Monthly Budget Template in Excel — Complete Guide (2026)

Excel remains the go-to tool for personal budgeting — and for good reason. It's flexible, it's free if you already have Microsoft 365, and it puts every formula at your fingertips without forcing you into a subscription app. A monthly budget template in Excel lets you see exactly where your money goes each month, compare what you planned to spend versus what you actually spent, and catch problem areas before they snowball. No subscription fees, no learning curve beyond what you probably already know, and no data uploaded to someone else's server.

But what actually makes a budget template useful? Not fancy macros or pivot charts you'll never touch — the best templates are simple. You need five things: an income section, fixed expenses (rent, insurance, loan payments), variable expenses (food, fuel, subscriptions that drift month to month), a savings row, and a running balance at the bottom. That balance is just income minus total expenses. When it's negative you know you have a problem. When it's positive you know exactly how much discretionary room you have.

The real power comes from the variance column — a fourth column that subtracts your actual spending from your budgeted amount on every row. Glance at it mid-month and you can see at once whether you're on track across every category. That's not something a bank statement or a phone app gives you in one view. It's what makes a well-structured monthly expense tracker in Excel genuinely actionable rather than just a record-keeping exercise.

If you're brand new to spreadsheet budgeting, it's worth bookmarking a solid excel reference so you're not hunting for function syntax mid-session. And if you want a head-start rather than building from scratch, there are pre-built excel budget template options available both inside Excel and from third-party sites like Vertex42 and Smartsheet. Both approaches are covered below.

This guide walks through both paths: building your own monthly budget template step by step (columns, formulas, formatting, the works) and using Excel's built-in template library to get up and running in under five minutes. We'll also cover personal vs family vs household budget structures, month-over-month tracking on a second sheet, and the handful of formulas — =SUM(), =B2-C2, =C2/B2 — that do most of the heavy lifting.

One thing worth flagging upfront: a personal monthly budget in Excel, a household budget template, and a family budget template all share the same four-column structure. The only real difference is the category list. Personal budgets are leaner. Family and household budget templates add rows for childcare, school costs, multiple vehicle expenses, and larger grocery allocations. The core formulas are identical across all of them — so everything in this guide applies regardless of which version you're building.

Keep it low-tech at first.

You don't need colour-coded dashboards or dynamic charts to get value from your first budget spreadsheet. A plain grid with six expense categories, a savings row, and a net balance cell is enough to change how you think about money. The sophistication can come later — pivot tables, annual overview sheets, conditional formatting rules.

For now, the goal is simply to make your spending visible. That alone, for most people, is the thing that changes behaviour. You see where the money actually goes instead of where you think it goes. That's the real value of a simple monthly budget template in Excel.

Building a Monthly Budget Template From Scratch

Open a blank worksheet and start in cell A1. The column layout you want is: A — Category, B — Budgeted, C — Actual, D — Difference (=B-C). That fourth column is the most useful thing in the whole spreadsheet — it tells you at a glance where you're over or under plan without any mental arithmetic. Positive difference means you came in under budget. Negative means you overspent. That's the signal that drives action.

Set up row sections with bold header rows in between. A solid structure looks like this:

• Row 1: Column headers (Category, Budgeted, Actual, Difference)
• Rows 2–5: Income section (Salary, Freelance, Other Income, Total Income)
• Rows 7–11: Housing (Rent/Mortgage, Electricity, Gas, Internet, Water)
• Rows 13–15: Transport (Car payment, Fuel, Insurance)
• Rows 17–21: Food (Groceries, Dining out, Coffee, Work lunches)
• Rows 23–25: Utilities and subscriptions
• Rows 27–29: Entertainment
• Row 31: Savings goal
• Row 33: Net Balance (Total Income − Total Expenses)

In column B, type your planned amounts for the month — use last month's actuals as a starting point if you have them. In column C, fill in actuals as the month progresses. In column D, put =B2-C2 and drag it down every data row. Negative values mean you went over — that's exactly what you want to catch quickly, before it compounds.

For section totals, use =SUM(C7:C11) for your Housing actual total, =SUM(C13:C15) for Transport, and so on. The overall expense total at the bottom is just =SUM() across all your section total rows — reference each section's total cell rather than the entire column to avoid double-counting. Your Net Balance row is simple subtraction: Total Income minus Total Expenses.

Want to know what percentage of your food budget you've used so far this month? Put =C18/B18 in a helper column and format it as a percentage. Hitting 80% with a week still to go? You know to ease up. If you need to count how many categories have exceeded their budget, that's where countifs excel becomes genuinely handy — =COUNTIFS(D2:D30,"<0") gives you the count of over-budget rows instantly without scanning every line.

For category-level subtotals across a bigger dataset — especially if you've been tracking daily transactions for months on one sheet — the SUMIF function is your best friend. =SUMIF(A:A,"Food",C:C) pulls all rows tagged Food and totals their actuals, even if those rows are scattered across the sheet. This becomes especially powerful once you start adding months of data or logging individual purchases instead of monthly totals.

Once your formulas are in place, lock the formula cells to prevent accidental overwrites during data entry. Select those cells, right-click, choose Format Cells, go to the Protection tab, and check Locked. Then go to Review → Protect Sheet and set a simple password. Regular data entry cells — the Budgeted and Actual columns — should stay unlocked so you can type amounts in freely.

This one step saves hours of re-building blown-up formulas. Name your ranges too: selecting your Total Income cell and naming it TotalIncome in the Name Box means your Net Balance formula reads =TotalIncome-TotalExpenses — far easier to audit three months later.

Conditional Formatting for Over-Budget Rows

Once your variance column is live, the next step is making over-budget rows jump out visually. You shouldn't have to scan numbers — Excel should flag the problem automatically. That's the whole point of building a living spreadsheet rather than a static record.

Select the range in your Difference column (say D2:D30). Go to Home → Conditional Formatting → Highlight Cell Rules → Less Than. Enter 0 and pick a red fill. Any row where actuals exceed the budget turns red the moment you type the actual figure. Add a second rule: Greater Than 0, green fill. Now your spreadsheet works as a traffic-light system with zero manual checking. Red means act. Green means you're on track.

You can take it further: select the entire row range (A2:D30) and use a formula-based conditional formatting rule. Go to Home → Conditional Formatting → New Rule → Use a formula, and enter =$D2<0. That highlights the entire row red, not just the variance cell — much easier to read at a glance when you're scanning a long template. The dollar sign before D is important; it anchors the column reference so the rule fires correctly across all four columns in that row.

Dropdown lists for your Category column keep data consistent and make SUMIF formulas reliable. If you type "Groceries" in one row and "Grocery" in another, SUMIF won't catch them as the same category — you'll get inaccurate subtotals. Fix it with Data Validation: select your category cells in column A → Data → Data Validation → Allow: List → type your categories separated by commas, or point to a reference range on a hidden sheet. The hidden-sheet approach is cleaner; update the master list once and every month's template benefits automatically.

While you're in the formatting mindset, sort out column widths too. If category names get cut off or currency values show ##### (column too narrow), learning how to change column width in excel is a quick fix — double-click the column border in the header row to auto-fit, or drag it to a custom width. Column A usually needs the most room for category names; columns B, C, D can be narrower since they hold numbers only.

A few more formatting habits worth building: bold your section header rows (Housing, Transport, Food) and apply a light grey fill to separate the groups visually. Freeze the top row (View → Freeze Panes → Freeze Top Row) so column headers stay visible as you scroll. Apply currency formatting to columns B, C, and D (select them, press Ctrl+1, choose Currency) so amounts display with your local symbol and two decimal places automatically.

And if your budget is shared with a partner, add a Notes column (E) for flagging irregular items — annual car insurance payment, birthday dinner, one-off purchases — so the data tells a story rather than just numbers when you review past months.

Don't overlook keyboard shortcuts while you're formatting. Pressing Ctrl+Shift+$ formats selected cells as currency instantly. Ctrl+1 opens the Format Cells dialog for anything more specific. And if you're working on a monthly income and expense template in Excel with a lot of rows, Ctrl+End jumps to the last used cell — handy for checking that no stray data is lurking outside your intended range. Small habits like these speed up monthly maintenance considerably and make your personal monthly budget in Excel feel less like a chore and more like a two-minute check-in.

Tracking Month-Over-Month on a Second Sheet

A single-month view tells you how this month is going. A multi-month view tells you whether your spending is actually improving — or whether you just got lucky last month. That second sheet is where the real insight lives, and it's straightforward to build.

Create a new sheet in the same workbook and name it Annual Overview or Trends. Put category names down column A (same order as your monthly sheet) and month abbreviations across the top — Jan in B1, Feb in C1, through Dec in M1. In cell B2, type =January!C30 (or whatever cell holds your Housing actual total in the January sheet). Do that for every category row across every month column. As you fill in each monthly sheet throughout the year, the overview populates automatically — no copy-pasting, no manual updates.

Keep monthly sheets named consistently: January, February, March. If you use abbreviations or different capitalisation, cross-sheet references break. A naming convention set in month one saves headaches all year. And copy each new monthly sheet from the previous one (right-click the tab → Move or Copy → tick Create a copy), rename it, clear column C (Actual), and leave column B (Planned) as your estimate. Adjust where you know things have changed — a rent increase, a new subscription, a cancelled one.

This is where excel pivot tables become genuinely powerful. If you're logging individual transactions on a raw data sheet (columns: Date | Category | Amount | Notes) rather than just monthly totals, you can build a pivot table that summarises spending by category and by month in seconds. Add a slicer for the month field and you can filter to any month or category with a single click. It's a step up in complexity from a simple template, but it's the right tool if you're tracking 50+ transactions a month.

Want pre-built year views and comparison charts without building them yourself? Exploring the wider family of Excel budget templates from Microsoft and Vertex42 is worthwhile — many include annual summary sheets and pre-set category structures for specific use cases like student budgets, home renovation tracking, or retirement planning.

Charts are worth adding once you have two or three months of data. Select your Overview sheet's monthly totals for a category like Food, insert a line chart, and you immediately see whether spending is trending up or down. A simple bar chart comparing Planned vs Actual across all categories for the current month shows at a glance which categories consistently run over and where your estimates need recalibrating for next month. These visual patterns are often invisible when you're scanning rows of numbers — a chart makes them obvious in seconds.

One practical tip for the annual overview sheet: add a row at the top that shows your savings rate — total savings divided by total income — for each month. A formula like =January!SavingsActual/January!TotalIncome gives you a single number per month that tells you whether you're building financial margin or just treading water.

String those twelve numbers across the top of your overview and the trend is immediately obvious. That's the kind of high-level insight that transforms an excel budget planner monthly from a record-keeping tool into an actual financial planning instrument. It takes five minutes to set up and the payoff compounds every month you use it.