An aging report turns a list of open invoices into a short list of customers to call.
Start with a list of open invoices showing customer, invoice date, due date and outstanding amount. Calculate days overdue against the report date, assign each invoice to a bucket such as current, 1-30, 31-60, 61-90 and over 90 days, then summarise by customer with a pivot table. Agree the total to the receivables control account before using it.
Export open (unpaid or part-paid) invoices from your accounting system, one row per invoice:
Put the report date in a cell named ReportDate, usually the month-end date.
F: days overdue (zero or negative means not yet due)
=ReportDate-D2
G: bucket
=IF(F2<=0,"Current",IF(F2<=30,"1-30",IF(F2<=60,"31-60",IF(F2<=90,"61-90","90+"))))
Age by due date, not invoice date. Aging by invoice date makes customers on longer terms look late when they aren't.
Insert a pivot table with customer in rows, bucket in columns and the sum of outstanding amount in values. Sort by the 90+ column, then by 61-90. Add a percentage-of-total row so you can see the shape of the ledger at a glance. If you prefer formulas, a SUMIFS grid does the same:
=SUMIFS($E:$E,$A:$A,$J2,$G:$G,K$1)
with customers listed down column J and bucket names across row 1.
Save each month's summary and track the percentage in each bucket over time. A rising share in 31-60 days is an early warning that will turn into a 90+ problem if nobody acts. Combine it with DSO and best-possible DSO for a fuller picture of collection performance.
UK teams usually call this the "aged debtors report"; US teams say "AR aging report". The method is identical. Decide whether amounts include VAT or sales tax and keep it consistent with the ledger.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
Due date, for collection work, because it shows what is actually overdue. Some teams also show aging by invoice date for provisioning, but label it clearly.
Current, 1-30, 31-60, 61-90 and over 90 days overdue is the most common set. Use buckets that match your payment terms and provision policy.
Usually because of unapplied cash, manual journals to the control account, or a report date that differs from the period end.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.