What is the basic bank reconciliation formula?

The fundamental bank reconciliation formula adjusts both balances to reach an agreed true cash position: Adjusted Bank Balance (Bank Statement Ending Balance + Deposits in Transit - Outstanding Checks) = Adjusted Book Balance (General Ledger Cash Balance + Unrecorded Bank Additions/Interest - Unrecorded Bank Charges/Fees).

What is the difference between a bank statement and a bank reconciliation statement?

A bank statement is an external document issued by a bank detailing cleared deposits, withdrawals, and balances over a statement period. A bank reconciliation statement is an internal accounting schedule created by a business or bookkeeper that identifies timing differences (e.g., outstanding checks, deposits in transit) and explains why the bank balance differs from the general ledger balance.

What are the main steps to reconcile a bank statement?

The core steps are: 1) Verify the opening statement balance against the previous reconciled closing balance; 2) Match cleared deposits between the bank statement and cash book; 3) Match cleared withdrawals and identify outstanding checks; 4) Post journal entries for unrecorded bank fees, interest, or direct debits; 5) Calculate the adjusted bank and book balances; 6) Investigate any remaining variance until the reconciliation is balanced.

Why does a bank statement balance rarely match the general ledger balance?

Discrepancies naturally occur due to timing differences (checks written that have not yet been cashed, deposits made after banking cutoff hours), bank-initiated fees or interest not yet recorded in the ledger, and human data entry mistakes.

Does a zero reconciliation difference prove every transaction is correct?

Not necessarily. Offsetting omissions, compensating transposition errors, or duplicate entries of equal amounts can still produce a zero net variance. Row-level transaction matching and continuous running balance checks remain essential.

How does converting PDF bank statements to Excel help reconciliation?

Converting PDF statements into structured Excel (.xlsx) or CSV files allows accountants to run automated VLOOKUP matching, sort by amount or date, run running-balance integrity checks, and prepare clean tabular datasets for 1-click import into accounting software without manual data entry errors.

Which records should be retained after completing a bank reconciliation?

You should retain the original bank-issued statement PDF, the reviewed transaction dataset, the finalized bank reconciliation statement, copies of adjusting journal entries, and preparer/reviewer sign-offs for the duration required by statutory tax and accounting retention guidelines (usually 5–7 years).

How Bank Statement Reconciliation Works: Step-by-Step Guide

Understand what bank reconciliation is, how a bank reconciliation statement works, the 7 steps to reconcile accounts, and how to resolve discrepancies.