For Controllers ·
What you'll accomplish
You'll build a repeatable workflow for generating the narrative sections of your monthly management variance report in Claude, cutting what currently takes 2–4 hours of concentrated writing to 30–45 minutes of paste-and-review. The structured approach ensures consistent tone, complete coverage, and CFO-appropriate language every month.
What you'll need
Before going to Claude, spend 10 minutes pulling together the key variance facts from your ERP/Excel. You don't need polished sentences, just facts.
This prep takes 10 minutes and produces dramatically better AI output than pasting raw numbers.
Go to {{tool:Claude.url}} and start a new chat. Send this opening message before any variance data:
I'm a Controller preparing our monthly management variance commentary for [month]. Context:
- Audience: [CFO and executive team / Board / Audit committee]
- Company: [brief description — e.g., "mid-size B2B software company, $150M revenue"]
- Report style: [concise and factual / narrative and explanatory / bullet-point]
- Sensitive items: [flag any — e.g., "revenue miss needs careful framing; we expect to recover in Q4"]
I'll share variance data next. Please draft professional variance commentary for each line item.
What you should see: Claude confirming it understands and ready for the data.
Send the next message with your variance bullet points:
Here are the key income statement variances for [month]. Draft a management commentary paragraph for each significant item. Professional tone. Lead with what happened, explain why, note outlook where relevant.
Revenue: [your variance + reason]
Cost of Goods Sold: [your variance + reason]
Gross Margin: [calculated result]
SG&A: [your variance + reason]
Operating Income: [total result]
[Continue for other line items]
Other notable items: [one-time items, unusual transactions, anything requiring explanation]
What you should see: Commentary for each line item in consistent, professional language.
In the same conversation, follow up with:
Now draft brief commentary for these balance sheet/cash flow variances:
Accounts Receivable: [variance + reason — e.g., "up $2.1M vs. prior month due to strong billings in last week of month; collections trending normal"]
Cash: [variance + reason]
Debt: [if applicable]
After all line items are done:
Based on all the variances above, write a 150-word executive summary paragraph for the top of the management package. Lead with the overall performance message. Be direct — don't soften if performance was below plan, but frame constructively.
What you should see: A cohesive opening paragraph that previews the key themes from the month.
Copy all the generated commentary into your report template. Then:
Income statement commentary:
Draft management commentary for each income statement variance. Audience: [audience]. Context: [company brief]. Variances: [list]. Professional, factual, concise. Lead each paragraph with what happened, explain why.
Executive summary:
Based on the variances above, write a 150-word executive summary paragraph. Lead with overall performance message. Direct, no excessive softening. Frame constructively where there are misses.
Balance sheet commentary:
Draft 2-sentence commentary for each significant balance sheet change vs. prior month: [list variances]. Focus on what changed and the business reason.
Sensitive item framing:
Rewrite the revenue variance paragraph to be more constructive. We want to acknowledge the miss but emphasize the LOIs in place for Q4 recovery. Keep it factually accurate.