budget your family's money
Be Savvy

How To Create Your Family’s Budget 101 (+ Free Budgeting Template)

Disclaimer: This post may contain affiliate links. This means that I may receive a small commission if you make a purchase, at no cost to you.

One of the most daunting tasks related to budgeting and understanding your personal finances is actually sitting down and pulling in all of the information into one place. It takes time and effort, I get it. But in order for you to truly understand where your money is going and generalize trends from your spending, you must put all your cards on the table.

You can begin with and without the use of technology (like mobile apps). In this post, I will walk you through how to plan your budget with the use of Microsoft Excel (free template available here).

 

How to Create Your Monthly Budget

Income

The cadence of your paychecks will matter here. You will need to approximate how much you’re earning a month. There will be some variance in your monthly income depending on how often you receive your paychecks (ex: monthly, biweekly, per assignment, etc.). For example, if you’re getting paid bi-weekly, there will be some months that you’ll be earning 3 paychecks, rather than 2. To illustrate this further:

  • Let’s assume that your paycheck days are Fridays, then in January 2019 you must have received only 2 paychecks. In other words, January 2019 has 4 dates that fall on a Friday, so you should be noting 2 paychecks x paycheck amount for that month.
  • March 2019 will have 5 dates that fall on a Friday, so depending on when your paycheck will arrive – you may have 3 paychecks.

Here is a sample calendar with paycheck days (Fridays on a bi-weekly schedule) marked. This calendar is available as part of the Free Template).

 

budgeting money

Begin by creating a list of all of your monthly income sources. This may include:

  • Your salary
  • Your spouse’s salary
  • Your side income
  • Your spouse’s side income
  • Income generated from renting out a property (ex: if you’re renting out an apartment or a beach house)
  • Bonuses
  • Gifts (ex: money that you get for holidays, birthday, or another event)

You want to be thorough and realistic. Do not skip putting something on this list because you think it may not be relevant. If you don’t take this seriously, then you’ll begin to slip and start omitting an item here … an item there … Be thorough and be consistent!

Before you can plan your expenses, you need to know the total income that you’re working with.

 

sources of income for your budget

Expenses

Next, you’ll want to put all of your expenses on the table. I usually break these into fixed and variable expenses. From the perspective of budgeting, I think this is an easier way to organize them.

Fixed expenses are your monthly costs that do not change month to month. These are your long-term obligations, such as mortgage, cell phone payments, car payments, insurance premiums, etc.

Variable expenses are your monthly costs that literally vary depending on what you’re doing that month. These expenses may include your electric bill, food, presents, etc. Depending on the time of year, you may be utilizing more electricity during cold months to keep your home warm. And while you’re at it … maybe snacking a little bit more than you usually do during other times of the year and so your food expenses may go up. 

 

expenses for your budget

 

Once you put your incomes and expenses into the worksheet, this is what it should look like:

 

total budget worksheet

Future Cast Your Budget

Now that you have your budget set up for the current month, you’d want to project (or “predict”) what your future expenses may be. This will help you better understand how much money you will be saving each month, and by the end of the year. If you don’t know how much you’ll be paying into a certain category, for example – your taxes, then use the information from the past as the best estimator of what that expense (or income) could be.

Businesses do this all the time in order to see what their profits are and to be able to plan for the future. Why shouldn’t you? You should be able to be equipped with information about your finances to plan your future.

Maybe you’ve been planning to buy a house but not sure when would be a good time to do this. Use your worksheet to “future-cast” your total annual savings into the coming years. This will help you to figure out how much time you’ll need to achieve your goal. 

See Where You Can Create Extra Room in Your Budget

create extra room in your budget

Ok, the point of going through the budgeting exercise is not to cry over how much money is bypassing your savings. Instead, you should be using this knowledge to your advantage.

  • Is there something that you absolutely do not need? Maybe you can spare the clothing subscription box for a few months in the interest of saving more money.
  • Could you save on groceries? Maybe you could buy most frequently used items in bulk at Costco. Or think about switching to generic brands.
  • Could you save on utilities? You can set your air conditioning to a few degrees lower (during winter) or higher (during summer) while you’re away to make sure you’re not wasting energy. 

Conclusion: Maintain and Learn!

At the end of every month, make a habit to sit down and reconcile all of your expenses. This will take 30 minutes to an hour, but it so worth your time! You’ll need to update your future-cast table with “actual” earnings and expenses. This will help paint a more realistic picture of what your savings will be.

I would highly recommend maintaining your budget each month. You will become more aware of your spending habits and learn the trends. There will be variations month to month, and you may even have some unpredictable events occur that you could not have “forecasted” budget.

We live and we learn. Adjust your budget accordingly. Remember, it is better to have some form of a budget, then no budget at all!

Download the free template: 

    .formkit-form[data-uid="2ad589978e"] *{font-family:"Helvetica Neue",Helvetica,Arial,Verdana,sans-serif;box-sizing:border-box;}.formkit-form[data-uid="2ad589978e"]{-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;}.formkit-form[data-uid="2ad589978e"] legend{border:none;font-size:inherit;margin-bottom:10px;padding:0;position:relative;display:table;}.formkit-form[data-uid="2ad589978e"] fieldset{border:0;padding:0.01em 0 0 0;margin:0;min-width:0;}.formkit-form[data-uid="2ad589978e"] body:not(:-moz-handler-blocked) fieldset{display:table-cell;}.formkit-form[data-uid="2ad589978e"] h1,.formkit-form[data-uid="2ad589978e"] h2,.formkit-form[data-uid="2ad589978e"] h3,.formkit-form[data-uid="2ad589978e"] h4,.formkit-form[data-uid="2ad589978e"] h5,.formkit-form[data-uid="2ad589978e"] h6{color:inherit;font-size:inherit;font-weight:inherit;}.formkit-form[data-uid="2ad589978e"] p{color:inherit;font-size:inherit;font-weight:inherit;}.formkit-form[data-uid="2ad589978e"][data-format="modal"]{display:none;}.formkit-form[data-uid="2ad589978e"][data-format="slide in"]{display:none;}.formkit-form[data-uid="2ad589978e"] .formkit-input,.formkit-form[data-uid="2ad589978e"] .formkit-select,.formkit-form[data-uid="2ad589978e"] .formkit-checkboxes{width:100%;}.formkit-form[data-uid="2ad589978e"] .formkit-button,.formkit-form[data-uid="2ad589978e"] .formkit-submit{border:0;border-radius:5px;color:#ffffff;cursor:pointer;display:inline-block;text-align:center;font-size:15px;font-weight:500;cursor:pointer;margin-bottom:15px;overflow:hidden;padding:0;position:relative;vertical-align:middle;}.formkit-form[data-uid="2ad589978e"] .formkit-button:hover,.formkit-form[data-uid="2ad589978e"] .formkit-submit:hover,.formkit-form[data-uid="2ad589978e"] .formkit-button:focus,.formkit-form[data-uid="2ad589978e"] .formkit-submit:focus{outline:none;}.formkit-form[data-uid="2ad589978e"] .formkit-button:hover > span,.formkit-form[data-uid="2ad589978e"] .formkit-submit:hover > span,.formkit-form[data-uid="2ad589978e"] .formkit-button:focus > span,.formkit-form[data-uid="2ad589978e"] .formkit-submit:focus > span{background-color:rgba(0,0,0,0.1);}.formkit-form[data-uid="2ad589978e"] .formkit-button > span,.formkit-form[data-uid="2ad589978e"] .formkit-submit > span{display:block;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;padding:12px 24px;}.formkit-form[data-uid="2ad589978e"] .formkit-input{background:#ffffff;font-size:15px;padding:12px;border:1px solid #e3e3e3;-webkit-flex:1 0 auto;-ms-flex:1 0 auto;flex:1 0 auto;line-height:1.4;margin:0;-webkit-transition:border-color ease-out 300ms;transition:border-color ease-out 300ms;}.formkit-form[data-uid="2ad589978e"] .formkit-input:focus{outline:none;border-color:#1677be;-webkit-transition:border-color ease 300ms;transition:border-color ease 300ms;}.formkit-form[data-uid="2ad589978e"] .formkit-input::-webkit-input-placeholder{color:inherit;opacity:0.8;}.formkit-form[data-uid="2ad589978e"] .formkit-input::-moz-placeholder{color:inherit;opacity:0.8;}.formkit-form[data-uid="2ad589978e"] .formkit-input:-ms-input-placeholder{color:inherit;opacity:0.8;}.formkit-form[data-uid="2ad589978e"] .formkit-input::placeholder{color:inherit;opacity:0.8;}.formkit-form[data-uid="2ad589978e"] [data-group="dropdown"]{position:relative;display:inline-block;width:100%;}.formkit-form[data-uid="2ad589978e"] [data-group="dropdown"]::before{content:"";top:calc(50% - 2.5px);right:10px;position:absolute;pointer-events:none;border-color:#4f4f4f transparent transparent transparent;border-style:solid;border-width:6px 6px 0 6px;height:0;width:0;z-index:999;}.formkit-form[data-uid="2ad589978e"] [data-group="dropdown"] select{height:auto;width:100%;cursor:pointer;color:#333333;line-height:1.4;margin-bottom:0;padding:0 6px;-webkit-appearance:none;-moz-appearance:none;appearance:none;font-size:15px;padding:12px;padding-right:25px;border:1px solid #e3e3e3;background:#ffffff;}.formkit-form[data-uid="2ad589978e"] [data-group="dropdown"] select:focus{outline:none;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"]{text-align:left;margin:0;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"]{margin-bottom:10px;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] *{cursor:pointer;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"]:last-of-type{margin-bottom:0;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]{display:none;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"] + label::after{content:none;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked + label::after{border-color:#ffffff;content:"";}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked + label::before{background:#10bf7a;border-color:#10bf7a;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] label{position:relative;display:inline-block;padding-left:28px;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] label::before,.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] label::after{position:absolute;content:"";display:inline-block;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] label::before{height:16px;width:16px;border:1px solid #e3e3e3;background:#ffffff;left:0px;top:3px;}.formkit-form[data-uid="2ad589978e"] [data-group="checkboxes"] [data-group="checkbox"] label::after{height:4px;width:8px;border-left:2px solid #4d4d4d;border-bottom:2px solid #4d4d4d;-webkit-transform:rotate(-45deg);-ms-transform:rotate(-45deg);transform:rotate(-45deg);left:4px;top:8px;}.formkit-form[data-uid="2ad589978e"] .formkit-alert{background:#f9fafb;border:1px solid #e3e3e3;border-radius:5px;-webkit-flex:1 0 auto;-ms-flex:1 0 auto;flex:1 0 auto;list-style:none;margin:25px auto;padding:12px;text-align:center;width:100%;}.formkit-form[data-uid="2ad589978e"] .formkit-alert:empty{display:none;}.formkit-form[data-uid="2ad589978e"] .formkit-alert-success{background:#d3fbeb;border-color:#10bf7a;color:#0c905c;}.formkit-form[data-uid="2ad589978e"] .formkit-alert-error{background:#fde8e2;border-color:#f2643b;color:#ea4110;}.formkit-form[data-uid="2ad589978e"] .formkit-spinner{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;height:0px;width:0px;margin:0 auto;position:absolute;top:0;left:0;right:0;width:0px;overflow:hidden;text-align:center;-webkit-transition:all 300ms ease-in-out;transition:all 300ms ease-in-out;}.formkit-form[data-uid="2ad589978e"] .formkit-spinner > div{margin:auto;width:12px;height:12px;background-color:#fff;opacity:0.3;border-radius:100%;display:inline-block;-webkit-animation:formkit-bouncedelay-formkit-form-data-uid-2ad589978e- 1.4s infinite ease-in-out both;animation:formkit-bouncedelay-formkit-form-data-uid-2ad589978e- 1.4s infinite ease-in-out both;}.formkit-form[data-uid="2ad589978e"] .formkit-spinner > div:nth-child(1){-webkit-animation-delay:-0.32s;animation-delay:-0.32s;}.formkit-form[data-uid="2ad589978e"] .formkit-spinner > div:nth-child(2){-webkit-animation-delay:-0.16s;animation-delay:-0.16s;}.formkit-form[data-uid="2ad589978e"] .formkit-submit[data-active] .formkit-spinner{opacity:1;height:100%;width:50px;}.formkit-form[data-uid="2ad589978e"] .formkit-submit[data-active] .formkit-spinner ~ span{opacity:0;}.formkit-form[data-uid="2ad589978e"] .formkit-powered-by[data-active="false"]{opacity:0.35;}@-webkit-keyframes formkit-bouncedelay-formkit-form-data-uid-2ad589978e-{0%,80%,100%{-webkit-transform:scale(0);-ms-transform:scale(0);transform:scale(0);}40%{-webkit-transform:scale(1);-ms-transform:scale(1);transform:scale(1);}}@keyframes formkit-bouncedelay-formkit-form-data-uid-2ad589978e-{0%,80%,100%{-webkit-transform:scale(0);-ms-transform:scale(0);transform:scale(0);}40%{-webkit-transform:scale(1);-ms-transform:scale(1);transform:scale(1);}} .formkit-form[data-uid="2ad589978e"]{max-width:700px;}.formkit-form[data-uid="2ad589978e"] [data-style="clean"]{width:100%;}.formkit-form[data-uid="2ad589978e"] .formkit-fields{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-wrap:wrap;-ms-flex-wrap:wrap;flex-wrap:wrap;margin:0 auto;}.formkit-form[data-uid="2ad589978e"] .formkit-field,.formkit-form[data-uid="2ad589978e"] .formkit-submit{margin:0 0 15px 0;-webkit-flex:1 0 100%;-ms-flex:1 0 100%;flex:1 0 100%;}.formkit-form[data-uid="2ad589978e"] .formkit-powered-by{color:#7d7d7d;display:block;font-size:12px;margin:0;text-align:center;}.formkit-form[data-uid="2ad589978e"][min-width~="700"] [data-style="clean"],.formkit-form[data-uid="2ad589978e"][min-width~="800"] [data-style="clean"]{padding:10px;}.formkit-form[data-uid="2ad589978e"][min-width~="700"] .formkit-fields[data-stacked="false"],.formkit-form[data-uid="2ad589978e"][min-width~="800"] .formkit-fields[data-stacked="false"]{margin-left:-5px;margin-right:-5px;}.formkit-form[data-uid="2ad589978e"][min-width~="700"] .formkit-fields[data-stacked="false"] .formkit-field,.formkit-form[data-uid="2ad589978e"][min-width~="800"] .formkit-fields[data-stacked="false"] .formkit-field,.formkit-form[data-uid="2ad589978e"][min-width~="700"] .formkit-fields[data-stacked="false"] .formkit-submit,.formkit-form[data-uid="2ad589978e"][min-width~="800"] .formkit-fields[data-stacked="false"] .formkit-submit{margin:0 5px 15px 5px;}.formkit-form[data-uid="2ad589978e"][min-width~="700"] .formkit-fields[data-stacked="false"] .formkit-field,.formkit-form[data-uid="2ad589978e"][min-width~="800"] .formkit-fields[data-stacked="false"] .formkit-field{-webkit-flex:100 1 auto;-ms-flex:100 1 auto;flex:100 1 auto;}.formkit-form[data-uid="2ad589978e"][min-width~="700"] .formkit-fields[data-stacked="false"] .formkit-submit,.formkit-form[data-uid="2ad589978e"][min-width~="800"] .formkit-fields[data-stacked="false"] .formkit-submit{-webkit-flex:1 1 auto;-ms-flex:1 1 auto;flex:1 1 auto;}

    Leave a Comment!

    I love hearing from you and as always would love to learn your ideas, perspectives, and comments. And if you just want to say “hi” – would love to take the opportunity to say “hi” back!

    Related Links:

    Leave a Reply

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

    shares