A basic Excel budget template needs four columns: category, planned amount, actual amount, and the difference. Add income and expense totals with SUM, then subtract expenses from income to see what remains. You can build this simple monthly budget in a blank Excel for Microsoft 365 workbook by entering the layout and formulas below.
What a basic budget template includes
A useful starter budget separates the money you expect to receive from the money you plan to spend. It also lets you compare your plan with what actually happened. That comparison is the main reason to record both planned and actual amounts instead of keeping only a list of bills.
Set up four columns in a worksheet:
- Category: The source of income or type of spending.
- Planned: Your estimate for the month.
- Actual: The amount received or spent.
- Difference: How actual results compare with the plan.
For a clear first version, use separate sections for income and expenses. Include a final line for the amount left after expenses. A budget is a planning tool, not a record of every detail of your financial life; it should be simple enough that you will update it regularly.
Build the worksheet layout
Open a blank workbook and enter the month in cell A1, such as November 2026. Put the column headings in A3:D3: Category, Planned, Actual, and Difference. Start income categories in rows 4 and 5, and use row 6 for Total income. Leave row 7 blank to make the sections easier to scan.
Use rows 8 through 15 for expense categories and row 16 for Total expenses. Row 17 can be your Net amount, meaning income minus expenses. For example, your labels might be Paycheck and Other income, followed by Housing, Utilities, Groceries, Transport, Insurance, Debt payments, Savings, and Personal spending. Adjust the categories to match your situation rather than forcing your spending into labels that do not fit.
Enter amounts as numbers, not text. For example, type 1500 rather than including a currency symbol manually; apply a currency number format afterward. Leave the actual column blank or enter 0 until you have a real amount to record. A blank cell is not the same as a confirmed zero, so choose one approach and use it consistently when reviewing the month.
Add totals and comparison formulas
Assume the headings are in row 3, income items are in rows 4 and 5, total income is in row 6, expenses are in rows 8 through 15, total expenses are in row 16, and net amount is in row 17. In this example, planned income is 4,000 and 200, while actual income is 4,000 and 150. Planned expenses, in order, are 1,500, 250, 500, 300, 200, 300, 400, and 250. Actual expenses are 1,500, 230, 540, 280, 200, 300, 400, and 220.
With the planned income figures in B4:B5, enter this in B6:
=SUM(B4:B5)
The result is 4,200. With actual income in C4:C5, enter this in C6:
=SUM(C4:C5)
The result is 4,150. These totals update when you change either income entry.
With planned expenses in B8:B15, enter this in B16:
=SUM(B8:B15)
The result is 3,700. With actual expenses in C8:C15, enter this in C16:
=SUM(C8:C15)
The result is 3,670. The total includes every row from 8 through 15, so if you add a category below row 15, expand the formula range to include it.
For expense rows, define Difference as planned minus actual. With Groceries in row 10, planned spending in B10, and actual spending in C10, enter this in D10:
=B10-C10
The result is -40 because actual grocery spending of 540 is 40 greater than the planned 500. Enter the same row-relative pattern in D8 and fill it down through D15; Excel adjusts the row references for each category. A positive result means you spent less than planned for that item, while a negative result means you spent more.
For the net amount, use planned income minus planned expenses. With totals in B6 and B16, enter this in B17:
=B6-B16
The planned net amount is 500. With actual totals in C6 and C16, enter this in C17:
=C6-C16
The actual net amount is 480. If you want the Difference cell on the net row to show actual net minus planned net, and those values are in B17 and C17, enter this in D17:
=C17-B17
The result is -20: the actual amount left is 20 less than planned. This net-row convention differs from the expense-row convention, so label the column clearly or add a note. Another option is to label D as Variance and explain the sign convention near the top of the sheet.
Choose categories that are useful
Categories should be detailed enough to reveal patterns but not so numerous that updating the sheet becomes a chore. A first budget can use broad groups, then split a group only when the extra detail would help you make a decision. For instance, you might initially track all food spending in one row, then separate groceries and restaurant meals if those amounts are important to your planning.
Keep different kinds of outflow distinct where it helps you understand the plan. A monthly utility bill is not the same as a once-a-year payment, and putting irregular costs in a separate category can make them easier to anticipate. You can also list savings as a planned use of income if that reflects how you want to allocate money. The worksheet will still calculate the remaining amount, but savings will be included among the planned outflows.
Use categories consistently from month to month. If a purchase could fit in more than one place, decide on a rule and apply it the same way each time. Consistency makes comparisons more meaningful than repeatedly changing the category scheme.
Update the budget through the month
A budget is more useful when actual amounts are entered during the month rather than reconstructed long afterward. Pick a routine that fits your schedule, such as updating once a week or after reviewing account activity. The spreadsheet does not automatically know whether a transaction has cleared or whether an amount is correct; verify entries against your own records.
- At the beginning of the month, enter estimates in the Planned column.
- As income arrives and expenses occur, record their amounts in the appropriate Actual cells.
- Review negative expense differences to identify categories that are above plan.
- At month-end, check the net amount and note any unusual or one-time items.
- Use what you learned to make next month’s estimates more realistic.
Do not change the original plan just to make a variance disappear. If you deliberately revise a plan mid-month, consider keeping the original amount in a note or a separate column so you can distinguish the first estimate from the updated target. Otherwise, a changed plan can hide what the comparison was meant to show.
Format the sheet for easier review
In Excel for Microsoft 365 on Windows, select the amount cells and use Home > Number to choose a currency or accounting format. Use the same format across planned, actual, and difference amounts. Number formatting changes how a value appears; it does not change the underlying arithmetic. Avoid typing currency symbols or commas as part of text, because text entries may not be included in totals as expected.
Make section headings and total rows visually distinct with bold text or a fill color. Keep color use restrained and do not rely on color alone to explain a result; labels and minus signs should make the meaning clear. You can use Home > Conditional Formatting to highlight negative differences, but check that the rule applies to the intended cells and does not hide the displayed amount.
For readability, widen column A for category names and keep the numeric columns aligned. Freeze panes only if the worksheet grows enough that headings disappear while scrolling. A compact budget with fewer than twenty rows usually does not need elaborate formatting, charts, or multiple worksheets.
Common problems and simple fixes
If a total is wrong, first check whether every amount is stored as a number and whether the formula range includes all relevant rows. A formula that adds B8:B15 will not include a new category entered in B16 if that row now contains the total. Insert new categories above the total row or update the range carefully.
A negative expense difference is not necessarily an error. Under the planned-minus-actual convention, it means actual spending exceeded the plan. A negative net amount means expenses exceeded income in the figures entered. Review the underlying entries before interpreting either result, especially if amounts were copied from another source or entered with the wrong sign.
Do not put a typed total into a cell that should contain a formula. The typed value will not change when the detailed amounts change. Similarly, do not overwrite a formula with an actual transaction amount. Keeping input cells and calculation cells separate makes the workbook easier to maintain.
One-time or annual costs can distort a single month’s comparison. You can record the full payment in the month it is due, or create a separate planned category to reflect money set aside for it each month. The template itself does not decide which approach is appropriate; choose a method that represents your cash-flow plan clearly and use it consistently.
When to use a template or a more detailed tool
A hand-built worksheet is a good choice if you want a transparent monthly plan with a small number of categories. It is easy to change and does not require a special budgeting feature. Microsoft Excel may also show templates through File > New, with availability depending on the version, account, and connected template catalog. A downloaded workbook can save setup time, but check its categories, formulas, and any included links before relying on it.
A basic worksheet is not the same as a transaction ledger. If you want to reconcile every purchase, track several accounts, or categorize many transactions, a separate transaction table or a dedicated budgeting application may be more suitable. More complex spreadsheets can use additional worksheets for transactions and monthly summaries, but that adds work and more opportunities for formula or data-entry mistakes.
For a personal budget, protect the workbook like other financial records. Save it somewhere appropriate for your privacy needs, use a strong sign-in password on the device or storage account, and avoid sharing a file that contains details you do not intend to disclose. A cell or sheet protection setting can prevent accidental edits, but it should not be treated as a substitute for secure storage.
Frequently Asked Questions
How do I make a simple monthly budget in Excel?
Enter income and expense categories, then add Planned, Actual, and Difference columns. Use SUM formulas for the income and expense totals, and subtract total expenses from total income to calculate the remaining amount. Update actual figures during the month.
Does Excel have a free budget template?
Excel may offer budget templates under File > New, but the choices shown can vary by version, account, and availability. You can also create the basic layout in a blank workbook using the rows and formulas in this guide.
What formula calculates a budget balance?
Subtract total expenses from total income. If income is in B6 and expenses are in B16, the formula is =B6-B16. With example totals of 4,200 and 3,700, it returns 500.
Should actual spending be higher or lower than planned?
Neither is automatically good or bad; the difference indicates how the month compared with your estimate. For an expense row using planned minus actual, a positive number means spending was below plan and a negative number means it was above plan.
Can I use this budget template in Excel for Mac or the web?
The basic cells and formulas shown here use standard Excel features and can also be used in Excel for Mac and Excel for the web. Menu locations and some formatting details can differ by platform, but the arithmetic formulas remain the same.
Related
- 5 Year Sales Forecast Excel Template: 5 Options to Compare
- Structured Cell References in Excel: How They Work
- Remove Duplicates in Excel: Steps, Options, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- INDEX MATCH in Google Sheets: How It Works and ExamplesYes. Google Sheets supports both INDEX and MATCH, and combining them lets you find a value in one…
- Excel Paste Special Shortcut: Keys and OptionsIn Excel for Microsoft 365 on Windows, copy the cells, select the destination, and press Ctrl+Alt+V to open…
- Excel Dependent Drop-Down Lists in TablesYes. In Excel for Microsoft 365 on Windows, you can put a dependent drop-down list in an Excel…
- How to Remove a Section Break in Word 365 Without FussTo remove a section break in Word 365, show formatting marks, locate the line labeled Section Break, and…
- Excel Column Limit: What XFD Means and How It WorksMicrosoft Excel allows 16,384 columns in a worksheet, running from column A to column XFD. This limit applies…
- Excel Export CSV With Headers: How It WorksTo export an Excel worksheet to CSV with its headers, put the column names in the worksheet’s first…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.