For accountants.
Ask the client for one aged-debtors export, clean it into this template, then review the overdue invoices together.
Use this free template to structure overdue B2B invoice rows for a bookkeeper, accountant, finance manager, or credit-control owner. You can use the sample in the free health check before importing your own file.
| Column | Use | Example |
|---|---|---|
| customer_name | Names the debtor in letters and emails. | Acme Supplies Ltd |
| customer_email | Identifies the customer email to check before sending. | accounts@example.com |
| invoice_number | Identifies the debt being chased. | INV-1042 |
| invoice_date | Supports the timeline in the letter. | 2026-03-01 |
| due_date | Used for days-overdue and interest calculations. | 2026-03-31 |
| amount_due | Outstanding principal to calculate from. | 1800.00 |
| notes | Optional reviewer context. | Reminder sent 15 May |
Ask the client for one aged-debtors export, clean it into this template, then review the overdue invoices together.
Standardise messy debtor lists before deciding which invoices need a polite reminder or final notice.
Keep invoice references, due dates, balances and customer details consistent so you can check them before preparing reminders.
Run the free health check to see ageing bands, overdue totals, estimated statutory interest, and priority actions before importing into your workspace.
Run free health check