Your result
What your team can start with
What controlled output looks like
One month of variance commentary, with the controls showing
This is the control layer a draft has to pass through before it reaches anyone. It runs on Helix Consumer Goods, a fictitious company, for September 2026.
CC100 Digital Commerce — actual 7,733,233 EUR, 258,767 EUR below forecast (-3.2%). Driver: [to be confirmed by cost-centre owner]. Reviewer decides whether this is timing, volume, price or one-off.
lineage: 2026-09-CC100 → row 102 of helix_pnl_24m.csv; actual − forecast; variance -258,767 EUR (-3.2%) breaches threshold (|5.0%| or |100,000 EUR|).
CC200 Wholesale — flagged as DATA ISSUE, not a business variance. Actual shows 0 against a forecast of 2,808,000 EUR. Action: data owner to confirm the ERP load before any commentary is written.
lineage: 2026-09-CC200 → row 103 of helix_pnl_24m.csv; actual − forecast; actual = 0 with forecast > 0: missing load or mapping. Do not comment on the business.
CC300 Marketing — within threshold (-2.7%). No commentary required.
lineage: 2026-09-CC300 → row 104 of helix_pnl_24m.csv; actual − forecast; variance -32,693 EUR (-2.7%) within threshold.
- 1Material on amount, not on percentage. At -3.2% the line is under the 5% threshold, but 258,767 EUR is over the 100,000 EUR one. The driver is left blank for the cost-centre owner.
- 2A zero is treated as a data problem. Wholesale shows no actuals against a 2.8m EUR forecast. The line is flagged and gets no narrative until the ERP load is confirmed.
- 3Every line names its source row. A reviewer can open the exact row of the exact file version, identified by its hash.
- 4Nothing is approved until a person approves it. The control log below has an empty approver column and every status reads DRAFT.
The control log behind it
| output_id | cost_center | classification | source_row | source_hash | approver | status |
|---|---|---|---|---|---|---|
| 2026-09-CC100 | CC100 Digital Commerce | MATERIAL | 102 | d5c41192e998 | (empty) | DRAFT |
| 2026-09-CC200 | CC200 Wholesale | DATA_ISSUE | 103 | d5c41192e998 | (empty) | DRAFT |
| 2026-09-CC300 | CC300 Marketing | IMMATERIAL | 104 | d5c41192e998 | (empty) | DRAFT |
| 2026-09-CC400 | CC400 Logistics | IMMATERIAL | 105 | d5c41192e998 | (empty) | DRAFT |
| 2026-09-CC500 | CC500 G&A | IMMATERIAL | 106 | d5c41192e998 | (empty) | DRAFT |
Synthetic figures. Helix Consumer Goods is a fictitious company. These lines came from a deterministic script, run on 13 November 2026. No AI model wrote them: an AI step may only reword a line between draft and approval, and never after.
Free series
AI in FP&A, the controlled way
Short, practical tools that show finance teams where AI really helps, without losing lineage, approvals or the controller's trust. Follow me on LinkedIn for the next one.