A benchmark comparison should help a practice owner make a specific decision: whether to change staffing, investigate collections, revise a location budget or delay expansion. A number that looks worse than a peer average is a starting point for investigation—not proof that the practice is underperforming.
For staffed private medical practices, differences in payer mix, provider schedules, payment timing and shared overhead can make similar-looking financial reports tell very different stories. Before acting, reconcile those differences and identify what remains within management’s control.
This guide provides a repeatable comparison worksheet, a worked example and a process for turning a variance into an accountable action.
1. Start With the Decision and Reporting Unit
Write down the decision before collecting benchmarks. “Improve profitability” is too broad. “Determine whether the second location needs additional administrative coverage” gives the analysis a useful boundary.
Then identify what you are comparing:
- The whole practice: Useful for overall operating performance and cash planning.
- An individual location: Useful for staffing, occupancy and expansion decisions.
- A legal entity: Useful when separate entities hold operating activity, payroll or shared expenses.
- A service line: Useful only when revenue and related costs can be attributed consistently.
Do not compare a location’s revenue with an entity’s expenses. Similarly, do not treat a bank transfer between practice entities as additional operating revenue.
For location decisions, prepare both a direct-cost view and a fully allocated view. The direct-cost view shows revenue less costs attributable to that location. The fully allocated view also includes its share of central administration and other shared expenses. Both are useful, but they answer different questions.
2. Build Three Separate Comparisons
Historical results, budget and external peers serve different purposes. Keep them in separate worksheet columns rather than blending them into one target.
| Comparison | Question it answers | Main caution |
|---|---|---|
| Own historical trend | Is performance improving or deteriorating? | Changes in provider availability, locations or accounting treatment may distort the trend. |
| Approved budget | Are results matching the operating plan? | The budget may contain assumptions that no longer apply. |
| Qualified external peers | Is there a structural difference worth investigating? | Specialty, payer mix, geography, scale and cost definitions may differ. |
Use history to establish direction
Compare the current period with a comparable prior period and review a longer trend. A single month may reflect a delayed payer receipt or a payroll cycle rather than a lasting change.
Annotate events such as provider leave, a location opening, a staffing vacancy or a change in payment posting. Keep reported results intact; show any comparison adjustments separately.
Use budget to test the plan
A budget variance can reveal an operating problem or an unrealistic assumption. If the budget expected a provider to start before that provider actually became available, distinguish the schedule change from performance during available sessions.
Keep the original budget visible. A revised forecast can guide current decisions without erasing the assumptions management originally approved.
Use external peers as a qualified reference
Before using a peer figure, document its source, reporting period, sample description and calculation method. Confirm whether expenses include owner-provider compensation, benefits, occupancy and central overhead.
If those details are unavailable, label the comparison “directional only.” Do not use a poorly matched peer figure as the sole basis for reducing staff or changing provider compensation. This article does not supply a universal medical-practice target.
3. Close and Reconcile the Underlying Records
Benchmarking cannot repair incomplete books. Before calculating variances, confirm that the reporting period is sufficiently complete and that the source records agree.
| Check | What the manager or finance team should verify |
|---|---|
| Bank reconciliation | Deposits, withdrawals and outstanding items reconcile to the ledger. |
| Receipt reconciliation | Payer and patient receipt totals can be traced between collection reports, deposits and the books, with timing differences explained. |
| Payroll completeness | Provider and administrative payroll, employer payroll costs and benefits receive consistent treatment. |
| Location coding | Revenue and direct expenses are assigned to the appropriate location. |
| Shared costs | Central expenses use a documented allocation method applied consistently. |
| Entity activity | Transfers and intercompany balances are distinguished from operating income and expense. |
| Reporting basis | Actuals and comparators use the same accounting basis, or differences are explicitly reconciled. |
The IRS guidance on business recordkeeping supports maintaining complete records, keeping business accounts separate and reconciling bank records. These are foundations for reliable financial comparisons, not evidence that a particular benchmark is appropriate.
If an error affects the accounts, correct it through the normal bookkeeping process. If a difference exists only to make a management comparison more meaningful, show it in a separate analytical schedule rather than silently changing the books.
sbb-itb-17e8ec9
4. Complete the Comparison Worksheet
Use one worksheet for each decision and reporting unit. Start with the few measures needed to answer the question; a large dashboard can obscure the issue.
Comparison worksheet template
| Worksheet field | What to enter |
|---|---|
| Decision | The staffing, spending, collections or location decision under review |
| Scope and period | Practice, location or entity; reporting dates; accounting basis |
| Measure | The exact calculation, including the numerator and denominator |
| Current actual | The result tied to the closed reports |
| Historical comparison | A comparable prior period, with relevant operating changes noted |
| Budget comparison | The approved amount and its underlying assumptions |
| External reference | Qualified peer result, source and limitations—or “not available” |
| Initial variance | Actual minus comparator, plus percentage variance where meaningful |
| Reconciliation | Timing, classification, scope and allocation differences |
| Remaining variance | The difference still requiring explanation after reconciliation |
| Action and owner | A specific investigation or operational change and accountable person |
| Review point | When to reassess and what evidence will indicate progress |
For a dollar measure, percentage variance is generally the dollar difference divided by the comparison amount. If the comparison amount is zero or too small to produce a useful percentage, report the dollar difference instead. For margin comparisons, use percentage-point differences rather than confusing them with percentage changes.
A compact location-level scorecard
| Measure | Comparison to run | Investigation if results differ |
|---|---|---|
| Payer and patient receipts | Actual versus budget and historical trend | Deposit timing, collection delays, service mix or provider availability |
| Provider compensation | Dollars and relationship to comparable revenue | Compensation structure, payroll timing and owner compensation treatment |
| Administrative staffing cost | Dollars, staffed hours and workload context | Overtime, vacancies, temporary coverage or central staff allocation |
| Occupancy expense | Actual versus budget and other locations | Lease scope, usable capacity and shared-space treatment |
| Location contribution | Revenue less direct location costs | Whether the location covers attributable operating costs |
| Fully allocated operating result | Result after shared overhead | Allocation changes and the underlying central cost base |
A ratio should prompt questions, not supply an automatic answer. Administrative payroll as a share of receipts can rise because payroll increased, receipts arrived late, or both. Inspect numerator and denominator separately.
5. Reconcile the Gap Before Acting
Work through differences in a consistent order:
- Scope: Are both figures for the same location, entity and activities?
- Timing: Are payment posting, payroll periods and cutoffs comparable?
- Classification: Are similar items recorded in the same categories?
- Allocation: Are shared expenses distributed consistently?
- Operating conditions: Did provider availability, payer mix or capacity change?
- Remaining performance: What difference still needs an operational explanation?
An explained difference is not necessarily harmless. A delayed payer payment may explain a receipts variance while still creating a cash problem. A provider vacancy may explain lower revenue while still requiring a revised operating plan.
Illustrative example: a location appears below budget
All numbers in this example are illustrative, not industry benchmarks. A practice manager is evaluating whether a location’s results justify reducing administrative hours. The practice uses a receipts-based management report.
| Measure | Reported actual | Budget | Actual minus budget |
|---|---|---|---|
| Receipts | $420,000 | $450,000 | −$30,000 |
| Direct operating costs | $310,000 | $315,000 | −$5,000 |
| Location contribution | $110,000 | $135,000 | −$25,000 |
| Allocated shared costs | $45,000 | $40,000 | +$5,000 |
| Fully allocated result | $65,000 | $95,000 | −$30,000 |
The initial report shows a substantial shortfall. Investigation finds three comparison differences:
- A payer remittance of $18,000 arrived just after period-end, although the budget assumed receipt during the period.
- $6,000 of receipts attributable to this location was incorrectly assigned to another location.
- A changed shared-cost allocation assigned $5,000 more overhead than the method used in the budget.
The bookkeeping team corrects the location coding. For comparison purposes only, the manager separately bridges the receipt timing and allocation-method differences.
| Bridge to the budget comparison | Effect on fully allocated result |
|---|---|
| Originally reported result | $65,000 |
| Correct location receipt coding | +$6,000 |
| Show identified receipt timing difference | +$18,000 |
| Compare using the budget’s allocation method | +$5,000 |
| Analytical comparison result | $94,000 |
| Budget result | $95,000 |
| Remaining difference | −$1,000 |
The analytical result is not a replacement for the reported result or cash balance. It explains why the original gap looked large. The delayed receipt still matters for cash planning, and management must decide whether the new allocation method better represents shared resource use.
The evidence does not establish a need to reduce administrative hours. The next steps are to verify the delayed receipt, prevent location-coding errors and review staffing workload separately.
6. Turn the Remaining Variance Into an Action
After reconciliation, classify the issue before assigning work.
| Finding | Appropriate response |
|---|---|
| Bookkeeping or coding error | Correct the records and add a targeted review check. |
| Payment timing difference | Track expected receipts and update the cash forecast. |
| Budget assumption no longer valid | Revise the forecast while preserving the original budget. |
| Shared-cost methodology difference | Review the allocation driver and apply the chosen method consistently. |
| Persistent operating gap | Investigate the underlying workload, capacity or spending decision. |
| Weak external comparability | Obtain a better reference or rely more heavily on internal evidence. |
Give each action an owner and a review point. “Reduce costs” is not an action plan. “The practice manager will review overtime by location and explain recurring coverage gaps at the next monthly review” is actionable.
Before making a staffing change, consider its effect on necessary coverage and administrative work. A lower expense ratio is not useful if the change creates backlogs or undermines collections.
7. Make the Review Repeatable
Use a consistent monthly packet: reconciled financial statements, location P&Ls, the comparison worksheet, the variance bridge and an action log. For multi-entity practices, retain entity-level detail alongside any consolidated management view.
Keep financial analysis aggregated where possible. Ordinary Slack conversations and general-purpose AI tools should not receive patient-identifiable information. The HHS minimum necessary guidance explains a context-dependent standard with exceptions; it is not a blanket authorization to share patient data for financial analysis.
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, catch-up bookkeeping and location/entity visibility can support this review process, with Slack available for coordination using appropriately limited financial information.
The goal is not to rank a practice against an arbitrary average. It is to explain a meaningful difference, choose a justified action and check whether that action improved the result.
Which comparison should a practice owner review first?
Start with reconciled actuals against the approved budget and the practice’s own comparable history. Use qualified external peers to investigate structural differences, not to override known facts about the practice.
What if no reliable external benchmark is available?
Mark the external-reference field as unavailable. Use consistent historical trends, budget assumptions and comparable locations within the practice. An undocumented peer average is less useful than a well-supported internal comparison.
Should shared expenses be included in location comparisons?
Review both direct location contribution and the fully allocated result. Document how central expenses are allocated. Otherwise, a change in allocation can look like a change in location performance even when the underlying operations have not changed.
Does explaining a variance mean no action is needed?
No. A timing difference may still require cash planning, and a provider vacancy may require a revised budget. Reconciliation identifies the right action; it does not excuse the result.