How to reconcile a Xero customer statement

When a customer queries their balance in Xero, use an Activity statement to trace the invoices, receipts and credits behind the total. Then check the amount still open on an Outstanding statement for the same customer and cutoff date.
Upload a case

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.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.