Excel Template for a Budget Plan: Build Your Own

How-to basics · Updated November 19, 2026

An Excel template for a budget plan can be a built-in workbook or a simple worksheet you set up yourself. For a flexible monthly plan in Excel for Microsoft 365 on Windows, make a budget sheet for planned amounts and actual spending, then use a transaction log and SUMIFS formulas to compare them.

Choose a template or build a simple one

To look for a ready-made option, open Excel and select File > New, then search for budget templates. The available designs can vary with your Microsoft account, internet connection, and what Microsoft currently offers. Before using one, check that it lets you see the categories and calculations clearly; a polished dashboard is less useful if you cannot tell how its totals are calculated.

A custom workbook is a good alternative if you want to control the categories, avoid features you do not need, or learn how the numbers are produced. The structure below is intentionally plain: one sheet holds the monthly plan, and another records income and expenses. You can start with a single month and reuse the workbook after checking that the dates and categories work as expected.

Set up the workbook

  1. Rename the first worksheet Budget and add a second worksheet called Transactions.
  2. On Budget, put a month-start date in B2, such as January 1, 2026. Format the cell as a date so it is easy to read.
  3. Use A3 for Planned income and B3 for the amount you expect to receive. Put Actual income in C3; a formula for that cell appears below.
  4. In row 5, add the headers Expense category, Planned, Actual, and Left in cells A5:D5. List your expense categories in A6:A14.
  5. On Transactions, use columns A:E for Date, Type, Category, Description, and Amount. Enter each transaction as a separate row, using Income or Expense consistently in the Type column.

For example, a transaction row might contain a date, Expense, Groceries, Weekly food shop, and 85.40. Enter amounts as positive numbers; the Type field identifies whether they are income or expenses. On Budget, enter a planned amount beside each expense category. Keeping categories consistent matters: if the budget says Groceries but the log says Food, Excel treats those as different labels.

Calculate actual income and spending

SUMIFS adds amounts that meet several conditions. In the following formulas, transaction dates are in Transactions!A2:A1000, types in B2:B1000, categories in C2:C1000, and amounts in E2:E1000. The date in Budget!B2 should be the first day of the month being reviewed. The criteria include that date and stop before the first day of the next month, so transactions from other months are not included.

With the Transactions layout above and the month-start date in Budget!B2, enter this formula in Budget!C3 to total income for that month:

=SUMIFS(Transactions!$E$2:$E$1000,Transactions!$B$2:$B$1000,"Income",Transactions!$A$2:$A$1000,">="&$B$2,Transactions!$A$2:$A$1000,"<"&EOMONTH($B$2,0)+1)

If the matching income rows total 4,200.00, C3 returns 4,200.00. For example, two income entries of 3,000.00 and 1,200.00 add to 4,200.00. The formula only includes rows marked Income whose dates fall within the selected month.

With expense categories in Budget!A6:A14 and the same Transactions columns, enter this formula in Budget!C6, then copy it down through C14:

=SUMIFS(Transactions!$E$2:$E$1000,Transactions!$B$2:$B$1000,"Expense",Transactions!$C$2:$C$1000,$A6,Transactions!$A$2:$A$1000,">="&$B$2,Transactions!$A$2:$A$1000,"<"&EOMONTH($B$2,0)+1)

In a sample month, suppose the Groceries rows are 178.40 and 233.97. If Groceries is in A6, C6 returns 412.37 because 178.40 + 233.97 = 412.37. When copied down, the category reference changes from A6 to A7, A8, and so on. The month reference remains fixed at B2.

With planned expenses in B6:B14 and actual expenses in C6:C14, enter this formula in D6 and copy it down to D14:

=B6-C6

If the planned Groceries amount in B6 is 600.00 and actual spending in C6 is 412.37, D6 returns 187.63: 600.00 minus 412.37. A positive result means planned funds remain; a negative result means actual spending is over the planned amount. This interpretation applies because the rows represent expenses, not income.

With expense plan values in B6:B14 and actuals in C6:C14, enter these totals in B15 and C15 respectively:

=SUM(B6:B14) and =SUM(C6:C14)

If the planned amounts add to 3,300.00, B15 returns 3,300.00. If actual expenses add to 2,860.00, C15 returns 2,860.00. Check the displayed totals against the individual rows when you first set up the workbook; a missing category or an incorrect amount can make a total misleading even when the formula itself is correct.

Choose useful budget categories

Start with categories that help you make a decision, rather than copying a long generic list. A practical first version might include housing, utilities, groceries, transport, insurance, debt payments, dining, household costs, and other spending. Adjust the names to fit your situation, and keep the number manageable enough that you will reliably classify transactions.

It can help to distinguish regular bills from spending that varies. Rent may be fairly predictable, while groceries or transport can change from month to month. If a category is too broad to be useful, split it; if you rarely use two similar categories, combine them. Treat transfers between your own accounts carefully so they are not accidentally counted as both income and spending.

Make data entry easier and reduce errors

A transaction log is only useful when its entries are consistent. In Excel, select the transaction range and choose Insert > Table, then confirm that the table has headers. Tables make it easier to filter and review records as the list grows. The formulas above use fixed ranges through row 1000, so extend those ranges if you expect more than 999 transaction rows; alternatively, adapt the formulas to table references if you are comfortable working with structured references.

  • Use the same category spelling in the budget and transaction log.
  • Enter actual dates as Excel dates, not as text that merely looks like a date.
  • Use one amount convention throughout: positive amounts plus a Type column is straightforward.
  • Check for duplicate transactions and uncategorized entries when reconciling a month.

For a category dropdown, select the cells where you will enter categories on Transactions and choose Data > Data Validation. Set Allow to List and provide a source range containing the category names. This can reduce spelling variations, but it does not replace checking that the right category was selected.

Format the plan for quick review

Format planned and actual amounts as currency using Home > Number, and make the month selector visually obvious. You can use Home > Conditional Formatting to highlight negative values in the Left column, which draws attention to categories that have exceeded their plan. Keep colors readable and do not rely on color alone; the negative number itself should remain visible.

Freeze the header row or the top rows if the transaction list becomes long by using View > Freeze Panes. A chart can help show the relative size of expense categories, but it should complement—not replace—the table. A simple comparison of planned and actual totals is usually easier to interpret than a dashboard with many decorative indicators.

Review the plan each month

A budget is a working estimate, not a promise that every month will match exactly. At the end of the month, enter or import the transactions, check the category totals, and compare actual amounts with the plan. Then adjust the next month’s planned figures when circumstances or priorities change. If you reuse one sheet, change B2 to the first day of the new month; if you duplicate a monthly sheet, keep a separate, clearly named copy for each period.

For an annual view, summarize each month’s planned and actual totals on a separate sheet. Avoid mixing months in one monthly total unless you deliberately add a month condition, as the formulas here are designed to filter by the date in B2. If you use the workbook to organize debt payments or other obligations, confirm payment dates, rates, and amounts against the relevant statements or lender terms. This is a tracking tool, not financial, tax, or legal advice; consult a qualified professional for advice specific to your circumstances.

Common problems and what to check

If a formula returns zero unexpectedly, first check that the transaction dates are real Excel dates and fall within the selected month. Then check that Type and Category text match exactly. Extra spaces, a different spelling, or using Expense in one row and Expenses in another can prevent a match. Also verify that the amounts are numeric rather than text.

If the formula produces an error after you extend the log, confirm that the formula ranges still cover every transaction row. The example formulas stop at row 1000 by design. If a month total appears too high, look for duplicate imports, transfers counted as expenses, or transactions assigned to the wrong month. A formula cannot determine whether the underlying entry is correct; it only adds entries that meet its stated conditions.

Frequently Asked Questions

Does Excel have a free budget template?
Excel’s File > New page may offer budget templates to search and open, but the available choices can vary. You can also build the basic workbook described here without downloading a separate template.

Can I use this budget template in Excel for Mac?
The basic worksheet layout and SUMIFS formulas work in current desktop versions of Excel for Mac as well. Ribbon placement can differ from Windows, so follow the equivalent commands in the Mac interface if a menu path does not match exactly.

Can I use the workbook in Excel for the web?
Excel for the web supports ordinary worksheets and SUMIFS, so the core budget can be used there. Some ribbon commands and template options may appear in different places than in the Windows desktop app.

Should I enter expenses as negative numbers?
Not with this setup. Enter income and expenses as positive amounts, then distinguish them with the Type field. The budget formulas filter by Type, and the expense remaining calculation subtracts actual spending from the planned amount.

How do I budget for irregular expenses?
Use a category such as Annual bills or Car repairs and plan a monthly contribution if that helps you track the amount you intend to set aside. Record actual payments as expenses when they occur, and keep the planned contribution separate from a payment so the same money is not counted twice.

What if I want a different currency?
Select the amount cells and choose a suitable currency or number format from Home > Number. The formulas add numeric values; the displayed currency symbol is a format and does not change the arithmetic. Use one currency consistently within a budget unless you deliberately convert amounts.

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.