How to Build a SaaS Revenue Bridge

A revenue bridge shows exactly how you got from last period’s recurring revenue to this period’s, broken down by new customers, expansion, contraction, and churn. A revenue bridge chart helps visualize changes in a company’s revenue over time, making it easier to identify the specific drivers behind those changes.

This simple visual transforms how you understand your growth. Bridge charts are a key tool for breaking down and interpreting a company’s revenue growth, allowing you to see how factors like volume, pricing, and product mix contribute to overall performance.

Most companies just show revenue going up and call it success. The bridge breaks revenue into its key components for clearer analysis, revealing whether you’re growing from new customer acquisition or existing customer expansion, whether churn is accelerating, and where your business model is working or breaking. Build one every month and you’ll spot problems quarters before they hit your P&L.

Why Revenue Bridges Matter More Than Revenue Growth

Every SaaS company celebrates when revenue grows 15% quarter over quarter. Understanding the importance of what drives that revenue growth is critical for sustainable success. The board deck shows a lovely upward curve. Everyone’s happy. Nobody asks uncomfortable questions.

Then six months later, growth has stalled and nobody can explain why. Marketing says they’re hitting lead targets. Sales says they’re closing deals. The product team shipped new features. But growth went from 15% to 5% and the only explanation is “the market.”

The revenue bridge would have shown the problem months earlier. Here’s what was actually happening: New customer revenue stayed flat, expansion revenue dropped by half, and churn doubled. The aggregate number still showed growth, but the components revealed a business in trouble.

This is why we build revenue bridges for every client, every month, without exception. The bridge forces you to understand growth composition and helps determine the specific factors contributing to changes in revenue, rather than just celebrating that the number went up.

The Basic Structure: From Starting MRR to Ending MRR

A revenue bridge has five components:

Starting MRR (starting value): What you ended last period with
Plus: New MRR from new customers acquired this period
Plus: Expansion MRR from existing customers upgrading, buying more seats, or adding products
Minus: Contraction MRR from existing customers downgrading or reducing seats
Minus: Churn MRR from customers who cancelled completely
Equals: Ending MRR (ending value)

Here’s a real example from a $4M ARR SaaS company that faced several financial red flags common in early-stage SaaS businesses:

Starting MRR (January 1): $333K
New customer MRR: +$48K
Expansion MRR: +$12K
Contraction MRR: -$6K
Churn MRR: -$11K
Ending MRR (January 31): $376K

The bridge shows they grew $43K in net new MRR, which is 12.9% month-over-month growth. But look at the composition: 74% came from new customers ($48K), 19% from expansion ($12K), offset by 20% erosion from contraction and churn ($17K combined). The volume impact from new customer acquisition and expansion played a significant role in driving the increase in MRR.

This company celebrated strong growth, but the bridge revealed a problem. Their new customer acquisition was masking the fact that existing customers were eroding at 5% monthly ($17K erosion on $333K base). Fix that erosion and growth accelerates dramatically. Miss it and you hit a wall when new acquisition slows.

Building It in Practice: Data You Need

Most companies can’t produce a revenue bridge because their data isn’t organized correctly. Here’s what you need:

A customer list with current MRR for each customer. Updated monthly. This seems obvious but many companies track customers in sales systems, billing systems, and accounting systems that don’t reconcile.

Historical MRR for each customer by month. You need to know what each customer was paying last period to calculate changes. If Customer A is paying $5K now and paid $4K last month, that’s $1K of expansion.

Reason codes for changes. When a customer’s MRR changes, tag it: new customer, upgrade, downgrade, churn. This lets you categorize changes into the right buckets.

Clean signup and churn dates. When did each customer start? When did they end? This prevents double-counting or missing transitions.

• Tracking revenue by unit or different products can provide deeper insights into revenue changes and help you analyze performance across your offerings.

Here’s how to build the bridge from this data:

Pull your customer list with current MRR. That’s your ending MRR. Pull the same customer list from last month. That’s your starting MRR. Compare the two lists customer by customer. Customers who exist in both lists with higher MRR: that’s expansion. Customers who exist in both lists with lower MRR: that’s contraction. Customers who exist in this month but not last month: that’s new. Customers who existed last month but not this month: that’s churn.

Sum each category. Now you have your bridge.

If this feels manual and tedious, it is. That’s why mature SaaS companies use tools like ChartMogul or build custom data systems to automate bridge generation. But every company should build it manually at least once to understand what goes into it. Analyzing revenue bridge data by unit or different products can help identify which areas drive the most growth or churn.

Visualizing Revenue Changes

Visualizing revenue changes is a powerful way to unlock deeper insights into your company’s revenue growth and financial performance. While data tables and monthly reports provide the raw numbers, a revenue bridge chart transforms that data into a clear, actionable story. By using a stacked column chart or waterfall chart, you can break down the key components of revenue growth—such as volume, price, and mix impact—and see exactly how each factor contributes to changes in your top line.

To get started, gather the necessary data: sales figures, expenses, gross profit, and any other relevant financial data that impacts your company’s revenue. Organize this information into a data table with well-defined columns for each key component. This structure makes it easy to track trends and pinpoint the underlying drivers of revenue changes over one period or across multiple periods.

When building your revenue bridge chart, use data labels to clearly identify each segment—such as new sales, price increases, or shifts in product mix. Adjust colors to highlight positive and negative impacts, making it easy for stakeholders to spot areas of performance improvement or concern at a glance. For example, use green for positive drivers like increased units sold or higher prices, and red for negative factors such as lost sales or unfavorable product mix shifts.

Tools like Excel and Google Sheets make it simple to create these visual representations. Both platforms offer built-in options for stacked column charts and waterfall charts, allowing you to customize your analysis with just a few clicks. By visualizing your financial data, you can quickly explain changes in revenue, calculate the impact of different factors, and support strategic planning with concrete evidence.

A well-constructed revenue bridge chart doesn’t just show what happened—it reveals why it happened. If your analysis shows that most revenue growth came from price impact rather than volume, you might consider further pricing optimization. If mix impact is dragging down gross profit, it could be time to reevaluate your product strategy or sales focus. These insights are invaluable for driving performance improvement and increasing profitability.

In summary, visualizing revenue changes with a revenue bridge chart is essential for any business aiming to understand its financial trends and make data-driven decisions. By breaking down the key components of revenue growth and presenting them in a clear, visual format, you empower your team to identify opportunities, address challenges, and drive sustained growth. Whether you’re using Excel, Google Sheets, or another tool, the process of creating and analyzing a revenue bridge chart should be a core part of your financial analysis and strategic planning toolkit.

What the Bridge Tells You About Business Health

The revenue bridge patterns reveal everything about your business model health.

Healthy SaaS growth pattern: New customer MRR and expansion MRR are both growing month over month, churn is flat or declining as a percentage of starting MRR, contraction is minimal (under 2% of starting MRR).

New customer MRR growing, expansion flat, churn rising: You’re acquiring customers but they’re not seeing enough value to expand, and more are leaving. This suggests product-market fit issues or poor onboarding.

New customer MRR flat, expansion growing, churn declining: You’ve figured out how to serve existing customers well but haven’t cracked acquisition. This is a good problem—scale what’s working with current customers, then fix acquisition.

All categories declining: Your business is in crisis. Customers are leaving faster than you’re adding them, and the ones who stay aren’t expanding. You need to fix core value proposition before focusing on growth.

Track these ratios monthly:

New MRR as percentage of net new MRR: Shows how dependent you are on acquisition versus expansion. Expansion MRR as percentage of starting MRR: Should be 3-5% monthly for healthy B2B SaaS. Gross churn (churn + contraction) as percentage of starting MRR: Should be under 2% monthly for SMB, under 1% for mid-market, under 0.5% for enterprise. Net revenue retention: Starting MRR plus expansion minus churn minus contraction, divided by starting MRR. Above 100% is good, above 110% is great.

We worked with a company showing 8% monthly growth that looked strong until we built the bridge. They were adding $80K in new customer MRR but losing $35K to churn and contraction, netting $45K growth on a $560K base. Their gross churn rate was 6.25%—way too high. The business model was fundamentally broken despite top-line growth.

Understanding these revenue bridge patterns is also essential for accurate company valuation, especially when preparing for mergers and acquisitions. Strategic assessment of these metrics helps identify value drivers and supports a compelling narrative to maximize your business’s valuation.

Segmenting the Bridge for Deeper Insights

Don’t stop at one aggregate bridge. Segment it by anything that might reveal patterns:

Build separate bridges by customer size (SMB, mid-market, enterprise). Usually you’ll find SMB has high new MRR but also high churn, enterprise has low churn but slow acquisition. This informs resource allocation.

Build bridges by acquisition channel. Do customers from paid search expand and retain like customers from direct sales? If not, you’re acquiring different quality customers from different channels.

Build bridges by cohort vintage. Compare customers who signed up 6 months ago versus 18 months ago. Older cohorts should have lower churn and higher expansion rates as they mature.

Build bridges by product tier or feature set. Does your premium product have better retention and expansion than basic? That tells you where to focus product development.

A segmented bridge might reveal that your enterprise segment has 120% net revenue retention while SMB has 85% retention. Knowing this changes your entire strategy—pour resources into enterprise, reduce or eliminate SMB acquisition.

Using Bridges to Forecast Revenue

Once you have historical bridges, you can forecast revenue bottoms-up instead of guessing at growth rates.

Take your current MRR base. Apply historical new MRR rates (maybe you average $50K in new customer MRR monthly). Apply historical expansion rates (maybe 4% of starting MRR). Apply historical churn and contraction rates (maybe 2.5% combined).

Run this forward month by month. This gives you a realistic revenue forecast based on actual historical performance, not aspirational growth targets.

Now model scenarios:

Best case: New MRR increases 20%, churn drops 25% Base case: Everything continues at current rates Worst case: New MRR drops 20%, churn increases 25%

This shows your revenue range. Investors and boards want to see this because it demonstrates you understand your business drivers, not just revenue.

We build 36-month forecasts for clients using bridge methodology. It’s dramatically more accurate than trend-based projections because it accounts for churn compounding, expansion accelerating, and new customer mix changing.

Common Mistakes When Building Bridges

Confusing bookings with MRR. If you sign a $100K annual contract, that’s $100K in bookings but only $8,333 in MRR. The bridge tracks MRR, not bookings.

Not handling one-time fees correctly. Implementation fees, professional services, one-time setup charges are not MRR and should not be in the bridge. Only recurring revenue belongs here.

Miscategorizing upgrades and downgrades. If a customer goes from $500/month to $800/month, that’s $300 expansion, not a new customer. If they go from $800 to $500, that’s $300 contraction, not churn.

Forgetting about reactivations. If a customer churned three months ago and comes back now, they’re not a new customer—they’re a reactivation. Track this separately so you understand win-back rates.

Not reconciling to financial statements. Your ending MRR should match your revenue run rate (with timing adjustments for annual contracts and revenue recognition). If they don’t match, your bridge has errors or your accounting does.

Only building it quarterly. Revenue bridges need to be monthly. Quarterly hides too much. A spike in May churn gets averaged into Q2 and you miss the signal that something broke in May.

What Good Revenue Bridge Analysis Looks Like

Companies that master revenue bridges review them in monthly leadership meetings. Not just the CFO, everyone. Sales needs to see that new MRR is slowing. Product needs to see that expansion is declining. Success needs to see that churn is concentrated in a specific segment.

The bridge becomes the single source of truth for understanding growth. When someone says “we’re growing 15% monthly,” the next question is “what’s the composition?” If they can’t answer, they don’t really understand the business.

The bridge drives strategic decisions. You see that new MRR is strong but expansion is weak—that’s a product problem. You see that churn is accelerating in Q4 cohorts—that’s an onboarding problem. You see that enterprise expansion is 2x higher than SMB expansion—that’s a go-to-market prioritization signal.

Most importantly, the bridge reveals problems early when they’re still fixable. Aggregate revenue can grow for 2-3 quarters while underlying trends deteriorate. The bridge shows those trends the month they start, giving you time to respond instead of react.

Q: Should we track revenue bridge on bookings, revenue recognized, or cash collected?

Track it on MRR (monthly recurring revenue), which is different from all three. Bookings is contract value signed, revenue recognized follows accounting rules, cash collected is when money hits the bank. MRR represents the recurring revenue run rate and is the right metric for understanding SaaS business momentum. You can also build bridges for bookings (useful for sales planning) and cash (useful for cash flow management), but the MRR bridge is the core analysis.

Q: How do we handle annual contracts in the revenue bridge?

Convert annual contracts to monthly equivalents. A $120K annual contract is $10K MRR. When the customer signs, show +$10K new MRR in that month’s bridge. If they churn after 12 months, show -$10K churn MRR in that month. Don’t show +$120K in month 1 and zero for 11 months—that’s bookings accounting, not MRR bridge accounting. The point is to normalize everything to monthly recurring value.

Q: What’s a realistic target for expansion MRR as a percentage of starting MRR?

For B2B SaaS, target 3-5% monthly expansion MRR (as a percentage of starting MRR) which compounds to 40-80% annually. This comes from a combination of seat expansion, upsells to higher tiers, cross-sells of additional products, and price increases. SMB SaaS typically sees lower expansion (1-2% monthly) due to smaller customer sizes limiting expansion opportunity. Enterprise SaaS can see higher expansion (5-8% monthly) with large land-and-expand motions. If you’re under 2% monthly expansion, you’re leaving significant growth on the table.

Conclusion:
Revenue bridge analysis and bridge charts are essential tools for understanding the drivers behind revenue growth and identifying areas for improvement. By providing a clear breakdown of revenue components, these charts support competitive analysis, performance assessment, and data-driven decision making. Leveraging revenue bridge analysis enables leadership teams to make strategic decisions, address issues proactively, and drive sustainable company performance.