Create a Simple budget in Excel

We will create a budget to track planned explenses vs actual expenses on a monthly basis

The first thing we will need to enter is the monthy income. We will enter 40000 in B2

Next enter your planned monthly expenses and put savings at the bottom and we will calculate your savings.

The formula for the Savings will be:


We take your income in B2 and subtract the total of all your expenses and that will be your savings.

Enter your actual expenes next to your planned expenses.

So to graph our data select the information on our page

Select Insert Tab and select recommed a chart

Say Ok to the Recommended chart and the following chart will be produced

Instructions for creating a simple budget