Finance trackers

Free Printable Check Register (Checkbook Register PDF, Excel)

A check register is the running record of your checking account: every check you write, every debit card swipe, every automatic payment and deposit, with the balance after each line. Banks show you what has cleared, but only your own register knows about the check you mailed yesterday. Print a full page for the desk, cut checkbook-size strips for the checkbook cover, and use the bank reconciliation sheet once a month to match your register to the statement.

Formats
PDF, Word, Excel, ODT, ODS
Paper
US Letter and A4
Calculates
Running balance in Excel

Updated November 17, 2026

Filled-in example: Full-page check register with running balance.
Save to Pinterest

Choose a design

Pick the design that fits

Save to Pinterest

Full-page check register with running balance

Check number or code, date, description, payment, cleared box, fee, deposit and balance on one Letter page, with totals at the bottom. The Excel check register carries the balance down line by line from your balance forward.

OpenDocument: ODT · ODS

Save to Pinterest

Checkbook register that fits a checkbook cover

Three strips per page, each 6 x 3 inches on the Letter PDF, the size of the register booklet that comes with personal checks. Cut them out, staple a few along the top and slide them into the register pocket of your checkbook cover.

OpenDocument: ODT · ODS

Save to Pinterest

Monthly bank reconciliation sheet

List outstanding checks, deposits in transit and the fees or interest that are on the statement but not yet in your register. The sheet works out the adjusted bank balance and the adjusted register balance; the difference should be zero.

OpenDocument: ODT · ODS

What is on the page

Check number or code
The check number for paper checks. For everything else use a short code: DC for a debit card purchase, ATM for cash, AP for an automatic payment, DEP for a deposit, TR for a transfer between your own accounts.
Date
The day you wrote the check or made the payment, not the day it clears. That gap is exactly what the register is for.
Description
Who you paid or where the money came from, plus a few words of memo. "Duke Energy, October bill" is easier to match to a statement than "electric".
Payment, fee, deposit
Money out goes in Payment, money in goes in Deposit. Bank fees, such as the charge for using another bank's ATM, get their own column so they are easy to total at the end of the month.
Clr (cleared)
Tick it when the item shows up on your bank statement or in online banking. Anything left unticked at reconciliation time is still outstanding.
Balance
Your balance after each line: the previous balance plus deposits, minus payments and fees. The Excel check register does this for you; on paper, write it every time.
Balance forward
The balance you carry from the bottom of one page or strip to the top of the next.

How to use a check register

  1. Start with today's balance. Look up the current balance in online banking, subtract any checks you know have not cleared yet, and write the result as your balance forward.
  2. Write every transaction the day it happens. Checks, debit card purchases, ATM cash, automatic payments, transfers, deposits. Keep receipts in your wallet till they are written down.
  3. Work out the new balance on the same line. Add deposits, subtract payments and fees. If you use the Excel file, just type the amounts and the balance column follows.
  4. Add the automatic stuff up front. Rent, insurance, phone and streaming plans that come out on fixed dates are easy to forget. Some people write them in at the start of the month so the balance shows what is truly free to spend.
  5. Tick the Clr box as items clear. Check online banking every week or two and tick what has gone through.
  6. Reconcile once a month when the statement arrives, using the bank reconciliation sheet below.

A checkbook register that fits your checkbook cover

The register booklets that check printers supply with personal checks are about 6 inches wide and 3 inches tall. Retail packs are sold as "personal size" 6 x 3 inch registers that fit a standard checkbook cover. The checkbook-size design here is built to that size: on the Letter PDF each strip prints at 6 x 3 inches. Print at 100% or "actual size" (fit to page shrinks it a little), cut along the outer border, stack a few strips and staple them along the top edge so they flip up like the original booklet.

The A4 PDF keeps the same height but is a touch narrower, because A4 paper is narrower than Letter. If you print on A4 and need the full 6 inch width, use the Word file and set the page to Letter, or simply trim a little less.

Bank reconciliation, step by step

Bank reconciliation means proving that your register and the bank statement describe the same money. They almost never show the same number on the statement date, and that's normal. Checks you wrote may not have been cashed yet, a deposit may have been made after the statement closed, and the bank may have charged a fee or paid interest that you haven't written down. The reconciliation sheet lines all of that up.

  1. Tick every register item that appears on the statement. Tick the statement line too.
  2. List the unticked payments from your register as outstanding checks and withdrawals.
  3. List unticked deposits as deposits in transit.
  4. List anything on the statement that isn't in your register: monthly service fees, overdraft or ATM fees, interest, an automatic payment you forgot. Fees are negative, interest is positive.
  5. Bank side: statement ending balance, plus deposits in transit, minus outstanding items. That's your adjusted bank balance.
  6. Register side: your register balance as of the statement date, plus or minus the statement-only items. That's your adjusted register balance.
  7. The two should match to the cent. Then write the fees and interest into your register so it is current.

In the sample the statement ends at $2,359.94. Add the $1,872.15 paycheck that had not posted, subtract the two checks still out ($145.00), and the adjusted bank balance is $4,087.09. The register said $4,091.67; take off the $5.00 service fee and add $0.42 of interest, and you get the same $4,087.09.

When the numbers do not match

  • The difference is a round number. Often a single item was missed or entered twice. Look for a payment or deposit of exactly that amount.
  • The difference divides evenly by 9. That's the classic sign of two digits swapped, such as $56.20 written as $65.20.
  • The difference is twice an amount. A payment was probably added instead of subtracted.
  • Math errors. Re-add the balance column on paper from the last point where it agreed. The Excel version removes this one.
  • Something you do not recognize. Call your bank. Under federal rules for debit cards and other electronic transfers, how quickly you report an unauthorized charge affects how much you can lose, so don't leave it for next month.

Check register, expense tracker or budget?

They do different jobs and work well together. The check register follows one bank account and answers one question: how much money is really in there? An expense tracker groups spending by category so you can see where it goes, and the monthly budget planner sets limits before the month starts. For due dates and autopay, keep a monthly bill tracker next to the register. Business owners who pay from a cash box need a petty cash log instead, and the business expense tracker totals deductible costs by category for tax time.

Using the Excel check register

Type your balance forward in the box at the top of the full-page register. Each line's balance is a formula: the balance above, plus the deposit, minus the payment and the fee. Blank lines stay blank, and the totals at the bottom show payments, fees, deposits and the ending balance. When a page fills up, copy the ending balance into the balance forward box on a fresh copy of the sheet. On the bank reconciliation sheet the outstanding, in-transit and statement-only items are totaled for you, and the difference cell tells you whether you balanced.

The checkbook-size strips are meant for printing, so their balance column is left for you to write in. The fillable PDF files let you type before printing but don't calculate. The ODT and ODS files open in LibreOffice and Google Docs or Sheets.

Questions

Do I still need a check register with online banking?

Online banking shows what has cleared. It does not know about the check you mailed on Friday or the automatic payment due next week. A register shows the money you can actually spend, which is why people who have overdrafted once tend to keep one.

What does the Clr column mean?

Clr stands for cleared. Tick it when the transaction appears on your statement or in online banking. At reconciliation time, every unticked line is either outstanding or a mistake.

How often should I reconcile my checking account?

Once a month, when the statement arrives, is the usual habit. A quick weekly look at online banking catches fraud and errors sooner.

How long is a check good for?

Under the Uniform Commercial Code rule that states follow, a bank does not have to pay a personal check presented more than six months after its date, though it may choose to. If a check stays outstanding for months, contact the payee before you assume the money is yours again.

How fast do I need to report a charge I did not make?

For debit card and other electronic transactions, the CFPB says you aren't liable for an unauthorized charge if you report it within 60 days after the statement is sent, as long as the card or PIN wasn't lost or stolen. A lost or stolen card has shorter deadlines. Rules can differ by account type, so check with your bank.

Can I print the checkbook register on card stock?

Plain paper is easier to staple and fits the register pocket better. If you like a stiffer back, print one strip on card stock and put it at the bottom of the stack.

How useful was this template?

Tap a star to rate it. Your rating helps other people pick a template.

Comments and questions

Have a question about this template, or an idea to make it better? Leave a comment.

Leave a comment

Comments are checked before they appear, usually within a day or two. Please keep personal details out of your comment.