How to Reconcile Supplier Statements in Xero, With a Worked Example

Does Xero reconcile supplier statements?

The word “reconcile” misleads here. In Xero it normally means bank reconciliation: matching lines from a bank feed to transactions in your books.

Customer statements exist. Xero’s help describes two types, Activity and Outstanding, which you send to the people who owe you money. We found no supplier-side equivalent in the published help.

Which Xero report matches which supplier statement?

Statements usually come in one of two shapes, and the shape decides the report. An open-item statement lists only what is unpaid. Garrity Valve & Hose sends this kind. It has seven lines, no opening balance, no payments, and a total of 6,665.95 at 31 August 2026.

A balance-forward statement starts from an opening balance and then lists invoices, credits and payments down to a closing balance. Merrin Hydraulics sends that shape, and it is the one in the worked example further down.

For that statement, run Aged Payables Detail for Garrity only, as at 31 August 2026. The seven lines should come back with the same total.

The balance-forward statement is harder, because it carries payments and a period. Start with Supplier Bill Activity. It lists one supplier’s bills and bill payments over a period, with an opening and a running balance, so it reads like the statement.

It does not show every payment. When we ran it in Xero’s Demo Company (AU), a spend-money payment was missing from it and showed in Contact Cash Activity instead. So run both reports for the period and read them together against the statement.

Xero Central lists Supplier Bill Activity with the Contact Transactions reports: open Reporting, then All reports, search for it, pick a contact and a date range, and click Update.

Two more reports help. Payable Invoice Detail lists bills and credit notes, paid or not, but no payments. Account Transactions, set to your Accounts Payable account and filtered to one contact, lists bill payments beside the bills they settle.

Aged Payables or Aged Creditors is the same report under two names. The glossary entry sorts out which name goes with which country.

Three checks before you open a report

1. Open Purchases, then Bills, then the Draft tab. Approve or delete anything from this supplier that is sitting there.
2. Check that the supplier’s payments are matched on the bank reconciliation. A payment that is in the bank feed but not applied to the bill leaves the bill looking unpaid.
3. Search your contacts for the supplier’s trading name and its legal name. Bills split across two records produce a short balance on both.

The method, one statement at a time

1. 1

   Write down three numbers

   The statement date, the period, and the closing balance printed on the page. Add the currency if it is not your own.

2. 2

   Run the report for that supplier only

   Go to Reporting, then All reports, open the report, set the date or period and the contact, and click Update. If the statement lists open items, use the statement date rather than today’s date.

3. 3

   Compare the totals, then keep going

   If the two totals agree, spot-check the oldest items anyway. A missing invoice and a duplicate bill can offset each other.

4. 4

   Tick off by reference, then amount, then date

   Start with the supplier’s reference. If it is not in Xero, look for the same amount on the same date. Some people type a purchase order number into the Reference field instead of the invoice number, so a bill can sit under a reference the supplier has never seen.

5. 5

   Move to a sheet once the statement runs past about fifteen lines

   Under fifteen lines, a printout and a pen are quicker. Beyond that, export both lists from the reports (Xero offers PDF, Excel and Google Sheets) and put them side by side. The free spreadsheet template has the columns laid out. In the sheet, pull the Xero amount in beside each statement reference with =XLOOKUP(A2, XeroRefs, XeroAmounts, "not in Xero") in Excel 2021, Microsoft 365 or Google Sheets. Any row that says "not in Xero" is a line to chase.

6. 6

   Give every difference a cause

   Typical causes are a bill or credit note that is missing from Xero, a duplicate in Xero, an amount that differs, a timing gap, or something only the supplier can explain. If a difference has no cause written beside it, you haven’t finished with it.

7. 7

   Fix what is yours, query the rest, file the working

   Post, correct, allocate or void in Xero. Email the supplier about what is theirs. Keep the statement PDF and your tick-off sheet together and dated, so next month’s opening balance has something to be checked against.

Merrin Hydraulics, September 2026: eight lines, five causes

Fenwick Reach Fabrication buys couplings and hose fittings from Merrin Hydraulics on account FRF-2207. Both businesses are invented for this guide, and so is every figure. Merrin’s statement is dated 30 September 2026 and closes at 6,414.35. Fenwick Reach’s Xero balance for Merrin is 4,231.60. The statement is 2,182.75 higher.

Five differences, three different owners

The table walks from the Xero balance to the statement balance, one cause at a time, and ends on 6,414.35.

Three of the five are yours to fix: approving MHY3102 lifts Xero by 2,063.45, entering MHY-CR219 takes off 314.60, and voiding the second MHY 3117 takes off 957.80. After that Xero reads 5,022.65.

Once the 29 September payment reaches Merrin, their statement would read 5,168.00, and the 145.35 left between that and Xero’s 5,022.65 is the one coupling. We would not edit the bill from five couplings to six just because the statement says six.

The one line that is the supplier’s

Why doesn’t my supplier statement match Xero?

Merrin’s statement had five causes. Problems that turn up in any ledger are in the common reconciliation problems guide.

• An amount that differs from the statement: hold that line out of the payment run until the supplier has confirmed which figure is right.
• A timing difference, where the item falls on either side of the statement date: note it, and expect it to clear on next month’s statement.

How do I find and allocate a supplier credit note in Xero?

Suppliers often raise a credit note without sending you a copy, so the statement is where you first see it.

If you have never seen the document, ask the supplier for it. Our guide on chasing a missing credit note has the email and the follow-up.

Once you have the credit in Xero, the rules for applying it come from Xero Central’s page on applying a supplier’s credit to a bill:

• A credit can be applied only to a bill that is Awaiting payment, not to a draft or a paid one.
• More than one credit can go on one bill, up to the amount still outstanding, and one credit can be spread across several bills.
• When you approve the next bill for that supplier, Xero prompts you to allocate any credit you hold.

The Merrin credit note does not say which invoice it relates to. Work out which bill the returned fittings were on, and allocate it there. If that bill is MHY3102, approve the draft first. A credit can only go onto a bill that is Awaiting payment.

A credit note you have not entered can also change the GST for the period it belongs to. How it is treated depends on your accounting basis and your registration, so ask your registered tax agent. General information, not tax or legal advice.

How do I reconcile a supplier that bills in another currency?

Foreign-currency suppliers are the awkward case. Users on Xero’s Product Ideas forum have reported since 2023 that Supplier Bill Activity does not show amounts in the supplier’s currency. Statemint’s Xero guide says Aged Payables shows foreign-currency items in your base currency. To confirm it on your own organisation, open one foreign-currency bill and compare its amount with the report line.

Match on reference first. The amounts will differ by whatever rate Xero used when each bill was entered. For the lines that matter, open the bill and read the amount in the supplier’s currency. Small rate differences on payments are exchange differences, so do not chase them as if they were errors. For the matching order, see how lines get paired.

How often should you reconcile supplier statements?

Do it each month for the suppliers you pay every month, and again before a payment run if an account is in dispute. Someone you only buy from a couple of times a year can usually wait until the next order. The month-end and pre-payment-run checklist sets the cadence out in a table.

Twenty suppliers a month: where Statement Zen fits

Merrin took eight lines and five causes. With 20 suppliers like it you are looking at 40 exports, 20 lookups and a stack of emails.

Statement Zen is our product, and it can reconcile Xero supplier statements automatically. Connect Xero once with a read-only sign-in, forward the supplier’s statement as it arrived, and each line is matched against your open Xero bills and credit notes. Nothing in Xero is changed by the connection, so approving the draft bill and voiding the duplicate stay your decisions.

To try it on one statement, use the free reconciliation.

Questions people ask

Sources

• Xero Product Ideas: Reporting, add ageing for Customers and Suppliers (Xero community team reply, 2024), read 30 Oct 2026
• Xero Central: Contact transactions reports, read 30 Oct 2026
• Xero Central: Payable Invoice Detail report, read 30 Oct 2026
• Xero Central: Account Transactions report, read 30 Oct 2026
• Xero Central: Aged Payables Detail report, read 30 Oct 2026
• Xero Central: Select contents and display order in a new report, read 30 Oct 2026
• Xero Central: Apply a supplier’s credit to a bill, read 30 Oct 2026
• Xero Central: Add and track your bills in Xero, read 30 Oct 2026
• Xero Central: Send a customer statement, read 30 Oct 2026
• Xero Product Ideas: Supplier Bill Activity report, run in foreign currency with totals, read 30 Oct 2026
• Xero Product Ideas: Contacts, Supplier Statement Detailed Ledger (running balance request), read 30 Oct 2026
• Xero blog: Product news, August 2022 (Payable Invoice Detail report), read 30 Oct 2026
• Statemint: Xero supplier statement reconciliation, read 30 Oct 2026

What changed

• 30 Oct 2026: First published. Report names and menu labels checked against Xero help pages and Xero staff replies on this date.
• 31 Oct 2026: Opening answer split into two short sentences, and each unverified route now has a confirm-on-your-organisation row in a table.
• 31 Oct 2026: Ran Supplier Bill Activity, Contact Cash Activity, Payable Invoice Detail and Account Transactions in Xero’s Demo Company (AU) and replaced the hedged report notes with what each report showed. Added a screenshot of Supplier Bill Activity and shortened the report cards. Shortened the guide by about 1,200 words.