Your bank says one thing. Your bookkeeping software says another. The gap is usually small — a standing order you forgot to record, a supplier payment that landed a day late — but until you find it, every figure you pull from your accounts carries a question mark. Bank reconciliation is the work of closing that gap, transaction by transaction.
It's also one of the most commonly postponed jobs in a small business, and one of the most useful. A clean reconciliation tells you what you actually have, what you actually owe, and whether your VAT return is built on solid ground.
What reconciliation really involves
Reconciliation means agreeing two records: the transactions that have passed through your bank account, and the transactions recorded in your bookkeeping. Most UK small businesses now work from a bank feed — a daily download of transactions into software such as Xero, QuickBooks or FreeAgent.
A bank feed is not a reconciled account. The feed brings transactions in; reconciliation is the work of saying "this one is the payment for invoice 1042", "this one is the direct debit for business insurance", "this one is a coffee bought on the company card".
Do it monthly rather than annually. A month of transactions takes an hour. A year of them takes a week you don't have.
Start with the opening balance
Before you match anything, check the starting point. The opening balance on your bank statement should match the opening balance in your software. If they don't, nothing downstream will line up, and you'll waste time chasing entries that were never wrong.
Two things usually cause a mismatch. Either the software account was set up partway through a month, so the earliest transactions were never brought in. Or someone reconciled to the wrong figure previously — often the bank's available balance rather than its ledger balance. Those two numbers differ whenever there are unpresented cheques or card payments still pending. Available balance is what you can spend now; ledger balance is what has actually cleared. Reconcile to the statement balance.
The matching routine
Once the opening balance agrees, work through the feed in date order and apply the same routine each time:
- Match the obvious ones first. Customer receipts against invoices, supplier payments against bills, direct debits against repeating expenses. Most lines should clear in seconds.
- Code the recurring items. Rent, software subscriptions, insurance, loan repayments. Set up rules so your software suggests the right account next month.
- Create entries for spending you haven't recorded. A fuel receipt, a train ticket, a stationery order paid on a personal card. These need a purchase record, not just a category.
- Raise invoices for money that arrived without one. If a customer paid ahead of an invoice, record the receipt as a credit and match it when the invoice is issued.
- Investigate whatever is left. The residue at the end of the month is where the real work sits.
Finding the entries that are missing
When a transaction won't match, the cause is nearly always one of a handful of things.
Timing. A cheque written in March but cleared in April. A card payment taken on Friday that hits the account on Monday. These are timing differences rather than errors, and they resolve themselves in the following period.
Duplicates. The same receipt entered twice, or entered manually and then again from the feed. Search by amount and date before creating anything new.
Split transactions. One bank payment covering several invoices, or one card payment covering both stock and postage. Split it into the correct lines rather than forcing it into a single category — it matters for your VAT treatment and your profit figures.
Bank charges, interest and foreign exchange fees. These rarely arrive with paperwork. Code them as bank charges or finance costs, and check them monthly; small fees accumulate quietly.
Personal spending through the business account. If you're a sole trader or a director with a company card, personal items belong in drawings or a director's loan account, not in expenses. Mixing the two creates a tax problem that is far easier to fix now than at year end.
Correcting an opening balance
Sometimes the starting figure is genuinely wrong: an old reconciliation was posted against the wrong date, a duplicate opening entry crept in, or a balance was forced to make the account agree when the feed started mid-month.
Don't adjust the current month to hide it. Find the cause and post a correcting entry with a clear description and the date of the original error, so the audit trail makes sense to you — or your accountant — in two years' time. If the difference relates to a period that has already been filed, take advice before posting anything, as some corrections have to be handled in a specific way.
If the account was set up incorrectly in the first place, it's often cleaner to create a fresh account in the software with the correct opening balance and date than to post a string of adjustments that nobody will understand later.
A month-end habit worth keeping
Reconciliation isn't a task you finish; it's a rhythm. Ten minutes a week keeps the feed tidy, and a proper hour at month end gets you to the point where every line is matched and the software balance equals the bank statement balance.
- Statement balance agrees to the software balance
- No unmatched transactions left in the feed
- Recurring items coded consistently month to month
- Anything unusual noted for your accountant
Get the reconciliation right each month and the rest of the year gets noticeably easier — VAT returns, management accounts and tax planning all rest on books that agree with the bank. If the numbers have drifted, or a difference simply won't budge, a bookkeeper or accountant can usually trace it in minutes. One conversation is cheaper than a week of guesswork. Where a correction touches a previously filed period or an uncertain tax position, take professional advice before you post it.
Photo: Pavel Danilyuk / Pexels
