Bank Account Reconciliation Template
Reconcile all bank accounts to the general ledger and identify and resolve reconciling items.
How to use this template
Obtain bank statement
Collect the bank statement for each account for the period being reconciled.
Start with bank balance
Note the ending cash balance per the bank statement as the starting point.
Add deposits in transit
Add deposits recorded in the GL but not yet reflected in the bank statement.
Subtract outstanding checks
Subtract checks written and recorded but not yet cleared by the bank.
Adjust for other items
Adjust for bank errors, service charges, and other reconciling items.
Why use this template
- Ensures cash balance in the GL matches bank records
- Identifies theft, fraud, or unauthorized transactions
- Detects bank errors and processing issues
- Provides audit support for cash accounts
Related templates
Prepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Close ManagementStandard Month-End Close Checklist
A comprehensive checklist to ensure nothing falls through the cracks during your month-end close. Track every task, owner, and deadline in one place.
Close ManagementClose Calendar Template
Plan out your entire month-end and quarter-end close timeline with a structured calendar. Coordinate across teams and set clear deadlines.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.