Aged debt analysis is the practice of grouping your unpaid customer invoices by how long they have been outstanding, usually in 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 one lump sum of receivables into a layered picture of risk. The report it produces is often called an aged debtors report or aged receivables report.
The principle is simple: the longer an invoice goes unpaid, the less likely it is to ever be paid, and the more urgently it needs attention. Aged debt analysis makes that visible at a glance, so your collections effort lands where it matters instead of being spread evenly across a ledger.
Debt sorted by age.Unpaid invoices grouped into 30, 60 and 90 day buckets to show how overdue your money is.
Older means riskier.The further right a balance sits, the less likely it is to be collected in full.
It sets your priorities.The report tells your team which accounts to chase first and which to escalate.
An aged debtors report lists each customer down the side and the age buckets across the top, so you can see not just how much is overdue but exactly who owes it and for how long. Here is a worked example for a business owed 60,000 in total.
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Ltd | 12,000 | 0 | 0 | 0 | 0 | 12,000 |
| Bowen & Co | 6,000 | 8,000 | 0 | 0 | 0 | 14,000 |
| Crest Group | 0 | 4,000 | 9,000 | 0 | 0 | 13,000 |
| Delta Trades | 0 | 0 | 3,000 | 5,000 | 0 | 8,000 |
| Essex Supplies | 0 | 0 | 0 | 6,000 | 7,000 | 13,000 |
| Total | 18,000 | 12,000 | 12,000 | 11,000 | 7,000 | 60,000 |
Read across, then down. Of the 60,000 owed, 18,000 is current and healthy, while 42,000 is overdue and split across the buckets. Acme is no concern. Bowen and Crest need a standard chase. Delta and Essex are the worry: Essex alone has 7,000 sitting past 90 days, the balance most likely to turn into a write-off. Reading it this way turns a single 60,000 figure into a ranked action list. You can build the same report from your own ledger with the accounts receivable aging analysis calculator.
Each bucket represents 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 set them to match your terms. As a rule of thumb, the probability of collecting falls as debt ages: a current invoice is almost certain to be paid, while debt past 90 days is materially at risk.
No action beyond your normal reminders. These invoices are almost certain to be paid.
A polite nudge usually does it. Catch the slip early before it hardens.
Move to a phone call and a clear request for a payment date.
Pause further credit and consider a payment plan while the balance is still recoverable.
A candidate for final demand, an overdue escalation, or handing to collections. This is the band that feeds your bad debt provision.
Aged debt analysis and aging analysis are the same technique under different names: grouping receivables by age to assess risk and prioritise collection. The wording is regional. "Aged debt" and "aged debtors" are common in the UK, Australia and New Zealand, where customers who owe you are called debtors. "Aging analysis" and "aging schedule" are the more usual terms in the US. The buckets, the maths and the purpose are identical. If you want the mechanics under the US name, see aging analysis, and for the table format itself, the aging schedule.
The report is only useful if it drives action, so the point is to work it, not just file it. A handful of habits turn the aged debtors report from a monthly artefact into a collections engine.
Run it on a fixed rhythmMonthly at least, weekly if your volumes are high, and compare period to period rather than reading it once.
Watch the trend, not just the totalMoney migrating right, from current into the 30 and 60 day columns, means collections are falling behind even if the total looks stable.
Sort by the oldest bucketLet the highest-risk balances rise to the top, then chase by priority instead of working alphabetically.
Set clear escalation pointsFor example, anything past 60 days gets a call and anything past 90 a final notice, so nothing drifts.
Feed decisions upstreamA customer who lives in your late buckets is one whose credit terms or limit deserve a review before you extend more.
Most of this cadence is repetitive, which is why it rewards automation. AR reporting in Paidnice keeps the aged debt picture live and current, and automated reminders chase each bucket on schedule so balances are worked before they harden into bad debt.
Aged debt analysis is the standard basis for estimating bad debt, because the age of a debt is the best simple predictor of whether it will be paid. The common method 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.
Add the buckets up and you have a defensible bad debt provision grounded in the actual shape of your ledger rather than a flat guess. In the worked example above, you might reserve almost nothing against the 18,000 that is current but a large share of the 7,000 sitting past 90 days, because experience says that is the money least likely to arrive. This is why the report feeds straight into your accounts: it both drives collection and sizes the loss you should already be carrying.
Aged debt analysis is the difference between knowing you are owed money and knowing whether you are going to get it. A single receivables total hides everything that matters: a business owed 60,000 that is nearly all current is in fine shape, while one owed the same 60,000 mostly past 90 days is heading for a cash crunch and a write-off. The age profile is what tells the two apart.
It also gives you the earliest possible warning, because debt ages gradually and visibly, so a worsening aged debt report flags trouble weeks before it reaches the bank balance. For any business extending credit, it is the core report behind protecting cash flow, setting realistic bad debt provisions and deciding who to keep selling to on terms. Read and acted on regularly, it keeps the gap between invoice and payment short, which is the whole job of accounts receivable.
Don't let these critical mistakes hurt your
collections - See how to fix them, today!
Request an AI summary of Paidnice
