Bookkeeping

Bank Reconciliation Template

Compare your bank statement with your ledger and identify the amount that remains unreconciled.

$229 USD

Purchase now

Excel .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

  1. Enter the bank and ledger closing balances for the same statement date.
  2. List the reconciling items that explain timing differences or other adjustments.
  3. 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.