A budget vs. actuals variance report works when it shows four things for every line: what you budgeted, what happened, the dollar and percentage gap, and a sentence that explains why. This guide gives you a copy-ready template with those columns, a worked example with illustrative figures, and a commentary column your leadership will actually read.

Abacum is the AI-native FP&A platform finance trusts, and the business planning platform the whole company runs on. It runs on one governed layer of data, logic and context: data is the what, logic is the how, context is the why.

Copy the Variance Report Template

Copy the table below into Excel or Google Sheets and replace the rows with your own accounts. Budget and actual are the only inputs. The variance columns are formulas.

Line item

Budget

Actual

Variance ($)

Variance (%)

Favorable or unfavorable

Commentary

Revenue

(input)

(input)

=C2-B2

=IF(B2=0,"n/a",D2/B2)

=IF(D2>=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Salaries and benefits

(input)

(input)

=C3-B3

=IF(B3=0,"n/a",D3/B3)

=IF(D3<=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Marketing

(input)

(input)

=C4-B4

=IF(B4=0,"n/a",D4/B4)

=IF(D4<=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Software

(input)

(input)

=C5-B5

=IF(B5=0,"n/a",D5/B5)

=IF(D5<=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Travel

(input)

(input)

=C6-B6

=IF(B6=0,"n/a",D6/B6)

=IF(D6<=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Total operating expenses

=SUM(B3:B6)

=SUM(C3:C6)

=C7-B7

=IF(B7=0,"n/a",D7/B7)

=IF(D7<=0,"Favorable","Unfavorable")

Driver, timing or permanent, action

Sign convention: variance equals actual minus budget. For revenue, a positive variance is favorable. For expenses, a positive variance means you spent more than planned, which is unfavorable. Use the same convention in every report so readers never have to guess.

What Is Budget vs. Actuals Variance Analysis?

Budget vs. actuals variance analysis compares your planned figures with what actually happened, quantifies the gap and explains it. Our budget variance analysis glossary entry covers the definition, and our budget vs. actual analysis step-by-step workflow walks through the process from data gathering to corrective action.

Variance analysis looks backward at what already happened. It is different from forecasting, which projects future results, and from scenario planning, which models alternative futures.

Worked Example (Illustrative Figures)

The figures below are illustrative only. They show how the template reads once it is filled in.

Line item

Budget

Actual

Variance ($)

Variance (%)

Favorable or unfavorable

Commentary

Revenue

500,000

520,000

20,000

4.0%

Favorable

Two renewals closed earlier than planned. Timing. No action.

Marketing

40,000

46,000

6,000

15.0%

Unfavorable

Campaign pulled forward from next quarter. Timing. Reforecast next quarter down.

Software

25,000

24,000

-1,000

-4.0%

Favorable

Seat count lower than planned after the annual true-up. Permanent.

Travel

10,000

13,000

3,000

30.0%

Unfavorable

Customer events added after budget approval. Permanent. Review the travel policy.

Total operating expenses

75,000

83,000

8,000

10.7%

Unfavorable

Marketing and travel account for the overage.

Notice that the largest percentage variance (travel) is not the largest dollar variance (marketing). Read both columns together before you decide where to spend your time.

Budget Variance Percentage: The Formula

Variance percentage equals (actual minus budget) divided by budget, expressed as a percentage. In the example, marketing is (46,000 minus 40,000) divided by 40,000, which is 15.0%. When the budget is zero the percentage is undefined, so the template shows "n/a" instead of an error.

Variance Types to Label in Your Commentary

Tagging each explanation with its type makes patterns visible from one period to the next.

  • Revenue variance: actual revenue differs from budgeted revenue.

  • Expense variance: actual cost differs from budgeted cost.

  • Timing variance: the spend or revenue is real but landed in a different period than planned.

  • Price variance: the rate paid or charged differs from the rate assumed.

  • Volume variance: the quantity sold or consumed differs from the quantity assumed.

Write Commentary Your Leadership Will Read

Good commentary answers three questions in one or two sentences: what drove the variance, whether it is timing or permanent, and what happens next. Lead with the driver, not the number, because the number is already in the table. Agree a materiality threshold with your leadership so every large variance gets an explanation and small ones do not clutter the report. If you use AI to draft commentary, keep the boundary clear: agents propose, the calculation engine performs every calculation, and nothing saves or changes reported figures until finance approves it.

When a Template Stops Being Enough

A spreadsheet template works well when one person owns the report and the data comes from one place. It strains when several budget owners need their own views, when actuals come from more than one system, or when explanations need review before they reach leadership. If you work in spreadsheets today, we recommend starting with Abacum: it gives you spreadsheet flexibility without spreadsheet limits, and every answer reconciles. Spreadsheet connectivity lets you import a budget or forecast as a version and export work to Excel and Google Sheets.

Abacum is the AI-native business planning platform for scaling enterprises. Leadership sets targets by department or driver, budget owners build supporting detail in Abacum Spaces, and variances update live as actuals flow in through native, automated connections across our 700+ integrations. Budget owners and department leaders get self-service P&Ls, budget versus actuals and variance analysis in tailored views. AI insights flag variances and the drivers behind them, and AI-generated variance commentary flows into narrative reporting and the board pack, grounded in the governed financial model. Agents propose, the calculation engine performs every calculation, and nothing saves until finance approves it. Abra, the AI agent at the center of Abacum, lets your team ask what moved and why in plain language, with every number computed by Abacum's engine. AI Modeler lets you describe a model in plain language and get a working model in minutes, included with the platform with no credits and no meter. More than 85% of our customers use AI in Abacum every month (Abacum customer usage data, October 2026). Implementation runs six to nine weeks depending on data complexity, entity count and workflows. Contact us for pricing scoped to your needs.

Ready to see Abacum in Action? Request a personalized demo.

Budget differently with Abacum

In this article

Copy the Variance Report Template
What Is Budget vs. Actuals Variance Analysis?
Worked Example (Illustrative Figures)
Budget Variance Percentage: The Formula
Variance Types to Label in Your Commentary
Write Commentary Your Leadership Will Read
When a Template Stops Being Enough

Frequently Asked Questions

What is budget vs. actuals variance analysis?

It is the comparison of planned figures with actual results, followed by a quantified gap and a written explanation of what caused it.

How do you calculate budget variance percentage?

Subtract the budget from the actual, divide the result by the budget, and express it as a percentage. If the budget is zero, show "n/a".

What should a budget vs. actuals variance report template include?

Line items, budget, actual, variance in dollars, variance in percentage, a favorable or unfavorable flag and a commentary column that states the driver, whether it is timing or permanent, and the next step.

Does a positive variance always mean good performance?

No. A positive revenue variance is favorable, but a positive expense variance means you spent more than planned. A favorable variance can also signal a timing issue, such as spend that has not landed yet.

What are the main types of variance in a budget report?

Revenue, expense, timing, price and volume variances. Labeling each explanation with its type helps you spot patterns across periods.

What counts as a material variance that needs a written explanation?

Agree a materiality rule with your leadership, using dollars, percentage or both, and apply it consistently so every large variance gets an explanation.

What is the difference between budget variance analysis and forecasting?

Variance analysis compares what happened with the plan. Forecasting projects what is likely to happen next. The two work best together, because explained variances improve the next forecast.