Xero Bank Reconciliation, Step by Step (With Fixes)

TL;DR In Xero, reconciling means pairing every bank statement line (from a bank feed or an imported file) with a transaction in your books: match it to an existing invoice, bill or payment, create a new transaction, or record it as a transfer. When every line for the period is reconciled, compare the statement balance in Xero with the closing balance on your actual bank statement, and run the bank reconciliation report. If they don't agree, the cause is almost always a missing or duplicated statement line, a wrong opening balance, or a transaction reconciled to the wrong line.

Xero's reconciliation screen is one of its best features, and also one of the most misunderstood. People click OK on a suggested match for months, then discover the bank balance in Xero doesn't match the bank. This guide explains what's actually happening on that screen, a reliable monthly routine, and how to track down differences when they appear.

Xero changes its interface from time to time, so the steps are described by what they do rather than by exact button labels. Look for the equivalent options in your version, and check Xero's help centre if something has moved.

How reconciliation works in Xero

There are two lists involved.

Statement lines. These are what the bank says happened. They arrive through a bank feed, or you import them from a statement file. Each line has a date, a description or payee and an amount.

Account transactions. These are what your books say happened: payments against invoices and bills, spend and receive money transactions, transfers, and manual entries.

Reconciling pairs the two. Each statement line should end up linked to exactly one transaction (or a group that adds up to it). When you do this, Xero marks both sides as reconciled.

Two balances then matter:

• Statement balance: the running total of the statement lines in Xero. If your statement lines are complete and correct, this equals the bank's real closing balance.
• Balance in Xero: the total of reconciled transactions in your books for that account.

When both of these agree with the actual bank statement at the end of the period, the account is reconciled. If the statement balance in Xero doesn't match your real statement, the problem is in the statement lines. If it does match but the balance in Xero is different, the problem is in how lines were reconciled.

Before you start

A few things make reconciliation much smoother.

1. Have the bank statement for the period. The PDF statement gives you the closing balance to aim for. Without it, you're reconciling to whatever the feed says, which is usually right but not always.
2. Check the opening balance. If this is the first period in Xero, the conversion balance for the bank account must equal the bank's balance on the conversion date. Our guide to opening balance mismatches explains how to check it.
3. Make sure the statement lines are complete. If you rely on a bank feed, check it covers the whole period. If you import, import every statement for the period. For PDFs, convert them first: SheetStatement's bank statement to Xero converter produces a CSV in Xero's format and checks it against the statement's balances before you download.
4. Enter invoices and bills first. If customers pay invoices and you pay bills through the bank, having those documents in Xero means statement lines can be matched to them rather than created as new spend or receive money.

The monthly routine, step by step

Step 1: Open the bank account's reconcile screen

From the dashboard or the bank accounts area, open the account and go to the list of items to reconcile. Each row shows a statement line on the left and Xero's suggestion, or an empty space, on the right.

Work oldest first. It's easier to follow and keeps any problem contained to one period.

Step 2: Match lines to existing transactions

When Xero finds a likely match, such as an invoice for the same amount or a payment already recorded, it suggests it. Before you accept:

• Check the amount and the contact, not just the amount. Two invoices for $500 from different customers look the same to a matching algorithm.
• Check the date. A match months away from the statement line is suspicious.
• Use find and match when the suggestion is wrong or there's none. You can search by amount, contact or reference, and select several transactions that together equal the statement line, for example a single deposit that covers three invoices.

If a customer paid an invoice net of a fee, find and match lets you select the invoice and add an adjustment for the fee, so the totals agree. Make sure the adjustment goes to a sensible account, such as bank fees.

Step 3: Create transactions for everything else

For lines that don't relate to an existing document, such as a card purchase, a bank fee or a refund, create a new transaction from the statement line. Choose the contact, the account (expense or income category), the tax rate if applicable, and a description.

Our guide to categorizing business expenses from bank statements helps with consistent choices.

Step 4: Record transfers as transfers

Moves between two of your own accounts (checking to savings, checking to a credit card) are transfers. Use the transfer option and choose the other account. If both accounts are in Xero and both have statement lines, the transfer created on one side should be matched, not recreated, on the other. Creating it twice is one of the most common causes of a balance that's off by exactly the transfer amount.

Step 5: Use bank rules for repeat items

Bank rules tell Xero how to code a statement line based on its description, payee or amount. They're worth setting up for anything that recurs monthly: rent, software subscriptions, the phone bill, bank fees. Keep rules specific. A rule that catches anything containing "AMAZON" will code business and personal purchases the same way.

Review rule-coded lines before you reconcile them; rules suggest, but you still confirm.

Step 6: Handle lines you can't explain yet

If you don't know what something is, don't guess. Leave it unreconciled, or use the discuss feature to leave a note or a question for your accountant, and come back to it. Coding a mystery transaction to a random expense to clear the screen makes next month harder.

Step 7: Compare with the real statement

When all the lines for the period are reconciled:

1. Look at the statement balance in Xero at the statement end date.
2. Compare it with the closing balance on the bank's statement.
3. Run Xero's bank reconciliation report for the account and date. It shows the balance in Xero, the statement balance, and items that explain any difference, such as unreconciled statement lines or payments recorded in Xero that haven't appeared at the bank yet.

If all three agree, the month is done.

Finding differences

When the numbers don't agree, work out which side is wrong before you start fixing.

If Xero's statement balance doesn't match the real statement

The statement lines themselves are off. Look for:

• Missing lines. A feed gap or an import that didn't cover the whole period. Compare the count and total of lines in Xero for the period against the statement.
• Duplicated lines. An import that overlapped with the feed, or the same file imported twice. Look for identical date and amount pairs and compare with the statement.
• Wrong signs. An imported file where money out was positive. Everything is reversed, and the difference is usually large and obvious.
• Wrong dates. A day-first file read as month-first shifts transactions into the wrong month.

Once you've found the problem, fix the statement lines first: delete the duplicated import or import the missing lines. Our guide to Xero bank statement import errors covers import problems in detail.

If the statement balance matches, but the balance in Xero doesn't

The statement lines are fine, but something was reconciled incorrectly. Look for:

• Lines matched to the wrong transaction, such as the wrong invoice or a payment from a different month.
• Transactions created that already existed, such as a supplier payment entered manually and then created again from the statement line.
• Transfers recorded twice, once on each account.
• Manual entries dated in the period that never went through the bank.
• Edits to reconciled transactions after the fact, which change the balance in Xero without touching the statement.

The reconciliation report and the account transactions list, filtered to the period, are the tools here. Sort by amount and look for the size of the difference. If the difference is exactly one transaction's amount, look for that amount; if it's double, look for a sign problem.

Our general guide to finding bank reconciliation discrepancies applies to Xero as well.

Undoing a bad reconciliation

If you reconciled a line to the wrong transaction, you can unreconcile it from the account transactions list and reconcile it again correctly. Be careful with this on periods that have already been reported or filed. If your books are locked for a period, or your accountant has already used the figures, ask before you change anything.

If you need to remove an entire imported statement (for example, because it overlapped with the feed), Xero offers a way to delete imported statements or statement lines. Any lines from that import that were already reconciled will need to be unreconciled first. Check Xero's help for the exact behaviour in your version.

Reconciling credit card accounts

Card accounts in Xero work the same way, with one difference in perspective: purchases increase the balance owed and payments reduce it.

• Import or connect the card as a credit card account, not a bank account.
• Code purchases to expense accounts and match the monthly payment from your bank as a transfer from the bank account.
• At the end of the period, the statement balance in Xero should equal the card statement's closing balance (shown as an amount owed).

Our guide to credit card reconciliation explains the logic in more detail.

A worked example

A design studio uses Xero with a bank feed on its business checking account. In April, the statement balance in Xero shows $18,940.12, but the April bank statement closes at $19,190.12. A difference of $250.00.

1. Which side is wrong? The statement balance in Xero doesn't match the bank, so the problem is with the statement lines, not with reconciling.
2. Count the lines. The bank statement shows 84 transactions for April; Xero has 83 statement lines for the same dates.
3. Find the missing one. Comparing the two lists by date, a $250.00 deposit on April 17 is on the statement but not in Xero. The feed had a short outage that day.
4. Fix it. The studio converts the April PDF, keeps only the April 17 deposit in the CSV, and imports that one line. The statement balance now matches.
5. Reconcile the new line. The deposit was a client paying a small invoice; it's matched to that invoice.
6. Run the report. The bank reconciliation report shows the balance in Xero and the statement balance agree with the bank at $19,190.12. April is done.

The key step was the first one. Deciding which side was wrong took a minute and pointed straight to the cause.

Reconciling a backlog

If you've fallen several months behind, the screen can show hundreds of unreconciled lines, and the temptation is to start at the top and click through as fast as possible. A little structure works better.

1. Confirm the statement lines first, month by month. For each month in the backlog, check that the statement balance in Xero at month end equals the bank's closing balance. Fix any missing or duplicated lines before reconciling anything. There's no point matching lines that are about to change.
2. Clear the easy matches. Work through invoice and bill payments that Xero has matched by contact and amount. Check each one, but these go quickly.
3. Set up bank rules for the regulars. Look through the remaining lines for payees that appear every month. Creating five or six rules at this point can clear a large share of a backlog.
4. Do transfers in one pass. Filter to the amounts that move between your own accounts and record them as transfers together, so you can see both sides at once.
5. Leave the oddities for last. Anything you need to ask about goes into a list for your accountant or the business owner, with the date, amount and description.
6. Close each month before moving on. Run the reconciliation report at each month end and confirm it agrees with the statement.

Our catch-up bookkeeping guide covers the wider process of rebuilding months of books, including where Xero fits in.

Working with your accountant or bookkeeper

If someone else reviews your books, agree on a few things up front: who reconciles which accounts, how unexplained items are flagged, and whether periods are locked after review. A shared note listing each account, its feed start date and any imported statements prevents the most common surprises. It also means that if a balance stops matching six months from now, whoever investigates knows exactly where the data came from.

Good habits

• Reconcile weekly or at least monthly. Small batches are easier to check.
• Always compare with the real statement at month end, not just Xero's numbers.
• Never create a transaction to make a difference disappear. Find the cause.
• Keep the PDFs. They're what you'll check against if anything is questioned later.
• Write down feed cutoffs. If you imported history before connecting a feed, record the first feed date so nobody imports over it.

Our month-end close checklist puts reconciliation into a full monthly routine.

Get statements into Xero quickly

If you're catching up from PDF statements, upload them to the bank statement to Xero converter. Each file is checked against the statement's balances, then exported as a CSV in Xero's format, ready to import and reconcile. The free plan covers 3 pages a month; paid plans start at $9 a month.

FAQ

What does reconciling mean in Xero?

It means pairing each bank statement line with a matching transaction in your books, by matching an existing invoice, bill or payment, creating a new transaction, or recording a transfer.

Why doesn't my Xero balance match my bank statement?

First check whether the statement balance in Xero matches the real statement. If not, statement lines are missing, duplicated or wrongly signed. If it does, look for transactions reconciled to the wrong line, duplicates or transfers recorded twice.

What is the bank reconciliation report in Xero?

It's a report that compares the balance in Xero with the statement balance for an account at a date, and lists the items that explain any difference.

Can I reconcile in Xero without a bank feed?

Yes. Import statement files for the account instead. Convert PDF statements to Xero's CSV format first, then reconcile as normal.

How do I fix a transaction reconciled to the wrong line?

Unreconcile it from the account transactions list, then reconcile the statement line again correctly. Check with your accountant before changing locked or reported periods.

How often should I reconcile in Xero?

At least monthly, and weekly if you have many transactions. Smaller batches make mistakes easier to spot.