Reconciling the bank by hand: matching every movement to the accounts

15/09/2026

Every so often someone logs into the bank’s app or website, downloads the statement, and checks it against what’s recorded in the accounts or the management system. A payment from a customer, a direct debit to a supplier, a fee charged by the bank itself: every line on the statement has to show up in the books too, with the same amount and, ideally, the same date.

When everything matches, reconciling is mechanical: tick the line, move to the next one. The problem is the lines that don’t match right away — a payment for a different amount than the invoice, a transfer with no clear reference, a charge nobody remembers authorising — because those force a stop, a search for the matching invoice or receipt, and sometimes a call or an email to ask. The reconciliation session takes as long as those exceptions take, not as long as the lines that were already clear.

Why reconciling the bank by hand takes longer than it looks

The first cost is switching screens: going from the bank statement to the accounting software and back, line by line, with neither one telling the other what’s missing. The second is searching: when a transaction carries no clear reference, finding the invoice or receipt it belongs to can take longer than clearing ten transactions that already match. The third is setting movements aside as “to review later”, which sounds reasonable but means opening the same statement again, with less fresh memory of why they were set aside in the first place. The fourth is the mismatch that doesn’t explain itself: when the totals don’t add up at the end, the whole statement has to be gone through again to find the error, which can be as small as one transaction counted twice.

None of these steps is hard on its own. Together, they’re why reconciling the bank “one afternoon a month” quietly turns into an afternoon and a half, without anyone deciding it should.

The four figures for bank reconciliation

Here a case isn’t each bank transaction, even though that seems the obvious choice: most get ticked off in seconds, and timing a single transaction minute by minute doesn’t mean much. What does have a measurable cost is the whole reconciliation session: how long it takes start to finish, exceptions included. The frequency is usually monthly, when the statement comes in or the month’s accounts need closing, and the duration hides almost entirely in the transactions that don’t match on the first pass.

Say a small business reconciles the bank once a month: around 70 transactions on the statement, and the whole session — checking them all, tracking down what doesn’t match and clearing it — takes 150 minutes, with someone whose hour costs €24. That’s 30 hours a year, and around €720 a year.

Change them for your own in the calculator

What gets automated first in bank reconciliation, and what doesn’t

The first thing to automate is the mechanical matching: an integration that reads the bank’s transactions and pairs them automatically with invoices or accounting entries when the amount, date and reference line up closely enough. That leaves visible only what genuinely needs a look: whatever doesn’t find a match.

What stays in someone’s hands is exactly that: deciding whether a transaction with no clear reference belongs to this invoice or that one, whether a mismatch is a typing error or a duplicate payment, and whether an unrecognised charge needs chasing up or a call to the bank. An assistant can suggest the likeliest match based on the amount and the date, but confirming it is still a call made by someone who knows the business.

What we won’t tell you about bank reconciliation

What’s usually missing here isn’t the frequency, which most small businesses know well, but how much of that session goes into transactions that don’t match versus the ones that do. If all you know is that “reconciling takes an afternoon” without being able to split how much is routine checking and how much is chasing exceptions, the automation figure comes out as not estimable — not because the data doesn’t exist, but because nobody has separated it out yet. Noting, even roughly, how many transactions from the last few months took real work to track down is what turns that feeling into a figure.

If this is how you reconcile the bank each month, describe it in Handmetric: which accounting software you use, roughly how many transactions there are, and which part actually drags it out. Describe your process.