★★★★★160+This app is a game changer!Lesley

The Xero aged receivables report, with what to do next

Xero’s Aged Receivables Summary, or aged debtors report, shows who owes what. Paidnice adds how each customer pays, when the cash will land and who to call first.

The Xero aged receivables report, and Paidnice

Xero tells you what is owed. Paidnice adds what each customer is likely to do next.

  • The report lists what is owed, by age.A board of overdue invoices you can act on, by age.
  • It does not show how each customer usually pays.A credit score from 0 to 100 and average days to pay for every customer.
  • Xero’s forecast projects your bank balance.A weekly forecast of cash from each customer’s own payment pattern.

How to run the aged receivables report in Xero

Also called the aged debtors report. These are the steps for the summary; the detail report lists each invoice.

  1. Open Reporting and choose Aged Receivables Summary.
  2. Set the report date, the number of periods and the timeframe.
  3. Under Ageing By, choose Due Date or Invoice Date.
  4. Add columns such as Credit Limit and Available Credit, or group by contact group, then click Update.
  5. Save the layout as a custom report, or open a customer for the detail.

Note: the report covers approved invoices, credit notes and overpayments as at the report date. Days sales outstanding sits in Xero Analytics, not on this report.

Or let Paidnice run it
  1. Connect Xero
  2. See scores, the board and the forecast
  3. Act on the slowest payers first
Try it Free

Aged receivables from Xero, with the next step for each customer

Paidnice reads the same Xero invoices as the report and adds how each customer pays and what happens next.

Every overdue Xero invoice on one board

Invoices sit in Current, 1 to 30, 31 to 60, 61 to 90 and 90+ day columns, with counts and totals, and each card shows days until due or days overdue.

A score for how each customer pays you

Every customer starts at 100 and loses points for paying late and for what is overdue now, so the slowest payers are easy to find. It is never a bureau credit check.

When the cash is likely to land

Each invoice’s expected date is its due date plus that customer’s average days to pay, shown as weekly bars with a late bar for invoices already past it.

DSO, overdue and what runs next

Days sales outstanding, overdue and average days to pay sit beside the reminders, statements and late fees that run next, from your Xero data.

Your aging view in your inbox each Monday

Save any view, such as customers over 60 days, and email it as a CSV weekly or monthly to up to 10 people.

The accounts receivable toolkit for Xero

Every tool you need to get paid on time, running on your live Xero invoices. Connect once and switch on what you need.

Paidnice for Xero →AR insights and reports for every business →

Aged receivables in Xero: questions

Where is the aged receivables report in Xero?
In Reporting, as the Aged Receivables Summary and the Aged Receivables Detail. In the UK it is often called the aged debtors report. Paidnice reads the same invoices and adds a board, a credit score and a cash forecast.
What is the difference between the summary and the detail report?
The summary shows what each customer owes and how old it is. The detail report lists each invoice, credit note and overpayment behind those totals.
Does Xero show days sales outstanding?
Yes, in Xero Analytics. Paidnice shows DSO, overdue and average days to pay on its dashboard, next to the actions that run next.
Can I age the report by due date?
Yes. Xero ages by due date or invoice date. Paidnice’s aging board groups invoices as current, 1 to 30, 31 to 60, 61 to 90 and 90+ days.
Can I email the aged debtors report every week?
In Paidnice, any saved view can be emailed as a CSV weekly or monthly to up to 10 people.
Is the Paidnice credit score a credit check?
No. It is a 0 to 100 score from how each customer pays you. External credit checks are Creditsafe on the Custom plan.

A team that has your back

Talk to the people who build Paidnice. We help in every time zone and know collections inside out.

“The best service I have had from anyone in years. The product does exactly what it says.”

Anna H. on the Xero App Store
Denym from the Paidnice team, next to a support chat window
Xero

See what your Xero receivables will do next

Connect Xero and your scores, board and forecast are ready. Nothing is sent until you approve a policy.

Rated 5 stars, 160+ reviews · Xero App of the Year