What it means
A single receivables total tells you almost nothing useful. Knowing that customers owe $680,000 is very different from knowing whether that money is two weeks old or seven months old, and ageing is what turns one number into a picture.
It matters because collectability falls sharply with time. Invoices still within terms are almost always paid, while debt more than 90 days old has a materially lower chance of being collected, so the shape of the ageing profile drives both the cash forecast and the bad debt provision.
In practice the ageing schedule is produced monthly from the sales ledger and worked through line by line. Credit controllers chase the oldest and largest balances first, sales managers are shown their own customers, and finance uses the totals to set the allowance for doubtful debts.
The brackets themselves are a convention rather than a rule. A business selling on 60-day terms will set its brackets differently from one selling on 7-day terms, and many companies age from the invoice due date rather than the invoice date so that overdue genuinely means overdue.
Two nuances catch people out. A single large disputed invoice can distort the oldest bucket and make the whole book look worse than it is, and a customer who pays old invoices while letting new ones age can keep the totals flat while the underlying position quietly deteriorates.
In practice
Real-world examples.
Example
A wholesaler reviews its ageing report and finds one customer accounts for $90,000 of the over-90-day bracket. It suspends further credit to that account and moves the customer to payment in advance while the debt is negotiated.
Example
A staffing agency uses its ageing schedule to build a thirteen-week cash forecast. Balances in the current bracket are assumed to pay on time, while over-90-day balances are excluded from the forecast entirely.
Example
A manufacturer's bank lends against the sales ledger and refuses to advance funds on anything older than 90 days. The finance team therefore tracks the ageing profile weekly, since letting balances drift reduces the available borrowing directly.
Formula
Calculation
Estimated uncollectible amount = Sum of (Balance in each ageing bracket x Expected loss rate for that bracket)
Worked example: a business services company prepares its ageing schedule at the year end and applies loss rates drawn from its own collection history.
Current, 0 to 30 days: $400,000 x 1% = $4,000
31 to 60 days: $150,000 x 5% = $7,500
61 to 90 days: $80,000 x 15% = $12,000
Over 90 days: $50,000 x 40% = $20,000
Total receivables = $400,000 + $150,000 + $80,000 + $50,000 = $680,000.
Required allowance = $4,000 + $7,500 + $12,000 + $20,000 = $43,500.
That allowance is about 6.4% of the ledger, because $43,500 divided by $680,000 is 0.064. Note how the over-90-day bracket is only 7.4% of the balance yet contributes almost half of the estimated loss, which is exactly the insight a plain receivables total would have hidden.Case study
Seen in the real world.
The following is an illustrative example featuring a fictional business. Salter and Vane Print Services, an invented commercial printer, ran with total receivables of about $680,000 and assumed that everything would eventually arrive. Its first proper ageing schedule showed $50,000 sitting beyond 90 days, most of it owed by two customers who had been placing new orders throughout.
The company introduced three changes: statements issued on the same day each month, a rule that no new order ships to any account with a balance over 60 days without director approval, and a weekly review of the top ten oldest balances. Over the following six months the over-90-day bracket fell from $50,000 to $12,000 and average collection time shortened by eleven days, which released roughly $80,000 of cash without any increase in sales.
Watch out
Common mistakes.
- Ageing from the invoice date when the business sells on extended terms, which makes perfectly healthy accounts look overdue and hides the genuinely late ones.
- Chasing the oldest balance regardless of size, when the fastest cash gain usually comes from the largest overdue balances rather than the oldest small ones.
- Leaving disputed invoices sitting in the ageing report for months, so the schedule mixes genuine collection risk with unresolved paperwork.
Questions
People also ask.
What ageing brackets should I use?
Match them to your payment terms, so 30-day terms suit 30-day brackets, and always keep a separate bracket for anything beyond 90 days because that is where the real risk sits.
Can ageing be applied to what a business owes?
Yes, an aged payables report sorts supplier invoices by how long they have been outstanding and is used to plan payment runs and protect supplier relationships.
Does a clean ageing profile mean there is no bad debt risk?
Not entirely, because a single large customer in the current bracket can still fail suddenly, which is why concentration by customer matters alongside the ageing profile.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%