Lifetime Deal Complete Personal Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Checkbook Register Spreadsheet Template for Google Sheets & Excel

Fifty entries, each with a date, a check number, a payee and a description, and a balance that carries down and stops where your entries do. The Essentials Checkbook Register spreadsheet template adds a Cleared column and a second balance built only from the entries you have marked cleared - the figure to set against the bank, rather than the one that includes what has not landed yet. Google Sheets and Excel. No macros, no VBA.

Instant digital delivery · Terms & Conditions apply

Essentials Checkbook Register spreadsheet template - Google Sheets and Excel preview

What's Included

  • A starting balance in its own labelled cell
  • Date, check number, payee and description on every entry
  • Separate payment and deposit columns
  • A balance that carries down and stops where your entries do
  • A Cleared column, with a second balance built only from the entries marked cleared
  • A dashboard with six figures
  • Total deposits, total payments and the net change across the period
  • A count of entries logged and of checks written
  • A chart of payments against deposits
  • A chart of the balance across the period
  • Works in Microsoft Excel and Google Sheets with no setup required

The FinancialAha Essentials Checkbook Register Spreadsheet Template is a two-sheet workbook for Google Sheets and Excel, with a How to Use guide on a third tab. It works as an Essentials Checkbook Register Excel template and an Essentials Checkbook Register Google Sheets template from the same download. A starting balance, a check number and a payee on every entry, a balance that carries down the sheet, and a dashboard reporting the current balance, what came in, what went out and how many checks you wrote. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Checkbook Register spreadsheet template

The FinancialAha Essentials Checkbook Register Spreadsheet Template runs on two working sheets, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Checkbook Register spreadsheet holds.

  1. 01 of 02

    Register

    A starting balance in its own labelled cell, then the entries. Each carries the date, the check number where there is one, who it went to, what it was for, and either a payment or a deposit. The balance follows down the sheet from the starting figure. The payee column is what makes a register searchable later. A description says what you thought you were paying for; a payee says who took the money, and when a charge is queried months later that is the field that settles it. The check number does the same job for anything written on paper - a number that ties the row to a physical document. Rows left empty leave the balance blank rather than repeating the last figure, so the column stops where your entries do rather than running a flat line to the bottom of the sheet. The last column is Cleared, and the totals row turns it into a second balance: the starting figure adjusted only by the entries you have marked. Set against the full balance, the difference is everything written but not yet gone through - which is the number a bank statement is actually reconciled against, and the reason a paper register was ever kept.

    FinancialAha Checkbook Register spreadsheet template - Register sheet

  2. 02 of 02

    Dashboard

    Six figures and two charts. The top row carries the current balance after every entry, the total that came in and the total that went out. The row beneath carries the net change across the period, how many entries are logged and how many of those were checks. The check count is a small figure that answers a practical question: whether the chequebook is still being used enough to be worth reconciling by hand. The charts set payments against deposits and then plot the balance across the period, which is the view that shows whether an account is drifting down over months rather than in any one week.

    FinancialAha Checkbook Register Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering the starting balance, what each column expects, how the balance carries, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Checkbook Register Spreadsheet template for Google Sheets

Upload the Essentials Checkbook Register Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Checkbook Register Google Sheets template needs no conversion step, both charts come across, and the balance and dashboard recalculate exactly as they do in Excel.

Essentials Checkbook Register Google Sheets template setup

A shared copy of the Essentials Checkbook Register Google Sheets template suits a joint account, where the payee column tends to answer the question before it gets asked.

Running the Essentials Checkbook Register Google Sheet

The Essentials Checkbook Register Google Sheet takes an entry at a time and updates everything else itself. The balance history chart is the part worth looking at monthly rather than daily.

Essentials Checkbook Register Spreadsheet template for Excel

The Essentials Checkbook Register spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Checkbook Register Excel template directly, with no import step, and both charts are native Excel charts rather than pictures. There are no macros and no VBA in the file.

Essentials Checkbook Register Excel template setup

The same Essentials Checkbook Register Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Checkbook Register spreadsheet download to choose between.

Essentials Checkbook Register spreadsheet Excel notes

The Essentials Checkbook Register spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.

Opening the Essentials Checkbook Register spreadsheet Excel file

Nothing in the Essentials Checkbook Register Excel template is version-specific, so this Essentials Checkbook Register spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Spreadsheet template highlights

What the Essentials Checkbook Register spreadsheet template tracks

A starting balance, then a row per entry. This is what the Essentials Checkbook Register Spreadsheet Template carries:

Date
when the entry happened
Check #
the number on the cheque, which is also what the dashboard counts
Payee
who took the money, and the field that settles a query months later
Description
what it was for
Payment
money out
Deposit
money in
Cleared
mark it Y once the entry has reached the bank, and the cleared balance follows
Balance auto
derived, carried from the starting balance and blank past your last entry

Compare builds

FinancialAha Checkbook Register spreadsheet template: Free and Essentials compared

Feature Free View Spreadsheet Template Essentials This page
Working sheets 1 2
Transaction rows 16 50
Running balance Yes Yes
Opening balance A row at the top Its own labelled cell
Check number Yes Yes, beside a payee
Payee – Yes
Cleared marker – Yes, with a cleared balance
Category Yes –
Deposit and payment totals – Yes
Net change for the period – Yes
Count of checks written – Yes
Balance history chart – Yes
Charts – 2

The Free Checkbook Register Spreadsheet Template is a bank register - dates, descriptions, categories, money in and out, and a balance that follows. The FinancialAha Essentials Checkbook Register Spreadsheet Template is the chequebook version: a check number and a payee on every line, a labelled starting-balance cell, a longer register, and a dashboard carrying the current balance, the totals in and out, the net change, the entry count and how many of them were checks, with a chart of the balance across the period. It also adds a Cleared column with a cleared balance beneath it, so the register can be reconciled against a statement rather than only totalled. It trades the free build's category column for the payee one.

Compare the other builds: Free Checkbook Register spreadsheet template .

Good to know

Notes on working in the Essentials Checkbook Register spreadsheet template

  • The starting balance is its own labelled cell here, so the figure everything follows from is not buried in the first row.
  • The payee column is what makes a register searchable later - a description says what you thought you were paying for, a payee says who took the money.
  • Rows you have not filled leave the balance blank rather than running a flat line down the sheet.
  • The check count answers whether the chequebook is still in use enough to be worth reconciling by hand.
  • The balance history chart shows drift across months, which no single week reveals.
  • The cleared balance counts only the rows you have marked, so the gap between it and the full balance is what has not reached the bank yet - which is the figure a statement is actually reconciled against.
  • The Cleared column is free text rather than a dropdown, and the totals row matches on Y, so that is the letter to use.
  • The currency dropdown relabels the money columns across the workbook. It changes the label only and does not convert the numbers.

How to Use the Essentials Checkbook Register Spreadsheet Template

1

Set the starting balance

Its own cell at the top of the register.

2

Log each entry

Date, check number if there is one, payee and amount.

3

Watch the balance

It carries from the starting figure down the sheet.

4

Read the dashboard

In, out, net change and how many checks you wrote.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Checkbook Register Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". Both charts come across in the Essentials Checkbook Register Google Sheets template, and the balance and dashboard recalculate exactly as they do in Excel.

Is the FinancialAha Essentials Checkbook Register Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Checkbook Register Excel template opens directly in Excel with no import step. Both charts are native Excel charts rather than pictures, and there are no macros or VBA.

Will the FinancialAha Essentials Checkbook Register spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Checkbook Register spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

What does the payee column add?

A record of who took the money. A description says what you thought you were paying for; when a charge is queried months later, the payee is the field that settles it.

Does it have a category column?

No. This build trades the free build's category column for a payee and a check number. It identifies who and which cheque rather than grouping spending by type.

Can I mark entries as cleared?

Yes, on this build. The register carries a Cleared column, and the totals row beneath it holds a second balance built only from the rows marked cleared - the starting balance adjusted by those entries alone. Reading it against the full balance is the reconciliation: the gap between them is everything still in flight. The Free build has no such column.

What is the check count for?

A practical question - whether the chequebook is still being used enough to be worth reconciling by hand. It counts the rows that carry a check number.

How do I open the Essentials Checkbook Register spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Special Purpose Templates

Christmas Budget

A row per person on the gift list, with the relationship beside the name, a column for what you are giving or still considering, a budget and an actual, and a purchased flag - which is the only question that matters two weeks out. The Essentials Christmas Budget spreadsheet template keeps decorations and other holiday costs in blocks of their own. Twenty rows, three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Event Budget

Venue, catering, entertainment, decor and marketing each get their own line items with a subtotal at the foot, and a notes column takes vendor names and due dates. The Essentials Event Budget spreadsheet template derives the difference on every line and reports total budget, total spent, over or under, and the share used on a dashboard, so a category that is drifting shows up early. Two working sheets and two charts, Google Sheets and Excel. No macros, no VBA.

$19

Baby Budget Planner

One-time purchases and monthly costs sit in blocks of their own, each totalling itself, with every recurring item converted to its annual figure so the two can be added honestly. The Essentials Baby Budget Planner spreadsheet template puts a share-of-first-year column on every line and gives the estimated total a monthly and a daily average - the numbers that make a year of costs legible. Three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Home Renovation Budget

Eight projects, each named to match your renovation, and each budget split three ways - labour, materials and permits - so an overrun can be traced to what caused it. The Essentials Home Renovation Budget spreadsheet template derives the total from those three columns, sets actual spend and variance against it per project, and leaves a notes column for vendors, dates or a change of scope. Dashboard on its own tab. Google Sheets and Excel, one file. No macros, no VBA.

$19
Essentials
Preview
See Bill Tracker Ultimate Pack 5 templates included • Save $76

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →