Yes. A useful Excel budget template can use columns for category, type, planned amount, actual amount, and variance, with formulas to total income and expenses and calculate what remains. In Microsoft Excel for Microsoft 365 on Windows, enter the example layout and formulas below to build a monthly budget you can adjust to your own categories.
What an Excel budget template should show
A budget compares what you expect to receive and spend with what actually happens. A template is most helpful when it makes that comparison easy to update, rather than trying to forecast every detail of your financial life. Start with one month per worksheet or one clearly labeled month in a larger table. Use consistent categories so month-to-month figures remain comparable.
The example below uses one transaction category per row. Column A contains the category, B identifies it as income or expense, C holds the planned amount, D holds the actual amount, and E calculates the variance. Enter these headings in row 1, then use the sample rows:
- Rows 2–4: Salary, Freelance, and Other income. Planned amounts are $4,000, $500, and $20; actual amounts are $4,000, $350, and $20.
- Rows 5–10: Rent, Groceries, Utilities, Transport, Insurance, and Dining. Planned amounts are $1,500, $600, $180, $250, $200, and $250; actual amounts are $1,500, $650, $165, $240, $200, and $310.
These figures are illustrative, not a recommended budget. The example has $4,520 in planned income and $2,980 in planned expenses, leaving $1,540 planned. Actual income is $4,370 and actual expenses are $3,065, leaving $1,305. Seeing both sets of totals makes it clear that the sample month finished $235 below its planned remainder.
Set up the worksheet and make it readable
In a blank workbook, type the headings and sample data into columns A through D. Leave E for the variance formula. Select the populated range and choose Home > Format as Table, select a style, and confirm that the table has headers. A table makes the list easier to filter and can extend formatting and formulas as you add rows. If Excel asks whether the data has headers, keep that option selected.
Format the money columns as currency or number with two decimal places. Select the cells, then use Home > Number to choose an appropriate format. For a simple monthly budget, a currency symbol helps distinguish amounts from counts or percentages. Freeze the header row using View > Freeze Panes > Freeze Top Row if you expect the list to grow. These steps apply to Excel for Microsoft 365 on Windows; the Excel for Mac ribbon offers similar commands, although the layout can differ. Excel for the web also has tables and number formatting, but some ribbon controls may be arranged differently.
Keep actual amounts blank or enter zero until you have figures to record, but be consistent. A blank can mean “not recorded yet,” while zero means “recorded and none occurred.” If you use actual amounts to calculate a running remainder, decide whether unrecorded categories should count as zero or remain incomplete. A note at the top of the sheet can record the month and the date you last updated it.
Calculate each category’s variance
For this example, a positive variance means the result is favorable: income exceeded its plan, or an expense came in under its plan. That means the calculation needs to account for whether a row is income or an expense. With the category type in B2 and planned and actual amounts in C2 and D2, enter this in E2, then copy it through E10:
With the category type in B2, planned amount in C2, and actual amount in D2, the formula in E2 is:
=IF(B2="Income",D2-C2,C2-D2)
For Salary in row 2, the result is $0 because $4,000 actual minus $4,000 planned is zero. For Freelance in row 3, it returns -$150 because actual income of $350 is $150 below the $500 plan. For Groceries in row 6, it returns -$50 because $600 planned minus $650 actual is -$50. The sign convention makes overruns and income shortfalls negative; it does not mean the formula has failed.
To copy the formula, select E2 and drag the small square at the lower-right corner of the selection down to E10, or copy E2 and paste into E3:E10. Excel adjusts the row references as it fills the formula. If you add rows inside a formatted Excel table, Excel will often extend a calculated-column formula automatically; check the new row rather than assuming it did so.
Build summary totals with SUMIF
A small summary section turns the list into a budget view. Put labels in A13:A18 and the corresponding formulas in B13:B18. The first formula totals planned income by adding values in C2:C10 only when the matching type in B2:B10 is Income:
With types in B2:B10 and planned amounts in C2:C10, enter this formula in B13 for planned income:
=SUMIF($B$2:$B$10,"Income",$C$2:$C$10)
It returns $4,520: $4,000 + $500 + $20. The dollar signs keep the source ranges fixed if you copy a formula elsewhere. To total actual income, use the actual-amount column instead:
With types in B2:B10 and actual amounts in D2:D10, enter this formula in B14 for actual income:
=SUMIF($B$2:$B$10,"Income",$D$2:$D$10)
It returns $4,370: $4,000 + $350 + $20. For planned expenses, use the same type range and planned amounts, changing the condition to Expense:
With types in B2:B10 and planned amounts in C2:C10, enter this formula in B15 for planned expenses:
=SUMIF($B$2:$B$10,"Expense",$C$2:$C$10)
The result is $2,980. With types in B2:B10 and actual amounts in D2:D10, enter this formula in B16 for actual expenses:
=SUMIF($B$2:$B$10,"Expense",$D$2:$D$10)
The result is $3,065. Finally, subtract expenses from income to show the planned and actual remainder:
With planned income in B13 and planned expenses in B15, enter this formula in B17:
=B13-B15
It returns $1,540. With actual income in B14 and actual expenses in B16, enter this formula in B18:
=B14-B16
It returns $1,305. This remainder is what is left in the example after the listed income and expenses; it is not automatically a savings balance or a forecast of future cash.
Customize categories without breaking the math
Use categories that match the way you review spending. “Housing” might be more useful than separate rent and maintenance lines if you only need a broad monthly view; separate lines are better if you want to identify which cost changed. Keep income and expenses labeled consistently as Income or Expense, because the variance formula and SUMIF summaries depend on those exact labels.
When you add a category, place its type, planned amount, and actual amount on the same row. Extend the variance formula to that row and expand the summary ranges if the new row falls outside rows 2:10. An Excel table can make range expansion easier, but ordinary cell ranges do not automatically include every new row in every formula. Check the formulas after inserting data. You can also add a Notes column for irregular items such as an annual subscription, a reimbursement, or an unusually large bill.
For a longer time horizon, consider a separate worksheet for each month or a single transaction table with a date column and a month summary. Separate monthly sheets are straightforward for beginners but can make year-wide comparisons cumbersome. A single table supports broader analysis but needs more careful organization. Whichever structure you choose, avoid mixing planned amounts and actual transactions in a way that makes it unclear whether a figure is a monthly total or an individual payment.
Common formula and budgeting problems
- A total is too low: Check whether all relevant rows are included in the SUMIF range and whether the type is spelled exactly Income or Expense. A trailing space or a different label will not match the condition.
- A formula displays as text: The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell format to General, then re-enter the formula.
- Variance signs seem backward: This template treats positive as favorable. If you prefer “actual minus planned” for every line, the expense interpretation changes. Pick one convention and label the column clearly.
- Actual income is counted as an expense: Check column B. The summary only includes rows with the matching type, so a misclassified row is omitted from the intended total.
- The remainder looks larger than the available cash: The summary only accounts for categories included in the list. Add missing expenses, transfers, or other relevant items if you want a more complete picture. Avoid counting a transfer twice—for example, as both an expense and a separate savings allocation.
Formulas in this example use commas between arguments, which is standard in many Excel installations. Depending on regional settings, Excel may expect semicolons instead. If a correctly typed formula is rejected, check the list separator setting and your decimal conventions rather than assuming the function is unavailable.
Excel template, built-in templates, or another tool?
Building this template yourself is useful when you want a small, transparent sheet and control over categories. Excel also offers built-in workbook templates: choose File > New and search for budget-related templates. Available templates can vary by account, language, and version, so inspect the layout and formulas before entering personal figures. A downloaded template may include extra sheets or features you do not need.
A spreadsheet is flexible, but it requires manual updates and careful handling of the file. A dedicated budgeting app may offer account connections or automatic categorization, depending on the service, while a simple notes list may be enough for someone tracking only a few recurring costs. Compare the setup effort, privacy practices, access across devices, and any subscription or service terms before choosing. No template can make incomplete or inaccurate entries reliable.
For a personal workbook, save it somewhere you can find and back up, and avoid sharing it publicly if it contains sensitive information. Password-protecting a file is not a substitute for secure storage or a backup. The figures here are a spreadsheet example, not financial, tax, investment, or legal advice; verify real account terms and consult a qualified professional for decisions that require tailored advice.
Frequently Asked Questions
How do I make a monthly budget in Excel?
List income and expense categories, enter planned and actual amounts, calculate each category’s variance, and add totals for income, expenses, and the remainder. Review and update the actual column during the month.
What formula totals expenses in Excel?
If expense types are in B2:B10 and amounts are in C2:C10, use =SUMIF(B2:B10,"Expense",C2:C10). It adds amounts only for rows labeled Expense. Make sure the type labels match your data.
Can Excel calculate money left after bills?
Yes. Subtract total expenses from total income. In this example, actual income of $4,370 minus actual expenses of $3,065 leaves $1,305 for the listed month.
Should a positive budget variance be good or bad?
It depends on the convention. This template uses positive to mean favorable: income above plan or expenses below plan. Label the column and use the same convention throughout.
Can I use this budget template in Excel for Mac or the web?
Yes. The basic formulas and worksheet layout work in current Excel for Mac and Excel for the web. Ribbon placement and some formatting options can differ, so use the corresponding Home, View, or File controls in your version.
How often should I update a budget spreadsheet?
Update it whenever you have reliable new figures—weekly is a practical rhythm for many people, while frequent transactions may call for more regular updates. The important point is to use a consistent schedule and mark estimates separately from confirmed amounts.
Related
- Attendance Register Template in Excel: Setup and Tips
- Attendance Roster Template in Excel: Setup and Tips
- Attendance Point Tracking Excel Template?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formulas to Compare Data: Top MethodsThe fastest way to compare data in Excel is to use the IF function for row-by-row checks (e.g.,…
- Excel SUMIF with Text: How to Sum Cells That Contain TextThe Excel SUMIF function can sum values based on a text criterion, such as a specific word, a…
- Excel Count Unique Values: 6 Ways to Ignore DuplicatesTo count unique values in Excel while ignoring duplicates, use =SUMPRODUCT(1/COUNTIF(range, range)) for a single column, or =COUNTA(UNIQUE(range))…
- Excel VLOOKUP IFERROR: Return a Blank for Lookup ErrorsTo make an Excel VLOOKUP display a blank when it returns an error, wrap it in IFERROR: =IFERROR(VLOOKUP(E2,$A$2:$C$100,3,FALSE),"").…
- Oracle Java String Functions ExplainedIn Oracle-related Java code, string operations usually mean methods on Java’s built-in String class, such as length(), substring(),…
- Count Unique Cells in Excel: Formulas and ExamplesTo count distinct, nonblank values in Excel for Microsoft 365, use =COUNTA(UNIQUE(FILTER(A2:A10,A2:A10<>""))). This assumes the values are in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.