Free Home Budget Spreadsheet
Budgeting 2 Comments »I am proud 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:
Internal Tags: