Monthly Excel Budget Spreadsheet: Setup and Formulas

Formulas & functions · Updated November 18, 2026

To make a monthly Excel budget spreadsheet, list spending categories in column A, planned amounts in column B, actual amounts in column C, and the difference in column D; use =B2-C2 in D2 and copy it down. Add income and total rows so you can compare what you expected to spend with what you actually spent, then save a fresh copy for each month or reuse one workbook with a separate sheet per month.

What a monthly budget spreadsheet does

A monthly budget is a plan for money coming in and going out during a defined period. In Excel, the spreadsheet can put that plan beside recorded transactions, making it easier to see which costs matched expectations and which did not. It is a tracking tool, not a guarantee that future expenses will match past ones. Irregular bills, changing prices, and one-time purchases can all make a month look different from the next.

A useful sheet answers a few practical questions: How much income do I expect? What do I plan to spend in each category? What did I actually spend? Is there money left after those expenses? Keeping the answers visible is more useful than building a complicated workbook with many calculations you will not maintain.

For example, suppose a sample month has $3,620 in income and $2,735 in listed expenses. The difference is $885 before accounting for any costs not included in the table, savings transfers, debt payments, or other goals. The example is only an illustration; use your own figures and check account records rather than treating a spreadsheet estimate as a financial recommendation.

Choose a layout that is easy to update

Start with a simple expense table. Put category names in A2:A7, planned expenses in B2:B7, actual expenses in C2:C7, and the difference in D2:D7. In this example, the six categories are rent, utilities, groceries, transport, insurance, and dining. Put a total row in row 8. Use consistent units—such as dollars with two decimal places—and enter numbers as values rather than typing currency symbols into the cells.

Here is one illustrative set of planned and actual expenses:

  • Rent: $1,450 planned and $1,450 actual.
  • Utilities: $180 planned and $205 actual.
  • Groceries: $500 planned and $472 actual.
  • Transport: $220 planned and $238 actual.
  • Insurance: $160 planned and $160 actual.
  • Dining: $180 planned and $210 actual.

For income, create a small second table with income sources in F2:F4 and actual amounts in G2:G4. For instance, wages of $3,600, side work of $0, and interest of $20 add to $3,620. You can add a planned-income column if forecasting income is useful, but it is not required to calculate the actual amount left after expenses.

Use plain category names that make sense to you. A single category called “shopping” may conceal very different purchases; splitting it into household supplies and clothing can make review more informative. On the other hand, too many narrow categories make transaction entry tedious. Choose a level of detail you are likely to maintain.

Build the sheet in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, open a blank workbook and enter a title such as “November Budget” near the top. Add headings and data as described above. Select the table headings and values, then use Home > Format as Table if you want a styled table with filter controls. If you use a table, ensure its totals row and formulas include all relevant expense entries. A simple cell range is also perfectly workable for a small monthly budget.

Keep the total row below the last category, and avoid leaving blank rows inside the data. If you add a category later, insert it above the total row or extend the table, then check that the totals include it. A common spreadsheet error is adding a new expense below a total formula’s range and assuming the total updates automatically.

To apply currency formatting, select the amount cells and choose Home > Number, then select a currency or accounting format. The exact currency symbol and available formats depend on regional settings. Formatting changes how a value appears, not the underlying number used in calculations. For negative differences, you can use a number format that shows a minus sign or parentheses, provided it remains clear to you.

On Mac, the same basic cell layout and formulas work. Ribbon labels or their placement can differ slightly between Excel versions, and Excel for the web may arrange commands differently, but the core steps—enter headings, format values, and add formulas—are the same. The instructions here assume Microsoft Excel for Microsoft 365 on Windows unless a difference is noted.

Use formulas to total and compare amounts

With planned amounts in B2:B7 and actual amounts in C2:C7, enter the following in D2 to calculate how much remains in the category’s plan. Copy or fill the formula down through D7. In the utilities example, row 3 has $180 planned and $205 actual, so D3 returns -$25: spending exceeded the plan by $25.

With the expense categories in rows 2 through 7, planned values in B2:B7, and the total row in row 8, enter this in B8. It returns $2,690 for the illustrative planned expenses.

=SUM(B2:B7)

With actual expense values in C2:C7 and their total in C8, enter this in C8. It returns $2,735 for the sample month.

=SUM(C2:C7)

With the planned total in B8 and the actual total in C8, enter this in D8. It returns -$45, indicating that the listed expenses together are $45 above plan. A negative result is not an error; it follows from the chosen convention of planned minus actual.

=B8-C8

With actual income amounts in G2:G4 and the income total in G5, enter this in G5. For the example amounts of $3,600, $0, and $20, it returns $3,620.

=SUM(G2:G4)

With actual income total in G5 and actual expense total in C8, enter this in a clearly labeled cell, such as G7, to calculate the amount left after the listed expenses. It returns $885 for the example: $3,620 minus $2,735. It represents only the categories entered in the workbook, not necessarily a complete account balance or an amount available for discretionary use.

=G5-C8

Set realistic categories and planned amounts

A budget is more useful when planned values reflect the timing and variability of real bills. Fixed costs such as rent may be straightforward to enter, while utilities, groceries, and travel can vary. For a bill that changes, a recent statement or several months of records can provide context for a working estimate. The estimate is still a planning choice, not a prediction with certainty.

Decide how to handle occasional expenses before they arrive. You might create categories for annual subscriptions, vehicle maintenance, gifts, or medical costs and record an amount each month toward them. If you instead enter the full bill only in the month it is paid, that month will show a spike. Neither presentation is inherently wrong; consistency helps you interpret the totals.

Also decide whether savings transfers and debt payments belong in the expense table. If the goal is to see all cash leaving a checking account, include them as categories. If the goal is to compare household consumption costs, you may want to separate them. Label the approach so that a future reader—or you several months later—understands what the total represents.

Review the month without overcomplicating it

At the end of a month, compare actual entries with bank, card, or receipt records. Enter transactions in a consistent way: either record each transaction and summarize it by category, or enter category totals after reconciling records. Do not add both individual transactions and their category totals to the same calculation, because that would count the same spending twice.

Use the difference column as a prompt for review, not as a judgment. A negative amount could reflect a one-time repair, a changed bill, an unrealistic plan, or a data-entry mistake. Check the source transaction and the category before deciding what it means. A category that is regularly over plan may need a revised estimate, a different classification, or a change in spending; the spreadsheet alone cannot determine which explanation applies.

For a quick visual scan, select the difference cells and choose Home > Conditional Formatting > Highlight Cells Rules. You can highlight values below zero to make over-plan categories stand out. Set a rule that matches the sign convention in your sheet, and verify it on a known example. Conditional formatting changes the display, not the underlying calculation.

Keep monthly records and avoid common errors

You can use one sheet per month in a workbook, with consistent category order and column positions. Duplicate a clean template sheet, rename the copy, and update the month label. Alternatively, create a separate workbook each month. A year-to-date summary can be useful, but it should be built only after the monthly layout is stable; otherwise, changed rows or category names can make comparisons unreliable.

Keep a clean template with blank actual amounts, and preserve completed months rather than overwriting them. Save the workbook in a location you can access and back up. If it contains sensitive financial details, use appropriate account and device security, and consider whether storing full account numbers or other identifying details is necessary. A budget generally needs categories and amounts, not login credentials or complete payment-card numbers.

  • Check that amounts are entered as numbers and that formulas cover every category.
  • Confirm that the month’s transactions are not counted twice.
  • Use the same meaning for each category from month to month.
  • Review totals after inserting or deleting rows.
  • Keep an untouched template or backup before making structural changes.

One frequent misconception is that Excel will know whether an expense is “over budget” without being told how to define the comparison. In this layout, planned minus actual means negative values are over plan. If you reverse the subtraction, the signs reverse too. Either method can work, but label the column—for example, “Plan remaining”—and keep the convention consistent.

Excel templates, apps, and other options

Excel includes workbook templates that may help you start faster. On Windows, check File > New and search the available templates for a budget. Template names and availability can vary by Excel version, account, and connected services, so inspect the workbook before entering personal information. Confirm that its categories and formulas suit your needs; a polished design does not guarantee that a calculation matches your preferred definition of income or expenses.

A custom workbook gives you control over categories and layout, while a template reduces setup work. A budgeting app may offer automatic transaction imports or phone-based entry, depending on the product and its permissions, but it can involve account linking, fees, or data-sharing considerations. A bank’s own spending summary may be convenient, though its category rules may not match yours. The best option depends on whether customization, automation, privacy, or simplicity matters most.

Excel for the web can be useful when you want to open a workbook in a browser, while desktop Excel offers a full desktop interface. Availability and features depend on the account and service. If you share a workbook, decide who can view or edit it and avoid putting confidential credentials in cells. For a basic monthly budget, neither macros nor elaborate automation are necessary.

Frequently Asked Questions

Does Excel have a monthly budget spreadsheet template?
Excel may offer budget templates through File > New on Windows. Availability and template names can vary, so check the formulas, categories, and layout before relying on one. You can also create a simple workbook from a blank sheet.

How do I calculate the amount left in my budget?
Subtract actual spending from the planned amount for each category. In the layout above, planned is in column B and actual is in column C, so =B2-C2 gives the remaining amount for row 2. A negative result means actual spending was higher than planned.

Should I make a new Excel sheet for every month?
A separate sheet for each month makes it easy to preserve monthly records when the layout stays consistent. A separate workbook is another option. Either way, keep a blank template and use the same categories if you want comparisons to be meaningful.

Can I use this budget spreadsheet in Excel for the web?
Yes, the basic layout and formulas shown here work in Excel for the web as well as Microsoft 365 desktop Excel. Ribbon placement and some features can differ, but the SUM and subtraction formulas are standard Excel formulas.

Why does my budget total not change when I add a category?
The new row may be outside the range included in the total formula. Check the formula’s cell references and extend the range, or add the category within an Excel Table. Always verify the displayed total after changing the layout.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.