Skip to content
The title slide and first slides of the Bank Reconciliation Worksheet template

Bank Reconciliation Worksheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Reconciling by eye means ticking two lists against each other and hoping nothing slips. This bank reconciliation worksheet does the matching. Paste the statement into one tab and your own entries into another, giving each item a reference. A line counts as matched when the other side holds the same reference and amount, and the rest turn amber. The Difference tab then counts the unmatched lines on each side, totals them and compares the statement balance with your book balance after those items are set aside.

The sample month has a fee and interest that appear only on the statement, a check and a late deposit that appear only in the books, and a difference of zero once they are explained. Small businesses use the same method for the monthly close, and households can use it for a joint account. Record the statement-only items in your books and the check and deposit will clear next month.

Useful for

  • Close the month for a small business account
  • Find a missing entry in a joint checking account
  • Explain outstanding checks and deposits in transit

What's included

  • 4 tabs: Statement, Book, Difference, How to use
  • Statement: a table
  • Book: a table
  • Difference: a table with 6 summary figures
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Statement tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I do a bank reconciliation?

Compare each line on the bank statement with your own records, mark what matches and list the rest. Items on the statement but not in your books, such as fees, need recording. Items in your books but not yet on the statement are usually checks or deposits in transit.

What is a deposit in transit?

A deposit in transit is money you have recorded as deposited that has not yet appeared on the bank statement, often because it was made after the statement cut-off.

Why do my book balance and bank balance differ?

Timing differences, bank fees and interest, and entry mistakes are the common causes. This worksheet lists each unmatched line so you can see which explain the gap.

  • #tracker
  • #bank-reconciliation-worksheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…