Home Budget Spreadsheet: Build a Clear Monthly Plan

How-to basics · Updated November 21, 2026

A home budget spreadsheet is a worksheet that compares the money you expect to receive with what you plan to spend and what you actually spend. In Excel for Microsoft 365, start with columns for category, planned amount, actual amount, and difference; add monthly income and expense totals so you can see what remains.

What a home budget spreadsheet does

A useful household budget is a working plan, not a record of every financial decision you will ever make. It gives you a consistent place to estimate income and costs, record real transactions, and notice when actual spending differs from the plan. A basic sheet can be enough for a household with steady pay and a manageable number of bills; you do not need a complicated financial model to get a clear monthly picture.

Keep planned and actual amounts in separate columns. If you overwrite the plan with what you spent, you lose the comparison that helps explain whether a month went as expected. You can build one worksheet for each month or reuse a single worksheet by changing the month and clearing only the actual entries. Separate monthly tabs make comparisons convenient, while one reusable tab is simpler to maintain.

A budget spreadsheet does not automatically know what you bought. Unless you connect it to a properly supported import process, you enter or paste transaction totals yourself. That can be a useful prompt to review statements, but it also means the sheet is only as complete as the figures you record.

Set up a simple Excel layout

For a monthly worksheet, put expense categories in column A, planned amounts in B, actual amounts in C, and the difference in D. Use rows 2 through 9 for example expenses and row 10 for total expenses. Put income sources in rows 12 and 13 and their total in row 14. Row 16 can show the amount remaining after expenses. Add the month and year near the top of the sheet, and format money cells as currency using Home > Number.

Here is one illustrative set of expense rows: rent, utilities, groceries, transport, insurance, phone and internet, subscriptions, and eating out. An example plan might allocate $1,450 to rent, $220 to utilities, $600 to groceries, $250 to transport, $180 to insurance, $120 to phone and internet, $40 to subscriptions, and $180 to eating out. Those values are examples only; categories and amounts should reflect the household’s own situation.

For the example, the planned income entries are $4,200 in take-home pay and $200 in other income. The actual income entries are $4,200 and $150. If actual expenses are $1,450, $198, $575, $265, $180, $118, $48, and $160, the worksheet can compare the month’s results with the original plan.

  • Give each category one row, and keep the wording consistent from month to month.
  • Enter amounts as numbers, not text with currency symbols typed into the cell; apply currency formatting instead.
  • Use a clear label such as Total expenses or Money left after expenses for calculated rows.
  • Leave a little space between sections, but avoid merging cells in the middle of tables because merged cells can make sorting and copying harder.

Use formulas to calculate totals and differences

Formulas reduce arithmetic errors and update when you change an entry. With expense categories in A2:A9, planned expenses in B2:B9, actual expenses in C2:C9, and totals in row 10, enter this in B10:

=SUM(B2:B9)

For the illustrative plan, it returns $3,040. With the same expense layout, enter this in C10 to total actual expenses:

=SUM(C2:C9)

It returns $2,994 for the example amounts. In D2, with planned values in column B and actual values in column C, enter the following and copy it down through D9:

=B2-C2

For the rent example, it returns $0 because planned rent and actual rent are both $1,450. A positive result means actual spending is below the plan; a negative result means it is above. That interpretation is useful for expenses, but it may not suit every category, so label the column clearly—for example, Plan minus actual.

With planned income in B12:B13, actual income in C12:C13, and totals in row 14, enter =SUM(B12:B13) in B14; it returns $4,400. Enter =SUM(C12:C13) in C14; it returns $4,350. Finally, with total income in row 14 and total expenses in row 10, enter =B14-B10 in B16 for planned money left, which returns $1,360. In C16, enter =C14-C10 for actual money left, which returns $1,356. These are illustrative arithmetic, not financial, tax, investment, or legal advice; verify loan terms with the lender and seek a qualified professional for advice about your circumstances.

Choose categories that fit your household

Start with categories that make decisions easier rather than copying an elaborate template without considering how you spend. Fixed bills such as rent, a mortgage payment, insurance, or a phone plan are often straightforward to list. Flexible costs such as groceries, household supplies, transport, and meals out may need more attention because they can vary from month to month.

Some people prefer broad categories to keep entry quick; others want enough detail to identify a useful pattern. For example, a single Food category is easy to maintain, while separate Groceries and Restaurants categories can show whether meal spending is changing. Avoid splitting categories so finely that recording purchases becomes a burden. If a category rarely affects a decision, combine it with a suitable broader group.

It can also help to include less frequent costs rather than treating them as surprises. Examples include annual subscriptions, car maintenance, school costs, seasonal utility bills, and gifts. You might list these as separate categories in the monthly plan, or keep a separate section that notes the expected timing and amount. Do not count the same expense in both places when calculating the monthly total.

Build a routine for recording actual spending

A spreadsheet is most helpful when you update it regularly. Choose a routine that fits how you manage money: a brief weekly review, an update after payday, or a month-end check against account statements. Enter totals in a consistent way. If you use statement totals, decide whether the budget tracks purchases by transaction date or by the date money leaves the account, especially for credit-card purchases, so expenses are not counted twice.

At the end of the month, compare the plan with actual spending and investigate the largest differences. A variance is information, not automatically a failure. A higher utility bill may reflect weather or a billing-cycle change; a grocery total may be unusually high because of guests or a bulk purchase. Note one-off explanations so you do not assume the same amount will recur every month. If a cost is likely to continue, update a future plan rather than silently changing the completed month’s figures.

For organization in Excel, select the category and amount range and use Home > Format as Table if you want a formatted, expandable table. Avoid including the total row inside the table if you plan to add categories to its bottom. You can also use Home > Conditional Formatting > Highlight Cells Rules to flag negative differences, but a clear number and label are often enough. These ribbon paths are for Excel for Microsoft 365 on Windows; the ribbon is similar in Excel for Mac, although layout and shortcut details can differ.

Common spreadsheet mistakes and privacy considerations

One frequent problem is mixing planned amounts, actual transactions, and transfers between accounts. A transfer from checking to savings moves money but is not necessarily household consumption. Decide whether your sheet is tracking cash flow, spending, or both, then label transfers accordingly. Another mistake is entering take-home pay in one month and gross pay in another; use a consistent income basis so the comparison remains meaningful.

Check that formulas include every relevant row. If you add a category below row 9 but the total still uses B2:B9, the new amount will be omitted. Expand the range or place new categories within the existing range. Also check for blank cells that should have amounts, numbers stored as text, and duplicated transactions. A total that looks plausible can still be wrong if one expense was missed or recorded twice.

Protect personal information. A budget usually does not need full bank account numbers, card numbers, passwords, or security answers. If the workbook is stored in a shared folder or cloud service, review who can access it and use the account’s available security controls. A password on a file is not a reason to put credentials or sensitive account details into the sheet. Keep a backup if the workbook is important, and be cautious about emailing copies that contain private household details.

Spreadsheet or budgeting app?

A spreadsheet offers flexibility: you control categories, layout, formulas, and how much detail to record. It can be a good fit if you like reviewing numbers manually, need a custom format, or want a simple plan without linking financial accounts. Its trade-off is maintenance. You must enter figures, check formulas, and manage copies or monthly tabs yourself.

A budgeting app may automate transaction imports or offer alerts, but features, costs, account coverage, and data practices vary by provider. Automatic categorization can also mislabel transactions, so imported data may still need review. A bank’s own spending summary can be convenient, though its categories and reporting period may not match the budget you want. Compare the amount of manual work, privacy implications, export options, and any fees before choosing; no one format is best for every household.

Frequently Asked Questions

What should a home budget spreadsheet include?
At minimum, include the month, income sources, expense categories, planned amounts, actual amounts, totals, and a calculation of what remains. Add savings goals or irregular costs if they are useful to your household, and keep categories manageable.

Can Excel make a monthly budget automatically?
Excel can calculate totals and differences when you enter formulas, but it does not automatically know all of your income or purchases in a basic workbook. Transaction imports depend on separate services or processes and should be reviewed for omissions and incorrect categories.

Should savings be an expense in a budget?
It depends on what you want the sheet to show. You can list a planned savings contribution as a budget line to reserve that amount, while keeping it distinct from household consumption. Be consistent so you do not count a transfer as both spending and savings.

How often should I update a home budget spreadsheet?
Update it often enough that you can remember or verify transactions and respond to changes. Weekly or payday updates work for many people; a monthly review is still useful for checking totals and adjusting future estimates.

Is a spreadsheet better than a budgeting app?
Neither is universally better. A spreadsheet gives you control and can work without linking accounts, but requires manual upkeep. An app may import transactions and provide alerts, but its cost, account support, privacy practices, and categorization accuracy vary.

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.