Excel Budget Template: What to Include and How to Build
A good Excel budget template has four parts: an income list, categorized expenses with planned and actual columns, a difference column that shows over or under budget, and a summary that totals everything. Build these in one sheet, add simple SUM formulas, and update it weekly.
What should an Excel budget template include?
The best template is the one you will actually open. That usually means it is simple, with only the pieces that answer one question: where did my money go this month, and where should it go next month?
Use this checklist as your minimum:
- Income section: paychecks, side income, and any regular benefits, listed separately.
- Fixed expenses: rent or mortgage, insurance, car payment, phone, subscriptions.
- Variable expenses: groceries, gas, dining out, household items, personal spending.
- Savings and debt: emergency fund, retirement, extra debt payments.
- Planned vs. actual columns: so you can compare your intentions with reality.
- Difference column: planned minus actual for each line.
- Summary box: total income, total spending, and what is left.
Why planned and actual? A budget with only one number is a record, not a plan. Seeing both is what lets you adjust before the month is over.
How do I build a monthly budget in Excel step by step?
You can build a working version in about 20 minutes. Here is the process.
- Name the sheet and set up columns. In row 1, type Category, Planned, Actual, and Difference in columns A through D.
- List your income first. Put each source on its own row, then add a Total Income row using =SUM(B2:B4), adjusting the range to match yours.
- List expenses by group. Add a heading row for Housing, Transportation, Food, and so on, with the individual lines beneath each one.
- Add the difference formula. For expense rows, type =B10-C10 in column D and copy it down. A positive number means you spent less than planned.
- Total each group. Use SUM at the bottom of every group so you can see the big picture quickly.
- Create the summary. Make one cell for Total Income, one for Total Expenses, and one for Left Over, which is income minus expenses.
- Fill in a first draft. Use last month's bank and card statements to enter actual numbers, then set planned amounts for next month.
Tip: format money columns with the Currency style (Home tab, Number group) so every figure shows a dollar sign and two decimals.
What does a filled-in example look like?
Here is a simplified example for a household bringing home $5,200 a month after taxes. These numbers are illustrations only. Yours will depend on where you live and how you spend.
| Category | Planned | Actual | Difference |
|---|---|---|---|
| Rent | $1,650 | $1,650 | $0 |
| Groceries | $700 | $765 | -$65 |
| Utilities and phone | $320 | $298 | $22 |
| Gas and car costs | $450 | $430 | $20 |
| Dining out | $250 | $310 | -$60 |
| Savings | $600 | $600 | $0 |
In this example, groceries and dining out ran $125 over combined. The sheet makes that visible right away, so next month the household can either raise the food line or trim another category to cover it. That trade-off is the real point of budgeting.
Which formulas make an Excel budget easier to use?
You do not need advanced skills. A few formulas handle nearly everything.
SUM and SUMIF
SUM adds a range. SUMIF adds only the rows that match a category. If you keep a transaction list with a Category column (A) and Amount column (B), then =SUMIF(A:A,"Groceries",B:B) gives your grocery total automatically.
Percent of income
Add a column that divides each category by total income, such as =B5/$B$2. This shows you what share of your pay goes to housing, food, or savings. If you want a quick benchmark to compare against, try the 50/30/20 budget calculator and see how your split differs.
Conditional formatting
Select the Difference column, choose Conditional Formatting, and set negative numbers to show in red. A glance then tells you which categories need attention.
How do I handle irregular and annual expenses?
This is where most budgets break. Car registration, annual insurance, holiday gifts, and vet bills do not show up monthly, so they feel like surprises even though they are predictable.
Add a Sinking Funds section. For each irregular cost, estimate the yearly total and divide by 12. For example, a $900 annual insurance premium becomes $75 a month, and a $600 holiday gift budget becomes $50 a month.
Transfer those amounts into a savings account each month. When the bill arrives, the money is already there, and your regular monthly categories stay on track.
What mistakes should I avoid with a spreadsheet budget?
- Too many categories. Dozens of tiny lines make updating a chore. Start with 15 to 25.
- No miscellaneous line. Some spending never fits neatly. A small buffer prevents constant reshuffling.
- Budgeting for an ideal month. Use your real past spending as the starting point, not what you wish you spent.
- Waiting too long to update. Entering transactions weekly takes minutes. Waiting until month-end takes much longer.
- Hardcoding totals. Typing a number where a formula belongs means your summary silently goes stale.
Should I build my own or use a ready-made template?
Building your own teaches you how your money moves, and it costs nothing but time. It also lets you shape the layout around your life. If you would rather skip the setup, a prebuilt sheet can save an evening. The Ultimate Budget Planner Spreadsheet is one optional shortcut, though the DIY version above works fine if you prefer it.
Whichever route you choose, review your sheet at the end of each month. Ask which categories were off, adjust the planned numbers, and carry the lessons forward. After two or three months, your budget will reflect how you really live.
This article is general education, not professional financial advice. If you carry significant debt, face a major financial change, or need tax guidance, consider speaking with a qualified financial counselor or tax professional.
Frequently asked questions
Does Excel have a built-in budget template?
Yes. Excel includes budget templates you can open from File > New by searching for "budget." They are a decent starting point, but you may want to edit the categories so they match your actual spending, such as adding a line for childcare or pet costs.
How many categories should a budget spreadsheet have?
Most people do well with 15 to 25 categories. Fewer than that hides useful detail, and more than that becomes tedious to update. Start broad, then split a category only when it keeps going over budget and you need to see why.
How often should I update my Excel budget?
Weekly or twice a week is enough for most households. Paste in transactions from your bank export, then categorize them in one sitting. Waiting a full month makes it harder to remember what unclear charges were.
Is Excel or Google Sheets better for budgeting?
Excel is better if you want full control, offline access and custom formulas. Google Sheets is easier for sharing with a partner and editing from a phone. The formulas in this article work in both, so you can switch later without starting over.
How do I budget for irregular expenses in Excel?
Add a column for the annual cost, divide it by 12, and list the result as a monthly line item. Move that amount into savings each month, so the bill is already covered when it arrives. Car registration, insurance premiums and holiday gifts are common examples.