Bank Reconciliation Without Errors: A Faster, Repeatable Method

Bank reconciliation is one of those tasks everyone agrees is necessary and many small companies postpone until year end. This sets out a structured method that turns it from a tedious search into a repeatable process, and explains why it is also one of the best fraud detection tools you have.

Why the two balances never agree

A difference between the ledger and the bank is normally not an error. You and the bank record events at different moments. You record a cheque when you write it; the bank records it when it is presented. The bank records a fee when it deducts it; you record it when you see the statement.

The goal is not to force the two numbers together. It is to explain and document every difference. If each gap has a stated cause and a supporting item, the work is done correctly even though the two figures differ.

The four categories of open items

The first two are normal timing items and simply appear on the reconciliation statement. The last two require action: a correcting entry in one case, correspondence with the bank in the other.

The four-column statement

Rather than working from one balance to the other, bring both sides to the true balance:

The advantage is that both columns land on one figure, and that figure is your genuinely available cash — the number every liquidity decision should rest on. The amounts above are illustrative.

Eight practical steps

1. Download the statement as a file, not a printout; almost every bank offers Excel or CSV.
2. Extract the ledger bank account activity for the same period.
3. Normalise both into the same columns: date, description, debit, credit, reference number.
4. Match automatically on amount and date. A simple lookup closes more than eighty percent of lines.
5. Classify the unmatched items into the four categories above.
6. Raise correcting entries for category three and contact the bank for category four.
7. Print, sign and file the reconciliation; an unsigned reconciliation has no control value.
8. Carry the open item list forward and track its ageing.

Card terminals and payment gateways

Retailers and online sellers get stuck here because the amount credited never equals the day's sales. Three reasons: settlement delay, commission deducted, and several days or terminals aggregated into one credit.

The correct treatment is:

• Record sales gross and hold the receivable from the payment processor in its own account.
• Record commission separately as an expense, not as a reduction of revenue.
• Reconcile against the processor's settlement report, not the net bank credit.
• Track refunds and failed transactions separately.

Beyond accounting accuracy this has a tax dimension: terminal turnover is linked directly to your tax file and must agree with declared sales, as discussed in bank transactions and tax scrutiny.

Cheques, the usual source of open items

An issued cheque is a liability in your books and invisible at the bank until presented. Three controls reduce the noise: keep a cheque register with serial number, due date and clearing status; review monthly any unpresented cheque more than three months past its date; and separate returned cheques from ordinary receivables immediately.

Reconciliation as an internal control

In most misappropriation cases I have seen, the first trace was visible here: small repeated withdrawals with vague narrations, a cheque recorded as cancelled in the books but cleared at the bank, or a customer receipt diverted to another account and written off as a discount in the ledger.

That is why the person preparing the reconciliation should not be the person posting receipts and payments. It is the simplest segregation of duties available, workable even in a five-person company — see internal control and fraud prevention.

Before closing the year

Year-end reconciliation differs from a routine month because its output flows straight into the financial statements. Confirm that all category three and four items are cleared, obtain a balance confirmation from the bank, and file the signed reconciliation in the audit pack. The wider year-end sequence is in closing the books at year end.

Key takeaways

• The goal is a documented explanation of each difference, not identical balances.
• Sort open items into four categories; two are timing, two demand action.
• Match on reference numbers so future months reconcile themselves.
• Record card sales gross and commission separately, reconciling to the settlement report.
• Keep the reconciler separate from the person posting receipts and payments.