Membership churn: underwriting recurring revenue on a car wash acquisition

Underwrite membership churn by reconciling paid members, cancellations, payment failures, reactivations, and cohort retention to actual subscription collections. Define the population and reporting period before comparing rates. Separate existing-member revenue from new sales assumptions, then test whether the recurring cash flow survives the proposed acquisition, pricing, and operating changes.

Which membership records should a buyer request?

Request stable account IDs, signup dates, plans, billing terms, status history, payment attempts, successful charges, refunds, cancellations and returns where the system records them. Set the review period and ask how system changes or manual entries affect the export.

Limit access and use only the data needed for the review. Early work may use coded IDs and grouped results, but coded records are not always anonymous. Agree on who can receive customer records and how they will be handled before the seller shares them.

The buyer hub places this work in the wider deal review. Find out what customers paid and how their plans changed, rather than copying the total from a sales deck. A displayed account may not have paid for its latest service period.

Keep the source export intact and log changes in a working copy. Name missing fields and the questions they leave open. Missing cancellation dates do not prove that no customers left.

How do you build the member movement bridge?

First define who qualifies for the member count, such as accounts that paid under stated terms. Then track each way an account enters or leaves that group, keeping promotional signups, paused plans and unpaid accounts distinct.

Add new qualifying members and returns to the opening count, then subtract departures and other removals. Make the categories mutually exclusive so the same loss is not counted twice. If someone leaves and returns in one period, check how both events are logged instead of relying on the final status.

In a fictional example, 1,000 opening paid members plus 120 new members and twenty returns, less 100 cancellations and forty payment-related removals, leave 1,000 ending members. The count is unchanged, but 140 losses occurred. These invented inputs show the math, not a churn target for an actual wash.

Explain any gap in the bridge using dates, account records and report rules. Keep unresolved differences visible rather than adding a balancing entry that hides missing evidence.

What should the churn denominator include?

State who is included in the count and which losses form the rate. A rate based on opening members differs from one based on average members, and cancellations alone differ from all removals.

In a fictional opening-member calculation, fifty qualifying losses from 1,000 eligible members equal five percent for that period. This is not an industry target or an annual retention estimate. It says nothing about new sales, cash per account or the cost of replacing lost members.

Use the volume and ticket analysis guide to keep accounts, member visits and collected fees separate. A member who visits often creates more wash activity, but each visit is not another monthly payment. Mixing those units can overstate recurring revenue.

Record the start and end dates alongside the formula. Check that losses belong to the same eligible group used in the denominator, and explain changes in the rules. A comparison between sites is weak if one counts unpaid plans while another includes only paying accounts.

Why do cohorts improve the review?

Group accounts by a stated starting event, such as signup month, and follow their paid status over time. Use the same rules for each group and mark later periods unavailable when the records end too soon.

Review groups sold under different promotional terms separately. Compare their payments and retention with standard-price groups, but do not assume the promotion caused a difference. Timing and operating changes may also affect the result.

Cohorts reveal patterns to investigate rather than promise future behavior. Check whether the buyer will change prices, service or billing terms after closing. A past result may not hold under a different operating plan.

How should failed billing and recoveries be handled?

Track attempted charges, successful charges, account status and later recovery as distinct events. Check whether the system logs several retries for one unpaid bill, since attempts are not collected revenue and recovery does not create a new customer.

Identify cash collected, refunds and the service period each payment covers. Use the profit-and-loss review guide to tie those records to the accounts and bank evidence. If processor fees reduce the cash bridge, show how they enter earnings so the same fee is not deducted twice.

Find out who handles recovery work and what it costs. If the owner follows up personally, budget the buyer’s replacement process and staff time. Show proposed recovery gains as a separate scenario until there is proof that the process works.

Keep an unpaid balance visible until it is paid, written off or otherwise resolved under the actual records. A later payment should be traced to the original bill. Record corrections so another reviewer can follow the cash without counting it in two periods.

What does industry research establish?

The ICA Pulse landing page describes quarterly research covering industry expectations and consumer views. Its Q4 2025 public summary reported renewal intent and improving churn indicators heading into 2026, which are dated survey context rather than this wash’s paid retention.

Ask the seller for actual customer behavior and payments. An intention to renew is not proof that a charge succeeded. No paywalled benchmark, universal acceptable churn rate or realized 2026 site result is inferred here.

The SBA SOP resource links version 8.1 with technical updates effective October 1, 2026. For covered transactions requiring a lender quality-of-earnings report, that report must include cash proof. The SBA financing guide explains the relevant categories and exceptions.

Have the lender confirm which rules and reports apply to the actual deal. A membership dashboard does not replace the required financial evidence or establish loan approval. Keep source dates beside market context so an older survey is not presented as a current site result.

How do you forecast the recurring revenue?

Separate the opening member base from future signups and estimate collections using observed paid status, plan terms, losses and recoveries. Show new sales and promotions in their own schedule so the reader can see how much growth the forecast needs.

Do not carry one monthly loss rate through the year without checking whether it fits the records. Group age, promotions, billing changes and seasonality may affect the pattern. Use a downside case when the history is short or missing key fields.

Budget the cost of serving retained members as well. Their visit patterns, support needs and peak demand may differ from those of retail customers. Retention helps explain revenue durability, but does not alone prove margin or cash available for debt and upkeep.

Link each forecast input to a source period or label it as an estimate. Test proposed price changes and recovery gains separately from the supported base case. Update the model when later records change the assumptions, rather than keeping an old rate because it produces a higher value.

What should the diligence conclusion contain?

State which revenue the records support and which assumptions remain estimates. Give each major open question an owner and a named evidence item before relying on the forecast in an offer.

1. A dated definition of the eligible population and each movement category.
2. A reconciled opening-to-ending bridge with unresolved differences identified.
3. Cohort observations and the limits of their available history.
4. A subscription collection reconciliation linked to financial records.
5. A buyer forecast separating existing members, new sales, and uncertain improvements.

If the export cannot distinguish successful payment from displayed status, keep that limit visible in the price review. A precise retention rate should not hide a weak definition. Say which conclusions would change if missing records become available.

Keep the source export, working schedules and conclusions linked by version and review date. Record changes in definitions so the incoming operator can compare later results on the same basis. That gives the buyer a usable monitoring plan while preserving the limits of the evidence reviewed before closing.