Bank Reconciliation preview
Transactions sheet with columns for bank and book references, amounts, differences, match keys, and status tracking. 1/5

About this bank reconciliation spreadsheet template

This bank reconciliation template helps accountants, treasurers, and small business owners match bank statement entries against internal book records across five structured sheets. The Transactions sheet logs bank and book references with amounts, differences, match keys, and statuses; the Unmatched Items queue surfaces bank-only entries and discrepancies with aging and action prompts; the Reconciliation sheet produces an adjusted bank and book balance statement; and the Dashboard delivers a high-level summary of matched, unmatched, and difference counts.

Every cell, formula, and label is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. The International Setup sheet includes currency and date convention settings so you can adapt the template for any local market.

5 structured sheets

Transactions, Unmatched Items, Reconciliation, Dashboard, and International Setup in one workbook.

Automated matching logic

Match keys and status columns help identify matched, bank-only, book-only, and difference entries quickly.

Clean dashboard layout

At-a-glance summary of reconciliation counts and key balance figures for reporting.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Bank Reconciliation template is designed for accountants, treasurers, and business owners to match bank statement entries with internal book records, track unmatched items, and produce a reconciliation statement. Customize the sample data, formulas, and layout in WPS Office for your own accounts.
Use the native XLSX in WPS Office, Microsoft Excel, Google Sheets, or Apple Numbers. For Notion workflows, reuse the data structure and reconciliation logic in a Notion database; for PDF reports, export the completed reconciliation in Adobe Acrobat.
Download the template, open it in WPS Office, and replace the sample transaction data, currency labels, date formats, and other editable cells with your own bank and book records.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for monthly bank reconciliations, audit preparation, cash flow tracking, and financial close processes. It is available for personal and commercial projects, subject to the applicable template license.