Show the number of days overdue on each statement line
A customer who can see “45 days overdue” next to an invoice knows what to pay first. Xero’s statements and its Send Statements screen don’t show that figure. The idea “Invoicing – Add Number of Days Overdue to Send Statements screen” was moved to Gaining Support on 15 January 2026, and comments ask for “Days Past Due” on the PDF statement as well.
The manual way in Xero
- Work it out by hand: open each customer’s invoices, note the due dates and count the days, then type them into your email.
- A custom statement template: one user on that idea shared a Word template that calculates days overdue with mail-merge field codes. It needs a working knowledge of Word field codes, and Xero’s merge fields don’t give days overdue directly.
- The Aged Receivables Detail report: it groups invoices by ageing period, which you can export and send alongside the statement.
What Ageline does
- Every statement line shows the invoice date, number, reference, due date, days overdue (for overdue items) and amount due.
- The top of each statement shows the total due and how much of it is overdue, followed by the ageing table (Current / 1–30 / 31–60 / 61–90 / 90+ or the buckets you choose).
- Days are counted to the statement date you set, from the due date.
- The suggested email text in the ZIP includes each customer’s total due and the overdue amount, ready to paste into your own email.
It reads Xero’s Aged Receivables Detail export (Excel) or an invoice export, and makes one PDF per customer. See which export to use.
What it doesn’t do
- It doesn’t change Xero’s own statements or the Send Statements screen.
- It doesn’t email customers; you send the PDFs yourself.
Xero is changing statements. On 27 October 2026 Xero moved the idea “Customer statements – Ability to auto email Statements” to In development and invited a limited group of users to test a new statement list and PDF views, with scheduling and “more control over which columns you display on your statement PDF” listed as coming soon. If your Xero organisation gets a statement layout that already does what you need, use it.
Try it on your own export. Free, no sign-up, nothing uploaded. The ageing summary covers every customer, and statement PDFs are made for the first 3 customers in each batch. The Practice plan ($29 per month or $290 per year) makes them for every customer: see pricing.
Make statementsMore guides
- Add 30/60/90-day ageing to Xero customer statements
- Send statements showing only overdue invoices
- Turn the Aged Receivables Detail export into statements
Ageline is independent and not affiliated with or endorsed by Xero. Xero is a trademark of Xero Limited. This guide was checked against the linked sources on 27 October 2026; Xero changes its product, so check the current Xero Central article if a menu looks different.