Net Revenue Retention Calculator

(NRR & GRR Tool)

Calculate Net Revenue Retention and Gross Revenue Retention from your existing customer cohort's expansion, contraction, and churn — deliberately excluding new business.

Existing Customer Cohort Only — Exclude New Business

From customers you had at the beginning of the period

Upgrades, upsells, and add-ons from those same existing customers

Downgrades from existing customers

Lost entirely from existing customers who canceled

Calculated Results

Enter your starting MRR and its movement to calculate net revenue retention.

The One SaaS Metric That Ignores New Sales on Purpose

Net Revenue Retention deliberately excludes new customer revenue to answer one specific question: is the existing customer base, left entirely alone, growing or shrinking? A business could be adding logos every month and still have a declining NRR if churn and downgrades are quietly eating away at the customers already on the books.

NRR % = ((Starting MRR + Expansion − Contraction − Churn) ÷ Starting MRR) × 100

Worked Example

A SaaS company starts the month with $100,000 in MRR from its existing customers. That same cohort adds $8,000 in expansion (upgrades), loses $3,000 to downgrades, and $4,000 to cancellations.

NRR = ($100,000 + $8,000 − $3,000 − $4,000) ÷ $100,000 = 101%

GRR for the same cohort, excluding the $8,000 expansion credit, would be ($100,000 − $3,000 − $4,000) ÷ $100,000 = 93% — the gap between the two numbers is entirely explained by upsell revenue.

Frequently Asked Questions (FAQ)

NRR as a percentage can't go below 0%, but it can drop well below 100% if churn and contraction badly outweigh expansion — some struggling SaaS businesses report NRR in the 70%–85% range, meaning existing customers alone are shrinking revenue by 15%–30% a year.

Both are common — investors most often see NRR reported annually or on a trailing-twelve-month basis, since a single month can be noisy. This calculator works for whatever period you enter the MRR figures for, monthly or annual.