The All Financial Activity / AR Aging report gives you a complete view of invoices, payments, and accounts receivable aging, and lets you choose the accounting style that fits your needs. It is located on the Accounting Summaries page of the Financials workbook.
Choosing your accounting basis
Use the basis toggle to switch between Cash and Accrual views of your financial activity. Cash reflects money when it is received; Accrual reflects revenue as it is earned. Pick the one that matches how your organization keeps its books.
Reading the AR aging buckets
Outstanding balances are broken into aging buckets: 0-30, 31-60, 61-90, and 91+ days. Use the date filter to set your reporting window, then read across the bucket columns to see how old each customer's outstanding balance is. This is the fastest way to spot overdue balances that need follow-up.
Tips
If your totals look different than expected, check the basis toggle first. Cash and Accrual can differ significantly for the same period, especially when payment plans or prepayments are involved.
Column Names and descriptions
Organization Name | Name of the organization the invoice belongs to. |
Paying User Name | The customer responsible for the invoice. |
Invoice Id | Unique identifier of the invoice. |
Day of Invoice Created At | The date the invoice was created. |
Invoice Due Date | The date the invoice is due; aging is measured from here. |
Invoice Amount | The total invoiced amount on the line items. |
Amount in Payment Plans | The portion of the balance scheduled under payment plans. |
Not Yet Due | Outstanding balance that has not reached its due date yet. |
Payment Total | Payments applied against the line items. |
0-30 | Outstanding balance 0 to 30 days past due. |
31-60 | Outstanding balance 31 to 60 days past due. |
61-90 | Outstanding balance 61 to 90 days past due. |
91+ | Outstanding balance more than 90 days past due. |
Total AR | The sum of the four aging buckets. |