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.
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.
In practice
Real-world examples
Example 1
A freelance designer checks their ageing report and sees a $5,000 invoice sitting in the 60 days past due column. They immediately contact the client and discover the bill was sent to the wrong department. Payment arrives by the end of the week.
Example 2
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 the client's credit terms and offers a small discount for early payment. Within two months the client's invoices move back into the current column.
Example 3
An IT consultancy uses its ageing schedule to spot that a quarter of all outstanding debt is older than 90 days. It hires an external collections agency to recover the funds and tightens its vetting process for new corporate clients. The report now forms part of every monthly management meeting.
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 is a sorting method rather than a single equation. Each unpaid invoice is placed in a bucket by days past its due date, and the buckets add up to the receivables balance: Total Accounts Receivable = Current + 1-30 Days Overdue + 31-60 Days Overdue + 61-90 Days Overdue + Over 90 Days Overdue. The share of any bucket is Bucket Amount / Total Accounts Receivable x 100.
Worked example. A firm has $120,000 of unpaid customer invoices:
- Current: $72,000 (60% of the total)
- 1-30 days overdue: $24,000 (20%)
- 31-60 days overdue: $12,000 (10%)
- 61-90 days overdue: $6,000 (5%)
- Over 90 days overdue: $6,000 (5%)
Check: $72,000 + $24,000 + $12,000 + $6,000 + $6,000 = $120,000. The amount more than 60 days overdue is $6,000 + $6,000 = $12,000, which is $12,000 / $120,000 = 10% of receivables, and that is the slice the credit team should chase first.
Many finance teams also use the report to estimate likely losses by applying an assumed loss rate to each bucket. Using illustrative rates of 1%, 3%, 10%, 25% and 50%, the estimate is $72,000 x 1% = $720, plus $24,000 x 3% = $720, plus $12,000 x 10% = $1,200, plus $6,000 x 25% = $1,500, plus $6,000 x 50% = $3,000. The total is $7,140, or about 6% of the receivables balance.Case study
Seen in the real world
This is a fictional, illustrative scenario. 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 in outstanding customer debt. While $30,000 was current, a worrying $35,000 sat in the 60 to 90 days past due bracket, and $15,000 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 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.