Variance Analysis Template

Monthly Variance Bridge Template

A good bridge does more than reconcile plan to actual. It exposes which movements were real, which were timing, and which now deserve intervention. This template is built to compress the distance between the close and a useful management conversation.

Plan to actual bridge Waterfall-ready logic Commentary cues Board-friendly

Back to Toolkit Download Workbook (.xlsx) Book a Fit Call

Bridge Structure

Keep categories clean enough that management can follow them in one pass.

Bridge item	Impact	Commentary cue
Opening budget EBITDA	INR 2.4 Cr	Baseline
Volume miss in enterprise	INR -0.7 Cr	Deals slipped 3-4 weeks
FX gain on USD billing	INR +0.2 Cr	Rate moved from 82.8 to 83.5
Cloud cost overrun	INR -0.18 Cr	Usage spike on data workloads

Commentary Builder

Use the bridge to draft the note, not the other way around.

What changed: EBITDA landed INR 0.68 Cr below plan, mainly from enterprise timing and cloud overrun.

Why: Two large deals shifted into next month while data workloads ran above expected usage.

What follows: Revenue timing remains recoverable, but cloud usage now needs owner review before the next cycle.

Usage Rules

Keep the bridge honest.

Use mutually exclusive categories. One movement should not sit in two buckets.
Separate timing effects from structural change whenever possible.
Bridge only the handful of movements that explain most of the variance.
End the bridge with a sentence on action, not just explanation.

Key Logic

Total variance Total variance = Actual result - Budget result

Bridge balance check Opening budget + Sum of bridge movements = Actual result

Timing note If recoverable next cycle, label as timing. If new run-rate changes, label as structural.

Common Mistakes

Too many small categories that hide the main story
Using the bridge as a data dump instead of a decision tool
Mixing revenue, margin, and cash movement without clear order

When This Tool Shines

Use it when management wants the short answer to, "What moved this month and what should we do about it?" without forcing finance to explain ten disconnected tables.

Adapt To Your Context

The bridge only works when the categories mirror how the business actually moves.

Adapt the buckets to your operating model, but do not let the bridge become another report no one can narrate. The main goal is faster judgment. If you want this embedded into your month-end, variance, and board pack rhythm, the toolkit hub is the next step.

Back to Tool Pages Book a Fit Call