Monthly Excel Budget Format: Build a Simple Template

How-to basics · Updated November 18, 2026

A useful monthly Excel budget format puts each income source and expense category on its own row, with columns for the budgeted amount, actual amount, and difference. Add totals for income and expenses, then subtract expenses from income to see the planned and actual amount left for the month.

A simple monthly budget layout

In Excel for Microsoft 365 on Windows, create a worksheet with the following structure. Put the month in a visible heading, such as January 2026, and use the same currency throughout the sheet.

  • A3:D3: Category, Budgeted, Actual, Difference (Actual − Budget).
  • A4: Income heading; list income sources in A5:A6, such as Salary and Other income. Put Total income in A7.
  • A9: Expenses heading; list categories in A10:A18, such as Housing, Utilities, Groceries, Transport, Insurance, Debt payments, Savings, Personal, and Other. Put Total expenses in A19.
  • A21: Amount left after expenses.

Enter planned figures in column B and amounts received or spent in column C. Column D shows how actual results differ from the plan. This layout works for a household, an individual, or a small project; rename categories to match the purpose rather than forcing every transaction into an ill-fitting label.

Build the worksheet step by step

  1. Open a blank workbook and rename Sheet1 to the month or period you are tracking.
  2. Enter the headings and category names in the cells described above. Keep the category names in column A and numeric amounts in B and C.
  3. Enter your best estimate for each category in Budgeted before the month begins. Leave Actual blank until you have a figure, or enter zero if you want the totals to include an explicit zero.
  4. Add the formulas in the totals and difference cells. Format the amount columns as currency or accounting values so that amounts are easy to scan.
  5. Compare the remaining balance with your plan during the month and update actual amounts as new information arrives.

Use one row per category rather than putting several categories into one cell. That makes totals, comparisons, and later changes easier. Avoid typing currency symbols directly into numbers; apply a number format instead, so Excel can still calculate with the values.

Formulas for totals and the amount remaining

In the layout above, row 7 totals the two income rows. With income amounts in B5:B6, enter this in B7:

=SUM(B5:B6)

With actual income in C5:C6, enter this in C7:

=SUM(C5:C6)

In the same layout, row 19 totals expense categories 10 through 18. With planned expenses in B10:B18, enter this in B19:

=SUM(B10:B18)

With actual expenses in C10:C18, enter this in C19:

=SUM(C10:C18)

For each category, use Actual minus Budget as the difference. With budgeted amounts in B10:B18 and actual amounts in C10:C18, enter this in D10 and copy it down through D18:

=C10-B10

A positive difference on an expense row means spending exceeded the budget; a negative difference means spending was below budget. For income rows, the interpretation reverses in practical terms: a positive difference means actual income was higher than planned. This is why the column heading should say what the calculation means, rather than simply calling it “good” or “bad.”

To calculate the planned amount left, with total income in B7 and total expenses in B19, enter this in B21:

=B7-B19

With actual income in C7 and actual expenses in C19, enter this in C21:

=C7-C19

To compare the actual remaining amount with the planned remaining amount, with those results in B21 and C21, enter this in D21:

=C21-B21

For a check on the arithmetic, suppose planned income is $4,200 and planned expenses total $3,630. The planned amount left is $570. If actual income is $4,100 and actual expenses total $3,655, the actual amount left is $445. The difference in D21 is −$125, because $445 minus $570 equals −$125. The example is illustrative, not a recommendation about how much to spend or save.

Choose categories that fit your money

A useful budget is detailed enough to guide decisions but not so detailed that maintaining it becomes a chore. Start with broad categories you can recognize from bank or card records. If Groceries regularly combines food and household supplies but you need to track them separately, split it into two rows. If you never make decisions based on a category, consider combining it with a related one.

  • Income: record take-home pay or another consistent basis. If you budget with gross pay, account separately for deductions so the comparison is meaningful.
  • Fixed bills: include rent or mortgage payments, insurance, subscriptions, and other recurring commitments.
  • Variable spending: include categories such as food, transportation, and personal spending, where monthly totals can change.
  • Irregular costs: consider a monthly allowance for annual or occasional bills, such as a yearly membership or vehicle registration. Divide an expected annual amount by 12 to create a planning estimate, then adjust it when the real bill is known.

Decide how to treat savings and debt carefully. If Savings is listed as an expense or allocation, the remaining-balance figure means money left after that planned transfer. For credit cards, avoid counting the same purchase twice: either record purchases in their spending categories and treat the card payment as settling the balance, or use another consistent method that does not add both the purchase and payment as separate expenses.

Make the sheet readable and useful

Format columns B:D as currency or a suitable number format. Select the amount cells, then use Home > Number to choose a format; the exact controls can vary with the ribbon layout. Use bold formatting for total rows and a distinct fill for headings, but keep the sheet readable in grayscale or when printed. Widen column A so category names are visible.

You can highlight overspending in the expense difference column. Select D10:D18, then choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than and enter 0. This marks positive differences in the example’s Actual minus Budget convention. Check that the rule applies only to the expense rows; positive income differences are not overspending. If you change the difference convention, adjust the rule too.

Keep formulas separate from manual entries. In this layout, formulas belong in B7, C7, B19, C19, D10:D18, and B21:D21; most other amount cells are inputs. A simple visual distinction, such as a pale fill for input cells, can help prevent accidental overwriting. Consider saving a blank copy as a reusable template before entering the next month.

Track actuals and handle changing plans

Actual figures can come from bank statements, receipts, or a transaction export, but reconcile them consistently. A budget is only as useful as its inputs: an unrecorded cash purchase or a refund entered as new income can distort a category. Decide whether to record transactions when they occur or review them in batches, and use the same approach each month.

If a bill changes during the month, update the actual column rather than silently changing the original budget. Keeping the original plan makes the difference informative. If your plan itself changes, you can revise the budgeted amount, but note why or keep a separate copy of the original plan if you want to compare against it later. For variable or irregular income, avoid treating an uncertain estimate as guaranteed cash; a separate conservative planning figure can make the sheet easier to interpret.

For several months, you can duplicate the worksheet and change the month heading, or create one transaction table with a date and category for each entry and summarize it by month. Separate tabs are straightforward for a personal budget, while a transaction list can be more flexible when you want to filter or review spending over time. Pick the method you will actually maintain.

Common spreadsheet mistakes

  • Entering numbers as text: pasted values with symbols or unexpected spaces may not add correctly. Use numeric values and apply formatting in Excel.
  • Including a total in its own sum: the expense total should sum category rows 10:18, not row 19 itself. Otherwise, a circular reference can result.
  • Mixing time periods: compare a full month of actual spending with a monthly budget, and identify annual or one-time bills rather than treating them as ordinary monthly amounts.
  • Confusing a low balance with a budget surplus: the sheet’s result depends on which accounts and transactions you include. It is a planning calculation, not a live bank balance.
  • Overwriting formulas: if a total stops updating, select the cell and check whether its formula has been replaced by a typed value.

Review the category totals against your source records if a result looks surprising. For a cell that should contain a formula, the formula bar can show whether it still contains one. Also check that the relevant input cells are numeric and that no category was left outside the sum range.

Frequently Asked Questions

How do I create a monthly budget spreadsheet in Excel?
Set up rows for income and expense categories, then add Budgeted, Actual, and Difference columns. Sum income and expenses separately and subtract expenses from income to show the planned and actual amount left.

What formula subtracts expenses from income in Excel?
If actual income is in C7 and actual expenses are in C19, enter =C7-C19 in C21. In the example, that returns $445 when C7 is $4,100 and C19 is $3,655.

Should savings count as an expense in a monthly budget?
It depends on what you want the remaining-balance figure to mean. Treating a planned savings transfer as an expense shows what remains after that allocation; leaving it out shows money remaining before savings are set aside. Use one approach consistently.

Can I use the same Excel budget template every month?
Yes. Keep a clean copy, duplicate the sheet for a new month, and update the month heading and planned amounts as needed. Preserve prior months if you want to review how estimates compared with actual results.

Is an Excel budget better than a budgeting app?
Excel offers flexible categories and transparent formulas, but you must enter or import and check the figures yourself. An app may automate some account connections or categorization, depending on its features and terms. Choose based on the level of automation, control, and maintenance you want.

When to use a different format

A basic monthly worksheet is a good starting point when you want a clear plan and a few totals. If you need to analyze many transactions, use a separate transaction log with columns for date, description, category, and amount, then summarize those records by month. If multiple people need to edit the file at once, a shared workbook or a budgeting tool may be more convenient, but consider access permissions and how financial information is stored.

Whatever format you choose, treat the spreadsheet as an organizing tool rather than a guarantee of future results. Verify important figures against statements and actual bill terms. Budgeting choices can have financial consequences, so seek advice from a qualified professional when you need guidance specific to your circumstances.

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.