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.
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.
In practice
Real-world examples
Example 1
A freelance designer checks her ageing report and sees that a client is 45 days late on a $2,500 project invoice. She sends a polite follow-up email with the invoice attached and asks the client to confirm a payment date. She also adds a reminder to recheck the account in one week. If nothing has arrived by then, she will phone the client directly.
Example 2
A small wholesale bakery reviews its monthly ageing report and notices that three cafe accounts have moved into the over-90-days column. The owner pauses deliveries to those cafes until the balances are cleared. She agrees a repayment schedule with the cafe that owes the most. The other two cafes switch to paying on delivery.
Example 3
An IT services firm uses its ageing report to spot that large enterprise clients consistently take 60 days to pay, while smaller clients pay within 30. The finance team negotiates 45-day payment terms with enterprise clients at the next contract renewal. It also adds a milestone billing schedule for large projects, so cash arrives as work is delivered. The change is expected to shorten the company's average collection period.
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 current, $2,000 at 30 days, and $1,000 at 90 days, the total outstanding debt is $8,000. The over-90-days share is ($1,000 / $8,000) x 100 = 12.5%, which is the figure to watch each month.Case study
Seen in the real world
This is a fictional, illustrative scenario. 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, 40% 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 required a 50% upfront deposit for future work. It also assigned an office assistant to make weekly phone calls for any invoice past 30 days. The assistant logged every call, so the managing director could see which clients responded. Within two months, overdue balances had dropped by 60%, and GreenLeaf rebuilt its cash buffer without needing a bank overdraft.
The report also changed how the managing director ran the business. He made it a standing item at the monthly management meeting, with each overdue account given a named owner and a follow-up date. Any balance past 90 days now needs sign-off before the company agrees to further work for that client. The team now treats collections as part of sales rather than an afterthought.
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.