Free Check Register Template (Excel)
What's in the check register template
The Register sheet is a row-per-transaction log with Date, Check #, Payee/description, Category, Payment ($), Deposit ($), and Balance ($), sized for up to 200 transactions — enough to track a checking account for months.
You start by entering your opening balance as the first deposit row, then every transaction after that follows the same simple format.
The Category column also lets you tag each transaction — rent, groceries, utilities, business expense — so the register doubles as a rough spending record even though its main job is tracking your balance.
What calculates automatically
The Balance column updates on every single row as you enter payments and deposits, so you always see your running balance without adding anything up yourself.
At the bottom, the sheet also totals your payments and your deposits for the period, giving you a quick check on total cash in and out alongside the running balance.
Those two totals are also a built-in error check: if your ending balance doesn't match starting balance plus deposits minus payments, you know immediately that a row was entered incorrectly, before it snowballs into a bigger reconciliation headache.
Why this beats a blank spreadsheet
A DIY check register means writing a running-balance formula yourself and copying it down every time you add a row — miss one row and your balance is silently wrong from that point on.
Bank apps also often summarize rather than itemize, especially for check payments, so a dedicated register is still the clearest way to see every check number and payee lined up against your running balance.
This template's balance formula is already built into every row, so the running total stays accurate no matter how many transactions you log, and the payment/deposit totals give you an independent sanity check.
Who this check register template is for
Anyone who wants a clearer, more detailed view of their checking account than their bank's app provides will find this useful — especially people who write physical checks regularly, since the Check # column keeps a paper trail that bank apps often don't surface well.
It also suits small business owners keeping a simple manual record of a business checking account, side by side with or instead of accounting software, particularly when the volume of transactions is modest enough that a full bookkeeping system feels like overkill.
Families managing a shared household account, or anyone reconciling a checkbook the traditional way, get a familiar row-by-row format with the manual balance math already handled — one less place for arithmetic mistakes to creep into your account records.
How to use it
- Enter your starting balance as the first Deposit row.
- Log every transaction: date, check number, payee, category, and the amount as either Payment or Deposit.
- Watch the running balance update automatically on every row.
- Check the total payments and total deposits at the bottom for a period summary.
Download the free Free Check Register Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
If you need more than a running balance — categorized expenses ready for taxes — the paid Bookkeeping template ($19) adds Schedule C categorization, a tax dashboard, and CPA-ready export.
See the full versionFrequently asked questions
Can I use this check register in Google Sheets?
Yes. Upload it to Google Drive, then File > Save as Google Sheets, and the running balance keeps updating.
Is the check register template free?
Yes, in exchange for an email address to download it. No further cost after that.
Can I print it for my paper records?
Yes, the row layout prints cleanly, or you can export it to PDF.
Can I add categories specific to my spending?
Yes, the Category column is plain text you can adapt to whatever categories you track.
What's the license for using it in my business?
Personal use or use within one business. Not for resale or redistribution as a template product.