Skip to main content

Open AR Invoices

The Open Invoices data model tracks all unpaid invoices and their aging status on the accounts receivable side. It includes measures like amount not due, due amount, aging categories (1 to 30 days, 31 to 60 days, 61 to 90 days, 91+ days), balance, and invoice total. Use it to monitor outstanding receivables, review aging by customer or salesperson, and plan for upcoming cash flow.

How to use this data model​

  • Monitor aging balances across categories to see how much is current, slightly overdue, or significantly past due.
  • Review open invoices by customer to identify which accounts have the largest outstanding amounts.
  • Track receivables by salesperson to see how open invoices are distributed across the team.
  • Compare open invoices by company to understand outstanding balances across different entities.
  • Plan for cash flow by reviewing due amounts and payment timelines to forecast upcoming collections.

Available views​

ViewTypeWhat it shows
Open InvoicesWorksheetLists all outstanding invoices with amounts, aging, and balance details.
Open Invoices By SalespersonWorksheetBreaks down open invoices by salesperson with amounts and aging details.
Cash Flow ProjectionWorksheetShows projected incoming cash based on open invoice amounts and expected payment dates.
Open Invoices By CustomerWorksheetBreaks down open invoices by customer with amounts, aging, and balance details.
Open Invoices by MonthWorksheetBreaks down open invoices by month to show when outstanding amounts originated.
Customer Aging BalanceWorksheetShows aging balances by customer formatted for reporting, with amounts across each aging category.