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.

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