Bank feed & categorising

Bank reconciliation without the headache: what it is and how to reconcile your bank account

Updated 13 October 20269 min readLedgers Team

On this page
Quick answer

What bank reconciliation means, why it matters, and how to reconcile your bank account step by step, with a worked example and how to fix differences.

What reconciliation actually means

Reconciliation is checking that two records of the same thing agree.

In bookkeeping, the two records are almost always your books (your own record of what happened to your money) and your bank statement (what actually moved through the account). Bank reconciliation means laying them side by side and confirming, line by line, that every payment and receipt in one appears in the other, and that the balances agree.

You're not calculating anything clever. You're answering one question: does my version of events match the bank's? When it does, the account is reconciled. When it doesn't, you've found something that needs a look.

It's the same habit as checking a shopping receipt against what's in your bag. You don't do it because you expect a problem. You do it because comparing the two lists is the only way to know.

The same idea applies beyond the bank. Accountants reconcile credit card statements, Stripe and PayPal balances, loan statements and supplier statements, and check that balances such as VAT owed or a director's loan account agree with the underlying records. The bank account is where everyone starts, because the bank's record is independent of yours.

What "reconciled" means when you see the word

When an accountant says an account is reconciled, they mean every transaction in your books has been matched to the bank statement, and the closing balance in your books equals the closing balance at the bank, once you allow for items still in transit.

So "reconciled" is really a statement of trust: we've checked, and the records agree. An unreconciled account might be perfect or might be quietly out of step. Until someone compares, nobody knows.

Why reconciliation matters

It's the difference between knowing and guessing. Your profit figure, your VAT return and your balance sheet all assume your books reflect reality. Reconciliation is the step that confirms it.

It catches errors while they're small. A duplicated payment or a miskeyed amount takes a minute to fix the week it happens and an afternoon to untangle at year-end.

It surfaces what shouldn't be there. A subscription you forgot to cancel, a supplier who charged twice, a card payment you don't recognise. Reconciliation is a quiet form of fraud protection.

It's what lets you trust your cash position. A reconciled balance is money you can plan around.

It matters most when someone else relies on your numbers: HMRC at VAT time, your accountant at year-end, an investor in due diligence. Reconciled books are what let you answer "are these figures right?" with a straight face.

Why your books and the bank disagree (and why that's normal)

Your books and your bank not matching on a given day is ordinary. The causes fall into two groups.

Timing differences are items that are correct in your books but haven't reached the bank yet, or the other way round:

  • A supplier payment you've recorded that hasn't left the account yet.
  • A customer payment or cheque you've recorded that hasn't cleared.

These sort themselves out. You just need to list them.

Genuine differences need fixing in your books:

  • Bank charges, interest or a direct debit you never recorded.
  • A customer payment that arrived but wasn't logged.
  • A payment entered twice, for the wrong amount or in the wrong month.
  • A personal transaction on the business account.

Most mismatches turn out to be timing. A few are real errors you'll be glad you caught.

How to reconcile a bank account, step by step

This is the manual method, the same whether you use a spreadsheet or accounting software.

  1. Pick the period and get the statement. Usually a calendar month. Note the bank's closing balance on the last day.
  2. Start from a reconciled opening balance. Your books and the bank should have agreed at the end of the previous period. If they didn't, fix that first, or every later reconciliation will carry the same error.
  3. Match each transaction. Go down the statement and find each item in your books by amount, date and payee. Tick both sides. Matching on amount alone is risky: two £50 payments to different suppliers are not interchangeable.
  4. Record what's on the statement but missing from your books. Bank charges, interest, direct debits, customer receipts. Check each is genuine before you add it.
  5. List what's in your books but not yet on the statement. Payments you've sent that haven't cleared and money you've recorded that hasn't arrived. These are your timing differences.
  6. Do the sum. Take the bank's closing balance, add money in transit and subtract payments not yet cleared. That adjusted bank balance should equal your book balance after step 4.
  7. Investigate anything left over. See the tips below.
  8. Sign it off and keep a record. Note the date, the balances and the outstanding items, so next month starts from solid ground.

A worked example

Here is an illustration with invented figures. On 31 August the bank statement shows a closing balance of £8,450. Before reconciling, your books show £7,715. Matching the transactions turns up four unticked items:

  • £15 of bank charges on the statement, not in your books.
  • A £600 customer payment on the statement, not yet recorded.
  • A £400 supplier payment recorded in your books on 30 August that hasn't cleared.
  • A £250 customer payment recorded in your books on 31 August that hasn't arrived.

First, update your books with the two genuine items:

Books£
Balance before reconciling7,715
Add: customer payment not recorded+600
Less: bank charges not recorded−15
Corrected book balance8,300

Then adjust the bank balance for the timing items:

Bank£
Statement closing balance8,450
Add: money recorded but not yet arrived+250
Less: payment recorded but not yet cleared−400
Adjusted bank balance8,300

Both sides come to £8,300, so the account is reconciled at 31 August. The £400 and £250 should appear on September's statement. If they don't, that's worth chasing.

Doing it in a spreadsheet

If you don't use accounting software yet, a simple cash book works. Give it columns for the date, who the payment was to or from, a reference, money in, money out, a running balance and a "cleared" column you tick when the item appears on the statement.

Each month, filter for anything not ticked as cleared. Those are your timing differences. Put the two small tables from the worked example at the bottom of the sheet: book balance, adjustments and corrected balance on one side; statement balance, items in transit and adjusted balance on the other. When the two totals match, note the date and save a copy alongside the statement.

That saved copy matters. A dated, signed-off reconciliation is good evidence that your figures were checked, and it's one of the first things an accountant asks for. Our guide to which records you legally have to keep covers the rest of the paperwork.

The spreadsheet's weakness is that every line is typed by hand, which is where most errors come from. Once you're past a few dozen transactions a month, a bank feed saves more time than the spreadsheet does.

When the difference won't go away

If you're left with an unexplained gap, work through these before doing anything drastic:

  • Check the opening balance really was reconciled last month.
  • Search for the exact difference. A missing £37.50 is often a single unrecorded transaction of £37.50.
  • Search for half the difference. If a £120 payment was entered as money in instead of money out, your books are wrong by £240.
  • If the difference divides by 9, look for transposed digits. £54 entered as £45 leaves a £9 gap.
  • Check the dates. A transaction on the boundary between months can sit in the wrong period on one side.

What you shouldn't do is "force" the balance with an adjusting entry just to make the numbers agree. Your books then become quietly wrong, and next month inherits the error. If you can't find it, flag it for your accountant with what you've already checked.

How often to reconcile

At a minimum, monthly, and always before a VAT return and at year-end. Our guide to filing a VAT return assumes your bank accounts are reconciled first, because VAT figures built on unreconciled books can be wrong in either direction.

More often is easier, not harder. The problem with month-end reconciliation is the batching: it turns thirty small, easy checks into one big job done weeks after the fact, when you can no longer remember what each payment was for. Weekly is better. Continuous is best.

Don't forget the accounts that aren't your main current account: savings accounts, business credit cards, and payment platforms like Stripe or PayPal, where a single payout to your bank can bundle dozens of sales and fees. Matching those payouts to the underlying invoices is a common source of double counting, and our guide to matching bills to bank payments covers the supplier side.

Why it has a reputation for being a chore

For a long time, reconciliation meant a printed statement, a ledger and a pen. Find the £420 in the bank, find the £420 in the books, tick. Repeat for every line, then hunt for the few that don't match, often late in the evening before a deadline.

In most accounting software, including Xero and QuickBooks, the bank feed now suggests matches, but someone still has to work through and approve them line by line. The concept is simple. It's the labour, and leaving it to pile up, that makes people dread it. If you're weighing up a move, our Ledgers vs Xero comparison sets out how the two approaches differ.

Continuous reconciliation: the same check, done as you go

The fix for the month-end slog isn't a faster tick-box. It's not saving the work up at all.

With a live bank feed, transactions arrive in your books daily from the same source the bank uses, so the two records don't drift apart. (If you haven't set one up, here's how connecting your bank to your accounting works.) Each transaction can be categorised and matched as it lands, which means reconciliation becomes a status that's always current rather than an event at the end of the month.

In Ledgers, that looks like this:

  • Bank and books are tied out nightly, and any gap is explained in plain English, so you see what doesn't match and why instead of hunting for it.
  • Receipts link themselves. Snap a receipt and Ledgers waits for the matching bank transaction, then links the two when it lands.
  • Platform payouts are matched. Card sales are booked to a Stripe clearing account, and when the payout arrives in your bank Ledgers matches it and clears the balance.
  • Anything that needs you lands in one inbox, sorted by urgency, so you deal with exceptions while you still remember them.
  • Reconciliation feeds the Confidence Score, a 0–100 measure that includes your reconciliation gap, so you can see at a glance how far to trust the books today.
  • A nightly integrity check guards the ledger. If anything fails to tie out, the AI pauses automatic posting rather than build on bad numbers, and shows you why.

Your accountant gets their own mode with the reconciliation and audit log they're used to, so they can check the work rather than redo it. For a wider check on whether your books are right, see how to know if your books are actually correct.

The short version

Reconciliation is checking that your books and your bank agree, line by line, with the balances matching once you allow for items in transit. Differences are normal and usually timing, but comparing is the only way to catch the ones that aren't. Do it at least monthly, never force a balance, and reconcile every account, not just the main one. Or let it happen continuously, so there's nothing to save up. If you'd like the tie-out done for you each night, start free and connect your bank to Ledgers.

Frequently asked questions

What is reconciliation in accounting?

Reconciliation is checking that two records of the same money agree. Most often that means comparing your books with your bank statement, line by line, until every transaction matches and the balances agree.

How do I reconcile my bank account?

Take the bank statement for the period, match every transaction to your books, record anything genuine that's on the statement but missing from your books, and list items that haven't cleared yet. Adjust the statement balance for those timing items; it should then equal your book balance.

Why is bank reconciliation important?

It's the step that confirms your records reflect reality. Without it, your profit, VAT return and balance sheet rest on unchecked figures. It also catches errors, duplicate charges and fraud while they're small.

Why don't my books match my bank statement?

Usually timing: a payment you've recorded hasn't cleared, or money has arrived that you haven't recorded. The rest are bank charges you didn't enter, duplicates, wrong amounts or transactions in the wrong period.

How often should I reconcile my bank account?

At least monthly, and always before a VAT return or year-end. More often is easier, because small, recent differences are quick to explain. Software with a live bank feed can reconcile continuously.

What does "reconciled" mean?

It means every transaction in your books has been matched to the bank and the closing balances agree, after allowing for items still in transit. A reconciled balance is one you can stand behind.

What should I do if a difference won't go away?

Don't force it with a balancing entry. Check the opening balance was reconciled, look for a transaction of exactly the difference or half of it, and if the difference divides by 9, look for two transposed digits.

See your numbers without learning accounting

Ledgers does the bookkeeping — bank feeds, VAT, year-end — and keeps your accountant in the loop. Free for pre-revenue founders.

Start free →

Get the next guide by email

Plain-English accounting for founders — a couple of new guides a week. No spam, unsubscribe anytime.

Keep reading · Bank feed & categorising