How to Create an Excel Budget

Here is a guide on how to make a budget in Excel. Making a budget is a useful aid to get a solid overview of your personal finances, or the finances of a company.

A budget consists mainly of the quite simple arithmetic operations addition and subtraction. This is something a spreadsheet can do for you with ease.

Excel Instruction

Making a Budget Spreadsheet

Divide your different income and expenses into separate categories. These categories will depend on your sources of income (or the company’s). Do the same with your expenses.
Enter the amounts for each category.
Sum your income, and then your expenses.
Lastly, calculate the projected surplus or deficit by subtracting expenses from income.

Example 1

Erica Clementine is making an overview of all the income and expenses she expects in a certain month. She needs your help to use Excel to create a budget.

Below you have categorized Erica Clementine’s various income sources and expenses.





Bookstore (part time)


Bus card


Dog sitting


Phone subscription


Monthly allowance


Food and snacks


Clothes and shoes






Enter these numbers into Excel:

Spreadsheet in Excel presenting income and expenses

Eventually, sum all the income and expenses, and find Erica Clementine’s surplus/deficit:

Spreadsheet in Excel summarizing income and expenses

Here are the formulas used for each cell.

Spreadsheet in Excel presenting formulas used for summarizing

Note! Notice that Erica Clementine’s budget had a surplus because the number in cell  B11 is positive. You should always set up budgets with a surplus.

Want to know more?Sign UpIt's free!