Monthly Budget Template in Excel: How to Set Up and Track a Household Budget

Short answer: a monthly budget template needs four parts — your take-home income, a list of spending and saving categories with a planned amount for each, a log of what you actually spend, and a summary that compares the two. In Excel or Google Sheets, a SUMIFS formula pulls each category’s actual spending from the log for the month, so you only type each purchase once and the sheet shows what is left in every category.

Budget apps do the same job, but a spreadsheet gives you categories that match your life, no subscription and full control of the numbers. This guide builds the template step by step, explains three common budgeting methods and finishes with a ten-minute monthly review routine.

The structure of a monthly budget spreadsheet

Keeping plans and actual spending on separate tabs is the key design choice. The plan changes only when you decide to change it; the transactions grow every day. Mixing them in one table is the main reason home-made budgets stop being used after a few weeks.

Step 1: Start with take-home income

Budget with the money that actually reaches your account after tax and payroll deductions — not your salary before tax. Add every regular source: wages, side income, benefits, child support. If your income varies from month to month, base the budget on a typical low month and treat anything above it as extra to allocate when it arrives.

Step 2: Set up your categories

Use enough categories to make decisions, but not so many that logging becomes a chore. Fifteen to twenty-five is a workable range for most households. A typical set, grouped:

• Fixed costs: rent or mortgage, utilities, internet and phone, insurance, childcare, minimum debt payments.
• Variable costs: groceries, transport and fuel, eating out, personal care, clothing, entertainment, gifts.
• Irregular costs: annual subscriptions, car maintenance, insurance paid yearly, holidays — see “sinking funds” below.
• Savings and debt goals: emergency fund, retirement contributions, extra debt repayments, a specific goal such as a deposit.

Put the category list in the Setup tab and use Data → Data Validation → List so the Transactions tab only accepts those names. A typo like “Grocery” instead of “Groceries” silently drops spending out of your totals.

Step 3: Choose a budgeting method

None of these is right for everyone. Housing costs alone can exceed 50% of income in some cities, so treat percentages as a check, not a rule. The template below works with any method: the difference is only in how you fill the Budget tab.

Step 4: Build the formulas

In the Transactions tab use: A Date, B Description, C Category, D Amount, E Account. Enter spending as positive numbers.

In the Summary tab, put the first day of the month you are reviewing in B1 (for example 1 Dec 2026) and categories in column A from row 4. Then:

• Planned (B): =XLOOKUP($A4,Budget!$A:$A,XLOOKUP($B$1,Budget!$1:$1,Budget!$A:$Z)) — or simply link to the right month column of the Budget tab.
• Actual (C): =SUMIFS(Transactions!$D:$D,Transactions!$C:$C,$A4,Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<"&EDATE($B$1,1))
• Left to spend (D): =B4-C4
• % used (E): =IFERROR(C4/B4,0)

Add totals at the bottom and two key figures: money left this month (income minus total actual) and savings rate (savings categories ÷ take-home income). Conditional formatting that turns column E amber above 90% and red above 100% makes overspending visible at a glance. Change B1 to another month and the whole summary recalculates.

A worked example

An illustrative zero-based budget for a household with $4,200 take-home pay:

The plan used every dollar, and the month ended $61 over. The summary shows exactly where: groceries and eating out ran over, transport and clothing came in under. The savings rate was (400 + 200) ÷ 4,200 = 14.3%. The fix for next month is a decision, not guilt: either raise the grocery budget and lower something else, or look for the reason groceries ran over.

Sinking funds: the secret to a budget that survives

Most budgets fail in the month an annual bill arrives. A sinking fund spreads irregular costs across the year. List every non-monthly cost with its yearly amount — car registration, insurance paid annually, holidays, gifts, school costs — add them up and divide by 12. In the example, $1,620 of yearly costs becomes $135 a month in the “Annual costs fund” category. Move that amount to a separate savings account each month, and when the bill comes, the money is waiting.

A ten-minute monthly review

1. Make sure every transaction for the month is logged; check against your bank and card statements.
2. Look at the red and amber categories and write one line on why each went over.
3. Check the money left and decide where it goes: savings, debt or next month’s buffer.
4. Adjust next month’s plan in the Budget tab — not this month’s, so you keep an honest record.
5. Once a quarter, review the categories themselves: merge ones you never use and split ones that hide too much.

Logging takes less time if you do it little and often: a couple of minutes every few days, or a weekly session pasting your bank’s CSV export into the Transactions tab and assigning categories.

Common mistakes

• Budgeting gross pay instead of take-home pay.
• Ignoring irregular costs until they arrive.
• Too many categories, which makes logging feel like work.
• No buffer. A small “miscellaneous” line absorbs the unexpected without breaking the plan.
• Giving up after one bad month. The first two or three months are calibration; plans get accurate as you learn your real numbers.

Frequently asked questions

Should I use Excel, Google Sheets or a budgeting app?

Excel and Google Sheets give you full control and cost nothing extra; Google Sheets is easier to share with a partner and update from a phone. Apps connect to your bank automatically but come with subscriptions and fixed categories. Many people start with a spreadsheet to learn their numbers, then decide.

How do I budget with irregular income?

Plan the month on your lowest typical income, cover fixed costs and essentials first, and keep a holding category for income above that level. Allocate the extra once it arrives, starting with a buffer of one month’s essential costs.

How do couples use one budget?

Share one Google Sheet, add a “Who” column to the Transactions tab and agree on the categories together. Some couples budget everything jointly; others share fixed costs and keep personal spending categories for each person.

How much should I save each month?

It depends on your income, costs and goals. A common approach is to build a small emergency fund first, then increase savings gradually. The savings rate in the summary lets you track the trend, which matters more than any single month.

Do I need to track cash spending?

Yes, or it disappears from the budget. Either log cash purchases as you make them, or log cash withdrawals as spending in a “Cash” category and treat that as the limit.

More guides are collected in Monthly Household Budget, part of Personal Finance & Budgeting.