The aged receivables report lists every unpaid customer invoice, grouped by how long it has been outstanding. It is the single most useful report for getting paid, and it takes two minutes to read once you know what to look for.
What it shows
For each customer, the report shows what they owe you, split into age buckets:
- Current: not yet due.
- 1 to 30 days: recently overdue.
- 31 to 60 days: getting late.
- 61 to 90 days: seriously late.
- Over 90 days: at risk of becoming a bad debt.
How to read it
- Look at the totals first. A large share in the older buckets is a warning.
- Find the biggest debtors. A few customers often make up most of the overdue amount.
- Compare with last month. Is the overdue total growing or shrinking?
- Check for credit notes or part payments that may explain an odd balance.
Debtor days
Debtor days estimates how long customers take to pay you on average. A simple version is: receivables divided by sales, multiplied by the number of days. If your terms are 30 days and your debtor days are 55, customers are paying late. AvrioBooks shows debtor days among its analytics on the Premium plan.
What to do about each bucket
- Current: nothing, but send a reminder before the due date to the larger invoices.
- 1 to 30 days: a polite reminder.
- 31 to 60 days: a firm email, and a phone call.
- 61 to 90 days: stop further work or supply until it is paid, and warn about interest and compensation.
- Over 90 days: a final notice, and consider formal recovery or writing it off. See bad debts.
Use our late payment email templates for the wording.
Customer concentration
If one customer is a large share of your receivables, their late payment can hurt your whole business. Consider tighter terms, deposits or spreading your customer base.
A weekly routine
- Run the report every Monday.
- Send reminders for anything newly overdue.
- Phone the biggest late payers.
- Note promises to pay, and follow up on the date.
How AvrioBooks helps
The aged receivables and aged payables reports show what is owed to you and by you, and you can chase customers with reminders. See aged receivables and aged payables and invoicing software.
Frequently asked questions
What is an aged receivables report?
A list of unpaid customer invoices grouped by how long they have been outstanding, such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days.
What are debtor days?
An estimate of how long customers take to pay. A simple version is receivables divided by sales, multiplied by the number of days.
How often should I check it?
Weekly is a good habit, with reminders sent for anything newly overdue.
Does AvrioBooks have this report?
Yes. Aged receivables and aged payables are available in the reports.
Keep reading
What is double-entry bookkeeping? A plain-English guide
Every business transaction affects two accounts. Here is how double-entry works, with simple examples.
29 October 2026 · 7 min read
Bank feeds vs statement imports: which is better for a small business?
There are two ways to get bank data into your books. Neither is always better, so here is how to choose.
29 October 2026 · 6 min read
How to read a balance sheet: a small business guide
The balance sheet is a snapshot of the business on one day. Here is how to read it without an accounting degree.
28 October 2026 · 6 min read