Xero Bank Reconciliation: A Practical Small Business Guide

Q: How do you do a bank reconciliation in Xero?

Go to Accounting > Bank Accounts, click Reconcile [number] items, then match each statement line to a Xero transaction using OK (suggested match), Match (multiple invoices), Create (new transaction), or Transfer (internal movement). Run the Bank Reconciliation Summary when the counter reaches zero to confirm balances agree.

Key Takeaways

Xero bank reconciliation works best when bank feeds, bank rules, and a weekly review routine run together, with a monthly Bank Reconciliation Summary retained as your audit trail.

Point	Details
Use the Reconcile screen	Match every statement line using Match, Create, or Transfer before closing a period.
Automate with bank feeds and rules	Bank feeds and suggested matches can cut manual reconciliation work by up to 75%.
Reconcile weekly, not monthly	Weekly reconciliation catches errors before they compound and distort your tax return.
Run reports every month	The Bank Reconciliation Summary and Reconciliation History are your audit trail for IRS purposes.
Tolliver Bookkeeping and Tax	As a Xero Silver Partner, Tolliver handles setup, migration, and monthly reconciliation for Kern County businesses.

What does bank reconciliation in Xero actually mean?
How to reconcile a bank account in Xero, step by step
How bank feeds, suggested matches, and bank rules speed up reconciliation
Reconciling credit cards, multi-invoice payments, foreign currency, and fees
How to find and fix common reconciliation problems
Which Xero reports confirm your reconciliation is correct?
How often should you reconcile, and what mistakes should you avoid?
How Tolliver Bookkeeping and Tax approaches Xero reconciliation
What most reconciliation advice gets wrong
Xero reconciliation support from Tolliver Bookkeeping and Tax
Sources
FAQ

What does bank reconciliation in Xero actually mean?

Bank reconciliation in Xero is the process of matching every line on your bank statement to a corresponding transaction in Xero, so your Xero balance and your actual bank balance agree after accounting for any outstanding items. It is also one of the most reliable internal controls a small business can run, because it catches miscoded expenses, duplicate entries, and unauthorized charges before they distort your financial statements or your tax return.

Two distinct objects live in the Reconcile screen, and confusing them is the most common source of frustration:

Statement lines: These come from your bank feed (a live connection Xero maintains with your bank) or from a manually imported file (OFX, CSV, QIF). They represent what your bank actually recorded.
Xero transactions: These are the invoices, bills, payments, and manual journal entries already in Xero. They represent what you recorded.

Reconciliation closes the gap between the two.

A few Xero-specific terms worth knowing before you start:

Suggested match: Xero compares amounts and dates and proposes the most likely Xero transaction for each statement line. You confirm or override it.
Bank rules: Saved criteria (contact name, keyword, amount range) that tell Xero how to code recurring statement lines automatically.
Cash coding: A spreadsheet-style bulk-coding view for high-volume accounts with many similar transactions.
Clearing accounts: Temporary holding accounts used when money moves between accounts or payment services before it settles.
Payment Services: Third-party processors (Stripe, Square, PayPal) that batch deposits; their clearing accounts reconcile the gross deposit against individual sales.

reconciliation guide. Frequent reconciliation is the single most effective way to keep your books accurate. Weekly is the practical minimum for most small businesses; daily works best for high-volume operations.

Pro Tip: Reconciling weekly rather than monthly cuts your error-hunting time dramatically. A one-week discrepancy is far easier to trace than a 30-day one.

How to reconcile a bank account in Xero, step by step

Xero Central’s reconciliation workflow follows a Prepare → Review → Match/Create/Transfer sequence. Here is exactly how to move through it.

Step 1: Prepare

Go to Accounting > Bank Accounts on the Xero dashboard.
Confirm the opening balance for the period matches your bank statement’s opening balance.
Check that your bank feed is active and current. If statement lines are missing, import a file manually (OFX or CSV) from your bank’s download center.
Gather supporting documents (receipts, invoices, remittance advice) before you start so you can code new transactions without interruption.

Step 2: Review statement lines

Click Reconcile [number] items on the bank account tile. The Reconcile screen opens with statement lines on the left and Xero’s suggested matches on the right. The reconciliation counter at the top shows how many lines remain.

Step 3: Match, Create, or Transfer

This is where the real work happens. Three tabs handle every scenario:

Match: Xero suggests a transaction. If it is correct, click OK. If one bank deposit covers several invoices, click Match, tick each invoice until the total equals the statement line amount, then confirm.
Create: No match exists. Click Create, fill in the contact, account code, and tax rate, and save. Use this for bank fees, cash sales, or subscription charges that were never invoiced.
Transfer: Money moved between two of your own accounts (e.g., checking to savings, or a credit card payment from your business checking). Transfer nets the movement to zero across both accounts so it does not inflate income or expenses.

For accounts with many similar card transactions, switch to the Cash coding tab. It presents statement lines in a spreadsheet grid where you can assign account codes and tax rates to dozens of rows at once, then save them all in one click.

Pro Tip: Use the Tab key to move between fields in the Create form and the Enter key to confirm a match. On a busy reconciliation session, keyboard navigation cuts the time per transaction by roughly half.

Statistic: Xero’s bank reconciliation guide reports that using bank feeds and suggested matches can significantly reduce manual reconciliation work compared to entering transactions by hand.

Step 4: Verify

Once the counter reaches zero, Xero marks the account as reconciled. Run the Bank Reconciliation Summary (Accounting > Reports) to confirm the closing balance matches your bank statement. If they match, you are done.

How bank feeds, suggested matches, and bank rules speed up reconciliation

The fastest path through a reconciliation session is one where Xero has already done most of the thinking. That requires three things working together: a live bank feed, well-tuned suggested matches, and a set of bank rules for recurring items.

Bank feeds connect directly to your financial institution and pull statement lines into Xero automatically, usually overnight. To set one up or reauthorize a stopped feed, go to Go and search for your bank. If a feed stops refreshing, reauthorize it from the bank account settings before importing a manual file as a stopgap.

Suggested matches work by comparing the statement line’s amount, date, and reference against open Xero transactions. When the match is obvious (same amount, same day, same contact), Xero presents it pre-selected. You click OK and move on. When the match is ambiguous, Xero shows multiple candidates and you choose.

Bank rules are where the real time savings compound. A rule tells Xero: “Whenever a statement line contains the word ‘Comcast’ and the amount is between $80 and $120, code it to Utilities, assign it to the Internet expense account, and mark it as reconciled.” Once saved, that rule fires automatically on every future import.

Good candidates for bank rules:

Monthly software subscriptions (Adobe, QuickBooks migration fees, Slack)
Recurring supplier charges with consistent descriptions
Payroll processor deposits with a standard reference code
Regular rent or lease payments

Pro Tip: Run a new bank rule for two or three cycles before trusting it fully. Pull the Reconciliation History after each session and spot-check that the rule coded transactions correctly. A rule with a description keyword that is too broad can mis-code unrelated transactions.

As Xero Central documents, the Reconcile screen surfaces all three tabs (Match, Create, Transfer) alongside the Cash coding option, giving you the right tool for every statement line without leaving the screen.

Reconciling credit cards, multi-invoice payments, foreign currency, and fees

Credit card accounts

Xero treats a credit card account exactly like a bank account. Connect a feed or import a statement, then reconcile charges using Match or Create. When you pay the card balance from your business checking account, use Transfer in both accounts: it records the outflow from checking and the inflow to the card account, netting to zero.

Finance charges and annual fees have no corresponding invoice in Xero, so use Create and code them to a Bank Charges or Interest Expense account.

Multiple-invoice payments and lump-sum receipts

When a customer pays several invoices in one wire transfer:

Click Match on the statement line.
Tick each open invoice until the running total equals the bank amount.
Confirm. Xero marks all selected invoices as paid and clears the statement line.

For a partial payment, enter the amount received in the payment field and leave the remaining balance open as a receivable.

Foreign currency transactions

Xero displays FX transactions in both the foreign currency and the USD equivalent at the exchange rate on the transaction date. The difference between the rate at invoice date and the rate at payment date becomes a realized gain or loss, which Xero posts automatically to your Foreign Currency Gains/Losses account. Review that account monthly to confirm the amounts are reasonable, and reconcile it against your bank’s FX confirmation if the amounts are material.

Pro Tip: Always verify FX amounts against the bank statement’s USD settlement figure, not the foreign-currency amount. Banks sometimes apply a spread that differs from Xero’s rate, creating a small residual that needs a manual Create entry coded to Bank Charges.

Bank fees and micro-transactions

Use Create for any fee that has no existing Xero transaction: wire fees, monthly service charges, NSF fees. Code them to a Bank Service Charges account (or equivalent) so they appear consistently in your P&L and are easy to identify at tax time. Accurate coding here matters because bank fees are generally deductible under IRS rules, but only if they are recorded to the correct account.

You can also manually mark a transaction as reconciled when no imported bank statement exists, which is useful for petty cash accounts or accounts where a feed is unavailable.

How to find and fix common reconciliation problems

A reconciliation that won’t balance almost always has one of four causes. Work through them in this order before making any adjustments.

Check Reconciliation History first. Go to Accounting > Bank Accounts, click the account, then select Reconciliation History. Look for any transaction that was edited or deleted after it was previously reconciled. That edit breaks the prior balance and cascades forward.
Confirm the opening balance. The opening balance in Xero for the period must match the closing balance on your bank statement for the prior period. A mismatch here means every subsequent period will be off by the same amount.
Search for duplicates. Filter the account register by amount and look for two identical entries on the same date. Duplicate imports are the most common cause of a balance that is off by an exact transaction amount.
Check for missing statement lines. If your bank feed skipped a day, import the missing range as an OFX or CSV file. Xero will deduplicate lines it already has.
Look for unreconciled transfers. A Transfer that was recorded on one side but not the other leaves a dangling balance. Find it in the account register and complete the matching entry.

Pro Tip: Before you undo a reconciled transaction, check whether it affects a period that has already been reported to the IRS or used in a tax filing. Editing a reconciled item in a closed period can create discrepancies in your financial statements. When in doubt, post a correcting journal entry instead.

If your bank feed has stopped entirely and you cannot identify the cause, check Status for known outages before spending time on internal troubleshooting.

Common fixes by symptom:

Balance off by a round number: Usually a missing transaction or a duplicate. Search by that exact amount.
Balance off by a small odd amount: Often an FX rounding difference or a bank fee coded to the wrong account.
Statement lines not appearing: Feed stopped or file import failed. Reauthorize the feed or re-import the file.
“Reconciled” but balance still wrong: An edited or deleted transaction in a prior period. Check Reconciliation History.

Which Xero reports confirm your reconciliation is correct?

Three reports do the heavy lifting for month-end review and audit purposes, as documented in Xero Central’s Bank Reconciliation reports:

Report	What it confirms	When to use it
Bank Reconciliation Summary	Xero balance vs. bank statement balance for a period	Month-end close; before filing taxes
Reconciliation History	Who reconciled or edited each transaction and when	Audit trail review; investigating discrepancies
Bank Statement report	Full list of statement lines imported for a date range	Verifying feed completeness; spotting gaps

Internal controls that actually hold up

Reconciliation is not just a balancing exercise. It is a fraud-prevention control, and its effectiveness depends on who does it and how often.

The most important control for small teams is segregation of duties: the person who enters transactions should not be the same person who reconciles the account. When one person does both, errors and unauthorized transactions can be concealed. If your team is too small to separate these roles completely, a second reviewer (an owner, a partner, or an outside bookkeeper) should sign off on the reconciliation report monthly.

Practical controls for small businesses:

Set an approval threshold: any transaction above a set dollar amount requires a second sign-off before reconciliation.
Retain a printed or PDF copy of the Bank Reconciliation Summary for each month. The IRS can request records going back several years, and a clean reconciliation history is your first line of defense.
Document your reconciliation checklist and keep it consistent. Inconsistent procedures are harder to defend in an audit than a simple, documented routine.

Pro Tip: Save a PDF of the Bank Reconciliation Summary immediately after closing each month. Store it in a dedicated folder alongside your bank statements. If the IRS ever questions a deduction, you can produce a clean paper trail in minutes rather than reconstructing it from memory.

How often should you reconcile, and what mistakes should you avoid?

Recommended cadence:

Daily: High-volume businesses (retail, restaurants, laundromats) where cash and card transactions are numerous and errors compound quickly.
Weekly: The practical standard for most small businesses. Catches errors before they become month-end problems.
Monthly minimum: Acceptable only for very low-volume accounts, and only if you reconcile before filing any tax return or producing financial statements.

A monthly checklist for business owners:

Confirm the bank feed is current and all statement lines are imported.
Run the Bank Reconciliation Summary and compare it to the bank statement closing balance.
Review the Reconciliation History for any edits made to previously reconciled transactions.

A weekly checklist for bookkeepers:

Open the Reconcile screen and clear all pending statement lines using Match, Create, or Transfer.
Review any bank rule suggestions that were auto-applied and spot-check three to five for accuracy.
Flag any unreconciled items older than seven days for follow-up.

Mistakes that cost the most time:

Mixing personal and business transactions in the same account. Every personal charge requires a manual coding decision and slows every reconciliation session.
Delaying reconciliation until year-end. A 12-month backlog can take days to untangle and often requires reconstructing records that no longer exist.
Trusting bank rules without periodic review. Rules that made sense six months ago may now mis-code transactions if a vendor changed their billing description.
Using Create when Transfer is correct. Recording an internal account movement as income or expense inflates your P&L and distorts your tax return.

How Tolliver Bookkeeping and Tax approaches Xero reconciliation

As a Xero Silver Partner serving Kern County businesses for over two decades, the Tolliver Bookkeeping and Tax team handles reconciliation as a monthly discipline, not an afterthought. We set up bank feeds, build bank rules tailored to each client’s vendor list, and review Reconciliation History every month to catch edits before they become problems. Clients share documents securely through our Client Hub portal, so supporting receipts are matched to statement lines without email chains or missing attachments. For new clients, we handle the Xero migration at no cost and configure the reconciliation workflow from day one.

What most reconciliation advice gets wrong

The standard advice is to reconcile monthly and use bank rules for everything. Both are fine as far as they go, but they miss the two points that actually matter for small businesses.

First, monthly reconciliation is too slow to be a real control. By the time you catch a miscoded expense or a duplicate charge at month-end, it has already affected your cash position for weeks. Weekly reconciliation is not a luxury for organized businesses; it is the minimum frequency at which reconciliation functions as a genuine error-detection tool rather than a cleanup exercise.

Second, bank rules are powerful but not self-managing. The businesses that get into trouble with Xero reconciliation are almost never the ones who avoid automation. They are the ones who set up rules, trust them completely, and stop reviewing the output. A rule that mis-codes a transaction does not announce itself. It quietly inflates an expense account or misclassifies income, and you find it six months later when the numbers don’t match your tax return. The fix is simple: review a sample of auto-coded transactions every week, not just when something looks wrong.

The most underrated reconciliation habit is retaining the Bank Reconciliation Summary as a dated PDF every single month. It takes 30 seconds, and it is the document that makes an IRS inquiry manageable instead of stressful. Clean books and accurate tax reporting are not separate goals; they are the same goal, and reconciliation is what connects them.

Xero reconciliation support from Tolliver Bookkeeping and Tax

Clean books start with a working reconciliation setup, and that setup takes longer to get right than most business owners expect.

Tolliver Bookkeeping and Tax handles the full reconciliation workflow for small and medium-sized businesses in Kern County: bank feed setup, bank rule configuration, monthly reconciliation, and the Xero migration at no cost. Every client gets a dedicated bookkeeper who reviews Reconciliation History monthly and flags discrepancies before they reach your tax return. Documents move through a secure Client Hub portal, so nothing gets lost between your bank statement and your books.

If you are running reconciliation yourself and hitting problems, or if you have never set up a proper workflow in Xero, the right next step is a conversation. Visit the Tolliver bookkeeping services page to see what a managed reconciliation engagement looks like, or check service pricing to understand what monthly bookkeeping costs for a business your size.

Sources

This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.

FAQ

How do you do a bank reconciliation in Xero?

Go to Accounting > Bank Accounts, click Reconcile [number] items, then match each statement line to a Xero transaction using OK (suggested match), Match (multiple invoices), Create (new transaction), or Transfer (internal movement). Run the Bank Reconciliation Summary when the counter reaches zero to confirm balances agree.

Can Xero automatically reconcile transactions?

Full auto-reconciliation without human review is not recommended because rules can mis-code transactions if vendor descriptions change.

What is a statement line in Xero reconciliation?

A statement line is a transaction imported from your bank, either through a live bank feed or a manually uploaded file. It represents what your bank recorded, and reconciliation matches it to what Xero recorded.

What should I do if my Xero balance doesn’t match my bank statement?

Check Reconciliation History for edited or deleted transactions, confirm the opening balance for the period, search for duplicate imports, and look for unreconciled transfers. If the feed has stopped, check status.xero.com for outages before troubleshooting internally.

How does Tolliver Bookkeeping and Tax help with Xero reconciliation?

As a Xero Silver Partner, Tolliver Bookkeeping and Tax sets up bank feeds, configures bank rules, and handles monthly reconciliation for small businesses in Kern County, including Xero migration at no cost. Contact the team through the bookkeeping services page to get started.