Bank Reconciliations: The Month-End Control That Keeps Your Ledger Honest

Bank reconciliations are the single most reliable check a bookkeeper has. Every other account in the ledger rests on judgement somewhere. The bank account rests on a third party's records, and that is what makes it the anchor of the month-end close.

What a reconciliation actually proves?

A bank reconciliation does not prove the bank balance is right. It proves the ledger and the bank agree once you account for the items in transit. Those items are the heart of the exercise: deposits the bank has not yet credited, cheques the payee has not yet presented, and bank charges you have not yet posted.

The reconciled balance is the ledger balance plus unpresented cheques, minus deposits in transit, minus unposted bank charges. If that figure equals the statement balance, the account reconciles. If it does not, something is missing, duplicated, or posted to the wrong account, and you find it before the close does.

Where it fits in the close?

Reconcile the bank before you reconcile anything else. Subsidiary ledgers like accounts receivable and payable feed cash movements, so cash is the account most exposed to errors elsewhere in the books. A clean bank reconciliation tells you the cash side of those subledgers is broadly sound, which is why it comes first in most close checklists.

It also sets the cut-off. Deposits in transit at month end become the opening position for next month, so a sloppy reconciliation this month quietly corrupts next month's before you even start.

What catches errors that nothing else catches?

Some errors only surface here. A transposed amount on a payment, a direct debit posted twice, a supplier cheque recorded against the wrong bank account, or a payment entered but never sent: all of these leave the ledger internally consistent and the reconciliation broken. That broken reconciliation is the only symptom.

Fraud shows up here too, or fails to. Missing cheque sequences, unexpected payees, or round-amount transfers to unfamiliar accounts are visible in the statement even when the ledger looks clean. This is why reviewers read the statement itself, not just the reconciliation summary.

What should the working paper contain?

A good reconciliation working paper shows the statement balance, the ledger balance, each reconciling item with its date and value, and the arithmetic that joins them. Attach the statement. Note who prepared it and who reviewed it.

Old reconciling items are the warning sign. A cheque unpresented for six months is probably stale and may need to be reversed or reissued, depending on your jurisdiction's rules on unclaimed payments. A deposit in transit that has not landed by the following month's statement is not in transit at all; it is an error, and it should be chased.

How often should you reconcile?

Monthly, at minimum, aligned to the statement date. For high-volume accounts, weekly or even daily reconciliations shorten the gap between an error and its discovery, which makes each one easier to fix. The longer the gap, the more transactions sit on top of the mistake and the harder the untangling becomes.

When does a reconciliation problem stop being bookkeeping?

A reconciliation that refuses to balance after genuine effort can signal something worse than a missed entry. If transactions appear in the ledger with no statement counterpart in volume, if history changes after the period was closed, or if the file behaves oddly when you open old periods, the data itself may be damaged. That is not a bookkeeping problem, and working it by hand can destroy the evidence a specialist needs.

Before anyone touches the file, take a backup or verified copy and note exactly what you observed. Then stop. If you need that kind of help, see our QuickBooks data repair service rather than attempting fixes inside the file.

Done monthly, kept simple, and reviewed by a second pair of eyes, the bank reconciliation is the cheapest control in the entire close. It is also the one that tells you, every month, whether the rest of the ledger deserves your trust.