Rollstack
Get a demo

Budget vs actual presentation template, with the variance formulas

Slide 1 of 10

Rollstack team, reviewed by Nabil Jallouli Updated Nov 11, 2026

A budget vs actual review answers three questions: where did we land against plan, why, and what changes for the rest of the year. This template does that in 7 slides. Below it you'll find the variance formulas, the favorable vs unfavorable rules, and a way to send each department its own pack without building them one by one.

The 7 slides

#SlideWhat goes on it
1The headlineOne sentence: where you landed against budget and the main reason
2Summary tableRevenue, gross margin, operating expenses by category, EBITDA: actual, budget, variance, variance %, favorable or unfavorable
3Revenue bridgeA waterfall from budget to actual revenue, split by driver such as volume, price and mix
4Operating expensesSpend by department against budget
5Top variances explainedThe five largest variances, each with the owner's explanation
6Full-year outlookLatest forecast against budget for the year
7Actions and risksWhat changes, who owns it, by when
AAppendixCost-center detail and definitions

The file has 10 pages: these 7 slides plus a cover, an appendix and a how-to slide you delete before presenting.

The formulas

Variance = Actual − Budget

Variance % = (Actual − Budget) ÷ Budget

Example: budget revenue 2,000, actual 2,150. Variance = 150. Variance % = 150 ÷ 2,000 = 7.5%.

Favorable or unfavorable

LineActual above budgetActual below budget
Revenue and incomeFavorableUnfavorable
Costs and expensesUnfavorableFavorable

Three habits prevent most confusion:

  • Use the absolute value of the budget in the denominator when budgets can be negative, such as a planned loss. Otherwise the sign of the percentage flips.
  • Set a materiality threshold for what needs an explanation, for example a percentage and a fixed amount. Explaining every 1% wobble buries the variances that matter.
  • State your sign convention. Many finance teams flip the sign on cost lines so that a positive variance always means favorable. The template does this and says so in the source line. Whichever you choose, write it on the slide.

The variance workbook has these formulas built in, flags every variance above your threshold, and ties the cost-center detail back to the summary.

Writing the explanations

"Marketing was 12% over budget" is a restatement. A useful explanation says what drove it, whether it is timing or permanent, and what happens next: "Marketing was 12% over because the Q4 campaign launched in September instead of October. Timing only; full-year spend stays on budget."

One pack per department

Most finance teams send every budget owner a version of this review for their own cost center. Built by hand, that is the same deck copied and filtered 20 or 30 times every month.

In Rollstack:

  1. Open this template and connect your finance model in Excel, your ERP export or your Snowflake tables.
  2. Map the summary table, bridge and expense slides to their sources.
  3. Create a Burst with one variant per department or cost center. Each owner gets only their numbers.
  4. After close, refresh. Rollstack can draft the variance explanations from the data, labeled for each owner to correct and approve.
Get a demo

What our customers say

“We mapped our Tableau data to slides once with Rollstack. Now every executive report updates itself. It’s the part of our data stack we didn’t know was missing.”
Tyler DanzeyDirector, Finance Analytics, Tripadvisor
“We had a powerful data stack, but the last mile, getting our insights into the decision-maker’s hands, was still a manual process. Rollstack gave us the critical bridge to ensure our world-class analysis and insights made it into the decks where decisions were being made.”
Michael McElvaneySenior Director Finance Transformation, BI & Systems, SoFi
“The quarter ended, roughly 80 slides on the board deck, and I just clicked run—all updated. That used to take full days of copying and pasting.”
Matt CoxDirector of Strategy & Operations, Cribl

Common questions

How do you calculate budget vs actual variance?

Variance equals actual minus budget. Variance percentage equals that variance divided by the budget.

Is a positive variance good?

For revenue, yes. For costs, a positive variance means you spent more than planned, which is unfavorable.

How often should you present budget vs actual?

Monthly for management, quarterly for the board, with the same structure each time.

What chart works best for budget vs actual?

A waterfall from budget to actual shows which drivers moved the result. A bar chart of actual against budget by department shows where spend landed.

Get the template

Native PowerPoint charts and tables, sample data from a fictional company, and speaker notes on every slide. Using Google Slides? Upload the file to Drive and open it with Google Slides; charts arrive as pictures, everything else stays editable, so it's best in PowerPoint.

Discover more templates

About Rollstack.

Rollstack is the AI presentation platform for business reporting. It connects to data warehouses such as Snowflake, Databricks, BigQuery and Redshift, BI tools such as Tableau, Power BI and Looker, and spreadsheets such as Excel and Google Sheets. It also connects to CRMs such as Salesforce and HubSpot, PDFs and documents, and any other source through its API. It builds decks in your own PowerPoint or Google Slides template, links every number to its source, refreshes on a schedule, and creates one version per region, sales channel, team, product line or client. Teams build and edit decks in Rollstack, export them to PowerPoint, Google Slides or PDF, and each stakeholder gets their version in a personalized email. Rollstack is LLM-agnostic, access follows the permissions in your BI tools and warehouse, and it is SOC 2 Type II, HIPAA and GDPR compliant. Customers include SoFi, Tripadvisor, CarGurus and Octopus Energy.

Budget vs actual presentation template, with the variance formulas · 10 pages

Download