A medical practice budget should help an owner answer concrete questions: Can we afford another support employee? What happens if a provider reduces sessions? Will adding appointment capacity generate enough collections to cover the additional payroll?

A single revenue target cannot answer those questions. Scenario-based budgeting connects provider capacity, completed visits, expected collections and staffing costs so you can compare an expected case with plausible downside and upside cases.

The goal is not to predict every outcome. It is to decide which expenses you can commit to now, which should depend on demonstrated demand, and how much cash the practice needs if results fall short.

This guide provides a worksheet structure for staffed US private medical practices. All numerical scenarios below are illustrative examples, not industry benchmarks or recommended staffing levels.

Separate the Budget From the Forecast

Use three distinct planning views rather than repeatedly overwriting one spreadsheet.

Planning view Purpose When to change it
Approved budget Records the operating plan and spending commitments the owner approved Keep the original version for comparison; document any formally approved revision separately
Scenario budgets Test expected, downside and upside assumptions before making commitments When evaluating a decision or a material change in conditions
Rolling forecast Combines actual results with updated expectations for future months Update after each monthly close and when significant events occur

For example, your approved budget may include a new provider starting in July. If the start moves to September, update the forecast without erasing the original budget. The difference explains why revenue, recruitment spending and support staffing diverged from the plan.

An upside scenario is not spending authorization. It shows what additional resources might become necessary if demand and collections support expansion.

1. Establish a Reliable Starting Point

Before modeling growth, reconcile the numbers you already have. Gather recent monthly financial statements, provider schedules, aggregate completed-visit counts, payroll reports, payer receipts, patient payments and accounts-receivable summaries.

Use enough history to identify seasonal patterns, closures and unusual months. Separate recurring expenses from temporary items such as recruitment fees or equipment purchases.

The IRS guide to business recordkeeping supports maintaining complete records, separate business accounts and reconciling bank records. Those practices also give your budget a more dependable starting point.

For each input, document its source and owner:

Input Practical source Person responsible for checking it
Available provider sessions Provider schedules, leave plans and start dates Practice manager
Completed visits per session Aggregate scheduling or billing reports Operations or billing lead
Expected net collections per visit Mature historical visit cohorts and collection results Finance team with billing input
Provider and support payroll Payroll reports, compensation agreements and hiring plans Payroll or finance lead
Occupancy and other recurring costs General ledger, contracts and vendor bills Bookkeeper or controller
Collection timing Aggregate receivables and deposit history Billing and finance leads

Do not estimate collectible revenue by multiplying visits by gross charges. Use an assumption that reflects the practice's actual payer mix, contractual adjustments and collection experience.

2. Build Revenue From Provider Sessions

Define a session consistently—for example, a scheduled half-day block. Then connect capacity to activity and expected net collections:

Provider sessions × completed visits per session = completed visits

Completed visits × expected net collections per visit = modeled net revenue

Completed visits per session should reflect actual throughput, including the effect of unfilled appointments and cancellations. If that assumption already incorporates those losses, do not apply a second cancellation reduction.

For multiple specialties or materially different provider economics, calculate separate rows and then total them. A blended average may hide a shift toward lower-collection visit types.

Illustrative monthly scenario worksheet

The following example represents a hypothetical practice. Expected net collections per visit means the amount ultimately expected from that month's visits, not necessarily cash received during that month. The revenue line is a planning estimate; your finance team should align financial reporting with the practice's accounting method.

Revenue driver Downside Expected Upside
Provider sessions 144 160 176
Completed visits per session 8 9 10
Completed visits 1,152 1,440 1,760
Expected net collections per visit $115 $120 $120
Modeled net revenue $132,480 $172,800 $211,200

Here, the downside case combines fewer sessions, lower utilization and a lower collection yield. The upside case assumes both additional sessions and stronger utilization. Neither outcome should be entered without an operational explanation.

Attach a short assumption note to each scenario:

  • Expected: Current provider availability and recent utilization continue.
  • Downside: Provider leave reduces sessions, appointment gaps increase and collection yield weakens.
  • Upside: Providers can add sessions, demand fills them and support coverage is available.

Do not assume that extra sessions automatically fill. Check appointment demand, provider availability, room capacity and support coverage separately.

3. Connect Support Staffing to Workload

Staffing costs rarely move smoothly with revenue. A practice may need its current front-desk and clinical support coverage even when visits decline. Conversely, additional sessions may require another shift or employee before the practice reaches its upside revenue.

Build payroll from actual positions, schedules and compensation terms. Include employer payroll costs and benefits in the relevant payroll assumptions. Keep owner compensation for work performed distinct from owner distributions.

For each proposed staffing change, identify:

  1. The sessions or workload it supports.
  2. Whether existing staff can cover that workload without an unsustainable schedule.
  3. The date the cost starts, including training time.
  4. Whether the expense is committed, adjustable or dependent on a future decision.

Illustrative monthly operating worksheet

This continues the same hypothetical scenario. Provider and support payroll include assumed employer costs and benefits. Supplies vary at an illustrative $8 per completed visit. Other operating costs are assumed fixed within this activity range.

Operating line Downside Expected Upside
Modeled net revenue $132,480 $172,800 $211,200
Provider payroll $60,000 $60,000 $66,000
Support and administrative payroll $30,000 $30,000 $33,000
Visit-related supplies $9,216 $11,520 $14,080
Other operating costs $42,000 $42,000 $42,000
Total modeled operating costs $141,216 $143,520 $155,080
Modeled operating surplus / (shortfall) ($8,736) $29,280 $56,120

This simplified surplus is before debt principal, capital purchases, owner distributions and taxes; it is not a complete financial statement.

The downside retains baseline payroll because a reduction in visits does not immediately remove staffing commitments. The upside adds provider and support payroll rather than treating all additional revenue as profit.

The decision is now clearer: the expected case supports current operations, but the downside produces a shortfall. Before adding permanent payroll, the owner should test both the incremental economics and the cash needed during the ramp-up.

4. Add a Separate Cash Schedule

A practice can show a positive operating result while its bank balance falls. Payer receipts and patient payments may arrive after services are delivered, while payroll and rent must be paid on schedule.

Build cash receipts separately from modeled revenue. Use opening receivables, expected collection timing, payer payment patterns and patient-balance collection experience. Avoid treating all outstanding balances as immediately collectible.

Use this cash equation for each month:

Opening cash + cash receipts − operating payments − debt principal − capital spending − owner distributions = ending cash

Illustrative expected-case cash bridge

For this example only, assume all $143,520 of modeled operating costs are paid in the month, with no noncash expenses or unpaid operating bills. Cash receipts include payments for both current and earlier services.

Cash line Illustrative amount
Opening available cash $100,000
Cash receipts $165,000
Operating payments ($143,520)
Debt principal payments ($5,000)
Equipment purchases ($10,000)
Owner distributions ($10,000)
Ending available cash $96,480

Despite the expected-case operating surplus, cash falls by $3,520. Receipts lag modeled revenue, and the practice also funds principal payments, equipment and distributions.

Repeat the cash schedule for the downside and upside cases using their own collection assumptions. An upside case may still create a temporary cash squeeze if hiring and equipment costs precede collections. Add tax payments or reserves as applicable with your CPA's guidance.

5. Turn the Model Into Decision Rules

Scenario planning becomes useful when it changes a decision. For each significant commitment, write down the evidence required to proceed, the person responsible and the fallback action.

Decision Evidence to review Possible response
Add support coverage Sustained workload, scheduling pressure and affordable forecast payroll Approve coverage tied to the demonstrated need
Add provider sessions Available demand, rooms, support and positive incremental economics Phase in sessions rather than assuming immediate full utilization
Buy equipment Cash remaining after purchase under the downside case Proceed, stage or defer the purchase
Increase owner distributions Forecast cash after payroll, obligations and planned reserves Limit distributions when cash headroom narrows
Respond to weaker results Whether the cause is capacity, utilization, yield or collection timing Address the specific driver rather than cutting every expense equally

Set a minimum cash level based on your actual obligations and risk tolerance, not a generic percentage. Include payroll timing, rent, debt payments and spending already committed.

Test collection delays separately from a permanent revenue decline. A timing problem may require a different response than persistently underfilled provider schedules.

6. Extend the Worksheet Across Months and Locations

Do not multiply one representative month by twelve. Build monthly columns for provider leave, holidays, working days, recruitment dates, benefit changes and known spending commitments.

For multi-location practices, calculate sessions, visit activity, direct payroll and occupancy by location before combining results. Show shared administrative costs separately, then apply a documented allocation method if you need a fully allocated location P&L.

Keep allocation choices consistent across scenarios unless the underlying cost driver changes. Otherwise, an apparent improvement at one location may simply be a redistribution of overhead.

For multi-entity owners, maintain entity-level cash schedules. Cash shown in a combined report may not be available in the entity that owes the next payroll. Model any planned intercompany transfers explicitly and have the accounting team review their treatment.

7. Use AI to Assist, Not Approve, the Budget

AI-assisted work can help organize assumptions, draft variance explanations and identify inconsistent formulas. A spreadsheet may be sufficient; the essential requirement is a model your manager and finance team can inspect and maintain.

Useful review tasks include checking whether:

  • Completed visits equal sessions multiplied by visits per session.
  • Supply costs change with the stated activity driver.
  • Added sessions have corresponding provider and support coverage.
  • Annual totals match the monthly schedules.
  • Revenue and cash receipts remain separate.

A human reviewer should verify source figures, formulas and assumptions before the owner approves spending. AI-generated explanations are not evidence that a model is correct.

Use aggregate operational and financial data wherever possible. Do not place patient-identifiable information in a general-purpose AI tool or ordinary Slack messages. If a proposed accounting workflow involves protected health information, assess the arrangement with appropriate advisers; HHS explains when business-associate responsibilities can arise.

8. Review Variances Without Rewriting History

After each monthly close, compare actual results with the approved budget and update the rolling forecast.

Explain revenue differences through four drivers: provider sessions, completed visits per session, net collection yield and collection timing. For payroll, distinguish compensation changes from added hours, overtime, benefits and hiring dates.

Assign each material variance an action owner. A provider availability issue belongs with scheduling and leadership; a receipt delay needs billing and finance investigation. Not every variance requires a spending cut.

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 financial visibility provide a stronger foundation for these budgeting discussions, with support available through Slack.

The finished budget should leave the owner with three things: an approved operating plan, a realistic view of downside cash needs, and clear conditions for expanding capacity. Keep that budget as the reference point while the forecast evolves with actual results.