Save Money this Year: FREE Budget Spreadsheet by!

Courtesy of CartoonStock

Budgeting is always something that is intimidating to people. Writing down their expenses versus how much they are bringing in is a scary thought, but in reality it helps you know where your money is going and how you can reach a savings goal. Whether you are saving for a rainy day, a vacation, a house, a car, etc. you won’t get there unless you have a budget plan.

Of course it’s not that scary when Eastern Shore Mom is here to help! I have made a FREE downloadable version of the budget spreadsheet I use for our family’s finances! This has saved us lots of money just by me sitting down and typing out where our money is going and when.

Here is how this works:

Start by downloading the FREE Budget (download for Excel 1997-2003 Budget)

Step One: Fill in the month and dates of each weeks. You will see that I break down our budget weekly. This helps us plan on how much we are spending on what each week. So start with this month (I have already written “January” in) then go down the calendar and write the starting day of each week and the ending date of each week where is says “Dates of the Week”

Step Two: Fill in your weekly expenses. I have already made a category for Child Care, Gas, Groceries, Misc. & Bills. Note that the category of “BILLS” needs to be filled out below the highlighted lines where is says “List your bills here”. This form is made to calculate everything for you. So when you plug in your bills below, it is going to total them and bring them up to the top under “GAS” and the total will be next to “BILLS”.

Be sure to fill in each week’s expenses, so if your mortgage is due the first of the month, put it under the first week. If the cell bill is due at the end of the month, put it under the last week’s bills.

Step Three: Fill in your income. Underneath your TOTAL from your expenses is a place for you to fill in how much your bring in each week. Once you fill in the amount you bring in each week, the sheet will automatically calculate how much SAVINGS there is by subtracting the TOTAL amount from your expenses by your INCOME field. This is all done for you automatically inside the sheet, so don’t try to fill in the SAVINGS field yourself!

Step Four: Track your budget. If you need to stick the allotted money in envelopes each week to make sure what you have budgeted is what you are spending, do so. Be sure at the end of the week to check off what you have paid that week and make sure you didn’t go over budget. If so, be sure to change that category so your SAVINGS line updates with the new amount.

Final Step: DEPOSIT! At the end of the week, take the total amount under SAVINGS and make your deposit! If your budgeting went according to plan, that amount should be waiting to move over to the Savings Account and a new week begins!


Tips for the spreadsheet:

Save a BLANK one- Be sure to go ahead and save one that is blank. Open it, go to File, Save As, then name it “EasternShoreMom Budget Plan MASTER COPY”. Once you do that, open it again, go to File, Save As, then name it “January 2011″. Do this so you always have one that is not typed in because…

Don’t Delete the Formulas- I have inserted formulas in each HIGHLIGHTED cell (or little box). Be sure NOT TO DELETE (or backspace) inside these highlighted boxes, as it will delete the formulas I have inserted and the sheet won’t calculate correctly. If you do delete a formula, refer to the one you have saved blank (tip above) and select the cell (or little box) that you deleted and copy and paste over the correct formula.

Disclosure: This post may contain affiliate links. When you use them, you help support this site. Thanks so much!

Pin It


11 thoughts on “Save Money this Year: FREE Budget Spreadsheet by!

  1. This is awesome! Thank you so much! I am a recently seperated mother of 3 (2 of which are teenagers) and I have never had to pay the bills myself! I have been couponing for about 8 months and I have wanted to try to figure out how to make a budget for myself but did not know where or how to start! Thank you for your time and effort that you put into this site just so you can help people like me! I am saving for my daughter’s graduation present which is a cruise for the 2 of us in June 2011 and I think this will be a great help for my family!

  2. Thanks so much Wendy for your kind words! I hope you all have a wonderful time on your cruise & I am so glad that this may help you get there!

  3. Did you realize there are 3 sheets in this download and two of them look to be your actual budget? And at the bottom of the first sheet where it says ‘Misc. We Owe’ is all filled in with your bills. Is that just more examples or a mistake?

  4. Hey Michelle,

    Disregard that. You can actually download the sheet again, I have removed all of that. I was going to go into a lot more detail and I ended up changing it :)

    (blushing) you caught my mistake, thanks so much!

  5. A practical guide to Home financial with good examples to do that.
    For people like me there is a problem. How to do it when I don’t have the time and inclination for taking note of daily expenses? Thats why many people fails in keeping track of their expenses.
    However good work for trying to teach us how to do it. Cheers.

  6. its ok… mine is pretty advanced and works on a biweekly budget, which is why i do like that this one breaks the weeks down… Mine has several sheets , one with hours worked which feeds into paycheck which feeds intothe actual budget, which takes from grocery budget to help with couponing… very linked lol ! but for someone who is just starting in excel, it’s a nice place to start, so kudos!

  7. Help….I went to download the budget spreadsheet and I get a blank form. Can u help me.I would love to try this out.

      Thanks, Rebecca

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam Protection by WP-SpamFree