≡ Menu

Checkbook Register Template In Excel

Maintaining an excel check register is crucial for every business. By having an accurately maintained register, you can save your time as well as money. It will allow you to recognize how much is available to spend. Hence, you will not exceed your financial limit.

How To Do Check Register In Excel?

(Example of Checkbook Register Template)

Checkbook Register Template

Download Checkbook Register

This type of a register will help you to keep a close watch on every spending and deposit. Thus, you will always know precisely how much money is there in your accounts. You need to enter all the transactions incurred. These will include all the debits, credits, purchases, deposits and everything else that will affect your account balance.

The great thing about an Excel program is that you can easily configure it to act as a check register. This in turn will help you to ensure that you save your money on various other expensive spreadsheet templates. It will only take a few minutes to get established. Also, once you have set up the register, you can easily begin logging in vital information as frequently as you require. You can then even use it as a printable form. You can avoid overspending and refrain from getting charged additional fees.

You can easily cut down on the time you have been spending trying to reconcile your checkbooks by just creating an easy to use checkbook register in MS Excel. It does not take much time to create one as it gets quickly built into the calculations. Although majority of people are now paying their bills online by using their debit cards etc, yet it is a good idea to keep a proper balance for your checking accounts for google docs or in an excel format.

Bored of using the calculator to figure out your checking balance in your account at the end of each week? Well, then it is a good idea to let excel do these calculations for you. All you need to do is to just keep a track of the amount for your purchases in a checkbook register form. Here’s how you can do a check register in Excel.


1. Open MS Excel. Create the column headings in excel and then “Type of Transaction” lists.

2. Format your Deposit, Withdrawal and Balance columns as currency. You can do this by selecting the column and going to the tab Format>Cells>Number and then select Currency.

3. Enter your current balance for your checking account in the cell F2.

4. Next, in the cell F3, just type this following formula; =F2+E3-D3. This will auto fill out the balance column. Your balance column is filled with the latest balance amount.

5. Begin with the cell A3 and highlight these cells within the transaction columns. Next, you will be able to make your drop-down list for each Transaction column.

6. Go to the data menu and click on Validation. Next, click on the Setting tab, in case it isn’t already selected. Choose a list from the Allow drop down option. Just make sure that the “In-cell drop down” and the “Ignore blank” boxes are both checked. Type the following in the Source box; =$H$2:$H$6.

7. Next, click on the ‘Error Alert’ option and make sure that the “Show error’ tab box is unchecked. You will be allowed to put in your own custom description in the Transaction columns as you wish. For instance, you can enter your check number and then click OK.

8. After you have created your drop-down list in the Transaction columns, you can select the ‘Type of Transaction’ from the list. This will also allow you to create a table within the Description field. Next, use the same “drop-down menu” option to allow common data entries.

9. You can now start adding your account information into your check register.

10. You can check a few practice entries by typing in a few numbers within the Deposit and Withdrawal columns in order to check how the check register functions.

What Is The Purpose Of A Checkbook Register?

A check register will act as your personal record for tracking your checking account. It is a good idea to always use a check register as your backup system even if the bank is trustworthy. You will be able to use a paper check register that comes with your checkbook. But an easier alternative is to use an excel system. You can take a look at how the check register system works and how you can get these for free.

Why Use A Check Register?

A check register will help you to stay on top of the transactions in your bank account. Your bank could make mistakes or you may unknowingly make a mistake too. This is exactly why a check register will be of great help to you in doing the following:

1. Identify any errors
2. Catch any type of identity theft
3. Avoid the bouncing of checks and also manage the overdraft fees.

You should use a check register as frequently as possible. You need to enter every transaction in this register. While writing a check or using your debit card, just put the transaction details into your check register instantly. Also, save the debit card and ATM receipts to help you enter those transactions into your check register each week.

You need to also use the check register weekly, monthly or each time you receive your statement. Your statement will show you vital items that may have not been noted in the check register yet. These will include the following:

1. Fees that have been paid by you to the bank
2. Interest payments received from the bank
3. Any automatic transactions such as a direct deposit for your paycheck

You can easily build a basic check register using Microsoft Excel. Paper checkbook registers may have worked for several years, but if you do not want to keep doing entries that way, use an excel register. You can get a paper register when you order your checks and those will work fine. However, you can also look for free printable templates or create one of your own. Just print your very own check register so it can be the size and shape that you want it to be. You can easily create a document by using a pre-built spreadsheet or by downloading Google Docs or Microsoft Excel templates.

{ 0 comments… add one }

Leave a Comment