Spreadsheet Budget: Build a Monthly Plan in Excel

How-to basics · Updated November 21, 2026

A useful spreadsheet budget is a simple list of monthly income and spending, with formulas that total planned and actual amounts. In Excel for Microsoft 365, enter take-home income in one cell, list expense categories in a table, and use =SUM(B5:B13) to total planned expenses; subtract that total from income to see what the plan leaves unallocated.

What a spreadsheet budget does

A budget spreadsheet organizes the money you expect to receive and the money you plan to assign to bills, everyday spending, savings, and other goals. It does not predict the future or change your bank balance automatically. Its value is that it makes assumptions visible: you can see whether the amounts you have allocated add up to more or less than your take-home income, then compare the plan with what actually happens.

For a monthly budget, use income after deductions as the starting amount if you want to plan from the money available to spend. A sample might use $4,000 in monthly take-home pay. If you budget from gross pay instead, taxes and payroll deductions need to be represented too; otherwise, the sheet can make available cash look higher than it is.

There is no single required template. A small sheet with a handful of categories can be easier to maintain than a complicated workbook. The right amount of detail depends on what you want to understand. Separate categories when doing so helps you make decisions; combine them when extra rows would only create more work.

Set up the worksheet

Start a blank workbook in Excel for Microsoft 365 on Windows. In cell A1, enter a title such as “Monthly Budget.” Put the label “Take-home income” in A2 and the illustrative amount 4000 in B2. Then create the spending table beginning in row 4. Use these column headings:

  • A: Category
  • B: Planned
  • C: Actual
  • D: Left in category

Enter the categories in A5:A13: Rent, Utilities, Groceries, Transport, Insurance, Subscriptions, Dining, Savings, and Debt payment. Put the planned figures in B5:B13: 1300, 220, 500, 260, 180, 60, 250, 500, and 300. These are invented example amounts, not recommended spending levels. The planned categories add up to $3,570.

Turn the category range into an Excel table by selecting A4:D13 and choosing Insert > Table. Confirm that the table has headers. Tables make it easier to filter or sort rows and help keep formatting consistent as the list changes. You can also use ordinary cells; the formulas below work either way. Format money cells using Home > Number and select a currency or accounting format that suits the workbook.

Enter formulas and check the example

Enter actual spending in column C as the month progresses. For this example, use 1300 for rent, 235 for utilities, 530 for groceries, 245 for transport, 180 for insurance, 60 for subscriptions, 280 for dining, 500 for savings, and 300 for the debt payment. These actual figures total $3,630. Savings is included as an allocation in this example, so the leftover amount means income remaining after all nine listed allocations, including savings.

With planned amounts in B5:B13 and actual amounts in C5:C13, enter this in D5 to show the difference for the first category: =B5-C5. For rent, the result is 0 because planned and actual spending are both $1,300. Copy the formula down through D13; Excel adjusts the row references for each category. A positive result means some of that category’s planned amount remains, while a negative result means actual spending exceeded the plan.

With planned expenses in B5:B13, put this formula in B14 to total them: =SUM(B5:B13). The result is $3,570. With actual expenses in C5:C13, enter this in C14: =SUM(C5:C13). The example returns $3,630. These two totals let you compare the plan with the month’s recorded amounts.

With take-home income in B2 and planned expenses totaled in B14, enter this in B15 to calculate the planned amount not assigned to the listed categories: =B2-B14. It returns $430 from $4,000 minus $3,570. With the same income in B2 and actual expenses totaled in C14, enter this in C15 to calculate the amount remaining after actual allocations: =B2-C14. It returns $370 from $4,000 minus $3,630. Label row 14 “Total expenses” and row 15 “Income remaining” so the outputs are easy to interpret.

Choose categories that fit your spending

Category design affects whether the spreadsheet is useful. Begin with the expenses you need to track, and avoid using vague labels for everything. “Household” might conceal whether the money went to groceries, cleaning supplies, or a repair. On the other hand, splitting every small purchase into its own row can make data entry tedious.

  • Fixed or recurring costs: rent or mortgage, insurance, regular subscriptions, and scheduled debt payments.
  • Variable essentials: groceries, utilities, transport, and household supplies.
  • Flexible spending: dining, entertainment, clothing, or hobbies.
  • Planned allocations: savings, annual bills, or other amounts you set aside for a purpose.

Some people separate savings from expenses; others treat it as money assigned before calculating what is left. Either approach can work, but keep the definition consistent. If savings is excluded from the expense total, the “income remaining” figure will include that money. If it is included as in the example, the remaining figure is after the savings allocation.

Track actuals without making the sheet burdensome

Choose a routine for updating actual amounts. You might enter transactions weekly, or record totals at the end of each month from bank and card statements. The spreadsheet will only be as useful as the information entered, but it does not need to reproduce every feature of a financial app. A monthly category total is enough for a basic plan-and-compare worksheet.

Decide how to handle one-off costs before they appear. For example, if an annual insurance bill is due once a year, you can record the full payment in the month it is paid, or include a monthly amount in a separate set-aside category. The first method reflects cash leaving the account that month; the second helps show the amount you intend to reserve over time. Label the method clearly so a later reader understands what the figures mean.

Keep planned and actual figures separate. Replacing a planned amount with the actual amount destroys the comparison the sheet is meant to provide. If you revise the plan during the month, consider preserving the original plan in another column or noting the date of the change. That way, the difference between the original expectation and actual spending remains understandable.

Make the results easier to read

Formatting should clarify the figures rather than decorate the workbook. Bold the header and total rows, use a consistent number format, and widen column A so category names are readable. You can freeze the header row if the list becomes long, using View > Freeze Panes in Excel for Windows. Keep labels beside totals; a number without a clear description is easy to misread.

Conditional formatting can draw attention to categories that are over plan. Select D5:D13, then choose Home > Conditional Formatting > Highlight Cells Rules > Less Than and enter 0 to highlight negative differences. The exact color is a preference, not a change to the calculation. If you add conditional formatting, check that it still applies to new rows when the table grows.

For a quick visual overview, you could make a chart from category names and actual amounts. Select the relevant labels and values, then use Insert and choose a suitable chart type. A chart is optional: with only a few categories, the table may communicate the comparison more clearly. Avoid making a chart from both planned and actual amounts unless its legend and labels make the two series easy to distinguish.

Common spreadsheet budget problems

  • Amounts are stored as text: A value pasted with an unexpected symbol or leading apostrophe may not sum as expected. Check the cell contents and apply a number format after entering numeric values.
  • The total range misses a row: If a new category is outside the formula’s range, it will not be included. Review the range when adding rows; an Excel table can help extend structured data.
  • Income is counted twice: Use either the net amount deposited or a clearly itemized gross-pay calculation, not both as available income.
  • Transfers are mistaken for spending: Moving money between your own accounts is not necessarily a purchase. Decide whether the budget tracks cash leaving one account or spending by purpose, and apply that rule consistently.
  • Negative remaining amounts seem confusing: A negative result means the listed allocations exceed the income amount entered. It is a signal to review the inputs or assumptions, not proof that a formula is broken.

Before relying on a total, spot-check it by adding a few figures independently and confirm the formula bar shows the expected cell range. If a figure looks wrong, inspect both the source values and the formula rather than changing the displayed result manually.

Privacy, sharing, and backup

A budget may contain sensitive information, including income, account details, recurring bills, or debt balances. Avoid putting full account numbers, passwords, or authentication details in the workbook. Store it somewhere appropriate for your own privacy needs, and be cautious about emailing or sharing a file that contains personal data. If you use cloud storage, review who can access the file.

Keep an unaltered copy before making substantial structural changes, and use a clear file name or date to distinguish months. Excel’s version history may help with files stored in supported cloud locations, but it is not a reason to skip sensible backups. A basic budget usually does not need macros, external data connections, or complex automation; simpler workbooks are easier to inspect and maintain.

When to use a template or another tool

A blank workbook gives you control over categories and calculations. An Excel budget template can save setup time, but inspect its formulas, categories, and assumptions before entering personal information. Templates can use a different definition of income remaining, include annual totals, or separate savings from spending. Confirm that the result matches the way you intend to use the sheet.

A spreadsheet is a good fit when you want to customize categories, see formulas, or keep a compact monthly record. A budgeting app may be more convenient if automatic transaction imports, shared household access, or alerts are important to you, but those features depend on the particular service. You can also use a bank’s own spending summaries for a quick overview. No tool removes the need to check that transactions and categories are complete.

Frequently Asked Questions

What is the easiest way to make a budget spreadsheet?
List take-home income, create rows for spending categories, enter planned amounts, and total them with SUM. Add actual amounts as the month goes on and compare them with the plan. Start with a small number of meaningful categories, then add detail only if it helps answer a real question.

What formula calculates money left in a budget?
Subtract total expenses from take-home income. In the example above, income is in B2 and actual expenses are totaled in C14, so =B2-C14 returns $370. Confirm that the expense total includes the categories you intend to count, including or excluding savings consistently.

Should savings be listed as an expense in a budget spreadsheet?
It depends on what you want the remaining figure to mean. Include savings as an allocation if you want the leftover amount to be what remains after setting it aside. Exclude it if you want the figure to show money left before that allocation. Label the total clearly either way.

How often should I update a spreadsheet budget?
Update it often enough that you can keep the actual figures accurate. Weekly entry suits people who want a current view; a monthly review may be simpler if category totals are all that matter. Pick a schedule you can maintain and reconcile the recorded totals with statements or receipts.

Can Excel automatically make a monthly budget?
Excel can total, compare, format, and chart figures you enter, and templates can provide a ready-made layout. It will not know your complete income, bills, or purchases unless you supply or connect that data. Review any imported transactions and formulas rather than assuming the workbook is complete.

Use the spreadsheet as a clear record

A practical budget spreadsheet does not have to be elaborate. Separate planned and actual figures, make the income and expense totals explicit, and choose categories that reflect the questions you want to answer. The sample shows how a $4,000 income and $3,630 in actual allocations produce $370 remaining under the stated method. Treat the numbers as an illustration, not a personal recommendation. For questions about loan terms or other financial decisions, check the actual terms with the lender or consult a qualified professional; this spreadsheet example is for organization, not financial, tax, investment, or legal advice.

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.