Bank reconciliation

Bank reconciliation agrees the bank account in your books to the bank statement. The routine, a worked example, matching rules for awkward lines and the usual causes of a difference.

Bank reconciliation is the routine of agreeing the bank account in your books to what the bank statement shows. Done weekly it takes minutes; left until year end it can swallow a working week. Software now proposes most of the matches, but the lines it cannot place are where errors hide. This guide sits alongside the rest of our bookkeeping guides and covers the routine, a worked example, how to match the awkward lines and how to trace a difference.

Why reconcile so often

The bank reconciliation is the foundation of every other report you produce. Skip it and every figure downstream inherits the error:

  • VAT returns rely on complete income and expenses, so accurate VAT bookkeeping depends on a reconciled bank account
  • Management accounts are only as good as the bank ledger they sit on
  • HMRC enquiries often start with bank statements and trace into the ledger
  • A clean bank ledger shows fraud and duplicate payments quickly
  • The trial balance can balance while the bank figure in it is wrong; only the statement proves it

The reconciliation routine

A weekly cycle suits most small businesses; monthly is the minimum.

  1. Bring the bank lines into the books up to the statement date, by feed, file import or statement upload
  2. Match each line to the invoice, bill or receipt it settles
  3. Record the lines that have no document of their own, such as bank charges and interest
  4. Put anything you cannot identify in a holding account and chase it
  5. Compare the ledger balance with the statement balance at the same date
  6. Explain any difference by named items, then lock the period

Categorising as you go also feeds your expense tracking, so allowable costs are captured when the payment clears, not reconstructed at year end.

Match or create? The first decision on every line

The bank line is… What to do Why
A customer paying an invoice you issued Match to the open sales invoice The invoice already holds the sale and VAT; creating income again would double it
A payment of a supplier bill already entered Match to the open bill Clears the supplier balance
A card purchase with a receipt but no bill entered Create an expense with the receipt attached There is nothing to match to
Bank charges or interest Create The statement is the only document
A transfer between your own accounts Match to the transfer on the other account Neither income nor expense
A payroll, HMRC or VAT payment Match to the liability (net wages, PAYE, VAT) The cost was posted by the payroll or VAT journal

The common mistake is the third row applied to the first: a customer receipt “created” as new sales. The open invoice then stays unpaid, turnover is overstated and output VAT is counted twice.

Matching that is not one-to-one

One receipt, several invoices. A customer pays £4,560 covering invoices 1041, 1043 and 1050. Use the remittance advice, or the payment reference, to select all three invoices against the single bank line. If the remittance is missing, allocate to the oldest invoices first only if that is your agreed policy, and ask the customer to confirm.

Several receipts, one invoice. A customer pays in instalments. Match each bank line to the same invoice; it stays partly paid until the last one arrives. See partial payments from customers.

Batched payouts from card processors and marketplaces. A payout is usually many sales minus fees and refunds, paid as one amount. Do not match the payout to sales invoices. Route it through a clearing account: the sales and fees go into the clearing account from the provider’s report, and the payout clears it, as explained in card payment clearing in the chart of accounts.

A fee deducted from a payment. An overseas customer’s payment arrives £18 short because of an intermediary bank charge. Match the receipt to the invoice and record the £18 as bank charges in the same step, so the invoice is settled. Do this only when you know the difference is a bank fee and not a disputed amount.

Lines you cannot match

Some lines match nothing: a receipt with no reference, a payment you do not recognise. Do not force them into an income or expense account. Post them to a holding account, investigate within a set time and clear them; the steps are in unidentified payments and clearing entries.

Make matching easier at the source

  • Ask customers to quote the invoice number as the payment reference, and say so on every invoice.
  • Pay suppliers with their invoice number as your reference.
  • Keep the sales and purchase ledgers up to date before matching. A bank line cannot be matched to an invoice that has not been entered.
  • Treat a suggested match as a suggestion. Two invoices of £1,200 to different customers are easy to mix up.

A worked reconciliation statement

When the books are written up before the statement arrives, or cheques and cash are involved, the two balances differ for good reasons, and a short statement proves that they agree.

Starting figures £
Balance per the books, before adjustments 12,450
Balance per bank statement 14,780

First, bring into the books what the statement shows and the books lack:

Item on the statement, not yet in the books In (£) Out (£)
Transfer received from a customer 2,500
Interest received 15
Bank charges 85
Direct debit for insurance 350
Customer cheque returned unpaid 200

Adjusted balance in the books: £12,450 + £2,500 + £15 − £85 − £350 − £200 = £14,330.

Then list what the books show and the bank has not yet processed:

Reconciliation statement £
Balance per bank statement 14,780
Add: takings paid in, not yet credited 800
Less: cheques issued, not yet presented (1,250)
Adjusted bank balance 14,330

Both figures are £14,330, so the account is reconciled. The two timing items should clear on the next statement; if they are still there a month later, find out why.

Common reconciliation breaks

When the balance in your books does not agree with the statement and you cannot explain it, the difference is a break. Most fall into a few predictable kinds:

Break Likely cause Fix
Statement higher than ledger A receipt not yet recorded Match it to the invoice or record it
Ledger higher than statement A payment recorded but not yet cleared Leave it as a timing item and watch it
Difference equals one transaction A line missed on import, or entered twice Add or remove the line
Difference divisible by nine Two digits transposed (£540 entered as £450) Correct the entry
Round-sum difference on a currency account Exchange movement Post the exchange gain or loss
Repeated small differences Bank charges not posted Record them from the statement
Timing items older than six months Cheques never presented Cancel and reissue, or write back

The rule is to investigate, never override. Forcing a reconciliation to balance hides the underlying error and corrupts every report built on top of it.

Foreign currency accounts

If you hold a foreign currency bank account, reconcile it in the foreign currency first, then revalue at the period end using the closing rate. The revaluation gain or loss posts to an exchange differences account. Keeping the source currency separate keeps the reconciliation clean and isolates exchange movements as a distinct, explainable figure.

At month end

Before you close the month, every bank line should be matched or explained, the bank balance in the books should equal the statement, and the list of unpaid sales invoices should contain only invoices customers really still owe. If a customer says they have paid and your ledger disagrees, the unmatched list is the first place to look. Keep the reconciliation with the month’s papers; an auditor or accountant will ask for the year-end one. How long to keep it is covered in data retention for businesses, and HMRC’s record-keeping guidance gives the underlying obligation.

Reconciling in Nexbal

In Nexbal you upload the bank statement as a PDF. Lines the AI can match are posted, and the rest are listed for you to review, with the statement kept as the evidence. To try it on a month of your own statements, join the Nexbal beta, free for 30 days.

Nexbal is launching in the UK · beta open

Join the Nexbal beta

Early access, 30 days free, and your feedback shapes the product.