Bank Reconciliation Variance Calculator

A bank reconciliation that does not balance to zero is not a minor bookkeeping inconvenience — it is an open control failure. The AICPA's internal controls framework identifies bank reconciliation as one of the four most fundamental detective controls in any accounting system. When the book balance and the bank statement balance disagree, the difference is called a variance — and that variance has a specific cause that must be identified before the period can close. Variances typically fall into four categories: outstanding checks, deposits in transit, bank charges not yet recorded, and errors. Leaving a reconciliation open or forcing a plug entry masks fraud risk and produces unreliable cash balances for financial reporting. This bank reconciliation calculator identifies the sources of variance, walks through the reconciliation logic, and shows which side of the balance each item belongs on.

This bank reconciliation calculator computes the reconciled cash balance and identifies the nature of any remaining variance. Enter your book balance, bank statement balance, list of outstanding checks, deposits in transit, bank service charges, NSF checks, and any book errors. The calculator adjusts both the book and bank side to their true reconciled balance, shows whether they agree, and categorizes any remaining variance by type. Use it for monthly close, audit preparation, or to trace the source of a stubborn reconciliation difference.