Answers

What is a waterfall chart?

The waterfall is the CFO artifact of record for anything that opens at one value, moves through additions and subtractions, and lands at another. It is why boards read ARR movement as a waterfall and never as a line.

Short answer

A waterfall chart is a bar-chart variant that shows how a starting value changes through a sequence of positive and negative movements to arrive at an ending value. Each intermediate bar floats at the running total, with gains stacked up and losses stepped down, so the viewer can trace exactly how the opening number became the closing number. In SaaS reporting it is the standard shape for ARR movement, bookings coverage, and headcount, because every intermediate contribution and every drag is visible on a single chart.

Key points

What matters most.

The six things to understand about a waterfall chart before you build one for a board slide, read one in a diligence room, or ask a sub-ledger to produce one. Each one is a place real operators get the shape wrong and surface a headline number that cannot be reconciled to the pieces beneath it.

Definition

A floating bar chart that traces totals.

A waterfall chart begins with a starting total on the left, ends with a closing total on the right, and places a floating bar between the two for each positive or negative movement. The height of each intermediate bar is the size of that movement, and the vertical position is the running total after that movement. Gains move the running total up, losses step it down.

Also called

Bridge chart, cascade chart, flying bricks.

The waterfall chart is also called a bridge chart because it bridges a starting value and an ending value, a cascade chart because the bars appear to cascade across the horizontal axis, and informally a flying bricks chart. In finance the term bridge is used most often. In SaaS and operations the term waterfall is used most often. The shape and the math are identical under every name.

Core use

Explain the gap between two totals.

The waterfall exists to answer one question clearly. Why does the opening number not equal the closing number. Every intermediate bar names one contribution to the difference, with a sign and a size, so the gap is fully decomposed. A line chart or a pair of bars never does this, because the pieces of the change are hidden inside the delta.

SaaS flavor

ARR waterfall is the canonical example.

The most cited waterfall in SaaS reporting is the ARR movement waterfall. Start ARR, plus new business, plus expansion, minus downgrades, minus churn, equals end ARR. Each component is a floating bar. The chart is the single clearest view of how the recurring book moved during the period and the shape every revenue team is expected to produce for a board.

Forecast flavor

Bookings waterfall shows coverage, not history.

A bookings waterfall is a forecast view, not a historical one. It starts at committed, adds best case, adds pipeline coverage, and shows whether the stack reaches the number. Instead of decomposing a change over time, it decomposes a forecast into tiers of certainty. The shape is the same floating bars, but every bar is a probability-weighted contribution to the plan.

Why it matters

Boards and auditors read waterfalls, not lines.

Boards read waterfalls because the shape explains the result instead of restating it. A line chart of ARR over four quarters shows that the number went up. The ARR waterfall shows that new business carried the quarter while churn eroded the base, which is the actual story. Auditors read waterfalls because every intermediate bar must tie to a sub-ledger, and the chart surfaces the pieces that would otherwise be buried in a single net movement.

Anatomy of the chart

How a waterfall chart is actually built.

Every waterfall uses the same six structural pieces: an opening pillar, a sequence of floating bars for the movements, a closing pillar, color coding by sign, running total labels, and connectors between the bars. The six cards below describe each piece and the common mistakes that make a waterfall unreadable.

Opening pillar

A grounded bar at the starting total.

The chart opens with a solid bar rising from zero to the starting total on the left. It is not a floating bar, because it has no predecessor to float from. The opening pillar sets the scale for every bar that follows and establishes the running total that the first movement will adjust. Mislabel the opening pillar and the entire bridge is already off by whatever the mislabel was worth.

Floating bars

One bar for each movement, floating at the running total.

Between the opening pillar and the closing pillar sits one floating bar for every signed movement. A positive movement floats upward from the current running total. A negative movement steps downward from it. The bottom of each bar is the running total before the movement. The top is the running total after it. The height is the absolute size of the movement.

Closing pillar

A grounded bar at the ending total.

The chart closes with a second grounded bar rising from zero to the ending total on the right. It visually confirms that all of the floating bars together carried the running total from the opening to the closing value. If the closing pillar does not line up with the top of the final floating bar, the arithmetic of the chart is broken and the viewer will notice immediately.

Color by sign

Gains in one color, losses in another.

Positive bars use one color, negative bars use another, and the opening and closing pillars use a third neutral color. Convention is green for gains, red for losses, and gray or navy for the pillars, but any three colors with clear contrast work. The color encoding is what lets a reader scan the chart and immediately see where the gains and the drags landed in the sequence.

Running total labels

Every bar labelled with its signed size.

Each floating bar carries a label with its signed size, and the opening and closing pillars carry labels with their absolute totals. Many waterfalls also label the running total above each movement so the reader can trace the arithmetic without squinting at the vertical axis. The labelling is what separates a defensible board chart from a decorative one.

Connectors

Thin lines that join the running totals.

A horizontal connector line runs from the top of each bar to the bottom of the next, which makes the running total visually continuous even when the bars are far apart on the horizontal axis. Without connectors the eye has to jump between floating bars and the chart feels disjointed. With connectors the shape reads as a single running total passing through gains and losses.

Waterfalls in SaaS reporting

The waterfall views every revenue team is expected to produce.

SaaS boards and operating cadences lean on waterfalls because the shape makes change decompose cleanly. The six cards below describe the specific waterfalls that appear in almost every monthly book or quarterly board deck: ARR, net new ARR, bookings forecast, pipeline coverage, headcount, and gross-to-net revenue.

ARR waterfall

Start plus new plus expansion minus downgrade minus churn.

The canonical SaaS waterfall. The chart opens at starting ARR, adds new business ARR, adds expansion ARR, subtracts downgrade ARR, subtracts churn ARR, and closes at ending ARR. Boards read it every month because it explains the net change in the recurring book with every component of the movement visible on one chart.

Net new ARR

The condensed version for growth decks.

A tighter waterfall that shows only the components of net new ARR for a single period. New business plus expansion minus downgrade minus churn equals net new ARR. There is no opening or closing total of the book, only the quarter-over-quarter contribution. Growth-stage investor decks tend to lead with this view because it isolates the engine of the quarter.

Bookings forecast

Committed, best case, pipeline, gap to plan.

A forward-looking waterfall used in sales operating reviews. The chart opens at committed bookings, adds best case, adds pipeline weighted by stage, and compares the stack against the plan number on the right. If the stack falls short, the gap to plan is the final bar. The shape makes coverage conversations concrete instead of abstract.

Pipeline coverage

Starting pipeline, plus adds, minus closes, minus losses.

A pipeline waterfall decomposes the change in open pipeline for a period. Starting pipeline, plus newly created opportunities, minus closed won, minus closed lost, minus pushed out of the period, equals ending pipeline. The chart surfaces the balance between creation and consumption of pipeline, which is the single most important leading indicator of the next quarter.

Headcount waterfall

Start plus hires minus attrition equals end.

A people-side waterfall used by Finance and HR. The chart opens at starting headcount, adds hires, adds internal moves in, subtracts attrition, subtracts internal moves out, and closes at ending headcount. The shape is identical to the ARR waterfall because the arithmetic is the same. It is often shown alongside the ARR waterfall so capacity and revenue read together.

Gross-to-net revenue

Gross bookings down to recognized revenue.

A finance waterfall that bridges gross bookings to recognized revenue. Start at gross bookings, subtract discounts, subtract contra-revenue, subtract deferred revenue, add revenue recognized from prior deferrals, and close at the period revenue number. Auditors prefer this view because every subtraction and addition ties to a sub-ledger entry.

Reading and building one well

How to read and build a waterfall chart that holds up.

A waterfall only pays its freight if the arithmetic ties and the shape reads cleanly. The six cards below cover the rules that separate a defensible operating waterfall from one that embarrasses the finance team at the next board meeting: tying the ends, ordering the bars, segmenting cleanly, pairing with a prior period, surfacing subtotals, and connecting to the source data.

Tie the ends

Start plus signed movements equals end, every time.

The non-negotiable rule. Starting total plus the sum of signed movements must equal the ending total. If the sum does not tie, there is a missing bar or a mislabelled sign and the chart is wrong before anyone reads it. Most chart tools fail silently when the arithmetic breaks, so the arithmetic check belongs in the data pipeline that produces the chart, not in the chart tool.

Order the bars

A convention that readers can follow.

The bar order carries meaning. The standard SaaS convention is new, then expansion, then downgrade, then churn, because it mirrors the sales motion from acquisition to erosion. Finance waterfalls usually order by sub-ledger. The rule is to pick a convention, document it, and never reorder bars between periods, because any reorder makes period-over-period comparison impossible.

Segment cleanly

One waterfall per cohort, not one for the whole book.

A single waterfall for the whole business hides the segments where the number is actually broken. A disciplined board report shows the ARR waterfall for the enterprise segment, the SMB segment, and each product line, with the aggregate waterfall rolling them up. Reading only the aggregate is how a bad cohort gets masked by a strong one for a full year before anyone notices.

Pair with prior

Current period next to the same period a year ago.

A single waterfall shows one period. The useful comparison is the current period next to the same period a year ago, with each bar directly beneath its prior-year counterpart. The paired view surfaces whether the engine is accelerating, decelerating, or shifting from new business to expansion. One waterfall alone cannot answer any of those questions.

Surface subtotals

Running total labels at every logical break.

A long waterfall with eight or ten bars becomes unreadable without subtotal pillars. The convention is to insert a grounded subtotal bar at every logical break, for example after new business and expansion to show gross add, or after downgrade and churn to show gross loss. The subtotals turn a wall of bars into a story with chapters.

Tie to source

Every bar reconciles to a report or sub-ledger.

Every intermediate bar in a waterfall must map to a report in the source system. New business ARR ties to the won-closed pipeline report in the CRM. Churn ties to the renewal report. Expansion ties to the expansion deal pipeline. Downgrade ties to the account-change report. Without that tie, the waterfall is a drawing. With it, the waterfall is a defensible operating artifact.

Build ARR and pipeline waterfalls on the system where the deals already live.

Strkr captures new business in the pipeline, expansion on the account, downgrades at the renewal, and churn when the subscription ends, all against the same account record. The waterfall charts for ARR movement, bookings coverage, and pipeline progression roll up from the CRM the revenue team already uses, instead of being reassembled from spreadsheets at month end.

People also ask

Related questions.

What is a waterfall chart used for?

A waterfall chart is used to explain the gap between two totals by showing every intermediate positive and negative movement that produced the difference. It is the standard shape for ARR movement, bookings coverage, headcount change, gross-to-net revenue bridges, and any other reporting view that opens at one value, moves through additions and subtractions, and lands at another. Boards read waterfalls because the shape explains the result instead of restating it.

What is an ARR waterfall?

An ARR waterfall is a waterfall chart that decomposes the movement of annual recurring revenue across a period. It opens at starting ARR, adds new business ARR, adds expansion ARR, subtracts downgrade ARR, subtracts churn ARR, and closes at ending ARR. It is the canonical SaaS reporting view because every component of recurring revenue movement is visible on a single chart, instead of being buried inside a single net change.

What is a bookings waterfall?

A bookings waterfall is a forward-looking variant used in sales operating reviews. Instead of decomposing a historical change, it stacks tiers of forecast certainty. The chart opens at committed bookings, adds best-case bookings, adds pipeline weighted by stage, and compares the total to the plan number. The gap between the stacked forecast and the plan is the final bar, which makes coverage conversations concrete instead of abstract.

What is the difference between a waterfall chart and a bar chart?

A bar chart places every bar on the same horizontal baseline. A waterfall chart floats each intermediate bar at the running total, so gains step the running total up and losses step it down. The visual effect is a cascade from the opening value to the closing value, with every movement decomposed. A standard bar chart shows totals side by side. A waterfall shows how one total became another.

Why is it called a waterfall chart?

The name comes from the visual effect of the floating bars cascading from the opening value to the closing value across the horizontal axis. The chart is also called a bridge chart because it bridges a starting value and an ending value, a cascade chart for the same reason, and informally a flying bricks chart. Finance teams tend to say bridge. SaaS and operations teams tend to say waterfall. The math is identical under every name.

How do you read a waterfall chart?

Read it left to right. Start at the opening pillar on the left, which is the starting total. For each floating bar, check the color to see whether the movement is positive or negative, read the label for the signed size, and follow the running total up or down. The closing pillar on the right is the ending total, and it should equal the opening total plus the sum of every signed movement in the middle.

How do you build a waterfall chart in Excel?

Modern Excel includes a native waterfall chart type. Select the data range with one column of labels and one column of signed values, insert a waterfall chart from the ribbon, and mark the opening and closing cells as totals so the chart renders them as grounded pillars instead of floating bars. Older versions of Excel require a stacked-bar workaround with hidden spacer series. The native type produces a cleaner chart that is easier to maintain.

What makes a waterfall chart wrong?

The three most common failures are a sum of signed movements that does not reconcile to the ending total, bars reordered between periods so period-over-period comparison breaks, and a single aggregate waterfall that hides a broken segment inside a healthy roll-up. A waterfall is only as credible as its arithmetic and its source-system tie, and any of those three failures is enough to invalidate the chart in a diligence room.

Try it free. Bring your team next week.

No sales call, no migration consultant, no four-month implementation. Enter your card, get 14 days of the full Pro tier, cancel any time before day 14 with zero charge. Spin up a workspace, import your CSV, and have something useful before lunch.