Excel Budget Template: Free Download + 20-Minute Setup

Hey folks, it's Ren here.

Excel users are the hardest people we sell to. I mean that as a compliment.

I read every review that comes in, and a while ago I went back through all of them since 2023, nearly five thousand, and pulled out the ones that mention Excel by name. Ninety-seven of them. They rate us lower than everyone else, and when they are unhappy it is almost never about the maths. It is about a formula that would not open on an older laptop, or a sheet that tried to be too clever. Excel people know what a spreadsheet should feel like, and they notice when it does not.

Rebuilt September 2026 as the single Excel guide on this site: the free download, the tab-by-tab build, the version check most templates skip, and what our own Excel customers told us.

So this is the Excel budget template guide written for that crowd. A free download, the twenty minute build if you would rather make your own, and the one thing the roundup articles never mention: which Excel you actually have, and why that decides which formulas you can trust.

"Simplicity is the ultimate sophistication." — Leonardo da Vinci

📌 Is Excel good for budgeting?

Excel is good for budgeting because the file belongs to you, it works with no internet connection, it handles years of data without slowing down, and the handful of features a budget actually needs have not changed in nearly two decades. If you already have Excel on your machine, you already own the best budgeting tool most people will ever need.

The honest trade-offs are two. Excel does not pull your bank transactions in on its own, so you type them, and I have come to think of that as the point. Typing "groceries, 138" is the moment you notice groceries. And sharing a live file with a partner is clumsier than in Google Sheets, unless the workbook sits in OneDrive, where co-editing works well enough for a household.

If the sharing matters more to you than the offline ownership, the same build in the Google Sheets budget template guide is the sister article to this one. The products we sell are identical in both apps, so nothing below locks you in.

🧱 How to make a budget in Excel, tab by tab

A working Excel budget template needs two sheets, a Setup sheet that holds your income and category list, and a Monthly sheet that logs what happened, plus a Summary sheet once the first two exist. Here is the build in the order that avoids rework.

The Setup sheet. Cell B1 is your monthly take-home pay. Below it, one category per row with a budgeted amount beside each. Select the category list and give it a name in the Name Box (top left, just type Categories and press Enter). Keep this sheet boring. Everything else reads from it.

The Monthly sheet. A header row that reads Date, Category, Description, Budgeted, Actual, Difference. Click anywhere in it and press Ctrl+T to turn the range into a Table. That one keystroke is the most under-used feature in Excel budgeting: the header stays visible as you scroll, new rows inherit every formula on their own, and totals become a tick box under Table Design. Then select the Category column, open Data, then Data Validation, choose List, and type =Categories as the source. From now on the same thing is always spelled the same way, which is what stops "Groceries", "groceries" and "food" becoming three categories by March.

The formulas. Everything else is these, and every one of them runs on any Excel since 2007.

Job	Formula	What it does
Total a column	=SUM(Monthly[Actual])	Adds every actual amount in the Table, however many rows it grows to
Spent per category	=SUMIFS(Monthly[Actual],Monthly[Category],A5)	Adds only the rows tagged with the category in A5, so one line per category on the Setup sheet
The gap	=B5-C5	Budgeted minus actual, so a negative number means over
The flag	=IF(D5<0,"Over","Under")	Turns the gap into a word you can scan in a second
The safety net	=IFERROR(C5/B5,0)	Percent of budget used, without a #DIV/0! when a category is still empty

Then one conditional formatting rule on the Difference column: Home, then Conditional Formatting, then Highlight Cells Rules, then Less Than, type 0, and pick a light red fill. Now the sheet reads itself. Anything shaded is a category to look at, and nothing else needs your attention.

Notice what is not in that table. No XLOOKUP, no FILTER, no LET, no spilled arrays. Not because they are bad, but because a budget does not need them, and leaving them out is what makes the file open cleanly on whatever laptop you have. More on that in a moment.

To make the build concrete, here is a real shaped household on 4,800 dollars a month take-home, ten categories, one ordinary month.

Category	Budgeted	Actual	Difference
Rent	$1,500	$1,500	0
Groceries	$560	$612	-52
Power, water, internet	$210	$198	+12
Fuel and transport	$280	$305	-25
Insurance	$170	$170	0
Phone and subscriptions	$95	$109	-14
Eating out and fun	$260	$318	-58
Personal and clothing	$120	$84	+36
Debt repayment	$350	$350	0
Savings	$500	$500	0
Total of $4,800 take-home	$4,045	$4,146	-101

Four shaded cells, 101 dollars over, and 755 dollars of the 4,800 with no job. That unassigned number is the one to fix, and the fix is a sinking funds block: every bill that comes less than monthly, car registration, insurance renewals, Christmas, the dentist, listed on the Setup sheet with its annual cost divided by twelve. For this household that is about 380 dollars a month, moved to a separate account on payday, and the four yearly emergencies stop being emergencies. If you want that block as its own tracker, the sinking fund tracker spreadsheet guide is the long version.

🖥️ Which Excel do you have? The check every template skips

Before you download any Excel budget template, including ours, open Excel, click File, then Account, and read the version under Product Information. If it says Microsoft 365 or Excel 2021 or newer, every template on the internet will open. If it says 2019, 2016 or older, or you are on Excel for iPad, a template built with the newer functions will open as a column of #NAME? errors, and no amount of tutorial fixes that.

This is the differentiator nobody in the roundup articles talks about, and it is the single most common reason an Excel budget "doesn't work" in the reviews we get. One in six of our Excel reviews mentions a version, device or compatibility problem. The template was fine. The laptop was from 2018.

The good news is that a complete budget, dashboards included, needs none of the new functions. SUMIFS, IF, Tables, dropdowns, conditional formatting and SUMPRODUCT have been in Excel since 2007, and they behave identically in Google Sheets, Apple Numbers and LibreOffice. Build on those and the file opens everywhere, for everyone in the house, for years.

Two more practical checks. If a downloaded file opens with a yellow Protected View bar, click Enable Editing, and the formulas will start calculating. And if the file is a .xlsm rather than a .xlsx, it contains macros. A budget does not need macros, and I would treat one that has them as a reason to keep looking.

🗺️ What Reddit gets right about Excel budget templates

The personal finance communities on Reddit favour spreadsheets over apps for three reasons the regulars keep repeating: control, privacy and cost. The thread consensus is less about a brand than a principle, that the best Excel budget template is the one you will still be opening in month four, which is usually a simple one you own rather than rent. We went through those threads properly, option by option and catch by catch, in the Reddit budget template guide, so this page stays on the build.

💬 What our own Excel buyers told us

Reddit is other people's customers. Here are ours. I pulled every review that names Excel out of the nearly five thousand customers have left us since 2023 and sorted them by what they actually talk about.

Three things stand out. First, the thing Excel buyers praise most is not a feature, it is that a person answered when they got stuck, which tells you how often a spreadsheet leaves people stranded. Second, one in five says the tutorial video is what got them going, and one in twelve volunteers that they are not good with Excel, so a template has to assume a beginner even when the buyer is not one. Third, Excel reviewers are our toughest crowd, 79 percent five-star against 91 percent across the store, and every low score was about a version, a device or complexity. Not one was about a wrong number.

That shaped everything above. Six ordinary features, no macros, no new functions, one colour rule, and a video for the people who want one.

⚠️ Mistakes that kill an Excel budget by week three

• Downloading before checking your version. Fix it: File, Account, read the version, and if it is older than 2021 stick to templates built on SUMIFS rather than XLOOKUP and FILTER.
• Typing categories instead of picking them. Fix it: a Data Validation list, because SUMIFS cannot add up three spellings of the same word.
• Using a plain range instead of a Table. Fix it: Ctrl+T, so new rows inherit the formulas and the totals never stop one row short.
• Twenty categories. Fix it: merge anything under three transactions a month, since friction at the moment of logging is what ends budgets.
• Budgeting the year's bills as if they were monthly. Fix it: a sinking funds block, annual cost divided by twelve, moved on payday.
• Set and forget. Fix it: one calendar reminder on a day you already keep, five minutes, Summary sheet only. The templates that last are the ones with a weekly entry habit behind them.

If what you mostly want is the spending log on its own, the expense tracker in Excel guide is that build without the budget columns, and if the budget is for a business rather than a household, the small business budget template for Excel swaps categories for cost centres.

🛠️ Set it up in 20 minutes

1. Check your Excel version and open a blank workbook. File, then Account. Anything from 2007 onward runs this build, and knowing the version tells you which downloaded templates to trust.
2. Put take-home pay in one cell and list your categories under it. This is the Setup sheet. Name the category list Categories in the Name Box so the dropdown can find it.
3. Make the Monthly sheet and press Ctrl+T. Date, Category, Description, Budgeted, Actual, Difference, then turn it into a Table named Monthly so the header stays put and formulas fill down on their own.
4. Turn the Category column into a dropdown. Data, then Data Validation, then List, with =Categories as the source, so the same thing is always spelled the same way.
5. Add the formulas and one colour rule. SUMIFS per category on the Setup sheet, budgeted minus actual for the gap, IF for the flag, IFERROR on the percentage, and a conditional format that shades any negative difference.
6. Add a sinking funds block, then save to OneDrive and share it. Every once-a-year bill divided by twelve, the total moved on payday, and the file in OneDrive so your partner can log from their phone.

That is the Excel budget template you build yourself, and it handles the fundamentals. Here is what the fully built one looks like, the recurring expenses side of one monthly tab, with bills, debt, subscriptions and variable spending each totalled against budget.

🎯 Your action steps this week

• Open Excel, click File then Account, and write down your version before you download anything.
• Grab the free template and download it as .xlsx, or build the Setup sheet with your take-home pay and categories.
• Make the Monthly sheet, press Ctrl+T, and turn Category into a dropdown.
• List every bill that comes less than monthly, divide each by twelve, and open a separate account for the total.
• Log this week's spending from your banking app, even though the month has already started, and put one five minute review in the calendar. If the whole system is new to you, the budget spreadsheet hub is the wider map.

❓ Frequently asked questions

Does Excel have a free budget template?

Yes. File, then New, then search "budget" inside Excel gives you Microsoft's built-in monthly and household budgets. They are a reasonable start, though the categories are fixed and there is no budget-versus-actual on every line. The free Simple Budget template above adds a self-totaling tracker, a 50/30/20 calculator and an expenses chart, and one click, File, then Download, then Microsoft Excel, gives you a normal .xlsx.

How do I make a budget in Excel from scratch?

Put take-home pay and a category list on a Setup sheet, make a Monthly sheet with Date, Category, Description, Budgeted, Actual and Difference, press Ctrl+T to make it a Table, turn Category into a dropdown, then add SUMIFS per category, budgeted minus actual, one IF and one conditional format. It takes about 20 minutes.

Why does my downloaded budget template show #NAME? errors?

The template uses a function your version of Excel does not have, usually XLOOKUP, FILTER, UNIQUE or LET, which only exist in Excel 2021 and Microsoft 365. Check File, then Account for your version. Templates built on SUMIFS, IF and Tables open on any Excel since 2007.

Is Excel or Google Sheets better for budgeting?

Excel wins on offline use, file ownership and speed with big histories. Google Sheets wins on sharing with a partner and editing from a phone. The build above is identical in both, and our templates ship for both, so pick the one already on your devices.

Can I use an Excel budget template on a Mac or iPad?

Yes. Excel for Mac runs every formula above. Excel for iPad and the mobile apps open and edit the file but can be slow with large dashboards and do not support every newer function, which is one more reason to build on the everyday ones.

The people who rate us hardest taught me the most about what a budget template should be. Plain, honest about what it needs to run, and boring in all the right places.

Check your version, build on the left column, and start on the day it is.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.