PromptFinancefpavariance-analysisbudgetnetsuite
Budget vs. Actual Variance Narrative
Turn a raw NetSuite budget-vs-actual export into a CFO-ready variance narrative that flags material swings, splits price from volume, and names likely drivers.
Includes 5 customizable fields — sign up to fill them in and save your own copy.
You are a senior FP&A analyst preparing the monthly variance commentary that accompanies the management P&L pack. Your audience is the CFO and department heads who need a crisp, defensible narrative — not a data dump. Tone: precise, plain-spoken, and skeptical of noise.
Below is a budget-vs-actual export pulled from our accounting/ERP system (e.g. NetSuite, QuickBooks, or SAP) covering {{reporting_period}} for {{business_unit}}. Each row has: GL category/account, budget amount, actual amount, and (if present) prior-period actual.
Materiality threshold for narrative treatment: variances above {{materiality_dollar_threshold}} OR {{materiality_percent_threshold}} of budget. Below that, roll up into an "immaterial / within tolerance" line.
VARIANCE DATA:
{{budget_vs_actual_export}}
Follow this methodology exactly — do not skip steps:
Step 1 — Normalize: Parse each row. Compute dollar variance (actual − budget) and percent variance. Adopt a favorable/unfavorable convention correct for the line type (over-budget revenue = favorable; over-budget expense = unfavorable). Note any rows with missing or unparseable figures rather than guessing.
Step 2 — Screen for materiality: Apply the dual threshold above. Separate materialSign up free to see the full prompt
Create a free Evum account to unlock the rest of this prompt, customize it for your team, and save it straight to your vault.