Net Dollar Retention Calculator

Quickly understand your organization’s financial health.

Check icon
Say goodbye to the hassle of finding a reliable Net Dollar Retention calculator!
Check icon
Effortlessly copy and save the calculator for continuous use.
Check icon
Tailor the calculator to reflect your company's unique characteristics and needs.

Net Dollar Retention (%) = [(End of Month Revenue – Expansion Revenue – Contraction Revenue) / Start of Month Revenue] * 100

How to Calculate Net Dollar Retention (NDR)

  1. Identify Starting MRR: Monthly Recurring Revenue at the start of the period.
  2. Calculate Expansion Revenue: Revenue gained from upsells or cross-sells during the period.
  3. Determine Churned Revenue: Revenue lost from downgrades or cancellations.
  4. Apply the NDR Formula: Use the collected metrics in the formula above.

Understanding Net Dollar Retention

Net Dollar Retention (NDR) is a crucial SaaS and subscription business metric.

It highlights revenue retention and expansion from existing customers over a given period, accounting for churn and downgrades.

Why Net Dollar Retention Matters

NDR is pivotal for understanding customer value and business growth sustainability. 

High NDR indicates strong customer satisfaction and product-market fit, while improvements in NDR directly correlate with increased company valuation.

Real-world Example: NDR in Action

Consider a SaaS company that focuses on customer success initiatives to reduce churn and promote upsells. 

By enhancing product offerings and customer support, the company sees a rise in NDR, reflecting improved customer loyalty and revenue growth.

Improvement Strategies to Boost Your NDR

  • Enhance Customer Success: Implement proactive support and success planning.
  • Upsell and Cross-sell: Develop additional value-added services or products.
  • Customer Feedback Loop: Use feedback to drive product improvements.
  • Retention Programs: Create loyalty and incentive programs for long-term customers.
  • Pricing Flexibility: Adjust pricing strategies to encourage upgrades.

How to Calculate Net Dollar Retention in Google Sheets

  1. Input your Starting MRR in cell A1.
  2. Enter Expansion Revenue for the period in cell B1.
  3. Record Churned Revenue in cell C1.
  4. In cell D1, input the formula: =(A1 + B1 – C1) / A1 * 100.
  5. The result in D1 is your Net Dollar Retention rate.

Net Dollar Retention Limitations

  • Doesn’t account for new customer acquisition.
  • Can mask underlying issues if overall revenue is growing.
  • May vary significantly with business model or market changes.

When to Apply Net Dollar Retention

NDR is most applicable for SaaS or subscription-based businesses, especially for internal assessments of customer value and product-market fit, strategic planning, and investor reporting.

One Click Spreadsheet Connectors Sync Live Data into Your Spreadsheet No need to export data manually and rebuild stale dashboards. Sync it & set it on refresh in Google Sheets or Excel.