Fintrix Consulting LLC

Bookkeeping

Xero bank reconciliation: how it works and how to fix it

November 19, 2026 · 10 min read

← All articles
Bookkeeper's hand holding a pen and tapping a calculator on top of a binder of printed statements, next to an open laptop in bright window light
Photo via Pexels

Quick answer

In Xero, reconciling means pairing each bank statement line (what the bank says happened) with an account transaction (what you recorded), by matching an existing invoice, bill or payment, or creating a new spend, receive or transfer transaction. You're done when every line is reconciled and the Bank Reconciliation Summary ties to your real bank balance. Most mistakes come from creating a transaction you should have matched, and are fixed with Unreconcile or Remove & Redo.

You open Xero and the bank panel says 14 items to reconcile. The statement balance doesn't match the balance in Xero, neither matches your bank's app, and you're fairly sure you reconciled last month.

That's a normal Xero morning. The software is good at reconciliation, but a couple of its buttons are easy to press for the wrong reason, and a wrong click doesn't throw an error. It just quietly doubles your revenue or hides a bank fee.

This post covers how reconciliation works inside Xero, the report that proves it's right, and how to fix the common mistakes. For the general idea (deposits in transit, outstanding checks, why it matters), start with our bank and credit card reconciliation guide.

How does bank reconciliation work in Xero?

Xero keeps two lists for every bank account, and reconciling means pairing them up.

  • Bank statement lines come from the bank, through a bank feed or a file you import. They show on the left of the Reconcile tab.
  • Account transactions are what you (or Xero) recorded: invoice and bill payments, spend money and receive money transactions, transfers. They show on the right.

So the bank panel shows two balances. The Statement Balance is your opening balance plus every statement line imported. The Balance in Xero is your opening balance plus every account transaction, and it's the number on your balance sheet. Once everything is paired, they agree apart from timing items like an uncleared check.

For each statement line you do one of three things:

  1. Match it to something already in Xero, like a customer's payment against an open invoice. Xero suggests the closest match and you click OK. If it's wrong, Find & Match lets you search, pair one deposit with several invoices, or add a line for a bank fee.
  2. Create a new transaction on the Create tab when nothing exists yet. Bank fees, a software subscription, interest earned.
  3. Transfer when money moved between two of your own accounts, like paying the company card from checking. Create it in one account; Xero adds the other side, so in the second account you just click OK.

No idea what a line is? The Discuss tab lets you leave a note for your bookkeeper instead of guessing.

When should you use bank rules?

Bank rules tell Xero how to code repeat lines you'll never raise a bill or invoice for: the monthly bank fee, parking, a recurring transfer to savings. When a new line fits a rule's conditions (payee, description, amount, reference), Xero suggests a filled-in spend, receive or transfer transaction. You still click OK.

Xero checks rules in the order they're listed, so a broad rule near the top can grab lines meant for a narrower one. And never write a rule for something you invoice: a rule that books a client's payments straight to sales leaves the invoice open forever and counts the revenue twice. Xero's own guidance is to use Find & Match for anything tied to an existing transaction.

On some plans Xero now reconciles lines automatically when it's highly confident. Handy, but you still check what it did and prove the balance.

How do you know the reconciliation is actually right?

Clearing the Reconcile tab feels like the finish line. It isn't. The proof is the Bank Reconciliation Summary, which lives in the Bank Reconciliation report pack under Reporting, All reports. The pack also holds the Bank Statement and Statement Exceptions reports.

The summary walks from the Balance in Xero, through outstanding payments and receipts (recorded but not yet reconciled) and unreconciled statement lines, to the Statement balance (calculated). At the top you can type your actual bank balance under Bank statement ending balance, and Xero shows any gap as Calculated balance out by.

You want the out-by figure at zero, few or no unreconciled lines, and outstanding items that are real timing differences (a check that hasn't cleared), not something from six months ago.

If the out-by figure isn't zero, the problem is in the statement lines (a duplicate, deleted or missing line). If it's zero but the Balance in Xero is off, the problem is in your account transactions.

A worked example: one month in Xero

Say you run a hypothetical 10-person marketing agency, and you're reconciling the business checking account for October in Xero. Your bank's app shows $36,420 at October 31. Xero's Bank Reconciliation Summary, before any fixes, says this:

Line on the reportAmountWhat's behind it
Balance in Xero$36,475Every account transaction recorded so far
Plus outstanding payments+$2,300A $1,760 supplier check that hasn't cleared, and a $540 software charge entered twice
Plus unreconciled statement lines−$855A $45 bank fee, a $2,310 credit card payment, and a $1,500 client deposit that appears twice
Statement balance (calculated)$37,920
Bank statement ending balance (typed in)$36,420From the bank's app
Calculated balance out by$1,500Xero's statement is $1,500 too high

Step 1: fix the statement lines. The Statement Exceptions report flags the $1,500 deposit as a potential duplicate: someone imported an October CSV after the feed had already brought that week in. Delete the duplicate line and the Statement balance drops to $36,420, matching the bank.

Step 2: fix the account transactions. The $540 subscription was typed in as a spend money transaction and created again from the statement line. The extra copy will never clear, so delete it. Balance in Xero goes up $540.

Step 3: clear what's left. Create the $45 bank fee (a good candidate for a bank rule). Record the $2,310 card payment as a transfer, not an expense. The $1,760 check is genuine and stays outstanding until November's statement.

From Balance in Xero to the real bank balance

Hypothetical marketing agency, business checking, October 31

  • Raises balance
  • Lowers balance
  • Total
$0$10k$20k$30k$40kBalance in Xero: $36,475$36kBalance inXeroDuplicate deleted: +$540+$540DuplicatedeletedBank fee: −$45−$45Bank feeCard payment: −$2,310−$2.3kCardpaymentXero after fixes: $34,660$35kXero afterfixesUncleared check: +$1,760+$1.8kUnclearedcheckBank balance: $36,420$36kBankbalance

Hypothetical example. 36,475 + 540 − 45 − 2,310 = 34,660. Add back the $1,760 check that hasn't cleared and you get 36,420, the balance in the bank's app.

Show the numbers
Balance in Xero$36,475
Duplicate deleted+$540
Bank fee−$45
Card payment−$2,310
Xero after fixes$34,660
Uncleared check+$1,760
Bank balance$36,420

One thing the report can't show you: a $4,200 client payment from mid-October was reconciled with Create, coded straight to Sales, instead of matched to the open invoice. The bank balance is fine, but October revenue is overstated by $4,200 and the invoice still shows as unpaid. You use Remove & Redo on the receive money transaction, then match the line to the invoice.

That's the lesson in one example: a reconciliation can balance to the penny and still be wrong. The report proves cash. It doesn't prove coding.

Unreconcile, Remove & Redo or delete: which fix do you need?

Pick the wrong one and you either leave a duplicate behind or delete something you needed.

Three ways to undo a reconciliation in Xero

Keep the transaction

Unreconcile

  • Removes the link between the statement line and the account transaction
  • Both stay in Xero, ready to pair again
  • Use it when the transaction is correct but matched to the wrong line
  • Open the transaction, then Options, Unreconcile

Delete the transaction

Remove & Redo

  • Deletes the account transaction (spend, receive, transfer or payment)
  • The statement line goes back to the Reconcile tab
  • Use it when the transaction itself is wrong, like a receive money that should have matched an invoice
  • Open the transaction, then Options, Remove & Redo

Duplicates only

Delete statement line

  • Removes the bank's line, which changes the Statement Balance
  • Only for a line imported twice
  • Deleted lines can be restored from Bank Statements
  • On the Reconcile tab, Options, Delete statement line

You'll need the administrator role, or standard with bank account access, to unreconcile, delete or restore lines.

What if statement lines are missing, or the opening balance is wrong?

Missing lines. Feeds only bring in cleared transactions, so the last day or two may not be there yet. Refresh the feed first. If a stretch is missing (often between your Xero start date and the day the feed connected), compare the Bank Statement report with your bank, then export those dates from online banking and import them as a file.

Mark as Reconciled creates a statement line for you. Use it only when you truly can't import the bank's data, because if the real line arrives later you'll have a duplicate.

Opening balance. If the Statement Balance has been off since day one, check the opening figure. For an account you had before Xero, the conversion balance should be the bank's closing balance for the day before your conversion date, not your old trial balance figure, which may include uncleared checks. If a gap appeared later, find the last month-end where Xero and the bank agreed and work forward month by month.

How do lock dates protect a reconciled month?

Once a month is reconciled and reviewed, lock it. In Xero that's Accounting, Accounting settings, Financial settings, then a date under Lock Dates. After that, nobody can add or edit transactions dated on or before it. You can lock all users, or everyone except administrators.

Unreconciling or deleting an old line changes reports you've already sent to your CPA or lender. A lock date stops that happening by accident. It's the Xero version of the closing date we cover in the month-end close checklist.

Common Xero reconciliation mistakes

What actually goes wrong

On the Reconcile tab

  • Using Create for a customer payment instead of matching the invoice
  • Coding a credit card payment as an expense instead of a transfer
  • Writing a bank rule for income you invoice

With the statement lines

  • Importing a CSV over dates the feed already covered, creating duplicate lines
  • Using Mark as Reconciled, then the real line arrives later

When should you get help?

With one checking account, one card, a few dozen lines a month and the summary run monthly, doing this yourself is completely reasonable. It's an hour, not a day.

Get help when the balances haven't matched for a while and you don't know when it went wrong, when months are unreconciled (see our plan for catching up), or when you suspect revenue is double counted. Untangling a year of duplicates is slow work.

Fintrix Consulting works in your own accounting software, in your name, and QuickBooks Online and Xero are the systems we see most. Every bank and card account is reconciled monthly and closed by the 10th; here's how our bookkeeping works. Still deciding between the two platforms? Our QuickBooks Online vs Xero comparison covers that.

Frequently asked questions

What's the difference between Statement Balance and Balance in Xero?

Statement Balance is Xero's copy of the bank, built from imported statement lines. Balance in Xero is built from the transactions you recorded and is what your balance sheet shows. Once everything is reconciled they match, apart from items that haven't cleared.

Why does a customer's invoice still show as unpaid after I reconciled the payment?

The statement line was probably reconciled with a new receive money transaction instead of being matched to the invoice. Open the reconciled transaction, use Remove & Redo to delete it, then match the statement line to the invoice.

Should I use Mark as Reconciled for missing transactions?

Only if you can't get the data from the bank at all. Importing the missing dates as a file is better. Mark as Reconciled creates its own statement line, and if the real line is imported later you'll have a duplicate.

How often should I reconcile in Xero?

At least monthly, with the Bank Reconciliation Summary at month end. Weekly is easier, because you can still remember what each line was.

The bottom line

Reconciling in Xero is mostly matching: pair every bank line with the right transaction and create new ones only when nothing exists. An empty Reconcile tab isn't the proof; the Bank Reconciliation Summary tied to your real bank balance is. Know which undo button does what, and lock each month once it's reviewed.

This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

Ready for books you can trust?

Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.