Why reconciliation is more than a monthly chore

Bank reconciliation has a reputation for being the dullest job in the diary, but it is really a health check on your whole business. Every receipt that lands in your account and every payment that leaves it should correspond to something you already knew about. When they match, you have proof that your sales, your costs and your cash position are all telling the same story. When they do not, you have found a problem while it is still small enough to fix in ten minutes.

Left too long, reconciliation stops being a check and becomes an investigation. A single unrecorded payment is easy to trace in the same week; after three months, it is a puzzle with missing pieces. The discipline is not about tidiness for its own sake — it is about knowing exactly what you owe, what you are owed, and whether your profit figures can be trusted.

Start with a clean opening balance

Before you compare anything, agree your starting point. Take the closing balance from your last completed reconciliation and check it against the opening balance on the statement period you are working through. These should be identical. If they differ, something has been missed or altered in between, and there is no point pushing forward until you have found it.

A few practical points worth building in from the start:

• Reconcile to a date you can clearly close off, ideally the last day of the month rather than an arbitrary mid-week cut-off.
• Download the statement or export the transactions as a spreadsheet so you can sort, filter and tick items off.
• Keep the bank's own reference, not just your own, so you can search for it later without guesswork.
• Reconcile each bank account separately, including savings, credit cards and any second current account you use for tax or VAT money.

Match every receipt and payment against your records

Work through the statement line by line, both directions of travel. For every payment out, find the matching entry in your accounts — a supplier invoice, a direct debit, a standing order, a card purchase, a bank charge. For every receipt, find the sales invoice or till total it relates to, remembering that card takings usually arrive as a net figure after the payment processor has taken its fee.

Tick off in pairs, and be strict about it. Do not assume that a payment to a regular supplier is the one you are looking for just because the amount is close. Match the amount, the date and the reference. If you use accounting software with a bank feed, resist the urge to accept suggested matches in bulk without reading them; that is how a duplicate slip through unnoticed.

Round sums arriving on the same day, unusual references and payments made to individuals rather than businesses all deserve a second look. They are not automatically wrong, but they are the entries most likely to be misposted.

Investigate discrepancies straight away

Most differences fall into a handful of familiar categories. Identify which one you are dealing with rather than guessing:

• Timing differences. A cheque written last month but presented this month, or a card payment taken on Friday that reaches the account on Monday.
• Missing entries. A direct debit or bank charge that never made it into your books.
• Duplicate entries. The same invoice recorded twice, often because it was entered once manually and once from a feed.
• Errors in your own records. A figure typed as 1,250 instead of 125.00, or an invoice posted to the wrong customer.
• Bank errors. Genuinely rare, but they happen — an incorrect charge, a reversed transaction or a payment applied to the wrong account.

Deal with each one as you find it. Note the reason next to the item, and if you need to query it with the bank or a customer, do that the same day rather than adding it to a list of unexplained items. A discrepancy with a note attached is a task; a discrepancy without one is a worry you will carry around for weeks.

Mark items as reconciled so nothing gets entered twice

The moment an item is matched, lock it. In most accounting software this means a tick, a cleared flag or a reconciled status that removes it from the outstanding list. If you are working from a spreadsheet, add a clear column for the reconciliation date and mark each line. The purpose is simple: the next time you sit down to reconcile, you should be looking only at what is genuinely new.

This is the single most effective guard against duplicate entries. A transaction that has been ticked off cannot quietly be re-entered from a downloaded statement, and an invoice that already has a payment allocated to it will not be paid twice. Protect the reconciled period with a password or a lock if your software allows it, so a routine tidy-up cannot disturb figures you have already signed off.

Build a routine that keeps it painless

Reconcile little and often. A weekly twenty-minute session makes month-end straightforward and keeps your cash position accurate all month, which matters enormously if you are managing supplier payments or watching a tight margin. Keep a short list of recurring items — bank charges, loan repayments, director's drawings, software subscriptions — and check them off as you go.

At the end of each month, confirm three figures: the reconciled bank balance, the balance in your accounts and the difference between them, which should be zero. Save the statement alongside your reconciliation, and write a one-line note explaining anything unusual. When your accountant or the tax authority asks a question six months from now, that note will save you an afternoon of digging — and your books will be ready to support every figure you have reported.