Accounts Receivable Aging Template
Bucket unpaid invoices by age — 30, 60, 90+ days — and flag overdue accounts to chase, so nothing slips.
Prefer the spreadsheet? Accounts Receivable Aging Template · Invoice Tracker Template · Subcontractor Payment & Retention Template · WIP & Lock-Up Days Template · Rent Roll & Arrears Template — free with an account, 3 free downloads.
See inside before you download: Accounts Receivable Aging Template · Invoice Tracker Template · Subcontractor Payment & Retention Template · WIP & Lock-Up Days Template · Rent Roll & Arrears Template
| Customer | Current | 31–60 | 61–90 | 90+ |
|---|---|---|---|---|
| Northwind | £12,400 | £0 | £0 | £0 |
| Acme | £3,200 | £5,600 | £0 | £0 |
| Globex | £0 | £0 | £8,900 | £4,100 |
What's inside this template
How it works
It loads with realistic sample data so you see a finished result immediately — nothing to set up.
Type over the sample values, or upload your own file and map the columns in a couple of clicks.
The ageing tool recalculates instantly. Export to Excel or send a live link.
Related templates
Common questions
What are the standard ageing buckets?
Current, 1–30, 31–60, 61–90 and 90+ days past due. The 90+ bucket is the one that matters most — recovery rates fall steeply after three months.
What is DSO and how does it relate to ageing?
Days Sales Outstanding is the average time to get paid across all invoices. The ageing report is the detail behind it: DSO tells you there's a problem, ageing tells you which accounts are causing it.
When should I chase an overdue invoice?
The day it goes past due, then on a fixed cadence. Businesses that chase on a schedule collect materially faster than ones that chase when they notice — which is the actual argument for keeping this report current.
Start from the AR / invoice ageing template
Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.
Use this template free →