Short answer: Xero has no supplier statement screen. Its own help says there is no specific feature for sending supplier statements, and suggests reports you customise instead. Four do the job: Aged Payables Detail for what is open, Supplier Bill Activity for the movement, Payable Invoice Detail for line detail, Expenses by Contact for totals. Set both sides to the statement date, tick off what matches, correct what does not.
For the method with no software in mind, see supplier statement reconciliation, step by step. Report and menu names below come from Xero Central on 20 November 2026.
What Xero reconciles for you, and what it does not
In Xero, "reconcile" means the bank: statement lines in, matched against transactions. Supplier statements are a different job, and Xero has no feature for them. Customer statements exist, supplier statements do not. What you get instead is a reporting screen flexible enough to build one, and a layout you save sits on the Custom tab of the Reports screen.
The reports that do the job
All of these live under Reporting, then All reports.
| What you need | Report |
|---|---|
| Open bills, credit notes and overpayments by age | Aged Payables Detail |
| Bill activity in a period, with payments and refunds | Supplier Bill Activity |
| Line by line bills, credits, overpayments, prepayments | Payable Invoice Detail |
| Expense totals per supplier, across periods | Expenses by Contact |
| Payments made as spend money | Contact Transactions - Cash |
Supplier Bill Activity has no row of its own, which is why people cannot find it. Click the menu icon next to Contact Transactions - Summary and select it from the popup.
Four defaults change the answer, so set them deliberately:
- Prepayments are off on Supplier Bill Activity and the Payable Invoice reports. Click More, select Include, then Update. A prepayment the supplier has already netted off is a difference you would otherwise hunt for twice.
- The Payable Invoice reports include draft, deleted and voided bills until you filter them out. Run one unfiltered: it is the quickest way to tell a bill never entered from a bill sitting in draft.
- Aged Payables Detail ages by Invoice Date or Due Date, with the number of ageing periods up to you. Match whichever the supplier uses, or the columns disagree even when the balance does not.
- Supplier Bill Activity omits cash transactions, so a payment entered as spend money straight from the bank is missing from it. Contact Transactions - Cash catches those, a common reason a bill looks unpaid while the supplier has the money.
How to reconcile a supplier statement in Xero
- Fix the cut-off. Run every report to the statement date, not to today. Most unexplained differences are a date mismatch.
- Run Aged Payables Detail, filtered to the contact. That is your side of the argument: open items and their age.
- Run Supplier Bill Activity for the period to see what moved, then Contact Transactions - Cash for spend money payments.
- Tick off the bills. A bill matches when the supplier's own invoice number and the amount both agree. That number belongs in the Reference field: it is one of the three fields Xero uses to catch duplicates.
- Account for the drafts. Run Payable Invoice Detail unfiltered and look for the statement's missing invoices sitting in draft or voided. A draft bill needs approving, not entering again.
- List the one-sided items. On the statement only: bills never entered, credit notes never recorded, bills keyed to the wrong contact. In Xero only: payments in transit, duplicates.
- Correct Xero, query the rest, then rerun and check the corrected balance plus timing items equals the supplier's balance exactly. "Close enough" is how a duplicate survives to next month.
How to clear each difference
Bill on the statement, nothing in Xero. Ask for a copy of the invoice and enter the bill from that, never from the statement line, which carries no line or tax detail you can rely on.
Credit note on the statement, nothing in Xero. Enter it, then allocate it. Xero treats overpayments, prepayments and credit notes alike as credit on the account, and the rules are specific: credit goes only against bills that are Awaiting Payment, never draft or paid ones, and one credit can cover several bills, up to the outstanding amount either way. Credit the full amount and the bill becomes Paid; the credit stays Awaiting Payment until the last of it is used.
A credit sitting unapplied. It appears on Aged Payables Detail as its own line, so a balance can agree while no line matches. Allocate it: Purchases, Bills, Awaiting Payment tab, open the credit, options button, Allocate Credit.
Dates and locked periods. When credit is applied, the payment date follows the later of the two documents, which is usually what moved a bill into a month the statement did not expect. Credit in a locked period can go against a bill in an open one, but nothing can be applied to a bill in a locked period, so correct in the open period and note it.
Bill entered twice. Xero flags potential duplicates itself, comparing Contact, Reference and Total and treating a match on all three as a possible duplicate. Find them under Purchases, Bills, the menu icon, Review duplicate bills, then Void, Delete or Keep all. Two limits matter: all three fields must match, so a blank Reference or a rounding difference hides the pair, and bills from the same repeating template are never compared. If the duplicate is already paid, remove the payment before voiding it. The intake side is covered in how duplicate invoices happen.
One payment covering several bills. A Xero batch payment bundles bills into one payment transaction, and bills for the same supplier are combined in the payment file, so the supplier gets one payment and one reference while the bills still show separately. Batch payments run in the base currency only, and when the bank asks whether to import the batch as one statement line or several, one line is far easier to reconcile.
Payment sent but not on the statement. Timing: list it and leave it. If it is weeks old, chase the allocation instead.
A worked example
A supplier statement at 31 October shows GBP 9,650. Aged Payables Detail, at the same date and contact, shows GBP 6,920. The GBP 2,730 difference is five things, not one.
| What it is | Where it appears | Action | Effect on the Xero balance |
|---|---|---|---|
| Bill INV-2214, 1,180, emailed in, still in draft | Statement only | Approve the draft bill | +1,180 |
| Credit note CN-77, 260, for a returned item | Statement only | Enter it and allocate it | -260 |
| Bill INV-2190, 430, entered twice | Xero only | Void the duplicate | -430 |
| Bill INV-2203, 620, keyed to a sister branch | Statement only | Move to the right contact | +620 |
| Batch payment of 1,620 sent 29 October | Xero only | None, timing | none |
The reconciliation then reads:
| GBP | |
|---|---|
| Aged Payables Detail, 31 October | 6,920 |
| Add: bill INV-2214 still in draft | 1,180 |
| Less: credit note CN-77 not recorded | (260) |
| Less: bill INV-2190 duplicate | (430) |
| Add: bill INV-2203 under the wrong contact | 620 |
| Corrected balance in Xero | 8,030 |
| Add: batch payment in transit, 29 October | 1,620 |
| Balance per supplier statement | 9,650 |
Without it the client pays INV-2190 twice, misses a 260 credit, lets INV-2214 go overdue in draft and overstates the sister branch by 620.
A monthly routine for firms
- Run Aged Payables Detail at month end across all contacts and pick the accounts worth reconciling: largest balances, weekly suppliers, anyone sending reminders. Ask those suppliers for statements at the same date, and save the layout as a custom report.
- Reconcile the rest quarterly, and every supplier with a balance at year end. Keep each reconciliation with its statement, so next month starts from the open items.
- Put statements in the same queue as the bills, so whoever enters a client's invoices notices a missing one in seconds. The same job is covered for Zoho Books, QuickBooks and MYOB.
Four of the five differences above began at intake: a bill keyed wrongly, entered twice or left in draft. Fix that step and statements start agreeing on their own.
Where Invoreg fits
Invoreg does not reconcile supplier statements. It works on the step that creates most of the differences: it reads every supplier invoice, including scans and phone photos, line by line with the tax rate on each line, suggests the coding from the client's history, checks for duplicates against the workspace and the bills already in the accounting software, and registers nothing without a person approving it.
Zoho Books is the live connector today. For a Xero file the route is an import file the software already accepts, usually within days, or an API connector in one to three weeks after a short technical review, which the Xero connector page covers. Either way invoices arrive coded, de-duplicated and approved, which is most of what makes a statement agree: try it on your own invoices, the first 20 invoices are free.