Syntha Lab RU

Actual vs plan variance

(Actual − plan) ÷ plan for the same slice and period

Open interactively →

Formula
(Actual − plan) ÷ plan for the same slice and period
Unit
%
Aggregation rule
Ratio of sums
Source system
ERP and accounting system; Plan and budget model
Owning role
Chief financial officer
Frequency
Monthly

Passport

Grain
Line or category × period
Numerator
Actual − plan
Denominator
Plan
At zero or no data
Plan is 0: “—”, not infinity.
Limits
One slice and one period for plan and actual. A plus on costs is bad, on revenue good: read the sign by the meaning of the line.
Check example
Actual, RUB: 5400000; Plan, RUB: 5000000. (a-b)/b*100. Result: 8.0%
Related metrics

Version 1.0 · valid from 2026-11-16 · checked 2026-11-16

Related pages

Definition

Plan versus actual, variance: the difference between actual and plan for a line. For income minus is worse, for costs plus is worse, so the sign must be read by effect on profit; the variance is analyzed by cause: volume, price, one-offs.

Suppose planned revenue is RUB 10 million and actual RUB 9.2 million: variance −RUB 0.8 million (−8%); costs plan 4m and actual 4.3m: effect on profit −0.3m. Analyze first the line with the biggest harm to profit.

Open interactively →