Household Budget Spreadsheet: Build One in Excel

How-to basics · Updated November 21, 2026

A household budget spreadsheet is a simple way to compare monthly income with planned and actual expenses. In Excel for Microsoft 365 on Windows, make one by listing income and spending categories, recording planned and actual amounts, and using a few SUM formulas to calculate totals and what remains.

What a household budget spreadsheet does

A budget spreadsheet puts recurring income and expenses in one place so you can see how a month is expected to work and how it actually went. It is not a bank account, and it does not automatically make spending decisions for you. Its value is that it makes assumptions visible: housing may be fixed, groceries may vary, and an annual bill may need to be planned for before it arrives.

A useful sheet answers three practical questions: How much money is expected to come in? Where is it expected to go? How different were the plan and the actual amounts? Keeping those questions separate helps avoid a common misunderstanding: a budget is not only a list of bills. It can also include flexible purchases, savings transfers, irregular costs, and a line for money that has not yet been assigned.

Use one period consistently. A monthly budget is convenient for many household bills, but weekly or fortnightly pay does not have to be converted into a fictional monthly paycheck. Record income when it is expected to arrive, or use an average monthly figure and clearly label it as an estimate. The best choice depends on whether the sheet is for long-range planning or for managing cash between paydays.

Choose a layout that is easy to maintain

Start with a single worksheet named Monthly Budget. Put the month and year near the top, then make an income table and an expense table. For the expense table, use columns for category, planned amount, actual amount, and remaining. A positive remaining amount means the actual amount is below the plan; a negative amount means it exceeded the plan.

Keep categories specific enough to be useful, but not so numerous that updating the sheet becomes a chore. A reasonable starting set might include:

  • Income: wages, self-employment income, benefits, or other regular sources.
  • Fixed costs: housing, insurance, debt payments, and recurring service bills.
  • Variable costs: groceries, transport, household supplies, and personal spending.
  • Irregular costs: annual fees, school expenses, repairs, gifts, and medical costs.
  • Goals or allocations: savings transfers or other amounts set aside for a purpose.

Households differ, so rename or combine categories to fit actual statements and spending habits. If two people share expenses, add a payer or account column only if that information will help reconcile the numbers. Avoid storing account numbers, passwords, or other sensitive credentials in the workbook.

Build the sheet step by step

  1. Open a blank workbook in Excel for Microsoft 365 on Windows and rename the first worksheet Monthly Budget.
  2. Enter the month at the top. In the income area, put category names in A2:A5 and corresponding planned or expected amounts in B2:B5. Reserve row 6 for the total.
  3. Start the expense table around row 10. Put category names in A10:A20, planned amounts in B10:B20, actual amounts in C10:C20, and remaining amounts in D10:D20. Use row 21 for totals.
  4. Format the amount columns as currency using Home > Number. The exact currency symbol and decimal display depend on the workbook’s regional settings; make sure the displayed currency matches the household’s records.
  5. Enter the formulas described below, then save the workbook with a clear name and make a new copy for each month or duplicate the worksheet before entering a new period.

In Excel for Mac, the workbook structure and formulas are the same. Ribbon labels and the placement of commands can differ slightly by version, so use the Home tab and its number-format controls if the Windows path does not match exactly. Excel for the web also supports ordinary worksheet formulas, though some commands and layout options are arranged differently.

Use formulas to calculate totals and balances

For the following examples, the income categories occupy A2:A5, the amounts occupy B2:B5, and row 6 is the total. With 4,200 in B2, 600 in B3, 250 in B4, and 150 in B5, enter this in B6:

=SUM(B2:B5)

The result is 5,200. SUM adds the values in the specified range, so it updates when an amount changes. The example is illustrative rather than a recommended income figure.

For the expense table, assume A10:A20 contains category names, B10:B20 planned amounts, C10:C20 actual amounts, and D10:D20 the difference. With Housing in row 10, a planned amount of 1,700 in B10, and an actual amount of 1,700 in C10, enter this in D10 and fill it down through D20:

=B10-C10

The result in D10 is 0. If actual spending is 690 against a planned 650, the same row calculation returns -40, indicating the category is 40 over plan. To copy the formula down in Excel for Windows, select D10 and drag its fill handle down to D20; Excel adjusts the row references.

Assuming planned expenses are in B10:B20 and row 21 is their total, enter this in B21:

=SUM(B10:B20)

With the sample planned amounts in this article—1,700, 250, 650, 400, 220, 120, 100, 300, 70, 250, and 500—the result is 4,560. Assuming actual expenses are in C10:C20 and C21 is their total, enter this in C21:

=SUM(C10:C20)

Using actual amounts of 1,700, 235, 690, 370, 220, 115, 80, 300, 65, 275, and 500, the result is 4,550. With B21 holding planned expenses and C21 holding actual expenses, enter this in D21 to show the overall difference:

=B21-C21

The result is 10: total actual allocations are 10 below the total planned. This does not mean the household has only 10 left over; it compares actual and planned expense totals.

To calculate money remaining after the listed actual allocations, assume B6 contains total income and C21 contains actual expenses. Enter this in a separate summary cell:

=B6-C21

With income of 5,200 and actual allocations of 4,550, the result is 650. If the expense list includes a savings transfer, that transfer is counted as an allocation, not as money still available in the checking account. Decide whether the sheet is tracking cash flow, spending, or both, and label the total so the meaning stays clear.

Work through a realistic monthly example

Suppose a household expects 5,200 in monthly income and plans 4,560 across the expense categories. The plan leaves 640 not assigned to those categories. During the month, groceries come to 690 rather than 650, while utilities are 235 rather than 250. Those two categories together are 25 over their combined plan: groceries are 40 over and utilities are 15 under.

Across all the example categories, actual allocations total 4,550, which is 10 below the 4,560 plan. Subtracting those allocations from the 5,200 income gives 650. This example illustrates why a category-level difference and the month’s remaining amount answer different questions. A category can be over budget even while total allocations remain under the overall plan.

For irregular expenses, estimate a monthly amount and record the eventual bill when it is paid, or keep a separate sinking-fund line for money set aside. Do not count the same cost twice: if a car repair is paid from money previously set aside, the budget should distinguish the transfer into the reserve from the later payment, or it may make the expense appear twice.

Make the spreadsheet easier to review

Use simple formatting to make exceptions visible without turning the workbook into a dashboard project. Freeze or emphasize the header row, use consistent currency formatting, and bold the total rows. In Excel for Windows, select D10:D20 and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter 0 to highlight negative remaining amounts. This makes overspending easier to scan, but the color is only a visual aid; the values and labels should still make sense without it.

Review the sheet on a regular schedule that matches how the household handles money. Updating actual amounts once a week may help catch a missed bill or duplicate entry while there is still time to adjust discretionary spending. If updates are made only at month end, the spreadsheet is more useful for reviewing patterns than for managing the current month.

At month end, compare the totals with bank or card statements and investigate differences rather than forcing the sheet to match by changing figures without explanation. A transaction may have cleared in a different month, a refund may be missing, or a recurring charge may have changed. A notes column can preserve context, such as a one-time repair, without changing the basic categories.

Common problems and useful safeguards

  • Mixing periods: Do not compare a partial month of actual expenses with a full-month plan without labeling the difference. Keep the period visible and consistent.
  • Missing irregular bills: Annual renewals and occasional repairs can make a month look unexpectedly expensive. List known nonmonthly costs and decide how the sheet will represent them.
  • Double-counting transfers: Moving money between two household accounts is not automatically new income or a new expense. Record it according to the purpose of the spreadsheet, and avoid counting both the transfer and the later purchase as separate consumption.
  • Typing over formulas: Keep formulas in total and difference cells, and enter transactions only in designated input cells. If a total stops updating, check that the formula remains in the cell and that amounts are numeric rather than text.
  • Overcomplicated categories: Too many small categories can slow updates and make patterns hard to see. Combine categories that do not support a useful decision, and split them later if the records show a meaningful reason.

A spreadsheet is not automatically synchronized with financial accounts. If you import transactions, review the imported data and protect the workbook appropriately. Avoid emailing an unprotected file containing private financial details, especially when it includes account identifiers or information about other household members.

Spreadsheet, app, or paper budget?

An Excel workbook suits people who want flexible categories, transparent calculations, and a record they can adapt. It can work offline, and ordinary formulas do not require a subscription beyond access to Excel itself; Microsoft 365 licensing and available features depend on the user’s plan. A workbook can also be shared, but multiple copies may lead to conflicting updates unless the household agrees which file is current.

Budgeting apps may connect to financial accounts and categorize transactions automatically, depending on the provider and institution. That can reduce manual entry, but it introduces decisions about data access, account compatibility, fees, and the provider’s privacy practices. A paper budget or a basic notes document can be enough for someone who wants a short list of totals and does not need automatic calculations.

There is no requirement to use a particular method. A practical test is whether the household can keep the chosen method up to date and understand what its totals mean. Check the terms of any financial product or account directly with the relevant provider, and consult a qualified professional for personal financial, tax, investment, or legal questions; this spreadsheet example is for organization and arithmetic, not individualized advice.

Frequently Asked Questions

What should a household budget spreadsheet include?
Include the budget period, income sources, spending categories, planned amounts, actual amounts, and totals. Add irregular costs, savings allocations, or notes where they are relevant, and label whether a total represents spending, transfers, or cash remaining.

How do I make a simple household budget in Excel?
Create an income list and an expense table with planned and actual columns. Add SUM formulas for the totals and subtract actual from planned to show each category’s remaining amount. Start with a few useful categories and refine them after reviewing real transactions.

Should savings be listed as an expense?
It depends on what the spreadsheet is measuring. If it tracks where monthly income is allocated, a savings transfer can be listed as an allocation. If it tracks consumption spending, show savings separately so it is not mistaken for a purchase. Label the treatment consistently.

How often should I update a household budget spreadsheet?
Update it often enough that the numbers remain useful; weekly is a workable routine for many people, while others prefer to enter transactions as they occur. Reconcile the month’s figures against statements before using them to make decisions.

Can I use the same spreadsheet every month?
Yes. You can duplicate the worksheet or save a fresh copy for each month. Preserve a clean template, update the period and planned figures, and avoid replacing formulas with typed values when copying or clearing input cells.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.