Skip to main content

Open Invoices

The data model includes measures for different invoice aging categories (1-30 days, 31-60 days, 61-90 days, 91+ days), total invoice amount, current outstanding balance, and due amount. Views such as Open Invoices and Cash Flow Requirements provide insights into unpaid invoices, cash flow analysis, and forecasting based on outstanding amounts. The Open Invoice - Balance By Vendor Spline A 100% view breaks down outstanding balances by vendor, emphasizing payment due amounts.

Benefits of This Data Model​

  • Improved Cash Flow Analysis: The data model allows for in-depth analysis of cash flow requirements by providing insights into outstanding invoice amounts and payment timelines.
  • Vendor Payment Performance Monitoring: Enables monitoring of vendor payment performance by categorizing outstanding balances into aging categories and emphasizing payment due amounts.
  • Enhanced Forecasting Accuracy: Helps improve forecasting accuracy by providing visibility into unpaid invoices, cash flow analysis, and forecasting based on outstanding amounts.
  • Efficient Invoice Tracking: Facilitates efficient tracking of invoices across different aging categories and payment timelines, allowing for better management of outstanding balances.
  • Company-Wide Financial Insights: Provides company-wide financial insights by correlating data on invoice amounts, current outstanding balances, and due amounts with vendor and invoice details.

Key Performance Indicators (KPIs)​

  • 1 - 30 Days: Total amount of invoices that are due within 1 to 30 days from the current date.
  • 31 - 60 Days: Total amount of invoices that are overdue by 31 to 60 days.
  • 61 - 90 Days: Total amount of invoices that are overdue by 61 to 90 days.
  • 91 + Days: Total amount of invoices that are overdue by more than 90 days.
  • Invoice Amount: The total amount of all invoices in the system.
  • Balance: Current outstanding balance across all invoices.
  • Due Amount: The total amount of money that is currently due and payable to the company.

Available Visualizations​

View NameDescription
Open InvoicesDisplays outstanding invoices yet to be paid by customers.
Open InvoicesProvides visibility into unpaid invoices and potential cash flow issues.
Cash Flow RequirementsAnalyzes cash flow needs based on open invoices and payment timelines.
Cash Flow RequirementsHelps to forecast cash flow based on outstanding invoice amounts.
Open Invoice - Balance By Vendor Spline A 100%Breaks down outstanding balances by vendor, highlighting payment due amounts.