How to reconcile a bank account in Xero: match, create, find & match, cash coding and the reconciliation report
Manoj Tutika · Published 17 November 2026 · Last checked 17 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
How does bank reconciliation work in Xero?
Xero shows two things side by side. On the left are statement lines: the transactions your bank sent through the feed or that you imported from a file. On the right is what Xero thinks each line is: an invoice, a bill, a payment you already recorded, or a new transaction it suggests. Reconciling means pairing every statement line with the right transaction in Xero and clicking OK.
The goal is simple. Every line on the bank statement has one matching transaction in the books, nothing is recorded twice, and the bank balance in Xero equals the balance your bank shows on the same date.
You need the administrator role, or the standard role with the bank accounts permission, to reconcile. The work happens per bank account, so a business with a current account, a savings account and a card account reconciles three times.
Before you start
- Enter the sales invoices, bills, credit notes and expense claims for the period first. Reconciliation goes faster when there is something to match against.
- Check the opening balance of the bank account is right. A wrong opening balance makes every later month look out by the same amount.
- Compare the statement balance Xero shows with the balance in online banking. If lines are missing, the feed may be delayed or the dates may sit before the feed was connected, in which case you import a statement file.
How to reconcile in Xero, step by step
- In the Accounting menu, select Bank accounts.
- Next to the account, click Reconcile [number] items. If that link does not show, there are no lines waiting.
- Work down the list. For each statement line, read the suggestion on the right before you click anything.
- If the suggestion is the right invoice, bill or payment, click OK.
- If it is not, click the link for other possible matches, or use Find & Match to search.
- If nothing exists yet for the line, create it on the Create tab (spend or receive money) or the Transfer tab (money moving between your own accounts).
- If you do not know what the line is, add a comment on the Discuss tab and move on.
You can narrow the list with the search bar or with Filter, by start date, end date or amount range. The Compact view switch shows more lines per page, which helps on busy accounts.
Match when the line belongs to something already in Xero
Xero compares each statement line with the transactions already in the books and offers the closest one. Where several fit, it prefers the one with the nearest due date and gives you a link to the others. Matching is the right choice for customer receipts and supplier payments, because it marks the invoice or bill as paid. Coding a customer receipt as a new receive money transaction instead leaves the invoice open and counts the income twice.
Create when the line is a new cash transaction
Bank fees, interest, card subscriptions and other costs with no bill behind them are created during reconciliation. Xero fills in suggestions in three ways. A bank rule comes first, then a memory of how you coded similar lines before, then a prediction from the line details. Predictions show in italics, so you can tell them apart from memory. The Suggest previous entries checkbox at the bottom of the screen turns memory and predictions on or off.
For lines you see every month, a bank rule saves the most time. How to set them up, and where they stop working, is in Xero bank rules.
Transfer when money moved between your own accounts
A transfer to the savings account appears in both accounts. Create the transfer once, in either account. Xero creates the other side, so when you open the second account the line is already waiting for you to click OK.
Discuss when you do not know what it is
A comment on the Discuss tab is saved against the statement line, and an asterisk shows on the tab. Your bookkeeper or adviser sees it the next time they open the account. Once the line is reconciled, the comment moves to the History & Notes of the transaction. This beats parking unknown lines in a holding account. If you have no other choice, a suspense account in Xero is the way to do it and clear it later.
Find & match for part payments, several invoices and bank fees
Find & match is where most of the real work happens. Open it with the Find & Match link next to a statement line. You can search by name, invoice number, amount, reference or cheque number, tick several transactions and reconcile them to one line. To see credit notes in the list, select Show Received Items or Show Spent Items.
Take a customer, Harlow Joinery, who pays £1,440.00 in one transfer. In Xero they have INV-0412 for £960.00, INV-0415 for £600.00 and a credit note, CN-0031, for £120.00.
- Click Find & Match on the £1,440.00 line.
- Search for Harlow Joinery and tick INV-0412, INV-0415 and CN-0031.
- The selected total shows £1,440.00 (£960.00 plus £600.00 less £120.00), the same as the statement line.
- Click Reconcile. Both invoices are marked paid and the credit note is used up.
If the customer had paid only £1,000.00 against the two invoices, tick them, click Split, enter how much of the payment goes to each, and reconcile. The balance stays open on the invoice, ready for the next payment.
Card and payment processors often pay a little less than the invoice. If a customer paid a £2,400.00 invoice by card and £2,388.50 arrived, tick the invoice in find & match, choose Adjustments, then Bank fee, enter £11.50 and reconcile. For a small rounding difference with no fee behind it, use Adjustments, then Minor adjustment.
Find & match is not for money received before you raise the invoice. Xero treats that as a prepayment. A payment well above what is owed is an overpayment. Both have their own option during reconciliation.
Cash coding to reconcile many cash lines at once
Cash coding is a spreadsheet view of the unreconciled lines for one account. You open it from the bank account with the Cash coding tab. Lines with a bank rule applied already have the description, account and tax rate filled in. You tick them and click Save & Reconcile Selected. For the rest you type the account and VAT rate, or select a group of similar lines and set the account once for all of them.
Three points matter. Cash coding only creates new spend and receive money transactions, so reconcile invoices, bills, credit note refunds, transfers and prepayments on the Reconcile tab first, or you will post them twice. It is not on the Ignite plan. And it needs the administrator role or the standard role with the edit cash coding permission. Xero shows up to 200 lines at a time and suggests working in batches of fewer than 100.
How to fix a line reconciled to the wrong transaction
Mistakes come in two shapes, and the fix differs.
| What went wrong | What you see | Fix |
|---|---|---|
| Line matched to the wrong invoice or bill payment | The payment sits on the wrong invoice | Open the transaction, click Options, then Unreconcile. The payment stays, ready to match to the correct line. |
| Line coded as a new spend or receive money transaction when an invoice or bill already existed | The bill still shows awaiting payment and the cost appears twice | Open the transaction, click Options, then Remove & Redo. The created transaction is deleted and the line goes back to the Reconcile tab. |
After Unreconcile, the statement line and the transaction both stay in the account, without the link between them. The exception is a transaction that was manually marked as reconciled. Unreconciling that also deletes the statement line Xero created for it.
Once a period has been reported or filed, think twice before unreconciling inside it. Setting a lock date after each close stops it happening by accident.
Check the result with the Bank Reconciliation report
A screen with nothing left to reconcile does not prove the books are right. Duplicated or deleted statement lines can leave everything ticked and the balance still wrong. The Bank Reconciliation report pack is the check. In the Reporting menu, select All reports, open the Bank Reconciliation pack, pick the account and the date range, and enter the balance from online banking in Bank statement ending balance. The pack holds three reports: the Bank Reconciliation Summary, the Bank Statement and Statement Exceptions.
Here is the logic behind the summary, for a current account on 31 October 2026.
| Line | Amount | Why |
|---|---|---|
| Balance in Xero | £18,240.00 | All transactions entered for the account up to the report date |
| Add: supplier payment entered but not yet through the bank | £1,350.00 | Xero has taken it off, the bank has not yet |
| Less: customer receipt entered but not yet through the bank | −£600.00 | Xero has added it, the bank has not yet |
| Add: statement lines not yet reconciled (a £500.00 receipt and £62.40 of fees) | £437.60 | The bank has them, Xero does not yet |
| Statement balance (calculated) | £19,427.60 | |
| Bank statement ending balance from online banking | £19,427.60 | Agrees, so the account is out by nil |
If the calculated balance and the bank disagree, the report shows a Calculated balance out by amount. Open Statement Exceptions next. It lists deleted statement lines, lines Xero flagged as possible duplicates and lines created by marking transactions as reconciled. Those three explain most differences.
One quirk is worth knowing. A line matched to a transaction dated after the report date shows as unreconciled on the summary, because the report only recognises matches dated on or before its date.
How often should you reconcile?
Xero recommends reconciling regularly, and in practice that means daily or weekly for an operating account and at least before each month-end. Small batches are easier to clear because you still remember what each payment was. Bank reconciliation is also the first step of the close; the order of the other steps is in the Xero month-end close checklist.
Where an agent helps
Most reconciliation time goes on the lines Xero cannot suggest: a customer paying three invoices with a deduction, a processor payout that nets fees and refunds, an unknown transfer someone has to ask about. Thred runs an agent on top of Xero that works through those lines with the same tools, checks the remittance and the open invoices, proposes the match, and leaves a note on the ones that need a person. The general method, and what to automate first, is in bank reconciliation: how to automate it.
Frequently asked questions
How do I reconcile a bank account in Xero?
In the Accounting menu, select Bank accounts and click Reconcile [number] items on the account. For each statement line, click OK on a correct suggestion, use Find & Match to choose existing invoices or bills, or create a spend, receive or transfer transaction. Then run the Bank Reconciliation report to compare the balance with online banking.
What is the difference between unreconcile and remove & redo in Xero?
Unreconcile breaks the link between a statement line and a payment but keeps both, so you can match the payment to the right line. Remove & Redo deletes the transaction that was created during reconciliation and sends the statement line back to the Reconcile tab. Use Remove & Redo when a new transaction was created for something that already existed as an invoice or bill.
How do I reconcile a part payment in Xero?
Click Find & Match on the statement line, tick the invoice or bill, click Split, enter the amount paid and reconcile. The rest stays outstanding on the invoice or bill for the next payment.
Why does my Xero bank balance not match my bank statement?
Usually because of duplicated or deleted statement lines, a transaction reconciled to the wrong line, a wrong opening balance or payments entered in Xero that have not cleared. Run the Bank Reconciliation report with the online banking balance and check the Statement Exceptions report for deleted and duplicate lines.
Can you reconcile in bulk in Xero?
Yes, with cash coding, on plans other than Ignite. It suits cash transactions such as fees and small purchases. Invoices, bills, transfers and refunds should still be matched on the Reconcile tab so they are not recorded twice.
Sources
- Xero Central, Reconcile your bank account
- Xero Central, Bank reconciliation in Xero
- Xero Central, Find transactions to match to bank statement lines
- Xero Central, Record a part payment during reconciliation
- Xero Central, Reconcile statement lines in bulk (cash coding)
- Xero Central, Unreconcile an account transaction
- Xero Central, Fix an incorrectly reconciled bank statement line
- Xero Central, Add a comment to a bank statement line
- Xero Central, Bank Reconciliation reports
Read next
- Xero bank rules: how to create, edit and find them, and where they stop working
- Bank reconciliation: how to do it step by step, and how to automate it
- Suspense account in Xero: how to create, use, clear and reconcile it, with a worked example
- Month-end close checklist for Xero: the steps, checks and who does what
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
