Free Home Budget Spreadsheet

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:

  1. 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.
  2. 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.
  3. Cell B22 of the spreadsheet is where you enter your bank account’s balance at the beginning of the year.
  4. Columns C through Y are where you will be entering your actual monthly expenses, as they happen.
  5. 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:

Free Home Budget Spreadsheet.xls

4 thoughts on “Free Home Budget Spreadsheet

  1. Pingback: Bi Weekly Mortgage Plan: Highway Robbery

  2. Pingback: Spending to Saving: Making the Change

  3. I’m about to embark on one of the biggest financial investments that I’ve ever made and I’ve been scouring the internet for the most useful budget spreadsheet I can get my hands on. It took over a week to find your ‘Free Home Budget Spreadsheet’ but I can see right away that this is what I’ve been looking for.

    While picking away at the spreadsheet to figure out what makes it tick, I’ve come up with a question. My question is this…Should the hidden columns used to hold the TRUE/FALSE values have anything in the Automatic Calculation Area? I can see that the last three rows of this area contain formulas, but I’m thinking that they are redundant and only exist because of the nature of how Excel copies hidden rows/cells when you created the spreadsheet. I’ve deleted the formulas from these rows and everything still seems to work as expected. Am I correct about this? or have I messed something up that will bite me later down the road?

    Thanks for any insight you can provide. If the spreadsheet works for me as I hope it will, I can only say thank you very much for the work you’ve done. I wish I’d have found your spreadsheet long before reviewing so many others that seems to be basically useless.

    Thanks much, Ryan, Canada

  4. Ryan:

    The hidden columns are there for a reason. They figure out if there is anything that hasn’t been paid for the month, and let you know about it.

    As long as you pay everything, the hidden columns aren’t very important, but if you miss a payment, they help to let you know!

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge