Expansion rate on starting ARR
Expansion ÷ beginning ARR × 100—use alongside **net-revenue-retention** when segmenting upsell motion separately.
Example scenario
A vertical SaaS CFO closes fiscal April with four million two hundred thousand dollars in recognizable subscription ARR carried forward from March cohort reporting before churn adjustments post-quarter-close. Account management books three hundred fifteen thousand dollars in incremental annualized contract value from seat adds, storage tiers, and SKU expansions net of same-period downsell routed elsewhere in the revenue waterfall. Expansion dollars divided by beginning ARR yields seven point five percent expansion rate on starting ARR—while modeled ending ARR from expansion alone reaches four million five hundred fifteen thousand dollars before layering contraction or logo churn in the net-retention bridge.
Expansion rate on starting ARR
Expansion $ ÷ beginning ARR × 100
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
How to calculate expansion rate on beginning ARR
- Input beginning ARR ($) from the snapshot immediately before the measurement window—usually quarter-open booked ARR per revenue recognition policy excluding pending renewals not yet live.
- Input expansion and upsell ARR ($) booked inside that window from upsell orders, cross-sell SKUs, consumption step-ups, or uplifted platform fees—excluding brand-new logos counted in new-business bookings.
- Read expansion rate as the percentage of starting ARR replaced by expansion bookings—sanity-check numerator plus denominator currency windows match finance’s ARR definition.
- Compare ending ARR if only expansion (no churn modeled) against CRM waterfalls when communicating hypothetical upside before netting downgrade and churn buckets.
Expansion contribution planning context (B2B SaaS, directional)
- Net revenue retention targets cited among venture-backed SaaS benchmarks
- Strong SaaS businesses often aim materially above one hundred percent net revenue retention—expansion partially offsets churn depending on segment ACVs
- Seat-and-usage expansion as share of growth
- Product-led and consumption models frequently emphasize expansion faster than new-logo bookings once install bases mature—rates vary by pricing granularity
- Annual versus quarterly measurement cadence
- Board decks typically compare trailing-twelve-month logos against trailing-twelve-month cohort revenue—misaligned windows distort expansion-rate percentages
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Should expansion ARR include professional-services uplifts or usage spikes billed monthly?
Follow whatever feeds your net-revenue-retention model—many SaaS teams normalize recurring subscription expansion separately from one-time services while consumption businesses fold metered overages into expansion when those streams qualify as durable ARR under ASC 606 judgment calls.
Why is my expansion rate higher than net revenue retention implies?
Expansion rate isolates upsell dollars versus beginning ARR while net revenue retention nets churn and contraction. Large churn masks expansion wins—present both metrics side by side so boards see gross expansion versus net retention.
Do multi-year prepayments distort expansion numerator?
Book expansion ARR using recognized annualized values aligned with revenue schedules rather than invoice totals when contracts accelerate cash but recognize ratably—otherwise expansion spikes look inflated versus GAAP ARR balances.
Can beginning ARR be segment-filtered while expansion totals stay company-wide?
Only if you intentionally blend ratios—usually mismatched filters double-count. Restrict expansion dollars to the same customer cohort as beginning ARR when calculating expansion velocity by segment or geography.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: SaaS metrics & revenue analyticsTopics: Expansion ARR rate, Net revenue retention inputs, Upsell velocity
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team