Thanks to the overwhelming success of my free debt snowball spreadsheet, and my free excel checkbook spreadsheet, I’ve been inspired to “publish” the Excel spreadsheet I use to keep track of all my personal finances.
There are a lot of personal finance programs on the market today, but in my opinion they are difficult to use and have way too many features that end up overwhelming the average user.
If you’re looking for a simple Excel based spreadsheet that tracks your checking accounts, monthly bill due-dates, and your net worth, my super simple (AND FREE) personal finance Excel spreadsheet may be exactly what you are looking for!
What My Free Personal Finance Excel Spreadsheet Program Does:
As promised, my free Excel spreadsheet is programed to manage up to three separate checking/savings accounts (you can easily add more accounts if you need too).
As you update each account balance, your “net worth” is automatically updated on the “Overview” sheet.
Finally, there is a very handy monthly bill tracker you can use to keep track of what bills you’ve paid this month, and what bills still need to be paid.
Instructions for My Personal Finance Excel Spreadsheet:
I’ve designed my Excel spreadsheet to be as user friendly as possible cutting out all of the crap you often find built into other personal finance programs.
Once you download the Excel file and save it locally to your computer, simply open up the file and it will load on the “Overview Tab” (tabs are labeled at the bottom of each sheet).
In the “Overview” tab, you can fill in any liabilities you may have in the red liabilities section (outstanding balances on any loans, credit cards, etc.). You can skip this step if you want to.
While you’re in the “Overview” tab, you can also fill in any financial assets you wish under the green assets section (home value, car value, IRA, 401k, brokerage accounts, etc.). Warning, DO NOT type in how much money you have in your checking or savings accounts, these will fill in automatically as you update each checking/savings account registry (each has its own tab).
How to Use the Checking/Savings Account Registries:
1) Enter your “Beginning Balance” in the Dark Green Box, this will be your starting point.
2) From here it’s simply just a matter of updating your registry with every transaction you make.
ID/Check#: 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!
That’s it! It is super easy to use (did I say it was EASY).
How to Keep Track of Your Monthly Bill’s Due Dates:
Here’s another easy feature of my program. To track monthly bills, simply fill-in your monthly bills in the left hand column of the “Monthly Bill Tracker” tab.
Once all your bills are filled in, put an “X” in the corresponding monthly box when you make a payment.
Keeping up with this tracker after you make each monthly payment will help you keep track of which bills have been paid and which bills have not.
That’s all there is to it folks! I told you this was super easy! This Excel workbook is all my family and I have needed over the last few years to manage the majority of our daily personal finance transactions. I hope you enjoy it and please post any questions, comments, or suggestions in the comment section below!
Oh, and share it with your friends if you want to!