Growing overdue balances in Xero: how to see who is slipping and set an alert

Contents▾

Xero's Aged Receivables report shows what each customer owes you today. It has no view of whether that balance is larger than last month, and Xero raises no internal alert when an overdue balance crosses a threshold.

Direction has to be worked out by comparing two runs of the report, and the alert has to come from a connected app. If what you need is a nudge on the first day an account goes overdue, see the alert for the first overdue day.

This page is about the slower problem: the customer who was overdue last month and owes more this month, and the threshold that tells you so.

Why the Aged Receivables report cannot show direction

The Aged Receivables report shows one date only. It has no column for what a customer owed last month or how old their oldest invoice was then, so direction has to be worked out by comparing two runs by hand.

Xero's Aged Receivables Summary report shows the amount each customer owes and how long it has been outstanding, and the Detail report lists it invoice by invoice. You can choose the ageing periods, age by due date or invoice date, add columns such as Credit Limit, group by Contact Group or tracking category, save it as a custom report and export to PDF, Excel or Google Sheets.

Xero does not email a report on a schedule, compare a customer's balance with an earlier date, show days-to-pay on a contact record, or alert anyone inside the business when an account goes overdue or crosses a threshold. The request for automatic report emailing holds 780 votes on Xero's product ideas board and sits at "In discovery", with Xero's latest reply dated 25 May 2026 (checked 3 September 2026).

The nearest request to a comparison view asks to run the report for one date and view what was still outstanding at another. It holds 35 votes and is marked Completed, because Xero's reply of 9 July 2024 notes that the newer Aged Detail reports let you set the report date to any date.

That is a manual as-at date: run the report for 31 July and again for 31 August, then compare the two yourself, which is the weekly spreadsheet that keeping a Xero debtors report current without rebuilding it in Excel each week is about. A separate request to add Days Overdue to the contact record holds 91 votes, Submitted since 15 August 2023, with Xero's last activity on 9 October 2023.

What Xero's credit limit does and does not do

A Xero credit limit is a cap on a customer's unpaid invoices. In new invoicing it shows a banner when the contact reaches the limit and blocks an invoice that would exceed it. It sends no email and it ignores how late the balance is.

Both active parts live in new invoicing: a banner when a contact has reached their limit, and a block on sending or approving an invoice that would take them over it (a repeat invoice set to send automatically goes to drafts instead). Xero's own framing is that you see the limit is exceeded when you add the contact to a new invoice.

The check runs when you raise an invoice, so a customer you are not currently invoicing can sit past due for months without a banner appearing. The limit counts unpaid invoices, so a customer well inside it can be 60 days late on all of them; hovering over the contact shows what the customer owes and the overdue part of it, which is as close as Xero gets.

Two requests on the product ideas board ask for more. Automatic credit hold or stop holds 93 votes, Submitted since 5 December 2012; Xero's reply of 8 February 2024 called it "not something we have plans to develop at this time". Blocking new invoices while others are overdue holds 18 votes; Xero's reply of 22 May 2023 suggested a credit limit as one way to do it today.

A connected app closes the first of those. A Paidnice escalation can trigger when a customer's total balance passes their credit limit and raise a Stop Credit task for the account owner, which is the automatic credit hold the 2012 request asks for.

Every request on this page, as at 3 September 2026:

Three signals that a balance is getting worse

A balance is getting worse when the oldest overdue invoice is older than it was, the average days to pay is longer than it was, or a payment-history score is lower than it was. The overdue total on its own shows none of that.

The overdue total is the least useful of the four figures because it can stay flat while everything behind it moves. A customer who always pays 30 days late and a customer who used to pay on the day and has just stopped can show the same total on the Summary report.

The first signal is the age of the oldest overdue invoice. The Detail report gives it to you for today, invoice by invoice; last month's figure is a second run. When it climbs from 20 days to 45 on a flat total, the customer has stopped clearing their oldest invoice first, usually the earliest sign of a cash problem at their end.

The second is average days to pay. Xero reports an organisation-wide average time to get paid in Business Snapshot, worked out from average receivables and sales over the period. There is no per-customer version on the contact record, so a customer drifting from 35 days to 50 stays invisible.

The third is a payment-history score: a number from 1 to 100 built from how the customer has paid over time, which falls as invoices are paid later. Nothing on the Xero contact record plays this role.

How Paidnice shows which customers are slipping

Paidnice connects to Xero and shows, against every contact wherever it appears in the app, the overdue balance, the oldest overdue age and the average days to pay, next to a payment-history score from 1 to 100 that moves as the customer's behaviour changes.

The dashboard shows the same figures for the whole ledger (Overdue, Days Sales Overdue, Average Overdue Age, on-time payment percentage, average days to pay, trend views), and two widgets do the sorting: slowest payers puts the customers who take longest to pay at the top, and oldest invoices lists the invoices that have waited longest.

To watch a set of customers over time, put them in a group, which shows their combined payer data, and save the contact view you check each week. A saved view reopens to show how the headline metrics have moved, which is the job the second spreadsheet tab was doing.

The Aged Receivables by Contact report shows the same picture in ageing buckets (1 to 30, 31 to 60, 61 to 90 and 90+ days) with outstanding and overdue totals and unpaid counts, across entities and currencies, and it exports. The Weekly Report, an opt-in email per user per organisation, summarises the receivables each week.

Invoices and contacts export to CSV, and a custom report builder is in beta. The three report types, the dashboard, the contact cards and the export are covered on the accounts receivable reporting page.

What Xero reports on its own and what a connected app adds is set out in credit control reporting in Xero. If several people share the watch list, how a team tracks overdue Xero invoices together covers roles, seats and one shared view.

How Paidnice raises an internal alert at a threshold

A Paidnice escalation policy raises an internal task when an invoice reaches an amount and age you set, such as £2,000 at 14 days overdue. A policy can also trigger on the customer's total balance, including when the balance passes a credit limit, which is the alert Xero's own limit does not send.

The policy attaches to a group of contacts, with filters for Minimum and Maximum Due Amount, a due-date window, Contact Tag and Xero Group Name. The task type is Phone Call, Stop Credit or Template Legal Letter. Paidnice emails the instructions to an address you nominate, lists them on the Escalations page, and sends whoever is assigned the escalation an Assignment notification.

Five overdue invoices of £900 each never cross a £2,000 per-invoice minimum, so a customer who owes £4,500 in small invoices needs the total-balance trigger rather than the per-invoice one. Set the per-invoice minimum with your typical invoice size in mind, and attach the policy to a group holding only the customers you are watching.

1. Connect Xero. Invoices, contacts and payments sync across. Signing up is free, the first 20 actions are free, no card needed.
2. Create a group for the customers you want to watch, or use the Default Group that holds everyone, and add contacts by search or filter.
3. Add an escalation policy to the group: set the days overdue and a Minimum Due Amount per invoice (and a Maximum for a band), or a total balance or credit limit for the customer, and choose Phone Call, Stop Credit or Template Legal Letter.
4. Nominate the address that receives the instructions and assign an owner, who gets an Assignment notification when the task lands.
5. On Pro, add a webhook so every completed or failed action, and every escalation completed or cancelled, posts into Slack, Microsoft Teams, Discord, Telegram or WhatsApp. Paidnice sets the incoming webhook up.

Notes and call outcomes from the task sync to the invoice in Xero, and an @mention in a note notifies the person named. If your terms allow a late fee, attach a late fee policy to the same group: an invoice that costs money to ignore moves up the customer's payment run.

Tiering the customer-facing reminders by what is owed is a separate job, covered in how to tier Xero invoice reminders by overdue balance. Splitting them by department at one customer is in Xero invoice reminders for different departments.

Customers cut their average wait for payment in half, within 30 days. The escalation types, and the group and policy model behind them, are on the Paidnice escalations page.

Common questions

Does Xero send reminders for overdue invoices?
Yes. Xero's invoice reminders email the customer on the schedule you set, up to five reminders, for every invoice marked as sent. They go to the customer. Nobody inside your business is notified.

How do I switch Xero reminders off for one customer?
Turn the feature off for the organisation, or stop reminders going out to certain customers or for specific invoices, such as a part-paid invoice or one you have already spoken to the customer about.

How do I write an email reminder for an overdue invoice?
Hi Sam, invoice 2041 for £1,240 was due on 12 August and is 14 days overdue. Can you tell me when it is scheduled for payment? A copy is attached with a link to pay online. If it is already paid or in query, reply here and I will sort it out.

How do I send a payment reminder to my customer?
In Xero, turn on invoice reminders and the customer is emailed on the schedule you set. Paidnice sends reminders from your own domain, with timing and wording set per customer group, and can move to a senior sender as the debt ages.

Will Xero tell me when an overdue balance passes a set figure?
No. Xero Central documents no internal notification for an overdue balance or a threshold. The credit limit shows a banner and blocks an invoice in new invoicing, only when you raise one. An alert to your team needs a connected app: Paidnice raises a task when an invoice, or the customer's total balance, passes the figure you set, including a credit limit.

Does a Xero credit limit stop a customer going overdue?
No. It caps what a customer can have unpaid before Xero blocks a new invoice in new invoicing. A customer under the limit can still be months overdue, and the limit does not change when they are.