Skip to main content

Cash Receipts

The Cash Receipts data model tracks incoming cash payments and how they apply to outstanding invoices. It includes measures like cash amount applied and invoice balance to show how much cash has been applied against invoices and what remains outstanding. Use it to monitor cash flow patterns and track which invoices have been paid.

How to use this data model

  • Analyze cash receipt trends over recent periods to understand payment patterns and cash flow timing.
  • Monitor cash application to see how incoming payments are applied against outstanding invoices.
  • Track remaining balances after payment application to identify what's still owed and follow up on partial payments.
  • Reconcile accounts faster by reviewing cash receipts and invoice balances in one place.

Available views

ViewTypeWhat it shows
Cash Receipts Last 30 DaysWorksheetShows cash receipts from the last 30 days with applied amounts and remaining balances.
All Cash ReceiptsWorksheetLists all cash receipts with applied amounts and remaining balances for full payment history.