Aged debtors in Xero: how to run the Aged Receivables report, read it and use it for credit control
Manoj Tutika · Published 17 November 2026 · Last checked 17 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
What is the aged debtors report in Xero?
An aged debtors report lists what customers owe you and how long each amount has been outstanding, split into age bands. Xero names it Aged Receivables and offers it in two forms. The Summary shows one row per customer with the total in each band. The Detail lists every open invoice, credit note and overpayment behind those totals.
The report shows the position as at the report date. An invoice that was unpaid on 31 October appears on a report dated 31 October even if the customer paid on 3 November. That is what makes it usable for month-end and for comparing one month with the next.
How to run the Aged Receivables report
- In the Reporting menu, select All reports.
- Open Aged Receivables Summary, or Aged Receivables Detail. The search field in the top right finds them quickly.
- Choose the date, or a preset such as End of last month.
- Under Ageing By, choose Due Date or Invoice Date.
- Under Ageing Periods, set how many bands you want and how long each is.
- Click Update.
From the Summary you can click a customer to see their approved, sent and paid transactions, or click an amount to open the Detail behind it. Access needs the administrator, standard with reports, sales and purchases, sales or viewer role.
Due date or invoice date?
This one setting changes what the report means.
| Ageing by due date | Ageing by invoice date | |
|---|---|---|
| Puts each amount in the band for | When it fell due | When you raised it |
| Current column holds | Amounts not yet due | Nothing, unless you tick Include report date in Current column |
| Answers the question | How overdue is each customer? | How old is each invoice? |
| Best for | Credit control and chasing | Comparing customers on different terms, bad debt reviews |
For chasing, age by due date. A 60-day invoice raised seven weeks ago is not late, and ageing by invoice date would make it look as if it were.
Settings worth changing
- Columns lets you add the contact account number and, if you use them, credit limits. The Summary also has a Customer credit limits format that shows each limit next to the available credit.
- Percentage of total, under More, adds a row showing what share of the total sits in each band.
- Grouping and summarising works by contact group or tracking category, which is useful when sales teams own different customers.
- The Detail report can show an Expected Date column, taken from the expected payment date you add to an invoice, and an Invoice Seen column showing whether the customer opened the online invoice.
Save the layout as a custom report so you run the same view each month without setting it up again.
How to read the report, with a worked example
A UK distributor runs the Summary at 31 October 2026, aged by due date, with 30-day bands.
| Customer | Not yet due | 1–30 days overdue | 31–60 days | 61–90 days | Over 90 days | Total |
|---|---|---|---|---|---|---|
| Atlas Fitout | £12,400 | £3,600 | £0 | £0 | £0 | £16,000 |
| Brook & Hale | £0 | £0 | £8,250 | £0 | £0 | £8,250 |
| Calder Logistics | £5,100 | £2,900 | £0 | £1,750 | £0 | £9,750 |
| Dunmore Studio | £0 | £0 | £0 | £0 | £4,320 | £4,320 |
| Elm Street Dental | £2,200 | −£480 | £0 | £0 | £0 | £1,720 |
| Total | £19,700 | £6,020 | £8,250 | £1,750 | £4,320 | £40,040 |
Of £40,040 owed, £20,340 is overdue, just over half. The bands tell you what to do with each customer.
- Dunmore Studio, £4,320 over 90 days, needs a phone call today, and a decision on whether to stop supply or move to a formal demand. See the letter before action template.
- Brook & Hale has one invoice in the 31–60 band and nothing else open. That pattern usually means a dispute or a lost invoice, not a cash problem. Ask before you chase hard.
- Calder Logistics pays most invoices but has £1,750 at 61–90 days. Open the Detail. An old invoice left behind among newer paid ones is often a short payment or a query.
- Elm Street Dental shows a credit of £480 in the overdue band. That is an unallocated credit note or overpayment. Apply it before you chase, or the customer will rightly point out you owe them.
- Atlas Fitout is mostly not yet due. A friendly reminder on the £3,600 is enough.
If credit sales for the last 90 days were £120,000, days sales outstanding is £40,040 divided by £120,000, times 90, which is 30.0 days. How to track that figure and bring it down is in DSO: how to calculate and reduce it.
Check the total against the balance sheet
The aged receivables total and the Accounts Receivable line on the balance sheet describe the same money, so run both at the same date and compare. In a clean file they should agree. The reasons this matters, and how the sales ledger sits under the control account, are in accounts receivable vs sales ledger.
If they do not agree, look at the dates first: both reports must be run as at the same day. Then check for a payment dated before its invoice, which Xero notes can reduce the aged total when the report period does not include the invoice. If you invoice in foreign currencies, remember the report shows outstanding amounts in your base currency, with the exchange rate details available next to each amount.
Turn the report into a chase list
In the UK, if no payment date was agreed, a business payment is late 30 days after the customer receives the invoice, or after delivery if that is later. Agreed terms between businesses should normally be no more than 60 days. From the day an invoice is late you can claim statutory interest and a fixed sum for debt recovery; the calculation is in Late Payment Act interest.
A simple monthly routine works for most small businesses.
- Run the Summary aged by due date at month-end and save it.
- Apply open credit notes and overpayments before contacting anyone.
- Sort by the oldest band and work down: call the over-90 customers, email the 31–60 group, and let automated reminders handle the 1–30 group.
- Add an expected payment date and a note to each invoice where the customer has promised a date, so the Detail shows it next month.
- Compare the total and the overdue percentage with last month.
Xero's own invoice reminders cover the routine part. You can have up to five reminders, before or after the due date, and switch them off for single invoices or customers you are already talking to.
Where an agent helps
The report tells you who to chase; it does not do the chasing, read the replies or notice when a promised date passes. Thred runs a credit control agent on Xero that works from the same open items, sends reminders in your tone, logs promises to pay as expected dates and escalates the accounts that stop answering. The open items it works from are the same ones this report shows.
Frequently asked questions
How do I run an aged debtors report in Xero?
In the Reporting menu, select All reports and open Aged Receivables Summary or Aged Receivables Detail. Choose the report date, select Due Date under Ageing By, set the ageing periods and click Update.
What is the difference between Aged Receivables Summary and Detail in Xero?
The Summary shows one line per customer with the amount in each age band. The Detail lists every outstanding invoice, credit note and overpayment, with columns such as due date, expected date and whether the customer has seen the online invoice.
Should I age debtors by due date or invoice date?
By due date for credit control, because it shows how overdue each customer is against their terms. By invoice date when you want to compare the age of invoices regardless of terms, for example in a bad debt review.
Why does aged receivables not match the balance sheet in Xero?
Start by running both reports at the same date. Then check for payments dated before their invoice, which can reduce the aged total, and for foreign currency balances, which the aged report shows in your base currency.
Does the Xero aged receivables report include credit notes?
Yes. The total includes approved outstanding invoices, credit notes and overpayments as at the report date, so unallocated credits reduce what the report shows a customer owes.
Sources
- Xero Central, Aged Receivables Summary report
- Xero Central, Aged Receivables Detail report
- Xero Central, Add an expected payment date to an unpaid invoice
- Xero Central, How invoice reminders work
- Xero Central, Apply a customer's credit to an invoice
- GOV.UK, Late commercial payments: when a payment becomes late
Read next
- Chasing unpaid invoices: email templates that work
- Late Payment Act interest: how to calculate and claim it
- Accounts receivable vs sales ledger: the ledgers explained, with control accounts and a £ worked example
- Days sales outstanding (DSO)
- Credit control for Xero: how AI agents chase overdue invoices
Where Thred comes in
For finance leaders who want more capacity without more headcount.
