How Do You Create A Budgeting Template In Excel From Scratch

The short version: a proper Excel budgeting template needs just four tabs (Income, Expenses, Summary, and a rolling monthly view), three formulas you'll use (SUM, SUMIF, and a simple variance calculation), and about 90 minutes if you sit down and do it instead of watching another tutorial about it. Skip the fancy dashboard on day one. Get the numbers right first, then make it pretty.

I've built budgeting spreadsheets for my own business for over fifteen years, and for a good chunk of that time I made the same mistake everyone makes: I started with formatting. Colours, conditional formatting rules, a nice header, maybe a chart. Then two months in I'd realise the whole thing didn't add up because I'd built the pretty bit before I'd built the working bit.

So here's the order that works, built the way I build mine now.

Start with a blank workbook, not a template

I know this sounds backwards when the whole point of this post is to help you build a template. But every downloadable Excel budget template I've ever opened, and I've opened dozens, comes with someone else's categories, someone else's assumptions, and formulas locked into cells you don't understand. You end up fighting the template more than using it.

Open a new blank Excel file. Save it straight away as "Budget_2026" or whatever you'll search for later. I still have a colleague who lost three months of her business's financials because she called the file "Untitled 4" and Excel autosaved over the version she needed. Name it, save it, then start.

Tab one: Income

Create your first sheet and rename the tab "Income" by double-clicking it at the bottom.

• Column A: Date
• Column B: Source (client name, salary, side income, whatever applies)
• Column C: Category (a dropdown works well here, more on that below)
• Column D: Amount
• Column E: Notes

Row 1 is your header row. Bold it, freeze it (View, Freeze Panes, Freeze Top Row), and leave the formatting there. That's it for now.

For the Category dropdown in column C, select the cells you want the dropdown in, go to Data, Data Validation, choose List, and type your categories separated by commas: "Consulting, Product Sales, Refunds, Other." This one small step saves you from typing "Consulting" one week and "consulting fees" the next, which sounds trivial until you try to SUM a category six months later and half your entries don't match because of a capital letter.

Tab two: Expenses

Same structure, new tab, renamed "Expenses":

• Column A: Date
• Column B: Payee
• Column C: Category
• Column D: Amount
• Column E: Fixed or Variable

That last column matters more than people think. Fixed costs, rent, software subscriptions, insurance, don't move much month to month. Variable costs, travel, ad spend, contractor fees, do. When you separate the two you can spot the real problem areas fast. In my own business, splitting fixed versus variable was what showed me I was spending £340 a month on software tools I'd forgotten to cancel, three of which did exactly the same job. That single column, not a fancy formula, saved me over £4,000 a year.

Build your Category dropdown here too, and try to keep it under 12 categories. I've seen budgets with 40 expense categories and the owner still can't tell you where their money goes, because nobody wants to categorise a £3.50 coffee into one of 40 options, so everything ends up dumped in "Miscellaneous" and the whole exercise becomes pointless.

Tab three: the formulas that do the work

This is the tab most tutorials rush through, so let's slow down.

Create a new tab called "Summary." Down column A, list your categories from both Income and Expenses. In column B, you're going to pull totals using SUMIF.

The formula looks like this:

=SUMIF(Expenses!C:C, "Software", Expenses!D:D)

This tells Excel: look through column C on the Expenses tab, find every row where the category is "Software," and add up the matching amounts from column D. Type this for every category, changing the category name in the quotation marks each time.

Better still, don't hardcode the category name. Instead, reference the cell:

=SUMIF(Expenses!C:C, A2, Expenses!D:D)

Now if the category in cell A2 says "Software," it pulls software totals. Change A2 to "Travel" and the formula updates itself. This is the difference between a spreadsheet you rebuild every month and one you keep using.

For income, same idea, referencing your Income tab instead.

Then, at the bottom, three simple totals:

• Total Income: =SUM(B2:B10) (adjust the range to match your list)
• Total Expenses: =SUM(C2:C10)
• Net Position: =B11-C11

That Net Position row is the one number you should be looking at every single week. Everything else is detail.

Tab four: the monthly rolling view

Here's where most people either stop, or overcomplicate things with a dashboard they'll never update. Build a simple table instead:

• Row 1: months across the top, January through December
• Column A: your categories down the side
• Each cell: a SUMIFS formula that pulls totals for that category, in that specific month

The formula gets one extra condition compared to SUMIF:

=SUMIFS(Expenses!D:D, Expenses!C:C, "Software", Expenses!A:A, ">="&DATE(2026,1,1), Expenses!A:A, "<"&DATE(2026,2,1))

That pulls every "Software" expense that falls in January 2026. Copy it across for each month and each category, adjusting the dates. Tedious to set up once, useful for the rest of the year because now you can see March compared to January without opening three different files.

The uncomfortable part nobody tells you

Here's the bit most posts on this topic skip over entirely: your budget will be wrong for the first three months, and that's normal, not a failure. I've built dozens of these and every single time the first quarter throws up categories I hadn't thought of, income I forgot to log because it came in through a payment platform rather than a bank transfer, or a subscription that renewed annually and threw the whole monthly average off by hundreds of pounds.

Most guides make it sound like you build the template once and it just works. It doesn't. You build it, you use it badly for eight to twelve weeks, you fix the categories, you add a line you forgot, and then it works. If your first month's numbers don't balance, that's not a sign Excel is broken or that you're bad with spreadsheets. It's a sign the template is doing its job and showing you where your record-keeping has gaps. Treat month one as a data-gathering exercise, not a performance review.

Adding conditional formatting (once, and only once, the numbers are right)

Now, and only now, go back and make it easier to read. Select your Net Position row, go to Home, Conditional Formatting, and set a rule: green if greater than zero, red if less than zero. Do the same on individual expense categories against a budget target, so if "Marketing" goes over what you planned, the cell turns amber. It takes about four minutes and it means you can glance at the sheet instead of reading every line.

Where people usually go wrong

The three most common mistakes I see when people build their own template from scratch:

• Building categories that are too broad or too narrow. "Bills" tells you nothing. "Electricity bill for the second floor office in March" is more detail than you need. Aim for the level where a category has between 3 and 15 entries a month.
• Forgetting one-off annual costs. Domain renewals, annual software licences, insurance premiums paid yearly. These wreck monthly comparisons if you don't divide them by 12 and account for them as a monthly cost anyway.
• Never opening it again after week two. A template only works if updating it takes under ten minutes a week. If it's taking longer, your categories are too complicated and you need to simplify, not add more columns.

If you're running this for a household rather than a business, the categories and logic shift slightly, and I've written a full separate walkthrough on building a household budget spreadsheet that works, which covers things like joint accounts and irregular income that this business-focused version doesn't touch on.

A quick real example

When I rebuilt my own business tracking after a rough patch a few years back, I sat down on a Sunday afternoon with exactly this structure: Income, Expenses, Summary, Monthly view. Four tabs, maybe 15 categories total. Within the first month I found £212 going out monthly to a webinar tool I hadn't logged into in four months, and a recurring client payment that was landing three days late every single time, which was quietly messing with my cash flow assumptions. Neither of those would have shown up if I'd just glanced at my bank balance. The spreadsheet made the invisible visible, which is the entire point of building one from scratch instead of downloading someone else's version.

Keeping it going

Set a recurring 15-minute slot in your calendar, same day each week, to log entries and glance at the Summary tab. Not to redesign it, not to add features, just to log and look. The templates that fail are the ones people plan to "sit down with" once a month. The ones that work get touched weekly, briefly, without ceremony.

Once your own numbers are solid, that same Summary tab structure becomes the backbone for basic financial forecasting too, since you'll already have clean monthly data sitting there ready to project forward.

Frequently asked questions

Do I need Excel or will Google Sheets work the same way?

Google Sheets uses nearly identical formulas, SUMIF and SUMIFS work exactly the same way, so everything in this guide transfers directly if you prefer working in Sheets instead of Excel.

How many categories should a budgeting template have?

Aim for somewhere between 8 and 15 categories total across income and expenses combined. Fewer than that and you lose useful detail, more than that and you'll stop categorising things because it feels like too much admin.

What's the single most important formula in a budgeting template?

SUMIFS, because it lets you pull totals filtered by both category and date range, which is what turns a flat list of transactions into an actual month-by-month comparison you can act on.

Why doesn't my budget balance in the first month?

This is normal and happens to almost everyone, usually because of forgotten one-off costs, irregular income sources, or categories that need adjusting. Treat the first month as a test run rather than a final result.

Further reading

• Microsoft's own Excel documentation

Related reading: What Makes a Good Excel Checklist Template for Daily Tasks and What Is The Best Free Excel Template For Creating Price Quotations.