A scenario model can make a new provider hire, equipment purchase or additional location look affordable while hiding the month the practice cannot cover payroll. The problem may not be the forecast’s overall direction. It may be a duplicated receipt, an annual expense placed in a monthly column or a collection delay that never reaches the cash forecast.

Before approving a commitment, review whether the model’s assumptions, formulas and cash movements tell the same story. A detailed spreadsheet is not necessarily a reliable one.

This guide focuses on finding errors in an existing medical practice scenario model—not building scenarios from scratch. The review should answer three questions:

  • Does the model represent the practice’s operations and financial records correctly?
  • Do the assumptions within each case fit together?
  • Can the practice fund the proposed decision when payments actually come due?

Start With the Decision and the Model’s Boundaries

Ask the preparer to state the decision the model supports. “Approve another provider” is incomplete without a proposed start date, compensation commitment, supporting staff requirements and the location or entity that will pay.

Then confirm the model’s boundaries:

Review item What must be clear
Decision The spending, staffing or expansion commitment under consideration
Time period Monthly or weekly columns, with consistent start and end dates
Accounting basis Whether each schedule shows earned revenue, billed charges or cash receipts
Scope Included locations, entities, bank accounts and shared expenses
Starting position Opening cash, receivables, unpaid bills and existing commitments
Comparison The proposed decision versus continuing without it

That last comparison matters. A new location may appear profitable because the model assigns it revenue transferred from an existing office without showing the corresponding reduction there. Review both the location view and the total practice effect.

A Flawed Model Excerpt: What Should Stop Approval?

Illustrative example: all amounts and operating assumptions in this section are invented for review purposes. These are selected lines from a flawed February expansion model, not a complete financial statement.

Model line Flawed entry or logic Reviewer’s finding
Provider salary expense Annual salary of $240,000 entered as February expense Annual and monthly units are mixed; a full month’s salary would be $20,000 before other employment costs
Total revenue $120,000 expected net service revenue plus $80,000 payer receipts equals $200,000 Receipts are added to revenue even though they represent collections of receivables, not separate services
February cash inflow All $120,000 of February net service revenue collected in February Collection timing is assumed rather than supported
Completed visits 800 visits from one provider with 16 clinical days and 20 available slots per day Only 320 slots exist before cancellations or other scheduling constraints
Downside expenses Every cost falls by the same percentage as revenue Lease payments and committed salaries do not necessarily decline with volume
Ending cash Opening cash plus reported profit Equipment payments, debt principal and collection timing are missing

These errors should not be netted against one another. An overstated salary might accidentally offset overstated revenue, leaving a plausible-looking result built on incorrect logic.

The reviewer should require corrected source schedules and rerun the outputs before relying on the recommendation.

1. Mixing Time Periods and Units

A monthly heading does not prove that every input is monthly. Models often combine annual compensation, quarterly vendor payments, weekly staffing hours and monthly visit counts without converting them consistently.

Check each material input’s unit and effective date. For payroll, distinguish an annual compensation rate from the expense attributable to the modeled period and the dates cash is paid. A provider beginning partway through a month should not automatically generate a full month of payroll expense or clinical capacity.

Also inspect summary formulas. A quarterly report can accidentally add a year-to-date column to three monthly columns, counting the same activity twice.

Correction: Label units beside inputs, separate rates from period totals and verify that summary columns include only the intended periods. Use actual payroll payment dates in the cash schedule rather than assuming every month has identical payroll outflows.

2. Double-Counting Revenue and Collections

Medical practice models need clear distinctions among gross charges, expected net revenue and cash received. They are not interchangeable measures.

Common duplication errors include:

  • Adding payer receipts to revenue already recognized for the underlying services.
  • Adding patient balances to a revenue estimate that already includes patient responsibility.
  • Treating collections of opening receivables as new service revenue.
  • Recording transfers between practice bank accounts as outside revenue.
  • Counting intercompany charges as additional revenue in a consolidated practice view without eliminating the corresponding internal activity.

Trace a service period through the schedules. Where does its revenue appear? Where do its later collections appear? Is either amount counted again in the total?

Correction: Keep the revenue schedule separate from the receipts schedule. Reconcile opening receivables, new net receivables, collections, adjustments and ending receivables using consistently defined categories. At the consolidated level, remove internal transfers and intercompany activity that would otherwise overstate totals.

3. Omitting Collection Lags

A model can estimate eventual collections reasonably and still misstate near-term cash. Payer receipts and patient payments may arrive after the practice has paid provider and administrative payroll.

Inspect whether the model distinguishes:

  • Collections from receivables already outstanding at the start.
  • Collections from services delivered during the forecast.
  • Payer and patient payment timing where their patterns differ materially.
  • Delayed receipts from amounts the practice no longer expects to collect.

A delay moves cash to a later period. A reduction in expected collectibility changes the amount ultimately expected. Those are different assumptions and should not be applied twice to the same balance without justification.

Correction: Require a collection schedule supported by the practice’s historical receipt patterns and relevant receivables information. Check that a delay reduces cash in the affected month and leaves the corresponding amount outstanding until collection or adjustment.

Use aggregated financial information where possible. Patient-identifiable details generally are not needed for an owner’s scenario review and should not be placed in ordinary Slack messages or general-purpose AI tools.

4. Forecasting More Activity Than the Practice Can Deliver

Revenue projections should fit within operating capacity. A model that assumes a full schedule from a new provider’s first day may overlook ramp-up time, room availability or supporting staff coverage.

Compare modeled activity with the most relevant constraints:

  • Provider clinical days and available appointment slots.
  • Expected completed visits rather than scheduled appointments alone.
  • Room and equipment availability.
  • Administrative and clinical support staffing.
  • Coverage changes when providers split time between locations.

Capacity at one location cannot also be used at another during the same hours. Similarly, hiring a provider does not automatically create patient demand or make every appointment slot collectible at the same amount.

Correction: Reconcile completed visits to available capacity, then verify that the revenue assumptions match the expected service and payer mix. Ask for support when the model assumes performance materially above the practice’s own experience.

5. Using Unsupported Relationships in the Downside Case

A downside case is not simply the base case with every line reduced by the same percentage. It should describe a plausible chain of events.

Consider a slower-than-planned provider ramp-up. Fewer completed visits may reduce net revenue and some supplies expense. But guaranteed compensation, rent and essential administrative coverage may remain unchanged. Collections may also trail the reduced service activity.

Assumption Coherent slower-ramp downside Relationship to challenge
Completed visits Lower because the schedule fills more slowly Visits remain unchanged while revenue falls without explanation
Net revenue per visit Held steady unless mix or reimbursement assumptions also change Automatically falls whenever visit volume falls
Collections Follow the revised service activity and supported payment timing Improve simply because the case needs more cash
Payroll Reflects compensation terms and required coverage Falls immediately in proportion to revenue
Supplies Changes with the relevant activity All spending is treated as fully variable
Existing location Reflects any provider time or patient activity moved elsewhere Keeps all original activity while the new office counts it again

Correction: Ask the preparer to explain each material relationship in plain language. Historical data, compensation arrangements, vendor terms and operating plans should support the connections. Do not assign precise probabilities to scenarios without a defensible basis.

6. Ignoring Fixed Commitments and Shared Costs

A downside model may show reassuring margins because it assumes management can immediately remove costs that are already committed.

Review leases, equipment financing, compensation arrangements, software contracts and other obligations. Separate costs that can be avoided before approval from costs that continue after the commitment is made. Potential reductions should reflect feasible timing, not merely a spreadsheet formula.

For multi-location practices, inspect shared-cost allocation as well. Moving central administrative expense from one location to another changes location-level profitability but does not reduce total practice spending.

Correction: Request a commitment schedule showing payment amounts, timing, responsible entity and any assumptions about changing or ending the commitment. Distinguish incremental costs caused by the proposal from existing costs allocated to it, while keeping both visible in the appropriate reports.

7. Confusing Profit With Available Cash

A profitable proposal can still require cash the practice does not have. On an accrual-based forecast, revenue may precede collection. Equipment purchases, debt principal and owner distributions also affect cash differently from operating expenses.

Illustrative example: all figures below are invented. A practice starts a month with $25,000 in cash. It expects $120,000 in net service revenue, but total cash receipts during the month are only $80,000. Operating cash payments are $95,000, and an equipment payment requires another $20,000.

Its ending cash is:

$25,000 + $80,000 − $95,000 − $20,000 = negative $10,000.

The revenue forecast does not make those payment obligations affordable. The proposal needs a documented funding solution, a different commitment schedule or reconsideration.

Correction: Review a direct cash schedule alongside profitability. It should include opening cash, receipts, payroll and vendor payments, equipment spending, financing flows, distributions and applicable tax payments reviewed with the CPA. Check the lowest cash point—not just the year-end balance. Where monthly totals conceal payroll pressure, inspect shorter periods around the decision.

Pre-Approval Model Review Checklist

Use this checklist to document findings rather than accepting a general statement that the model has been reviewed.

Error risk Detection test Required correction
Inconsistent periods Inspect units, dates and summary ranges Align periods and separate rates from totals
Double-counted revenue Trace service revenue, receipts and transfers Separate revenue from collections; eliminate internal duplication
Missing collection lags Reconcile receivables and receipt timing Show supported collection timing and opening receivables
Unrealistic capacity Compare visits with provider, room and staff availability Cap activity at supportable operating levels
Unsupported relationships Explain why connected assumptions move together Replace blanket changes with coherent operating logic
Ignored commitments Compare expense reductions with payment obligations Retain committed costs and realistic reduction timing
Profit mistaken for cash Reconcile beginning to ending cash Include all material cash movements and funding needs
Misleading location results Reconcile location and entity schedules to practice totals Correct allocations, transfers and duplicated activity

Before approval, retain the reviewed model version, unresolved assumptions, supporting schedules and the owner’s decision. If a material error could change affordability, return the model for correction rather than approving around it.

Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices. Clean books and location/entity financial visibility provide a stronger foundation for reviewing these decisions; they do not replace checking the model’s assumptions and cash logic.

FAQs

Does a positive profit forecast mean the practice can afford another provider?

No. Review compensation commitments, supporting staff costs, collection timing and the lowest projected cash balance. Profitability and the ability to meet payments are separate approval questions.

Should every assumption get worse in a downside case?

No. Change assumptions that belong to the stated downside event and preserve relationships that remain valid. Slower visit growth may reduce some supplies expense without reducing rent or committed salaries. Making every line worse can be as misleading as making every line optimistic.

What should an owner request when a scenario model fails review?

Request the corrected model, an explanation of the error, the affected outputs and supporting evidence for the revised assumptions. The preparer should show whether the correction changes cash needs, location profitability or the recommendation. Do not rely only on a revised summary slide.