Budget vs Actual Excel Template: Free Options and Setup

How-to basics · Updated November 19, 2026

Yes—free budget vs actual Excel templates are available, and you can also build a simple one yourself in Microsoft Excel for Microsoft 365. A useful template lists budgeted amounts beside actual spending or income, then calculates the difference so you can see where results diverged from plan.

What a budget vs actual template does

A budget is a plan for income and spending over a defined period. Actuals are the amounts recorded for that same period. A budget vs actual spreadsheet puts the two figures side by side, usually by month and category, and calculates a variance. For example, if a department planned to spend $1,200 on supplies but spent $1,350, the $150 difference prompts a follow-up: Was there an unexpected purchase, a price increase, or an inaccurate estimate?

This is a comparison tool, not just a list of expenses. It can help a household review recurring bills, a small business track operating costs, or a project manager monitor a fixed project budget. The categories and level of detail should fit the decision you need to make. A household may want groceries, rent, and transport; a business could separate software, payroll, and marketing.

Where to find a free Excel template

In Excel for Microsoft 365 on Windows, select File > New and search the available templates for terms such as budget or monthly budget. The selection can vary, and some templates are designed for personal finances rather than a business-style budget-to-actual comparison. Check that the workbook actually includes both planned and actual amounts, the period you need, and formulas you can inspect.

You can also find downloadable workbooks from reputable accounting, nonprofit, or business-support organizations. Before entering financial information, consider who published the file, whether it requires an account or payment, and whether its license permits your intended use. A template described as free does not necessarily mean Excel itself is free: Microsoft 365 is a paid subscription, while Excel for the web has free access options with a Microsoft account and may not offer every desktop feature.

Download spreadsheet files only from sources you trust. If a workbook contains macros, Excel may show a security warning; a basic budget comparison ordinarily does not need macros. Avoid enabling macros simply to make a basic template work. Keep an untouched copy of the original, then save your working version under a clear name.

What to look for when choosing a template

A polished design is less important than a workbook that matches your reporting needs and makes its calculations understandable. Before committing to a template, check these points:

  • Time period: It should support the reporting cycle you use, such as monthly or quarterly, and make the dates clear.
  • Categories: You should be able to rename, add, or remove categories without breaking totals.
  • Separate inputs and calculations: Budget and actual entry cells should be distinguishable from formula cells.
  • Variance meaning: The workbook should explain whether a positive number means over budget, under budget, or favorable.
  • Useful summary: Totals and a concise overview can help you find significant differences without reading every line.
  • Compatibility: Check whether the file is an Excel workbook and whether it relies on features that may not work in older spreadsheet programs.

For a first workbook, a simple table is often preferable to a complex dashboard. Extra charts and formatting cannot compensate for categories that do not fit your records or formulas that are difficult to audit.

A practical workbook layout

For one month, create columns for category, budget, actual, variance, and percentage variance. Put headings in row 1 and category names in rows 2 through 20, adjusting the range to suit your list. For example, row 2 could be Rent, with a budget of $1,200 and an actual amount of $1,250. Keep the budget and actual columns as numeric values, not text containing typed dollar signs. Apply a currency number format to display the amounts clearly.

With budget in B2 and actual in C2, and the variance in D2 defined as actual minus budget, enter =C2-B2 in D2. In the rent example, Excel returns 50, meaning actual spending was $50 above budget. Copy the formula down the variance column for the other categories. This sign convention is intuitive for expenses, but it does not mean a positive variance is always bad: earning more revenue than planned also produces a positive difference.

With budget in B2, actual in C2, and variance in D2, enter =IF(B2=0,"",D2/B2) in E2 to calculate percentage variance. With a $1,200 budget and a $50 overrun, the result is about 4.17%. Format E2 as a percentage and copy the formula down. When the budget is zero, the formula leaves the percentage blank rather than attempting to divide by zero; decide separately how to flag unplanned spending in a zero-budget category.

With category amounts in B2:B20 for budget and C2:C20 for actual, place =SUM(B2:B20) in B21 and =SUM(C2:C20) in C21 to total each column. For those totals in B21 and C21, enter =C21-B21 in D21 to show the overall dollar variance. Check that the category range includes every intended row and excludes the total row, or the total may count itself and return an incorrect result.

How to enter and review actuals

Agree on what counts as an actual before comparing numbers. For a household, it may be posted bank transactions; for a business, it may be amounts from an accounting report for the same dates and accounting basis as the budget. Mixing a cash-based budget with actuals recorded on a different basis can create differences that reflect timing rather than underlying performance.

  1. Choose a period and use matching start and end dates for budget and actual figures.
  2. Enter or import actuals from reliable records, then check for duplicates, missing transactions, and incorrect category assignments.
  3. Compare category totals as well as the overall total; a small overall difference can hide large offsets between categories.
  4. Investigate notable variances and record a short explanation where useful, such as a one-time repair or a delayed invoice.
  5. Update the forecast only through a clearly labeled process. Do not overwrite the original budget if you need to preserve the plan for later comparison.

It can help to keep separate tabs for the monthly detail, a summary, and notes about assumptions. If you use one tab per month, keep the same category names and order to make comparisons easier. For a year-to-date view, add the same months or use a consistent transaction table; avoid mixing partial-month actuals with full-month budgets without labeling the period.

Making variances easier to interpret

A variance is a signal to ask a question, not a diagnosis by itself. An expense that is under budget may reflect savings, but it could also mean an invoice has not arrived or a planned purchase was postponed. An over-budget amount might be a genuine cost increase, a timing shift, or a budget assumption that needs revision. Add notes for material differences so the spreadsheet records the explanation as well as the number.

For expenses, a negative actual-minus-budget variance typically means spending was below plan; for income, a negative variance typically means income was below plan. Some organizations prefer a favorable/unfavorable column that reverses the sign for expense lines. Whichever approach you choose, label it clearly and apply it consistently. A reader should not have to guess whether red, green, positive, or negative indicates a problem.

In Excel for Microsoft 365 on Windows, you can use Home > Conditional Formatting > Highlight Cells Rules to emphasize values, or create a more tailored rule through Home > Conditional Formatting > New Rule. Set thresholds that suit your reporting purpose rather than coloring every tiny difference as urgent. A percentage variance can also be misleading when the budget is very small, so review the dollar amount alongside the percentage.

Common template problems and fixes

  • Totals do not match the source records: Confirm that the reporting dates, categories, and transaction range are consistent. Check for duplicate imports or omitted rows.
  • Formulas show as text: Ensure the cell is not formatted as Text, then re-enter the formula. A leading apostrophe can also cause Excel to display a formula rather than calculate it.
  • Percentage variance looks extreme: A tiny or zero budget can produce a dramatic percentage. Review the dollar variance and decide whether the percentage is meaningful for that category.
  • New rows are missing from totals: Expand the formula range or use an Excel table. To make a table, select the data and choose Insert > Table; confirm that the range includes the headings.
  • Positive numbers are interpreted inconsistently: Write the convention at the top of the sheet, such as actual minus budget, and distinguish income from expense categories.

Do not replace formulas with typed totals merely to make the sheet look right. Trace the inputs and ranges first. If you adjust the budget mid-period, preserve the original amount in a separate column or version; otherwise, the comparison may no longer show how actual results compared with the initial plan.

Excel template versus other options

A free Excel workbook is a good fit when one person or a small team needs a flexible, familiar file and can maintain it carefully. Excel tables, formulas, filters, and charts can support a useful review without specialized software. Excel for the web can be convenient for shared access, though the available features and workbook behavior may differ from the Windows desktop application.

A budgeting app may be more convenient for automatic transaction imports, while accounting software may connect budget comparisons with a business’s chart of accounts and reporting workflow. Those tools can have subscription fees, setup requirements, or features that are unnecessary for a simple monthly review. A paper worksheet or a basic spreadsheet in another program can also work if the process is small and the calculations are checked. The important choice is a method that keeps the budget, actuals, time period, and category definitions consistent.

Costs, privacy, and keeping a reliable copy

The template file itself may cost nothing, but consider the time needed to adapt it and verify its formulas. A free download is not automatically secure or suitable for confidential records. Store a workbook containing personal or business financial details in an approved location, limit access to people who need it, and follow any workplace data-handling rules. Do not include bank passwords or other authentication details in spreadsheet cells.

Save a clean starting copy before making structural changes. If several people edit the workbook, agree on who enters actuals and who checks formulas, and avoid having separate versions circulate without a clear source of truth. For important reporting, compare totals with the underlying statements or accounting records and keep dated copies of the budget versions you intend to preserve. This is practical recordkeeping, not financial, tax, investment, or legal advice; check real terms with the relevant lender or a qualified professional when a decision depends on them.

Frequently Asked Questions

Does Excel have a free budget vs actual template?
Excel’s File > New template gallery may offer budget-related templates, but availability and suitability vary. Check whether a template includes both budget and actual columns, variance calculations, and the reporting period you need.

What formula should I use for budget versus actual?
For a simple comparison, calculate actual minus budget. If budget is in B2 and actual is in C2, use =C2-B2 in the variance cell. State what positive and negative results mean, especially if the sheet includes both income and expenses.

How do I calculate percentage variance in Excel?
Divide the dollar variance by the budget. With budget in B2, actual in C2, and actual-minus-budget variance in D2, use =IF(B2=0,"",D2/B2), then format the result as a percentage. A zero budget has no meaningful percentage comparison, so review that case separately.

Is a positive budget variance good or bad?
It depends on the category and the sign convention. With actual minus budget, a positive expense variance usually means spending exceeded plan, while a positive income variance usually means income exceeded plan. Label the workbook so readers interpret the direction correctly.

Can I use the template in Excel for the web?
Many ordinary workbooks can be opened and edited in Excel for the web, but some desktop features may not be available or may behave differently. Check the workbook in the version you plan to use, particularly if it contains advanced features or macros.

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.