A decline in completed visits can affect a medical practice’s finances, but it is not the same as losing subscription customers. Patients do not necessarily purchase a continuing stream of services, and a gap between appointments does not establish that someone has left the practice.
For owners and managers of staffed private medical practices, the useful financial question is narrower: How much contribution might change when completed-service volume changes, after allowing for collections timing and costs that actually vary?
Answering that question requires aggregate service counts, collections attributable to those services and a defensible cost classification. A subscription churn rate cannot substitute for those inputs. This article explains the mismatch and provides a service-cohort worksheet for evaluating a volume decline without treating patients as subscribers or drawing conclusions about clinical need.
Why subscription churn formulas break down
Subscription churn measures the loss of customers or contracted recurring revenue over a defined period. Simplified SaaS lifetime-value formulas may divide periodic revenue or margin by a churn rate. Those calculations depend on assumptions about continuing payments, cancellation and relatively stable economics.
Service-based medical practices generally have a different revenue process: services are completed, claims or patient charges are processed, and payments arrive later. The amount collected may depend on payer terms, patient responsibility, adjustments and collection outcomes.
| SaaS concept | Why it can mislead a medical practice | More useful financial question |
|---|---|---|
| Customer cancellation | No recent appointment does not establish a terminated relationship | Did aggregate completed-service volume change in a comparable period? |
| Revenue per subscriber | Collections differ by service and payer mix | What net collections are attributable to the defined service cohort? |
| Lifetime value based on inverse churn | An assumed cancellation rate does not establish future service frequency or collections | What contribution did completed services produce within a stated collection window? |
| Lost monthly recurring revenue | Monthly deposits can include payments for earlier services | Is the change coming from service volume, collection timing or realized collections per service? |
| Retention-driven expansion | Financial analysis does not establish whether additional services are appropriate | What expense and cash decisions follow from the observed workload? |
The point is not that all recurring-payment arrangements are identical or irrelevant. A practice with a genuine membership arrangement may need a separate analysis of its contract economics. That does not make ordinary visits or procedures equivalent to subscriptions.
sbb-itb-17e8ec9
Define a service cohort, not a patient-retention cohort
For this analysis, a service cohort is a group of completed services sharing a defined service period and reporting scope. It is not a group of patients classified by whether they returned.
Start with one owner decision, such as assessing whether lower workload at a location will leave enough contribution to cover its committed payroll and occupancy costs.
Then document:
- Scope: The legal entity, location and service category included.
- Counting unit: Completed encounters, procedures or another consistently defined service unit. Do not mix encounters with claim lines.
- Service period: The period in which the services were performed, not when cash arrived.
- Comparison basis: Comparable operating days, provider availability and service definitions.
- Collection window: The same elapsed time after each cohort’s service period.
- Cost boundary: Which expenses vary with completed services and which remain committed.
Separate materially different service categories when a single average would conceal a mix change. A lower encounter count accompanied by a different service mix may not have the same financial effect as a proportional decline across all services.
A location closure, provider leave or fewer operating days can explain a count change without indicating any change in patient relationships. Report those facts alongside the comparison rather than calling the result churn.
Match collections to the services that generated them
A bank deposit is evidence of cash received, but not necessarily evidence of revenue from that month’s services. Payer receipts may cover earlier service dates, and patient balances can be paid after the associated payer payment.
For each cohort, calculate net collections attributable to its completed services, including associated payer and patient receipts and subtracting attributable refunds or recoupments. Contractual adjustments and write-offs help explain differences between charges and receipts; they are not additional cash collections.
Where available, use service-date reporting from the practice’s billing records, then reconcile the resulting receipt totals to the books and bank activity. Keep unapplied cash, unidentified receipts and payments covering multiple periods in a separate reconciliation schedule until they can be assigned reliably.
The IRS guidance on business recordkeeping supports complete records, separate business accounts and bank reconciliation. Those controls support the analysis, but they do not by themselves allocate deposits to service cohorts.
Compare cohorts at the same collection age
An older cohort has had more time to collect than a recent one. Comparing an older cohort’s near-final receipts with a recent cohort’s receipts to date can make current performance look worse solely because of timing.
Use a common collection window and label the result collections to date, not final revenue. Maintain a separate estimate of additional collections only if there is a documented basis for it. Keep actual and estimated amounts in separate columns.
Even equal-age comparisons have limits. Payer processing delays, unresolved claims, patient payment plans and later recoupments can change the result. If reliable service-level attribution is unavailable, present a provisional range or defer the contribution conclusion rather than allocating all monthly deposits by visit count.
Identify costs that actually change with volume
Contribution for this worksheet means attributable net collections less the defined variable costs associated with those services. It is an internal management measure, not operating profit or a replacement for the practice’s accounting statements.
| Cost | Possible treatment | What to verify |
|---|---|---|
| Supplies consumed per completed service | Variable | Actual consumption and purchasing or inventory timing |
| Outside services charged per completed service | Variable | Invoice basis and attribution to the cohort |
| Provider compensation tied to production or collections | Potentially variable | Contract terms, minimums, payment timing and calculation basis |
| Salaried provider and administrative payroll | Usually committed within the current schedule | Whether any expense would actually change over the decision period |
| Hourly staffing | Variable, fixed or step-based depending on scheduling | Whether paid hours can change, not merely whether workload fell |
| Rent, software and shared administration | Generally shown separately from service contribution | Consistent allocation and whether any cost is avoidable |
A cost assigned to a service is not necessarily a cost saved when that service does not occur. Purchased supplies may remain in inventory. Staffing may be adjustable only in blocks. Guaranteed compensation may remain unchanged despite lower production.
For multi-location practices, show contribution before allocated shared costs, then show those allocations separately. Otherwise, a change in the allocation method can look like a change in underlying service economics.
A cohort worksheet for a volume decline
Illustrative example only: A private practice compares two service cohorts from one location and one defined service category. Both have the same number of operating days, and collections are measured through 120 days after each service month ends. These figures are invented for explanation, not practice benchmarks or final collection estimates.
| Worksheet line | Baseline cohort | Comparison cohort |
|---|---|---|
| Completed services | 1,000 | 900 |
| Attributable net collections through the common cutoff | $150,000 | $130,500 |
| Net collections to date per completed service | $150 | $145 |
| Associated variable costs | $30,000 | $27,000 |
| Variable cost per completed service | $30 | $30 |
| Contribution through the cutoff | $120,000 | $103,500 |
| Contribution per completed service | $120 | $115 |
The completed-service count fell by 100, while measured contribution fell by $16,500. That does not mean 100 subscribers were lost. Nor does the count change alone explain the full financial difference.
Separate the change into two parts:
- Volume effect at baseline economics: 100 fewer completed services × $120 baseline contribution per service = $12,000 less contribution.
- Per-service contribution effect: 900 comparison-period services × $5 lower contribution per service = $4,500 less contribution.
Together, these explain the $16,500 decrease. The second component requires investigation: it could reflect service or payer mix, collections timing, adjustments or another difference. It is not automatically evidence of a pricing problem or lost patient relationships.
Turn the worksheet into a planning scenario
Illustrative planning scenario only: If another comparable cohort had 100 fewer services, with collections of $150 and genuinely variable costs of $30 per service, the modeled contribution reduction would be $12,000.
If committed expenses stayed unchanged, the modeled operating result would worsen by that amount, before other changes. But if the $3,000 of assumed variable costs could not actually be avoided during the planning period, the near-term effect could be worse than the contribution model suggests.
Do not treat the $12,000 as an immediate bank-balance change. Collections and vendor payments occur on different schedules. Prepare a separate cash forecast using expected receipt dates and payment obligations.
Reusable worksheet fields
| Field | Required entry |
|---|---|
| Cohort definition | Entity, location, service category and service dates |
| Count reconciliation | Completed-service total and exclusions |
| Collection maturity | Common cutoff and elapsed collection window |
| Net collections | Attributable receipts less refunds and recoupments |
| Unallocated receipts | Amount excluded pending reconciliation |
| Variable costs | Included categories, amounts and calculation basis |
| Contribution | Net collections less defined variable costs |
| Change explanation | Volume effect, per-service effect and known mix differences |
| Limitations | Outstanding collections, cost estimates and allocation uncertainty |
| Decision owner | Person responsible for the next review and action |
Use the result for expense and cash decisions
The worksheet should lead to a specific management response, not a campaign to increase utilization.
- If counts declined but deposits did not: Check whether current cash includes collections from older cohorts. Avoid assuming the bank balance proves that lower volume has no financial effect.
- If collections per service declined: Review collection maturity, payer mix, adjustments and unresolved balances before changing a forecast assumption.
- If workload fell but payroll stayed level: Review actual paid hours, coverage needs and commitments. A lower allocated payroll cost is not a saving unless spending changes.
- If one location weakened: Compare its contribution before shared allocations, then reconcile its location P&L and entity-level accounts.
- If attribution is unreliable: Improve the reconciliation process before relying on a precise contribution estimate.
Keep clinical decisions separate. Aggregate financial data cannot determine whether an individual needs care or should return for another service.
Keep the workflow practical and privacy-conscious
Give the practice manager responsibility for validating completed-service counts, the billing team responsibility for collection attribution and the finance team responsibility for reconciliation and cost classification. Document unresolved differences rather than forcing them into a single average.
Use aggregate reporting where feasible and minimize patient information in financial analysis. The HHS minimum necessary guidance explains the standard and its exceptions; it is not a blanket authorization to share identifiable information with outside tools. Do not place patient-identifiable information in ordinary Slack messages or general-purpose AI tools.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for US private medical practices with staff. Its AI-assisted work and human finance team can support clean books, catch-up bookkeeping and location/entity financial visibility, with support through Slack. Service-cohort analysis still depends on reliable practice records and documented allocation assumptions.
Conclusion
SaaS churn formulas answer questions about continuing subscriptions. A service-based medical practice needs a different analysis: comparable completed-service cohorts, attributable net collections, realistic variable costs and explicit collection-lag limitations.
Use the worksheet to distinguish volume changes from changes in collections per service, then assess committed expenses and cash timing separately. That produces a more useful owner decision than labeling fewer visits as lost subscribers.
FAQs
Does a patient who has not returned count as churned?
Not for this financial worksheet. An absence of appointments does not establish a cancellation, a permanent departure or a need for further services. Analyze aggregate completed-service volume without assigning subscription status to patients.
Can I divide monthly bank deposits by monthly visits?
You can calculate that ratio, but it does not reliably measure collections attributable to those visits. Deposits can include older payer receipts and patient payments. Match receipts to service cohorts where possible and compare cohorts at the same collection age.
Does lost contribution equal lost profit or immediate cash loss?
No. Contribution excludes costs classified as committed or shared. Operating profit also depends on those expenses and the accounting basis used. Cash impact depends on receipt and payment timing, while modeled cost savings depend on whether spending actually changes.
What if our records cannot allocate collections to service cohorts?
Keep the conclusion provisional. Reconcile what can be attributed, show unallocated amounts separately and avoid presenting monthly deposits as cohort collections. A clearly labeled range with documented assumptions is more useful than an unsupported precise estimate.