Aging Report
The aging report lists unpaid customer invoices or pending expenses according to their age at a selected date. It helps you review receivables and payables by document and identify items that need follow-up.
Accessing the report
Go to Reports → Aging.
Receivables vs payables
Use the toggle at the top of the page to switch between:
- Receivables — sent or overdue customer invoices issued on or before the selected date. Sent invoices that are not yet due appear in Current.
- Payables — expenses with a Pending or Approved status dated on or before the selected date. The expense date is used as the due date.
Both views use the same bracket structure.
Paid, draft, cancelled, and rejected documents are not included.
Age brackets
| Bracket | Description |
|---|---|
| Current | Not overdue, including items due on the selected date |
| 1–30 days | Overdue by up to 30 days |
| 31–60 days | Overdue by 31–60 days |
| 61–90 days | Overdue by 61–90 days |
| 90+ days | Overdue by more than 90 days |
Brackets are colour-coded:
- Green — Current
- Yellow — 1–30 days
- Orange — 31–60 days
- Red — 61–90 days
- Dark red — 90+ days
Reading the report
Each row represents one invoice or expense, not a grouped contact total. The name is the related customer, supplier, or vendor. The table shows the document number, document date, due date, amount in its age bracket, and row total. The footer shows totals for every bracket and the grand total.
| Name | Document # | Date | Due date | Current | 1–30 d | 31–60 d | 61–90 d | 90+ d | Total |
|---|---|---|---|---|---|---|---|---|---|
| Müller AG | INV-1042 | 2026-08-01 | 2026-08-31 | — | 2,160.00 | — | — | — | 2,160.00 |
| Schmid GmbH | INV-1043 | 2026-08-15 | 2026-09-15 | 5,400.00 | — | — | — | — | 5,400.00 |
| Weber SA | EXP-217 | 2026-06-10 | 2026-06-10 | — | — | — | 1,080.00 | — | 1,080.00 |
The report does not expand rows or open documents when an amount is selected. Open the related invoice or expense from its normal module page for details.
As-of date
The report is calculated relative to an as-of date. The default is today. Choose another date and click Apply to review the position at a past date, such as the end of a fiscal year.
Available controls
The page currently provides two controls:
- Receivables / Payables — choose which document type to display
- As of Date — choose the calculation date, then click Apply
There are currently no contact, vendor, or minimum-amount filters.
Taking action on overdue items
The aging report is read-only. To follow up on a receivable, open the invoice from Invoices and use the available communication or reminder actions. See Payment Reminders for reminder levels, templates, and automation.
Exporting
Click Export (top right) and choose PDF or CSV.
- PDF — formatted aging report, suitable for a collections review meeting
- CSV — data for further analysis or import into another tool
Frequently asked questions
Why does an invoice show in "Current" even though the customer is a slow payer? An invoice in "Current" is not overdue at the selected as-of date. An invoice due on that date is also treated as current; it moves to "1–30 days" the day after its due date passes.
Can I see the aging report for a specific period in my fiscal year? Change the As of date to the end of the period you want to review.
How does a partial payment affect the aging report? The current aging calculation uses the full total of each included invoice; recorded payments are not deducted from the aging row. Check the invoice's payment history when you need the remaining balance.
My total receivables in the aging report do not match the balance sheet — why? The reports use different scopes and accounting rules. Aging includes only sent or overdue invoices as of its selected date, while the balance sheet reflects ledger balances. Compare the date, invoice status, payments, and credit notes when reconciling the two reports.