Bank reconciliation every week: the 20-minute routine that keeps your books clean

 

Most small businesses reconcile their bank accounts once a month, usually in a rush, usually days after month-end. By then the trail is cold. A payment you cannot recognise is three weeks old, the person who made it has forgotten it, and the bank statement has moved on. Doing the same job every week takes about 20 minutes and removes almost all of that pain.

Weekly reconciliation is not extra work. It is the same work, split into smaller pieces, done while you still remember what happened.

Why weekly beats monthly

A monthly reconciliation tries to match hundreds of transactions in one sitting. Errors hide in volume. A duplicate supplier payment, a customer receipt posted twice, or a bank fee you did not expect all look the same when you are staring at 300 lines.

Weekly, you match 40 to 70 lines. Anything odd stands out at once. You also catch problems while you can still fix them: a missing invoice can be requested, a wrong amount can be queried, and a fraudulent transaction can be reported within days rather than discovered at year-end.

There is a cash benefit too. When your books match the bank every week, your cash position is real, not a guess. You know what you can pay, what is still owed to you, and whether a customer payment has actually landed.

The 20-minute routine, step by step

Set the same slot every week, ideally the first working morning. Work through these five steps in order.

1. Pull a fresh statement

Download the statement or open the live feed for the week just ended. If you use cloud software with a bank feed, refresh it first so nothing is missing. Work from the bank side, not from memory.

2. Match what you already recorded

Go through each bank line and tick it against a transaction in your books: sales invoices paid, supplier payments, payroll, direct debits, card spending. Most lines will match in seconds. Let the software auto-match where it can, but glance at each match rather than accepting the whole batch blind.

3. Chase the stragglers

Every week leaves a few unmatched items on each side: money in the bank with no invoice recorded, or a payment in your books that has not cleared. Deal with them now, not next month. A receipt with no invoice usually means an invoice was never raised. A payment that has not cleared after a week is worth a call to the supplier.

4. Clear old items properly

Uncleared items older than 30 days are a warning sign. A cheque never cashed, a transfer that never arrived, or a duplicate entry will sit in your reconciliation forever if you let it. Investigate each one, write it off only with a note explaining why, and never delete a transaction just to force the balance to agree.

5. Lock the week

Once the book balance equals the bank balance, lock the period in your software so nobody can quietly edit it later. Note the reconciled balance and the date in a simple log. That log is your evidence if a question comes up months later.

The mismatches you will meet, and what they mean

A few differences appear again and again. Bank charges and interest are the most common: record them as you go, and they stop surprising you. Timing differences are next: a card payment taken on Friday may clear on Monday, which is normal and needs no action beyond waiting.

The ones that matter are the unexplained items. A payment to a supplier you do not recognise, a refund you did not authorise, or a receipt from a customer you have never invoiced all deserve a same-day check. Small unexplained amounts are how bigger problems start, whether that is an error, a duplicate, or something worse.

If the same mismatch repeats, fix the process behind it. Recurring duplicates often mean two people are entering the same invoice. Recurring unrecorded receipts often mean sales invoices are raised late. The reconciliation is telling you where the workflow is broken.

When a backlog means you need help

A weekly routine only works if someone actually does it. When reconciliations slip to monthly, then quarterly, then "we will catch up at year-end", the backlog itself becomes the problem. Rebuilding six months of bank records takes far longer than the weekly routine ever would, and it usually happens at the worst possible time, right before accounts or a VAT return are due.

That is the point where outside help pays for itself. A dedicated bookkeeping team can clear the backlog, put the weekly routine in place, and keep it running, so the business owner sees clean numbers every Monday instead of a year-end panic. If that sounds familiar, look at accounting outsourcing services and outsourced bookkeeping services to see how a weekly reconciliation routine is run as a managed service.

A checklist you can reuse

Print this and keep it by the desk:

• Statement downloaded and feed refreshed
• Every bank line matched or queried
• Unmatched items chased the same week
• Items over 30 days old investigated, not ignored
• Book balance equals bank balance
• Week locked, balance and date logged

Twenty minutes a week, done properly, is the cheapest control a small business has. It keeps the books honest, the cash position real, and year-end boring in the best possible way.