What it means
The report is normally laid out as a grid, with customers down the side and ageing buckets across the top: current, 1 to 30 days overdue, 31 to 60 days, 61 to 90 days and over 90 days. Each row shows how one customer's balance is spread across those columns, and the totals show the pattern for the whole business.
It matters because the shape of the report predicts cash and trouble long before either shows up in the profit figure. Money drifting rightwards into the older columns signals collection problems, customer disputes or a customer in financial difficulty, and the probability of collection falls sharply the further right a balance sits.
Operationally, the report drives the credit control routine. Balances in the early buckets get a polite reminder, the middle buckets get a phone call and a statement, and the oldest buckets trigger a stop on further supply, a formal demand or referral to a collection agency.
The same report also supports the accounting estimate for doubtful debts. Applying a rising percentage to each bucket produces an allowance that is far more defensible than a single flat percentage of total receivables, which is why auditors normally ask for the ageing report first.
The report is most useful when it is read alongside a second measure of collection speed. Days sales outstanding summarises the whole ledger in one number and is good for tracking a trend, while the ageing report shows exactly which customers and which invoices are creating that number.
One practical refinement is to split disputed invoices out of the ageing entirely. Genuine disputes need an operations or account management fix rather than a chasing call, and mixing them in with slow payers makes the report look worse than reality while hiding the accounts that really do need pressure.
In practice
Real-world examples.
Example
A wholesaler notices that one customer accounts for $210,000 of the over-90-day column. Supply is suspended pending a payment plan, and the customer clears $140,000 within three weeks rather than lose its main source of stock.
Example
A staffing agency reviews its ageing every Monday and finds that invoices sent without a purchase order number age roughly 25 days slower than the rest. It changes its billing process so no invoice leaves the building without one.
Example
An accountant preparing year-end statements uses the ageing report to justify a $47,000 doubtful debt allowance to the auditor. The bucket-by-bucket calculation is accepted without adjustment.
Formula
Calculation
Estimated Allowance = sum of (balance in each ageing bucket x expected loss rate for that bucket)
A commercial printing company has $500,000 of receivables at month end, split as follows: $300,000 current, $100,000 in the 31 to 60 day bucket, $60,000 in the 61 to 90 day bucket and $40,000 over 90 days. Those four amounts add back to $500,000.
Based on several years of collection history, the company applies loss rates of 1%, 5%, 15% and 40% respectively. That gives $300,000 x 1% = $3,000, $100,000 x 5% = $5,000, $60,000 x 15% = $9,000 and $40,000 x 40% = $16,000.
The total allowance is $3,000 + $5,000 + $9,000 + $16,000 = $33,000, which is 6.6% of the total receivables balance.Case study
Seen in the real world.
Ridgeport Signage is an illustrative and entirely fictional maker of shopfront signs. Its receivables balance had grown to $1,400,000 on revenue of $8,000,000, and the owner assumed the increase simply reflected growth.
The first proper ageing report told a different story. Only $520,000 was current, while $380,000 was 61 to 90 days old and $290,000 had been outstanding for more than 90 days, most of it concentrated in four customers. Two of those customers were disputing installation work rather than refusing to pay, which nobody in finance had known.
Ridgeport assigned a credit controller to the four accounts, resolved the two disputes with credit notes totalling $64,000, and introduced weekly ageing reviews. Within five months the over-90-day column fell to $85,000 and the company cancelled a planned overdraft increase.
Watch out
Common mistakes.
- Producing the ageing report for the auditor once a year rather than using it weekly as an operational collection tool.
- Ageing invoices from the invoice date when the agreed terms actually start from delivery or statement date, which makes every bucket misleading.
- Focusing only on the largest overdue balances while ignoring a long tail of small aged invoices that adds up to real money.
Questions
People also ask.
What buckets should be used?
Current plus 30-day intervals is the standard, though businesses with 60 or 90-day terms should align the buckets with their own terms.
Does an old balance always mean a bad customer?
No, a surprising share of aged debt is caused by disputes, missing purchase order references or invoices sent to the wrong contact.
How does the report link to the accounts?
It supports the allowance for doubtful debts, and its total should reconcile exactly to the receivables figure in the general ledger.
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%