All calculators are downloadable Excel spreadsheets that allow you to save and amend your own personal data.With this spreadsheet, enter your personal data in the purple coloured cells.

budget spreadsheet

Looking to find out where all your money goes or want to track your progress? This is the sheet for you.

I’ve updated the sheet from the previous version. This one is a bit more user friendly with all information on one page.

Just enter all your expense and income details in the purple cells and the rest will calculate for you. I’ve pre entered some common budget categories but feel free to add or delete as you please.

There has been a box added at the top for savings that are to be spent. These are things you are saving for that are outside of your normal budget. Such as a wedding, car, holiday, home improvements, and so on.

You can then see a summary at the bottom of the page with all the important information. How much you spent. How much you saved. What your savings rate is. On the far right, you can even see how much of your allocated amount for each category you have spent for the year to date and whether you may need to scale back anything.

The calculator allows for one change of regular income during the year in cell B5, so leave that blank if you don’t expect any pay changes (up or down).

Row 71 auto calculates your monthly income based on the information you enter in cells B3,4,5 and 6, but if there are any changes in any given month, such as a bonus, or time out from work, then you can enter any changes in row 72. If you don’t enter the changes the calculator will assume your income remains the same as the original inputs.

If you have any feedback or ideas for improvements I’m always keen to hear suggestions.

For some spending tips click here.

Irregular expenses conversion calculator

Irregular spend can often derail best laid plans and make us go over budget or get in a tight spot.

Because the spending happens so infrequently, we often forget about it or underestimate how much it actually costs.

Because we tend to get paid regularly, we tend to only think about regular expenses. But the irregular expenses are just as important to remember and calculate. More often than not, it is the irregular expenses that can be much more costly than the regular expenses. Because we pay for it less often. For example, home repairs or an insurance bill.

You can use this calculator to add up all your irregular bills. The calculator will then convert these bills to monthly, fortnightly and weekly amounts. Your preference will likely be the same frequency as your pay cheque.

You can then easily see the amount of money you need to reserve for these often forgotten or underestimated expenses, saving you a lot of frustration and scrambling come payment time.

I have included a bunch of examples of irregular bills to get some ideas going, but feel free to delete or add any as it applies to your situation.

Irregular expenses are still expenses. They should not be unexpected. They should be planned for. An emergency fund is for truly unforeseen circumstances. Not for irregular expenses. By preparing for irregular expenses ahead of time, you have a much clearer idea of how much you can spend and save. Then you are not surprised or panicked when the time comes to pay. The financial peace of mind is priceless.

For personalised advice on the best way to use your savings, then get in touch for a no obligations chat to see how we may be able to add value for you.

For more calculators, click here