How to reconcile a Xero customer statement
Key facts
Which Xero customer statement should you use? Choose Activity to show how the balance changed over a period. Choose Outstanding to show what was still open on a particular date. Use the last day of the Activity period as the Outstanding statement date.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Choose the statement that answers the customer’s question
- Activity for “How did you get that balance?” Pick a date range that covers the disputed entries. Use the opening balance and the period’s invoices, receipts and credit notes to explain the closing balance.
- Outstanding for “Which items still need payment?” Pick the agreed cutoff date and review the open items. An open invoice may be within terms, so use the due date to identify what is overdue.
Set the same cutoff before comparing balances
Open the customer’s contact record and confirm the billing entity. For a September review, generate Activity for 1 to 30 September and Outstanding as at 30 September. Compare the same customer and currency on both. Check the balance against the underlying invoices and credits before treating a difference as a posting error.
Worked example for a missing £300 receipt
In this fictional account, Ashcombe Components opens September with £480 due on INV-418. On 8 September, you invoice £1,800 on INV-452. You apply an £850 receipt on 19 September and a £200 credit note on 23 September to INV-452. The Activity statement closes at £1,230 (£480 + £1,800 minus £850 minus £200). The Outstanding statement shows £480 on INV-418 and £750 on INV-452, also £1,230.
The customer expects £930 because they initiated another £300 transfer on 30 September. Ask for the amount, transfer date and bank payment reference or remittance advice. If your bank shows the money arrived on 2 October and it was applied to INV-452 that day, the September balance is £1,230. An updated statement as at 2 October shows £930, assuming no other activity.
If your bank instead confirms receipt on 30 September and you entered the payment in Xero on 2 October, check the payment date recorded in Xero and the invoice allocation. A correctly dated and applied September receipt brings the regenerated 30 September balance to £930. Check the bank line and existing Xero entry before recording any payment.
Reply with the balance and its date
Send the statement that answers the customer’s question. In the reply, state the cutoff, name the invoice in dispute and explain where the £300 appears, or request its reference if you still need to trace it.
Xero Central explains how to view or send a customer statement. Xero’s billing statement guide explains what to include. For an internal check, see how to use the Xero aged receivables report.


.webp)