What it means
When you sell products or services on credit, you issue an invoice with a payment term, such as 30 days. However, customers often pay late.
An ageing report acts as a health check on your customer ledger by organising all money owed to you based on the age of the debt. It usually divides balances into columns representing current invoices and those overdue by 30, 60, 90, or more than 90 days.
This report matters because cash is the lifeblood of any organisation. Knowing who owes you money and for how long allows you to spot collection problems before they threaten your ability to pay your own staff and suppliers.
If an account is slipping into older categories, you can intervene immediately with a reminder or phone call. In daily practice, credit controllers and managers review this report weekly or monthly.
It dictates your collection strategy. Current and slightly overdue invoices might just need a polite email, whereas accounts lingering past 90 days may require formal legal letters or being written off as bad debt.
By monitoring trends in the report over time, you can also tighten your credit approval process for new clients. If certain industries or customer types consistently land in the older categories, you can adjust your payment terms to require deposits or shorter credit windows.
In practice
Real-world examples.
Example
A freelance designer checks their ageing report and sees a client is 45 days late on a project invoice. They immediately send a polite follow-up email requesting prompt payment.
Example
A small wholesale bakery reviews its monthly ageing report, noticing that three cafe accounts have shifted into the 90-days-overdue column, pausing further deliveries until they pay.
Example
An IT services firm uses an ageing report to spot that large enterprise clients consistently take 60 days to pay, prompting them to negotiate stricter payment terms in future contracts.
Think of it
“An ageing report is like a fridge inventory for a restaurant. It helps you see which food items are fresh and which ones are sitting at the back spoiling so you can use them before they go bad.
Formula
Calculation
Total Outstanding Debt = Current Invoices + 1 to 30 Days Overdue + 31 to 60 Days Overdue + 61 to 90 Days Overdue + Over 90 Days Overdue
Example: If a company has 5,000 pounds current, 2,000 pounds at 30 days, and 1,000 pounds at 90 days, the total outstanding debt is 8,000 pounds.Case study
Seen in the real world.
GreenLeaf Landscaping, a medium-sized commercial grounds maintenance firm, faced a cash crunch despite strong sales. The managing director asked the finance team to run an ageing report. The report revealed that while total money owed was high, over 40 percent of it sat in the 90-days-overdue bracket, mostly tied to two property management clients who kept promising to pay next week. Armed with this clear data, GreenLeaf stopped all non-emergency maintenance for those two clients and implemented a strict policy requiring a 50 percent upfront deposit for future work. They also assigned an office assistant to make weekly phone calls for any invoice past 30 days. Within two months, the ageing report showed a drastic shift. Overdue balances dropped by 60 percent, and GreenLeaf restored a healthy cash buffer in their bank account without needing a bank overdraft.
Watch out
Common mistakes.
- Ignoring the report until cash flow runs completely dry.
- Failing to update customer contact details, making debt collection difficult.
- Continuing to supply goods to customers who consistently sit in the over-90-days category.
Questions
People also ask.
How often should I review my ageing report?
You should review it at least monthly, though fast-growing businesses with many transactions benefit from a weekly check.
What should I do with debts in the over-90-days category?
You should step up collection efforts, consider using a debt collection agency, or write them off as bad debt if recovery is unlikely.
Does an ageing report include bills my company has to pay?
No, that is an accounts payable ageing report. A standard ageing report focuses on money owed to you by your customers.
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%Related