The close numbers have been final for two days. You already know the story: APAC underperformed, OpEx came in favorable, and the net result is distorted by an unexpected consulting invoice.
The challenge is not analysis. It is translating that understanding into clear, concise variance commentary that a CFO can absorb in 90 seconds before a 9 a.m. meeting.
This process used to take me approximately 45 minutes per close. Today, it takes about eight.
WHY IT WORKS
Variance commentary is well-suited to AI
Not every FP&A task benefits equally from AI. Variance commentary does, for three reasons:
01
It is structurally consistent
Each month answers the same questions: What happened? Why? What does it mean going forward? The structure rarely changes — only the inputs do.
02
The analysis is already complete
By the time close commentary is written, the numbers and drivers are understood. The bottleneck is converting that knowledge into clear, executive-ready prose under time pressure.
03
The output format is defined
Effective commentary follows a predictable pattern: headline result, primary driver, secondary contributors and offsets, forward implication. This is a form-based task, not a creative one.
BEFORE & AFTER
The old workflow vs. the new one
THE OLD WORKFLOW | THE NEW WORKFLOW |
|---|---|
| Attach or paste the variance table from Excel as plain text |
| Run the prompt below |
| Review, add organisational nuance, tighten language |
| Finalise |
| |
|
The prompt handles structure and language. I retain responsibility for judgment, context, and forward-looking interpretation.
COPY AND USE THIS
The prompt
PROMPT — COPY VERBATIM
"You are a senior FP&A analyst preparing variance commentary for the CFO. Based on the following data, write a structured narrative with three paragraphs:
Paragraph 1: The headline result — overall performance versus plan, expressed in dollar and percentage terms. Identify the single most significant driver in one clear sentence.
Paragraph 2: Secondary drivers and offsets — what else contributed, and what partially offset the primary driver. Be specific about amounts.
Paragraph 3: Forward implication — one sentence on what this result means for the remainder of the year or the next period. Be direct, not hedging.
Tone: Executive. Business language, not accounting language. No jargon. Write for someone who will read this in 90 seconds before a board call. Be direct. Do not use passive voice.
Output length: 150–200 words.
Data: [attach/paste your variance table here]"WHY IT WORKS
Four specific design choices
Role definition
Positioning the model as a senior FP&A analyst aligns vocabulary, assumptions, and perspective to the audience.
Explicit structure
Defining paragraph purpose eliminates formatting uncertainty and reduces the need for post-edit restructuring.
Tone calibration
Clear direction to avoid accounting jargon and write in executive business language materially improves usability.
Length constraint
Enforcing 150–200 words prevents unnecessary elaboration and keeps the output board-ready.
IMPORTANT
What still requires judgment
This is not a replacement for professional judgment. The model cannot account for:
Off-system events or late-breaking developments
Politically sensitive variances
Forward implications that require contextual nuance
The specific metrics your CFO focuses on most
The prompt delivers a strong first draft — approximately 80% complete. The remaining 20% reflects experience, context, and judgment.
MAKE IT YOURS
Adapting the prompt
Add your terminology
Include company-specific labels and line item names so the output uses language your CFO already recognises.
Refine the audience
Change "CFO" to "board" or "non-finance leadership" to shift the vocabulary and assumed knowledge level.
Adjust the structure
Four paragraphs instead of three? A separate below-the-line section? Modify the paragraph instructions to match your format.
Create variants
Save separate versions for monthly close, quarterly board narrative, budget vs. prior year, and rolling forecast updates.
The value is not automation for its own sake. It is removing friction from work that never required senior judgment to begin with.