A single variance number hides a story, and a waterfall chart tells it: it breaks one figure into the drivers that made it move. So when someone asks "Why is EBITDA down $200K?", the answer should be visual, immediate, and clear, not a fifteen-minute "well, there are several factors" that leaves everyone more confused.

The Problem with Variance Numbers

A variance is a single number that represents multiple changes. Revenue is up $50K. But why?

Price increases contributed $80K
Volume declines cost $40K
Mix shift added $10K
Net: $50K favorable

That single "$50K favorable" hides a story. Price is working. Volume isn't. You're papering over a problem with a win.

When you report just the net variance, you're hiding the drivers. You're making it impossible for stakeholders to understand what's actually happening.

Enter the Waterfall

A waterfall chart, sometimes called a bridge chart, decomposes a variance into its components. It shows:

Where you started (budget, prior period, or prior forecast)
What changed (each driver as a step up or down)
Where you ended (actual results)

The visual makes the story obvious. Big green bars are good. Big red bars are bad. The net result is just math.

Building an Effective Waterfall

Good waterfall charts follow a handful of principles, whatever tool you build them in:

Start with a clear baseline: Budget vs. actual? Prior year vs. current? Prior month vs. current? Pick one and be consistent.

Order drivers by impact: Largest changes first (in absolute terms). This focuses attention on what matters.

Group related items: Don't show 47 tiny bars. Consolidate small drivers into "Other."

Use consistent colors: Green for favorable, red for unfavorable. Every time.

Label clearly: Each bar should state what it represents and the dollar impact.

The Elevator Analysis

Waterfall charts enable what we call "elevator analysis," the ability to explain a variance in the time it takes to ride an elevator.

Without a waterfall: "EBITDA was below budget due to a combination of factors including revenue timing, higher-than-expected marketing spend, and some operational efficiencies that partially offset..."

With a waterfall: "EBITDA missed by $200K. [Point to chart] Revenue was short $150K on delayed deals. Marketing overspent $100K on the product launch. But we saved $50K on the facility lease."

Same information. Radically different clarity.

Common Waterfall Mistakes

Even a good idea fails in execution. The recurring ways waterfalls go wrong:

Too many bars: If your waterfall has more than 8-10 steps, you've lost the plot. Consolidate.

Unlabeled bars: Every bar needs a label with the driver name and dollar amount. No exceptions.

Inconsistent direction: Decide whether favorable is up or down, then stick with it. Mixing conventions creates confusion.

Missing net line: The final bar should clearly show the ending position (actual results).

No reference to prior: Include the starting position prominently. Context matters.

Beyond the P&L

Waterfalls work for any variance analysis, not just the income statement:

Cash flow: Starting cash to operating changes to financing changes to investing changes to ending cash

Headcount: Beginning count to new hires to departures to transfers to ending count

Revenue bridge: Prior year to price to volume to mix to new products to current year

The structure is universal. The components change based on what you're explaining.

Automating the Waterfall

Manual waterfall creation is tedious. You're extracting data, calculating differences, formatting charts, repositioning labels.

The best waterfall implementations are automated:

Data flows from source
Drivers are pre-defined
Chart generates automatically
Formatting is consistent

When creating a waterfall takes more than two minutes, you won't create them. When it takes seconds, you'll create them for everything. The faster path is to carry the variance through from your monthly close columns into the presentation layer once, rather than rebuilding the chart by hand each period, which is the kind of last-mile work ClosePack is built to handle.

The Communication Upgrade

Waterfall charts transform finance communication from "let me explain this complex situation" to "look at this chart."

Boards understand waterfalls. Executives understand waterfalls. Even people who hate numbers understand waterfalls.

The visual does the work. You provide the context.

Your Challenge

Pick one variance from your last board deck. Build a waterfall showing the drivers.

Notice how much clearer the story becomes. Notice how much easier it is to identify what matters.

Then ask yourself: Why isn't every significant variance presented this way?

The variance waterfall isn't decoration. It's the clearest way to explain what changed.