How to do bank reconciliation

What bank reconciliation actually is

Two balances sit at the centre of every reconciliation. The book balance is what your own records say you have; the bank balanceis what the statement says. The gap between them is made up entirely of explainable items — transactions in transit, and things only one side knew about. When you adjust both for those items and they land on the same number, you're reconciled.

The output is a short bank reconciliation statement: a tidy list showing how you get from the bank balance to the adjusted book balance via the reconciling items. It's your evidence that the work was done and the records agree — the thing an auditor, lender or accountant wants to see.

app.parseflow.io

Why it matters

• Accuracy: your recorded cash is real and complete, so every report built on it is trustworthy.
• Error detection: duplicates, omissions and transposed figures surface as unexplained differences.
• Fraud control: unauthorised payments and odd charges can't hide once you reconcile regularly.
• Faster close: a reconciled account makes month-end and year-end straightforward, not a hunt.
• Cash truth: reconciliation underpins an honest cash position and a reliable cash-flow view.

It also feeds the rest of your numbers: a reconciled account is the foundation for cash-flow analysis and for categorising transactions with confidence. If you want a tool that matches transactions to invoices automatically, see bank reconciliation software.

Before you start

• Your own records for the period — a cash ledger, spreadsheet, or accounting software.
• The bank statement for the exact same period, with its opening and closing balances.
• Any statements as structured data, not PDFs — convert them first so you can sort and tick off rows.
• A note of last period's reconciling items, since some will clear this period.

Convert your PDF statement to a clean workbook with bank statement to Excelfirst — it's balance-validated, so you know the statement side is complete before you compare. Reconciling a year? Consolidate with Smart Merge.

app.parseflow.io

Step-by-step: the reconciliation

app.parseflow.io

Reconciling items, explained

Every difference between your books and the bank falls into one of a few buckets. Knowing them makes reconciliation a matter of sorting rather than detective work. Timing items resolve on their own as transactions clear; information items are things only one party knew about; and errors are differences that shouldn't exist and need correcting.

app.parseflow.io

A worked example

Suppose your books show a closing balance of £8,200 and the bank statement shows £8,650. A £450 gap — here's how it resolves.

Both sides now land on £8,250, so the account is reconciled. The outstanding check and deposit in transit are timing items that will clear next period; the interest and fee are now in your books. That's the whole game — every difference named and accounted for.

When it won't balance: finding the difference

A reconciliation that won't close is almost always one of a handful of culprits, and there's a quick way to narrow it down: look at the size of the difference. A difference divisible by 9 often means a transposed figure (£54 booked as £45). A difference equal to exactly twice a transaction usually means a wrong sign — a debit recorded as a credit. A round, familiar number is frequently a fee or a single missed transaction.

Working from structured, converted data makes this dramatically faster: you can sort by amount to spot a duplicate, filter by date to find a missing day, and rely on the converter's built-in balance validation and duplicate detection so the statement side is provably complete before you start hunting on your own side.

app.parseflow.io

How often should you reconcile?

Monthly is the standard cadence for most businesses, aligned to the statement cycle, and it's the rhythm that makes month-end close painless. Higher-volume businesses reconcile weekly or daily so problems never accumulate. The principle is the same at any frequency: little and often beats a once-a-year marathon, because a small set of fresh differences is easy to explain while a year's worth is a slog. If you've fallen behind, convert and consolidate the backlog and work month by month.

app.parseflow.io

Who needs to reconcile, and which accounts

Reconciliation isn't only for big companies with finance teams — anyone who needs to trust their cash figure should do it. A sole trader reconciling a single business account, a landlord with an account per property, a small company with a current account and a couple of cards, a charity answerable to trustees: all of them benefit from proving their records against the bank. The more accounts and the higher the volume, the more valuable it becomes, because that's where errors and missed items hide.

The rule of thumb is to reconcile every account that holds or moves money: business current accounts, savings and tax-reserve accounts, and every credit or charge card. Cards are often skipped and shouldn't be — they carry a lot of spending and their own fees and interest, all of which need to agree with your records. Reconcile each account against its own statement; don't try to reconcile a blended total, because you'll lose the ability to trace a difference to a specific account.

One thing to watch across multiple accounts is internal transfers: money moving from checking to savings appears as a debit in one statement and a credit in another. Those aren't income or expense, just movement, and tracking them as matched pairs keeps each account's reconciliation clean. Converting and consolidating all your accounts with Smart Merge first makes spotting those pairs straightforward.

app.parseflow.io

Recording the adjustments

Not every reconciling item is treated the same way in your books, and getting this right is what keeps the next period's reconciliation clean. Timing items — outstanding checks and deposits in transit — need noentry in your books, because your records are already correct; they're just waiting for the bank to catch up, and they'll clear on their own. You simply carry them forward on your reconciliation and confirm they clear next period.

Information items are the opposite: bank fees, interest, charges and direct debits that you didn't know about until the statement arrived doneed recording, because your books are currently missing them. In double-entry terms these are journal entries — a bank fee is an expense and a reduction in cash, interest earned is income and an increase in cash. If you use accounting software, you post these as you reconcile; in a simple cash book, you add the rows. Either way, once they're in, your book balance moves to meet the bank.

Errors get corrected at their source: fix the duplicated entry, add the missed one, correct the transposed figure. The principle across all three is that after you've recorded the bank-only items and corrected errors, your adjusted book balance should equal the adjusted bank balance — and your books now reflect reality, so you start next period clean.

app.parseflow.io

Reconciling in QuickBooks and Xero

Most people reconcile in accounting software, and the experience is smoother when you feed it clean data. QuickBooks and Xero both have a reconciliation screen that matches imported bank transactions against the entries in your books, letting you tick off matches and flag the rest. The weak point is the data source: live bank feeds break, don't cover every account, and can't reach historical months — so when the feed fails or you're doing back periods, you need another way to get transactions in.

That's where converting the PDF statement helps. Turn it into a structured .QBO for QuickBooks or a Xero import, and the software has clean, complete, correctly signed transactions to reconcile against — including the months a feed can't reach. Because each transaction in a .QBO carries a unique ID, re-importing or overlapping ranges won't create duplicates, which matters when you're catching up. The step-by-steps are in importing into QuickBooks and into Xero.

For the harder kind of reconciliation — matching individual bank transactions to specific invoices automatically — a dedicated tool helps; see bank reconciliation software and the AI reconciliation engine. The input that makes any of them work well is the same: clean, validated transaction data.

app.parseflow.io

Many accounts and catching up

Two situations stretch the basic process: lots of accounts, and being behind. For accountants and bookkeepers reconciling dozens of client accounts a month, the bottleneck isn't the logic but getting each client's statements into clean data — which is why standardising on a converter, so every bank's statement becomes the same structured workbook, is how firms reconcile at volume without proportional headcount. The accountant's converter is built around exactly this.

If you're catching up on months or years of missed reconciliations, don't try to do it all at once. Convert and consolidate the whole backlog, then reconcile month by month from the oldest open period forward, carrying each closing balance into the next month's opening. The reason to go oldest-first is that an error in an early month throws off every later one, so fixing it in sequence saves re-work. Because the data is structured and balance-validated, a backlog that feels impossible usually resolves in a focused session or two — and once you're current, a monthly cadence keeps it that way.

The broader, firm-level view of running reconciliation and statement processing at volume is in the at-scale processing playbook, and the complete reference is the bank reconciliation guide.

app.parseflow.io

How reconciliation catches fraud and errors

One of the most valuable things regular reconciliation does is expose money problems you'd otherwise never see. Because you're comparing your records against the bank's independent record, anything that hits the account without your knowledge — an unauthorised card payment, a duplicated direct debit, a supplier charging twice, even a bank error — shows up as a transaction on the bank side with no matching entry on yours. That unexplained item is the alarm; without reconciliation, it simply blends into the balance and goes unnoticed.

Errors are caught the same way and are far more common than fraud. A payment entered twice, an invoice receipt never recorded, a figure typed as £91 instead of £19 — each creates a difference you can't explain until you find and fix it. The discipline of reconciling forces that find-and-fix to happen on a schedule, so small mistakes are corrected while they're fresh rather than compounding silently across a year and surfacing as a baffling discrepancy at year-end.

The practical lesson is twofold: reconcile often, because the sooner you look the sooner an anomaly is caught and the less damage it does; and never explain away a difference you can't actually account for. An unexplained difference isn't noise to be smoothed over — it's the control doing its job, telling you something needs attention. Starting from balance-validated data means you can trust that the statement side is complete, so any genuine anomaly is real rather than an artefact of a missing page.

app.parseflow.io

A simple approach for a small business

If you're a sole trader or run a small business, reconciliation doesn't need to be elaborate — a monthly habit and a spreadsheet will do. Each month, convert your statement to Excel, sit it next to your own record of income and spending, and tick off everything that matches. Add the handful of bank-only items you spot (fees, interest), note any cheques or payments that haven't cleared yet, and confirm the adjusted figures agree. For most small accounts that's fifteen minutes, and it tells you your cash figure is right.

The biggest favour you can do yourself is to keep business and personal money separate, ideally in different accounts — reconciliation (and bookkeeping generally) gets far simpler when you're not picking trade transactions out of personal noise. Where they are mixed, convert the whole account and tag the business rows, then reconcile against the full statement. Pair the reconciliation with categorising in the same sitting and you get clean, complete books for the month in one short pass.

Fall behind and the fix is the same, just repeated: convert and consolidate the backlog, then reconcile month by month from the oldest open period. Once you're current, the monthly rhythm keeps it trivial — and at year-end your books are already done, which is exactly what makes tax preparation painless.

app.parseflow.io

Reconciling without (or alongside) software

You don't need accounting software to reconcile — a spreadsheet is enough, and for many sole traders it's the simplest route. Convert your statement to Excel, put your own records in a second column or sheet, and tick off matches with a helper column; the unmatched rows are your reconciling items. A short block at the bottom — bank balance, plus or minus timing items, equals adjusted bank balance; book balance, plus or minus bank-only items, equals adjusted book balance — is your reconciliation statement, and the two adjusted figures must agree.

If you do use software, the value of converting the PDF is feeding it clean data. QuickBooks and Xero reconcile a bank feed against your entries, but feeds break, miss accounts and can't reach historical months — so a structured .QBO or Xero import fills those gaps with correctly signed, duplicate-safe transactions. Many people use both: the spreadsheet for a quick monthly check or a back period, the software for the live month. Either way the input is the same — complete, validated transaction data.

Whichever route you take, keep the finished reconciliation statement. It's short, but it's the evidence that the work was done and the records agreed — exactly what an accountant, lender or auditor will ask to see, and what makes next period's reconciliation a quick continuation rather than a fresh investigation.

app.parseflow.io

Common mistakes

• Not confirming the opening balances agree before you start.
• Forgetting bank-only items — fees, interest, direct debits — that only the statement knows about.
• Treating timing items (outstanding checks, deposits in transit) as errors.
• Reconciling from a PDF, so you can't sort or filter to find a difference.
• Forcing a balance with a fudge entry instead of finding the real cause.
• Leaving it to year-end, so a single difference means trawling twelve months.

Best practices

• Reconcile on a fixed cadence — monthly at least — so differences stay small.
• Always work from converted, balance-validated data, not raw PDFs.
• Carry forward open reconciling items and check they clear next period.
• Never force a balance; an unexplained difference is information, not noise.
• Keep the reconciliation statement as evidence the work was done.
• Reconcile and categorise in the same pass to save time.

Working in QuickBooks or Xero? Convert the PDF to a structured .QBO or Xero importso their reconciliation tools have clean data to match — including historical months a live feed can't reach.

app.parseflow.io

Reconciliation checklist

Use this each period. If every box is ticked, your account is reconciled and the result is defensible.

• Opening balances on both records agree before you start.
• Every transaction that appears in both records is ticked off.
• Outstanding checks and deposits in transit are listed as timing items.
• Bank-only items — fees, interest, direct debits — are recorded in your books.
• Any errors (duplicates, omissions, transpositions) are corrected at source.
• Adjusted book balance equals adjusted bank balance — exactly.
• Open timing items are carried forward to confirm they clear next period.
• The reconciliation statement is saved as evidence.

For the complete reference around this checklist — reconciling items in depth, doing it at scale, software and the PDF-to-reconciled workflow — see the complete bank reconciliation guide, and pair it with categorising your transactions in the same pass.

Frequently asked questions

Related guides & tools