Key takeaways
- A working Excel budget needs three tabs: Setup for categories and limits, Log for transactions, and Dashboard for the totals.
- One SUMIFS formula pulls spending by category and month, and an IF statement flags any category over its limit.
- Put the month in a single cell on the Dashboard. Changing that cell rolls the whole workbook forward, so you never copy tabs or rewrite formulas.
- Keep to 8 to 12 categories and four log columns. Too much structure is the usual reason spreadsheet budgets get abandoned.
- A 15-minute weekly check is the whole maintenance routine. If typing every purchase is the part you will not keep up, a free budget app may suit you better.
A monthly budget planner in Excel needs three tabs, two formulas and one cell that holds the month. This guide gives you the exact columns and formulas, then covers the weekly routine that keeps a spreadsheet budget alive past week two.
Free download: skip the building and start from the finished workbook. It has the three tabs and formulas described below, with sample rows to replace. It uses plain ranges instead of an Excel Table, so it also opens in Google Sheets.
What does a working Excel budget need?
Three tabs: Setup, Log and Dashboard. Anything more becomes clutter you will abandon, and anything less breaks the first time a category changes.
- Setup holds your categories and monthly limits in one list.
- Log holds one row per purchase.
- Dashboard adds up the log by category and compares each total with its limit.
The reason to separate them is that categories and limits change. If a category name is typed inside a formula, adding "vet bills" means editing formulas. If the name lives in a Setup cell, you add one row and move on.
How do you build the Setup tab?
Use three columns: Category, Monthly limit and Type. Type is either Fixed (rent, insurance) or Variable (groceries, fun money), which helps later when you decide where to cut. A starter version looks like this:
| Category | Monthly limit | Type |
|---|---|---|
| Rent | 1,600 | Fixed |
| Groceries | 550 | Variable |
| Eating out | 180 | Variable |
| Transport | 120 | Variable |
| Subscriptions | 45 | Fixed |
| Health | 100 | Variable |
| Savings goal | 400 | Fixed |
Pick 8 to 12 categories
Thirty micro-categories look thorough and get abandoned by week two, because every purchase becomes a small decision about where it belongs. Group anything under about $50 a month into an "Other" row. You can split a category later once the log shows you what is worth watching. If you have not decided your categories yet, our beginner's guide walks through choosing them from last month's statements.
How do you build the Log tab?
Four columns are enough: Date, Category, Description and Amount. Select the range and use Insert, then Table, so Excel names it (call it Log) and extends formulas automatically as you add rows. In the Category column, add a drop-down through Data, Data Validation, List, pointing at the category names on Setup. The drop-down matters more than it looks: "Grocery" and "Groceries" would otherwise be counted as two categories.
Enter each purchase as you spend, or batch them in one weekly sitting. Either works. The log only needs to be complete by the time you look at the Dashboard.
How do you build the Dashboard tab?
Start with one month cell
In cell B1, type the first day of the month you are budgeting, for example 11/1/2026, formatted as a date. Everything else reads from this cell. When December starts you change B1 to 12/1/2026 and the whole sheet moves forward.
Spent, limit and remaining
List your categories in column A starting at row 4, matching the Setup tab. Then use these columns:
- B (Limit): =VLOOKUP(A4,Setup!A:B,2,FALSE) pulls the limit from Setup.
- C (Spent): =SUMIFS(Log[Amount],Log[Category],A4,Log[Date],">="&$B$1,Log[Date],"<"&EDATE($B$1,1)) adds that category's purchases dated inside the month.
- D (Left): =B4-C4
- E (Status): =IF(C4>B4,"OVER","OK")
SUMIFS takes the range to add up first, then pairs of ranges and conditions. Here it matches the category and keeps only dates from the first of the month up to, but not including, the first of the next month. EDATE adds one month to the date in B1, so the sheet needs no manual date entry. Microsoft's help page for SUMIFS documents the argument order.
Totals and one visual
At the top, add three large cells: income (from Setup), total spent (=SUM(C4:C15)) and left (income minus spent). Then select columns D and E and add a conditional format that turns negative numbers and "OVER" red. A clustered bar chart with spent beside limit makes an overrun obvious at a glance, but the red cells already do most of that work.
What does the weekly routine look like?
Pick one fixed slot, such as Sunday evening, and spend 15 minutes on three things: enter any receipts that are not in the log, compare the log with your bank or card statement to catch missed purchases, and look at the Left column. If a category is past 80% of its limit before the last week, adjust next week's spending rather than raising the limit mid-month.
Because you type everything yourself, no bank login or account is involved. That is the main privacy benefit of a spreadsheet, and the main cost is the typing. Our Google Sheets version shows how to enter purchases from a phone.
Why do people stop using spreadsheet budgets?
The usual reason is upkeep. Logging a purchase takes about 30 seconds, and after a couple of weeks of 30-second interruptions, the log goes stale. Three habits help:
- Batch your entries into two short sessions a week instead of logging in the moment.
- Put the Log tab first, so the file opens where you work.
- Copy recurring items (rent, subscriptions) into the log on the first of the month, so you only type the unusual purchases.
Excel, Google Sheets or a budgeting app: which fits?
Score each option on privacy, cost, upkeep and whether money sits next to the rest of your life.
- Excel costs nothing extra if you already own it, works offline, and keeps the file on your computer. You maintain the formulas.
- Google Sheets is free, shares easily and opens on a phone, but the file lives in your Google account.
- Paper & Prosperity is a free budget and debt app for iPhone, iPad, Android, Mac and the web. It uses manual entry with no bank link, so the privacy is similar to a spreadsheet without the formula upkeep. It does not import transactions.
- Empire Life Dashboard is a one-time purchase ($37 for Mac, $36.99 for Windows, with a 7-day free trial) that holds your budget in one tab next to your calendar, goals, health, home and people. It also uses manual entry and has no bank connection.
Choose the spreadsheet if you want zero cost and total control and you do not mind fixing a formula now and then. Choose an app if the upkeep is the part you would skip.
Importing the file into Google Sheets
If you later move the workbook to Google Sheets, upload the .xlsx file to Google Drive and open it with Sheets. Check three things afterwards: that the Table references converted (if not, replace them with plain ranges such as Log!D2:D1000), that the drop-down lists still point at the Setup categories, and that the conditional formatting and chart survived.
Takeaway: One month cell, one SUMIFS formula and one weekly check are the whole system. If you keep it that small, you are far more likely to still be using it in March.
FAQ
How do I make a monthly budget planner in Excel from scratch?
Create three tabs named Setup, Log and Dashboard. On Setup, list your categories with a monthly limit for each. On Log, add one row per purchase with a date, category, description and amount. On Dashboard, use SUMIFS to total each category for the month and compare it with the limit.
Can I reuse the same Excel budget file every month?
Yes. If the Dashboard has one month cell and your formulas read from it, you change that cell on the first of the month and the totals follow. Keep the Log as a running list for the year, and save a copy of the file each January.
What formula flags overspending automatically?
SUMIFS totals the month's spending for one category. Wrap it in IF and compare it with the limit: =IF(C2>B2,"OVER","OK"), where C2 is spent and B2 is the limit. Add conditional formatting to turn the OVER cells red.
Do I need to connect my bank for a spreadsheet budget to work?
No. An Excel budget runs on whatever you type in. Typing is slower than automatic imports, but your account details never leave your bank, and many people find that looking at each purchase is what changes their spending.
Is Excel or Google Sheets better for a budget?
Both work. Excel is stronger offline and with big files. Google Sheets is easier to share and to open on a phone. The structure in this guide works in either, with small differences covered in our Google Sheets version of this guide.
Sources
- Microsoft Support, SUMIFS function. The sum range comes first, followed by pairs of criteria ranges and criteria.
- Consumer Financial Protection Bureau, Your Money, Your Goals toolkit. Includes a cash flow budget tool for tracking income and spending.
Join the conversation
Questions or your own experience? Leave a comment below.
Comments could not load here. You can read and join the conversation on GitHub Discussions.