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
Daily Cash Position Report
Prepare a daily summary of cash balances across all accounts and locations for liquidity monitoring.
Cash & TreasuryLiquidity Forecast Model
Build a rolling cash flow forecast model to project cash position over the next 13 weeks.
Cash & TreasuryWire Transfer Approval Log
Document and track all wire transfers with appropriate authorizations before payment is released.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.