A waterfall report is one of the clearest ways to explain how a starting number becomes an ending number through a series of gains, losses, additions, deductions, or milestones. Instead of showing only the final result, it reveals the story behind the change. That makes it especially useful for finance teams, marketers, project managers, executives, and analysts who need to communicate performance in a visual, step-by-step format.
TLDR: A waterfall report shows how individual positive and negative changes move a value from a starting point to an ending point. For example, a company might begin with $500,000 in revenue, add $120,000 from new customers, lose $45,000 from churn, subtract $30,000 in discounts, and end at $545,000. In one monthly sales review, this kind of report can help managers quickly see that growth was strong, but churn reduced total gains by 27%. Use it when you need to explain movement, not just display totals.
Table of Contents
What Is a Waterfall Report?
A waterfall report is a report built around a waterfall chart, sometimes called a bridge chart, cascade chart, or floating column chart. It displays a beginning value, a sequence of increases and decreases, and a final value. Each bar represents a change, while the report around it explains the reasons, context, and business impact.
The format is popular because it turns complex calculations into a visual path. Instead of asking readers to compare dozens of spreadsheet rows, a waterfall report guides them from left to right: “Here is where we started, here is what changed, and here is where we ended.”
Common Waterfall Report Examples
Waterfall reports can be used in many departments. The structure stays similar, but the data and interpretation change depending on the goal.
- Revenue waterfall report: Shows how starting revenue changes through new sales, upgrades, renewals, churn, refunds, discounts, and ending revenue.
- Profit and loss waterfall: Explains how revenue becomes net profit after cost of goods sold, operating expenses, taxes, and other deductions.
- Budget variance waterfall: Compares planned budget to actual spending, highlighting where departments overspent or saved money.
- Marketing performance waterfall: Tracks how leads move through a funnel, from impressions and clicks to qualified leads, conversions, and final sales.
- Project waterfall report: Shows progress from initial scope to completed deliverables, including delays, added tasks, removed tasks, and final project status.
- Employee headcount waterfall: Tracks beginning headcount, new hires, transfers, resignations, terminations, and ending staff count.
For example, a SaaS company might use a monthly recurring revenue waterfall. It begins with $80,000 MRR, adds $14,000 from new subscriptions, $6,000 from account expansions, subtracts $5,000 from cancellations, and ends with $95,000 MRR. This is far more useful than only saying, “MRR increased by $15,000,” because it shows why the increase happened.
Typical Waterfall Report Formats
A good waterfall report can be simple or sophisticated, depending on the audience. Here are the most common formats:
- Executive summary format: A one-page report with a chart, three to five key insights, and recommended actions. Best for leadership meetings.
- Spreadsheet format: A table-based report with formulas, supporting data, and a waterfall chart. Best for analysts and finance teams.
- Dashboard format: An interactive report in a business intelligence tool, allowing users to filter by date, region, team, or category.
- Presentation format: A slide-based waterfall report used in quarterly business reviews, board meetings, or client updates.
- Narrative report format: A written explanation supported by charts and tables, often used in strategy documents or annual reports.
Regardless of format, the best waterfall reports include the same core elements: a clear starting point, logically ordered changes, positive and negative values, a final result, labels, and concise commentary.
What to Include in a Waterfall Report
Before creating the chart, decide what story the report needs to tell. A report about profit margin should not include every minor expense line if only five categories explain most of the movement. Similarly, a marketing waterfall should not overload readers with vanity metrics if the main question is conversion.
Include these elements:
- Report title: Make it specific, such as “Q2 Revenue Waterfall by Growth Driver.”
- Time period: State whether the report is monthly, quarterly, yearly, or campaign-based.
- Starting value: This anchors the report and gives readers a baseline.
- Change categories: These are the increases and decreases that explain the final result.
- Ending value: The final number after all changes are applied.
- Key insights: Briefly explain the most important drivers behind the result.
- Recommended action: Tell readers what should happen next based on the findings.
How to Create a Waterfall Report
Creating a waterfall report is not difficult, but it requires thoughtful structure. Follow these steps to build one that is both accurate and easy to understand.
1. Define the Question
Start with the business question. Are you explaining why profit fell? Why revenue increased? Why a project exceeded budget? A focused question prevents the report from becoming a collection of unrelated numbers.
For instance, instead of creating a vague report called “Marketing Results,” ask: “What factors caused paid campaign revenue to move from $200,000 in May to $255,000 in June?”
2. Choose Your Starting and Ending Values
The starting and ending values should be directly comparable. If your starting point is monthly revenue, your ending point should also be monthly revenue. Avoid mixing unrelated measures, such as revenue and profit, in the same waterfall unless the report clearly explains the transition.
3. Identify the Change Drivers
List the categories that contributed to the movement. In a revenue report, these might include new business, upsells, renewals, churn, returns, and discounts. In a cost report, they might include labor, materials, software, rent, and logistics.
Keep the categories meaningful. Too few categories make the report vague; too many make it hard to read. A practical range is usually 5 to 9 change drivers.
4. Organize the Data Logically
Place the data in a sequence that tells a story. For finance, this often means moving from gross values to net values. For project management, it may mean ordering changes by timeline. For marketing, it may follow the funnel from awareness to conversion.
5. Build the Waterfall Chart
Most spreadsheet and business intelligence tools can create waterfall charts. Use contrasting colors for increases and decreases. For example, green can represent positive movement, red can represent negative movement, and gray or blue can represent totals.
Label bars clearly, but do not overcrowd the visual. If the chart is used in a presentation, include only the most important data labels and explain the details in the speaker notes or accompanying text.
6. Add Commentary and Insights
A chart alone is not a full report. Add a short interpretation that answers: What changed? Why did it change? What should we do next?
For example: “Net revenue increased by 9.4% in July, mainly due to enterprise upgrades. However, customer churn offset $38,000 of potential growth, suggesting retention should be prioritized next month.”
Waterfall Report Best Practices
- Use clean labels: Avoid internal abbreviations unless everyone understands them.
- Separate totals from changes: Make starting and ending values visually distinct.
- Do not hide negative numbers: Losses, churn, and overruns are often the most important insights.
- Keep commentary brief: Readers should not need a long explanation to understand the chart.
- Validate the math: The ending value must equal the starting value plus and minus all changes.
- Match the report to the audience: Executives want decisions; analysts may want supporting details.
Simple Waterfall Report Example
Imagine a retailer reviewing monthly profit:
- Starting profit: $150,000
- Online sales increase: +$40,000
- Store sales decline: -$18,000
- Supplier cost increase: -$12,000
- Reduced advertising spend: +$9,000
- Ending profit: $169,000
The report would show that profit improved by $19,000, but not all performance was positive. Online growth drove the gain, while store decline and supplier costs reduced the final improvement. This creates a more balanced and actionable view than a simple profit total.
Final Thoughts
A waterfall report is powerful because it explains movement with clarity. It helps teams see the causes behind performance, not just the outcome. Whether you are presenting revenue growth, budget variance, project status, or customer churn, the format makes complex changes easier to understand.
The key is to keep the report focused, visual, and action-oriented. Start with a clear question, choose meaningful categories, verify the numbers, and add concise insights. When done well, a waterfall report does more than display data; it helps people make better decisions.