Why Does My Xero Balance Differ From My Bank Statement? How to Find and Fix the Difference

Last updated: 25 October 2026.

It is one of the most common bookkeeping frustrations: you log in to your bank, see one number, open Xero, and see another. Sometimes the difference is a few dollars; sometimes it is thousands. The good news is that the cause is nearly always one of a short list, and Xero has reports built to find it.

This guide explains the balances Xero shows, why they differ from the bank, and a practical method to track the gap down. The Xero features described were checked against Xero Central on 25 October 2026. Screens and menus change, so treat this as a guide and check Xero Central if something looks different.

The short version: work out first which two numbers disagree. If the Statement balance (calculated) in Xero is wrong, then statement lines are missing, duplicated, deleted or the opening balance is off. If the statement balance is right but the Balance in Xero is different, then you have transactions that are entered but not reconciled, or bank statement lines you have not yet matched.

First, which balance is different?

Xero’s own documentation says that if your transactions and reconciliation are up to date on a given date, three numbers should agree: your Balance in Xero, the Statement balance (calculated) and the balance in your online banking for that day. Xero defines them as follows.

Number	What it is
Balance in your online banking	What the bank says you have, as at the date you are checking
Statement balance (calculated)	The sum of all bank statement lines imported into Xero as at the report date. Xero says it is not taken from your online bank balance; it is calculated using the statement lines in Xero.
Balance in Xero	The sum of all bank transactions entered in Xero for that account, dated on or before the report date
Total Outstanding Payments/Receipts	Transactions entered in Xero that are not yet reconciled to a statement line
Total Unreconciled Statement Lines	Statement lines imported but not yet reconciled

That gives two separate questions. (1) Does Xero’s statement balance match the bank? If not, the data coming in is wrong. (2) Does the Balance in Xero match the statement balance? If not, there are unreconciled items on one side or the other.

Step 1: run the Bank Reconciliation Summary

In Xero, go to Reporting, then All reports, and open the Bank Reconciliation report pack. Xero says this pack groups three reports: Bank Reconciliation Summary, Bank Statement and Statement Exceptions, and that if your balances do not match you can use it to check for missing, deleted or duplicated transactions.

1. Choose the bank account and a pack date range. Reports that show balances at a point in time, such as the Summary, run as at the last day of the date range.
2. On the Summary, enter the Bank statement ending balance, which should be the balance in your online banking on the report date.
3. Look at Calculated balance out by. Xero defines it as the difference between the bank statement ending balance you entered and the Statement balance (calculated).

If Calculated balance out by is not zero, go to the next section. If it is zero, skip to “The statement balance is right, but Balance in Xero is different”.

The statement balance is wrong: common causes

The statement balance is built from the statement lines in Xero, so it is wrong when lines are missing, doubled or removed, or when it starts from the wrong figure.

1. Missing statement lines

Bank feeds do not always bring in everything straight away. Xero says it relies on banks to make recent transactions available for import and cannot guarantee that transactions will be available as soon as they show in your online banking. Most credential-shared (Yodlee) feeds need manual refreshing. If you import statements manually, a missed file leaves a gap. Compare the date of the last statement line in Xero with your bank, then check for gaps in dates.

2. Duplicate statement lines, often from “Mark as reconciled”

Xero has an option to manually mark a transaction as reconciled when a statement line is missing. When you do, Xero creates a new bank statement line to reconcile against. Xero warns that if the actual statement line shows in the bank account and the transaction is manually marked as reconciled, your bank balance will not match online banking because of a duplicate statement line. The same happens if you mark as reconciled and then later import the real line. Xero says to find duplicates in the Bank statements tab and delete the line with User in the Bank Transaction Source column.

3. Deleted statement lines and potential duplicates

The Statement Exceptions report is made for this. Xero says it shows statement lines created by marking transactions as reconciled, deleted statement lines, and all lines Xero has identified as potential duplicates, whether or not they have been deleted. If your balance is out by the amount of one transaction, start here.

4. A wrong opening or conversion balance

If the account was opened in Xero or migrated from another system, the starting figure matters. Xero’s conversion guidance says the conversion date is always the first of a month, and that the conversion balance for an account is the closing balance of that account in your previous system on the day before the conversion date. A bank account’s opening balance in Xero must match that closing figure. If it does not, every month after will be out by the same amount, which is a useful clue: a constant difference that never changes usually points to the opening balance, not a single transaction.

5. Credit card sign errors

Xero’s reconcile-period instructions say that for credit card accounts you enter negative opening and closing balances, including the minus sign (for example, -200). Entering a card balance as a positive number is an easy way to create a large, confusing mismatch.

6. Statement lines from the wrong account or wrong period

A file imported into the wrong account, or the same file imported twice, will distort the statement balance. The Bank Statement report shows the date each statement line was imported and its source (manual import, bank feed, or created by a user marking a transaction as reconciled), which helps you see what came from where.

The statement balance is right, but Balance in Xero is different

If Xero’s statement balance agrees with the bank but the Balance in Xero does not, the difference is made up of items that have not been matched. The Summary lists them in two groups.

• Outstanding payments and receipts: transactions entered in Xero (invoice payments, spend money, receive money) with no statement line matched. These are often payments recorded by hand that have not yet cleared, or entries that were made twice.
• Unreconciled statement lines: bank lines that have arrived but have not been matched to anything in Xero.

Common reasons include:

• Timing. A payment dated in one month that clears the bank in the next. Xero notes that a reconciled statement line or account transaction matched to a future-dated item will appear in the report as unreconciled, because the report does not recognise a match if the line or transaction is dated after the report date. Moving a report date by a day can change the result.
• Payments entered but never reconciled, for example an invoice marked as paid in Xero against the wrong account, or a payment entered twice (once from the invoice and once from the bank line).
• Transactions entered against the wrong bank account. This is common where a business has several accounts or cards.
• Unreconciled statement lines left in the Reconcile tab.

The “Outstanding” list in Xero’s Reconcile period tool shows account transactions dated in the period that have not been reconciled to a statement line. Xero says to reconcile them to a statement line, or, if a statement line is genuinely missing, to manually mark the transaction as reconciled.

A step-by-step method to find the gap

This is the method we use, based on Xero’s reports. It is our approach rather than an official Xero procedure.

1. Find the last date everything agreed. Run the Bank Reconciliation Summary at the end of each month, working backwards, with the bank’s closing balance for that date. The last month where Calculated balance out by is zero is your starting point.
2. Narrow it to the month the difference appeared. If it was zero at 30 June and out by $450 at 31 July, the problem is in July.
3. Compare the difference to what you see. Is it the exact amount of one transaction (missing or duplicate line)? Twice an amount (a sign error or a duplicate)? A round number such as a bank fee? The same amount every month (opening balance)?
4. Run Statement Exceptions for the month to see user-created lines, deleted lines and potential duplicates.
5. Run the Bank Statement report and check source and import date for anything odd.
6. Fix the cause: import the missing lines, delete the duplicate, correct the opening balance, or reconcile the outstanding items.
7. Confirm and lock it in. Re-run the Summary. Then use Reconcile period for the month: Xero says you can close a period only when balances match and all transactions in it are reconciled, and once closed, transactions in that period cannot be deleted or unreconciled (you can still edit account codes). If you must change a closed period, Xero lets you edit it, which returns it to draft.

Why this matters beyond neatness

Your BAS is only as good as the records behind it. The ATO tells businesses to regularly reconcile their banking records so they understand exactly what money goes through the account and why, and says reconciliation helps you be more confident your records contain what you need for your activity statements and reduces the time to prepare them. A bank account that does not reconcile can hide missing sales, duplicated expenses or wrongly claimed GST. If the problem has built up over several months, our guide to catching up overdue bookkeeping and BAS shows how to get back on track. Clean, reconciled books also make profit reports meaningful, as we explain in why a profitable business can run out of cash.

Preventing it next time

• Reconcile at least monthly, and before every BAS.
• Only manually mark a transaction as reconciled when you cannot import the real line; Xero says to identify why the line is missing first.
• Do not enter a payment manually if the bank line is already in the Reconcile tab; match it instead.
• Check your feed is active and refreshed. Xero says some feeds need manual refreshing.
• Close periods once they balance, so completed months cannot be changed by accident.
• Keep the bank’s closing balance for each month in your working papers.

How we help

If your Xero file will not reconcile, we can find the cause and put it right, then keep it reconciled monthly. See our bookkeeping services and BAS agent services, or email info@guidancegrowth.com.au or use our get in touch page.

Frequently asked questions

What is the difference between ‘Balance in Xero’ and ‘Statement balance’?

Xero says Balance in Xero is the sum of all bank transactions entered for the account dated on or before the report date. Statement balance (calculated) is the sum of all imported bank statement lines as at that date, calculated from the lines in Xero rather than taken from your online banking.

Why does my Xero balance not match my bank even though everything is reconciled?

If every statement line is reconciled but the balances still differ, the statement balance itself is probably wrong: a missing or duplicate statement line, a deleted line or a wrong opening balance. Run the Bank Reconciliation Summary and Statement Exceptions reports.

What does ‘Calculated balance out by’ mean?

Xero defines it as the difference between the bank statement ending balance you entered at the top of the report and the Statement balance (calculated). A non-zero amount means the statement lines in Xero do not add up to the bank’s balance.

Why do I have a duplicate bank statement line?

Xero says that if you manually mark a transaction as reconciled and the real statement line is also present or imported later, you get a duplicate. Delete the line that shows User in the Bank Transaction Source column.

How do I stop this happening again?

Reconcile regularly, avoid marking transactions as reconciled unless you cannot import the real line, check feeds are refreshed, and close periods once they balance.

Sources and further reading

• Xero Central: Bank Reconciliation reports (checked 25 October 2026)
• Xero Central: Reconcile and close a period (checked 25 October 2026)
• Xero Central: Manually mark a transaction as reconciled (checked 25 October 2026)
• Xero Central: About bank feeds (checked 25 October 2026)
• Xero Central: Convert to Xero from another accounting system (checked 25 October 2026)
• ATO: Banking records for business (checked 25 October 2026)

This article is general information, not personal advice. Rules and dates can change, so check ato.gov.au or acnc.gov.au for the latest, or speak to us about your situation.