Variance Brief | FP&A Budget vs Actual Variance Analysis & Commentary Toolkit for Excel

"Over budget" isn't an explanation. This toolkit helps you write one.

Variance Brief by The Finance Desk is an Excel workflow built by an FP&A professional for the monthly variance review: compare actuals to budget and forecast, focus on what's material, document the real business driver, and turn it into commentary leadership can act on.

The workbook handles the framework. You bring — and validate — the business story.

━━━━━━━━━━━━━━━━━━━━

WHAT YOU CAN DO

━━━━━━━━━━━━━━━━━━━━

• Compare actuals with budget and forecast

• See dollar and percentage variances

• Set your own materiality thresholds ($ and %)

• Prioritize the variances worth investigating

• Record drivers and supporting evidence

• Separate timing issues from persistent ones

• Capture next actions and forecast impact

• Generate first-draft commentary from your inputs

━━━━━━━━━━━━━━━━━━━━

THE COMMENTARY FRAMEWORK

━━━━━━━━━━━━━━━━━━━━

RESULT → DRIVER → SUPPORT → OUTLOOK / ACTION

What changed, why it changed, what proves it, and what happens next.

━━━━━━━━━━━━━━━━━━━━

WHAT'S INCLUDED — 7 TABS

━━━━━━━━━━━━━━━━━━━━

• START HERE — quick-start workflow and review settings

• DATA INPUT — actual, budget, forecast, owner, and notes

• VARIANCE ANALYSIS — calculations, materiality flags, priority

• INVESTIGATION — drivers, evidence, explanations, actions, status

• COMMENTARY — first-draft narrative plus structured inputs for optional AI editing

• EXAMPLES — weak versus improved commentary side by side

• LISTS — dropdown categories

━━━━━━━━━━━━━━━━━━━━

HOW IT WORKS

━━━━━━━━━━━━━━━━━━━━

1. Download and unzip the file.

2. Replace the sample results in DATA INPUT.

3. Set materiality thresholds and how many variances to review.

4. Work the prioritized list in INVESTIGATION.

5. Review and edit the generated commentary.

6. Validate figures and confidentiality before sharing.

━━━━━━━━━━━━━━━━━━━━

OPTIONAL AI SUPPORT

━━━━━━━━━━━━━━━━━━━━

A ready-to-use prompt is included for polishing validated inputs into concise executive commentary. AI is not required, and no AI subscription or connection is included. The "AI-Safe Input" field is a structured text block, not an anonymizer — remove confidential details yourself and follow your employer's AI policy.

━━━━━━━━━━━━━━━━━━━━

WHO IT'S FOR

━━━━━━━━━━━━━━━━━━━━

FP&A analysts, finance managers, controllers, and small finance teams who want a repeatable month-end variance and commentary process.

━━━━━━━━━━━━━━━━━━━━

FORMAT & COMPATIBILITY

━━━━━━━━━━━━━━━━━━━━

• Digital Excel workbook (.xlsx), delivered in a ZIP folder

• Requires Microsoft Excel (not included)

• Google Sheets and other apps have not been tested

• Includes sample data, commentary examples, and in-workbook guidance

━━━━━━━━━━━━━━━━━━━━

PLEASE NOTE

━━━━━━━━━━━━━━━━━━━━

This is a digital download. No physical item will be shipped. Devices and props shown in photos are not included.

The workbook does not identify or verify the causes of variances; commentary reflects what you enter and must be reviewed before distribution. It does not replace accounting controls or professional judgment.