How to Make a Simple Budget in Microsoft Excel

Andrey_Popov/Shutterstock.com

Keeping track of your budget, whether for yourself or your entire household, is key to money management. If you already use Microsoft Excel, you can create a budget easily using a template or making one from scratch.

Use an Excel Budget Template

You can get a jumpstart on your budget by using a template. Microsoft offers several budget templates already in Excel or via the Office Template website.

RELATED: How To Create Custom Templates in Excel

To see the budget templates in Excel, open the application and select “More Templates” in the Home section.

More Templates in the Excel Home section

Enter the word “budget” into the search box and you’ll see many options.

Excel budget templates

Choose the template you want to use to see more details and click “Create” to open the template.

Create a budget with the template

You’re then on your way to budgeting your money with premade sections and built-in formulas. For more options, visit the Budget section of Microsoft’s Office Template site. You can then pick a template to download and use in Excel, or open it online and use it in Excel for the web.

Office budget templates

Use a Third-Party Budget Template

If you’ve browsed Microsoft’s budget templates and don’t see one you like, you can choose a third-party template. Sites like Vertext42 and Spreadsheet123 offer nice collections of budget templates.

Tip: One benefit of using a template is that it lists common expenses for you so that you don’t forget anything.

This option from Vertex42 is ideal for managing your own finances. It’s a personal monthly budget template with spots for all income you receive, and the expenses are grouped by category. At the top, you’ll see a wrap-up section of moneys in and out along with the net amount, totals, and averages.

Vertex42 template

The template from Spreadsheet123 is a good option for a family monthly budget. Similar to the personal budget template above, you have places for income and expenses but also with estimated and actual amounts. The top section shows you your estimated and actual totals with the differences per month.

Spreadsheet123 template

Create a Budget From Scratch

If you can’t find a template to fit your needs or just want something simple, or if you have unique circumstances and needs, you can create a budget from scratch with helpful Excel budget functions. For the purpose of this tutorial, we’ll make a basic monthly budget.

RELATED: How to Create Expense and Income Spreadsheets in Microsoft Excel

Open a new workbook, select the sheet, and give your budget a title at the top of the sheet. Then, create sections for income and expenses labeled however you like.

Title and labels for a budget

If you have more than one source of income such as more than one earner, multiple jobs, or dividends from investments, you can list those separately in your income section.

Income in the budget

Then, list all of your expenses. Be sure to include all bills, loans, and miscellaneous expenses.

Expenses in the budget

Next, head back to the top and enter the months across the second row, starting in the second column. If you prefer a weekly budget, you can enter the week numbers or for a daily budget, enter the days of the week.

Months in the budget

Tip: You can enter the first two or three months, week numbers, or days and then use the fill handle to enter the rest.

You can then start adding the amounts for income and expenses starting with your current month. If you want to insert these amounts for previous time periods, that’ll be helpful for an overall picture of the year.

To format the amounts as currency, select the cells containing the amounts. Then go to the Home tab and pick “Currency” in the Number drop-down box.

Format as currency in the budget

Because you want a clear picture of money coming in and going out, you should add totals to your income and expense sections. This will also let you easily see how much money you have remaining at the end of the month.

Go to the first cell below all income for the first month. Select the Sum button in the Editing section of the Home tab and pick “Sum” from the list. Confirm the cell range and press Enter or Return. Then, do the same for your expenses.

Total the income using SUM

You can then copy both total formulas across the rows for the remaining months. Select the cell with the formula, use the fill handle to drag to the remaining columns, and release. Although some months display $0, you’ll have the formulas ready to go when you add the amounts later.

Use Fill for the SUM formula

Next, you can include a money remaining section at the bottom as mentioned above. You can do this easily by subtracting the cell containing your total expenses from the one containing your total income.

Go to the bottom of the column for the first month, below expenses. Enter the subtraction formula for the two total cells. For instance, our income total is in cell B6, and expense total is in cell B19, so we’d use this formula:

=B6-B19

Subtraction formula for remaining money

Press Enter or Return and you’ll see your remaining money at the end of the month. Remember, you can use the fill feature to copy the formula to the rest of the months. Optionally, you can label this amount in the first column as well as the income and expense totals if you like.

Labels for totals and remaining money

Once you have this basic budget built, you can use Excel’s formatting features to spruce up the sheet if you like. Here, we simply increased the font size for the title and added font colors and bold for income expenses, totals, and months. Visit the Font section of the Home tab for options like these.

Font formatted in the budget

If you want to create a more detailed budget, take a look at our list of Excel budget functions to see if any interest you. 

Here are just a few examples:

  • Use the COUNT function to count the number of expenses you have.
  • Use the MAX function to see your most costly expense.
  • Use the TODAY function to always see the current date when you open your sheet.

With these easy ways to create a budget in Excel, you can stay on top of your incoming and outgoing money. It’s also a great option if you’re a Money in Excel user and looking for a replacement for the vanishing service.

RELATED: 7 Essential Microsoft Excel Functions for Budgeting

Budgeting