A rising member count can conceal the loss of the members present at the start. A cohort analysis follows a defined group over time; a population bridge explains how the total active count changes. Reviewing both helps a buyer test what the membership headline actually represents before using it in an earnings or valuation discussion.
Define the account and status before counting
Decide whether the unit is a paying account, subscription, household or vehicle, and use it consistently. Document the reporting timezone and month-end cutoff. Separate paid active members from trials, complimentary access, pauses, failed billing and service that remains available after cancellation. A dashboard label alone does not establish which population the export contains.
Stripe’s analytics documentation illustrates that a provider’s metric definitions and configuration matter. It is one provider’s reporting system, not evidence that a particular car wash uses Stripe or has identical statuses. Obtain the data dictionary for the POS and billing systems actually involved. The calculator below uses its own explicit opening-to-closing definitions.
| Movement | Definition used in this model |
|---|---|
| Opening active | Distinct paid members active at the beginning of the month. |
| Joins | Previously absent new members who are active at the end of the month. |
| Reactivations and resumes | Previously inactive or frozen members returning to active at month-end; keep the two statuses distinct. |
| Voluntary and payment losses | Opening active members absent at closing because of cancellation or an unrecovered payment-loss status. Count each removed member once. |
| Freezes | Opening active members moved into a frozen status at closing; shown separately from cancellation loss. |
| Original-cohort exits and returns | Subsets of the same total removals and returns, belonging to the fixed group selected at the opening date. |
Use status transitions rather than repeated events
A failed billing attempt followed by successful recovery is not automatically a lost active member. Likewise, a person who joins and cancels within the same month has activity but is absent at both endpoints. This model is an opening-to-closing status bridge, not an event ledger. Keep within-month activity in a separate report and reconcile its cash, refunds and service effects.
Every removed member must come from the opening active population. Original-cohort removals must fit inside both that cohort and the total removals; remaining removals must fit the opening noncohort population. Original-cohort returns must fit both the inactive original cohort and total reactivations/resumes. These checks catch impossible aggregates, but they cannot deduplicate customer identities or authenticate an export. Do that in the private source records.
Read the bridge and the cohort curve together
Closing active = opening active + new joins + reactivations + resumes
− voluntary losses − unrecovered payment losses − freezes
Closing original cohort = prior active original cohort − cohort exits + cohort returns
Original-cohort active retention = closing active original cohort / original cohort size
Cancellation loss rate = (voluntary + unrecovered payment losses) / opening active
The cohort selected at the start stays fixed. New joins never enter it. A returning original member remains part of the original group; active retention can rise when that person returns. Freezes reduce active retention while separately appearing as freezes in the population bridge. This definition is not a first-churn survival curve and should not be compared with one without reconciling definitions.
Cancellation loss excludes freezes here. A zero opening active population makes the cancellation-loss and net-growth percentages undefined; absolute movements still work. A zero original cohort makes retention undefined. The tool displays that condition rather than replacing it with an artificial 0% or 100% result.
A fictional growing membership base with cohort loss
The example begins with 500 active members, all in the opening cohort. Month one adds 40 new joins and five reactivations, then removes 25 voluntary cancellations and ten unrecovered payment losses. Closing active members are 510: net growth is 2%, while the defined cancellation-loss rate is 7%. The opening cohort falls to 465 active, or 93% active retention.
After twelve invented monthly movement rows, total active members reach 620, yet only 245 members from the original 500-person cohort remain active. Original-cohort active retention is 49%. Net growth and cohort retention describe different populations; neither number alone proves durable subscription economics. The example’s $199,800 total net cash collected is a separate cash measure, not automatically the period’s earned revenue.
Do not plug a reported-count difference
If an independent closing active count is available, enter it in the optional reported-closing field. The result shows reported count minus calculated count. A mismatch remains an exception; the tool does not manufacture a balancing adjustment or silently use the reported count as next month’s opening balance. Subsequent months follow the calculated bridge.
Investigate cutoff dates, duplicate identities, different account units, freezes, recovered payments and same-month round trips before deciding the explanation. Record the source and resolution. A small difference is not proof that it is harmless, and a large difference is not by itself evidence of misconduct.
Connect the population to cash and service obligations
Reconcile membership charges, refunds, fees, settlement timing and bank receipts using the POS-to-bank verification guide. Net collected cash can be negative in a refund-heavy month; the calculator preserves that sign. Member visits are recorded for review and export, without converting them into assumed incremental revenue or lifetime value.
Mister Car Wash’s 2025 Form 10-K describes its own membership revenue recognition over the subscription period. That is an example of one public company’s accounting policy, not a benchmark for retention, pricing or your transaction. Have the accountant assess the actual contracts, prepaid amounts and remaining service obligation. A cash collection, an active member and earned revenue need not occur at the same time.
Keep the acquisition interpretation evidence-based
Ask which billing rights, software access, payment authorizations and service commitments can continue under the actual transaction structure. Do not assume customer payment details can simply be copied to a new provider. Investigate promotions, price changes, closures, plan migrations and the cost of delivering member visits before drawing conclusions about earnings.
Use this analysis alongside the membership revenue guide, subscription valuation questions and earnings worksheet. No automatic valuation premium, generic good churn threshold or lifetime-value forecast is assigned by this tool.
Download the membership status and cohort worksheet
Questions before using the result
Why can the original cohort recover after declining?
This is active retention at each endpoint, including returns of original members. It is not a one-way survival measure that permanently removes everyone at their first cancellation.
Is every failed payment a lost member?
No. Use the documented status at the reporting cutoff and distinguish failed attempts from unrecovered loss. Recovery and remaining access can change the appropriate classification.
What does the optional reported closing count do?
It supplies an independent comparison. The tool displays the difference, leaves it unresolved, and continues from the calculated bridge instead of plugging the reported number.
Can I enter customer-level files or billing details?
This tool uses aggregate counts and amounts only. It provides no upload or provider connection. Keep identities, payment details and private records in your own authorized systems.
Reproduce the fictional monthly revenue case
Reproduce the fictional monthly revenue case with explicit source periods, evidence references and unresolved questions.
Test the cost of serving retained members
Test the cost of serving retained members with the method, private tool and reproducible fictional case. Reconcile periods and amounts before carrying a result into another model.
Connect the next evidence question
Membership billing continuity. Each workbook has its own scope, written method and fictional case. Reconcile definitions before manually carrying a result into another review.
Sources and scope
Official and original sources checked October 17, 2026. These sources support the identified rules and methods; they do not verify a particular business or property.
- Stripe — Subscription analytics and metric definitionsOne provider’s subscription metric definitions and configuration; other POS systems and this explicit model can differ.
- Mister Car Wash · SEC filing — 2025 Form 10-KOne public operator's membership revenue recognition and POS-to-bank audit; not a small-business margin benchmark.
Continue your review
Verify the revenue · Normalize earnings · Model the cash flow