Blog · Board and management reporting · Finance and FP&A teams
Prepare a monthly management meeting around actual-versus-plan evidence. Reconcile the movements, identify decisions and give each action an accountable owner.
A monthly management meeting should turn reconciled actual-versus-plan movements into decisions and named actions. Prepare the evidence before the review: what changed, how much it changed, why the explanation is credible and what management can do next. A longer reporting pack cannot compensate for an unexplained profit movement.
Freeze the month's actual ledger export and the approved budget version. Record entity scope, currency, period, account mappings and any management adjustments. Show whether each comparison is monthly or year to date; never place a monthly cost against a cumulative revenue denominator.
The SEC's guide to financial statements separates income over a period from balance-sheet positions at a date and cash movements over a period. Keep those distinctions in the review: profit, cash generation and available cash answer different questions.
Use management reporting for the overall reporting-package structure. For this meeting, select the evidence needed to explain material performance and reach a decision, rather than reading every schedule aloud.
Create an Actual sheet with entity in A, account in B, month-end date in C and signed reporting amount in D. Use positive revenue and positive expense amounts in this particular reporting layout. Give the Plan sheet the identical columns and use the same account map.
On a comparison sheet, put the entity in H1, month-end date in H2 and account code in A2. The actual amount in C2 is:
=SUMIFS(Actual!$D$2:$D$9999,Actual!$A$2:$A$9999,$H$1,Actual!$B$2:$B$9999,$A2,Actual!$C$2:$C$9999,$H$2)
Use the same formula pointing to Plan for B2. This assumes column C contains normalized month-end dates without times and that the ranges cover every row. Preserve transaction IDs in the underlying detail so the subtotal can be traced back.
For variance in D2 and variance percentage in E2:
=C2-B2
=IF(B2=0,"n/a",D2/ABS(B2))
A higher expense is an unfavorable movement despite its positive actual-minus-plan sign. Label the direction explicitly or convert every row to profit impact before combining it. A zero budget returns "n/a" for the percentage; it does not eliminate the dollar variance.
A US industrial distributor reviews September 2026. The plan and actual quantities below relate to one comparable product family; there are no returns, currency changes or inventory-cost timing effects in this simplified example.
| Measure | Plan | Actual | Actual minus plan |
|---|---|---|---|
| Units sold | 10,000 | 11,000 | 1,000 |
| Realized unit price (USD) | 100 | 95 | -5 |
| Revenue (USD) | 1,000,000 | 1,045,000 | 45,000 |
| Cost of goods sold (USD) | 600,000 | 660,000 | 60,000 |
| Operating expenses (USD) | 250,000 | 270,000 | 20,000 |
| Operating profit (USD) | 150,000 | 115,000 | -35,000 |
Revenue is units multiplied by realized price: 11,000 × $95 = $1,045,000. Operating profit is revenue minus cost of goods sold minus operating expenses. The actual figure is therefore $1,045,000 − $660,000 − $270,000 = $115,000.
Sales rose by $45,000, or 4.5% of the $1,000,000 plan, while profit fell by $35,000. That is the review's opening finding. All dollar movements are exact; the percentage is shown to one decimal place.
Now prove the bridge. Use planned price for the volume effect and actual volume for the price effect, so the interaction is assigned once.
| Profit bridge step | Calculation | Profit impact (USD) |
|---|---|---|
| Planned operating profit | 1,000,000 − 600,000 − 250,000 | 150,000 |
| Revenue volume effect | (11,000 − 10,000) × 100 | 100,000 |
| Revenue price effect | 11,000 × (95 − 100) | -55,000 |
| Cost of goods sold movement | −(660,000 − 600,000) | -60,000 |
| Operating expense movement | −(270,000 − 250,000) | -20,000 |
| Actual operating profit | 150,000 + 100,000 − 55,000 − 60,000 − 20,000 | 115,000 |
The two revenue effects sum to $45,000. All four movements sum to −$35,000, exactly the profit variance. Do not call the entire $60,000 cost movement inefficiency: the business sold more units. Further evidence is needed to distinguish volume, purchase prices and operating performance.
Use the company's approved materiality rules to select the review items. For each selected movement, attach the calculation, the underlying rows, a confirmed cause or labeled hypothesis, the proposed decision, an owner and a review date.
Here, the commercial owner should establish whether the lower realized price came from approved discounting, contract changes or transaction errors. Finance can show the $55,000 revenue price effect without claiming which cause produced it. Operations should explain the cost movement against the additional units, and the expense owner should support the $20,000 overspend from account detail.
When an action needs spending, show its expected benefit and cost over the same period. The SBA's financial-management guidance describes cost-benefit analysis as comparing benefits and costs over a specified period. An action's expected benefit remains an assumption until later results support it.
Keep the underlying sales schedules in the monthly commercial pack, and use the management accounts template when a consistent financial layout is needed. The meeting record should preserve the decision and the evidence version used to make it.
Bring the actual export, approved plan and supporting business schedules to Covirage; its tools compute the comparisons and check that the movements reconcile. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own reporting pack; see FP&A reporting for the supporting finance context.
Use a reconciled results summary, an actual-versus-plan profit bridge, relevant cash and working-capital changes, and the few operating measures needed to explain them. Include the approved comparison period and plan version so every participant is reviewing the same basis.
Finance owns the calculation and its reconciliation to the reporting pack. The responsible business owner supplies operational evidence and proposes action. Where the cause is unconfirmed, record a hypothesis and a follow-up owner rather than presenting a convenient explanation as an established fact.
Keep the approved budget comparison visible to preserve accountability, then show the latest approved forecast separately if it helps decisions. Label both versions and their approval dates. Replacing the budget silently with a newer forecast obscures the original performance commitment.