How to Reconcile Bank Feeds in Xero (Without Losing Your Mind)

What Is Bank Reconciliation in Xero?

Bank reconciliation is the process of matching the transactions in your Xero accounting file to the transactions on your actual bank statement. It is one of the most fundamental bookkeeping tasks, and if you get it wrong, your financial reports become unreliable.

Xero simplifies reconciliation by pulling in live bank feeds directly from your bank. Instead of manually entering every transaction, you review each feed item, match or categorise it, and confirm. Done well, you can reconcile hundreds of transactions in minutes rather than hours.

But bank reconciliation still trips up a lot of small business owners. Duplicates, missing transactions, unexplained differences, and confusing suggested matches can turn a 15-minute task into a full afternoon of frustration.

This guide walks you through the entire process, from setting up your bank feeds to resolving the most common headaches.

Setting Up Bank Feeds Correctly

Before you can reconcile anything, you need a reliable bank feed flowing into Xero. Most major Australian banks support direct feeds, including CBA, Westpac, ANZ, NAB, Macquarie, and dozens of smaller institutions.

To set up a bank feed:

1. Go to Accounting, then Bank Accounts, then Add Bank Account
2. Search for your bank and follow the prompts
3. Authorise the connection through your bank's website
4. Choose which accounts to connect

A few things to keep in mind:

• Direct feeds typically import transactions within 24 hours of them clearing at the bank
• If your bank does not support a direct feed, you can use Yodlee (a third-party aggregator) or upload bank statements manually in CSV or OFX format
• Always connect the feed before manually importing historical transactions to avoid duplicates

The Reconciliation Workflow: Step by Step

Once your bank feed is active and pulling in transactions, here is how to reconcile efficiently.

Step 1: Open the Bank Account

Go to Accounting, then Bank Accounts, and click the account you want to reconcile. You will see a list of unreconciled bank feed items on one side and suggested matches from Xero on the other.

Step 2: Review Suggested Matches

Xero will try to match each bank feed item to an existing transaction in the system (such as an invoice or bill you have already entered). If the amount and date line up, Xero will suggest a match.

• Green match means Xero is confident. Review the details and click OK.
• Partial match means the amount or date is close but not exact. You may need to adjust.
• No match means you need to categorise the transaction manually.

Step 3: Categorise Unmatched Transactions

For transactions with no match, you need to tell Xero what they are:

• Select the correct account code (e.g., Office Supplies, Rent, Advertising)
• Set the tax rate (usually GST on Income or GST on Expenses for most Australian businesses)
• Add a description or reference if it helps you remember what the transaction was for

Step 4: Use Bank Rules to Speed Things Up

If you see the same type of transaction appearing repeatedly, create a bank rule. Bank rules automatically categorise future transactions that match your criteria.

For example, you could create a rule that codes all payments to "OFFICEWORKS" as Office Supplies with GST on Expenses. Next time an Officeworks transaction comes through, Xero handles it for you.

Step 5: Reconcile and Move On

Once a transaction is matched or categorised, click OK to reconcile it. The item moves off the list, and you are one step closer to a clean set of books.

Common Bank Reconciliation Problems (and How to Fix Them)

Duplicate Transactions

This is the most common issue. Duplicates usually happen when you import a bank statement manually after a bank feed has already brought in the same transactions.

Fix: Go to Accounting, then Bank Accounts, then click the account. Look for the "Bank Statements" tab to review imported statements. Delete any duplicated statement lines before reconciling.

Prevention: Never import a CSV or OFX file for a date range that your bank feed has already covered.

Missing Bank Feed Items

Sometimes a transaction appears on your bank statement but not in Xero's bank feed.

Fix: Wait 24 to 48 hours, as some transactions take time to appear in the feed. If the item still does not show up, manually create a "spend money" or "receive money" transaction and reconcile against it.

Statement Balance Does Not Match Xero

If the closing balance on your bank statement does not match the balance in Xero, there are a few things to check:

• Look for unreconciled items sitting in the bank feed
• Check for transactions that were entered manually but not matched to the feed
• Review the statement balance in Xero under Accounting, then Bank Accounts, then select the account and click "Manage Account" to see the statement balance

Transfers Between Accounts

Internal transfers (e.g., moving money from a savings account to a transaction account) need to be reconciled in both accounts. In Xero, use "Transfer Money" rather than categorising each side as income or expense.

Tips for Faster Reconciliation

• Reconcile weekly, not monthly. A small batch of transactions is far easier to remember and categorise than a month's worth.
• Use bank rules aggressively. The more rules you set up, the less manual work remains. Aim to automate at least 70% of your transaction volume.
• Keep your chart of accounts simple. The fewer account codes you have, the faster you can categorise. Most small businesses only need 20 to 30 account codes.
• Review the "Discuss" tab. If you are working with a bookkeeper, use Xero's discussion feature to flag transactions you are unsure about.
• Leverage AI tools. Platforms like SortBooks use artificial intelligence to automatically categorise transactions, suggest matches, and flag anomalies before you even open the reconciliation screen.

When to Call in a Professional

If your reconciliation is more than three months behind, or if the discrepancy between your bank balance and Xero balance is more than a few dollars, it is worth engaging a qualified bookkeeper to clean things up. Fixing a mess after the fact is always harder than staying on top of it week by week.

For businesses that want to keep reconciliation in-house but hate the manual work, SortBooks automates the heavy lifting. Our AI engine categorises transactions, detects duplicates, and keeps your Xero file accurate so you can focus on running your business.

Final Thoughts

Bank reconciliation in Xero is straightforward once you understand the workflow. Set up your bank feeds properly, create bank rules for recurring transactions, reconcile weekly, and address discrepancies as soon as they appear. The goal is a clean, accurate set of books that you can trust when making financial decisions.