What Is Aging Report?
An aging report lists unpaid invoices grouped by how far past due they are, such as current, 1-30, 31-60, 61-90 and 90+ days, by customer.
Detailed Explanation
An accounts receivable aging report takes every open invoice on a chosen date and places its unpaid balance in a bucket based on days past the due date. Some reports age from the invoice date instead, so check which one you are reading. Totals by bucket show how much of what you are owed is late and how late; the customer breakdown shows who is responsible. It is the working list for collections: current balances need nothing, 1 to 30 days needs a reminder, and older buckets need calls, payment plans or escalation. The same format is used for accounts payable aging, which shows what you owe suppliers by age.
Example
On 30 June an invoice for $2,000 due on 10 June is 20 days past due, so it sits in 1-30 days. One for $900 due on 5 July is current. One for $1,200 due on 15 March is 107 days past due, in 90+.
Why It Matters
The older an invoice gets, the less likely it is to be paid. An aging report turns a vague sense of 'some clients are slow' into amounts and names you can act on this week.
Key facts
- Under IFRS 9, companies must hold a loss allowance equal to lifetime expected credit losses on trade receivables. The standard gives a provision matrix, which applies loss rates by how many days receivables are past due, as a practical example, so aging buckets feed the financial statements too.
- UK VAT bad debt relief cannot be claimed until a debt is at least 6 months past the later of the payment due date and the date of supply, so the over-180-days balance is the one to review for relief (HMRC VAT Notice 700/18).
- US: the IRS says to keep records for 7 years if you claim a bad debt deduction. Keep the aging history that shows when a debt became uncollectable.
- Read the aging date carefully. Aging from the due date shows lateness; aging from the invoice date mixes in your payment terms, so a net 60 invoice looks 'old' before it is due.
- InvoiceQuickly Pro reports include receivables aging by days past due, in five buckets (current, 1-30, 31-60, 61-90 and 90+ days), totalled separately for each currency. Invoices with no due date, or a due date today or later, count as current.
How it shows up in practice
Illustrative example: a UK cleaning company runs its aging report on 31 October. Of £26,400 owed, £17,200 is current, £5,100 is 1-30 days past due, £1,600 is 31-60 days and £2,500 is over 90 days, all of it from a gym that closed in April. The office manager emails reminders for the 1-30 day invoices, phones the two clients in 31-60 days and agrees a payment plan with one. The gym's invoice was due on 30 April, so by 31 October it is past the 6-month mark for VAT bad debt relief. The company writes it off and moves it to a bad debt account, then claims back the £416.67 of VAT included in the £2,500 on its next return.
Common mistakes
- Reading an aging report built from invoice dates as if it were built from due dates.
- Looking only at totals and not at which customers sit in the oldest buckets.
- Adding balances in different currencies into one total.
- Running the report monthly or less, so problems are spotted a month late.
- Leaving uncollectable invoices in 90+ days indefinitely instead of writing them off.
Frequently asked questions
What is an accounts payable aging report?
It is the same report for money your business owes. It lists unpaid supplier bills grouped by how many days they are past due, usually current, 1-30, 31-60, 61-90 and over 90 days, with a total for each supplier. Use it to plan payments, keep to suppliers' terms and spot overdue bills that may attract late fees. InvoiceQuickly tracks money owed to you, not supplier bills, so it has no accounts payable aging report.
What are the standard aging buckets?
Commonly current, 1-30, 31-60, 61-90 and over 90 days past due. Some businesses add 91-120 and 120+ for long-term debts. Use the same buckets every time so reports can be compared.
How often should I run an aging report?
Weekly if you have many invoices, and at least monthly. Run it before your collections calls and before each month end so you know what cash to expect.
What is the difference between an aging report and DSO?
An aging report shows the open balances and who owes them, by age. Days sales outstanding is a single number estimating how many days, on average, it takes to collect. Aging tells you what to do; DSO tracks whether you are improving.
Does InvoiceQuickly have an aging report?
Yes, on Pro. Reports show receivables aging by days past due in five buckets, with each currency totalled separately, alongside invoiced, collected, expense and time figures for any period.
Related Resources
- Accounts receivable: definition
- Days sales outstanding: definition
- Bad debt: definition
- Late payment guide
- Effective payment reminder emails
Last verified: 4 November 2026
Related Accounting Terms
Useful, occasional notes
Get invoicing tips that actually help
Join the InvoiceQuickly update list for practical invoicing advice and product news.
No spam, ever. Unsubscribe anytime.