What it means
When you send an invoice to a customer, you expect to get paid within your agreed payment terms. However, payments often arrive late.
An aged debt analysis report gives you a clear picture of who owes you money and for how long. It sorts your unpaid customer invoices into columns based on their age.
This allows you and your team to quickly spot which accounts are falling behind. This tool matters because cash flow is the lifeblood of any organisation.
You can show strong profits on paper, but if your customers do not pay their bills, you will soon run out of cash to pay your staff and suppliers. By reviewing this report regularly, you can catch payment delays early before they turn into bad debts that you never recover.
In daily business practice, finance teams run this report weekly or monthly. It forms the backbone of credit control.
Instead of chasing every customer with equal urgency, staff use the report to focus on the oldest and largest debts first. It also helps managers spot patterns, such as a specific client who consistently pays sixty days late, allowing you to take corrective action.
Using this analysis helps you make better decisions about extending credit to new clients or continuing to work with slow payers. It transforms a messy pile of unpaid bills into an organised action plan, giving you total visibility over your incoming cash and protecting your financial health.
Think of unpaid customer bills like milk in your fridge. A fresh carton is fine, but as the days pass, it starts to sour.
An aged debt report is like checking the expiry dates on all your cartons so you know which ones to use immediately and which ones to throw away.
In practice
Real-world examples
Example 1
A freelance designer reviews her aged debt report and sees that a client is 45 days overdue on a $2,000 project invoice. She pauses further creative work for that client until the bill is settled, and she sends a firm reminder with a payment link the same day.
Example 2
A regional plumbing supply firm checks its monthly ledger and finds $15,000 sitting in the 90-plus days column across six trade accounts. The credit controller calls each account, agrees a payment plan with four of them, and moves the remaining two onto cash on delivery. Within six weeks, that column falls below $3,000.
Example 3
A software startup uses an automated aged debt tool to flag invoices reaching the 30-day mark, which triggers friendly reminder emails to corporate clients. The finance lead reviews the flags every Monday and asks an account manager to phone any client whose invoice reaches 60 days. Since introducing this routine, the team rarely lets an invoice pass the 60-day mark.
Think of it
Think of unpaid customer bills like milk in your fridge. A fresh carton is fine, but as the days pass, it starts to sour. An aged debt report is like checking the expiry dates on all your cartons so you know which ones to use immediately and which ones to throw away.
Formula
Calculation
Aged debt is a sorting exercise rather than a complex calculation, but it still rests on simple addition. Total Unpaid Debt = Current Invoices + 31-60 Days Overdue + 61-90 Days Overdue + 90+ Days Overdue, and each bucket can be expressed as a percentage of that total. For example, suppose a company has $10,000 of unpaid customer invoices: $6,000 current, $3,000 at 31-60 days overdue, and $1,000 over 90 days overdue. The total is $6,000 + $3,000 + $1,000 = $10,000, and the over-90 share is ($1,000 / $10,000) x 100 = 10%. That 10% signals that this slice needs urgent legal or collection action.Case study
Seen in the real world
This is a fictional, illustrative scenario. Brighton Bakery Supplies, a medium-sized distributor of commercial baking equipment, noticed their bank balance dwindling despite record sales. The finance manager pulled an aged debt analysis and discovered a shocking truth. Out of $120,000 in total outstanding customer invoices, nearly $50,000 sat in the 90 plus days overdue bracket. Several restaurant clients had simply stopped paying during a difficult trading season, and nobody had noticed because overall sales figures looked high.
Armed with this report, management changed their credit control procedures. They assigned a staff member to spend two hours every morning calling clients with debts older than 60 days. They also introduced stricter credit limits for new buyers and offered a 2% early payment discount. Within three months, the 90-day bucket shrank from $50,000 to $12,000. This injection of recovered cash allowed Brighton Bakery Supplies to pay off their own suppliers early, securing a valuable trade discount and stabilising their daily operations.
The company also used the report to review its own payment terms. Management noticed that most slow payers were on 60-day terms, so new restaurant accounts were moved to 30-day terms with a clear late payment clause. Six months later, the finance manager presented the aged debt analysis to the board every month as a standing agenda item.
Watch out
Common mistakes
- Waiting until month-end or year-end to look at who owes you money instead of checking weekly.
- Ignoring small overdue balances on the assumption that they are not worth the effort to chase.
- Failing to update invoice statuses when a customer makes a partial payment, skewing the report.
Questions
People also ask
How often should I look at my aged debt analysis?
For most small and medium businesses, reviewing the report on a weekly basis keeps cash flow steady and prevents issues from snowballing.
What is considered an acceptable amount of overdue debt?
Ideally, the vast majority of your debt should sit in the current column. Anything past 60 days should be a small fraction of your total.
Can accounting software generate this report automatically?
Yes, almost all modern cloud accounting packages generate an aged debtor report instantly with a single click.