How to Reconcile a Bank Account in Xero
A practical walkthrough of the Xero reconciliation process — from importing transactions to confirming matches and fixing common problems.
Bank reconciliation is one of the most important bookkeeping tasks for any business. It helps ensure that the transactions recorded in your accounting software match the activity shown in your bank account.
If you're using Xero, regular reconciliation helps maintain accurate financial records, improve reporting accuracy, and identify potential bookkeeping errors before they become larger problems.
In this guide, you'll learn how to reconcile a bank account in Xero step by step.
📘 Want to compare all your software options in one place? Visit our Accounting Software Guide for Small Businesses.
What is bank reconciliation in Xero?
- It compares transactions imported from your bank with records entered in Xero
- The goal is to confirm every transaction has been recorded correctly
- Xero suggests matches automatically using bank feeds
- Regular reconciliation improves financial accuracy and report reliability
What Is Bank Reconciliation?
Here's the simplest way to think about it.
Bank reconciliation is the process of comparing transactions recorded in Xero with transactions appearing on your bank statement. The goal is to confirm that every transaction has been recorded correctly.
When reconciliations are performed regularly, financial reports become more reliable and bookkeeping mistakes are easier to identify and fix early.
Why Bank Reconciliation Is Important
Regular reconciliation is not just a housekeeping exercise — it directly affects the quality of your financial information.
Why does bank reconciliation matter for small businesses?
- Maintains accurate financial records across all accounts
- Identifies missing or unrecorded transactions quickly
- Detects duplicate entries before they distort reports
- Improves cash flow visibility for better decision-making
- Supports tax preparation by keeping records clean and complete
- Produces more reliable financial reports throughout the year
Many businesses reconcile their accounts weekly or monthly. The more frequently you reconcile, the easier it is to catch and correct any issues.
Before You Start
A little preparation goes a long way.
Before reconciling your bank account in Xero, make sure:
- Your bank account is connected to Xero (if using bank feeds)
- All recent transactions have been imported
- Supporting documents are available if needed
- Opening balances are correct
Having accurate data in place makes the reconciliation process significantly faster and more straightforward.
Step-by-Step: How to Reconcile in Xero
Open the Bank Account in Xero
From the Xero dashboard, select Accounting → Bank Accounts, then choose the bank account you want to reconcile. You will see a summary of imported bank transactions and unreconciled items.
Review the Reconciliation Screen
The reconciliation screen displays two key elements side by side:
Bank Statement Line — the transaction imported from your bank (customer payments, supplier payments, bank fees, interest received).
Suggested Match — Xero will attempt to automatically match the imported transaction to an existing record already in the system.
Confirm Suggested Matches
When Xero finds a matching transaction, review the suggested match carefully. Verify the amount, date, and payee before clicking OK. The transaction will then be marked as reconciled.
Don't accept matches automatically — always review before confirming.
Create a New Transaction if Needed
If Xero cannot find a matching transaction, use the Create option to enter the payee, account code, description, and tax treatment. Once entered, reconcile the transaction directly from that screen.
Match Existing Transactions
Sometimes transactions have already been entered manually — such as sales invoices, supplier bills, or expense claims. Use Find & Match to locate the existing transaction and confirm the match. This prevents duplicate entries from appearing in your records.
Review Bank Rules
For recurring transactions such as software subscriptions, utility bills, loan payments, or merchant fees, bank rules allow Xero to automatically suggest transaction coding based on predefined criteria. This saves significant time on routine reconciliation tasks.
Complete the Reconciliation
Continue reviewing transactions until all imported items have been reconciled. The goal is to have no unreconciled transactions remaining unless legitimate timing differences exist — such as outstanding cheques or payments in transit.
🧠 Memory Trick: The Three-Check Rule
Before clicking OK on any suggested match, always check three things: Amount, Date, and Payee. If all three match, you can reconcile with confidence. If any one of them is off, investigate before proceeding.
Common Reconciliation Problems in Xero
Even experienced bookkeepers run into these.
Duplicate Transactions
Often caused by manual entries combined with bank feed imports, or duplicate invoice entries. Always verify transactions carefully before reconciling to avoid double-counting income or expenses.
Missing Transactions
If transactions appear on the bank statement but not in Xero, check bank feed imports, review manually entered records, and verify transaction date ranges. Bank feed delays can sometimes cause temporary gaps.
Incorrect Coding
Transactions may be assigned to the wrong account code — for example, equipment coded as office expenses, or loan repayments coded as ordinary expenses. Incorrect coding affects the accuracy of financial reports and tax calculations.
Opening Balance Errors
An incorrect opening balance can create ongoing reconciliation discrepancies that compound over time. If differences persist despite correct transaction entries, review historical records and opening balance settings in Xero.
For a deeper look at why your numbers might not line up, see Why Your Bank Balance Doesn't Match Your Accounting Software.
Best Practices for Bank Reconciliation in Xero
| Best Practice | Why It Matters |
|---|---|
| Reconcile frequently | Weekly or monthly reconciliations are far easier than catching up over several months |
| Review transactions carefully | Don't automatically accept suggested matches without checking amount, date, and payee |
| Keep supporting documents | Maintain receipts and invoices for important transactions in case queries arise |
| Use bank rules wisely | Bank rules improve efficiency but should be reviewed periodically to stay accurate |
| Investigate differences promptly | Small discrepancies are much easier to resolve when discovered early |
For a complete monthly bookkeeping routine, see the Monthly Bookkeeping Checklist for Small Business Owners.
Conclusion
Bank reconciliation is one of the most important bookkeeping tasks for maintaining accurate financial records. Xero simplifies the process by importing transactions, suggesting matches, and providing reconciliation tools that help identify errors quickly.
By reconciling accounts regularly — and reviewing each transaction carefully before confirming — businesses can improve reporting accuracy, strengthen financial controls, and gain greater confidence in their financial information.
If you're managing your own bookkeeping, making reconciliation a weekly habit is one of the best investments of time you can make in your business finances. Learn more about What Financial Reports Small Businesses Should Review Monthly to get the most from your Xero data.
Key Takeaways
- Bank reconciliation compares Xero records with your actual bank activity
- Regular reconciliation improves the accuracy of all financial reports
- Xero can automatically suggest transaction matches using bank feeds
- Bank rules help automate the coding of recurring transactions
- Duplicate and missing transactions are the most common causes of discrepancies
- Always verify amount, date, and payee before confirming any match
- Frequent reconciliation prevents bookkeeping problems from compounding
Frequently Asked Questions
Most businesses should reconcile accounts at least monthly. Weekly reconciliation is beneficial for businesses with higher transaction volumes, as it keeps records current and makes it easier to catch errors early.
Xero allows reconciliations to be reviewed and corrected if mistakes are identified. You can unreconcile a transaction and re-match it to the correct record without losing data.
Xero can suggest matches and apply bank rules to speed up the process, but transactions should still be reviewed before approval. Automation assists — it doesn't replace careful review.
Possible causes include bank feed delays, connection issues between Xero and your bank, or incorrect date ranges being selected. Check the bank feed status in Xero settings if transactions are missing.
Bank reconciliation ensures that your accounting records accurately reflect actual bank account activity. It helps identify errors, prevent fraud, and maintain the integrity of your financial reports.
About the Author
Ishara Vithana is a Xero Certified Advisor and Partner, Dext Certified Expert, and Fathom Advisor. Through Finance Made Simple, he helps small business owners and DIY bookkeepers understand accounting, bookkeeping, and business finance with practical, easy-to-follow guides.
Connect with Ishara →Start Your Bookkeeping the Right Way
Download our Free Small Business Bookkeeping Starter Pack — practical templates and resources designed for small business owners.
Download Free Starter Pack →
Comments
Post a Comment