Aging analysis is the practice of sorting your unpaid customer invoices by how long they have been outstanding, usually into 30, 60 and 90 day buckets, so you can see how much you are owed, how overdue it is, and which accounts to chase first. It turns a single receivables total into a layered view of risk. The report it produces is called an aging report or aging schedule, and in the US it is the standard way finance teams keep on top of accounts receivable.
The logic is simple and reliable: the longer an invoice goes unpaid, the less likely it is ever to be paid. Aging analysis makes that visible, so your collections effort goes where the risk is instead of being spread evenly across the ledger. Without it, a healthy receivables balance and a dangerous one look identical on the books.
Receivables sorted by age.Unpaid invoices grouped into current, 30, 60 and 90 day buckets to show how overdue your money is.
Older means riskier.The further right a balance sits, the lower the odds you collect it in full.
It ranks your collections.The report tells your team which accounts to chase first and which to escalate.
Group every open invoice by how far past its due date it is, total each bucket, then list customers so the oldest balances stand out. An aging report puts customers down the side and age buckets across the top, so you see not just how much is overdue but who owes it and for how long. Here is a worked example for a business owed 80,000.
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Inc | 15,000 | 0 | 0 | 0 | 0 | 15,000 |
| Brightline | 8,000 | 10,000 | 0 | 0 | 0 | 18,000 |
| Cedar Co | 0 | 5,000 | 11,000 | 0 | 0 | 16,000 |
| Dunmore LLC | 0 | 0 | 4,000 | 7,000 | 0 | 11,000 |
| Easton Supply | 0 | 0 | 0 | 8,000 | 12,000 | 20,000 |
| Total | 23,000 | 15,000 | 15,000 | 15,000 | 12,000 | 80,000 |
Read across each customer, then down to the totals. Of the 80,000 owed, only 23,000 is current; the other 57,000 is overdue and spread across the buckets. Acme is no concern. Brightline and Cedar need a routine chase. Dunmore and Easton are the worry: Easton alone has 12,000 sitting past 90 days, the balance most likely to become a write-off. Reading it this way turns one 80,000 figure into a ranked to-do list. You can build the same report from your own ledger with the accounts receivable aging analysis calculator.
Each bucket is a band of how overdue an invoice is, and each carries a different level of risk and a different response. The standard bands are current, 1 to 30 days, 31 to 60, 61 to 90, and over 90, though you can adjust them to fit your terms. The probability of collecting falls as a balance moves right: a current invoice is almost certain to be paid, while debt past 90 days is materially at risk.
Almost certain to be paid; needs only your normal reminders.
A polite reminder usually does the job at this stage.
Time for a more direct message and a phone call.
Step up the chase, hold further credit, and consider a payment plan.
A candidate for a final demand, a step up in your overdue receivables response, or handing to collections. This is the band that drives your bad debt provision.
Aging analysis and aged debt analysis are the same technique under different names: grouping receivables by age to assess risk and prioritize collection. The difference is purely regional. "Aging analysis," "aging report," and "aging schedule" are the usual terms in the US. "Aged debt analysis" and "aged debtors report" are common in the UK, Australia, and New Zealand, where customers who owe you are called debtors. The buckets, the math, and the purpose are identical. For the same method under the Commonwealth name, see aged debt analysis, and for the table format on its own, the aging schedule.
Aging analysis is the standard basis for estimating bad debt, because the age of a receivable is the best simple predictor of whether it will be paid. The common approach applies a rising percentage to each bucket: a small allowance against current and early-overdue balances, a larger one against 60 and 90 day debt, and a high percentage against anything over 90 days. Total the buckets and you have a defensible provision grounded in the real shape of your ledger rather than a flat guess. In the example above, you would reserve almost nothing against the 23,000 that is current, but a large share of the 12,000 sitting past 90 days, because experience says that is the money least likely to arrive. This is why the same report both drives collection and sizes the loss you should already be carrying.
Aging analysis is the difference between knowing you are owed money and knowing whether you will actually get it. A receivables total hides everything that matters: a business owed 80,000 that is nearly all current is in good shape, while one owed the same 80,000 mostly past 90 days is heading for a cash crunch. The age profile is what tells them apart, and it gives you the earliest possible warning, because debt ages gradually and visibly. A worsening aging report flags trouble weeks before it shows up in the bank balance.
Run it on a regular rhythm, monthly at least, compare it period to period, and watch for balances drifting right from current into the older buckets. That trend is the real signal. Acted on consistently, with steady follow-up on each bucket, aging analysis keeps the gap between invoice and payment short, which is the whole job of accounts receivable. Tools like AR reporting in Paidnice keep the picture live so you act on it rather than just filing it.
The report is only as useful as the discipline around it, and a few mistakes recur. Each one quietly blunts a report that should be driving action.
Treating it as a record, not a triggerRunning the report, glancing at the total, and chasing no one. Every overdue bucket should map to a defined next step.
Aging by invoice date, not due dateThis makes everything look more overdue than it is and muddies your read on real risk. Always age from the due date.
Reading the report in isolationLooking at one period hides the trend. Always compare to last period to catch balances drifting right before they harden.
Leaving the ledger unreconciledStale credits, unallocated payments and disputed items inflate the overdue figure. Reconcile first, then trust the report.
Don't let these critical mistakes hurt your
collections - See how to fix them, today!
Request an AI summary of Paidnice
