Syntha Lab RU

Income and expense budget: plan versus actual

Combines plan and actual of the profit and loss statement, shows variances by line and what drove the profit.

Forecast and budget For whom: Finance directors and owners: monthly and quarterly control.

Calculate on your data →

At a glance

What question does it answer?
How far actual deviated from plan and which line affected profit most.
What data is needed?
Revenue and cost of goods: plan and actual.
How to read the result?
The chart bars show each line’s effect on profit: minus is worse than plan. Begin with the most harmful line: volume, price or one-off costs. Example on the default values: Revenue of RUB 44.5m against a plan of RUB 48m (−7.3%), gross margin 51.9% and expenses 6.8% above plan. Profit is RUB 4.63m instead of RUB 9.1m: minus RUB 4.47m, with “Revenue” affecting it most (RUB 3.5m below plan). If revenue is the main factor, split it into price, volume and mix; if expenses, look for one-off costs. Next: “Revenue analysis: price, volume and mix” and “Profit and loss statement and profitability”.

Why and how to reason

Comparing plan and actual is not about finding the guilty but about understanding what changed profit. For this each line’s deviation is converted into its effect on profit. For income it is actual - plan: less revenue means minus. For costs the opposite, plan - actual: more cost means minus. Then all deviations can be summed.

Profit = revenue - cost of sales - total expenses. The profit deviation equals the sum of the line effects.

Example. Plan: 48 - 21.6 - 17.3 = RUB 9.1 m. Actual: 44.5 - 21.4 - 18.47 = RUB 4.63 m. Deviation -RUB 4.47 m. Revenue -3.5 m, cost of sales +0.2, expenses -1.17: marketing gave -0.9 m, staff -0.3. Revenue is 7.3% below plan and expenses 6.8% above: both sides worsened the result.

When to use it

It fits after closing a period: a month, quarter or season, to define which lines need review. It does not show the cause of a deviation, only its size: look for causes in sales, assortment and costs. Assumption: plan and actual are built on the same basis (with or without VAT, the same lines). If you changed the accounting structure, reconcile. Keep the plan unchanged so the comparison is fair.

How to read the result

Look first at the profit deviation, then at lines with the biggest effect. If revenue is below plan, check whether variable costs fell accordingly; if not, they eat profit. A cost above plan is not always bad: marketing may have delivered sales. Compare with gross margin: it shows the quality of sales. Decision: assign owners for the largest deviations, revise the forecast for the rest of the year and adjust costs. Split deviations into controllable (marketing, staff) and external (demand, rate): the first can be fixed at once, the second should be built into the plan. It is worth checking the year-to-date total against the forecast so as not to lose the picture.

Common mistakes

The usual mistakes: comparing a plan with VAT to an actual without; mixing the sign of deviation for income and costs; setting a plan with no allowance; explaining a deviation with “external factors” without checking. Also: comparing cumulative totals when the months' structures differ. Also: changing the plan retroactively. Also: not revising the plan after obvious changes.

What data is needed?

  • Revenue and cost of goods: plan and actual.
  • Expense lines: plan and actual (can be added and excluded).
  • Where to take it: the plan from the approved budget; actual from the management profit and loss report for the same period (1C, ERP, accounting); name expense lines identically in plan and actual. Amounts excl. VAT. Enter revenue and cost first, then expense lines.

Inputs

FieldUnitValue in the exampleMeaning
Revenue: plan₽48,000,000Planned revenue for the period excl. VAT: from the approved budget or sales plan; the actual revenue is compared with it.
Revenue: actual₽44,500,000Actual revenue for the period excl. VAT; if there were no sales enter 0: ratios to plan show a dash.
Cost of goods sold: plan₽21,600,000Planned cost of goods sold for the period, per the budget.
Cost of goods sold: actual₽21,400,000Actual cost of goods sold for the period, from accounts.

How it is calculated

StepFormula
ProfitRevenue − cost of goods − total expenses
Effect of a line on profitFor income: actual − plan. For costs: plan − actual

Worked numbers

Default values from the app; in the interactive version you enter your own.

Profit: actual
4.63 m ₽Revenue − cost of goods − expenses, before income tax.
Profit: plan
9.1 m ₽
Profit variance
−4.47 m ₽
Revenue vs plan
−7.3 %
Gross margin: actual (plan)
51.9 % (55 %)Actual first, plan in brackets.
Expenses: actual vs plan
6.8 %

Plan versus actual

LinePlanActualVarianceIn percent
Revenue48 m ₽44.5 m ₽−3.5 m ₽−7.3 %
Cost of goods sold21.6 m ₽21.4 m ₽−200,000 ₽−0.9 %
Rent4.2 m ₽4.2 m ₽0 ₽0 %
Staff6.8 m ₽7.1 m ₽300,000 ₽4.4 %
Marketing3 m ₽3.9 m ₽900,000 ₽30 %
Logistics1.8 m ₽1.95 m ₽150,000 ₽8.3 %
Other1.5 m ₽1.32 m ₽−180,000 ₽−12 %
Profit9.1 m ₽4.63 m ₽−4.47 m ₽−49.1 %

Profit is 4.47 m ₽ below plan. The biggest effect came from “Revenue”: 3.5 m ₽ worse than plan. Look at it first: volume, price or one-off costs.

Nuances and limits

  • Amounts exclude VAT; income tax is not deducted.
  • Corporate income tax is not deducted: profit here is pre-tax, reconcile with the report on the same basis.
  • Compare plan and actual for the same period and under one method of recording expenses.

Terms used

Calculate on your data →