Household Budget Template: A Monthly Budget Spreadsheet Example

A household budget template is a simple sheet that lists your household’s monthly income and expenses line by line and shows how much is left at the end of the month. A good monthly budget spreadsheet has six sections: income, fixed expenses, variable expenses, debt payments, savings and what’s left over. The math fits on one line: left over = total income − (fixed + variable + debt payments + savings).

Below is a sample family budget spreadsheet filled in with realistic numbers for a family of four. There’s nothing to download: copy the table into your own Excel or Google Sheets file and swap in your own figures. After that, we cover the formulas, where spreadsheets tend to break down, and when it makes sense to switch to an app.

What goes in a household budget template

The simpler a budget template is, the longer you’ll actually use it. These six sections cover most families:

• Income: Take-home pay after tax and payroll deductions, side income and any other regular payments. If your income varies, use the average of the last three months.
• Fixed expenses: Costs that barely change from month to month: rent or mortgage, utilities (averaged), internet and phones, insurance, childcare, subscriptions.
• Variable expenses: Groceries, gas, dining out, clothing, health costs and fun money. This is the part of the budget that flexes.
• Debt payments: Car loan, buy-now-pay-later plans, financed purchases and card payment plans. Enter what’s due this month, not the full balance.
• Savings: What you set aside at the start of the month, plus a monthly share for yearly costs like car registration, the holidays or back-to-school.
• Left over: What remains after everything above. If it’s negative, the plan isn’t realistic yet.

Sample monthly budget spreadsheet for a family of four

This family budget spreadsheet is purely an example: two working parents, two kids, renting. Your numbers will differ depending on where you live and how your household runs; the structure is what matters.

Pasted into a spreadsheet, each row lands in its own row of cells; if the amounts paste as text, change the column’s format to Number. Let formulas fill in the “Total” rows, as shown below.

What this monthly budget planner tells you

Turning each block into a share of income makes the sheet much easier to read. In this example:

• Fixed expenses take about 45% of income ($3,350 of $7,500).
• Variable expenses take about 25%.
• Debt payments take 8%.
• Savings get about 13%.
• The buffer is about 9%, or $700.

Rent and utilities won’t change quickly; the $1,850 variable block, especially groceries and dining out, is where this family can adjust. To compare the split against a ready-made framework, see our 50/30/20 budget rule guide; if you like giving every dollar a job, a zero-based budget fits this template directly.

How to build a monthly budget spreadsheet in Excel

Setting one up in Excel takes about ten minutes, and two formulas do most of the work.

1. Set up the columns

In the first row, type the headers: Section in column A, Line item in B, Planned in C, Actual in D and Difference in E. Planned is what you expect at the start of the month; Actual is what you really spend. Seeing the two side by side is the whole point. Use one tab per month.

2. Add section totals with SUM

In each section’s “Total” row, click the Planned cell, type an equals sign followed by SUM and an opening parenthesis, select that section’s line items with your mouse and press Enter. If the income items sit in C2 to C4, the cell reads =SUM(C2:C4). Drag the formula one cell to the right into the Actual column and Excel shifts the range to D2:D4 on its own.

3. Calculate what’s left and the difference

In the Left over cell, start from total income and subtract the other four totals: type an equals sign, click the total income cell, type a minus sign, click the total fixed cell, and repeat for variable, debt payments and savings. In the Difference column, subtract Actual from Planned on each row (=C2-D2) and drag the formula down. A negative difference on an expense row means you went over plan. Conditional Formatting on the Home tab can turn negative differences red.

4. Log transactions on a separate tab

Rather than adding up actual spending by hand, create a second tab called “Transactions” and list each purchase with Date, Category and Amount columns. In the main sheet’s Actual cell, SUMIF totals every amount for that category for you. The first argument is the category column on the Transactions tab, the second is the cell holding the category name (say, B12), and the third is the amount column: =SUMIF(Transactions!B:B,B12,Transactions!C:C). Make sure category names match exactly on both tabs; a single typo makes the total show zero.

Setting up a family budget spreadsheet in Google Sheets

If you want to share the budget with a partner, Google Sheets is the easier option. The same columns and formulas work there. Click Share in the top-right corner and give your partner edit access. Version history in the File menu lets you restore a formula someone overwrote by accident. Phone entry works, but finding the right row on a small screen is fiddly, so entries often wait until evening.

Mistakes that break a budget spreadsheet

• Forgetting yearly costs: Car registration, annual insurance premiums and holiday spending come once a year and wreck that month’s numbers. Divide the yearly amount by 12 and add it to the savings section every month.
• Entering a financed purchase at full price: A $1,560 couch on a 12-month plan goes in as $130, not $1,560. Our installment tracking guide covers how to carry payments forward.
• Using gross pay: Income rows get the take-home amount that actually lands in your account.
• Skipping cash: Card purchases are easy to remember; cash at the farmers’ market or for a cab disappears.
• Filling in Actual from memory at month-end: Numbers written down on the 30th are guesses; the Actual column only works if you log spending as it happens (see how to track your spending).
• Leaving no buffer: A plan with no room for small surprises falls apart at the first one.

Where budget spreadsheets fall short

A spreadsheet is flexible and free, but it has a few structural problems that make it hard to keep up:

• Everything is manual: Every purchase means opening the file and finding the right tab and row. That friction is exactly what makes entries pile up.
• It’s awkward on a phone: Spending happens at the register; the spreadsheet lives on a computer. Editing cells on a small screen invites mistakes, and it’s easy to type over a cell that holds a formula.
• Sharing with a partner gets messy: With two people in one file, it isn’t clear who entered what, and emailed copies split into two versions. That matters: a 2012 study by Dew, Britt and Huston in Family Relations found that money arguments between spouses were a stronger predictor of divorce than other disagreements. Shared, up-to-date numbers at least keep the “who spent what” talk about data, not guesses.
• Recurring items are carried by hand: Every new month means copying rent, subscriptions and debt payments, and deleting a plan once it’s paid off.
• Formulas break silently: Inserting a row or selecting a range one cell short changes a total, and the error often goes unnoticed for months.

When to move from a spreadsheet to an app

A spreadsheet is a great way to learn how a budget works. If two or more of these sound familiar, it may be time to try an app:

• You enter spending in a weekend batch instead of the same day.
• The Actual column is half empty by the end of the month.
• Your partner never opens the file, or keeps separate notes.
• Setting up each new month takes longer than reviewing the budget.
• You struggle to see from the sheet when each payment plan ends.

Switching doesn’t mean throwing your template away. The sections and categories stay the same; what changes is where you log and how long it takes. Our guide to choosing a budgeting app covers what to look for.

Keeping the same household budget in Hano

Every section of the template above has a home in Hano: Family Budget Tracker; the difference is that the app keeps the rows and totals for you.

• Income and fixed expenses: Set up paychecks, rent, internet and subscriptions once as monthly recurring transactions, with or without an end date. No new tab each month, and it’s on the free plan.
• Variable expenses: Enter them manually on the free plan. On Pro and Max, type “groceries 84” or “gas 45” to the assistant and the AI works out the amount and category and logs it with today’s date. Receipt scanning and voice entry are part of Pro and Max too.
• Debt payments: Installment tracking is free. On Pro, typing “couch 1560 12 installments” splits the cost across 12 months, and the “Upcoming” filter lists future installments and recurring items so you can see when each plan ends.
• Savings: The savings rate in your insights shows how much of your income went unspent. If you save in gold or foreign currency, you can record purchases in My assets and follow their current value.
• Left over: The end-of-period projection tells you where you’ll land at your current pace, and the iPhone home screen widget shows this month’s net balance.
• Planned vs. actual: Hano doesn’t have per-category budget limits. Keep your planned amounts in a note and compare them mid-month with the category breakdown chart; the 6-month income vs. expense trend puts months side by side. On Max, an AI-analyzed Monthly Report also arrives at the start of every month.

The hardest part of a shared spreadsheet solves itself here: your partner joins the same household with a 6-digit invite code, everyone logs their own spending from their own phone, each entry shows who made it and the numbers sync instantly (two people on Pro, up to six on Max, with a 7-day free trial and no card required). If you prefer a big screen, the same account opens in the web dashboard, and you can export your data as JSON at any time. Download Hano for free and start with the categories from your template; no formulas required.

This guide is general information, not personal financial advice.