Accountio / Templates / Debt recovery / Aged debtors report

Aged debtors report template (Excel) with chasing steps

List every unpaid invoice, see how long each one is overdue and know which reminder each customer should get next. This aged debtors report template is one Excel workbook with room for 300 invoices and 100 customers.

UK practices
$15
In the pack
Debt recovery pack
Files
5, Word and Excel
Buy the pack · $15
Global library · 110 packs

Get this pack and 109 more for $99

Debt recovery · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What the report looks like

Aged debtors report template
What the report showsSheet or column in the report
The date the report runs to
✓
Report dateToday, or the last day of the month
When each chasing step starts
✓
Polite reminder from, Firm reminder, Final notice, Letter before action fromDays after the due date, set to 1, 14, 28 and 42 to start with
One row for each unpaid or part-paid invoice
✓
Customer, Invoice number, Invoice date, Due date, Invoice amount, Paid so farCopied from your accounts system
What is still owed
✓
OutstandingInvoice amount less anything paid so far
How old each invoice is
✓
Days since invoice, Days overdueBoth counted to the report date
The ageing bucket
✓
AgeingNot yet due, 1-30 days, 31-60 days, 61-90 days or Over 90 days
Who to chase and how
✓
Next stepPolite reminder, Firm reminder, Final notice or Letter before action
Totals by bucket
✓
SummaryAmount, number of invoices and share of the total for each bucket, and the total overdue
Totals by customer
✓
SummaryEach customer split across the buckets, with their next step
Mistakes caught as you type
✓
Check, Settings checkMissing dates, a due date before the invoice date, payments above the invoice, customers left off the summary

When you need it

An aged debtors report lists the money customers owe, grouped by how long each invoice has been outstanding. It is the list credit control works from and the one reviewed at the month end and year end. Use this one when:

  • Your practice chases its own fees and wants one list of who owes what
  • You run credit control for a client whose system has no ageing report
  • You are checking debtors at the year end and need the overdue balances to review for bad debts
  • A board or owner wants to see overdue debt by customer each month

How to use the aged debtors report template

  1. Set the report date and steps. Enter the report date on the Invoices sheet and the number of days overdue at which each reminder goes out. Each step must be later than the one before.
  2. Enter the unpaid invoices. Customer, invoice number, invoice date, due date, amount and anything already paid. The grey columns fill in the rest.
  3. Clear the Check column. Every row should show OK. Fix any missing date or payment larger than the invoice.
  4. List each customer once on the Summary sheet. The sheet totals each one by bucket and warns you if an invoice is missing from the list.
  5. Chase in the order it shows. Start with the oldest balances. Run the report again each week or month and delete invoices once they are paid.

Questions

What is an aged debtors report?

A list of unpaid customer invoices, grouped by how long they have been outstanding: usually not yet due, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days. It shows who owes money, how much and how late it is.

How do you read an aged debtors report?

Look at the older buckets first. Money in the over 90 days column is the hardest to collect, and a customer moving from one bucket to the next each month without paying needs a firmer step.

Should invoices be aged from the invoice date or the due date?

Both are useful. This report shows days since the invoice and days overdue, and sorts each invoice into a bucket by days overdue, which is what decides the next reminder.

How often should you run an aged debtors report?

At least once a month, at the month end. A business with many customers on short terms often runs it weekly, so reminders go out on time.

When is an invoice overdue if no payment terms were agreed?

For business customers, 30 days after the customer receives the invoice, or after the goods or service are delivered if that is later. From then a business can claim statutory interest at 8% over the Bank of England base rate.

Also in the debt recovery pack

Chase lettersLetters before actionLate payment calculator

See the whole pack →

Who it's for

Accountancy practices chasing their own fees or running credit control for clients, and finance teams of small businesses.

Last checked

Checked against the Late Payment of Commercial Debts (Interest) Act 1998 and government guidance on late commercial payments in November 2026.