Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 5 of 6

Plan/actual variance reporting

9 min

Listen to this lesson

0:00 / 8:13

The monthly cost center review is where planning and postings meet. The plant manager opens the plan/actual report for Detroit Maintenance and sees: plan $48,000 for period 5, actual $55,600, variance $7,600 or 15.8% over plan. The number is the start of a conversation, not the end of one. The controller's job is to explain it: which accounts, which postings, which causes, and whether anything must be corrected.

  1. Open the reportCost Centers - Plan/Actual for cost center 17101102, period 5, plan category Budget
  2. Find the accountsWhich G/L accounts carry the variance? Here: external repair services and maintenance materials
  3. Drill to line itemsOpen the postings behind the accounts: documents, suppliers, dates, users
  4. Classify the causePrice, volume, one-off event, timing, misposting or missing allocation
  5. ActCorrect errors, explain real variances, adjust the forecast if needed
From variance to explanation.
The Sign-Off Table · thesignofftable.com/academy/sap-co-201

Where to report

SAP's learning material names the Cost Centers - Plan/Actual Fiori app for this comparison and the Query Browser for ad-hoc reporting on analytical queries. Both belong to SAP S/4HANA embedded analytics, which reads Universal Journal data directly through CDS views without copying it, so a reposting made at 10:00 shows in the report at 10:01. Classic report transactions are also still used in many private edition systems; whichever report Contoso uses, the test is the same: does the report show what was posted?

Classifying the causes

CauseWhat it looks likeContoso period 5 exampleAction
One-off eventA single large posting not in the plan$5,200 emergency repair of a test benchExplain; consider a forecast update
MispostingA posting that belongs elsewhere$2,400 Chicago parts on DetroitRepost the line item
PriceSame quantities, higher pricesLakeside Components parts up 4%Explain; review the plan basis
VolumeMore activity than plannedExtra shift maintenance in a busy monthExplain; link to production volume
TimingCost in the wrong month, not the wrong yearQuarterly service invoice booked in one monthConsider accruals for smoother periods
Missing allocationSender or receiver totals off after period endEnergy distribution not yet runRun or fix the allocation cycle

Common variance causes and responses.

Working the example: $5,200 emergency repair plus $2,400 misposted parts explains $7,600 exactly. After the reposting, Detroit Maintenance is $5,200 over plan for a documented one-off reason, and Chicago Maintenance shows the $2,400 it really consumed. The misposting was not a performance problem in Detroit at all, which is why the drill-down matters before anyone draws conclusions.

Drilling the $7,600 variance to line items splits it into a real one-off cost and a misposting that belongs to Chicago.
The Sign-Off Table · thesignofftable.com/academy/sap-co-201
  1. Is the variance above the review threshold (for example $2,000 and 5%)?No → no explanation needed this month · Yes → continue
  2. Is it caused by a posting that belongs to another cost object?Yes → repost, then re-run the report · No → continue
  3. Is it a timing difference within the year?Yes → note it; consider accruals for irregular costs · No → continue
  4. Is it a real price, volume or one-off effect?Yes → explain it to the manager; update the forecast if it will continue
Contoso's variance review routine.
The Sign-Off Table · thesignofftable.com/academy/sap-co-201

Timing and accruals

Irregular costs make monthly variances noisy: a quarterly service invoice makes one month look terrible and the next two look excellent. SAP's material describes accrual calculation in controlling for this purpose, with methods such as percentage, plan equals actual, and target equals actual, so that irregular expenses are spread across periods. Contoso uses it for annual bonuses on its production cost centers; the service contract remains a timing note in the review.

MonitorSmall and unexplained: watch the trend next month
IgnoreSmall and explained: no action
Investigate nowLarge and unexplained: drill to line items before the review meeting
Report and actLarge and explained: correct mispostings, update forecasts, inform the manager
Prioritizing variances in the monthly review.
The Sign-Off Table · thesignofftable.com/academy/sap-co-201

What would you do?

Detroit Maintenance is $7,600 over plan in period 5. The plant manager wants to cut overtime immediately. What should the controller do before that decision?

Key points
  • Plan/actual reports start the conversation; drill-down to line items explains it.
  • SAP names the Cost Centers - Plan/Actual app and the Query Browser for this reporting.
  • Classify variances: one-off, misposting, price, volume, timing, missing allocation.
  • Correct mispostings by reposting before judging performance.
  • Use thresholds to focus the review; use accruals for irregular costs.

Check your understanding · not graded

Lesson check

  1. 1. Which Fiori app does SAP name for comparing plan and actual cost center values?

  2. 2. A variance is caused by a posting that belongs to another cost center. What comes first?

  3. 3. What do accruals in controlling help with?

  4. 4. Why does a reposting show in the embedded report almost immediately?