Revenue Is Up. Cash Is Down. Trace the Drivers and Decide What to Fix.

Entimema Analysis 16: an amber evidence line passes through glass margin and working-capital control chambers between a rising revenue plane and a receding cash reservoir, resolving at a decision plane.

The monthly meeting opens with an apparently favourable result: revenue is 10% above budget. Then the CFO turns the page. Gross margin has fallen from 32% to 28%, EBITDA is below plan and operating working capital has consumed far more cash than expected. The management team has one hour and three competing interventions: change pricing, correct production cost or accelerate collections.

Which comes first? Revenue alone cannot answer. Neither can a margin percentage, an ageing report or a cash balance viewed in isolation. The first page of a useful CFO monthly reporting pack must connect the outcome to its drivers, distinguish evidence from explanation and make the decision explicit.

Revenue is up. Cash is down. What should the CFO fix first?

Consider Meridian Components, a fictional mid-sized manufacturer. All company details, reports and figures in this article are synthetic. The reporting period is September, all monetary values are EUR thousands unless stated otherwise, and favourable variances are shown as positive. Cash uses are shown in parentheses.

September revenue is EUR 11.0 million against a EUR 10.0 million budget. But gross profit is EUR 3.08 million rather than EUR 3.20 million, EBITDA is EUR 1.18 million rather than EUR 1.40 million and operating cash is negative EUR 0.45 million rather than positive EUR 0.60 million. Management cannot responsibly choose an intervention until those movements form one reconciled explanation.

The purpose of the pack is therefore not to present every available number. It is to compress a controlled model into a decision surface: outcome, variance, driver, evidence, action, owner and follow-up measure.

What should a monthly management reporting pack include?

A monthly management reporting pack should include an executive first page with material outcomes and required decisions; comparable P&L, Balance Sheet and cash views; actual, budget, forecast and prior-period context; reconciled variance and cash bridges; operational drivers; working-capital and liquidity analysis; material exceptions and limitations; evidence-linked commentary; and an action register with owners, deadlines and success measures.

That answer defines the minimum information architecture, not a fixed page count. A compact pack can be complete if every executive conclusion drills into controlled evidence. A long pack can still be incomplete when it shows variances without mechanisms or recommendations without accountability.

ENTIMEMA FRAMEWORKA decision-led management reporting pack structureMove from executive compression to evidence without breaking the link between them.
  1. First page: material outcomes, drivers, decisions and actions.
  2. Financial bridges: revenue to margin and EBITDA; EBITDA to operating cash.
  3. Driver pages: price, volume, mix, input cost, efficiency, receivables, inventory and payables.
  4. Evidence and control appendix: source schedules, reconciliations, exceptions, definitions and approvals.

The numbers should be prepared through a controlled close, mapping and reconciliation process. The Month-End Reporting Workflow explains that preparation layer. The pack in this article begins where those controlled numbers become management information.

The first page makes the decision visible

Meridian’s first page does not attempt to reproduce the full financial statements. It selects six connected outcomes and states the current best-supported driver and the action required. Variance is Actual minus Budget. For margin, the variance is shown in percentage points.

Synthetic CFO pack — first page, September (EUR '000 unless stated)
MeasureActualBudgetVarianceDriverAction
Revenue11,00010,000+1,000 / +10.0%Higher volume; weaker price and mixTest contribution by customer and product
Gross profit3,0803,200(120) / (3.8%)Growth benefit offset by material cost and mixValidate price, usage and discount effects
Gross margin28.0%32.0%(4.0) ppMaterial price, yield loss and low-margin mixSeparate evidenced drivers from hypotheses
EBITDA1,1801,400(220) / (15.7%)Gross profit (120); operating cost (100)Protect margin and review discretionary spend
Operating working-capital movement(1,350)(500)(850)Receivables (600); inventory (250)Prioritise collectible overdue exposure
Operating cash(450)600(1,050)EBITDA (220); working capital (850); tax +20Recover cash and update the liquidity outlook

The page already changes the meeting. Pricing, production and collections are no longer three unsupported opinions. They are candidate actions attached to different parts of the financial mechanism. The next step is to prove that the bridge between those parts reconciles.

Bridge the revenue gain to the EBITDA shortfall

Start with budget gross profit of EUR 3.20 million. Apply the budget gross margin of 32% to the EUR 1.00 million revenue upside: if incremental revenue had carried the planned economics, it would have added EUR 0.32 million of gross profit. It did not. A four-percentage-point margin shortfall across actual revenue of EUR 11.00 million removes EUR 0.44 million. The net gross-profit variance is therefore positive EUR 0.32 million minus EUR 0.44 million, or negative EUR 0.12 million.

Revenue and margin bridge to EBITDA — September (EUR '000)
Bridge itemCalculationEffectRunning result
Budget gross profit10,000 × 32%—3,200
Revenue above budget at budget margin1,000 × 32%+3203,520
Margin dilution on actual revenue11,000 × (28% − 32%)(440)3,080
Actual gross profit11,000 × 28%—3,080
Operating-cost variance1,900 − 1,800(100)—
EBITDA varianceGross profit (120) + operating cost (100)(220)—
Actual EBITDABudget EBITDA 1,400 − 220—1,180

The EUR 0.44 million margin dilution is then decomposed in the supporting schedule: EUR 0.21 million adverse material-price effect, EUR 0.13 million adverse material-usage effect and EUR 0.10 million adverse realised-price and mix effect. These are additive effects under the company’s approved bridge convention. No residual is hidden; 210 + 130 + 100 equals 440.

This distinction matters. Revenue growth contributes EUR 0.32 million at the budget margin, but the economic quality of that growth and production inputs remove EUR 0.44 million. “Sales exceeded budget” is true and still unsafe as an executive conclusion.

Bridge EBITDA to the cash shortfall using a defined scope

The cash bridge covers September only and starts from EBITDA. It includes movements in trade receivables, inventory and trade payables, then cash tax and cash interest. It excludes capex, debt drawdowns and repayments, dividends, equity flows, foreign-exchange movements and opening cash. Those excluded items belong in the full cash-flow and liquidity view; they must not be silently mixed into operating conversion.

EBITDA to operating cash bridge — September (EUR '000)
Bridge itemActualBudgetVariance
EBITDA1,1801,400(220)
Trade receivables movement(900)(300)(600)
Inventory movement(600)(350)(250)
Trade payables movement+150+150—
Operating working-capital movement(1,350)(500)(850)
Cash tax(160)(180)+20
Cash interest(120)(120)—
Operating cash(450)+600(1,050)

The table reconciles in both columns. Actual operating cash is 1,180 − 1,350 − 160 − 120 = negative 450. Budget operating cash is 1,400 − 500 − 180 − 120 = positive 600. The EUR 1.05 million cash shortfall consists of EUR 0.22 million lower EBITDA, EUR 0.85 million additional working-capital consumption and EUR 0.02 million favourable tax timing.

The largest immediate variance is not EBITDA. It is receivables. That does not prove that collections caused the margin decline; it proves that collections is the largest evidenced short-term cash lever in this bridge.

Defend one material finding down to a source-schedule row

The executive finding reads: gross margin fell four percentage points because EUR 0.34 million of adverse material economics and EUR 0.10 million of realised-price and mix dilution more than offset the gross-profit benefit of higher revenue. The EUR 0.34 million material effect must be traceable, not merely plausible.

Synthetic production-cost detail — primary alloy, September
Source-schedule fieldValueController check
Standard quantity allowed for actual good output2,400 tonnesApproved standard and confirmed good output
Actual quantity consumed2,500 tonnesIssues less returns, reconciled to inventory movement
Standard priceEUR 1,300 / tonneEffective standard-cost version
Actual purchase priceEUR 1,384 / tonneInvoices, receipts, freight and currency treatment
Material-price variance2,500 × (1,384 − 1,300) = EUR 210k adverseQuantity and price basis consistent
Material-usage variance(2,500 − 2,400) × 1,300 = EUR 130k adverseNo cut-off, scrap or WIP distortion
Total material varianceEUR 340k adverseAgrees to the gross-margin bridge

The controller can confirm the arithmetic deterministically. The controller cannot yet confirm the full cause. Before attributing the EUR 0.13 million usage variance to poor production efficiency, the team must test inventory cut-off, bill-of-material version, scrap recording, rework, work in progress, production mix, units of measure and unrecorded material returns. The value may be validated while the operational explanation remains under review.

This is the standard for a defensible finding: observed result, reconciled calculation, source location, current interpretation, alternative explanations, unresolved checks and the decision consequence if the explanation changes.

The failure mode: treating growth as improvement

If management stops at the 10% revenue increase, the likely response is to protect momentum and defer intervention. The pack changes that decision because it tests two conversions: revenue into gross profit, and EBITDA into cash. Both conversions deteriorated.

Why the positive sales headline changes
Initial signalMissing testEvidenceDecision consequence
Revenue is 10% above budgetDid growth retain planned margin?Gross margin is 28%, not 32%Do not reward volume without contribution
EBITDA remains positiveDid profit convert into cash?Operating cash is EUR 450k negativeProtect liquidity before expanding commitments
More customer demandWhen will invoices become cash?Receivables consumed EUR 600k more cash than planPrioritise collectible overdue exposure

A further analytical error would be to assign the entire cash shortfall to weak collections. Higher September sales mechanically create some receivables before collection. The receivables schedule must separate current invoices consistent with agreed terms from overdue, disputed and concentrated balances. Only then can management distinguish growth financing from collection failure.

Validate the pack before the meeting, then challenge the explanation

The controller’s pre-meeting release gate should prove that the P&L agrees to the validated ledger view; revenue, gross profit, operating cost and EBITDA bridge without unexplained residuals; working-capital movements agree to opening and closing Balance Sheet balances; signs and units are consistent; cash-tax and interest payments agree to bank or cash records; source schedules use the same entity, period and currency; and every manual adjustment retains an owner and evidence.

Analytical validation comes next. Test whether price, volume and mix use an approved allocation convention; whether standards are effective for the reporting period; whether the receivables movement separates volume, timing, overdue balances and disputes; whether inventory quality and cut-off are visible; and whether commentary states causal conclusions more strongly than the evidence permits.

The design of findings, materiality and action ownership is developed further in Management Reporting for CFO Decisions.

The management meeting ends with an owned decision record

The CFO approves collections as the first intervention. It addresses the largest evidenced short-term cash variance—EUR 0.60 million adverse versus budget—and can improve liquidity sooner than a production redesign or broad repricing programme. This priority does not declare production cost unimportant. It separates an immediate cash action from a material causal question that still requires validation.

Synthetic management-meeting decision record
Decision or actionWhy nowOwnerDeadlineNext-cycle proof
Execute a targeted collection plan for overdue, undisputed balancesReceivables explain EUR 600k of the cash varianceCredit Controller10 business daysCash collected; overdue balance; DSO bridge; broken promises
Validate the EUR 130k material-usage variance before changing production standardsArithmetic is proven; operational cause is notPlant Controller with Operations Director5 business daysConsumption-to-output reconciliation; scrap and WIP evidence; kg per good tonne
Review low-margin orders and discount exceptions; approve targeted corrections onlyPrice and mix removed EUR 100k, but broad repricing could damage profitable volumeCommercial DirectorBefore next order cycleRealised net price; contribution margin by customer and product; retained volume
Update the 13-week liquidity outlookSeptember operating cash missed plan by EUR 1.05mTreasury Lead2 business daysWeekly trough, headroom and collection scenarios reconciled to opening cash

The record distinguishes decision, investigation and monitoring. The collection action is approved. The production explanation is assigned for validation. Pricing is targeted rather than universal. Treasury updates the forward consequence. At the next cycle, management will review evidence and outcomes, not merely ask whether an action is “in progress”.

Make the first page a recurring control, not a monthly writing exercise

Reuse the structure, not last month’s narrative. Each cycle should refresh the validated model; recalculate comparisons and bridges; surface material exceptions; invalidate stale commentary when dependent values change; assign actions; retain approvals; and carry unresolved items into the next meeting with their evidence status intact.

ENTIMEMA FRAMEWORKReusable first-page specificationFor every material line, require the same controlled fields.
  1. Outcome: actual, comparison, absolute variance, percentage or point variance, unit and period.
  2. Driver: reconciled mechanism, evidence status, materiality and residual or limitation.
  3. Decision: required management choice, alternatives and consequence of delay.
  4. Action: accountable owner, due date, success measure and next review condition.

Track the pack’s performance through decision lead time, percentage of material findings with evidence paths, action closure with proof, forecast or scenario accuracy where relevant, recurring reconciliation exceptions and measurable financial outcomes. Page count and production speed matter only when they improve controlled decision throughput.

The commercial boundary is the recurring workflow: controlled inputs, harmonised periods, canonical mappings, deterministic validation, visible exceptions, targeted human review, a validated financial model and an executive-ready output. The report is the decision interface; the governed path behind it makes the interface defensible.

FROM METHODOLOGY TO CONTROLLED EXECUTION

Convert validated financial data into a management decision layer.