Excel workbook .xlsx

Bank Reconciliation Template

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

$229 USD

Purchase now

What’s inside

  • Bank and ledger closing balances
  • Register for outstanding payments, deposits, fees, and other adjustments
  • Adjusted balances and remaining 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.