An account count is not collected recurring revenue
Begin with a definition of an active paid member at a specified date. Exclude or separately identify free accounts, paused plans, failed payments and canceled members still present in an export. Reconcile the POS membership record to processor settlements, refunds and bank deposits.
A growing headline count can hide weak collections or heavy promotional discounting. A stable total can hide high cancellations offset by expensive new joins. The buyer needs a bridge between operational activity and cash, not just a screenshot of the dashboard.
Build a monthly membership roll-forward
Record beginning active paid members, gross paid joins, voluntary cancellations, involuntary payment failures, pauses, reactivations, transfers and ending members. Decide whether changes happen at period start, throughout the period or at period end. Keep the definition consistent across months.
Monthly cohort attrition is different from net member growth. If 1,000 beginning members lose 40 and gain 40, ending members remain at 1,000; that does not mean churn is zero. Separate member churn from revenue churn when prices or plans change.
| Metric | Definition to document | Useful check |
|---|---|---|
| Active paid members | Status and billing conditions at the measurement date | Reconcile to successful collections, not all CRM accounts |
| Cohort attrition | Lost beginning-cohort members / beginning members | Keep new joins out of the original cohort |
| Gross joins | New paid memberships in the period | Separate free trials and reactivations |
| Realized monthly price | Defined collected/earned revenue per relevant member | Account for discounts, refunds and failed charges |
| Visit intensity | Visits by paid members over a stated period | Compare capacity and variable costs without treating visits as new revenue |
Test retention without calling it a forecast
With 1,000 members and 4% monthly attrition, no new joins and a constant assumption, the modeled cohort falls to about 612.71 members after twelve months. At a $30 monthly realized price, the ending monthly revenue run rate is about $18,381.29. These are illustrative expected values, not actual fractional customers.
The membership scenario tool makes the timing explicit. Run-rate revenue is not the same as actual cash collected during all twelve months. Billing dates, refund policy, taxes, payment failures and plan changes require a more detailed cash reconciliation.
Understand capacity and transfer risk
More members can create peak-time queues, wear and variable cost. Review usage by time of day and day of week, equipment downtime and complaints. A membership contribution margin requires actual costs and usage assumptions; recurring billing alone is not proof of recurring profit.
Before closing, review software/vendor terms, payment-token portability, customer consents where applicable, plan promises and responsibility for refunds or prepaid obligations. Do not assume every membership agreement or processor token transfers unchanged.
Prepare the evidence a buyer can reproduce
Export monthly aggregates with a field dictionary, reconciliation and exception log. Preserve the underlying records privately; do not upload member names, plates or payment information to public calculators. Explain every data cleanup rather than deleting unfavorable periods.
There is no universal acceptable churn rate or guaranteed valuation premium on this page. The significance depends on the definition, cohort, price, collection quality and buyer’s operating plan. Link documented earnings to the earnings bridge and test acquisition cash flow separately. The arithmetic is transparent; the inputs still need verification.
Put the assumptions to work
Use the membership retention scenarios to trace account losses over time, then use the retail and membership break-even tool to compare recurring costs with your own contribution assumptions.