Last updated: December 2025
An accounts receivable aging report shows you exactly where your money is stuck, and which invoices need urgent attention before they become uncollectable.
UK businesses are owed an average of £21,000 in late invoices. Without a clear view of what's overdue and for how long, you're flying blind on cash flow. This guide shows you how to create, read, and act on AR aging reports, plus a free template to get started.
Want to see your AR health at a glance? Try our free AR Health Calculator.
What Is an Accounts Receivable Aging Report?
An accounts receivable aging report (also called an aged debtors report) categorises your unpaid invoices by how long they've been outstanding. Instead of seeing receivables as one lump sum, you see them broken into time buckets:
- Current: Not yet due
- 1-30 days overdue
- 31-60 days overdue
- 61-90 days overdue
- 90+ days overdue
This simple breakdown transforms raw invoice data into actionable intelligence. At a glance, you can see which customers pay on time, which consistently pay late, and which accounts need immediate attention.
Why AR Aging Reports Matter
Cash Flow Visibility
You can't manage what you can't see. AR aging reports show not just how much you're owed, but when that money is likely to arrive. If 30% of your receivables consistently age beyond 60 days, you can plan accordingly rather than being blindsided by cash shortages.
The 90-Day Danger Zone
Here's the statistic that should worry every business owner: once an invoice hits 90 days overdue, you'll statistically only recover 70p on the pound. After six months, collection probability drops below 50%.
Collection Probability by Age
| Invoice Age | Collection Probability | Action Required |
|---|---|---|
| Current | 98% | Standard reminder before due date |
| 1-30 days overdue | 95% | Automated email reminders |
| 31-60 days overdue | 85% | Phone call + escalation |
| 61-90 days overdue | 73% | Payment plan or formal demand |
| 90+ days overdue | 70% (drops to <50% at 6 months) | Legal action or debt collection |
This is why the 61-90 day bucket is your "red zone." Invoices in this bracket need escalation, phone calls, payment plans, or formal demand letters, while there's still time to collect.
Bad Debt Prevention
AR aging reports serve as an early warning system. When a previously reliable customer's invoices suddenly start aging, that's a red flag for potential financial distress. Early identification allows intervention before amounts become unrecoverable.
Free AR Aging Report Template
Download our free Excel template to start tracking your aged debtors today:
→ Download Free AR Aging Template (Excel)
The template includes:
- Automatic aging calculations
- Customer summary view
- Separate retention tracking (for construction)
- Late payment interest calculator
- Visual dashboard
How to Create an AR Aging Report
Step 1: Gather Your Data
List all outstanding invoices with:
- Customer name
- Invoice number
- Invoice date
- Due date
- Original amount
- Payments received
- Balance remaining
Step 2: Calculate Invoice Age
For each invoice, calculate the number of days since the due date (or invoice date, depending on your preference). Be consistent, mixing methods creates confusion.
Step 3: Assign to Aging Buckets
Sort each invoice into the appropriate bucket:
- Current (not yet due)
- 1-30 days past due
- 31-60 days past due
- 61-90 days past due
- 90+ days past due
Step 4: Summarise by Customer
Group invoices by customer to see total exposure. A customer with multiple aging invoices presents higher risk than one late invoice.
Step 5: Add Totals and Percentages
Calculate total amounts in each bucket and percentages of total receivables. These summary statistics reveal your overall AR health at a glance.
The Construction Twist: Handling Retentions
If you're in construction, standard AR aging templates will mislead you.
Here's why: Construction contracts typically hold back 5-10% of each payment as retention until project completion (or 12 months after). This retention money isn't "overdue", it's contractually held.
If you don't separate retentions from standard aging, your report will look artificially bad. £50,000 in legitimate retentions will show as "90+ days overdue" when it's actually not due yet.
Solution: Add a separate "Retention Held" column to your aging report. This shows:
- Current Due: Money you can chase now
- Retention Held: Money due at project completion
- True Overdue: Actual late payments needing attention
Our free template includes this separation built in.
For more strategies specific to construction, see our guide on how to reduce DSO in UK construction.
Tracking Retention Release Dates
Retentions often get "forgotten" after project completion. Set up a system to:
- Track all retention amounts and release dates
- Set calendar reminders 30 days before release
- Submit release applications promptly at practical completion
- Follow up if retention isn't released within 30 days of due date
Reading Your AR Aging Report: Warning Signs
Red Flags to Watch
Concentration risk: If one customer represents more than 20% of your receivables, their late payment could cripple your cash flow.
Growing 90+ bucket: If your over-90-day receivables increase month over month, your collection process needs immediate attention.
Sudden aging from reliable customers: When a customer with a strong payment history suddenly has aging invoices, investigate immediately. It often signals financial distress.
Pattern recognition: Do certain industries, salespeople, or project types consistently show poor payment? The pattern reveals where to focus process improvements.
Healthy vs. Unhealthy Aging
Healthy vs Unhealthy AR Distribution
| Aging Bucket | Healthy % | Warning % | Critical % |
|---|---|---|---|
| Current | 70%+ | 50-70% | <50% |
| 1-30 days | <20% | 20-30% | >30% |
| 31-60 days | <7% | 7-15% | >15% |
| 61-90 days | <3% | 3-8% | >8% |
| 90+ days | <5% | 5-10% | >10% |
If more than 15% of your receivables are over 60 days, you have a collection problem that needs addressing.
Using AR Aging Reports for Collection Prioritisation
Not all overdue invoices deserve equal attention. Use aging data to prioritise:
High Priority (Action Within 48 Hours)
- Large invoices approaching 90 days
- Previously reliable customers now aging
- Invoices with disputed items unresolved
Medium Priority (Action This Week)
- Invoices in the 31-60 day bucket
- Customers with multiple aging invoices
- Accounts near credit limit
Lower Priority (Automated Reminders)
- Invoices 1-30 days overdue
- Small balances
- Customers with consistent payment patterns (they'll pay at day 35 as always)
Know Your Rights: UK Late Payment Law
The Late Payment of Commercial Debts (Interest) Act 1998 gives you powerful tools to recover late B2B payments. Consider adding an "Accrued Interest" column to your aging report, seeing this potential revenue motivates faster chasing.
Statutory Interest
You can legally charge 8% above Bank of England base rate on late commercial debts. As of December 2025, that's approximately 13% annual interest.
Fixed Recovery Costs
You can also claim fixed compensation:
- £40 for debts up to £999.99
- £70 for debts £1,000 to £9,999.99
- £100 for debts £10,000+
Pro tip: Include these rights in your payment terms. Even if you don't charge interest, referencing statutory rights in collection letters often accelerates payment.
Common AR Aging Mistakes
Ignoring Small Balances
Small invoices accumulate. Ten £500 invoices at 90+ days is £5,000 you're unlikely to recover. Track everything.
Inconsistent Aging Calculations
Some businesses age from invoice date, others from due date. Either works, but mixing methods makes reports meaningless. Pick one and stick to it.
Creating Reports But Not Acting
Beautiful reports that sit unread are worthless. Establish clear responsibilities: who reviews the report, how often, and what actions trigger at each aging threshold.
Not Separating Disputes
Disputed invoices shouldn't be treated the same as simply unpaid invoices. Add a "Dispute Status" column to avoid chasing customers for amounts they've legitimately queried.
Automating Your AR Aging Reports
Manual spreadsheets work for very small businesses, but they're error-prone and time-consuming. As invoice volumes grow, manual tracking becomes a "paper-heavy nightmare."
Modern AR automation platforms like Equisettle integrate with Xero, QuickBooks, and FreeAgent to:
- Generate live aging reports automatically
- Separate retentions from standard aging
- Predict which invoices are likely to age (before they're overdue)
- Trigger automated chasers based on aging thresholds
- Track disputes and resolutions
The result: real-time visibility without manual data entry, and collection workflows that run themselves. See how Wulfjoy automated their AR process.
Compare your options in our guide to the best AR software for UK businesses.
Frequently Asked Questions
What does DSO mean?
DSO stands for Days Sales Outstanding, the average number of days it takes to collect payment after invoicing. Calculate it as: (Accounts Receivable ÷ Total Credit Sales) × Number of Days. A lower DSO means faster collections. UK construction companies average 83 days; top performers achieve 45-60 days. Learn more in our guide to reducing DSO in construction.
How often should I review AR aging reports?
Weekly reviews catch issues early. Collection teams might review daily for work prioritisation, while management reviews weekly summaries. Monthly trending analysis shows whether collection performance is improving or declining.
What's the difference between an AR aging report and an aged debtors report?
They're the same thing. "Accounts receivable aging report" is the American term; "aged debtors report" is more common in the UK. Both categorise unpaid invoices by how long they've been outstanding.
What percentage of receivables over 90 days is acceptable?
Aim for less than 5% of total receivables in the 90+ day bucket. If you're above 10%, you have a serious collection problem. Above 15% threatens business viability.
Should I age from invoice date or due date?
Either method works, the key is consistency. Aging from due date is more intuitive (0 days = just became overdue), while aging from invoice date accounts for different payment terms across customers. Most businesses age from due date.
The Bottom Line
AR aging reports transform reactive "chasing invoices when you need cash" into proactive credit management. The key insights:
- The 90-day cliff is real, invoices over 90 days recover only 70p on the pound
- Construction businesses must separate retentions or reports will mislead
- Healthy AR has less than 15% in the 60+ day buckets
- UK law lets you charge 8% + base rate on late B2B payments
- Automation eliminates manual errors and ensures consistent follow-up
Start with our free template, review weekly, and take action on what the data shows.
Stop Creating Spreadsheets Manually
Equisettle integrates with your accounting software to generate live AR aging reports automatically. See which invoices are at risk of going overdue, before they do, and automate collection workflows based on aging thresholds.
See how Wulfjoy transformed their collections, then try it yourself:
Start your free 14-day trial →

