A useful unit economics workbook helps a private medical practice owner answer a specific question: Which parts of the practice generate contribution, and what costs must that contribution support?

The unit might be a location-month, a completed service within a defined category, or a staffed capacity block. Each view supports a different decision. Location results help owners understand site performance. Service-category results show how the mix of work affects contribution. Capacity-block results help managers examine whether available staffing and space are being used effectively.

The workbook should not become a second, disconnected set of books. It needs consistent definitions, documented cost treatment and a reconciliation to the accounting records. The following worksheet layouts provide a reusable structure without assuming every practice has the same staffing model or revenue cycle.

Define the Unit Before Building the Workbook

Start with the management question, then choose the unit and reporting period. Avoid a single blended measure called “profit per patient”: it can conceal differences in service mix, payment timing and staffed capacity.

Worksheet view Unit definition Owner or manager question Essential context
Location One location for one reporting month Does this site support its directly attributable operating costs? Operating days, service mix and shared staff
Service category One completed service within a consistently defined category How does this category contribute before fixed and shared costs? Payer mix, resource requirements and revenue maturity
Staffed capacity One consistently defined staffed block at a location Is available capacity producing enough contribution to support the block? Block duration, staffing configuration and unused capacity

A staffed block could be a morning session with a specified provider and support team. Define its duration and staffing requirements in the workbook rather than assuming every session is interchangeable.

These are alternative views of the same practice, not separate revenue streams to add together. Revenue shown in the location worksheet may also appear in the service and capacity worksheets. Adding all three views would double-count it.

Why SaaS metrics do not transfer directly

Subscription churn, annual recurring revenue and customer lifetime value describe assumptions about recurring customer relationships. Ordinary medical-practice revenue does not follow those assumptions simply because patients return.

Payer contracts, completed services, patient responsibility, contractual adjustments and collection timing all affect receipts. A patient who does not return is not automatically a canceled subscription, and an outstanding patient balance is not recurring revenue.

Use measures that describe the practice's actual work and financial records. If a practice has a genuine subscription arrangement, analyze that arrangement separately rather than applying subscription metrics to all patient activity.

Set Up a Reusable Workbook

Keep source data, definitions, calculations and owner-facing reports separate. This makes errors easier to locate and policy changes easier to review.

Tab Purpose Core contents
Read Me and Controls Establish scope and ownership Reporting period, entities, accounting basis, preparer, reviewer and version
Data Dictionary Define every important field Unit definitions, source fields, exclusions and calculation rules
Source Data and Mapping Preserve inputs and classification Book accounts, aggregate revenue activity, payroll summaries and location/service mappings
Allocation Policy Document shared-cost treatment Cost pools, allocation drivers, rationale and effective dates
Location Economics Compare sites consistently Revenue, variable costs, contribution, direct fixed costs and shared allocations
Service Economics Examine service-category results Completed units, revenue attribution, variable costs and contribution
Capacity Economics Examine staffed blocks Available blocks, completed activity, contribution and block-level committed costs
Reconciliation and Review Tie results to the books Control totals, adjustments, exceptions and approval notes

Use stable location, entity and service-category identifiers. Display names can change; identifiers should preserve the history of the underlying unit.

For multi-entity practices, retain the legal-entity field even when the owner reviews a combined report. Document intercompany charges and any eliminations so the combined view does not duplicate revenue or shared costs.

Build the Data Dictionary First

The dictionary prevents different managers from using the same label for different measures. It should explain not just what a field means, but also where it comes from and when it is updated.

Field Definition to document Important control
Reporting period Month or other defined interval covered Use the same period across the selected view
Revenue basis Cash receipts or recognized revenue under the books' accounting basis Do not silently mix bases
Net revenue Revenue after applicable contractual adjustments, discounts, refunds and other reductions under the stated policy Do not substitute gross charges
Completed unit Activity included in the service denominator State how cancellations, no-shows and bundled services are treated
Attributable variable cost Cost expected to change with the defined activity within the stated operating range Separate from committed staffing and occupancy
Contribution Net revenue less attributable variable costs Label it as contribution, not final profit
Direct fixed or committed cost Cost attributable to a location or block but not changing with each completed service Present below contribution
Shared cost Cost supporting multiple locations, categories or entities Identify the allocation policy or leave separately unallocated
Capacity available Staffed blocks made available under the defined configuration Distinguish staffed availability from theoretical room capacity
Data status Final, provisional or estimated Identify estimates and later revisions

Keep revenue timing visible

Cash received this month may relate to services performed in earlier months. Conversely, recently completed services may not yet have produced payer receipts or patient payments.

A cash-based workbook can explain cash contribution, but dividing current receipts by current completed services may produce a misleading per-service result. A service-period view needs a documented method for attributing revenue to the relevant activity, with estimates clearly identified.

Do not solve this by treating all open patient balances as collectible revenue. Agree on the revenue approach with the finance team, and use a bridge when management reporting differs from the books.

Reusable Layouts for the Three Operating Views

Use the following tables as column structures, not as benchmarks. Keep unsupported or unavailable fields blank and flag them for review rather than filling them with assumptions.

Location economics worksheet

Use one row per location and reporting period, with entity retained as a separate field.

Column group Recommended fields
Identification Entity, location, period, operating days, data status
Activity Completed units by category, staffed blocks available
Revenue and contribution Net revenue, attributable variable costs, contribution
Direct operating costs Committed provider/admin payroll, occupancy and other directly attributable fixed costs
Shared costs Allocated shared costs, allocation-policy reference
Result and context Location result after listed costs, unusual items, unresolved attribution

Show contribution before shared allocations. Then show direct fixed costs and shared costs separately. An owner should be able to distinguish an operating change from a change in allocation policy.

A salaried employee assigned to one site may be directly attributable to that location without being a variable cost. Direct attribution and cost behavior are different classifications.

Service-category economics worksheet

Use one row per service category, location and period where the available data supports that detail.

Column group Recommended fields
Definition Category ID, included activity, completed-unit rule
Volume and revenue Completed units, attributed net revenue, revenue maturity/status
Attributable variable costs Supplies, external services and compensation that genuinely varies with the activity
Contribution Total contribution, contribution per completed unit
Interpretation Payer/service mix notes, bundled-service treatment, excluded or unassigned activity

Do not force every service category to absorb a full share of rent or administration merely to produce a “profit per service.” Those allocations may be useful for a separate full-cost view, but they should not obscure contribution.

Where one payment covers several activities, document a consistent attribution method. If the data cannot support a reliable split, retain a broader category instead of presenting false precision.

Staffed-capacity economics worksheet

Use one row per defined block type, location and period. Aggregate comparable blocks rather than mixing materially different staffing configurations.

Column group Recommended fields
Block definition Location, duration, provider/support configuration, available blocks
Activity Used blocks, unused staffed blocks, completed services by category
Financial output Attributed net revenue, activity-variable costs, contribution
Block commitments Staffing and other costs committed for the block, shown separately
Review Contribution after block commitments, allocation status, scheduling exceptions

A block can remain costly even when fewer services are completed. Keeping block commitments separate helps an owner see unused capacity without pretending that salaried payroll falls automatically when volume falls.

Document Shared Costs in an Allocation-Policy Tab

An allocation is a management convention, not proof that a cost would disappear if a location or service stopped operating.

For each shared-cost pool, record the source accounts, receiving locations or entities, driver, rationale, exclusions, policy owner and effective date.

Shared-cost pool Possible driver Limitation to document
Central administrative payroll Supported workload or documented time Revenue share may not reflect administrative effort
Shared occupancy Space used Space alone may not reflect actual use
Shared provider or support coverage Documented scheduled time Scheduled time can differ from completed activity
Practice-wide professional services A documented driver suited to the work, or separate presentation Some ownership-level costs lack a meaningful operating driver

Assign a cost directly when supportable before allocating the remainder. Check that allocation weights cover the intended recipients and that the same expense does not appear both directly and in a shared pool.

Keep genuinely unallocated costs visible. Forcing an arbitrary allocation can make a report look complete while making comparisons less useful. When a policy changes, record the change and either restate comparison periods or flag the break in comparability.

Reconcile Each View to the Books

The reconciliation tab should explain the path from accounting totals to workbook totals. Each operating view must reconcile independently; the views should not be summed together.

IRS Publication 583 explains the importance of complete business records, separate business accounts and reconciling bank records. For this management workbook, add a reconciliation from the accounting records to the analysis.

Control What to show
Scope Included entities, locations, accounts and period
Revenue tie-out Book revenue, documented timing/classification adjustments and worksheet revenue
Expense tie-out Book expenses mapped to variable, direct fixed, shared and excluded categories
Allocation check Shared-cost pool totals compared with allocated and unallocated amounts
Activity check Source-system completed units compared with worksheet units
Combined-entity check Intercompany amounts and eliminations, where applicable
Exception log Unmapped items, estimates, unresolved differences and responsible reviewer

For service-period revenue analysis, show timing differences separately from errors. Do not adjust the accounting records merely to make a management ratio look consistent.

Preserve original exports and distinguish input cells from calculated fields. Keep unresolved mapping differences visible rather than burying them in an “other” category with no explanation.

Recognize When Comparisons Are Misleading

A consistent workbook still requires judgment. Pause before ranking locations or service categories when:

  • Capacity differs: A fully staffed site and a site with provider vacancies do not have equivalent available capacity.
  • Cost behavior differs: Contracted per-service coverage and salaried coverage respond differently to volume changes.
  • Revenue maturity differs: Recent services may have less complete collections history.
  • Service or payer mix differs: A blended average can change without any underlying operational improvement.
  • Shared-cost policies differ: An allocation change can move reported profit without changing practice-wide expense.
  • Opening, closure or unusual costs distort the period: Show these separately without automatically excluding them from the books.

Use like-for-like periods and label exceptions. Contribution alone should not determine a staffing, location or service decision; the owner also needs to understand capacity commitments, transition costs and operational requirements.

Maintain the Workbook as Part of the Monthly Close

Assign a preparer and reviewer. After the books are ready, refresh the source data, review mappings, reconcile totals and record unresolved issues before distributing the workbook. Provisional operating views can be useful sooner, but should be labeled accordingly.

Review definitions whenever staffing models, locations, service categories or entity structures change. Preserve prior versions so a policy change does not silently rewrite the historical story.

Use aggregate financial and operating data wherever possible. Avoid patient names and other identifying details in owner-facing worksheets. HHS guidance on the minimum necessary standard provides relevant context, including exceptions; have the appropriate privacy lead review workflows involving patient information. Do not place patient-identifiable data in ordinary Slack messages or general-purpose AI tools.

Turn Consistent Reporting Into a Useful Owner Review

A good review ends with a short list of questions: Which variance reflects activity? Which reflects collection timing? Which reflects a staffing commitment or allocation change? What information is missing before a decision can be made?

Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices, combining AI-assisted financial work with a human finance team. Clean books and location/entity financial visibility provide the foundation for this kind of analysis.

The workbook's value comes from consistency: defined units, defensible revenue attribution, clear cost behavior and totals tied to the books. Those controls make unit economics useful for practice management rather than merely another dashboard.