How to Calculate Expansion Revenue (With Examples)

Here is how I calculate expansion revenue. Expansion revenue is the extra recurring revenue that customers who were already paying at the start of a period add during that period, through more seats, higher tiers, add-ons, usage or price increases. To calculate it, add up each existing account's increase: expansion MRR = Σ (ending MRR − starting MRR) for every existing account whose MRR went up. Divide by starting MRR for the expansion rate: $48,000 on a $400,000 base is 12%.

The free NRR and GRR calculator shows how expansion moves your retention numbers. This is the final part of my SaaS Retention Metrics series. In part 3 we split customer churn from revenue churn; this part covers the growth that comes from customers you already have.

What counts as expansion revenue?

Expansion is the positive term in net revenue retention, and the only reason NRR can go above 100%.

Counts as expansion	Does not count
More seats or licences	New customers, even if they upgrade in month 1
Tier upgrades	Reactivated customers (track separately)
Add-on products (cross-sell)	One-time fees such as implementation or training
Usage above commitment	Contraction (it gets its own line)
Price increases on existing contracts

Use one revenue basis throughout, MRR or ARR.

How do you calculate expansion revenue?

Expansion MRR  = Σ max(0, Ending MRR − Starting MRR)
                 for each account that was paying on day 1
Expansion rate = Expansion MRR ÷ Starting MRR × 100

Starting MRR = recurring revenue of that account on day 1 of the period
Ending MRR   = recurring revenue of the same account on the last day
max(0, …)    = only increases count; decreases go to contraction or churn

Calculate per account first, so one customer's upgrade never cancels out another customer's downgrade. In a sheet with starting MRR in column B and ending MRR in column C: =SUMPRODUCT((C2:C251>B2:B251)*(C2:C251-B2:B251)).

What does an expansion revenue calculation look like?

Say you have 250 accounts with $400,000 starting MRR. By quarter end, 30 accounts increased spend by $48,000, 15 downgraded by $10,000, and 8 cancelled, taking $16,000.

• Expansion rate = $48,000 ÷ $400,000 × 100 = 12.0%
• Net expansion = $48,000 − $10,000 = $38,000, or 9.5% of starting MRR
• GRR = ($400,000 − $10,000 − $16,000) ÷ $400,000 × 100 = 93.5%
• NRR = ($400,000 + $48,000 − $10,000 − $16,000) ÷ $400,000 × 100 = 105.5%

NRR minus GRR equals the expansion rate: 105.5% − 93.5% = 12 points. If your NRR and gross revenue retention don't differ by exactly that much, one input is defined inconsistently. Check yours with the NRR calculator.

Where does expansion revenue come from?

Source	Expansion MRR	Share
Seat or licence growth	$18,000	37.5%
Tier upgrades	$12,000	25.0%
Add-on products (cross-sell)	$8,000	16.7%
Usage above commitment	$6,000	12.5%
Price increases	$4,000	8.3%

Source share = source expansion MRR ÷ total expansion MRR × 100. For seats: $18,000 ÷ $48,000 × 100 = 37.5%.

Seats, tiers and add-ons usually mean customers are getting more value, and they tend to stick. Usage overages can reverse next quarter. Price increases come from your decisions, and you cannot repeat them every quarter without raising churn risk.

Is my expansion revenue sustainable?

I run four tests before I share an expansion number:

1. Source quality. Seats, tiers and add-ons total $38,000, or 79.2% of expansion. I give the other 20.8% less weight in forecasts.
2. Coverage. Expansion MRR ÷ (churned MRR + contraction MRR) = $48,000 ÷ $26,000 = 1.85x. Above 1.0x, growth from the base outpaces losses. If you also want new business in the picture, the SaaS quick ratio calculator adds new MRR to the top line.
3. Breadth. 30 of 250 accounts expanded, or 12%. Narrow expansion is fragile.
4. Concentration. If the top 5 accounts gave $27,000, that is 56% of the total. Not bad in itself, but the quarter depended on a few relationships.

What I've seen in practice

A strong quarter that came mostly from two partners' seasonal volume looked great in the review, then reversed the next quarter. Breadth and concentration would have warned us. Now I check both before any expansion number leaves my desk.

Tag a reason code on every subscription change when it happens. On one team I worked with, we rebuilt the sources at quarter end from invoice notes. It took two people most of a week, and about a third of the changes still landed in "other". A required reason field in the CRM fixed it.

Agree before the quarter who gets credit for each source, so the numbers don't turn into a debate afterwards. At account level, the QBR template is where I connect a customer's outcomes to the seats or modules they may add next.

My expansion dashboard

I report expansion monthly, so the targets below are monthly rates on the same 250 accounts.

Metric	Target	This month	Last month	Change
Expansion rate	3.0%	3.6%	3.1%	+0.5 pts
Coverage (expansion ÷ losses)	1.5x	1.85x	1.4x	+0.45x
Accounts expanding	5%	5.6%	4.0%	+1.6 pts
Share from seats, tiers, add-ons	75%	79%	71%	+8 pts
Top 5 accounts' share	under 50%	56%	48%	+8 pts

Everything improved except concentration, which is the line I would raise first in the review. The series' retention metrics dashboard newsletter puts expansion next to NRR, GRR and churn on one page.

Frequently asked questions

What is the difference between expansion and net expansion?

Gross expansion counts only increases. Net expansion subtracts contraction, and NRR also subtracts churn.

Does a price increase count as expansion revenue?

Yes, if it raises recurring revenue from an existing customer. I report it as its own source, because it is not a sign of more usage or value.

Is upsell revenue from a new customer expansion?

Not in the period they signed. A customer who was not paying on day 1 is new business for that whole period.

What is a good expansion rate?

It depends on your pricing model. Seat- and usage-based products expand more easily than flat-fee contracts. I watch the trend and the coverage ratio rather than one target.

Sources

• Scaling to $100 Million, Bessemer Venture Partners (section "Gross and net retention")
• Net revenue retention, Stripe