Debtor Ageing Report Explained — What It Is & How to Use It

TL;DR: A debtor ageing report groups your unpaid invoices by how long they have been outstanding. It shows you who owes you money, how much, and how overdue each invoice is. It is one of the most important tools for managing cash flow and chasing payments effectively.

What Is a Debtor Ageing Report?

A debtor ageing report (also called an accounts receivable ageing report) is a summary of all the money owed to your business by customers, grouped by how many days each invoice has been outstanding. Most accounting software generates this report automatically.

The standard groupings are:

• Current — not yet due
• 1–30 days overdue
• 31–60 days overdue
• 61–90 days overdue
• 90+ days overdue

Why It Matters for Cash Flow

Your debtor ageing report tells you where your cash is stuck. If a large portion of your receivables are in the 60+ day columns, you have a collection problem that is directly affecting your working capital. The longer an invoice goes unpaid, the harder it becomes to collect.

Research consistently shows that the probability of collecting an invoice drops significantly after 90 days.

How to Use Your Debtor Ageing Report

1. Run it weekly — not monthly. Cash flow moves fast.
2. Prioritise the largest and oldest balances — focus your energy where it counts.
3. Identify repeat late payers — consider adjusting terms or requiring deposits.
4. Follow up consistently — a structured reminder process outperforms ad-hoc chasing.
5. Consider invoice finance for persistent gaps — if you consistently have large 30–60 day balances, Fundtap lets you access those funds immediately rather than waiting.

How to Generate a Debtor Ageing Report

In Xero: Go to Reports > Aged Receivables Summary or Detail.

In MYOB: Go to Reports > Receivables > Aged Receivables.

In QuickBooks: Go to Reports > Who owes you > Accounts receivable ageing summary.

When Your Debtor Book Is the Problem

If your debtor ageing report consistently shows large balances in the 30–60 day columns, you may not have a collection problem — you may have a cash flow timing problem. Your customers might pay reliably, just slowly. In this case, invoice finance lets you access the value of those invoices immediately without changing your payment terms or client relationships.

See how Fundtap invoice finance works →