How to Build a Simple Monthly Budget in Excel

A monthly budget does not have to be complicated to be useful. For most beginners, the best budget is a simple one: a clear list of the money coming in, the money going out, and what is left at the end of the month.

Excel is a great tool for this because it can do the math for you, keep everything organized, and make it easy to update your numbers over time. Here is a simple way to build a monthly budget in Excel.

Step 1: Set Up the Budget Labels

Open a blank worksheet and enter these labels in column A:
(See Figure 1)

A1: Monthly Budget
A2: Income
A3: Paycheck
A4: Other Income
A5: Total Income
A6: Expenses
A7: Rent or Mortgage
A8: Utilities
A9: Groceries
A10: Transportation
A11: Insurance
A12: Phone
A13: Entertainment
A14: Savings
A15: Total Expenses
A16: Money Left Over

Figure 1

You can adjust these categories later to fit your own situation.

Step 2: Enter Your Monthly Amounts

In column B, type the dollar amounts for each item:

B3: your monthly paycheck
B4: any other monthly income
B7: your monthly rent or mortgage
B8: your utility costs
B9: your grocery spending
B10: your transportation costs
B11: your insurance costs
B12: your phone bill
B13: your entertainment spending
B14: the amount you want to save

At this point, your worksheet will be a simple two-column budget: labels on the left, amounts on the right.

See Figure 1 above.

Step 3: Add a Formula for Total Income

Click cell B5 and type:

=SUM(B3:B4)

Then press Enter.

This formula adds your income together.

Step 4: Add a Formula for Total Expenses

Click cell B15 and type:

=SUM(B7:B14)

Then press Enter.

This adds up your monthly expenses.

Step 5: Calculate the Money Left Over

Click cell B16 and type:

=B5-B15

Then press Enter.

This formula subtracts your total expenses from your total income.

If the result is positive, you have money left after your monthly expenses. If it is negative, you are spending more than you bring in.

Step 6: Add Formatting for Clarity

A little formatting can make a simple budget look much more organized. You might want to:

Color-fill the top row and change the text color to white.
Make the title larger.
Bold the labels Income, Expenses, and Money Left Over.
Shade the Total rows so they stand out.
Add a border around the total rows (select the entire table first).

These steps are optional, but it helps the worksheet look cleaner and easier to scan.

The screenshots below show the click paths for the basic formatting.

Figure 2.

Step 7: Format the Numbers as Currency

Now make the budget easier to read.

Select the cells that contain dollar amounts. Then go to the Home tab and click the Accounting Number Format button or the Currency button.

This will display your values as money, which makes the worksheet much clearer.

Why This Works

A simple monthly budget helps you answer three basic questions:

How much money is coming in?
How much money is going out?
How much is left?

That is the foundation of budgeting.

You do not need a complicated spreadsheet or advanced Excel skills to build a useful monthly budget template. A basic worksheet with a few formulas can readily give you a clear picture of your finances.

Ways to Improve It Later

Once you are comfortable with a simple budget, you can always build on it.

For example, you could:

add more expense categories
compare budgeted amounts to actual spending
create a separate worksheet for each month
add a chart to visualize your spending

But for beginners, simple is better. The goal is to build a budget you will actually use.

Final Thought

A monthly budget in Excel can be easy if you keep it simple. Start with a few labels, enter your numbers, and let Excel do the math.

A simple budget is often the first step toward better financial habits.

Page updated

Google Sites

Report abuse