QBSpecialist
Free ReviewCall (850) 842-6767

Doc · Concept

Bank reconciliation

Bank reconciliation is the process of matching the cash balance in your books to the balance on the bank statement, accounting for timing differences, until the two agree exactly.

Call (850) 842-6767

Last reviewed October 2026

Bank-side items, and why reconciling catches fraud

Items the bank knows about before you do are their own category: bank service fees, interest earned, direct debits and automatic payments, returned deposits and chargebacks. They appear on the statement first, so a reconciliation is where they get entered — each with its own account, not forced into the difference.

It is also a fraud control. Matching every line of the statement to the books, every month, is how an unauthorized withdrawal, a duplicated vendor payment or a check you didn't write gets noticed while the bank can still act on it — banks set limits on how long you have to dispute an unauthorized transaction, so a reconciliation months behind can turn a recoverable loss into a permanent one.

Why bank reconciliation matters

Bank reconciliation

The reconciliation identity, worked $48,905.10 Book balance LESS $694.55 Outstanding items = $48,210.55 Bank statement CHECKS NOT CLEARED DEPOSITS NOT POSTED OUT BY 0.00 TO THE PENNY
Read this as text

Book balance of $48,905.10, less $694.55 of items still in transit, equals the $48,210.55 bank statement. The difference is out by 0.00, so the account is reconciled. A worked example.

A worked bank reconciliation: the book balance, less items still in transit, equals the statement. When the difference is out by 0.00, the account is reconciled for the period. Figures are illustrative.

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.

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.

Questions about reconciliation

How often should accounts be reconciled?

Every account, every month, against the statement. Monthly reconciliation keeps errors small and catchable; letting it lapse is what turns an ordinary month-end into a cleanup.

What if it won't reconcile?

A reconciliation that won't zero out usually means a duplicate, a deleted transaction, or a wrong opening balance. Isolating which one — and whether it's the file or the data — is exactly the kind of triage a specialist does first.

Do credit-card accounts need reconciling too?

Yes. Reconciliation applies to every account that issues a statement — checking, savings, credit cards, and lines of credit. Card accounts are the ones most often skipped, and unreconciled card activity distorts expenses the same way unreconciled bank activity distorts cash.

Is matching bank-feed transactions the same as reconciling?

No. Bank feeds match individual transactions as they arrive; reconciliation is the deliberate month-end check that the ending balance in your books agrees with the statement. A file can have every feed transaction matched and still be unreconciled.

Keep going

More on this topic