How to plan your personal finances using a budget

A simple and free Excel tool to manage your personal finances

Do you ever wonder where all your money goes?

Why you’re always broke?

Why you can never seem to put any money aside for savings?

Maybe now is the time to create a budget.

But how?

We have created a free tool to help you.

It’s very simple to use. Simply enter in all of your income each month, and all of your planned expenses (or outgoings). Then as each month happens, record the actual income and expenses. By entering this information you can then compare where you think you should be spending money, and where you actually are spending it.

This is the screen where you enter your income streams
Excel sheet for entering in your planned and actual expenses or outgoings

There is also a dashboard to help you visualise the money you could save over time if you keep to your budget.

Over time you will find you are better at planning your money, and your actual spend is closer to your planned spend.

Dashboard showing information about your personal budget and finances

After opening, please ensure you set the start date for planning in cell B4 of the income sheet. The tool will then give you 10 years of financial planning from this date. You will need to have macros enabled to ensure the dashboard charts are automatically updated with your latest budget information.

That’s about it. It really is that simple, but if you have any questions then please leave them in the comments box below so we can answer them for everyone to see.

Enjoy 🙂

Here is a full video demo of how to use the budget…

Facebooktwitterredditpinterestlinkedinmail