Bank Reconciliation for Small Business: A Practical UK Guide

What Is Bank Reconciliation?

Bank reconciliation compares two records of the same movement of money:

• Your bookkeeping or accounting records
• Your bank statement

For example, suppose your bookkeeping software shows a £480 customer payment. You would normally expect to find the same £480 entering your bank account.

Likewise, if your bank statement shows a £42 software subscription, your bookkeeping should normally contain the relevant expense.

Reconciliation involves more than checking whether two closing balances happen to match. You need to understand the transactions behind those balances.

Never create an unexplained adjustment simply to force the numbers to agree. Investigate the cause first.

Why Does Bank Reconciliation Matter for Small Businesses?

Accurate bookkeeping gives you a clearer picture of your business finances.

Suppose your accounting software shows £14,600 in the bank while the actual bank balance stands at £11,900. Any cash-flow report based on the bookkeeping may mislead you until you explain that difference.

Regular reconciliation can uncover:

• Missing expenses
• Customer payments matched to the wrong invoice
• Duplicate transactions
• Incorrect bank transfers
• Bank fees
• Interest
• Wrong opening balances
• Unusual payments

Reconciliation can also improve the quality of your financial reports.

Your bank balance alone cannot tell you whether a payment represents sales income, a loan, an owner contribution, a refund or a transfer between accounts. Good bookkeeping adds that context.

HMRC requires self-employed businesses to maintain accurate records and identify their business transactions. Bank reconciliation provides a practical control that supports those records.

It does not represent a separate HMRC return or filing requirement.

Which Accounts Should a Small Business Reconcile?

Start with your main business current account, but do not automatically stop there.

Depending on how your business operates, you may also need to reconcile:

• Savings accounts
• Business credit cards
• Foreign-currency accounts
• PayPal
• Stripe
• Other payment processors
• Business loan accounts

Remember transfers between accounts

A transfer from one business account to another affects both accounts.

Check both sides of the transaction. Otherwise, you could accidentally record a transfer as income or expenditure.

Take extra care with payment processors

Payment processors can make reconciliation less obvious.

For example, a customer might pay £100 through an online platform. The platform could deduct a £3 fee and transfer £97 to your bank.

Simply recording £97 as sales may fail to show the complete transaction. Your records may need to show the £100 receipt and the separate £3 processing fee, depending on the circumstances.

The £97 bank deposit tells you how much cash arrived. It does not explain the whole transaction.

How to Do a Bank Reconciliation Step by Step

1. Choose a reconciliation date

Choose a clear end date, such as the final day of the month.

Compare the bookkeeping and bank information up to exactly the same date. Using different periods will create unnecessary differences.

2. Check the opening balance

Confirm that the reconciliation starts from the correct balance.

If you reconciled the previous month successfully, use that point as your starting position.

When you have never reconciled the account before, establish the correct opening balance before you continue.

An incorrect opening balance can make every later period appear wrong.

3. Match money received

Work through the money entering the bank.

Compare each receipt with your bookkeeping and check:

• Date
• Amount
• Customer or source
• Invoice reference, where relevant

Do not assume that every deposit represents sales income.

Loans, refunds, transfers and money introduced personally by the owner may need different treatment.

4. Match money paid

Next, work through payments leaving the account.

These might include:

• Supplier bills
• Software subscriptions
• Insurance
• Materials
• Travel costs
• Professional fees
• Payroll
• Tax payments
• Bank charges

Check invoices, receipts and other supporting documents where necessary.

A bank statement confirms that money moved. On its own, it may not explain what you bought or how you should record the transaction.

5. Investigate unmatched transactions

Now focus on anything that appears in only one set of records.

For each unmatched item, ask:

• Did someone forget to enter it?
• Is it a genuine timing difference?
• Does a duplicate already exist?
• Did someone enter the wrong amount?
• Did the transaction go into another account?
• Did a bank feed duplicate an earlier manual entry?

Keep a query list for anything you cannot resolve immediately.

That approach works better than guessing.

6. Correct genuine bookkeeping errors

Once you understand the cause, correct the original bookkeeping entry where appropriate.

For example, you might need to add a missing bank charge or remove a genuine duplicate.

Avoid posting a vague balancing adjustment simply because it makes the software show the expected closing balance.

The correction should make accounting sense and reflect what actually happened.

7. Review timing differences

Some transactions legitimately sit on one side of the reconciliation for a short period.

For example, your books may contain a customer receipt or payment that does not reach the bank until the following day.

Check whether the transaction clears after the reconciliation date.

A genuine timing difference should normally resolve itself later. An unexplained difference that remains for months needs investigation.

8. Confirm and save the reconciliation

After you resolve errors and identify valid timing differences, confirm the reconciled balance.

Keep the reconciliation report or working paper with your accounting records.

That creates a useful audit trail and gives you a clear starting point for the next reconciliation.

A Simple Bank Reconciliation Example

Consider a small web-design business at month-end.

Its bookkeeping shows a bank balance of £8,420.

The bank statement shows £8,275.

That creates an initial difference of £145.

The owner investigates and finds two items:

• A £25 bank charge appears on the statement but not in the books.
• A £120 customer receipt appears in the books but had not reached the bank by the statement date.

After recording the £25 bank fee, the bookkeeping balance becomes:

£8,420 − £25 = £8,395

Adding the £120 timing difference to the statement balance gives:

£8,275 + £120 = £8,395

The adjusted figures now agree.

More importantly, the owner can explain the original £145 difference rather than simply removing it.

Why Does a Bank Reconciliation Not Balance?

Most reconciliation problems have a straightforward cause once you trace the transactions carefully.

Start from the last correct period

If you cannot find the problem, identify the most recent month that reconciled correctly.

Work forward from there.

Finding an error from last week usually takes far less time than investigating a difference that has remained unresolved for six months.

How Often Should a Small Business Reconcile?

For many small businesses, monthly reconciliation provides a sensible starting point.

However, transaction volume and complexity should guide your schedule.

A freelancer with ten monthly transactions may not need daily reconciliation. In contrast, an online retailer processing hundreds of payments could benefit from weekly checks.

Consider more frequent reconciliation if your business has:

• High transaction volumes
• Several bank accounts
• Regular credit-card activity
• PayPal or Stripe transactions
• Employees making purchases
• Tight cash flow
• Frequent customer payments
• Regular management reporting

The best schedule is one you can maintain consistently.

Do Bank Feeds Automatically Reconcile Your Accounts?

No.

A bank feed imports transaction data into accounting software. Many systems can then suggest matches or categories.

That automation can save significant time, but it does not remove the need for review.

Imagine that a £250 payment enters your bank account. The software may import the amount automatically, but you may still need to decide:

• Who paid it
• Which invoice it relates to
• Whether it represents income
• Whether it duplicates another entry
• What VAT treatment applies, where relevant

HMRC’s Making Tax Digital guidance also explains that bank-connected software may require users to add information to imported transactions. Some transactions may need separate records.

The taxpayer remains responsible for keeping accurate digital records.

Bank Reconciliation and Making Tax Digital

Bank reconciliation itself does not form an MTD submission.

However, regular reconciliation can improve the reliability of the digital records that support Making Tax Digital reporting.

HMRC expects affected businesses to maintain relevant income and expense information digitally and correct errors when necessary.

A bank feed therefore supports digital bookkeeping, but it does not replace it.

Real Key Accountancy’s separate guide to Making Tax Digital for Income Tax explains the current implementation rules in more detail.

Common Bank Reconciliation Mistakes

Checking only the closing balance

Two balances can occasionally agree even when individual transactions contain errors.

Review the underlying transactions as well as the final figure.

Removing differences without investigating them

Do not delete an entry simply because removing it makes the account reconcile.

Find out why the transaction exists first.

Treating a bank feed as complete bookkeeping

A bank feed supplies transaction data.

It may not provide the supporting document, business purpose or correct accounting treatment.

Forgetting credit cards and payment processors

A reconciled current account does not guarantee accurate bookkeeping if your credit card contains months of unchecked business expenditure.

Include all significant financial accounts in your process.

Mixing personal and business transactions

Mixed spending creates extra work and makes reconciliation harder.

Keeping business transactions separate usually makes the bookkeeping much clearer.

Waiting until year end

Leaving reconciliation for twelve months creates a much larger investigation.

A payment that seems obvious today may become difficult to explain many months later.

What If Your Bookkeeping Is Already Months Behind?

Do not try to repair an entire year in one go.

Find the last date when you know the records were correct, then work forward systematically.

A practical catch-up process

1. Obtain statements for every relevant account.
2. Gather invoices, receipts and payment-platform reports.
3. Check bank-feed connections.
4. Establish the correct opening balance.
5. Add missing transactions.
6. Remove genuine duplicates.
7. Investigate unexplained items.
8. Reconcile one period before moving to the next.

Keep a separate query list if you need more information about particular transactions.

Real Key Accountancy’s guide to catch-up bookkeeping explains the wider process for bringing overdue records back under control.

When Might Professional Bookkeeping Support Help?

You may benefit from help when:

• Several months remain unreconciled
• Opening balances appear incorrect
• Bank feeds contain duplicates
• You use several accounts or payment processors
• Corrections may affect VAT periods
• Previous returns or accounts could contain errors
• You cannot explain significant differences
• Bookkeeping takes too much time away from running the business

A good reconciliation process does more than make accounting software display the word “reconciled”.

It gives you financial records that clearly explain what happened to the business’s money.

Need Help Reconciling Your Business Accounts?

Real Key Accountancy supports sole traders and small businesses with bookkeeping, bank reconciliation and financial record organisation.

If your bookkeeping has fallen behind, start by establishing which periods need attention, which accounts need checking and what records you already have.

Speak to Real Key Accountancy about your bookkeeping requirements.