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.












