Skip to main content

Open Invoices

The data model includes measures such as Amount Not Due, Due Amount, 1 - 30 Days, 31 - 60 Days, 61 - 90 Days, 91 + Days, Balance, and Invoice Total, reflecting various stages and totals of invoice amounts in terms of due dates and outstanding balances. The views, including Open Invoices By Company, By Customer, By Month, and By Salesperson, offer detailed perspectives on invoice statuses across different dimensions for comprehensive analysis of accounts receivable performance.

Benefits of This Data Model​

  • Enhanced Aging Analysis: Enables detailed tracking and analysis of invoice amounts across aging categories such as 1 - 30 Days, 31 - 60 Days, 61 - 90 Days, and 91 + Days, providing insights into payment timelines and outstanding balances.
  • Comprehensive Accounts Receivable Reporting: Offers a wide range of dimensions including Company, Customer, Salesperson, and AR Division, allowing for in-depth analysis and comparison of accounts receivable data from different perspectives.
  • Improved Cash Flow Management: Facilitates better cash flow projection by leveraging measures like Amount Not Due, Due Amount, and Balance, enabling organizations to forecast and manage cash flow based on current invoice statuses and payment schedules.

Key Performance Indicators (KPIs)​

  • Amount Not Due: Total amount of invoices that are not yet due for payment.
  • Due Amount: Total amount of all invoices that are currently due for payment.
  • 1 - 30 Days: Total amount of invoices due within 1 to 30 days from the current date.
  • 31 - 60 Days: Total amount of invoices due within 31 to 60 days from the current date.
  • 61 - 90 Days: Total amount of invoices due within 61 to 90 days from the current date.
  • 91 + Days: Total amount of invoices due 91 days or more from the current date.
  • Balance: Total outstanding balance of all invoices.
  • Invoice Total: Total amount of all invoices regardless of due date.

Available Visualizations​

View NameDescription
AR Gauge ViewProvides a visual representation of accounts receivable performance metrics.
Open Invoices By CompanyDisplays open invoices grouped by company, offering insights into outstanding payments per organization.
Open Invoices By Company WorksheetDetailed worksheet showing open invoices by company for in-depth analysis of payment status.
Open Invoices By CustomerShows open invoices categorized by customer, aiding in tracking outstanding balances for each client.
Open Invoices By Customer WorksheetWorksheet presenting open invoices by customer for thorough examination of payment status.
Open Invoices by MonthBreakdown of open invoices by month, facilitating analysis of payment trends over time.
Open Invoices by Month WorksheetDetailed worksheet displaying open invoices by month for comprehensive examination of payment patterns.
Open InvoicesSummary of all outstanding invoices, providing a holistic view of current accounts receivable.
Open InvoicesSummary of all outstanding invoices, providing a holistic view of current accounts receivable.
Open Invoices By SalespersonView showing open invoices allocated by salesperson, aiding in tracking individual sales performance.
Open Invoices By SalespersonView showing open invoices allocated by salesperson, aiding in tracking individual sales performance.
Cash Flow ProjectionOffers insights into projected cash flow based on open invoices and payment history.
Cash Flow RequirementsProvides analysis of cash flow requirements based on open invoices and payment timelines.
Customer Aging Balance for ReportGenerates a report showing aging balance for customers, assisting in monitoring overdue payments.