Expansion Revenue Calculator — Expansion Rate and Source Mix

Background.

Expansion revenue is the recurring revenue your existing customers added during a period: upgrades to higher tiers, additional products, extra seats and metered usage above what they had committed to. It is the growth that arrives without the sales team winning a new logo, and in a mature subscription business it is often the largest single source of new recurring revenue. This calculator totals it, expresses it as a rate against the base you started with, splits it into its three operational sources, and shows what share of all your new recurring revenue came from customers you already had.

The boundary that defines expansion is the same one that defines every retention metric. Datadog's Form 10-K puts it plainly: its retention figure "includes any expansion and is net of contraction or attrition over the last 12 months, but excludes ARR from new customers in the current period." Expansion means the customer was already there. That has one consequence worth stating before you enter numbers: a customer who churned in an earlier period and came back during this one was not in the opening base, so their revenue is new business here, not expansion. There is no reactivation field on this page for that reason, and the new-business field is where win-backs belong.

The three-way split groups the movements Instructure enumerates in its own filing, where the retention calculation "contemplates all changes to ARR for the designated customer cohort, which includes ... changes in quantities of users, changes in pricing, additional applications purchased or applications no longer used." Changes in quantities of users are seat and usage growth; additional applications purchased are cross-sell; changes in pricing and tier moves are upsell. Instructure enumerates the movements rather than naming the three buckets, so treat the labels as the standard operational grouping rather than a filed standard — and hold whichever grouping you use constant across periods, because the SEC's guidance on key performance indicators asks anyone presenting a metric like this to define how it is calculated and to disclose a change of method.

Two ratios come out of this page and they are not interchangeable, because they have different denominators. The expansion rate divides expansion by the opening base, and it is exactly the gap between gross and net revenue retention — if your NRR is 105% on a GRR of 87%, your expansion rate is 18%, and that single figure tells you whether a healthy NRR reflects customers staying or customers being sold more. Expansion's share of new recurring revenue divides expansion by expansion plus new business, and it answers a different question: where is the next dollar coming from, and should the next hire sit in sales or in customer success? Because the denominators differ, the two move independently. Doubling new-business revenue leaves the expansion rate untouched while cutting the share-of-new figure — in the default numbers here, from 40% to 25%.

This page deliberately does not accept churn or contraction. Netting losses against expansion is net revenue retention, which is a different calculation with a different question behind it, and it has its own calculator. What you get here is the upside of the ledger on its own, decomposed — which is the view you need when the question is not "did we hold the base" but "what is actually driving growth inside it".

What is expansion revenue calculator?

Expansion revenue is recurring revenue added by customers who were already in the base at the start of a measurement period. It comprises upsell (moves to a higher tier, and contractual price increases), cross-sell (additional products, modules or add-ons sold into an existing account), and seat or usage growth (extra licences and metered consumption above the committed level). It explicitly excludes revenue from customers acquired during the period, and excludes win-backs of accounts that had previously churned, because neither was part of the opening base. The expansion rate expresses that total as a percentage of the opening recurring revenue: expansion ÷ opening base. It is the same quantity that separates gross revenue retention from net revenue retention, since NRR = GRR + expansion rate over a shared denominator. Expansion revenue is not a GAAP or IFRS concept and no accounting standard defines its components, so the categories you use and the treatment of edge cases like automatic price uplifts and reactivations are conventions you set and should hold constant. This calculator reports total expansion, the expansion rate, the split across the three sources, and expansion as a share of total new recurring revenue. It does not net churn or contraction against expansion — that is net revenue retention, which has its own page.

How to use this calculator.

1. 01Enter the recurring revenue in force on day one of the period, counting only customers you already had. Use ARR for an annual view and MRR for a monthly one; the ratios are unit-free as long as every field uses the same basis.
2. 02Enter upsell: existing customers moving to a higher plan, plus any contractual price uplifts. If your own reporting excludes automatic uplifts, exclude them here too — and expect your figure to differ from published ones that include them.
3. 03Enter cross-sell: additional products, modules or bundles sold into accounts that already had the core product.
4. 04Enter seat and usage growth: added seats, licences and metered consumption above the committed level from existing accounts.
5. 05Enter new-business recurring revenue from customers signed during the period. This is not counted as expansion — it is used only for the share-of-new-revenue figure. Put win-backs of previously churned accounts here, not in the expansion fields.
6. 06Read the expansion rate and the share of new recurring revenue as two separate answers. The first tells you how hard the installed base is working; the second tells you where growth is coming from overall.
7. 07Use the source split to decide where to act. Seat and usage growth is the most exposed to a customer's own headcount and budget, so a mix concentrated there is more fragile than the same total concentrated in cross-sell.

The formula.

Total expansion is the sum of the three sources: upsell plus cross-sell plus seat and usage growth. With the default figures — $280,000 + $120,000 + $200,000 — that is $600,000. The expansion rate divides that total by the opening recurring revenue base: $600,000 ÷ $4,000,000 = 15.00%. This is the same quantity that separates gross from net revenue retention, because both are measured against the same opening base: NRR = GRR + expansion rate. Expansion's share of new recurring revenue uses a different denominator — expansion plus new-business revenue — so with $900,000 of new business the figure is $600,000 ÷ $1,500,000 = 40.00%. Forty cents of every new recurring dollar came from customers who were already there. The two ratios are independent: doubling new business to $1,800,000 leaves the expansion rate at 15.00% and drops the share of new revenue to 25.00%, because only the second denominator moved. The three component shares divide each source by the expansion total: $280,000 ÷ $600,000 = 46.67% upsell, $120,000 ÷ $600,000 = 20.00% cross-sell, $200,000 ÷ $600,000 = 33.33% seat and usage. They sum to 100% by construction, and are computed from unrounded components so the sum holds before display rounding. Two divisions are defined rather than performed. When total expansion is zero, all three component shares are reported as 0% rather than an undefined value, and the text output says no expansion was recorded. When expansion and new business are both zero, the share of new recurring revenue is likewise reported as 0%. All arithmetic is carried at full arbitrary-precision decimal width and nothing is rounded until the result is returned.

A worked example.

Frequently asked questions.

References& sources.

1. [1]Instructure Holdings, Inc. — Form 10-K for the fiscal year ended December 31, 2022 (accession 0000950170-23-003203), Item 7 MD&A, "Net Revenue Retention Rate; Gross Revenue Retention Rate": the calculation "contemplates all changes to ARR for the designated customer cohort, which includes customer terminations and non-renewals, customer consolidations, changes in quantities of users, changes in pricing, additional applications purchased or applications no longer used." Cited as the filed enumeration of the expansion movements this page groups into upsell, cross-sell and seat/usage. Instructure enumerates the movements; it does not use those three labels. Retrieved 2026-07-29.
2. [2]Datadog, Inc. — Form 10-K for the fiscal year ended December 31, 2020, Item 7 MD&A: "Current Period ARR includes any expansion and is net of contraction or attrition over the last 12 months, but excludes ARR from new customers in the current period." Cited for the boundary between expansion and new business, which also governs the treatment of win-backs. Retrieved 2026-07-29.
3. [3]Box, Inc. — Form 10-K for the fiscal year ended January 31, 2025, Item 7 MD&A, "Net Retention Rate": net retention is "the net percentage of Total Annual Recurring Revenue (Total ARR) retained from existing customers, including expansion"; the company attributes pressure on its rate to "heightened budget scrutiny, putting pressure on seat expansion within existing customers", and notes that customers who "purchase add-on products or our bundled plans" show higher average contract values and stronger net retention rates. Cited for the distinct behaviour of the seat and cross-sell expansion sources. Retrieved 2026-07-29.
4. [4]U.S. Securities and Exchange Commission — Commission Guidance on Management's Discussion and Analysis of Financial Condition and Results of Operations, Release Nos. 33-10751; 34-88094; FR-87, 85 Fed. Reg. 10568 (Feb. 25, 2020), Section II "Key Performance Indicators and Metrics", pp. 10569–10570: a registrant presenting a metric should give "a clear definition of the metric and how it is calculated", and on changing the method should disclose "the differences in the way the metric is calculated or presented compared to prior periods", the reasons and the effects. Official Federal Register text via GPO govinfo. Retrieved 2026-07-29.