Subscription Expansion Forecast

A software company has 1,000 customers and expects some to add seats next quarter, so it models which contracts can expand, when the change may take effect and the extra recurring value, rather than multiplying all accounts by an ambitious upgrade percentage. Define expansion precisely: a paid tier upgrade, more seats or increased contracted usage can count, while a one-off implementation fee usually belongs in a different category, so separate recurring and nonrecurring amounts.

Start from the opening customer base, identifying plans, contract terms, usage patterns and renewal dates, because a customer whose agreement prohibits midterm changes should not be forecast as an immediate expansion without a supported amendment path. Stripe's SaaS forecasting guide lists expansion and contraction alongside churn as drivers of recurring revenue, and notes that expansion can be unpredictable, so assumptions need review rather than a fixed top-down growth rate.

Use historical cohorts where they help, since customers of different ages, sizes or product types may expand at different rates, and avoid applying a mature-enterprise expansion pattern to brand-new small accounts. Distinguish opportunity from commitment: a customer using 90% of a seat limit may need more capacity but could also remove inactive users, and a signed order or confirmed renewal has stronger evidence than product usage alone.

Model timing, because an upgrade agreed in March may start billing in April and its recognised revenue may follow accounting policy over the service period, so state whether the forecast is monthly recurring revenue, billings or cash. An illustrative expansion MRR forecast is the sum of expected incremental monthly recurring amounts from existing customers, so if five existing accounts add $200 per month each, the forecast addition is $1,000 of MRR once all upgrades are effective, which is not $1,000 of new-customer MRR.

Track downgrades separately, since a forecast of $10,000 expansion and $4,000 contraction has net existing-account growth of $6,000 before cancellations, and the contraction should not be hidden inside a single positive number. Stripe's net revenue retention guidance describes changes to recurring revenue from an existing customer group, including expansion, contraction and churn, so expansion contributes to retention but the metrics are not interchangeable.

Use pipeline evidence with care, as sales teams may have open expansion opportunities whose close dates and amounts are uncertain, so calibrate stage probabilities against actual outcomes rather than assigning all quoted value to the forecast. Account for usage-based pricing, where higher consumption may produce more revenue without a formal upgrade but volume may vary, using credible usage drivers and distinguishing committed minimums from variable upside.

Review product changes and limits, since a new feature may open an upgrade path while a pricing migration can create apparent expansion without more use, and document the source of growth so trends remain understandable. Avoid pressuring customers to fit a forecast, because a helpful expansion offer should solve a genuine need and respect agreed terms, and revenue targets do not authorise surprise charges or unwanted plan changes.

Compare forecast with actual changes by recording the number of expanding accounts, average increment and effective dates, since a miss can arise from fewer upgrades or slower activation, each requiring a different response. Use scenarios, with a conservative case that may include only signed changes and a broader case that may include qualified opportunities, and show the difference to avoid basing fixed spending on speculative upgrades.

Keep the denominator clean, because customers acquired after the opening date belong to new-business revenue until a later cohort analysis, and otherwise the model can relabel acquisition as expansion. For an owner, the expansion forecast shows how much growth may come from customers already served, and it is most useful when amounts, timing and evidence are visible alongside churn and downgrades.