You sit down to reconcile your bank account, and the numbers don't match. Your accounting software says one thing, your bank statement says another, and the difference could be £4.50 or £4,500. Either way, something is wrong — and until you find it, you can't trust your financial reports, your VAT return, or your profit and loss statement.

Bank reconciliation errors are one of the most common bookkeeping problems UK small businesses face. According to recent studies, approximately 30% of companies have errors in their financial records due to inadequate reconciliation practices. The good news is that nearly every reconciliation discrepancy falls into one of a handful of predictable categories, and once you know what to look for, most can be found and fixed in minutes rather than hours.

What Bank Reconciliation Actually Is

Bank reconciliation is the process of comparing the transactions in your accounting software against the transactions on your bank statement to make sure they match. Every payment you've recorded, every invoice you've been paid for, every direct debit and standing order — all of it should appear in both places, for the same amounts, on the correct dates.

When everything matches, your accounts are reconciled. When something doesn't match, you have a discrepancy — and that discrepancy needs to be investigated and resolved before your financial records can be considered accurate.

Bank reconciliation workflow infographic for small businesses

This matters for three practical reasons:

VAT returns — If your records are wrong, your VAT calculations are wrong. Submitting an incorrect VAT return to HMRC can result in penalties, interest charges, and the stress of having to file corrections.
Tax filings — Your Self Assessment or Corporation Tax return is built on top of your accounting records. Reconciliation errors that go undetected ripple upward into your tax figures.
Cash flow visibility — If you can't trust your account balances, you can't make reliable decisions about whether you can afford to hire, invest, or take on new work.

The 8 Most Common Bank Reconciliation Errors

Nearly every reconciliation discrepancy you'll encounter falls into one of these categories. Understanding each one makes the detective work faster.

1. Timing differences

This is the most common cause of a reconciliation mismatch, and it's usually not an error at all. Timing differences occur when a transaction has been recorded in your accounting software but hasn't yet appeared on your bank statement, or vice versa.

Examples include cheques you've written that haven't cleared yet, payments you've received that are still processing, or direct debits recorded on a slightly different date than expected. If you reconcile on the last day of the month and a payment clears on the first day of the next month, you'll see a discrepancy that resolves itself naturally.

Timing differences are legitimate reconciling items. You don't need to change anything in your records — you just need to account for them when comparing your figures. Most accounting software lets you mark these as outstanding items that carry forward into the next reconciliation period.

2. Transposed numbers

This is the classic manual entry error. You type £1,583 instead of £1,538, or £2,590 instead of £2,950. The digits are correct but in the wrong order. The telltale sign of a transposition error is that the discrepancy between your records and the bank statement is divisible by 9. In the first example, £1,583 minus £1,538 equals £45, and 45 divided by 9 equals 5. If your reconciliation difference divides evenly by 9, start looking for transposed figures.

This type of error is most common in businesses that still enter transactions manually rather than using automatic bank feeds. Switching to automatic bank feeds eliminates transposition errors almost entirely, because the figures are imported directly from the bank rather than typed by hand.

3. Duplicate entries

A transaction gets recorded twice in your accounting software, but it only appears once on your bank statement. This doubles the amount in your books and creates a discrepancy equal to the value of the duplicated transaction.

Duplicates happen more often than you'd expect. Common causes include recording a transaction manually and then having it imported again through a bank feed, two people in the business both entering the same payment, or accidentally clicking "save" twice on an invoice payment. Recurring payments are particularly prone to this — if a monthly subscription is both manually entered and auto-imported, you'll get 24 entries per year instead of 12.

Most cloud accounting software includes duplicate detection that flags suspicious entries. If yours doesn't, running a transaction report sorted by amount is the fastest way to spot identical figures appearing on the same or adjacent dates.

4. Missing transactions

A transaction appears on your bank statement but doesn't exist anywhere in your accounting records. This means something was paid or received that you never recorded — a bank fee you didn't notice, a small refund you forgot to enter, a direct debit that started without being set up in your books, or a card payment you made but didn't log.

Missing transactions are particularly common with bank charges and interest. Your bank debits fees for wire transfers, international payments, or account maintenance, but these amounts often don't generate invoices or receipts. They simply appear on your statement. If you're not actively importing and reviewing every bank line, these small amounts accumulate into a meaningful discrepancy over time.

The fix is straightforward — find the missing transaction on your bank statement, determine what it relates to, and create the corresponding entry in your accounting software with the correct category and date.

5. Incorrect categorisation

The transaction exists in both your bank statement and your accounting records, and the amount is correct — but it's been categorised under the wrong account. A £500 payment to a supplier is recorded as an expense instead of a bill payment. A refund from a vendor is categorised as income rather than a reduction in expenses. A loan repayment is recorded entirely as an expense when part of it should be allocated to interest and part to the principal.

Categorisation errors don't always cause a reconciliation discrepancy in the traditional sense — your bank balance may still match — but they distort your profit and loss report, your balance sheet, and potentially your VAT return. They're particularly dangerous because they can exist invisibly for months until someone reviews the detail of a report and notices that a figure doesn't look right.

6. Bank fees and charges

Banks charge fees for all sorts of things — overdraft interest, international transfer charges, failed direct debit fees, monthly account maintenance, and CHAPS or Faster Payment fees. These charges appear on your bank statement automatically but won't appear in your accounting records unless you create them.

Fintech illustration comparing bookkeeping records with bank statements and mismatch alerts.

A £35 wire transfer fee doesn't come with an invoice. A £15 monthly account charge doesn't generate a receipt. These small amounts are easy to overlook, especially if you reconcile infrequently. Over a quarter, bank fees can easily add up to a discrepancy of £100 to £300 for an active business bank account — enough to cause confusion when you're trying to reconcile and enough to affect your VAT return if the fees include VAT.

7. Batched payments from payment processors

If you accept card payments through a payment processor like Stripe, PayPal, Square, SumUp, or any similar service, the amount that reaches your bank account will not match the individual transactions in your records. Payment processors batch multiple transactions into a single deposit and deduct their processing fees before sending you the net amount.

For example, you process 15 sales totalling £2,800 over two days. Your payment processor deposits £2,714 into your bank account after deducting £86 in processing fees. Your accounting software shows £2,800 in sales. Your bank shows £2,714. The difference is the processing fee, and it needs to be recorded as an expense in your books for the reconciliation to work.

This is one of the most common reconciliation problems for ecommerce businesses, retail shops, and any service provider that takes card payments. The solution is to record the gross sales as income and the processing fees as a separate expense, so the net amount matches your bank deposit.

8. Opening balance errors

If the opening balance of your accounting period is wrong, every reconciliation after that point will be off by the same amount. This usually happens when migrating to a new accounting platform — the starting balance was entered incorrectly, transactions from the previous system were partially imported, or the switchover date wasn't cleanly defined.

Opening balance errors are frustrating because the discrepancy appears on every single reconciliation, and no amount of reviewing current transactions will fix it. The only solution is to go back to the beginning, verify the opening balance against the bank statement for that date, and correct it. Once the opening figure is right, subsequent reconciliations should fall into place.

How to Find the Error

When your accounts don't match and you don't immediately know why, there's a systematic approach that works faster than scrolling randomly through transactions hoping something jumps out.

Calculate the exact discrepancy. Know the precise amount your records differ from your bank statement. Write it down. This number is your most important clue.
Check if it divides by 9. If it does, you're almost certainly looking at a transposition error. Search your records for amounts close to the discrepancy value and compare digit by digit.
Check if it matches a specific transaction. If your discrepancy is exactly £49.99 or £350.00, search your bank statement for that amount. There's likely a missing entry or a duplicate that matches the figure precisely.
Halve the discrepancy. If you can't find a transaction matching the full discrepancy, divide it by two and search for that amount. A transaction recorded as a debit when it should have been a credit — or vice versa — will cause a discrepancy of double the transaction value.
Compare line by line. If none of the shortcuts work, export both your bank statement and your accounting transactions for the period, sort both by date, and compare them side by side. This is tedious but thorough — it will find everything the shortcuts might miss.
Check the previous period's closing balance. If your current reconciliation is off by the same amount as last month, the error likely originated in a prior period and has been carried forward. Go back to the last clean reconciliation and work forward.

How to Prevent Reconciliation Errors

Finding and fixing errors is necessary, but preventing them is better. Most reconciliation problems can be avoided entirely with a few consistent habits.

Use automatic bank feeds

The single most effective thing you can do to reduce reconciliation errors is to connect your bank account to your accounting software and let transactions import automatically. This eliminates manual data entry, which eliminates transposition errors, reduces missing transactions, and ensures that bank fees and charges appear in your records as they occur. Every major cloud accounting platform — Sage, Xero, QuickBooks, FreeAgent — supports automatic bank feeds with most UK banks.

Reconcile weekly, not monthly

The longer you wait between reconciliations, the harder it is to find errors. Reconciling weekly means you're reviewing a manageable number of transactions while they're still fresh in your memory. You're far more likely to remember what that £47.50 charge was when it happened five days ago than when you're looking at it six weeks later at the end of the quarter.

Don't mix manual entry with bank feeds

If you've connected your bank feed, stop entering transactions manually. The most common source of duplicate entries is recording a payment by hand and then having the same payment imported through the bank feed. Choose one method and stick with it. If you use bank feeds, let the feed bring in the transactions and then categorise them. If you prefer manual entry, disconnect the feed.

Review bank fees every month

Set a monthly reminder to check your bank statement for fees and charges that need to be recorded. Create a recurring task or calendar entry. It takes two minutes and prevents the slow accumulation of unrecorded fees that cause confusion at quarter-end.

Record payment processor fees separately

If you use Stripe, PayPal, or any payment processor, record the gross sale as income and the processing fee as a separate expense on every transaction. Don't record the net deposit amount as your income — doing so understates your revenue and hides a genuine business expense. Most accounting software can be configured to handle this split automatically.

Lock completed periods

Once a period has been reconciled, lock it in your accounting software so that transactions can't be accidentally edited or deleted. Most platforms offer a lock date feature that prevents changes to any transaction before a specified date. This protects your reconciled periods from well-meaning but destructive edits that reintroduce discrepancies into previously clean accounts.

When to Call Your Accountant

Not every reconciliation error needs professional help. Missing bank fees, timing differences, and obvious duplicates are straightforward fixes you can handle yourself. But there are situations where bringing in your accountant is the right call:

The discrepancy has been carried forward across multiple periods and you can't identify when it started
You've migrated from another platform and the opening balances don't align
The discrepancy involves VAT, and correcting it may affect a previously filed VAT return
You suspect a fraudulent transaction — an unknown payment, an unauthorised withdrawal, or a charge you didn't make
The amount is large enough that getting it wrong could materially affect your tax position

A qualified bookkeeper or accountant can usually resolve a stubborn reconciliation issue in a fraction of the time it would take you, because they know exactly where to look and what the common patterns are. The cost of an hour of their time is almost always less than the cost of filing incorrect figures with HMRC.

The Bigger Picture

Bank reconciliation isn't glamorous. It doesn't feel like the work that grows your business. But it is the foundation that everything else sits on — your VAT return, your tax filing, your profit figures, your cash flow forecast, and your ability to make financial decisions with confidence rather than guesswork.

When your accounts don't match, it's rarely catastrophic. It's almost always one of the eight errors described above, and it's almost always fixable once you know where to look. The businesses that struggle with reconciliation aren't the ones that make mistakes — everyone makes mistakes. They're the ones that leave it too long, don't use bank feeds, and don't reconcile until HMRC needs something.

Reconcile weekly. Use bank feeds. Record everything. Lock your periods. The maths will take care of itself.

This article is for informational purposes only and does not constitute financial or accounting advice. For guidance specific to your circumstances, consult a qualified accountant or bookkeeper.

Command Palette