Finance

Bank Reconciliation Calculator

Reconcile your bank statement balance with your book (ledger) balance.

Bank Side

Bank Statement Balance ($)

+ Deposits in Transit ($)

− Outstanding Checks ($)

± Bank Errors ($)

Book Side

Book (Ledger) Balance ($)

+ Interest Earned ($)

+ Collections by Bank ($)

− Bank Fees ($)

− NSF Checks ($)

± Book Errors ($)

Reconciliation:
Adjusted Bank = Bank Balance + Deposits in Transit − Outstanding Checks ± Errors
Adjusted Book = Book Balance + Interest + Collections − Fees − NSF ± Errors
Reconciled when Adjusted Bank = Adjusted Book

How Bank Reconciliation Works

Bank reconciliation matches your internal records (book balance) with the bank's records (statement balance). Differences arise from timing (outstanding checks, deposits in transit) and items the bank knows about but you haven't recorded yet (fees, interest, NSF checks).

Common Reconciling Items

Bank side: Deposits in transit (+), outstanding checks (−), bank errors
Book side: Interest earned (+), bank fees (−), NSF checks (−), collections by bank (+)