Free Download - Excel & Google Sheets

Free Checkbook Register Spreadsheet Template

Classic check register with deposits, withdrawals, and running balance.

Works in Excel and Google Sheets · CC BY 4.0

What's Included

"Register" sheet with deposit, withdrawal, and running-balance columns
Running balance updates automatically after each entry
Simple date/description/category layout - easy to reconcile
Step-by-step "How to Use" guide included in a second sheet
Works in Microsoft Excel, Google Sheets, and LibreOffice Calc - no setup or sign-up

Free and Essentials - what's the difference?

Free $0

"Register" sheet with deposit, withdrawal, and running-balance columns
Running balance updates automatically after each entry
Simple date/description/category layout - easy to reconcile
Step-by-step "How to Use" guide included in a second sheet
Works in Microsoft Excel, Google Sheets, and LibreOffice Calc - no setup or sign-up

Good for getting started

Essentials $12

Everything in Free
Full-featured Checkbook Register with dashboard and detailed analytics
Pre-filled subcategories, sample scenarios, and helper calculations
Larger data capacity for real-world usage
$12 one-time purchase, lifetime access

View Essentials →

How the Checkbook Register template works

Classic check register with deposits, withdrawals, and running balance. Open the spreadsheet, enter your own numbers, and let the formulas do the math.

When this template helps

You want a running balance on a single account without connecting to the bank.
You are reconciling statements and want one line per transaction.
You need a simple record for a petty cash box, personal account, or small fund.
You prefer pen-and-paper style entry in a digital file.

Tips to get the most out of it

Keep the column labels simple - the formulas work best when categories are consistent month to month.
Reconcile against statement regularly - once a week is a good rhythm for most people.

Common mistakes to avoid

Entering transactions out of date order. The running balance column assumes chronological entries.
Missing a beginning balance. Without an opening row, the running balance starts from zero.
Reconciling once a year. Do it monthly - catching errors earlier saves time.

How to Use This Checkbook Register Template

Review the sample data so

Review the sample data so you understand the layout.

Replace the sample values

Replace the sample values in the highlighted input cells with your own deposits and withdrawals.

Totals and KPI strip

The totals and KPI strip at the top update automatically from your data.

When you hit

When you hit the row limit, upgrade to Essentials (or Ultimate) for more capacity.

Built by Claude AI. Perfected by us.

We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.

Works in Excel and Google Sheets · CC BY 4.0

Frequently Asked Questions

What is included in the free version?

The free Checkbook Register is a single-sheet template with sample data and a "How to Use" guide. It covers the essentials. The Essentials version ($12) adds a dashboard, larger capacity, and extended categories; Ultimate (when available) adds multi-entity tracking and ultimate-grade reporting.

Does the running balance update automatically?

Yes. Each new entry recalculates the running balance column based on the prior row plus deposits minus withdrawals.

Can I use this for reconciliation?

Yes. Enter transactions in date order and compare the ending balance to your statement. Flag discrepancies in the description column.

Is the file safe to download?

Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel, Google Sheets, or LibreOffice Calc.

How do I open this in Google Sheets?

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

What license is this template under?

All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.