Bank reconciliation: a weekly routine that keeps the books clean

Bank reconciliation: a weekly routine that keeps the books clean


 

Why weekly beats monthly

Most small businesses reconcile the bank once a month, usually in a rush just before the VAT return or management accounts are due. By then, errors have had four weeks to compound: a duplicated payment looks normal, a missing receipt is forgotten, and a fraudulent transaction hides among hundreds of legitimate ones. A weekly reconciliation changes the dynamic completely. Each session takes about 30 minutes, discrepancies are caught while memories are fresh, and month end becomes a non-event because the books were already clean. It is one of the highest-return habits in bookkeeping.

The 30-minute weekly routine

Block the same slot each week, ideally the morning after the week's bank activity settles. Work through these six steps in order:

  1. Refresh the bank feed. Confirm the feed imported all accounts and that the closing balance matches the bank's own figure. If the feed failed silently, nothing else in the routine can be trusted.
  2. Match the obvious items. Let the software auto-match first, then clear the straightforward manual matches: customer receipts against invoices, supplier payments against bills, payroll against the payroll journal.
  3. Post the standing items. Direct debits, bank charges, interest and regular card payments often arrive without paperwork. Post them from the statement with clear descriptions so they do not become mystery entries later.
  4. Chase the unmatched. Anything left unmatched after 15 minutes of investigation goes on a follow-up list with a name and a date, not back into the pile.
  5. Review timing differences. Unpresented cheques and outstanding lodgements are normal, but they should clear within days. Anything older than two weeks needs a phone call.
  6. Sign off the week. Note the reconciled balance, file the follow-up list, and lock the week in the software so nobody posts backdated entries into it.

Handling the usual suspects

Every reconciliation throws up the same handful of characters. Unpresented cheques should be chased if they sit uncleared beyond a fortnight, and stale cheques over six months old may need cancelling and reissuing. Bank charges and interest need posting gross, never netted off, so the audit trail stays clean. Duplicate transactions usually come from a manual entry plus a feed import of the same item; delete the manual one once confirmed, and tighten the process that created it. Personal transactions in a business account should be posted to the director's loan account or drawings immediately, not left to fester until year end. Foreign currency items need the actual converted sterling amount from the statement, not the estimate from the invoice date.

Controls that keep the reconciliation honest

A reconciliation only controls anything if it is independent. The person who prepares it should not be the same person who approves payments, and a second pair of eyes should review the unreconciled items list each month. Lock prior periods in the software so reconciled weeks cannot be quietly altered. Keep suspense accounts near zero: a suspense balance that grows month after month is a sign that unmatched items are being parked rather than resolved. For businesses with multiple bank accounts, reconcile every account, including the savings and card accounts that are easy to forget.

When the reconciliation will not balance

Sooner or later the difference refuses to clear, and a systematic hunt beats staring at the screen. Start with the size of the difference: if it divides neatly by nine, a transposed digit is likely, two figures swapped somewhere. Check for a missing entry of exactly the difference amount, often a bank charge or a refund posted to the wrong account. Narrow the date range to isolate which week the error entered, and compare the software balance against the bank statement day by day within that week. Reversed entries, where a receipt was posted as a payment, show up as double the expected difference. Work methodically and the culprit almost always appears within the hour.

Make it stick

The routine fails when it depends on one heroic individual. Write it down as a one-page procedure, train a backup, and put the weekly slot in the calendar as a recurring meeting with the books. Report two numbers to management each month: the value of unreconciled items and the age of the oldest one. When both trend towards zero, the finance function is under control.

Clean books are not an accident; they are a routine, repeated weekly. For businesses without an in-house bookkeeper, that routine is exactly what outsourced support delivers. Finex Outsourcing is a Global Business Services provider, and its financial accounting outsourcing services keep reconciliations, ledgers and reporting disciplined week in, week out. Learn more at Finex Outsourcing.


Comments

Post a Comment

Popular posts from this blog

The bookkeeper's year-end file: what your accountant wants

Image
Every year, accountants send the same list of queries to clients, and every year clients answer half of them. The year-end file is how you break the cycle: a complete, organised pack that lets your accountant prepare the accounts without a fortnight of emails. Here is what goes in it. The reconciled trial balance Start with the end of the bookkeeping, not the beginning: a trial balance where every balance sheet account is reconciled. Bank accounts tied to statements, debtors and creditors agreed to aged listings, VAT control agreed to the returns, PAYE control agreed to the payroll summaries, and the directors loan account with a full transaction listing. An unreconciled control account is a question your accountant will ask; a reconciled one is a question they will not need to. The supporting schedules Behind each material balance, a schedule: fixed asset additions with invoices, prepayments and accruals with workings, stock valuation with the count sheets, and hire purchase or loan s...
Read more

Credit Notes Done Right: A Clean Process for AP and AR

Image
By John Thomas, Senior Accountant Credit notes are the unsung heroes of accurate bookkeeping. Every returned good, every pricing correction, every volume rebate ends with one, and every one that goes missing or gets mishandled leaves the ledgers wrong. Yet most small businesses handle credit notes informally: an email here, a netted-off payment there, no matching to the original invoice. Here is how to run a clean credit note process on both sides of the ledger. What credit notes actually do A credit note cancels or reduces an invoice that has already been issued. On the sales side, you issue a credit note to your customer; on the purchase side, your supplier issues one to you. In both cases it reduces what is owed and, where VAT applies, adjusts the VAT. The critical discipline is matching: every credit note must be linked to the original invoice it corrects. An unmatched credit note sitting in the system is a reconciliation problem waiting to happen, and a credit note applied to ...
Read more

Petty Cash Controls for Small Teams That Actually Work

Image
  Petty cash has a reputation problem. It feels too small to matter, which is exactly why it becomes the messiest corner of the bookkeeping. A tin of cash in a drawer, receipts stuffed into an envelope, nobody quite sure who took what last Tuesday. The amounts are small, but the discipline it teaches, or the habits it lets slip, run right through the rest of the finance function. Getting petty cash right is cheap and easy. Leaving it alone is how fifty-pound mysteries become audit findings. Run it as an imprest system The imprest system is the single most effective control and it costs nothing. You set a fixed float, say 200 pounds, and top it back up to exactly that amount each time you reimburse. At any moment, cash in the tin plus receipts must equal the float. If they do not, something is wrong and you know immediately. The alternative, topping up random amounts whenever the tin runs low, means the balance drifts and nobody can tell whether a shortfall is theft, error, or jus...
Read more