Free Check Register Template

A free printable checkbook register template to keep track of your bank balance at any given time. It records all payments and withdrawals during a specific period. It can also be used to record all outgoing and incoming checks issued or deposited.

The free printable check register template includes the following fields: the check number, the date it was issued, the payer or payee, transaction type, category, and status (reconciled, cleared, or not cleared). It also checks whether the transaction is tax-deductible or not. The free checkbook register is also editable so you can remove any of the fields if you don’t want to include them. If you use the check register template Excel version then it is better to hide a column than to delete it. The Excel spreadsheet has many formulas that you might delete if you delete a column. To hide a column, click on the top of the column (where the letters are) and right-click your mouse. Select hide. That way the column will be hidden but the formulas will not be affected.

You can filter all transactions to include only those that are tax-deductible to ensure that you have included all those transactions when submitting your tax return.

This free check register template gives you the one thing a paper checkbook register never could: a running balance that works itself out, on every single line, every time you change something. You type the date, who the payment went to and the amount, and the balance column takes care of itself.

I built it because I kept hearing the same story. Someone keeps a paper check register, makes one small subtraction error in March, and every balance from March to December is quietly wrong. The register is a good habit. The arithmetic is the part that breaks. So I removed the arithmetic and left everything else exactly as it has always looked.

Nothing you type leaves your browser. There is no sign up, no account, and no bank connection to set up.

What is a check register?

A check register is a running record of every transaction in a checking account, with a balance recalculated after each one. It is also called a checkbook register, a check ledger, a checking register, a transaction register or, outside the United States, a cheque register. They all mean the same thing.

Your bank keeps its own record, so people reasonably ask what the point is. The point is timing. The balance your bank shows is only the transactions it has finished processing. A check you wrote three weeks ago that nobody has cashed yet is not in that number, and neither is the automatic payment leaving on Friday. Your check register knows about both, because you wrote them down the moment they happened.

That gap is where overdrafts come from. Someone checks their banking app, sees enough money, spends it, and then the forgotten check finally clears. A check register is the tool that prevents exactly that.

What is the purpose of a check register?

It does four jobs at once, and they are worth separating because most people only think of the first.

• It tells you what you actually have, including money that is already committed but has not left the account yet.
• It catches bank errors and unauthorized charges, because you are comparing two independent records instead of trusting one.
• It gives you a written history you can search later, when you need to prove you paid something or find out where a month went.
• It makes your bank statement reconcile, which is the monthly ritual most people abandoned and then quietly regretted.

What the check register template records

The layout follows the register that came free with your checkbook, because that layout is genuinely good and there is no reason to reinvent it. Each row has the same columns a bank register has always had.

• Date. When the transaction happened, not when you got around to writing it down.
• Number or code. The check number if you wrote a check, or a short code for anything else. DC for debit card, DEP for a deposit, ATM for a cash withdrawal, TFR for a transfer, AP for an automatic payment, FEE for a bank charge.
• Description. Who the money went to, or where it came from.
• Category. Optional, and off by default. Turn it on if you want to see where your money is going by type, the way an expense tracker does.
• Payment. Money leaving the account.
• Deposit. Money arriving in the account.
• Cleared. Tick this once the transaction shows up on your bank statement.
• Balance. This one fills itself in. You never type in it.

Above the register you enter your starting balance, which is simply what is in the account before the first transaction on the list. Copy it from your bank, or from the last balance in the paper checkbook register you are replacing.

How to fill out a check register

If you have never used a checking register before, this takes about two minutes to learn and then you have it for life.

1. Type your current account balance into the starting balance box.
2. Enter the date of your first transaction.
3. Enter the check number, or one of the short codes, in the number column. If you tap the Check button above the register, the next check number is filled in for you automatically, counting up from the last one you used.
4. Type who the payment was to, or who the deposit was from. After a few entries the description box starts suggesting things you have typed before, so recurring bills take one keystroke.
5. Put the amount in the payment column if money is leaving, or the deposit column if money is arriving.
6. Look at the balance column. It has already updated, along with every row underneath it.

A new blank row appears at the bottom as soon as you start using the last one, so you can keep going without stopping to add rows. Press Enter to drop down to the next line.

One habit is worth building from day one: record bank fees. Monthly service charges, overdraft fees and ATM fees are the single most common reason a checkbook refuses to balance, because they are the transactions nobody remembers making.

Printable check register

Some people want the software. Some people want the paper. This page gives you both, and the printable check register is not an afterthought.

There are four printable versions, all free and all without a sign up.

A filled printable check register

This is the version I have not seen anywhere else. Enter your transactions in the tool, then print, and you get a designed register with your own transactions and your own running balance already worked out and printed on the page, plus blank ruled rows underneath so you can carry on by hand. If you came here for a printable and stayed for the calculator, you leave with a printable that is already filled in.

A blank check register printable

A clean, ruled, free printable check register with a space for your starting balance and nothing filled in. It prints two pages at a time on standard letter paper. This is the one to use if you genuinely just want the paper version and were never going to type anything.

A wallet size check register

Two narrow registers printed side by side on one page, with a cut line down the middle, so you can fold one into your checkbook cover and keep the other as a spare. This is the format the check register booklets from the bank use, and it is the one that actually gets carried around.

Large print check register

A large print check register with bigger type and taller rows, so the numbers are easy to read and there is genuinely enough room to write in the boxes. Standard bank registers are printed at a size that assumes perfect eyesight and a very fine pen, and for a lot of people that simply does not work.

There is also a large print setting for the tool itself, which enlarges the on-screen register, the balances and the buttons. Tick the large print box under the register and everything scales up together.

The full check register spreadsheet with categories and budget alerts

Alongside the tool there is a ready-made check register spreadsheet that I built years ago and still keep updated. It does several things the register above deliberately does not, because it is designed to be lived in for a year rather than balanced this month.

Download the check register spreadsheet and save it to your computer. It opens in Excel or in Google Sheets.

What it adds:

• A tax deductible column. Flag a transaction as deductible, then filter the register to show only those rows when you are pulling your tax return together. This alone saves an evening every April.
• Category budgets with alerts. Set a monthly limit for each category and the spreadsheet turns the figure red the moment you go over it, so overspending announces itself instead of being discovered later.
• A low balance alert. Choose the balance you never want to drop below and the cell colors itself when you cross the line.
• A monthly summary by category, so you can see at a glance where the money actually went.
• Dropdown lists for transaction type, category and status, so most of the register is filled in by selecting rather than typing.
• A three way status column, which distinguishes not cleared from cleared from fully reconciled. Useful if you like a stricter reconciliation than a single tick.

To set it up, open the Dropdown Lists tab first. It comes with categories for income, savings, food, housing, utilities, education, children, transportation, charity, health, clothing, entertainment and miscellaneous, and you should change these to match your own life rather than working around mine. Do the same for the transaction types and the status labels. Whatever you put on that tab is what appears in the dropdowns on the register.

One warning. If there is a column you do not want, hide it rather than deleting it. Click the column letter at the top, right click, and choose Hide. The spreadsheet is full of formulas that reference those columns, and deleting one breaks the balance calculation in a way that is annoying to repair.

The simplest way to think about the two is this: use the register at the top of this page for the daily running balance and the monthly reconciliation, and use the spreadsheet if you want categories, budget limits and a tax trail across the whole year. Plenty of people use both.

Check register template for Excel and Google Sheets

If you would rather keep your register in a spreadsheet, you can take everything with you.

Check register template for Excel

The Excel download is a real check register template, not a picture of one. The balance column contains a live formula in every cell, so if you add a transaction, change an amount or insert a row, the balances recalculate the way they should. It arrives with your existing transactions already in place and roughly sixty blank rows underneath, plus a second tab with a list of suggested categories you can edit.

Save it, keep adding to it, and you have an Excel checkbook register that behaves properly for as long as you want to use it.

Checkbook register template for Google Sheets

Download the spreadsheet version and, in Google Sheets, choose File, then Import, then Upload. The balance formulas come across intact, so your Google Sheets check register calculates on its own from the first row.

The advantage of the Google Sheets route is that it syncs across your phone and your computer. The disadvantage is that your transaction history now lives on a server. Which trade you prefer is genuinely personal, and both options are here.

If you already keep your budget in the same place, the Google Sheets monthly budget template sits alongside this nicely. The budget plans the month, the register records it.

How to balance a checkbook

Balancing a checkbook, or reconciling it, means proving that your register and your bank agree. It sounds like accounting. In practice it is five minutes once a month, and this template does the subtraction.

1. Open your most recent bank statement. Use the statement, not the balance showing in your banking app today, because the app includes things the statement period does not.
2. Work down the statement line by line. For every transaction that appears on it, tick the cleared box next to that row in your register.
3. Add anything the statement shows that is missing from your register. This is almost always a bank fee, interest, or a debit card purchase nobody wrote down.
4. Type the ending balance from the statement into the balance your checkbook box.
5. Read the verdict. If your cleared balance matches, you are reconciled and you are finished.

If you are off, the size of the difference is usually the clue, and two patterns cover most cases.

• If the difference divides evenly by nine, you almost certainly transposed two digits somewhere. A payment of 54 dollars typed as 45 leaves you off by 9. A payment of 271 typed as 217 leaves you off by 54.
• If the difference is exactly twice the value of one of your transactions, that transaction is in the wrong column. A deposit entered as a payment moves your balance by double the amount.

Beyond that, look for a missing bank fee, a check you wrote and never recorded, or an automatic payment you forgot renews annually.

Register balance and cleared balance

The register keeps two numbers side by side and the difference between them is the whole point of the exercise.

The register balance counts everything you have written down. The cleared balance counts only the ticked rows, so it should match what your bank thinks. The gap between the two is the money that is spent but has not left yet, and this template shows it separately as outstanding.

Spend against the register balance. Reconcile against the cleared balance. People who overdraw are almost always doing the opposite.

A check register example

Here is a small sample check register so you can see the shape of it. Press the button to load a filled example in the tool above if you would rather see it live and change the numbers yourself.

Starting balance: 1,482.60

Read it the way the person who wrote it would. The register balance is 1,408.27, so that is what is really available. The cleared balance is 1,762.02, so that is what the bank statement will say. The difference of 353.75 is the dentist, the gas station and the piano lessons, all recorded and none of them processed yet. Anyone spending against 1,762.02 is about to have a bad week.

Business check register

A business check register works the same way, with two changes worth making.

Turn on the category column and use it consistently, because at tax time the categories are the whole reason you kept the register. Then keep the business account and the personal account in separate registers rather than one shared list, which is the mistake that makes bookkeeping painful later. If you need the planning side as well, the budget sheet template has a business version.

For a small business, the cleared balance matters even more than it does personally. Checks written to suppliers can sit uncashed for weeks, and a business account that looks healthy on the bank website while three large checks are still outstanding is the classic way to bounce payroll.

Teaching someone to use a checkbook register

A checkbook register is one of the few personal finance lessons that still works exactly as well as it did forty years ago, and it is a good one for students and teenagers with a first checking account.

Print the blank register, give them a starting balance and a list of made up transactions, and have them work the balance column by hand. Then load the same transactions into the tool on this page and compare. The comparison is the lesson. They learn the mechanics by doing it manually, and they see immediately why one arithmetic slip on line four poisons every number below it.

Why keep a check register when you have online banking?

This is the fair question, and the honest answer is that online banking solves a different problem.

Your banking app is a rear view mirror. It reports what has already been processed, and it is excellent at that. A check register is forward looking. It knows about the check you wrote this morning, the automatic payment due Friday and the deposit that has not landed yet, because you wrote them down when they happened rather than waiting for a bank to catch up.

It only knows about them if you write them down, though, which is the one weakness. A bill tracker covers the gap by holding the due dates, and a budget calendar lays your bills and paydays out across the month so you can see a low balance coming before it arrives.

There is a second reason, and for a lot of people it is the bigger one. Budgeting apps want your bank login. A check register does not. This one runs entirely inside your own browser, with no account and no connection to any financial institution. If that matters to you, it is not a small thing.

The third reason is simply attention. Writing a transaction down is a moment of noticing. Plenty of people find that the act of recording their spending changes their spending, and no app that silently categorizes things in the background can reproduce that.

Common check register mistakes

• Forgetting bank fees. Service charges, ATM fees and overdraft charges are small, easy to miss, and the number one reason a checkbook will not balance.
• Recording the debit card and forgetting the tip. The restaurant charge that clears your account is often larger than the one you wrote down.
• Treating the bank balance as the truth. It is not. It is the bank’s version, which lags behind yours.
• Only writing down checks. Debit card purchases, transfers and automatic payments all belong in the register too.
• Letting it lapse for a month and then trying to catch up from memory. Work from your bank statement instead of your memory, and tick as you go.
• Never reconciling. A register you never check against a statement will drift, and by the time you notice you will not be able to find where.

Where can you buy check registers?

You can, and most banks will send you replacement check register booklets for free if you ask, which is worth knowing before you pay for them. Office supply stores and online retailers sell packs of them, and if you like the physical booklet there is nothing wrong with that.

The wallet size printable on this page is the same format, in whatever quantity you want, at no cost. Print two, print twenty.

Is the check register template really free?

Yes. Every version on this page is free, with no email address required and no sign up. Fill it in online, print any of the four printable layouts, or download the spreadsheet, in whatever combination suits you.

If you want your register waiting for you when you come back, leave the save box ticked and it is stored in this browser on this device only. Nothing is uploaded anywhere. Untick it and everything disappears when you close the page.

Once your register is running, the natural next step is planning rather than recording. A monthly budget spreadsheet decides where the money is supposed to go, and the check register tells you where it actually went. Read together they are the only two documents most people need. The rest of the free budget templates fill in the pieces around them.

Frequently asked questions

What is a check register?

A check register is a running list of every transaction in a checking account, with the balance recalculated after each one. It records checks, debit card purchases, deposits, transfers, automatic payments and bank fees, so you always know what is actually in the account rather than what the bank has finished processing.

What is a checkbook register?

The same thing. Checkbook register, check register, check ledger, checking register, transaction register and cheque register are all names for the same document. Cheque register is simply the spelling used outside the United States.

How do you balance a checkbook?

Tick every transaction in your register that appears on your bank statement, add anything the statement shows that you had not recorded, then compare your cleared balance to the statement’s ending balance. If they match, you are balanced. The template on this page does that comparison for you and tells you the size of any difference.

How do I fill out a check register?

Enter your starting balance, then add one row per transaction with the date, the check number or a code, who it was to or from, and the amount in either the payment or the deposit column. The balance column calculates itself. Tick the cleared box once a transaction shows up on your bank statement.

What is the purpose of a check register?

To know your true available balance at any moment, including transactions the bank has not processed yet, and to give you an independent record to check your bank statement against. It is how you avoid overdrafts and how you catch errors and unauthorized charges.

Is there a free printable check register?

Yes. This page has four free printable check register layouts: a blank ruled register, a filled register with your own transactions and balances already printed on it, a wallet size version that folds into a checkbook cover, and a large print version. None of them require an email address or a sign up.

Is there a large print check register?

Yes. The large print check register uses bigger type and taller rows so the figures are easy to read and there is room to write comfortably. There is also a large print setting for the on-screen register, which enlarges the whole tool.

Can I use this check register template in Excel?

Yes. Download the spreadsheet version and it opens in Excel as a working check register template, with a live balance formula in every cell and blank rows ready for new transactions. Adding, editing or inserting rows recalculates the balances automatically.

Can I use a checkbook register template in Google Sheets?

Yes. Download the spreadsheet file, then in Google Sheets choose File, then Import, then Upload. The balance formulas transfer across, so your Google Sheets check register calculates on its own.

What is the difference between my register balance and my bank balance?

Your register balance includes everything you have written down. Your bank balance includes only what the bank has processed. The difference is outstanding transactions, usually a check nobody has cashed yet. Spend against your register balance, not your bank balance.

Do I need a check register if I never write checks?

Many people use one purely for debit card purchases and automatic payments, which are exactly the transactions that clear at unpredictable times. Leave the number column blank or use the short codes, and the register works the same way. If you want spending broken down by category rather than a running balance, an expense tracker is the better fit.

Is there a check register app that does not need my bank login?

This one. It runs entirely in your browser, with no account, no sign up and no bank connection. Nothing you type is sent anywhere, and if you leave the save option on, your register is stored on this device only.

Where can I buy check registers?

Most banks will send you replacement register booklets free if you ask, and office supply stores sell packs of them. The wallet size printable on this page is the same format and you can print as many as you like.

A check register tells you what your balance is; it does not tell you where the money went or what is due next. Pair it with the bill tracker printable so nothing slips past its due date, the expense tracker printable to group your spending into categories, and the monthly budget spreadsheet to plan the month before it starts.