How to Make a Budget in Excel (Step by Step, Free Template)

To make a budget in Excel, create a table with columns for category, budgeted, actual, and difference — then use a SUM formula to total each column. The difference column (actual minus budgeted) instantly shows where you’re over or under. Here’s the full setup, step by step.

Method 1: Build it from scratch

Step 1: Set up the columns

In row 1, type these headers:

Step 2: List your categories

Fill column A with your spending categories. A good starter list:

• Fixed: Rent/mortgage, Utilities, Insurance, Subscriptions, Debt payments.
• Variable: Groceries, Transport, Dining out, Shopping, Entertainment.
• Goals: Savings, Emergency fund, Investments.

Step 3: Enter your numbers

• Column B = how much you plan to spend on each.
• Column C = how much you actually spent (fill in as the month goes).

Step 4: Add the formulas

If typing formulas by hand is the slow part, describe your columns to an AI assistant and it will write them for you - see how to use AI for Excel formulas.

• Difference (column D): in D2, type =C2-B2 and drag it down. Negative = over budget.
• Total (bottom row): type =SUM(B2:B20) for each of columns B, C, and D.
• Total income: add an “Income” row above your categories and reference it in savings calculations.

Your budget now totals itself and shows you exactly where you overspent. For the formulas behind this, see Google Sheets formulas for beginners.

Method 2: Use a free template

Skip the setup — use a ready-made template:

• Excel: File → New → search “budget” for Microsoft’s built-in templates.
• Google Sheets: Sheets home → Template gallery → “Monthly budget”.

The template has categories, formulas, and charts already built — just replace the sample numbers.

Method 3: Use the 50/30/20 rule

A simple budgeting framework that many templates follow:

To apply it in your sheet, add three rows calculating each as a percentage of your income: =0.5 * B1 (needs), =0.3 * B1 (wants), and =0.2 * B1 (savings), where B1 is your monthly income.

Make it visual

Highlight overspending automatically with conditional formatting — color the “Difference” column red when it’s negative:

1. Select column D.
2. Home → Conditional Formatting → Highlight Cells Rules → Less than 0 → red fill.

Now anything over budget jumps out in red. For a step-by-step, see how to use conditional formatting.

Track spending by month

For a full-year budget, add a new sheet per month (January, February, …) or add a “Month” column. To sum across months in Excel, use a 3D reference: =SUM(January:December!C2) totals that cell across every sheet. Google Sheets has no equivalent, so there you’d add a “Month” column and use SUMIF.

Tips for a budget that actually sticks

• Track weekly, not monthly — smaller updates are less painful and more accurate.
• Budget to zero — every dollar gets a job, even if that job is “fun money.”
• Separate fixed vs. variable — fixed (rent) is predictable; variable (groceries) is where budgets usually slip.
• Review at month-end — compare actual vs. budgeted and adjust next month’s numbers.

A worked example

Say your monthly income is $3,000 and you’re using the 50/30/20 rule:

In your sheet, break each group into specific rows (Rent $1,100, Groceries $400, Utilities $150 under Needs, and so on). The SUM formulas total each group, and at month-end the Difference column tells you exactly where you went over.

Once your categories add up, a pivot table or an Excel dashboard turns the numbers into something you can read at a glance.

FAQ

How do I make a simple budget in Excel?

Use the setup above: Category / Budgeted / Actual / Difference columns, plus a SUM total and a =C2-B2 difference formula. It takes about 10 minutes.

Does Excel have a budget template?

Yes — File → New → search “budget” has several free templates with formulas and charts built in.

What’s the 50/30/20 budget rule?

Spend 50% of income on needs, 30% on wants, and save 20%. It’s a simple starting framework you can apply to any spreadsheet.

How do I track actual spending against my budget?

Fill in the “Actual” column as the month goes, and the “Difference” column (=C2-B2) shows over/under automatically.

Can I make this in Google Sheets?

Yes — the steps are identical, and Google Sheets has a free “Monthly budget” template. See how to make a chart in Google Sheets to visualize it too.

How do I make my budget auto-highlight overspending?

Use conditional formatting on the Difference column — rule “less than 0” with a red fill. See how to use conditional formatting.

How do I budget for irregular income?

Base your budget on your lowest recent month, and put extra income from good months straight into savings. This avoids overcommitting in lean months.

What formulas do I need for a budget?

Just SUM for totals and a subtraction for the difference column. SUMIF is useful if you want to total by category automatically — see how to use VLOOKUP in Excel for more on categorizing data.

What if my expenses exceed my income?

Your budget’s job is to reveal that before it becomes a problem. If the totals show spending over income, cut from the “Wants” category first, then look at reducing fixed costs. The Difference column makes this gap visible immediately.

Should I budget weekly or monthly?

Monthly is the standard, but tracking weekly is easier to stick with — a quick update each week beats a painful month-end session. The sheet works either way; just total your columns for the month.

Can I update my budget on my phone?

Yes — the Google Sheets and Excel mobile apps open budget templates and sheets, so you can record spending on the go instead of waiting until you’re at your computer.

How do I create a budget in Excel?

Creating a budget in Excel is the same as making one: set up Category / Budgeted / Actual / Difference columns, add =SUM() totals, and a =C2-B2 difference formula — then fill in your numbers. It takes about 10 minutes; see the steps at the top.