What it means
Imagine running a business where you deliver a service or product today, but your customers pay you thirty days later. Not everyone pays on time.
Accounts Receivable Ageing takes all your unpaid customer invoices and sorts them into neat categories based on age, such as current, 1 to 30 days past due, 31 to 60 days past due, and over 90 days past due. This matters because money tied up in unpaid invoices is not sitting in your bank account, which can quickly cause cash flow shortages.
If you cannot pay your staff or suppliers because your clients are slow to pay, your business is in trouble even if your sales look great on paper. In daily practice, business owners and finance teams review this report weekly or monthly.
It acts as an early warning system. If an invoice creeps into the 60 or 90 day buckets, it signals that you need to take action, such as making a phone call, sending a firmer reminder, or pausing future work for that client.
Ultimately, this report gives you a clear picture of your credit risk. It shows you which customers are reliable payers and which ones constantly drag their feet, helping you make better decisions about who to offer credit to in the future.
In practice
Real-world examples.
Example
A freelance designer checks their ageing report and sees a 5,000 pound invoice sitting in the 60 days past due column. They immediately contact the client, discovering the bill was sent to the wrong department, and secure payment by the end of the week.
Example
A small manufacturing firm reviews its monthly ageing report and notices a recurring retail client consistently paying at 45 days instead of the agreed 30 days. The manager adjusts their credit terms and offers a small discount for early payments.
Example
An IT consultancy uses their ageing schedule to spot that a quarter of all outstanding debt is older than 90 days. They hire an external collections agency to recover the funds and update their vetting process for new corporate clients.
Think of it
“Think of unpaid customer invoices like milk in your fridge. A fresh bottle is fine, but as the days pass, it starts to sour. An ageing report is like a label on each bottle telling you exactly how old it is, so you know which ones to use immediately before they go completely bad.
Formula
Calculation
Ageing categorisation does not use a single mathematical equation, but rather a sorting method. Total Accounts Receivable = Current Invoices + 1-30 Days Overdue + 31-60 Days Overdue + 61-90 Days Overdue + 90+ Days Overdue. For example, if a firm has 10,000 pounds total, it might break down as: 6,000 pounds current, 2,000 pounds at 30 days, 1,000 pounds at 60 days, and 1,000 pounds at 90+ days.Case study
Seen in the real world.
Oakwood Supplies, a mid-sized commercial cleaning provider, experienced a tight cash crunch despite hitting record sales targets. The business director decided to review the monthly Accounts Receivable Ageing report for the first time in six months. The report revealed a total of 80,000 pounds in outstanding customer debt. While 30,000 pounds was current, a worrying 35,000 pounds sat in the 60 to 90 days past due bracket, and 15,000 pounds was over 90 days overdue. Oakwood had been delivering services without checking if previous bills were settled. Armed with this data, the credit control team immediately contacted the accounts departments of the slow-paying clients. They discovered that several invoices had been forgotten or disputed over minor delivery details. By clarifying these issues and setting up automated payment reminders, Oakwood successfully collected 40,000 pounds within thirty days. The ageing report transformed their cash flow, allowing them to pay off supplier debts and fund new equipment purchases without taking out a bank loan.
Watch out
Common mistakes.
- Waiting until the end of the quarter to look at the report instead of checking it weekly.
- Ignoring small overdue amounts that add up to a significant cash flow drain over time.
- Failing to follow up promptly with clients whose invoices have just crossed into the overdue category.
Questions
People also ask.
How often should I look at my Accounts Receivable Ageing report?
You should review it at least once a month, though weekly reviews are better for businesses with high transaction volumes and tight cash flow.
What is considered a dangerous age for an unpaid invoice?
Any invoice older than 60 days past its due date starts to lose collectability rapidly. Anything past 90 days has a significantly lower chance of ever being paid.
Does this report tell me my profit?
No. This report only tracks cash that is owed to you by customers. It does not reflect your expenses, taxes, or actual net profit.
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