My Simple Excel Based Check Book Registry Spreadsheet

If you’ve got plenty of time, and need sophisticated tools to run advanced calculations of your finances, you can’t beat Microsoft Money or Quicken.

On the other hand, if you just want a basic spreadsheet to keep track of your checking, savings, and credit card accounts (like I did), you might be interested in the simple checking account registry spreadsheet I created with Mircosoft Excel. It’s easy to use, it’s quick, it can be used on virtually any computer, and best of all it’s FREE! You may also be interested in my article How to Pay Off Your Debt (The Debt Snowball), and How To Get Your REAL Free Credit Report.

 excel-checkbook-registry

Click HERE to download Excel Template

To use, simply follow the directions below: 

1) Click the “download” button above. A new window will open, you will see a file called “Checkbook Registry”. Click “download” and save the file to your computer.

2) Once the file has downloaded, double click on the icon and it will open.

3) The program will automatically open to the “Checking Account” page you see in the picture above.

4) Enter your “Beginning Balance” in the Yellow Box, this will be your starting point.

5) From here it’s simply just a matter of updating your registry with every transaction you make.

ID: This is where I enter the transaction type or check #. For example, if I made a purchase with my atm/debit card I would enter “atm” here. If I wrote a check I would write the check # here, if I made a deposit I would write “deposit”, if I transferred funds to my savings account, I would write “transfer”, you can use your own codes to suit your needs.

X: I write an “X” in this column when I see that the transaction has cleared at my bank either online or in the statements that are mailed to me. This is my form of reconciling.

Date: Enter the date of your transaction.

Description of Transaction: Write a quick blurb that best describes the transaction (Example: Ford Car Payment, Exxon Gas Station, Dinner @ Olive Garden, etc.)

: If the transaction involves money coming out of your account enter the amount in the – column.

+: If the transaction involves money going into your account enter the amount in the + column.

Balance: Your new balance will be calculated automatically!

This simple spreadsheet has been extremely valuable to me over the years. I no longer have to worry about making mistakes when adding up long columns of numbers, the program saves me time, and it is extremely portable. You can even email a copy to yourself so you can always have access to it no matter where you are. If you do try it out, I hope you find it as helpful as I have. There are more sophisticated programs on the Internet, but this is all I ever needed a money management program to do.

Advanced Tips: If you look at the tabs in the lower lefthand corner of the screen you will see that I have included a page for you checking account, savings account, and credit card so that you can keep track of multiple accounts with this one program. If you want to add an additional account, right click on the tab you want to copy and select “move copy”, then check the box that says “create a copy” and press “OK”. To change the title of each page (example “Jane’s Checking Account) simply click the title where it says “checking account” and type what you want the new title to be.

Have you read my Guide to Protecting Your Credit and Identity?

Related Articles:
How to Clean Up Your Credit Reports
Dave Ramsey’s 7 Financial Baby Steps
How to Use a Goodwill Letter to Remove Late Payments From Your Credit Report
Free Excel Checkbook Registry Spreadsheet
Identity Theft Prevention Guide

Too Much Debt?  Download our free Trees Full of Money Debt Snowball Calculator and see how quickly you can pay off your debt.

19 Responses

  1. Robbia 9 years ago
  2. johnneTEE 9 years ago
  3. admin 9 years ago
  4. James Hastings 8 years ago
  5. JW 8 years ago
  6. MRG 8 years ago
  7. Liz 7 years ago
  8. Ben 7 years ago
  9. Kelly 7 years ago
  10. Steph 7 years ago
  11. Patty 7 years ago
  12. BitsyBet 6 years ago
  13. BitsyBet 6 years ago
  14. Wendy Robes 5 years ago
  15. Ben 5 years ago
  16. Jan Gregory 5 years ago
  17. Angel 3 years ago
  18. Ben 3 years ago
  19. termites in house 1 year ago

Add Comment

sign up today for our
free personal finance newsletter

Subscribe to our mailing list and receive FREE daily updates from Trees Full of Money, the best personal finance blog nobody has heard of.