Evum AI logo
← Back to Template Gallery
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 material

Sign 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.