Account receivable aging
Who owes you money right now — and where does that balance come from? This report lists your open receivables per customer. It has two views (switch with the buttons above the table); both answer the same "who owes me" question with the same calculation:
- By invoice month (default): one column group per calendar month of the invoice date. An unpaid invoice counts in the month it was issued — a receivable arises at issue, whether or not it is due yet.
- By overdue age: the classic aging buckets (not yet due, under 30/60/90/ 120/180 days, older) measured from the invoice's due date.
The columns (By invoice month view)
Each calendar month carries three numbers for every customer:
| Number | Meaning |
|---|---|
| Issued | Total of that month's invoices that are still open. |
| Paid | How much of those invoices has been paid or credit-noted to date. |
| Open | The still-unpaid balance — this is the receivable. |
The last three groups summarize: Other months (open invoices issued outside the selected months), Selected months (the visible columns), and Total (all months) — everything that customer owes you. The Open figures of all months always add up to the Total.
The Months filter picks which months get their own columns (shortcuts: last 3/6/12 months, this year, last year, all time — or any custom month range). Narrowing the months never changes the Total column, so a filtered view can never be mistaken for the whole receivable.
Click any amount to see the invoices behind it.
The columns (By overdue age view)
Each open invoice's remaining amount is placed into exactly one column, based on how far the invoice's due date has passed today:
| Column | Invoices whose due date is… |
|---|---|
| Not yet due | …still in the future. |
| Less than 30 / 60 / 90 / 120 / 180 days | …1–30, 31–60, 61–90, 91–120 or 121–180 days past. |
| Older | …more than 180 days past. |
| Total | The sum of all buckets — everything that customer owes you. |
The bottom row totals each column over all customers.
What is counted
- Invoices that are still open — their total minus the payments and credit notes recorded on them to date. Advance payments count as payments here, and an invoice fully covered by a credit note no longer appears.
- A partly paid invoice is included with its remaining amount.
- Draft, cancelled and deleted invoices are left out, and so are invoices that were merged into another invoice.
- Invoices issued in a foreign currency are converted to your own currency.
Account receivable aging vs. Account receivable — what is the difference?
The Reports menu has two similarly named reports. They use the same calculation and the same buckets — the only difference is the reference date the aging is measured from:
| Account receivable aging (this report) | Account receivable | |
|---|---|---|
| Question it answers | What do customers owe me right now, split by invoice month or overdue age? | What did customers owe me on a chosen date? |
| Aging measured from | Always today. | A date you choose — e.g. last month-end. |
| Payments & credit notes | Everything recorded to date. | Only the ones dated on or before the chosen date. |
| Best for | Everyday monitoring and collections work. | Month-end or year-end snapshots. |
Because both reports use the same calculation, choosing today's date in Account receivable gives exactly the same numbers as this report — same customers, same totals.
Good to know
- Click any amount to see the invoices behind it: a popup lists each invoice with its number, dates, total, paid amount, credit notes and the remaining balance — plus a VAT breakdown per VAT rate and account, and totals for the whole bucket. The invoice number opens the invoice PDF in a new tab.
- Customer names are links: click one to jump to that customer's invoice view and see the invoices behind the number.
- Use the customer filter to produce the report for a single customer.
- The result table can be searched, printed and exported (copy, CSV, Excel, PDF) from the buttons above the table.
Related pages
- Account receivable by date — the same calculation for a chosen past date.
- Reports guide & catalog — every report in one place.