Checkbook Register Template (Excel)
Last updated June 2026
A paper register runs out of lines; this one recalculates instead. Enter a starting balance in cell C3, then record every check, deposit, and transfer in 200 pre-built rows on the Register sheet — the Balance column updates with each new line, and category and cleared drop-downs keep entries consistent. One sheet, one free .xlsx download.
Checkbook Register Template (Excel)
checkbook-register.xlsx · free · no signup
Works in Excel, LibreOffice Calc, and Google Sheets (File → Import).
SHA-256: a610bcd40ce5e3d2e8b1cf999d166755ba28c2fb414ed544ec47a493aa26e4cc
| A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| Date | Check # | Payee / Description | Category | Cleared | Withdrawal | Deposit | Balance |
| 7/1 | Paycheck | Income | $2,200.00 | $4,700.00 | |||
| 7/2 | 1041 | Rent | Housing | ✓ | $1,400.00 | $3,300.00 | |
| 7/5 | Groceries | Food | ✓ | $96.40 | $3,203.60 | ||
| 7/8 | Transfer to savings | Savings | $200.00 | $3,003.60 | |||
| 7/9 | 1042 | Electric bill | Utilities | $88.15 | $2,915.45 |
What's inside
Sheets
RegisterThe whole template. A title, a Starting balance input inC3, an eight-column header row, and 200 entry rows (rows 6–205) with the running-balance formula already copied down.
Columns
- DateWhen the transaction posted. Formatted as a date so it sorts correctly.
- Check #The check number for checks you write — leave it blank for debit, transfer, or deposit lines.
- Payee / DescriptionWho got paid or what the line is for, such as Rent, Groceries, or Paycheck.
- CategoryA drop-down with 12 categories (Income, Housing, Utilities, Food, and more) so you can filter or total by type later.
- ClearedA
✓drop-down you tick once the bank posts the transaction, separating pending from cleared. - WithdrawalMoney leaving the account — checks, debits, and transfers out.
- DepositMoney coming in — paychecks, refunds, and transfers in.
- BalanceThe running account balance after the row. It updates automatically and stays blank on empty rows.
Formulas that do the work
The first entry row anchors to the Starting balance in C3 with an absolute reference, subtracts that row's withdrawal, and adds its deposit.
Every row from 7 down checks whether both amount cells are empty; if so it shows nothing, otherwise it carries the cell above forward minus the withdrawal plus the deposit. It is copied to row 205.
How to use it
Set your starting balance
Open the
Registersheet and type your current account balance into cellC3, replacing the sample 2,500. Every Balance cell below recalculates from this number.Log each transaction
On the next empty row starting at row 6, enter the Date, an optional Check #, and the Payee / Description, then pick a Category from the drop-down in column D.
Enter the amount in one column
Put money you spent in Withdrawal (column F) or money you received in Deposit (column G) — never both. The Balance in column H fills in the moment you type an amount.
Mark cleared transactions
When the bank posts a line, click its Cleared cell and choose
✓from the drop-down. Anything left blank is still pending, so you can reconcile against your statement at a glance.Watch for a negative balance
A conditional-formatting rule turns any Balance cell red when it drops below zero, flagging an overdraft before it costs you. The header row stays frozen, so the running balance is always visible as you scroll.
Compatibility
- Microsoft Excel. Excel for Microsoft 365, Excel 2016 and later (Windows and Mac).
- LibreOffice Calc. Opens directly — formulas, validation lists, and formatting carry over.
- Google Sheets. Upload via File → Import → Upload, or drag the file into Drive and open with Sheets.
The category and ✓ drop-downs and the red negative-balance rule survive a Google Sheets import — open File → Import → Upload, then click a Category cell to confirm the list came through.
Frequently asked questions
- How does the running balance work?
- Each Balance cell takes the balance directly above it, subtracts that row's withdrawal, and adds its deposit, so the bottom line always reflects every transaction logged so far.
- Why is the Balance cell blank on empty rows?
- The formula uses
IF(AND(F7="",G7=""),"",…)to show nothing until you enter a withdrawal or deposit, which keeps the register clean instead of repeating the same number down 200 rows. - How do I add more than 200 transactions?
- Right-click row 205, choose Insert, then drag the fill handle on cell H204 through the inserted rows so the running balance keeps calculating past the original range.
- How do I reconcile against my bank statement?
- Mark each posted line with
✓in the Cleared column, then filter the header on✓and compare that subtotal with your statement's ending balance to find any missing entry. - Does this checkbook register work in Google Sheets?
- Yes. Upload it through File → Import → Upload and the running-balance formula, the drop-downs, and the red negative-balance formatting all carry over unchanged.