How to Make a Monthly Budget in Excel (Step-by-Step for Beginners)

Most people avoid making a monthly budget because they think it means spending less. It doesn't. A budget is just a plan for the money you already have — a way to know where it goes instead of wondering. Once you see the pattern, you can decide what to do about it. This guide shows you how to make a monthly budget in Excel from scratch, using a simple structure that works whether you earn a regular salary, freelance, or have variable income.

Why a monthly budget matters

Without a budget, three things happen almost universally: (1) you underestimate variable spending like dining out and subscriptions, (2) you save whatever is left at month-end, which is usually nothing, and (3) irregular expenses like insurance renewals or holiday gifts sneak up and land on credit cards. A budget fixes all three by turning "somehow" into "on purpose."

A good monthly budget gives you:

• A clear picture of income vs spending
• An emergency fund and savings goals that actually get funded
• Early warning when a category is drifting over
• Confidence to say "yes" to spending — because you know it fits

The 50/30/20 rule — the simplest budget framework

If you've never budgeted before, start here. Take your monthly take-home pay (after tax) and split it:

• 50% for needs — rent or mortgage, utilities, groceries, insurance, transportation to work, minimum debt payments. The must-pay items.
• 30% for wants — dining out, entertainment, hobbies, subscriptions, non-essential shopping, travel. The nice-to-have items.
• 20% for savings and debt payoff — emergency fund, retirement contributions, extra debt payments, investments. The future-you items.

You don't have to hit these percentages exactly on month one — the point is knowing whether you're at 50/30/20 or 60/38/2. If your savings percentage is under 10%, that's the signal to look at variable spending.

The 5 sections every monthly budget needs

Whether you use the 50/30/20 rule or your own framework, structure your budget with these five sections:

1. Income

List every source with its expected monthly amount. Include:

• Primary salary (after tax)
• Secondary income (freelance, side gig, rental income)
• Investment income (dividends, interest)
• Other regular income (child support, alimony, refunds)

For variable income (freelancers), budget based on your last 6 months' average — not your best month.

2. Fixed expenses

Bills that are roughly the same amount every month:

• Rent or mortgage
• Utilities (electricity, water, gas, internet, phone)
• Insurance (health, auto, home, life)
• Loan payments (car, student, personal)
• Subscriptions (streaming, cloud, software, gym)
• Childcare or school fees

Fixed expenses are your baseline "cost of existence." Track them separately because they're hard to change month-to-month.

3. Variable expenses

The big opportunity area — spending that changes month to month based on your choices:

• Groceries
• Dining out (restaurants, coffee, takeout, delivery)
• Transportation (fuel, transit, rideshare, parking)
• Entertainment (movies, concerts, hobbies, events)
• Personal care (haircut, gym, skincare)
• Shopping (clothing, household items, gifts)
• Medical (copays, prescriptions, over-the-counter)
• Miscellaneous

If you're going to trim, this section is where you have the most control.

4. Savings and investments

Every budget must have this line — even if the amount is small:

• Emergency fund (target: 3-6 months of expenses)
• Retirement (401(k), IRA, pension contributions)
• Investments (brokerage, index funds)
• Specific goals (down payment, vacation, wedding, business seed money)

If you save whatever's left over, you'll save nothing. Assign the amount at the start of the month.

5. Debt payments

List each debt separately so you see progress:

• Credit card minimum payments
• Extra payments toward the debt you're focused on (snowball or avalanche method)
• Student loan payments
• Any personal or family loans

Step-by-step: build a monthly budget in Excel

1. Open Excel or Google Sheets and create a new file called "Monthly Budget — [current month]".
2. Set up 5 sections in columns for Income, Fixed Expenses, Variable Expenses, Savings, Debt Payments.
3. In each section, use these columns: Category | Note | Budgeted | Actual | Diff.
4. Fill Budgeted amounts based on your last 1-2 months of actual spending. Look at your bank and credit card statements to get real numbers — don't guess.
5. Add SUM formulas at the bottom of each section for Budgeted and Actual columns.
6. Add a summary card at the top showing: Total Income, Total Planned Spending, Money Left Over (Income − Spending).
7. Calculate Savings Rate: =Total Savings / Total Income, formatted as a percentage. Target 20% or higher.
8. Enter Actual amounts as they happen — ideally weekly, minimum monthly. The Diff column shows where you're on or off track.

How to actually stick to a budget (the hard part)

The template is easy. The habit is what matters. A few things that work in practice:

• Look at it more than once a month. A budget you check on the 30th is a report, not a tool. Check weekly.
• Automate savings first. Set up an automatic transfer to savings the day after payday, before you can spend it. The savings section becomes a fixed expense.
• Round expenses UP when budgeting. If groceries were $487 last month, budget $520. Room for reality prevents "failed month" fatigue.
• Have a monthly review with your partner if you share finances. 20 minutes over coffee. Compare notes on categories that drifted.
• Give yourself a "fun money" line. Wants that require no explanation. A budget with zero fun money is a diet — sustainable for weeks, not years.
• Roll the surplus. If you had money left over, don't spend it. Move it to savings or debt payoff before the next month starts.

Common monthly budget mistakes

• Budgeting who you wish you were. If you spent $300 on dining out last month, budget $250 — not $80.
• Forgetting irregular expenses. Annual insurance renewals, car registration, birthdays, holidays. Divide the yearly total by 12 and allocate a small monthly amount.
• Not tracking actuals. Budgeting without tracking is a wish list. The Actual column is where real change happens.
• Setting goals with no timeline. "Save more" isn't a goal. "Save $6,000 for emergency fund by December" is.
• Not talking about it with your partner. Money is the #1 topic couples argue about. Budgets built together stick; budgets imposed by one person fail.

Save time — download the free monthly budget template

Instead of building the layout and formulas from scratch, download our free Monthly Budget Spreadsheet. It has all 5 sections pre-built with sample data, Budgeted vs Actual columns, a Monthly Summary card at the top, automatic Savings Rate calculation, and a 12-month Yearly Summary sheet. Currency-neutral — works with dollars, euros, pounds, or any currency.

For related planning: our Business Expense Tracker is what to use if you're a freelancer keeping side-business expenses separate from personal, and the Cash Book Template works well if you deal in cash frequently.

Summary

A monthly budget is a plan for the money you already have. Split your take-home pay into needs (50%), wants (30%), and savings + debt payoff (20%). Structure the plan into 5 sections — income, fixed expenses, variable expenses, savings, and debt — with Budgeted and Actual columns. Track weekly, review monthly, and roll surplus into savings instead of spending it. Start realistic; adjust as you learn your actual patterns.

FAQ

How do I make a monthly budget for beginners?

Start with the 50/30/20 rule: 50% of take-home pay for needs (rent, utilities, groceries, insurance), 30% for wants (dining, entertainment, shopping), 20% for savings and debt payoff. In a spreadsheet, list each category with a Budgeted amount and an Actual amount. Fill in actuals as transactions happen. At month-end, review categories where you overspent and adjust for next month.

What is the 50/30/20 budget rule?

The 50/30/20 rule is a simple framework where 50% of your take-home pay goes to needs, 30% to wants, and 20% to savings and debt payoff. It's a starting benchmark — you can adjust the percentages to your situation (some people use 60/20/20 or 70/20/10), but the discipline of assigning every category to a bucket is what makes it work.

How much should I save each month?

A common target is 20% of take-home pay. If you're just starting, even 5% is better than 0% — the habit matters more than the amount. As you pay off debt and increase income, aim to grow your savings rate over time. This template calculates your savings rate automatically so you can track progress.

What's the difference between fixed and variable expenses?

Fixed expenses are roughly the same amount every month — rent or mortgage, insurance, loan payments, subscriptions. Variable expenses change based on your choices — groceries, dining out, entertainment, shopping. Variable expenses are usually the easiest to trim when you need to save more.

Should I use a budgeting app or a spreadsheet?

Both work. Apps (Mint, YNAB, EveryDollar) auto-sync with your bank and are easier to maintain. Spreadsheets give you full control, work offline, don't require a subscription, and are portable. If you've tried apps and they didn't stick, a spreadsheet often does — because manually entering each transaction forces awareness.