← All use cases

Build a variance driver bridge

Account for shifts across actuals, budget, and forecast using drivers tied to sources.

Share actuals, the budget, forecasts, KPI data, thresholds, and notes from owners with ZeroTwo. It ranks what drove the major swings and builds an editable bridge, complete with reconciliations, open questions, and citations to sources.

Intermediate
30m

Related links

Best for

  • Forecast-, budget-, or prior-forecast-to-actual reviews.

Skills & Plugins

  • Spreadsheets
    Reconciles the inputs and builds an editable .xlsx bridge ($spreadsheets).
  • Documents
    Packages the commentary into a .docx memo ($documents).

Starter prompt

Build a bridge from budget to actuals for last month's operating expenses. I've attached the close workbook, the budget, the latest forecast, and my notes from department owners; treat anything over $25k or 5% as material. Reconcile the inputs first and tell me where they don't tie. Then give me an editable workbook ranking the drivers behind each material variance, with sources, and a list of questions for owners, labeling each driver as supported, inferred, or open.

Introduction

A bridge ties a movement to ranked drivers, separating supported explanations from open questions.

Choose the comparison

Fix the versions, materiality threshold, sign conventions, and finance lines first.

Attach the inputs, run the prompt for an editable workbook, review breaks and rankings, then settle owner questions in the same chat.

Challenge the explanations

Label each driver supported, inferred, or open, with impact, source, and the question that closes it. Keep unsupported claims out of the executive summary.

Related use cases