Xero bank balance doesn't match your statement? What to check

When Xero and your bank show different balances, first identify which balances you are comparing and for what date. A live bank balance, an imported statement balance and the accounting balance in Xero can differ for different reasons. Making an adjustment before identifying the cause can hide the problem.

This guide is for Canadian business owners working through a specific difference. For ongoing responsibilities and support, see our Xero bookkeeping guide.

Start with the same account and date

Take the bank’s statement for the account you are reviewing. Note the account, currency, closing date and closing balance. Compare Xero at that date, rather than comparing last month’s records to today’s available bank balance. Pending bank activity may not yet be posted to the statement.

Write the difference down. For example: “CAD chequing, September 30, bank statement $8,420, imported statement balance $8,170, difference $250.” Keeping the question specific makes it easier to check whether a correction actually resolved it.

Is the imported statement balance wrong?

Xero’s statement-balance troubleshooting guidance identifies opening balances and statement-line errors as key checks when the same-date balances disagree.

Find the last date they agreed, then narrow the review to the first period with a difference. Compare the bank’s statement with Xero’s Bank Statement report. Look for gaps in the import, duplicate lines, deleted lines and manual statement lines. The Statement Exceptions report can help with that review.

Keep a list of the specific lines involved. Confirm how each arose before importing missing activity or correcting a duplicate. Review conversion balances with your bookkeeper if the discrepancy begins when the file was first set up; an opening-balance change affects everything that follows.

Or does the accounting balance need explaining?

Once imported statement activity agrees with the bank, review how it connects to the accounting transactions. A recorded payment may not yet have cleared, or an imported deposit may be waiting to match an invoice payment. Xero’s reconciliation instructions cover matching statement lines to existing entries.

Do not create new sales simply because an invoice payment is not suggested automatically. Search for the existing transaction first. For the underlying principle, see bank reconciliation explained.

A CAD example: a timing difference versus missing activity

Consider a fictional Canadian consulting business with a September 30 bank statement balance of $8,420.

Scenario A: the imported statement balance is $8,170. A $250 customer deposit appears on the bank statement but is missing from the imported statement lines. Investigate the missing import. If the invoice and payment are already recorded, adding another $250 sale would duplicate income rather than solve the import problem.

Scenario B: imported statement activity agrees at $8,420, but the accounting balance is $8,120. A valid $300 supplier payment is recorded but has not cleared the bank. That could explain the difference: $8,420 − $300 = $8,120. Confirm the payment, document it as outstanding and follow it into the next statement.

These examples illustrate different investigations; they do not establish what caused a difference in your file. Review every item in the reconciliation, including other outstanding receipts or payments. Xero’s Canadian bank reconciliation guide explains how timing differences enter the reconciliation.

What to gather before asking for help

Prepare the relevant bank statements, the last completed reconciliation, a list of known missing or duplicate activity, and the dates when the balances last agreed. Keep supporting invoices and receipts for transactions whose treatment is unclear.

If several months are affected, start with the oldest unresolved period. If a correction would affect a closed period or figures already used for GST/HST or year-end, review it with your bookkeeper or accountant first. Do not post an unexplained balancing entry or bulk-delete transactions to make the difference disappear.

For business cards, use the separate credit-card reconciliation guide, which covers payments, refunds and statement dates.

Get the difference reviewed

Avora offers reconciliation support and cleanup and catch-up bookkeeping for Canadian businesses. The free Bookkeeping Health Check can help you identify which routines need attention, but it does not diagnose a specific Xero error.

Tell us which account and period need review. Describe the issue first; share statements through an agreed secure channel after the initial conversation.

Reviewed October 14, 2026. General bookkeeping guidance. Use Xero’s current documentation for the features and reports available in your account.