How to Read Your Xero Aged Debtors Report (and Get Paid Faster)

Xero calls it the Aged Receivables Summary. It's the one report that tells you who owes you money and how late they are. Here's where to find it, the three settings to change, how to read each column and what to do about every overdue invoice.

Korda Team

9 min read
Dark banner tagged Finance, headed “What Your Xero Aged Debtors Report Is Actually Telling You (and What to Do About It)”.
In this article

Aged debtors, aged receivables: same report

Accountants in Australia often say "aged debtors". Xero calls the same report "Aged Receivables". Both mean money your customers owe you for invoices you've sent. There are two versions:

  • Aged Receivables Summary: one line per customer, with their total split across the ageing columns. Start here.
  • Aged Receivables Detail: every unpaid invoice, credit note and overpayment behind those totals. Click any amount on the Summary to open it.

How to run the aged debtors report in Xero

  1. In the Reporting menu, select All reports.
  2. Find Aged Receivables Summary. The search box in the top right corner is the quickest way.
  3. Set the date to today. (The arrow next to the date also offers presets like End of last month.)
  4. Change the three settings below, then click Update.
  5. Click Save as custom so the settings are there next week.

You need the administrator, standard + reports, sales and purchases, sales or viewer role in Xero to see it. If your bookkeeper set up your Xero, check you have one of those. New to Xero? Our Xero setup guide for tradies covers the rest.

The three settings that make it useful for a trade business

1. Ageing By: Due Date

This is the setting that matters most. Ageing by Due Date puts each invoice in a column based on how late it is. Ageing by Invoice Date puts it in a column based on how old it is. For chasing money you want the first: a 3-week-old invoice on 30-day terms isn't late, but a 3-week-old invoice on 7-day terms is two weeks overdue.

2. Ageing Periods that match your terms

Xero ages by month unless you change it. If you invoice on 7 or 14-day terms, a month is too long to wait before an invoice looks late. Set shorter periods under Ageing Periods so the report flags slow payers while they're still easy to chase. Tick Include report date in Current column so invoices due today don't look overdue.

3. Percentage of total

Under More, turn on Percentage of total. It adds a row showing what share of the money owed sits in each column. That one number tells you more about your cash flow than the total does.

A worked example: a two-person plumbing business

Here's an Aged Receivables Summary for a plumbing business on 14-day terms, run on a Monday morning and aged by due date. (Your column names will match the ageing periods you choose.)

Customer Current < 1 month 1 month 2 months 3 months + Total
Harbour View Strata $3,850$3,850
J. Nguyen (bathroom final) $6,600$6,600
Coastal Property Mgmt $1,240$980$720$2,940
D. Morris (hot water) $1,980$1,980
Kellerman Builders $2,400$2,400
Total $5,090$7,580$2,700$2,400$0$17,770
% of total 28.6%42.7%15.2%13.5%0%100%

What it's telling you:

  • 71% of what's owed is overdue. $12,680 of $17,770 is past its due date. That's the headline number to bring down.
  • One invoice is most of the problem. The $6,600 bathroom final has only just slipped past due. It's the biggest amount and the easiest to collect today, so it gets a reminder this morning.
  • One customer pays late every time. Coastal Property Management has money in three columns. That's a pattern, not a slip. Call their accounts team and ask what they need to pay on time (an order number, a different email address, a set payment run).
  • One needs a phone call. D. Morris is a month overdue on $1,980. An email has already been ignored, so call.
  • One needs a firm conversation. Kellerman Builders is two months overdue. Ask for a payment date in writing. If you're a subcontractor, check your contract and your state's security of payment laws before you go further.

Harbour View Strata isn't due yet. Leave it.

What to do about each column

Column (aged by due date) What it usually means What to do
Current Not due yetNothing. For large invoices, a friendly reminder a few days before the due date helps.
Less than 1 month overdue Forgotten, busy or waiting on a pay runA polite reminder with the invoice and a way to pay attached. Most invoices are paid at this stage.
1 month overdue Not a priority for them, or a question about the invoiceCall. Ask if anything is holding it up, and agree a payment date.
2 months overdue Cash problem or a disputeGet a payment date or a payment plan in writing. Check your contract terms.
3 months or older At real riskCall and agree a payment date or plan in writing. If that fails, follow the business.gov.au steps below. Talk to your accountant about anything you may need to write off.

Need the words for each stage? Our late payment scripts and templates cover the email, the text and the phone call.

Debtor days: the one number to track

Debtor days tells you how long, on average, it takes customers to pay you. It's worth more than the total owing, because the total goes up when you're busy even if everyone pays on time.

For the plumbing business above: $17,770 owing, $64,000 invoiced over the last 90 days. ($17,770 ÷ $64,000) × 90 = about 25 days.

On 14-day terms, that means customers are taking around 11 days longer than they should. For comparison, Xero Small Business Insights found Australian small businesses waited 22.9 days on average to be paid in the June 2026 quarter, about 6 days after the due date. Work your number out once a month. If it's rising, the chasing isn't keeping up.

Want to see what that wait costs you? Try the cash gap calculator, or read what late invoicing really costs.

The two-minute Monday routine

  1. Open your saved Aged Receivables Summary and click Update.
  2. Look at the percentage overdue. Is it higher or lower than last week?
  3. Send a reminder for anything that has just moved past Current.
  4. Call anyone with money in the 1 month column or further right.
  5. Note any promised payment dates, and check them next Monday.
Two minutes checked weekly against two hours left for a month.

Monday morning works because you can chase before the week fills up. What matters is doing it every week. If you only see this report when your accountant sends it each quarter, the easy conversations have already turned into hard ones.

Weekly marked with a tick and a row of evenly spaced dots, against quarterly marked with a cross and a single dot at the far end.

When an invoice still won't get paid

The Australian Government's business.gov.au sets out the steps in order:

  1. Check your contract or agreement for the due date and payment terms.
  2. Send a reminder and try to agree a new date or a payment plan.
  3. Get advice on formal options, for example from your state's small business commissioner.
  4. Get dispute resolution help, for example through the Australian Small Business and Family Enterprise Ombudsman's dispute support tool.
  5. Use a debt collection agency, following the ACCC's debt collection guidelines.
  6. Take legal action, such as a small claims tribunal.

Most tradies never need the later steps if the first two happen on time. That's what the weekly routine is for.

What Xero's own invoice reminders do (and don't)

Xero has built-in invoice reminders. Turn them on under Sales > Invoices > Invoice Reminders. You can set up to five emails, before or after the due date, and they go to every customer with an invoice marked as sent. For many businesses that's enough, and it's worth switching on today.

Where tradies tend to need more:

  • They're email only. A text gets read on site; an email often doesn't.
  • The same reminders go to every customer. A one-off homeowner and a property manager on a monthly pay run get the same wording.
  • They only start once an invoice exists. Nothing follows up the quote that was never accepted.
  • You still have to open the aged receivables report to see where things stand.

Korda Pro was built for that gap. It chases overdue invoices by email and SMS in your name, with a Pay Now link, and stops when the money lands. It follows up open quotes too. A 7am Morning Brief tells you what's been paid, what's owed and what's overdue, so you don't have to run the report at all. It syncs both ways with Xero, so the aged receivables report stays accurate for your accountant. See automatic payment reminders and how Korda Pro works with Xero.

Frequently asked questions

Where is the aged debtors report in Xero?

Go to Reporting > All reports and open Aged Receivables Summary. Click any amount to see the Aged Receivables Detail report for that customer.

What's the difference between aged debtors and aged receivables?

Nothing. "Aged debtors" is the term many Australian accountants use; "Aged Receivables" is Xero's name for the same report.

Should I age by due date or invoice date?

Due date, if you're using the report to chase payments. It shows how late each invoice is. Invoice date shows how old it is, which matters less.

Why does an invoice that's been paid still show on the report?

The report shows what was outstanding on the report date. If you ran it for an earlier date, or the payment hasn't been reconciled in Xero yet, a paid invoice can still appear. Run it for today and check your bank reconciliation is up to date.

How often should a tradie check the aged debtors report?

Weekly. It takes about two minutes when you do it every week, and chasing early is much easier than chasing late.

What is a good debtor days number?

Close to your payment terms. If you invoice on 14-day terms, aim for under 20 debtor days. Xero's data shows Australian small businesses waited 22.9 days on average to be paid in the June 2026 quarter.

Can Xero email me the aged receivables report automatically?

Not at the moment. Xero doesn't send scheduled report emails, so you need to run it yourself. Saving it as a custom report keeps your settings, so it only takes a click.

What should I do with an invoice that's more than 90 days overdue?

Call them and agree a payment date or plan in writing. If that fails, follow the business.gov.au steps: dispute resolution, a debt collector or a small claims tribunal. Talk to your accountant about whether any of it needs to be written off.