Posted in

10 Free Bank Reconciliation Templates in Excel

Match statement activity to the ledger and isolate the difference before closing. These free bank reconciliation templates for Excel give you ten editable worksheets for different parts of the job. Each has its own inputs, example, and calculated result. Download an individual template or get the complete workbook.

Use the monthly bridge after you have reconciled individual transactions. The bridge compares adjusted statement and ledger balances, including deposits in transit, outstanding checks, and book-side adjustments.

Jump to the Excel download and previews

Download the 10 Excel templates

Download all 10 templates (.xlsx)

Choose a template below to see its preview and download it as a standalone Excel file. The combined workbook above includes all ten templates as separate tabs.

Preview and download individual templates

Monthly bridge

Enter account, statement balance, deposits in transit, outstanding checks, book balance, book additions, book deductions. The worksheet calculates difference for each record.

Monthly bridge Excel template previewDownload Excel (.xlsx)

Deposit clearing

Enter deposit reference, book amount, bank amount. The worksheet calculates difference for each record.

Deposit clearing Excel template previewDownload Excel (.xlsx)

Outstanding checks

Enter check number, issued amount, cleared amount. The worksheet calculates still outstanding for each record.

Outstanding checks Excel template previewDownload Excel (.xlsx)

Bank fees

Enter statement reference, fee shown, fee posted. The worksheet calculates unposted fee for each record.

Bank fees Excel template previewDownload Excel (.xlsx)

Interest posting

Enter statement month, bank interest, ledger interest. The worksheet calculates unposted interest for each record.

Interest posting Excel template previewDownload Excel (.xlsx)

Transfer matching

Enter transfer id, sent, received. The worksheet calculates unmatched amount for each record.

Transfer matching Excel template previewDownload Excel (.xlsx)

Card settlement

Enter batch id, card sales, refunds, processor fees, bank deposit. The worksheet calculates difference for each record.

Card settlement Excel template previewDownload Excel (.xlsx)

Petty cash count

Enter count reference, opening float, top-ups, vouchers, cash counted. The worksheet calculates difference for each record.

Petty cash count Excel template previewDownload Excel (.xlsx)

Exception review

Enter exception id, expected amount, recorded amount, owner. The worksheet calculates difference for each record.

Exception review Excel template previewDownload Excel (.xlsx)

Close sign-off

Enter account, adjusted bank, adjusted books, reviewer. The worksheet calculates review status for each record.

Close sign-off Excel template previewDownload Excel (.xlsx)

Set up your tracker in Excel

  1. Save a working copy and open the worksheet you need. Look at the sample row to see which values you enter and where the calculated result appears.
  2. Replace the sample with your first real record. Keep the tinted result column for formulas, and use the input headers to preserve units and meaning.
  3. Enter one row per record for the selected workflow. Each sheet has 30 formula-ready rows. Copy the formula down if you extend the sheet.
  4. Compare the first calculated result against your source records or a manual check before relying on the sheet.

Worked example

A 12,500 statement balance plus 900 of deposits in transit less 450 of outstanding checks equals 12,950. A book balance of 12,990 less an unposted 40 fee also equals 12,950.

Before sharing or closing the tracker

Check whether the difference is a timing item before adjusting the ledger. Retain evidence for outstanding items and follow up if they fail to clear.

Keep the source evidence with the working copy, particularly when an entry changes after review. Record who checked it and the date if the spreadsheet is used for a handoff or approval.

Related templates

For adjacent work, see Excel bookkeeping templates and check register templates.

Ravin edits WordTemplatesPro’s collections of templates, examples and practical setup guides. His editorial focus is clear instructions, understandable file labels and layouts readers can adapt to their own records and projects.