How to Use The Excel
This comprehensive excel budget planner automatically works everything out for you. Just add add income into the income tab and spend into the spend tab and the results will be summarised on the Summary tab!
It’s a super simple way to manage your household, personal or even small business budgets as it shows you at a glace where all your money is coming from and often more importantly; where it is going to.
How The Excel Budget Planner Spreadsheet Works
It’s super simple to use, even if you’ve never used an excel template before.
To give you some ideas, the download file has an example budget template in the first sheet – you can see how all the numbers work out to the summary totals and what general headings for expenditure, bills and income you might want to use.
The main file consists of 3 sheets.
Your first task will be to add in all your income into the income tab: like this………………….
As you can see, there is a calculation in the sheet that automatically works out what your monthly income will be based on your inputs into the weekly, monthly or yearly columns. all you have to do is make sure that you only enter numbers into these fields, it will automatically add the dollar sign so you don’t need to add that in.
This is really useful if you get money at odd times in the month or the year, just add in when you usually receive it and the totals will work themselves out – just like magic!
Adding Expenses To The Spreadsheet
Next you will need to enter all your expenditure into the expenses tab: like this……………………..
Here you will notice that there is an extra column for you to add a category for your spend. You don’t have to use this if you don’t want to but you will see how useful this is when we get to the summary page!
As with the income sheet, there is a calculation in the sheet that automatically works out what your monthly expenditure will be based on your inputs into the monthly or yearly columns. All you have to do is make sure that you only enter numbers into these fields, it will automatically add the dollar sign so again, you don’t need to add that in.
The Budget Summary is Calculated for You!!
Finally we arrive at the summary page where all the figures that you have entered into the previous 2 sheets can be seen, sumarised in one place.
The spend totals are grouped into categories (these are the ones that you added above) so that you can easily see where all your money is going.
The total income and total spend values at the top of this page are a summary of your monthly activity. This might look a little different to your current budget plan because both the spend and income sheets allow for any yearly lump sums that you might receive or pay out; such as annual bonuses or tax bills.
The Printable Budget Work Sheet
We have optomised the above sheet for printing so if you don’t want to use the automated version, please feel free to download our printable option and fill it in at your leasure.
Please click HERE or any of the images above and we will send you a link to access ALL our free downloads.
Also, we promise; no spam or newsletters, we we only get in touch when we have something new that we think you might like.
If you would like to have a go at making your own printable budget sheet, or any other printable form or schedule for that matter, take a look at THIS. We’ve made a fancy version of the budget printable and put together some instructions on how you can make yur own FREE versions using a FREE VISME account.
So now that you have your budget sorted – how about you start work on your debts?
We’ve built a free cost of debt calculator that you might find really handy for this.
If you are struggling with debt right now, please don’t worry too much – I know it’s not easy but there is help avaialble.
If you are in the US try Debt.org
If you are in the UK, The money advise service is always a very reliable source of information