Monthly Budget vs Actual Excel Template: Free Setup

Yes—you can make a free monthly budget-versus-actual template in Excel with columns for category, budget, actual spending, variance, and percentage used. Enter your planned amounts and actuals, then use simple formulas to see where you are under or over budget; the layout and formulas below work in Excel for Microsoft 365 on Windows.

What a monthly budget-versus-actual template shows

A monthly budget is a plan for where money is expected to go. An actual column records what really happened. Comparing the two turns a list of spending limits into a useful review: you can spot categories that regularly run high, see whether a one-off purchase explains a difference, and adjust next month’s plan using real figures.

A basic worksheet can use these five columns:

Category: a spending group such as rent, groceries, transport, or utilities.
Budget: the amount planned for that category during the month.
Actual: the amount spent during the month.
Variance: the difference between the plan and actual spending.
Percent used: actual spending divided by the budget, useful for seeing how much of a category’s limit is used.

For an expense budget, define variance as budget minus actual. A positive number then means spending is below budget, while a negative number means spending exceeded it. State this convention in the sheet so a reader does not mistake a negative variance for a favorable result. Income needs a different interpretation: income above plan is generally favorable, so it is clearer to track income separately and calculate actual minus budget there.

Build the free template in Excel

Start a blank workbook and enter the column headings in A4:E4: Category, Budget, Actual, Variance, and Percent Used. Put expense categories in A5:A16, enter planned amounts in B5:B16, and reserve row 17 for totals. You can rename or add categories; if you add rows, extend the total formulas to include them.

For example, categories might include housing, electricity and other utilities, groceries, dining out, transport, insurance, healthcare, household supplies, subscriptions, personal spending, debt payments, and savings. The right categories depend on what you want to track. Separate categories only when the distinction will help you make a decision; an over-detailed sheet can take more effort to maintain than it returns.

Format Budget, Actual, and Variance as currency, and Percent Used as a percentage. On Windows, use Home > Number Format to select a suitable format. In Excel for Mac, the number-format controls are also on the Home tab, though ribbon layout can vary by release. Formatting changes how values display, not the underlying calculations.

Use formulas for variance and totals

With category names in A5:A16, budgets in B5:B16, actuals in C5:C16, and variance in D5:D16, enter this in D5 and fill it down through D16: =B5-C5. If the first category has a $1,500 budget and $1,560 of actual spending, the result is -$60, meaning spending was $60 over plan.

With the same row layout and the category’s budget in B5 and actual in C5, enter this in E5 and fill it down through E16: =IF(B5=0,"",C5/B5). If that category has a $1,500 budget and $1,560 actual, the result is 104%. When the budget is zero, the formula leaves the cell blank rather than showing a division error. A blank percentage does not mean there was no spending, so check the actual amount in C.

With budget amounts in B5:B16 and the total row in row 17, enter this in B17: =SUM(B5:B16). For example, if the listed budgets total $4,500, the result is $4,500. With actual amounts in C5:C16 and the same total row, enter this in C17: =SUM(C5:C16). If actual spending totals $4,200, the result is $4,200.

With totals in B17 and C17, enter this in D17: =B17-C17. Using the example totals, the result is $300 under budget. With those same totals, enter this in E17: =IF(B17=0,"",C17/B17). The result is 93.3% when $4,200 is divided by $4,500. The total percentage is a weighted comparison of the whole budget, not an average of the category percentages.

Enter actuals manually or from transactions

For a simple workbook, type each category’s month-to-date spending into the Actual column and update it as needed. This is quick, but it depends on remembering to include purchases and avoiding duplicates. A regular review of bank or card activity can help you reconcile the amounts. Keep a note for unusual items, such as an annual bill, so you can understand a large variance later.

If you prefer to list transactions, add a Transactions sheet with dates in column A, categories in B, and positive expense amounts in C, starting in row 2. On the budget sheet, with the category name in A5 and transaction categories in Transactions!B2:B100 and amounts in Transactions!C2:C100, enter this in C5 and fill it down: =SUMIF(Transactions!$B$2:$B$100,A5,Transactions!$C$2:$C$100). If the rows labeled Rent total $1,560, the formula returns $1,560 for the Rent category. Keep the category labels consistent; “Groceries” and “Food” will not match unless you use the same label or deliberately map them.

This method is transparent and does not require connecting a workbook to a bank account. Expand the formula ranges when the transaction list grows past row 100, or convert the transaction range to an Excel table and use structured references if you are comfortable maintaining them. For a first template, a clearly bounded range is easier to inspect.

Interpret variances without misreading them

A variance is a prompt to investigate, not a verdict on whether a purchase was good or bad. A negative grocery variance could reflect an unusually busy month, a price increase, or a budget that was unrealistic from the start. A positive utility variance could be temporary, or it could become a useful amount to reassign after checking upcoming bills.

Compare categories on the same basis and period. If the budget is for the full month but actuals cover only the first week, the difference is not yet a meaningful month-end result. For ongoing tracking, add a clear “Month” label near the top of the sheet and use the same date range for the budget and transactions.

Some categories do not behave like regular monthly bills. Annual insurance, car repairs, or gifts may be easier to plan for by setting aside a monthly amount, even when the bill is paid once a year. Record the budget approach you choose in a notes column or a separate notes area. Otherwise, a month with no payment can look unusually favorable, followed by a month with a large overspend.

Make the sheet easier to read and maintain

Use Excel’s built-in formatting to make exceptions visible without changing your calculations. On Windows, select the variance cells and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than to highlight negative expense variances. Choose a clear format and check that the colors remain readable when printed or viewed by someone with color-vision differences. Excel for Mac also provides conditional formatting from the Home tab; exact control placement may differ by version.

A few practical checks can prevent misleading totals:

Use the same currency throughout the workbook, and label it if the symbol alone could be ambiguous.
Enter amounts as numbers, not text with typed currency symbols, so SUM can include them.
Decide how refunds will be recorded. For expenses, a refund can be entered as a negative transaction against its original category, keeping the net spending calculation understandable.
Keep savings contributions distinct from purchases if you want to know how much was spent versus set aside.
Check that the total row includes every category and excludes the total itself.

Protecting formula cells can reduce accidental edits, but it is not a replacement for keeping a backup. A separate copy for each month preserves the record of what was planned and spent; alternatively, save one workbook and duplicate the monthly sheet, updating its dates and clearing only input cells.

Free Excel options and alternatives

The layout and formulas do not require a paid budgeting add-in. You can create the workbook yourself in Excel, and Microsoft offers Excel for the web with a Microsoft account, subject to its current product terms and feature availability. The desktop Excel application may require a qualifying license or subscription. Template catalogs can change, so if you look for a prebuilt file through Microsoft Create or another source, check the current download details and inspect formulas before entering personal information.

A spreadsheet is useful when you want to control categories, formulas, and storage. It also requires manual setup and upkeep. A budgeting app may offer automatic transaction imports or alerts, but those features, prices, and data practices vary by provider. Google Sheets is another spreadsheet option, though menus and some formula behavior differ from Excel. Choose based on whether customization, automated imports, offline access, or ease of sharing matters most to you.

For privacy, store the workbook somewhere appropriate for the sensitivity of its contents, limit sharing permissions, and avoid including unnecessary account numbers or other identifying details. If you use a cloud service, review its sharing settings rather than assuming a file is private because it is a spreadsheet. A basic budget workbook does not need bank credentials.

A simple monthly review routine

At the start of a month, copy the template, label the month, and enter planned amounts. During the month, record transactions or update category totals at a pace you can sustain. At month end, reconcile actuals against statements and receipts where appropriate, then review the largest variances.

Use the review to make specific adjustments: change a future budget if a recurring cost has changed, correct a category if a transaction was misclassified, or leave a one-time difference as an exception rather than permanently altering the plan. Carrying forward every overspend as a new “normal” can obscure whether the original budget still reflects your priorities. The spreadsheet is a tracking aid, not financial, tax, investment, or legal advice; check actual account terms with the relevant provider and consult a qualified professional for advice on your circumstances.

Frequently Asked Questions

Is there a free monthly budget-versus-actual Excel template?
You can build one without a paid add-in using the columns and formulas above. A ready-made file may also be available from Microsoft’s changing template catalog or another provider, but check its source, formulas, and terms before using it.

What does a negative variance mean in an expense budget?
With variance calculated as budget minus actual, a negative value means actual spending was higher than planned. For example, a $500 budget and $540 actual produce a -$40 variance.

Should income and expenses use the same variance formula?
Not if you want positive values to mean “better than planned” in both cases. For expenses, budget minus actual makes underspending positive. For income, actual minus budget makes income above plan positive. Label the convention used for each section.

Can actual spending update automatically?
It can update from a transaction list using a formula such as SUMIF, as shown above. The transactions still need to be entered or imported, and the categories must match the budget labels. Automatic bank imports depend on separate services or tools and are not built into this basic template.

Why is the percentage-used cell blank?
The example formula intentionally returns a blank when the budget is zero, because dividing by zero is undefined. Check the Actual cell for spending in that category, then decide whether to set a budget or keep that category outside the percentage comparison.

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.