How to Do Bank Reconciliation in Xero — UK Sole Trader Guide

What bank reconciliation actually is

Bank reconciliation means confirming that every transaction on your bank statement is recorded in your accounting software — and that every entry in your software matches something on your bank statement. When the two match, your books are reconciled. When they don't, something is missing or wrong.

In Xero, the process is almost entirely automated once your bank feed is connected. Xero imports your bank transactions daily and suggests matches or categorisations. Your job is to review, confirm, and catch anything it cannot automatically match.

Why it matters

Unreconciled books have three consequences.

First, you do not know your true profit. If expenses are unrecorded, your profit looks higher than it is — and you risk over-paying tax. If income is unrecorded, it looks lower — and HMRC may see this as underreporting.

Second, you cannot trust your cash position. Without reconciliation, the balance in Xero and the balance in your bank account are different numbers. You cannot plan ahead on numbers you cannot trust.

Third, your year-end accounts take longer and cost more to prepare. A bookkeeper or accountant clearing 12 months of unreconciled transactions in January charges more per hour for crisis work than for routine monthly maintenance.

How often to reconcile

Monthly is the minimum for most sole traders. For high-volume businesses, weekly is better. Some sole traders with simple finances reconcile quarterly — but this is risky as errors become harder to identify and correct after the fact.

How to reconcile in Xero (step by step)

Step 1: Go to your bank account In Xero, navigate to Accounting → Bank Accounts. Select the account you want to reconcile. You will see the Statement Balance (from your live bank feed) and the Balance in Xero. These should match once you complete reconciliation.

Step 2: Review imported transactions Xero will show you each imported transaction with a suggested match or categorisation. If you have set up bank rules, many will already be categorised. Review each one.

Step 3: Match existing invoices or bills If Xero has outstanding invoices or bills that match incoming or outgoing transactions, it will suggest a match. Confirm these — this marks the invoice as paid.

Step 4: Categorise uncategorised transactions For any transaction without a suggested match, select the correct account code. Common codes: Office expenses, Travel, Professional fees, Bank charges.

Step 5: Handle unmatched items Some items will not match automatically. Common reasons:

• A transaction in Xero was entered with the wrong date or amount
• A bank transaction is not yet recorded in Xero (create a new transaction)
• A transaction is personal and should be coded as drawings (not a business expense)

Step 6: Confirm the closing balance Once all transactions are matched, the balance in Xero should equal the closing balance on your bank statement. Xero shows a running balance that confirms this.

Common reconciliation problems

Duplicate transactions: If a transaction appears twice — once from the bank feed and once entered manually — delete the manual entry and keep the bank feed version.

Wrong categorisation: If you categorised a transaction incorrectly last month, correct it now. In Xero you can click on any transaction and change the account code.

Missing transactions: If something appears on the bank statement but not in Xero, enter it manually. This is common for cash transactions, direct debits set up outside your normal software workflow, or transfers between accounts.

The monthly reconciliation habit

Setting aside 30-60 minutes at the end of each month for reconciliation is the single most valuable financial habit for a sole trader. Done consistently, it means your Profit and Loss is always accurate, your VAT returns are always right, and your year-end is a review rather than a rescue.