How to Build a Revenue Waterfall in Google Sheets (No MBA Required)

Are you leaving thousands in revenue on the table because you can't see where your money leaks?

Most SaaS founders track leads and revenue separately — they see the top and bottom but miss the waterfall in between. That's how you lose customers during onboarding, fail to upsell happy users, or bleed MRR without noticing until it's too late.

Here's what a proper revenue waterfall looks like: leads → conversions → initial MRR → expansion revenue → contraction/churn → net retained MRR. Each stage compounds or leaks.

The Simple Google Sheets Approach

You don't need HubSpot or Salesforce for this. A single Google Sheets workbook with four tabs will show you everything:

Tab 1: Dashboard

Displays MRR, net retention rate, expansion percentage, and churn rate — all auto-calculated from raw data. Put a sparkline chart here for visual impact at board meetings.

Tab 2: Conversion Funnel

Track lead source, volume, conversion rate, new customers, and initial MRR. Example formula for new customers: =ROUND(Leads*ConversionRate/100,0). Pre-fill 30 rows with realistic industry data to understand the mechanics immediately.

Tab 3: Retention & Churn

Track existing customers by cohort. Note contraction revenue (downgrades) and expansion (upsells). Net revenue per cohort = expansion - contraction.

Tab 4: Waterfall Chart Builder

Google Sheets sparkline supports waterfall charts: =SPARKLINE(data, {"charttype","waterfall";"color","#1a73e8";"negative","#e8453c"}). Input the total pipeline amount, conversion value, expansion, contraction, and final retained MRR.

The Key Insight No One Talks About

Your expansion revenue from existing customers should exceed your churn. If it doesn't, you're running on a treadmill — every dollar of new MRR replaces lost dollars. A waterfall model shows you this instantly.

If your net retention rate drops below 100%, your growth is unsustainable without constant new customer acquisition. Fix churn before scaling acquisition.

Free Resource

I built a complete Revenue Waterfall Calculator — Google Sheets (4 tabs, pre-filled with 30 rows of realistic SaaS data, all formulas exposed).

Grab the template here — it's $27 and will save you 4-6 hours of spreadsheet-building time.

Happy forecasting!