Bookkeeping
Bank Reconciliation Template
Compare your bank statement with your ledger and identify the amount that remains unreconciled.
$229 USD
Purchase nowExcel .xlsx workbook · Digital delivery by email
What this workbook helps you do
Compare the bank statement with your accounting records at the same date. Record timing differences and other adjustments to see whether the adjusted balances agree and what remains to investigate.
At a glance
- Best for
- Reconciling an individual bank account at the end of a statement period.
- Format
- Microsoft Excel (.xlsx)
- Delivery
- Email attachment after payment
What’s inside
- Bank and ledger closing balances
- Register for outstanding payments, deposits, fees, and other adjustments
- Adjusted balances and remaining difference
Worksheets
- Start Here
- Setup instructions and a worked example.
- Items
- Record outstanding payments, deposits, fees, and other adjusting entries.
- Reconciliation
- Compare bank and ledger closing balances, track adjusted totals, and review the remaining difference.
Getting started
- Enter the bank and ledger closing balances for the same statement date.
- List the reconciling items that explain timing differences or other adjustments.
- Review the adjusted balances and investigate any difference.
Frequently asked questions
Can I use this for more than one account?
Use a separate copy for each account and statement. Enter the bank and ledger closing balances for the same date before recording adjustments.
What file format is included?
The template is a Microsoft Excel .xlsx workbook. It includes a Start Here tab with setup instructions and a worked example.
Which cells can I edit?
Use the blue cells for your entries. Green cells contain formulas and update as you enter your data.
How do I receive the workbook?
After payment is confirmed, we send the workbook as an email attachment to the address you enter at checkout.