Set up your budget spreadsheet in five columns

Start with a blank Excel workbook. In the first row, create five column headers: Category, Budgeted Amount, Actual Spending, Difference, and Notes. This layout lets you plan what you want to spend, track what you actually spend, and see where the gap is.

In the Category column, list the spending areas that matter to you: rent or mortgage, utilities, groceries, transportation, insurance, subscriptions, dining out, entertainment, and anything else you spend money on regularly. Add a row at the bottom labeled "Total" — you will use this to sum everything up.

Make the header row stand out by selecting it, then clicking the bold button in the toolbar. This makes it easier to read when you come back to the spreadsheet later.

Key Takeaways

  • Create five columns — Category, Budgeted Amount, Actual Spending, Difference, and Notes — so you can compare what you planned to spend against what you actually spent.
  • Use the SUM function to add up your totals automatically instead of calculating by hand, which reduces mistakes.
  • The Difference column shows you which categories are over or under budget, making it easy to spot where your spending habits differ from your plan.
  • Update your actual spending column weekly or monthly so the numbers stay current and useful for decision-making.
  • Format negative numbers in red so overspending jumps out at you when you glance at the spreadsheet.

Enter your budgeted amounts and use formulas to calculate totals

In the Budgeted Amount column, type in how much you plan to spend on each category each month. Be realistic — if you spend $200 a month on groceries, do not budget $100 just because you wish you would spend less. The budget only works if the numbers reflect your actual life.

Click on the cell in the Budgeted Amount column that lines up with your Total row. Type =SUM(B2:B11) (adjust the numbers if you have more or fewer categories). This formula adds up all the budgeted amounts automatically. Do the same in the Actual Spending column so it totals as well.

Excel updates these totals every time you change a number, so you do not have to recalculate by hand. If you add a new spending category later, you can edit the formula to include it.

Track actual spending and calculate the difference

As you spend money throughout the month, enter the actual amounts in the Actual Spending column. You can update this weekly from your bank or credit card statements, or once a month if you prefer. The more often you update it, the clearer your picture of where the money goes.

In the Difference column, create a formula that subtracts Actual Spending from Budgeted Amount. Click the first cell in the Difference column and type =B2-C2 (where B2 is your budgeted amount and C2 is your actual spending). A positive number means you spent less than planned. A negative number means you went over.

Copy this formula down to every row by clicking the cell, then dragging the small square in the bottom right corner down to the Total row. Excel fills in the formula for each category automatically.

Format negative numbers to spot overspending at a glance

Select all the cells in the Difference column that contain numbers (not the header). Right-click and choose Format Cells. In the window that opens, click the Number tab, then select a format that shows negative numbers in red — usually the second or third option in the list. Click OK.

Now any category where you spent more than you budgeted shows up in red. This makes it obvious which areas need attention without having to read every number carefully. Green or black text shows categories where you came in under budget.

Add a Notes column to track why spending changed

The Notes column is where you explain unusual spending. If you budgeted $100 for dining out but spent $180, write "birthday dinner" or "unexpected lunch meetings" in that row. Over time, these notes show you which overspending is one-time and which is a pattern you need to adjust.

When you review your budget next month, the notes remind you why certain categories went over. This helps you decide whether to increase that budget line or work on spending less. Without notes, you might forget why December groceries were so high (holiday cooking) versus why January was also high (a real change in habits).

Review and adjust your budget monthly

At the end of each month, look at the Difference column. Categories that are consistently red mean your budget estimate was too low — you either need to spend less or accept a higher budget. Categories that are consistently green might have room to shift money elsewhere if you have areas that are tight.

Do not change your budget every time you overspend in one category. Instead, look at three months of data before making changes. A single month of overspending might be an exception, but a pattern across three months tells you something real about your spending.

Update your Budgeted Amount column for next month based on what you learned. If you consistently spend $250 on groceries but budgeted $200, change the budget to $250. The goal is a budget that matches your real life, not one that makes you feel bad every month.

Use conditional formatting to highlight problem areas automatically

Excel can highlight cells based on their value, so you do not have to format manually each month. Select the Difference column cells, then click Conditional Formatting in the Home tab. Choose Highlight Cell Rules, then Less Than. Type 0 and choose a red fill color. Click OK.

Now any negative number (overspending) automatically turns red without you having to format it. If you add new months to your spreadsheet, the formatting applies to them too. This saves time and makes sure you never miss an overspending category.

Frequently Asked Questions

Should I create a separate sheet for each month or keep everything on one sheet?

One sheet per month is cleaner and easier to compare. Create a new sheet by right-clicking the sheet tab at the bottom and selecting Insert Sheet. Name it with the month and year. This way you can flip between months to spot trends, and each month stays organized.

What if my income varies month to month?

Add an Income row at the top of your spreadsheet above all categories. Enter your expected income in the Budgeted Amount column and your actual income in the Actual Spending column. This shows you whether you earned what you expected and helps you adjust spending if income was lower than planned.

Can I use Excel to budget for the whole year at once?

Yes. Create 12 sheets, one for each month, or create one sheet with 12 sets of columns (January Budgeted, January Actual, February Budgeted, February Actual, and so on). The monthly approach is easier to read and update, but the yearly approach lets you see annual patterns in one place.

How do I handle irregular expenses like car insurance that I pay quarterly?

Divide the annual cost by 12 and budget that amount each month. If car insurance costs $600 a year, budget $50 per month. When you actually pay it, enter the full $600 in the month you paid it. This smooths out the budget so you are not shocked by large bills in certain months.

What if I want to track spending by person in a household?

Create a separate sheet for each person, or add a column after Category that says "Person" and list who spent the money. Then you can filter by person to see individual spending patterns. This works well for shared expenses like groceries where multiple people contribute.