Skip to content
The title slide and first slides of the Checkbook Register template

Checkbook Register

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

A paper register still works, but the arithmetic is where mistakes creep in. This checkbook register keeps one row per check, debit or deposit, with a payee, a category, a payment or deposit amount and a Cleared tick box. The balance column updates on every row from an opening balance you set on the Reconcile tab. That tab compares the balance of cleared items with the ending balance on your statement and shows the difference, which should be zero, along with how many entries are still waiting to clear.

Fourteen sample entries show a month of paychecks, rent, groceries and fuel, with the last three still uncleared. Enter each item the day you write it, because the register is for what you know and the bank statement is for what has happened. When the statement arrives, tick the cleared lines, type the statement balance and read the difference. Any gap points to a missing entry or a transposed digit.

Useful for

  • Balance a checking account against the monthly statement
  • Track checks written but not yet cashed
  • Keep a record of spending by category

What's included

  • 3 tabs: Register, Reconcile, How to use
  • Register: a table with 4 summary figures
  • Reconcile: a table with 4 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 Register 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 balance a checkbook?

Start with the ending balance from the statement, add any deposits that have not cleared and subtract any payments that have not cleared. The result should equal the balance in your register. This sheet shows the difference directly.

What is a cleared transaction?

A cleared transaction is one the bank has processed and shown on your statement. Checks you wrote that the payee has not cashed yet are uncleared.

Why does my register not match the bank statement?

The usual causes are an entry left out, a wrong amount, a bank fee or interest you have not recorded, and uncleared items. Add missing entries and tick everything that appears on the statement.

  • #tracker
  • #checkbook-register
  • #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…