dsl-logo

Home Loans

Personal Loans

Car Loans

Business Loans

Credit Cards

Banking

dsl-logo
dsl-logo

Home Loans

Personal Loans

Car Loans

Business Loans

Credit Cards

Banking

Background

FREE BUDGET PLANNER AND GUIDE

How to create the ultimate budget (and stick to it)

Budget Planner Spreadsheet

In this ultimate budget planning guide, we’re going to take you through the budgeting process step by step, and show you how budgeting can be the best decision you’ll ever make for your financial future.

What is a budget plan?

A budget plan is an accounting tool which lets you easily track your income and expenditure. A budget plan is a crucial part of an effective financial plan, and can be created to track short, medium, or long-term financial goals. You can use a budget plan to save money, pay off debt, or assess long-term goals such as purchasing a home. ‍

A budget plan can initially seem daunting - if you haven’t created a budget plan before, seeing your income and expenses realistically displayed in a spreadsheet can be quite a shock. However, an honest budget plan will be the best way to see how much money you have coming in and going out each week, fortnight, month or year - and help you take complete control of your finances.

Benefits of a budget plan

Having a budget that details your income and expenditure will help you to maintain control of your finances and, if necessary, illustrate the problems you may be having with your creditors.

It’s true that your debt problems won’t be solved by the fact that you have a budget alone. But beginning with this basic information about the reality of your current situation is essential.

Having a firm handle on your expenses and broader financial situation can also help you build and maintain your credit score, which will come in handy if you need to apply for a home loan, or other credit products, in the future.

What to include in your budget

1. Your earnings

This is how much money you make. Often referred to as ‘incoming money’ – your earnings should outline every known source of income you have, not just your regular salary. ‍ Your earnings should list:

Income type

    circle-green-tick
  • Salary
    circle-green-tick
  • Rental properties
  • circle-green-tick
  • Share dividends
  • circle-green-tick
  • Term deposits
    circle-green-tick
  • Secondary jobs
  • circle-green-tick
  • Royalties
  • circle-green-tick
  • Payments from a small business you may be part of

The important task when calculating your total earnings is to be exhaustive - cover as much as you possibly can - as you’ll be doing the same with the next, crucial section: expenses. If you need assistance, you can use our free Pay Calculator to quickly calculate your take-home pay for easy weekly budgeting.

2. Your Expenses

This is how much money you spend. Assess your expenses by consulting your bank statements, receipts, and financial files. Some expenses are intermittent, such as insurance payments, so to get the most accurate financial picture you can calculate an average for six months to a year. Remember that being thorough when you add up expenses is important in creating a realistic budget. A forgotten bill really throws a wrench into your savings plan. When calculating your expenses, also factor in unexpected bills, such as unplanned car repairs. ‍ A good rule of thumb is to add an extra 10-15%. For example:
calculator

You calculate your expenses

coins stacked

You estimate you spend $1,500 per month

coins-swap-02

You add a buffer of 15% which is calculated at $225

Calendar check icon

Your new expenses total $1,725 per month

Listing your expenses quickly helps you establish whether you have enough money coming in to cover these. There are also two types of expenses: Fixed and variable.

lock

Fixed (or recurring) expenses

are easily tracked, as they are often a set amount on a regular date.

lock-unlocked

Variable expenses

are slightly harder to track and may require you to set yourself a daily or weekly budget limit to help cover these. For instance, some days you may buy a coffee – other days you may not. Instead of trying to track these mini variable expenses, you might be better off stating ‘I have $50 per week for variable expenses’ and work towards sticking to this number.

Here are some tips to accurately gather your existing expenses to document in your budget:

  • Analyse your credit card statement for spending patterns by categories.
  • Analyse how much physical cash you withdraw and spend – try to not use cash ongoing.
  • Look to have all fixed expenses debited out of a single account for better tracking.

Following these tips will help you document all of your expenses for your budget spreadsheet. It will also help you identify spending patterns and behaviours that could be better managed to save money.

These spending patterns and behaviours can be called ‘spending leaks’ - we’re going to change your mindset to look at these instead as ‘opportunities to save’. ‍ You should now have a complete list of your income and expenses, which we’ll use to fill in the spreadsheet in the creating your budget section.

3. Your current debts

This is how much money you owe. To ensure your budget is effective, you need to know where it is you owe money and, importantly, how much your debts are costing you in interest. One of the most popular reasons people decide to start a budget is to assess their current level of debt and find a proactive solution to paying it off early. ‍

As you start to list your debts, consider:

1

Do you have credit card debt?

2

Do you have a mortgage?

3

Do you have a personal loan?

4

‍Do you have a car loan?

5

Do you have an investment loan?

6

‍Do you owe money to someone?

Taking the time to list each of your debts will give you mental clarity on how much you owe and the rate of interest associated with each debt - particularly useful in prioritising which debts to pay off first. You can also use this method to create goals - you could even find ways to pay your debts earlier than you’d have thought possible!

4. Your Financial Goals

This is what you want to achieve and when. Financial goals may not seem like a vital part of the budgeting process, but listing your budgeting goals will keep you motivated. If your budget spreadsheet tracks your goals clearly, you are constantly reminded of why you are budgeting in the first place. ‍ Even if your goal is just to get better control of your finances and save a little extra each week or month, any sort of budgeting goal will keep you on track. ‍ Looking to deposit some money into a high interest savings account or term deposit to earn compound interest and grow your savings? Our free Compound Interest Calculator can be used to help you plan your long-term financial goals. Questions to ask yourself when writing goals:
Plane icon

Are you saving for a holiday?

Coins hand icon

Are you starting a budget to pay off your debts faster?

users

Are you saving for your children’s education?

home

‍Are you saving for a house deposit?

clock-fast-forward

What are your short-term goals?

Calendar check icon

What are your medium-term goals?

line-chart-up

What are your long-term goals?

Shield tick icon

Are you saving for retirement?

Whatever the reason, be clear when writing your budget goals. List the goal, the due date and implement a plan to start reaching your goal – step by step. Remember that a budget spreadsheet is there to help you achieve your end goals, so be sure to list them.

Ready to set up your budget?

At Money, our goal in offering a free budget planner spreadsheet is to give everyone in Australia the opportunity to find ways to save money, set realistic goals, and then build them into a budget to show how they can be achieved.

The secret to setting up an easy and effective budget is to set yourself long-term goals and use short-term strategies and goals to get there. This will be the basis of setting up your first successful budget. ‍

Learning how to set up a budget should be easy, fun and empowering, so if you’re feeling as though tracking your finances is a struggle, or you’re concerned about not being able to save as much as you’d like to, then take your time to carefully read through this guide.

A step-by-step guide for setting up a budget to save money

Before we begin, make sure you have an accurate listing of what we covered above:

coins stacked

Your earnings

coins-swap-02

Your outgoing expenses

Credit card x icon

Your current debts

line-chart-up

Your financial goals

Create your budget in 7 simple steps

Now let’s look at how you’ll go about setting up your budget. We’ll discuss each of these in more detail below, and you can click any of the steps on the right to automatically take you to the desired section. We’ll use the notes made from the previous section to fill out the appropriate sections of the spreadsheet with your budget information.

We’re going to use this information to fill out the various pages on the Money Budget Spreadsheet Template. If you haven’t downloaded the spreadsheet, you can do so here. You can refer to Getting Started tab of the Budget Template for a quick guide on each section.

7 steps in creating a fool-proof budget

First, enter the amount of money you make each month - remember to take into account your tax rates and the amount of money you have in hand after tax as we want figures that are raw and accurate as possible to assess your actual in-hand pay. ‍

Once you’ve figured out how much money you need to stay afloat financially each month, it’s time to determine your actual income. Besides your regular salary, get an accurate picture by adding in any extra funds that come your way throughout the year, such as cash gifts, sale of items online or via garage sales, and don’t forget other income sources like alimony, child support, interest, dividends and rental income.

Now we’re going to list your expenses. To make this easier, we’ll first list all your fixed expenses; these will give you a clear overview of your expenditure commitments, and getting these out of the way first will allow you to carefully consider your variable expenses below. ‍ The Expenses Section of the Budget Template is separated into six individual sections, so you can clearly see which areas of your spending are costing you the most:

    circle-green-tick
  • Transport
  • circle-green-tick
  • Home
  • circle-green-tick
  • Utilities
  • circle-green-tick
  • Health
  • circle-green-tick
  • Entertainment
  • circle-green-tick
  • Miscellaneous

You can also include your savings account in this list, so that you start to see your savings as another bill to help you reach your goal quicker.

Once you’ve filled in your fixed expenses, repeat the process for your variable expenses. Variable expenses are items that you spend money on each month that do not have a set value. This can include groceries, eating dinner at a restaurant, buying clothes and going to the movies.

These items are variable because they allow you to cut back on them if you wish and are not critical to your monthly budgeting. ‍ The reason we need to list these items is that one of the keys to a successful budget is to factor in some spending on variable expenses so that you don’t lose motivation.

If you need help finding your variable expenses, print out three months of your everyday accounts transaction history – this can help you form the basis of where you spend your money on non-essentials.

Congratulations! The hardest part of the setup process is over, so give yourself a pat on the back. Although it’s not directly connected with figures and accounting, staying positive and reminding yourself that you’re doing something proactive in creating a budget is something to be proud of - not everyone is comfortable taking this first, important step! ‍

Now, let’s look at creating what we call ‘zero-dollar budgeting’. This is where we look at the expenses and income together, and find a way to match every dollar you earn to an assigned part of your budget. ‍ Every dollar should be accounted for, whether it be for entertainment or savings – you will want to assign a dollar value to every element of your life - the more concise, the better.

By seeing how much money is coming in versus how much money is going out, you should start seeing where your money goes and how you can make small changes.

If you find that you cannot match your numbers, you may need to start looking at ways to tweak your budget. Your variable expenses should naturally be the first items to be reduced. Should you find yourself with money left over at the end of the month, you deserve another congratulations!

Put the money into your nest egg account and enjoy the fact that you are one of the few people in Australia who manage to not waste their entire paycheck per month. ‍

If you were to find yourself not able to reduce your variable expenses any further, you may need to look at fixed expenses and your options for lowering them. This can be done through refinancing a mortgage, cutting back on extras like Pay-TV and other bills.

Now that you’ve filled in the crucial aspects of your budget, and ideally refined your personal budget spreadsheet into a zero-dollar budget, you can start to look at how you’ll track your monthly expenses. ‍Sections three and four of the Money Budget Spreadsheet are Tracking and Visual Summary.

We’ve used this format because we know everyone is different - some people find it easier to look at numbers, and some people prefer to see their finances represented visually. Whichever option works for you, that’s the one you’ll find most beneficial to continuing your savings goals.

Now that we’re tracking our expenses, it’s time to set some Savings Goals. You can use the Time Target Tool to view your savings targets, or the Monthly Savings Tool to see how much you’ll need to save each month to reach new savings goals. ‍In order to determine realistic savings and debt payoff goals, subtract your monthly expenses from your income:

    circle-green-tick
  • If you determine you’re making more money than you’re spending, congratulations. This amount can be earmarked for savings and to pay off debt.
  • circle-green-tick
  • If you determine you’re spending more than you’re making, it’s time to do some cutting so you have something to save and don’t go further into debt. The best way to figure out where you can cut from your expenses is to track your spending and record every expense for a month.

Once you have a clear picture of where all of your money goes, be merciless in cutting expenses until your budget is in the black:

    circle-green-tick
  • Cut enough so that you have 10 per cent to 20 per cent of your income left over each month to add to your savings account.
  • circle-green-tick
  • If you are unable to cut a sufficient amount from your budget, consider ways you can increase your income.

By now, you should have an ultra-clear and realistic overview of your finances. You have successfully filled in the budget spreadsheet, and you now have a personal budget of your very own. The next step is almost entirely in your hands: Monitoring your budget and adjusting as you move toward reaching your goals.

These last two steps in creating a budget are dedicated to monitoring and upkeep. We’ve included them in the budgeting guide because they’re just as important as the initial few steps; it’s important to prepare and understand how to adjust your budget to remain motivated even when unexpected things happen.

For example:

    circle-green-tick
  • Your car may need new tyres
  • circle-green-tick
  • Your dog may need to have medical treatment
  • circle-green-tick
  • Your salary may increase or decrease
  • circle-green-tick
  • Your rent may increase

Whatever happens, just remember to add it into your expenses and reassess how you can continue to stick to your budget.

Remove things from your variable category for that month so that the money is shifted directly into your emergency requirement. ‍Events such as a change in your income or accommodation arrangements, a new addition to the family or consolidating your loans all impact on your finances.

Your budget will need to change in order to accommodate them, just remember to face any changes with confidence and not bury your head in the sand!

Ready to begin saving money in a way that can completely change your life and how you view finances? Here’s your first short-term goal: Follow your newly created budget for exactly one month. At the end of the first month, evaluate how you went with your budget. ‍ Ask yourself the following questions:

    circle-green-tick
  • Where did I overspend my budget?
  • circle-green-tick
  • Where could I save more money next month?
  • circle-green-tick
  • What was the hardest thing about my budget?

Budgeting is the key to saving money. It’s the tool that keeps you honest in your money-saving endeavours; it clearly outlines how much you spend versus how much you earn and quickly helps you keep track of your personal finances with an aim to improve them. ‍

Throughout this first month, you’ll conduct a number of Budget Reviews. ‍It’s important you review your budget plan regularly, as this will help you make sure you’re sticking to your savings or debt recovery plan and enable you to identify when your budget is no longer meeting your needs.

Bonus budget tip: Committing to your budget

One of the hardest things to do is stick to your budget. People often find a burst of inspiration to create a budget spreadsheet, only to never look at it again. ‍

To create a successful budget, you must keep it current and actively refer to it. To keep your budget spreadsheet current, review and update it at least once a week.

This means checking in on your spending and always updating your fixed expenses as they increase or decrease. ‍The moment you cancel say a Netflix subscription, update your budget spreadsheet. The moment your insurance premiums (like health insurance) increase, update your budget spreadsheet. ‍

Over time you will become confident you are adhering to your budget. As your confidence grows, you will likely only need to refer to your budget each time you get paid!

Free budget planner template summary

We’ve created the Money Budget Spreadsheet to be the ultimate budget planner. Here's a summary of what the budget planner can help you with:
coins stacked

Tracks income from multiple sources, at varying frequencies

Credit card search icon

Tracks every last expense - even the little ones you may miss!

Piggy bank icon

Offers ‘simple’ and ‘advanced’ budget options (be as quick or detailed as you want)

coins-swap-02

Has unlimited expense categories and suggests ones you are likely to have

clock-fast-forward

Comes with 3 x bonus tools to estimate your savings, figure out how much you need to save and create schedules

Bar chart icon

Creates beautiful graphs to motivate you to meet your goals and continue saving

Shopping bag icon

Helps forecast spending and identifying ways to reduce it

file-check

Is 100 per cent FREE to download and use forever

Why is such an amazing tool free to use? Because we don’t believe it’s fair to charge you money when you are already trying to show commitment to saving and making a positive change in your finances.

FAQs about creating a budget planner spreadsheet

A budget planner is a way to track your income and expenses. Creating a budget plan allows you to analyse the amount you are earning vs the amount you are spending, and helps in balancing your income. A budget plan is also crucial for setting financial goals and is a popular way of learning how to manage or repay debt.

Many people start a budget is to assess their current level of debt and discover ways to either manage their debt obligations or pay debts off early. A budget will display your income vs expenses, and allow you to quickly view where you can make changes to allocate extra cash toward additional repayments, or where you can cut back on expenditure to free up cash flow.

No. You will never have to pay a single cent to use our spreadsheet. We know we could charge for this valuable tool, but we’re committed to helping everyday Australians take control of their finances.

We believe our Money Budget Planner Spreadsheet can truly change the way you view your finances, and your dedication to making this future a reality is the only investment you ever need to make.

The budget spreadsheet is made in Microsoft Excel. It is able to work on all formats of Excel. If you have Excel installed on your computer, this will work for you. Otherwise, you can upload the spreadsheet to Google Drive and use Google Sheets to fill out the template.

You certainly can, but using a budget template will make the process far easier, especially if it’s your first time budgeting. There are also lots of spreadsheets available on the internet, though there are no free templates that are as concise or useful as the one we offer here.

logo

Our Money Promise

Money Pty Ltd (trading as Money) (ABN 42 626 094 773) Australian Credit Licence 528698 provides information about credit products. Money does not compare all products or issuers available in Australia. We are not a broker or credit provider and when we provide information via this website, we are not providing you with a recommendation or suggestion about a particular credit product. We may receive a commission when you apply for a home loan as a result of outbound links on this website.

This material has been prepared by Money Pty Limited (ABN 40 664 954 536) (Money, ‘us’ or ‘we’). Money is a corporate authorised representative (CAR 001307399) of 62 Consulting Pty Limited (ABN 88 664 809 303) (AFSL 548573) (62C). The material is for general information only and is not an offer for the purchase or sale of any financial product or service. The material is not intended to provide you with financial or tax advice and does not take into account your objectives, financial situation or needs. Although we believe that the material is correct, no warranty of accuracy, reliability or completeness is given, except for liability under statute which cannot be excluded. Please note that past performance may not be indicative of future performance and that no guarantee of performance, the return of capital or a particular rate of return is given by 62C, Money, any of their related body corporates or any other person. To the maximum extent possible, 62C, Money, their related body corporates or any other person do not accept any liability for any statement in this material.

The information on this website is intended to be general in nature and has been prepared without considering your objectives, financial situation or needs. You should read the relevant disclosure statements or other offer documents prior to making a decision about a credit product and seek independent financial advice. Whilst Money.com.au endeavours to ensure the accuracy of the information provided on this website, no responsibility is accepted by us for any errors, omissions or any inaccurate information on this website.

Interest rates, fees and charges are subject to change without notice. Before acting on any information, you should confirm the interest rates, fees, charges and product information with the provider. For clarity, where we have used the terms “lowest” or “best” these relate solely to the rates of interest offered by the provider and not on any other factor. The application of these terms to a particular product is subject to change without notice if the provider changes their rates.

The calculator provided on money.com.au is intended for informational and illustrative purposes only. The results generated by this calculator are based on the inputs you provide and the assumptions set by us. These results should not be considered as financial advice or a recommendation to buy or sell any financial product. By using this calculator, you acknowledge and agree to the terms set out in this disclaimer. For more detailed information, please review our full terms and conditions on the website.

Assumptions:

  • The calculations do not account for changes in interest rates or other market conditions that may occur.
  • Results are approximations and may differ from actual payment schedules or amounts.
  • The calculator does not include all fees and charges that you may incur in relation to a financial product.

Limitation

  • This calculator does not guarantee the availability of any financial product or the accuracy of the calculations. Please consult a financial advisor or the relevant product provider to obtain specific advice tailored to your circumstances.
  • money.com.au does not accept any liability for errors or omissions, or for any loss you may suffer as a result of relying on these calculations.
Money Pty Ltd trading as Money

ABN: 42 626 094 773 / ACL: 528698 / AFCA: 83955
Money is a corporate authorised representative (CAR 001307399) of 62 Consulting Pty Limited (ABN 88 664 809 303) (AFSL 548573) (62C)
aboriginal-and-torres-strait

Money acknowledges Aboriginal and Torres Strait Islanders as the traditional custodians of country throughout Australia and their continuing connection to land, waters and community.

© Copyright 2024 Money Pty Ltd.