Step-by-Step Guide to Xero Bank Feeds and Reconciliation

What Is Bank Reconciliation?

Bank reconciliation is the process of matching the transactions in your accounting software against your bank statement to make sure nothing has been missed, duplicated, or recorded incorrectly. In Xero, bank reconciliation is one of the most important tasks you’ll do regularly – it keeps your financial records accurate and your cash flow reporting reliable.

For UK businesses, accurate bank reconciliation also matters for VAT returns, corporation tax, and Making Tax Digital compliance. If your accounting records don’t match your bank statement, your VAT figures could be wrong – and HMRC won’t accept “the software got it wrong” as an excuse.

Setting Up Bank Feeds in Xero

Before you can reconcile, you need bank transactions flowing into Xero. Most UK banks support automatic bank feeds, which import your transactions daily. To set one up:

1. Go to Accounting > Bank Accounts and click Add Bank Account.
2. Search for your bank and follow the prompts to authorise the connection.
3. Once connected, Xero will start importing transactions automatically.

Major UK banks including Barclays, HSBC, NatWest, Lloyds, Starling, and Monzo all support direct Xero bank feeds. Business bank accounts from Tide and Revolut also connect natively. If your bank doesn’t support automatic feeds, you can manually import statements as CSV or OFX files.

Once your bank feed is live, Xero pulls in new transactions every business day. There’s usually a 24-hour delay between a transaction appearing on your bank statement and showing up in Xero – so don’t panic if today’s card payment isn’t visible yet.

What Are the 5 Steps of Bank Reconciliation?

1. Open the reconciliation screen – from your Xero dashboard, click on the bank account you want to reconcile. The number of items waiting is shown on the tile.
2. Review suggested matches – Xero automatically matches imported bank statement lines against invoices, bills, and other transactions you’ve already recorded. Check each suggestion is correct.
3. Create new transactions – for bank statement lines that don’t match anything, create a new “Spend Money” or “Receive Money” transaction directly from the reconciliation screen.
4. Confirm and reconcile – once a statement line is matched or a new transaction is created, click OK to mark it as reconciled.
5. Check your closing balance – after reconciling all items, compare the balance in Xero with your actual bank balance. If they match, you’re done. If not, investigate the difference.

These five steps apply whether you’re reconciling a current account, savings account, credit card, or PayPal balance. The process is the same – match each bank statement line to a transaction in Xero.

How to Reconcile All Transactions in Xero

To work through your unreconciled transactions efficiently:

• Set up bank rules – if you have recurring transactions (e.g. rent, subscriptions, regular supplier payments), set up bank rules to automatically categorise them. Go to your bank account, click the cog icon, and select Bank Rules. A good set of rules can handle 60-80% of your reconciliation automatically.
• Use cash coding for bulk reconciliation – if you have many similar transactions (like daily card payments), Xero’s cash coding feature lets you categorise multiple statement lines at once from a spreadsheet-style view. Click Cash Coding at the top of the reconciliation screen.
• Reconcile in batches – rather than letting statement lines build up, reconcile weekly or even daily. Small batches are faster and less error-prone than tackling months of transactions at once.
• Use the Xero mobile app – you can reconcile transactions on the go, which is especially useful for small business owners who want to stay on top of their accounts between meetings.

Setting Up Bank Rules for Automatic Reconciliation

Bank rules are the single biggest time-saver in Xero bank reconciliation. A bank rule tells Xero: “When you see a transaction matching these conditions, automatically categorise it like this.”

For example, if you pay £49.99 to “XERO UK LTD” every month for your Xero subscription, create a bank rule that matches any transaction containing “XERO UK” and automatically codes it to your software subscription expense account. Next time it appears, Xero matches it instantly.

To create a bank rule:

1. During reconciliation, when you see a recurring transaction, click Create Rule instead of just categorising it.
2. Set the conditions (e.g. payee contains “XERO UK”, amount equals £49.99).
3. Set the action (allocate to a specific account, apply a tax rate, add a tracking category).
4. Save the rule.

Build up your bank rules over the first month or two and you’ll find that most of your daily reconciliation is done automatically. We typically see clients go from 30 minutes of reconciliation per week to under 5 minutes once their rules are established.

Handling Transfers Between Accounts

When you transfer money between your own bank accounts, you need to record it as a transfer rather than income or expenditure. During reconciliation, click Transfer on the statement line and select the other account. This ensures your reports don’t inflate your income or expenses.

This is a common mistake for businesses with multiple bank accounts in Xero. If you record a transfer from your current account to your savings account as an expense, your profit and loss report will show inflated costs. Always use the Transfer option for internal moves between your own accounts.

Common Bank Reconciliation Problems

• Balance doesn’t match – check for transactions entered with the wrong date, duplicate entries, or items recorded in the wrong bank account. Also check whether your opening balance was entered correctly when you first set up the account in Xero.
• Missing transactions – your bank feed may have a short delay. If a transaction hasn’t appeared yet, wait 24 hours or manually import a recent statement. Also check whether the transaction date falls within the period you’re reconciling.
• Duplicate statement lines – if you’ve both connected a bank feed and manually imported a statement for the same period, you may have duplicates. Delete the extras from the bank statement screen by clicking the statement line and selecting Remove & Redo.
• Foreign currency transactions – if you receive payments in another currency, Xero applies the exchange rate at the transaction date. Small differences between the rate on your bank statement and Xero’s rate can create reconciliation variances. These are normal – Xero books them as exchange gains or losses automatically.

Running a Bank Reconciliation Report

To review your reconciliation history, go to Accounting > Reports > Bank Reconciliation Summary. This report shows the reconciled balance, unreconciled items, and any discrepancies for each bank account – useful for month-end reviews or when your accountant needs to verify your records.

The Bank Summary report is also valuable at year-end. Your accountant can compare the reconciled balance in Xero against your bank’s year-end statement to confirm everything ties up before preparing your annual accounts.

How Often Should You Reconcile?

For most UK small businesses, weekly reconciliation strikes the right balance between accuracy and effort. Daily reconciliation is ideal if you process a high volume of transactions (retail, e-commerce, hospitality), while monthly is the absolute minimum.

The more frequently you reconcile your bank accounts in Xero, the easier it is to spot errors, catch fraud, and maintain accurate financial records. Leaving reconciliation for months creates a backlog that is tedious to work through and increases the risk of errors going undetected.

If you use an accountant, frequent reconciliation also means they can access up-to-date figures in Xero at any time – without waiting for you to “get the books up to date” first.

How JacRox Can Help

Need help setting up bank feeds, creating bank rules, or catching up on a reconciliation backlog? Fill out the contact form below and a JacRox team member will be in touch.

Once your bank reconciliation is running smoothly, explore our guides on accounts payable and receivable in Xero, creating professional invoices, and the tracking expenses in Xero.

Want to get more from Xero? Talk to certified Xero accountants about your accounting needs.