Uncategorized

The Best Household Budget Worksheet! And it’s Free!

Recently a tragic event in my local community has brought to my attention that not as many woman as I thought, have a say or any control of their own personal or family finances, which I have taken for granted. I am fortunate enough to be in an equal relationship where mutual respect and appreciation is a key to the survival of our marriage.

My husbands preference is to not see the bills as they come in and fall due, as this impacts his anxiety and usually keeps him awake at night, so early on in our relationship our accounts were joined and I took over running the daily ins and outs of our finances.

So today I am sharing with you the best household budget worksheet, which I’ve set up! And we are going to discuss how important it is for you to have your own household budget and have some input into the family finances, which should be of mutual benefit to you and your partner.

The purpose of a household budget worksheet!

A household budget should be in place to avoid living pay cheque to pay cheque. With so much debt in society today and the threat of interest rate rises, the potential for all this to negatively impact on your families ability to meet its financial obligations is real.

For example if you only pay the minimum repayments on your mortgage and don’t have any savings at the end of the month, how are you going to afford any interest rate increase if they go up? Similarly, if you are renting, are you happy to rent forever?

Or do you have a longer term goal of owning your own property? Do you dream of travelling, or have an item you are saving for?

How do you know how much you will need to put away to reach those goals?

A household budget worksheet setting out your monthly in’s and out’s from a monetary perspective will be able to set you on the path of meeting these goals.

Putting a budget in place allows you to see all the wages, salary and any other income items you get in a set period depending on your pay cycle. Then when comparing that to your expenses in the same cycle, whats left after you take the expenses away from your pay will show the excess you could potentially save in that period, or highlight any shortfall you are somehow going to have to make up for.

My family budget is done on a monthly cycle as both our pay cycles are on a monthly basis, which means we need to be pretty vigilant with our savings! We both get paid on the 15th of the month and it looks like all our Christmases have come at once, but without tracking our expenditure on a weekly basis, by the time the 30th of the month comes around we would be living on fresh air if it weren’t for a budget.

Separate or Joint Bank accounts?

I am not going to tell you how to run your finances, these are decisions that need to be made mutually between you and your partner. I underline the word mutually because you both need to have input into how your family finances are run. If a decision is made to have separate accounts, make sure you are both able to openly discuss the balances and what you need money for to meet your joint expenses.

Money unfortunately means control in a lot of situations.

We are hearing more frequently in the media instances of denial of access to finances, or a partner having total control over the cash in the family.

This is a form of domestic abuse.

If you are in a situation where you have no visibility over the total cash inflows and expenses of your household, and this isn’t by your own choice, I urge you to consider the health of this relationship and seek help. Turn to a friend, email me at nicole@mumsonline.com.au, or if you would prefer to be anonymous please check out the White Ribbon Website.

If you are the primary carer, and perform the domestic duties, and you don’t have access to funds or need approval for cash to be spent on the day to day necessities by your partner who “earns the income” this is not acceptable.! You work hard raising those kids, you work hard keeping on top of the household duties, you do work and therefore you need access to money to meet your households basic needs.

There is a difference between needs and wants, and I learned early on in Year 7 social studies that the two shouldn’t be confused. A need is defined as something that is a basic requirement including food, shelter, warmth, clean clothing and health care. A want is something that isn’t necessary but we desire or wish for it. (I would love to have a manicure every 3 weeks, but alas this is a want and shouldn’t be confused with a need. My husband would love to play golf every week, this is a want and not a need.)

If you can’t provide these basic needs, or need to seek approval for cash to cover them, this is not a positive relationship! I know some instances where cash is dished out as an allowance, but that “allowance” doesn’t come close to covering these costs. Know your worth and know you deserve better!

In my household our preference is for a joint bank account. It makes managing the household budget a lot easier. Both our wages go into this account and all our expense come out of this account. Any excess we have to put towards savings, goes into a completely separate account, that we still both have access too. As I said earlier my husband doesn’t like to know what goes on with the money, but he does have one requirement and that is that money needs to be in the account. This is a pretty reasonable request, if he needs to get petrol, he wants to know cash is there. So we always keep a buffer in the account. Everything else goes into savings. We have a mutual understanding that big purchases need to be discussed, and our savings sit in a separate account so that they can’t be accessed through an ATM or by our debit card.

Setting up a Spreadsheet!

Here is my template of The Best Household Budget worksheet, which you can download it for free! Play around with it as you need, and add or delete columns that personalize the budget to your own needs. The pink columns are where you input your monthly income and expected expenses. Feel free to add or delete the description columns as you need. The total columns are formula generated, and shouldn’t need updating. (If you add a new row, you will need to sum the column at the end.)

At the moment the budget is set for monthly. However, if you feel you need to budget more on a weekly basis, feel free to personalize it to best suit your household.

If we look at it, the top rows reflect all monthly income, including, wages, rent income, investment earnings, other earnings. And this is subtotaled to represent the total income expected for the month.

Now for the expenses, and this can be a little harder especially when starting out!  I have listed the most common items, and what we use in our household. This includes, annual insurances, mortgage repayments, car repayments, monthly groceries, school expenses and extra curricula expenses. These descriptions can be amended, so make it your own. Each column is subtotaled down the bottom to show you the expected monthly outgoings.

Budgeting for expenses gets easier over time, so don’t expect to perfect it straight up. If you know you spend $200 a week on groceries, put that $800 in for the month. Then at the end of the month go through your bank account statements and see where you money went. This will enable you to see what your actual expenses where versus what you thought they were.

If you pay your gas and electricity quarterly, put in the average quarterly expense based on your experience, then adjust as you need too.

Once you take away your income subtotal from your expense subtotal, you will have either a positive figure, this will be excess that can go towards savings, or you may have a negative figure which means you need to somehow cut some expenses for that month and tighten the belt, or dip into the savings you have from previous months. A good example of when the budget shows you may fall short is when insurances and registrations are due, these are big lump sums that happen once a year, and if input correctly you will know when to expect them and so savings from previous periods will be used to cover that month of negative spend.

Below this positive or negative figure is the balance of total cash in your bank accounts. This will be NIL if you have no savings to begin with, but hopefully with time and use of the spreadsheet you will see this figure increasing. This figure needs to be updated at the end of each month to accurately reflect you actual cash savings position, and should agree to your total bank accounts with cash in them, to truly reflect what you have saved (or haven’t saved.)

Check in regularly!

A household budget isn’t something that is set and forget! It needs constant maintenance and updating to work properly for you. Particularly when you are getting used to it and gaining a feel for what goes in and how often certain expenses occur, e.g. rates may be quarterly, insurances annually. At least look at it in line with your pay cycle and update appropriately to make sure its accurately reflecting your e households situation.

Then choose a point, say at the end of the month, to true up your budget. So for example if you had your budget set for June, and expected a savings of $1,000 did this in fact happen? Or did you only save $500? Was there school excursions that came up unexpectedly, or some household maintenance that was urgently required. Then match this back to what is actually in your cash accounts. So at the 30 June did you bank account reflect a cash position of $3,000 savings from last month plus the $500 from this month with a total cash savings at 30 June of $3,500.

My budget attached above, has this running line so that you can project your savings, but also allows you to monthly true it up, and see what you are saving as the months tick by. Its the variance at the bottom which will show how much you were out by, and depending on how big this variance is, you may want to check it out further.

Take control and get budgeting!

To take control of your own personal wealth you need to plan for it, and you do that through budgeting. If you currently have no control over the finances, become familiar with my spreadsheet, play around with it, do some modeling and then sit down with your partner and show them how budgeting can benefit both of you in the long run to achieve some goals you have set. The spreadsheet could show you that within six months you could save enough for that holiday you deserve. By working together on the household budget you might find you both actually enjoy doing it and work towards achieving something financially together.

If you do have access to the cash, but you don’t know where it all goes by the end of the month, itemizing the expenses as per the Mumsonline spreadsheet, will tell you exactly where the money goes, and you will be able to see that maybe those monthly nail/hair appointments are costing you those few extra gifts at Christmas the kids are asking for.

Having a budget can only benefit your household, and although finances can be stressful on many families maybe working together on a budget will help improve your personal relationship, and also your relationship with money!

So what are you waiting for? Download the spreadsheet and get budgeting!!

I’d love to know how you went with the spreadsheet and hear any feedback, so please feel free to comment below.

If you have realized that you need to top up your income with some side work, check out my article on how to earn money and work from home these might just be some options that can help you out.

If you run your own small business check out why you should undertake a SWOT analysis here and see how it can help you with your business strategy.

 

 

 

 

 

11 Comments

  • Rob

    Hey Nicole 🙂 I’m always talking about budgets and joint accounts and separate accounts. It never ends. I think it can work both ways. I think having a budget that two people can oversee and stick to is a great plan.
    But I do believe in having both joint accounts and separate accounts as well. I told both my daughters to ALWAYS have their own money and accounts because you never know. Low and behold her **** soon to be ex-husband screwed her big time. Even though she’s gone through hell she’s glad she listened to me about her own accounts.
    Great article Nicole 🙂
    ~Rob

    • Nicole

      Thanks for your comment Rob, absolutely can work both ways. Finances are such a difficult topic in a lot of relationships, and I think trust factors into it as well big time. I guess my experiences have come from a controlling factor, in where money isn’t treated equally in a relationship, and one partner holds the purse strings in a position of power! But absolutely agree with your advice, particularly if someone is in a situation they are looking to leave, I know some of our financial institutes will assist women/men in setting up an account, and provide support, when looking to leave a relationship. For me I feel that the household should be run as a team where all resources are pooled together for the best outcome. If everyone has access to whats available with clear viability of cash coming in and cash going out , then you keep each other in check with a budget, and when discrepancies arise you can deal with it straight away.
      I hope your daughter gets through her divorce ok, and I am sure she is very grateful for your advice.

  • Kevin McNamara

    Hey Nicole,

    What a brilliant and informative post! So many people don’t budget or have one partner in a relationship in charge of the finances and problems arise. Money. Some say its the root of all evil, I say the love of money is the root of all evil.

    Love the budget planner. Thank you. Young people really need to read this post. Who am I kidding…everyone needs to read this! Just good common sense advice which sadly is not in great supply these days. Will share this if thats ok?

    Keep up the great work,

    Kev

    • Nicole

      Thanks for the comment Kev, and I have to agree with you Kev, its the love of money for sure that makes people do evil things. More than happy for you to share. I hope it’s able to help a few people out! I’m totally surprised by the number of people/families that dont have a budget in place. I can’t handle the stress of not knowing how much I need to put aside for bills that come in next month, so rely heavily on the budget.
      Would love to know how your friends go with the budget spreadsheet and any input for improvement would be appreciated. 🙂

  • Gillian

    Going through your post I realized my mistakes financially. I am not managing well my income and expenses. I’ll pick up from your post and apply it in our household. Thank you for sharing.

    • Nicole

      Ooooohhh I’m so glad you found it useful Gillian, please let me know how you go with the spreadsheet, and let me know if you need a hand with it! Great job in taking control of your finances, and I hope it helps you out!

  • Jeff

    Nicole, I appreciate your article. I’m more of a financial planner and my wife would prefer to not know what is going on as long as she can continue to spend. We have yet to put a budget together and that often causes me a lot of stress as I’m trying to juggle the funds around her spending to ensure we have enough to cover all the needs. I’m going to share the article with my wife to hopefully open her eyes a bit.

    Thank you,
    Jeff

    • Nicole

      Jeff, I’m so glad you found it useful, it is really stressful juggling it all! My husband is also a bit of a spender, (we both are, lets be honest) so when we havent budgeted for us both spending and then the bills roll in I wear the brunt of the stress juggling everything. Please share with your wife, I’d love to get her thoughts on it as well. Good luck and hopefully it eases your stress some what. 🙂

  • Loes

    Hi Nicole, thank you for your view on budgeting. The best way for me is to pay the bills the day they arrive, and when I don’t have the cash to pay it right away, to call the company right away for a periodic finance arrangement. That works best for me. As you understand, I am the one who deals with the finances:)
    Loes

    • Nicole

      No worries at all Christine, I am so glad you found the information useful. Please let me know if you have any problems with the budget, as I am always here to help. 🙂

Leave a Reply

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