I am pleased to introduce my user friendly, simple, free home budget spreadsheet. I took the home budget spreadsheet that I have been using for the last few years, and modified it so that it is dirt simple to use, and helps you to predict your future savings! Just a few instructions to follow, to make sure there is absolutely no confusion:
- Line 5 of the spreadsheet is where you enter your after tax or net income. It is entered by month, so that if you have a job that is not salary and your earnings vary month to month, this home budget spreadsheet will still work for you.
- Column B of the spreadsheet is where you enter all the line item expenses that you are budgeting for. Try to come up with an average for the year, as you don’t want to change these items as the year progresses, if possible. All the automatic calculations assume that the budget items will not change.
- Cell B22 of the spreadsheet is where you enter your bank account’s balance at the beginning of the year.
- Columns C through Y are where you will be entering your actual monthly expenses, as they happen.
- Check the automatic calculations for your predictions!
With regard to the automatic calculation area, here are the definitions of what is being calculated:
- The Total Budgeted Expenses is simply a sum of all the budget line items you inputted above.
- The Sum of Unpaid Line Items is a little tricky to understand – basically, if you enter an actual expense for a line item, regarless of whether it equals the budgeted number, this calculation will assume that the line item for which the actual expense is entered has been paid for. For example, if your electricity budget is $100, and you end up entering a payment of $150, it simply assumes that the electricity has been paid for. Thus, if you enter a zero, or leave an actual expense blank, it will assume that expense has not yet been paid for. Finally, the Sum of Unpaid Line Items will find all expenses that you left blank or entered a zero for, and add up the corresponding budget numbers. In looking at my example, you will see that I entered a zero for Car Insurance for the month of January. The Sum of Unpaid Line Items assumes that I have not yet paid for this item, so it shows a total of $50 left to be paid for the month of January.
- Over/Under Budget – If you have a green/positive number here, then you have beaten your budget for the month! Congratulations. If it is red/negative, then you have overspent somewhere.
- Predicted Cash at Month’s End – this is the good one. This number tells you based on everything entered into the home budget spreadsheet, how much cash you should expect to have left over. If it is red/negative, ouch! you are living in debt!
In closing, I hope the free home budget spreadsheet becomes a necessity for you. Make sure to kill all the test data and enjoy; you may download it here: