Quick answer: To make a budget in Excel, open a blank sheet and build four columns — category, planned, actual, and difference. List your income up top, your expenses below, then let two simple =SUM formulas add each up and one subtraction show what’s left. That’s the whole engine. It helps to know what “normal” looks like: the average U.S. household spent $78,535 in 2024, with housing alone eating 33% (BLS) — and with prices up 3.8% over the past year, a budget that just watches where the money goes is worth building.
Be honest — you’ve probably made a budget in Excel before. You picked nice colors, bolded the headers, felt like a tiny CFO for twenty minutes… and then never opened it again. Same. The spreadsheet isn’t the hard part; Excel will do the math forever. The hard part is building something simple enough that you actually come back to it in week three.
So that’s what we’re doing here: a budget that takes fifteen minutes to set up, uses maybe three formulas total, and is boring enough to keep. No macros, no pivot tables, no finance degree. Let’s go.
Key takeaways
- A working budget in Excel needs just four columns: category, planned, actual, difference.
- You only need two formulas — =SUM to total, and a subtraction to see what’s left. Excel handles the rest.
- Compare your plan to real benchmarks (housing ~33%, transport ~17%, food ~13%) so you know if your numbers are realistic.
- The budget you keep beats the fancy one you abandon. Simple wins every single time.
What a budget in Excel actually is (don’t overthink it)
Strip away the intimidation and a budget is just two lists and some subtraction: money coming in, money going out. Excel’s only job is to add up each list and show the difference, so you can answer the one question that matters — is there money left, or am I about to overspend?
Everything else — the colors, the charts, the tabs for every month — is decoration. Nice to have, but not the point. If your spreadsheet answers “what’s left?” at a glance, it’s already doing more than most people’s budgets ever do.
How to make a budget in Excel, step by step
Open a blank workbook and follow along. This takes about fifteen minutes the first time and five minutes a month after that.
- Set up four columns. In row 1, type Category, Planned, Actual, and Difference across cells A1 to D1. Bold them so they’re easy to spot. These four headers are the entire skeleton.
- List your income first. A couple of rows down, write “Income,” then list each source — paycheck, side gig, that one Venmo your roommate always owes you. Put the amounts under Planned.
- Total your income. In the row below your income list, click the Planned cell and type
=SUM(, drag over your income amounts, close the parenthesis, and hit Enter. Excel adds them for you. This is formula number one. - List your expenses. Skip a row and start a new block: rent, utilities, groceries, gas, subscriptions, fun money, savings. Yes, savings goes here — pay yourself like a bill. Put each planned amount in the Planned column.
- Total your expenses. Same move: an
=SUM(under your expense list. Formula number two. You’re done learning formulas, I promise. - Find what’s left. In an empty cell, subtract:
=your income total cell-your expense total cell. If it’s positive, that’s your breathing room. If it’s negative, the sheet just did its job and caught a problem before your bank did. - Fill in “Actual” as the month goes. The Planned column is your intention; the Actual column is real life. For Difference, type
=planned-actual so you can see where you drifted. This one column is where all the useful, slightly humbling insight lives.
That’s a complete, functional budget. Want it prettier later? Format the totals as currency or drop in a chart — but don’t let decorating become procrastination. A plain sheet you use beats a gorgeous one you don’t. And if building it from scratch already sounds like a chore, fair enough — there’s a shortcut coming.
What each category should actually be
Here’s what most Excel tutorials skip: they show you how to type numbers, but never what good numbers look like. So you end up guessing whether $2,000 rent is fine or a five-alarm fire. Real benchmarks help. According to the Bureau of Labor Statistics’ Consumer Expenditure Survey, here’s how the average American household actually split its spending in 2024:
| Category | Share of spending | What to watch |
|---|---|---|
| Housing | ~33% | The biggie. If you’re way over, it squeezes everything else. |
| Transportation | ~17% | Car payment + gas + insurance sneak up fast. |
| Food | ~13% | Groceries vs. takeout — this is where small leaks add up. |
| Everything else | ~37% | Healthcare, savings, fun, debt, the random Target run. |
These aren’t rules, they’re a mirror. Housing and transportation alone eat more than half of a typical budget, and housing was the one category that jumped 3.3% in 2024. If your sheet shows you at 45% on housing, that’s not a moral failing — it’s just a clear signal of where your pressure is coming from. Type your real numbers beside these and you’ll spot your trouble category in seconds.
Want the sheet already built for you?
Skip the setup. Our free monthly budget template is a ready-made spreadsheet with the columns, formulas, and totals already done — plus a dashboard that shows your leftover and savings rate the second you type a number. Use it in Google Sheets, or download it as an Excel file in two clicks. Free forever, no credit card, works on your phone too.
Get the free budget template →Common mistakes that quietly kill an Excel budget
“I’ll build every feature now.” The macros, the 12 tabs, the color-coded formatting — it feels productive, but it’s usually just fancy procrastination. Start with one plain sheet; add sparkle once the habit sticks.
“I forgot the irregular stuff.” Car registration, holidays, the annual Amazon Prime charge that ambushes you every year. These aren’t surprises — they’re expenses you scheduled poorly. Give them a line, even a rough monthly estimate.
“I only budgeted the bills.” A budget with no fun money is a crash diet — it works until Friday. Build in guilt-free spending on purpose, or your budget won’t survive contact with a real weekend.
“Savings is whatever’s left over.” Spoiler: nothing is ever left over. Put savings in as an expense line near the top so it gets funded first, not last.
The part every tutorial skips: keeping it alive
Here’s the thing nobody puts in their “10 easy steps” post. Making a budget in Excel is genuinely easy. Maintaining one is where most people quietly fall off — and it’s not a discipline problem, it’s a friction problem. Every month you reopen the file, remember what half your cells meant, re-drag a formula you deleted, and hand-type where every dollar went. Miss a week and the sheet is out of date; miss two and you stop trusting it. That’s why the average homemade budget has a shelf life of about three weeks.
You can fight that friction two ways. One: keep your Excel sheet stupidly simple, update it the same day each week, and resist the urge to redesign it. That works for plenty of people. Two: use a spreadsheet already built to stay alive — where formulas can’t break, the dashboard updates itself, and you never face a blank grid. That’s exactly why we made our monthly budget template free: the setup that kills most DIY budgets is already done, so all that’s left is the easy part — typing your numbers and watching it calculate. And if you’re here because money runs out before payday, pair it with a plan for living paycheck to paycheck so the timing finally matches.
Either path is fine. Just pick the one you’ll actually keep, because a budget only works if it’s still open in month six. The math was never going to be your problem — the coming back is. Make coming back easy and you’ve basically already won.
Frequently asked questions
How do I make a simple budget in Excel?
Open a blank workbook and make four columns: category, planned, actual, and difference. List income at the top and expenses below, use =SUM to total each, then subtract expenses from income to see what’s left. That six-step setup is a complete budget — everything else is optional decoration.
What formulas do I need for a budget in Excel?
Just two. Use =SUM(range) to add up your income and your expenses, and a simple subtraction (=income total − expense total) to find your leftover. Optionally add =planned − actual in a difference column to track where you drifted.
Is Excel or Google Sheets better for budgeting?
Both work the same for a budget — identical formulas, nearly identical layout. Google Sheets is free and syncs to your phone automatically; Excel is great if you already own it. Many templates, including ours, work in Google Sheets and download straight to Excel, so you’re not locked into either.
Does Excel have a free budget template?
Yes. In Excel, go to File, then New, and search “budget” to see built-in templates like a personal or family budget. They’re a fine starting point, though many people find a purpose-built budget spreadsheet easier to actually maintain.
How much should I budget for each category?
As a reality check, the average U.S. household spends about 33% on housing, 17% on transportation, and 13% on food, according to the BLS. Use those as a mirror, not a rule — if a category runs much higher, that’s simply where your budget is under the most pressure.
How often should I update my budget in Excel?
Once a week is the sweet spot. Pick the same day, spend five minutes entering what you actually spent, and check your leftover. Waiting a whole month lets things pile up until the sheet feels out of date, which is when most people abandon it.
Why do my Excel budgets never last?
Usually friction, not willpower. Rebuilding formulas, hand-entering every expense, and reopening a blank-looking file each month wears people down within a few weeks. Keeping the sheet very simple — or using a template that maintains itself — removes the friction that causes most budgets to die.
Can I make a budget in Excel on my phone?
Yes, with the Excel or Google Sheets mobile app, though typing formulas on a small screen is fiddly. It’s easier to build the budget once on a computer, then just enter your spending from your phone during the month.
This article is for general educational purposes only and isn’t financial advice. Your situation is unique — consider consulting a qualified financial professional before making decisions about budgeting, saving, or investing.