Free Checkbook Register Spreadsheet Template
Record checks, deposits, and withdrawals with a running balance. A digital version of the classic checkbook register for account reconciliation.
What's Included
- Dashboard with account balance showing current balance, total deposits, total withdrawals, and uncleared checks
- Register with check number, date, payee, description, and amount columns replicating a traditional checkbook layout
- Deposit and withdrawal columns with separate fields for credits and debits to the checking account
- Running balance calculation that updates automatically after every check written, deposit made, or withdrawal logged
- Reconciliation status tracking with color-coded cleared and uncleared indicators for monthly bank statement matching
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Preview
See what's inside this template
How to Use This Checkbook Register Template
Enter starting balance
Input your current checking account balance at the top. This is the starting point for the running balance.
Log transactions
Record each check, deposit, or withdrawal with the check number, date, payee, description, and amount.
Track the running balance
The register updates the balance after every entry. Compare it to your bank statement to catch discrepancies.
Reconcile monthly
Mark entries as cleared when they appear on your bank statement. The dashboard shows uncleared checks and deposits.
Built by Claude AI. Perfected by us.
We use Claude AI to draft each free 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.
Frequently Asked Questions
How do I reconcile with my bank statement?
Compare each bank statement transaction to your register. Mark matching entries as cleared. Any difference between the register and statement balance is the reconciliation variance.
Does it track uncleared checks?
Yes. Entries not marked as cleared are treated as outstanding. The dashboard shows total uncleared checks and deposits.
Can I track debit card purchases?
Yes. Enter debit card transactions just like checks - without a check number. The running balance includes all withdrawals regardless of type.
Is this still useful with online banking?
Yes. A checkbook register provides a real-time running balance and catches errors before they show up on the bank statement.
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.
More Free Special Purpose Templates
Looking for premium spreadsheet templates?
Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.