Bank Reconciliation Helper

Reconciling your bank account catches errors, fraud, and missing transactions before they become problems. Enter your bank statement balance and book (QuickBooks/ledger) balance, then add outstanding checks and deposits in transit to produce a complete reconciliation statement.

Opening Balances

Bank Statement Ending Balance ($)

Book (Ledger) Balance ($)

Outstanding Checks (in books, not on statement)

Deposits in Transit (in books, not on statement)

Bank Errors / Service Charges (not in books)

Bank Charges / Errors ($)

Interest Earned (not in books) ($)

Bank Side

Statement Balance

+ Deposits in Transit

− Outstanding Checks

Adjusted Bank Balance

Book Side

Book Balance

+ Interest Earned

− Bank Charges

Adjusted Book Balance