Editorial illustration for 10+ FREE Checkbook Register Templates [Excel & Word]

2+ FREE Checkbook Register Templates [Excel & Word]

A checkbook register is a running ledger for one bank account. Every cheque you write, card payment, transfer, withdrawal and deposit goes on its own line, and after each entry you update the balance. The result is a record of what the account holds right now, including payments the bank may not have processed yet. That is something a mobile banking app cannot always show, because outstanding cheques and pending payments can lag.

For nearby paperwork on this site, open the Practical Equipment Bill of Sale Templates, then the BEST Employee of the Month Certificate Templates or the Excellent Conference Agenda Templates.

A register is different from a weekly budget. A budget plans how much you intend to spend in each category; a register records what actually moved through a single account, line by line. Many people use both, but the register is the one that keeps you from overdrawing.

Choosing a register layout

The samples below carry a range of labels.

  • The Worksheet and Blank Word versions suit people who prefer to print the register and write entries by hand.
  • Excel versions, including the Customizable, Professional, Editable and Excel Example samples, suit people who want a digital sheet they can extend.
  • Standard, Official, Detailed and Special templates vary in how many columns they show.
  • The Printable template is a quick option for keeping a paper copy with a chequebook.

When previewing, look for columns for date, cheque or reference number, description, payment, deposit, a cleared mark and balance. Choose the layout whose columns match how you actually pay.

Download the BEST Checkbook Register Templates Below

Personal Checkbook Register Template

An Excel running ledger for one account, with date, reference, description, payment, deposit, cleared mark, category, and a calculated running balance. Sample rows are illustrations only.

Personal checkbook register template preview — free editable Excel workbook from Templates Show

File Size: 8 KB

Checkbook Register with Reconciliation Template

A three-sheet Excel workbook: a running register, a statement reconciliation (outstanding items and a difference that should be zero), and a monthly payments-and-deposits summary.

Checkbook register with reconciliation template preview — free editable Excel workbook from Templates Show

File Size: 11 KB

Recording each transaction

  1. Write the starting balance at the top, taken from your latest statement or online banking on the same day.
  2. For each cheque, record the date, the cheque number, the payee and the amount.
  3. Record card payments, standing orders, direct debits, transfers and cash withdrawals the same way, using a short reference code.
  4. Enter deposits in the deposit column, including transfers in and interest.
  5. After every line, subtract payments or add deposits to update the balance, and double-check the sum.
  6. When your statement arrives, tick each entry that appears on it in the cleared column.
  7. Add bank fees or interest you were not aware of, then compare the register balance with the statement after allowing for uncleared items.

Habits that keep the balance trustworthy

Record transactions the same day. The longer you wait, the more likely something is missed.

Write down automatic payments in advance. Subscriptions and loan repayments that leave on fixed dates are easy to forget.

Keep receipts until the entry clears, then file or discard them according to your record-keeping needs.

Use one register per account. Mixing a joint account and a personal account on one sheet invites mistakes.

Reconcile monthly. A small discrepancy is far easier to trace within a month than after several.

Agree on a routine for shared accounts. If two people spend from one account, decide who records what and when to compare notes.

When to start a fresh register

Many people begin a new page or sheet each month or each statement period, carrying forward the reconciled balance. This keeps the register manageable and links each page to one bank statement. If you use a spreadsheet, save each period as a separate tab or file with the month in its name.

Start fresh, too, after a significant correction, such as discovering a long-standing error. Write a short note explaining the adjustment and the date, so the history is clear if you look back later.

Reading the register when money is tight

The register is most useful in lean weeks. Before a large purchase, look at the current balance and subtract any payments you know are coming before the next deposit, such as rent or a loan repayment. What remains is the amount you can realistically spend. Writing down planned payments a few days before they leave makes that check quicker, and helps you avoid fees for a declined or overdrawn payment.

Joint account holders can each keep a pocket list of spending during the week and transfer it to the shared register at an agreed time, such as every Sunday evening, so the balance stays accurate for both people.

Frequently Asked Questions

What should I write when a cheque bounces after I deposited it?

Record a new line on the date the bank reversed it, showing the amount as a deduction, plus any returned item fee as a separate line. Note the original cheque number in the description so the two entries are linked.

How do I record a debit card refund?

Enter it as a deposit on the date it appears, with a description naming the merchant and noting it is a refund. Do not delete the original purchase line, since both entries are part of the account history.

Is a register useful for a business account as well as a personal one?

Yes, small businesses often keep a register for their operating account to monitor cash day to day. It does not replace bookkeeping or accounting records, but it can be a useful check alongside them.