Bank reconciliation

Why bank reconciliation matters

Bank reconciliation is the single check that proves your recorded cash is real. Until an account is reconciled, every report that touches cash — the balance sheet, the cash-flow statement, the P&L via deposits — is unverified.

It is the first thing a specialist does in a cleanup and the last thing skipped in a healthy month-end.

Bank reconciliation

The reconciliation identity

The reconciliation identity is the arithmetic every bank reconciliation rests on: the book balance, minus checks that haven't cleared, plus deposits the bank hasn't posted, equals the bank statement balance — exactly, to the penny.

Read the worked figure above through that lens: a book balance, less the items still in transit, lands on the statement balance with a difference of 0.00. The identity is unforgiving on purpose. It does not hold "close enough" — a difference of one cent means something in the ledger does not match something at the bank, and the reconciliation is not done until that something is found. That strictness is what makes a finished reconciliation meaningful: it is arithmetic proof, not a judgment call, that the cash on your balance sheet is real.

How the difference resolves

The book balance and the statement rarely match on the day you look, because some items are in transit: a check you wrote that hasn't cleared, a deposit the bank hasn't posted.

Reconciliation lists those outstanding items, applies them, and confirms the adjusted balances agree. When the difference is zero, the account is reconciled for that period. If you'd rather have it done for you — one account or a whole backlog of months — that is our bank reconciliation service, which works exactly this method on every account in the file.

Why a reconciliation won't finish

A bank reconciliation that won't finish — a difference that refuses to reach zero — almost always traces to one of four causes: a changed beginning balance, a duplicate transaction, a missing transaction, or a mistyped amount.

The beginning balance is the usual suspect. Each reconciliation starts where the last one ended, so if a previously reconciled transaction has since been edited, deleted, or un-cleared, the starting point itself is wrong and no amount of ticking will bring the difference to zero. Duplicates typically come from bank feeds — a transaction entered by hand and then accepted again from the feed. Missing transactions are the ones the bank knows about but the books don't: fees, interest, an autopay nobody recorded. And a transposed figure leaves a difference that divides evenly by nine — an old bookkeeper's tell. The wrong response to all of these is the adjustment entry QuickBooks offers when you give up: it forces the difference to zero without explaining it, which buries the error instead of fixing it and hands the same problem to next month.

What a stale uncleared transaction means

A stale uncleared transaction is a check or deposit that has sat unmarked through several reconciliations — recorded in the books but never confirmed by the bank. It usually signals a recording error, not slow banking.

Checks clear in days and electronic payments faster, so an item still uncleared months later is telling you something. An old uncleared check is usually a duplicate of a payment recorded another way, a check that was never actually sent, or one voided at the bank but not in the books — and until it is resolved, the ledger understates cash. An old uncleared deposit is worse: it often means income was recorded that never reached the bank, which overstates both cash and revenue, and it frequently points back to a mishandled Undeposited Funds balance. Either way the resolution is the same discipline — trace the item to a real event, then correct or void it deliberately, rather than letting it ride uncleared into another year.

What the R status and the reconciliation report mean

In QuickBooks, every transaction in a register carries a reconciliation status: blank for unmatched, C for cleared against the bank feed, and R for reconciled — confirmed against a statement in a finished reconciliation.

The distinction matters because C is provisional and R is proof. A transaction marked C has merely been matched or accepted from the bank feed; only completing a reconciliation stamps it R, which is why a file can show every feed transaction matched and still be unreconciled. Each finished reconciliation also produces a reconciliation report — the period's list of cleared items and the balances they prove — which QuickBooks Online keeps under its reconciliation history and QuickBooks Desktop exposes as the Previous Reconciliation report. That saved report is the evidence a later bookkeeper, lender, or auditor checks, and re-running the history is how a broken beginning balance is traced back to the month it broke.

Where this shows up

In practice, reconciliation surfaces here as the core of cleanup work — unreconciled accounts are the most common reason books need rescue — and as the monthly discipline that keeps a clean file clean.