Integrations

One card per source category, data flows in from anywhere.

View all integrations →

The Agentic Layer

The governed foundation — platform capabilities.

Reporting & Analysis

Business performance tracking, variance, and analytical insight.

See all →

Planning & Modeling

A comprehensive look at forward-looking corporate financial strategy.

See all →

Consolidation & Close

The entire financial close and data management cycle, at a high level.

See all →
Reporting & analysis

Variance analysis traced to the transaction.

Cube runs variance analysis on live actuals. It finds what moved, explains why in plain language, and traces every figure to the GL transaction behind it, so the answer is ready before the meeting starts.

ERP / GLActuals
CRMBookings
HRISHeadcount
PlanFY budget
CubeOpex · actual vs plan
$1.55M+$84K vs plan, explained
ActualsForecast →
Behind the variance
March opex=Plan $1.47M+ Price effect $61K+ Volume effect $31K− Timing $8K
Thousands of finance professionals, in every industry, run on Cube
The problem

The number moved. Nobody can say why yet.

The CFO asks why opex is up 6.5%. Finance exports the GL, rebuilds the BvA, and digs through transactions while the meeting gets closer.

BvA_March_FINAL_v3.xlsxGL export from last TuesdayBvA ≠ GL by $84K

The data is stale

A BvA built on last week’s export is wrong by Friday, and nobody knows which version is current.

The what, not the why

“Opex is up 6.5%” states the change. Finding the vendors, accounts, and owners behind it takes days.

Mapping breaks the math

Accounts map differently across reports, so variances appear that don’t exist and real ones hide.

The solution

Variance analysis that explains itself.

Cube keeps actuals live, traces every change to its drivers, and maps accounts once, so the why arrives with the number.

The data is stale

Actuals that stay live

The GL syncs on a schedule, so the BvA is current every time it opens.

The what, not the why

The why comes with it

Every variance traces to vendors, accounts, and owners in one click.

Mapping breaks the math

One mapping, every report

Accounts map once in Cube, so variances are real.

Why teams choose Cube

The why behind every number, before anyone asks.

Live, not last week

Actuals stay synced, so the BvA is current the moment the books update.

The why, in plain language

Smart Analysis finds the vendors, accounts, and owners behind each move and writes it up.

One click to the source

Every variance opens to the transactions behind it, so the answer holds up in the boardroom.

Every variance opens.

The CFO asks why cloud and software is over plan. In Cube, the +$84K is one click from the invoices behind it.

A glass bar opening into threads that lead to individual transactions
Drilldown
Cloud and software · March+$84.0K vs plan
Price effect+$61.5K
Headcount+$22.5K
Jul 06CloudStack · annual renewal$184.0K
Jul 08DesignHub · seat true-up$96.5K
Jul 09DataPipe · new contract$72.0K
+ 9 more invoices
Source: ERP / GL
Workflows

Where teams put variance analysis to work.

Monthly BvA

Budget vs actual by account, owner, and entity, on live actuals.

Variance commentary

Drivers and commentary written next to each number.

Board variance reporting

The deck pulls the same governed variance the team reviewed.

Forecast accuracy

Track how the last reforecast held up and feed it into the next.

Price, volume, and mix

Margin shifts untangled into cost, price, volume, and mix effects.

Variance by category

Each category explained against its own plan line.

One connection

Variance on live actuals.

The GL, CRM, and HRIS each hold part of the answer. Cube unifies them in one governed layer, so plan and actual always compare on the same mapping.

Your sources
Where it shows up
ERP / GL
Actuals by account
CRM
Bookings and pipeline
HRIS
Headcount and comp
Spreadsheets
Headcount
Budget vs actual
By owner and account
Variance commentary
Drivers, in plain English
Board deck
One explained number

One governed model that turns variance into operating intelligence. Accounts are mapped once, plan and actual compare on the same structure, and every figure traces to the transaction.

Mapped onceTraced to the transaction

The BvA that explains itself.

Actuals land from every connected source on the schedule you set. Cube compares them to the plan of record, splits each variance into its drivers, and writes the explanation next to the number.

Behind every cellGoverned formula
Actual =
PlanApproved budget · Cube model
+ Price effect(actual rate − plan rate) × actual volume
+ Volume effect(actual volume − plan volume) × plan rate
+ TimingSpend landing in a different month than planned
Variance % = (actual − plan) ÷ plan, by owner, account, and vendor
Watch a variance explain itself.
Bring last month’s toughest variance. On the demo, we find the drivers live and trace the figure to the transactions behind it.
Where you work

One explained variance, on every surface.

Cube connects the systems where your data lives to the tools where decisions happen. When a number changes in Cube, it updates in the spreadsheet, the board deck, the dashboard, and the answer in Slack or Claude. Everyone keeps their own view and permissions, and every figure traces back to the transaction.

See it on your numbers.
On the demo, we connect a source, publish a number once, and show it land in a spreadsheet, a deck, and chat.
AI Agents

Your digital finance team works while you sleep.

Four FP&Agents handle the always-on work across your data, reports, plans and business partners. Agents scale finance's capacity, while the people remain in control.

Before your first coffee
6:00 AM Actuals synced into your Excel model.
6:04 AM March bookings variance explained in #sales-leads.
6:10 AM Board deck refreshed with the latest numbers.
6:15 AM Q3 forecast rerun on new pipeline data.
9:00 AM CEO asks in Teams what changed. Answered.
Security & governance

Board-ready means audit-ready.

Delivering numbers everywhere only works if access travels with them. In Cube it does, enforced in the layer rather than in each tool.

Security & compliance
Every export, governed.

Every AI feature respects your permissions, and every edit, sync, and publish lands in one audit trail.

SOC 1 & 2
Type 2
Certified
HIPAA
Compliant
Certified
Every edit
Tracked
To the source
Role-based access
CFO, VP and auditor views from one source.
CFO
VP Sales
Permissions on every view
User-level access wherever your numbers show up.
Viewing as David
Marketing$1.24M
Sales
Full audit trail
Who, what, when, before and after.
Maya edited Q3 rent2:14 PM
David approved forecast2:31 PM
SSO
Okta, Microsoft Entra, Google.
Single sign-on enabled

See every variance explained on your own numbers.

Turn variance into action. Bring last month’s toughest one: we find the drivers live and trace the figure to the transactions behind it.

FAQs

Variance analysis questions, answered.

What is variance analysis?

Variance analysis compares actual results to budget or forecast, quantifies the differences, and explains why they happened so leadership can act. In Cube, it runs on live actuals and every explanation traces to the transactions behind it.

What is the difference between variance analysis and variance reporting?

Variance reporting shows the differences between plan and actual. Variance analysis explains them: which drivers, accounts, and owners caused each move. Cube does both from the same governed numbers.

How do you automate variance analysis?

Connect actuals to the plan so they sync on a schedule instead of through exports, map accounts once, and let the system split each variance into drivers. In Cube, Smart Analysis finds what moved and drafts the commentary for review.

What is the best variance analysis software?

The best variance analysis software runs on live actuals, maps accounts once so plan and actual compare cleanly, explains each variance in plain language, and drills every figure to the transaction. Cube does this as the Agentic FP&A Platform, in the spreadsheets, decks, and chat tools your team already uses. 

What should you look for in variance analysis software?

Look for live connections to your ERP and other sources; one governed account mapping; driver breakdowns such as price, volume, and mix; AI commentary you can review; drilldown to transactions; role-based access for owners; and audited security such as SOC 1 and SOC 2. Also check whether people can work in Excel, Google Sheets, or Slack, since that decides adoption.

How do you explain a budget variance?

Quantify the gap, split it into drivers such as price, volume, timing, and mix, and point to the transactions behind each. In Cube, the Analyst agent does this and writes the explanation in plain language for finance to review.

What is the variance formula?

Dollar variance is actual minus plan. Percentage variance is that difference divided by plan. Cube calculates both on every account and dimension and keeps the logic visible.

What data do you need for variance analysis?

You need GL actuals by account and department, the approved budget or latest forecast, and operational drivers such as headcount, bookings, and usage. Cube connects to hundreds of source systems across ERP, CRM, HRIS, and data warehouses.

What is a favorable vs unfavorable variance?

A favorable variance helps profit, such as revenue above plan or costs below it. An unfavorable variance hurts profit. Cube flags both and shows which drivers caused them.

How often should you run variance analysis?

Most teams run it monthly after close. With Cube, actuals sync on the schedule you set, so variance updates as soon as numbers land, and FP&Agents flag large moves overnight.

Can department heads see their own variances?

Yes. Cube uses role-based permissions, so cost-center owners see their own variances while finance sees the whole model. They can check in Cube Web, Excel, Google Sheets, Slack, or Teams, from the same governed source.

Does variance analysis software replace Excel?

No. Teams keep working in Excel or Google Sheets, with live, governed actuals flowing in and edits publishing back to the model. Cube replaces the exports and rebuilds, not the spreadsheet.

Is AI variance commentary reliable?

It is when it runs on governed data. Cube’s commentary is grounded in your chart of accounts and business logic, every figure traces to the transaction, and finance reviews it before it ships. Cube is SOC 1 and SOC 2 Type 2 audited.

Still have questions? See it on your own variance.
Start here

What is variance analysis?

Variance analysis compares actual results to budget or forecast, quantifies each difference, and explains why it happened. Done well, it runs continuously on live actuals.

The answer usually spans the GL, CRM, and HRIS, so it only works when they are connected. Cube brings them into one governed model.

Budget

Budget vs actual

Actual results against the approved annual budget.

Forecast

Forecast vs actual

Actuals against the latest reforecast, to measure accuracy.

Prior period

Period over period

This month against last month or last year.

Drivers

Price, volume, and mix

Each variance split into the effects that caused it.

Why variance analysis matters

The window between close and the board meeting is short. A variance explained early lets leadership act on it, and one explained late becomes an explanation for why nothing changed.

How to run a variance analysis

The same five steps apply whether the forecast lives in a spreadsheet or in Cube.

  1. 1.
    Map accounts once. Use one chart-of-accounts mapping for plan and actual.
  2. 2.
    Sync actuals. Load actuals by account, department, and entity.
  3. 3.
    Calculate the variance. Dollar and percentage, against budget and forecast.
  4. 4.
    Find the drivers. Split each move into price, volume, timing, and mix.
  5. 5.
    Explain and act. Write the commentary, trace it to the source, and feed it into the forecast.

Key variance metrics

Budget vs. actual
Actual minus plan for a period.
Variance %
Variance divided by plan.
Favorable vs unfavorable
Results above or below plan that help or hurt profit.
Price variance
Rate difference times actual volume.
Volume variance
Volume difference times plan rate.
Forecast accuracy
How close the last reforecast landed to actuals.

Variance analysis in a spreadsheet vs. Cube

Spreadsheet Cube
Answers Why did this number move? Answered live, traced to the transaction.
Built from GL exports pasted by hand. Live connections to every source.
Cadence Monthly, after close. On the schedule you set.
Accuracy depends on Whoever built the mapping. One governed mapping.
Access A shared file nobody trusts. Role-based views for each owner.