The Bank Reconciliation Statement Template is a practical, fill-in-the-blank guide designed for accountants, bookkeepers, and finance teams who need to reliably align bank and ledger balances every period. This template turns a once-a-month task into a repeatable workflow that reduces errors, speeds up close, and improves audit readiness.
What's inside
Statement Details: period, opening balances, and ending balances
Reconciliation Table: itemized differences between bank and books
Adjustments & Journal Entries: planned entries to correct the records
Supporting Documents: attach bank statements, check images, and receipts
Review & Approvals: built-in sign-off fields and dates
How to use this template
Fill the Statement Details with the period and opening balances for both the bank and the general ledger.
Enter the Bank Ending Balance and Ledger Ending Balance from the period-end statements.
Populate the Reconciliation Table with all reconciling items such as deposits in transit, outstanding checks, and fees not yet recorded.
Create Adjustments & Journal Entries to correct the books, then post them to the general ledger.
Attach all Supporting Documents and route for Review & Approvals.
Why it works
What if the balances don’t reconcile?
Double-check timing differences like deposits in transit and outstanding checks, re-run the reconciliation, and verify that all adjustments are properly coded.
Who should approve?
Typically the Finance Manager or Controller signs off, with archival copies kept for audit.
Can this handle multiple bank accounts?
Yes. Use a separate reconciliation per bank account and consolidate results in a master summary if needed.
FAQs
What if there are errors in the bank statement? Flag the item, contact the bank, and document the correction in the journal entry.
How often should this template be used? Monthly at minimum; use more frequently for high-volume cash environments.