Budgeting Template for Excel: Build a Monthly Plan

How-to basics · Updated November 21, 2026

A practical budgeting template for Excel has columns for each category’s planned amount, actual amount, and difference, plus totals for income, spending, and money left over. In Excel for Microsoft 365 on Windows, enter the categories below and use the copy-ready formulas in this guide to make a reusable monthly budget.

What the template should contain

A useful budget is a comparison, not just a list of bills. The planned column records what you expect to receive or spend; the actual column records what happened. A variance column makes the difference visible. For expenses, a positive variance means you spent more than planned if you calculate actual minus planned. For income, the same calculation shows whether you received more or less than expected.

Start with one worksheet and these four column headings in cells A1:D1:

  • Category: the income source or expense type.
  • Planned: the amount you expect for the month.
  • Actual: the amount received or spent.
  • Variance (Actual – Planned): the difference between what happened and the plan.

Use rows 2–4 for income categories such as wages, freelance work, and other income. Put total income in row 5. Use rows 8–14 for regular bills and other outflows, such as housing, utilities, groceries, transportation, insurance, eating out, and a savings or debt-payment goal. Put total outflows in row 15 and the amount remaining in row 17. Leave row 6 and row 16 blank, or use them for visual spacing.

Whether to include savings as an outflow depends on what you want the remaining balance to mean. Including a planned transfer to savings shows how much is left after that goal; leaving it out shows what remains before saving. Pick one treatment and use it consistently. This is a tracking layout, not a recommendation about how much to save or spend.

Set up the worksheet

In a new workbook, type the headings and categories into the cells described above. Add your own categories rather than trying to fit every household into a standard list. For example, a person who drives may want separate fuel and maintenance rows, while someone who works from home may track internet or office costs separately. Keep enough detail to make the figures useful without creating so many rows that updating the sheet becomes a chore.

Enter amounts as numbers in the Planned and Actual columns, not as text. For example, enter 1200 rather than typing a currency symbol into the cell; apply currency formatting afterward. Use the same period for all entries. A monthly budget should compare one month’s income and outflows, not a monthly plan against a yearly bill entered at its full annual amount. For an annual or quarterly bill, you can either track the full payment in the month it is due or set aside a monthly share, but avoid counting both approaches as separate spending.

It can help to label the worksheet with the month and year in a cell above the table, such as F1, and duplicate the sheet for the next month. Before reusing it, clear the old actual amounts while keeping the categories and formulas. In Microsoft 365 for Windows, save a reusable starting point with File > Save As. Excel for Mac has the same Save As command, though the dialog and menu presentation can differ. Keep an untouched copy as your base template.

Add formulas for totals and variances

The examples below use the cell layout above. Suppose planned income is 4,500 from wages, 300 from freelance work, and 200 from other income, for a planned total of 5,000. Actual income is 4,500, 250, and 100, or 4,850. For total planned income, with income categories in rows 2–4 and amounts in column B, enter this in B5:

With planned income in B2:B4, this formula in B5 totals those entries; the example returns 5,000: =SUM(B2:B4)

With actual income in C2:C4, this formula in C5 totals the received amounts; the example returns 4,850: =SUM(C2:C4)

With planned income in B5 and actual income in C5, this formula in D5 calculates the income variance; the example returns -150: =C5-B5

Now suppose planned outflows in rows 8–14 are 1,200, 450, 500, 250, 300, 400, and 600. They total 3,700. Actual outflows are 1,200, 480, 560, 230, 300, 450, and 500, totaling 3,720. With planned outflows in B8:B14, enter this in B15; it returns 3,700: =SUM(B8:B14)

With actual outflows in C8:C14, this formula in C15 returns 3,720: =SUM(C8:C14)

For an individual category, with its planned amount in B8 and actual amount in C8, this formula in D8 calculates actual minus planned; for the example’s first expense, it returns 0: =C8-B8

Copy D8 down through D14 to calculate each expense variance. A positive value means that category exceeded its plan; a negative value means actual spending was below plan. With total planned outflows in B15 and actual outflows in C15, this formula in D15 returns the overall difference of 20: =C15-B15

Finally, calculate what remains after outflows. With total planned income in B5 and planned outflows in B15, enter this in B17; it returns 1,300: =B5-B15

With actual income in C5 and actual outflows in C15, this formula in C17 returns 1,130: =C5-C15

With planned remaining money in B17 and actual remaining money in C17, this formula in D17 returns -170, meaning the actual balance is 170 lower than planned: =C17-B17

Choose categories and realistic estimates

Useful categories make it possible to spot patterns. Broad labels such as “bills” and “other” are quick to maintain, but they can hide what changed. At the other extreme, a separate row for every purchase makes a monthly summary difficult to scan. A balanced starting list might include:

  • Income: wages, self-employment or freelance income, and other expected income.
  • Regular commitments: housing, utilities, insurance, and subscriptions.
  • Variable costs: groceries, transportation, health costs, and personal spending.
  • Occasional costs: repairs, gifts, travel, or annual fees, handled consistently from month to month.

Use recent records to estimate variable categories rather than relying only on an ideal target. If grocery spending changes with the number of shopping trips or household members, a single month may be a poor guide; comparing several months can provide context. A budget is also easier to interpret when you mark estimates as estimates and update them as circumstances change. A large gap between planned and actual amounts is information to investigate, not automatically proof that the plan has failed.

Record actual amounts consistently

You can update the Actual column weekly, after each pay period, or at month-end. More frequent updates can make it easier to notice a category running high, but only if the routine is manageable. If you update monthly, use statements, receipts, or another reliable record so that the actual figures are not just guesses. Decide whether a transaction belongs to the date it occurred or the date it cleared, and apply that rule consistently.

For a larger or more detailed budget, keep transactions on a separate worksheet with columns for date, description, category, and amount, then summarize them in the monthly sheet. That approach makes it easier to review individual purchases, but it requires accurate category labels and a way to avoid counting transactions twice. For instance, if you record a credit-card purchase as spending, do not also count the later card-bill payment as new spending. Likewise, a transfer between your own accounts is not usually a new purchase; recording both sides as expenses can inflate your totals.

If you use a transaction log, reconcile its monthly category totals with account statements and the summary sheet. Excel can organize records, but it does not know whether a transaction is classified correctly or whether a bank import is complete. Avoid putting account passwords or other sensitive login information into workbook cells.

Make the template easier to read

Select the category and amount range, then use Home > Format as Table if you want a styled, filterable list. Because this simple design contains blank spacer rows and separate summary lines, you may prefer to format only the category rows as a table and style totals separately. Use Home > Number to apply currency or number formatting. Choose a consistent currency and decimal display; displaying no cents can make a summary easier to read, while retaining cents may matter when reconciling exact transaction totals.

Use bold text or a top border for total income, total outflows, and remaining money. Conditional formatting can draw attention to overspending: select the expense variance cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than and enter 0. That highlights positive expense variances under the actual-minus-planned convention used here. Do not apply the same interpretation blindly to income, where a positive variance has a different meaning.

For a long worksheet, View > Freeze Panes > Freeze Top Row keeps the column headings visible while you scroll. Excel for Mac also provides Freeze Panes controls on the View tab, though the ribbon layout can vary. If you change a category or insert a row, check that the total ranges still include all relevant entries.

Common problems and how to avoid them

A common source of confusion is reversing the variance calculation. This template uses actual minus planned throughout. That means positive expense variance is over plan, while negative expense variance is under plan. If you prefer a “remaining budget” column for expenses, calculate planned minus actual instead, but label it clearly and do not mix the two conventions. A number without a defined sign convention is easy to misread.

Another problem is mixing time periods or double-counting money. Do not compare a full year of insurance with one month of income unless the purpose is explicitly to show cash flow in the payment month. Do not record both a card purchase and its repayment as spending. If income varies, distinguish money already received from income that is only expected, and update the actual column as deposits arrive.

Check formulas when you add categories. A total such as SUM(B8:B14) will not include a new category placed below row 14. Expand the range or insert the category inside it, then verify the total. Also check for numbers accidentally stored as text, blank categories with amounts, and copied formulas pointing to the wrong row. These basic checks often explain totals that do not match a statement.

The figures in this guide are illustrative budgeting arithmetic, not financial, tax, investment, or legal advice. If you include loan payments or interest, check the actual payment schedule and terms with the lender or a qualified professional rather than assuming a budget example reflects your agreement.

Excel templates and other options

Excel may offer ready-made personal budget templates through File > New, but the templates shown can vary by Excel version, account, and availability. A built-in file can save setup time; review its categories and formulas before relying on it, since it may use a different definition of savings, income, or variance. The simple layout here is useful when you want to understand each calculation or adapt categories to your own tracking method.

A spreadsheet is not the only option. A paper budget or a basic notes app may suit someone who wants a short monthly checklist and does not need automatic totals. A dedicated budgeting app may offer account connections or transaction categorization, but features, costs, privacy practices, and availability vary. Choose a method you can maintain, and consider what data you are comfortable storing or connecting. Excel offers flexibility and local workbook control, but it does not automatically verify transactions unless you set up an import or enter them yourself.

Frequently Asked Questions

Does Excel have a free budget template?
Excel may show budget templates under File > New. Availability and the exact choices can vary, so you can also create a basic sheet with the columns and formulas above. Review any downloaded or built-in template before entering personal information.

How do I make an Excel budget calculate automatically?
Enter the SUM formulas for totals and subtraction formulas for variances and remaining money. When you change a planned or actual amount, Excel recalculates dependent cells automatically under the usual automatic calculation setting.

Can I use this budget template weekly?
Yes. Use a consistent week for the planned and actual amounts, and adjust the summary periods accordingly. If you compare weekly figures with monthly bills, be clear about whether you are recording the full bill when paid or setting aside a weekly share.

What is the difference between planned and actual spending?
Planned spending is the amount you assign to a category before or during the budget period. Actual spending is what you record as having occurred. The variance shows the difference, but its meaning depends on the subtraction order and the label you use.

Should savings count as an expense in a budget?
That depends on what you want the remaining-money figure to represent. Include a savings transfer among outflows if you want to see what remains after that planned transfer; otherwise show savings separately. Be consistent and avoid counting the same transfer twice.

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.