A medical practice can have a full appointment calendar and still face a cash shortage. Scheduled visits are not completed visits, billed charges are not net revenue, and revenue earned this month may not reach the bank until later.

For an owner deciding whether the practice can support another provider, a location expansion or its existing payroll, the projection needs to explain those differences. A useful model starts with provider availability, estimates completed activity, applies realistic service and payer assumptions, and then schedules collections separately.

The result should answer two questions: How much revenue is the practice expected to earn, and when will the related cash arrive?

Start With a Model That Matches the Decision

Build the projection monthly, with enough detail to explain the decision you are making. For near-term payroll and operating needs, supplement it with a weekly cash forecast.

A single-location practice might need provider-level activity assumptions and one consolidated revenue schedule. A multi-location or multi-entity group may need separate schedules by location and legal entity before consolidation.

Keep these layers distinct:

Projection layer Main question Typical inputs
Availability What capacity will actually be available? Provider schedules, leave, start dates and closures
Completed activity How much scheduled work will occur? Booking levels, cancellations and completed visits
Net revenue What revenue is expected from that activity? Service mix, payer mix and expected net reimbursement
Collections When will the money arrive? Opening receivables, payment timing and patient balance collections
Cash sufficiency Will receipts cover obligations? Provider/admin payroll, rent, other expenses and financing payments

Do not begin by increasing last year's revenue by a blanket percentage. Historical results are a useful comparison, but the bottom-up model should explain why the new forecast differs.

1. Establish a Reliable Starting Point

Gather recent monthly results and the underlying activity reports. Use enough history to identify recurring patterns, while separating periods affected by unusual closures, staffing changes or delayed payment batches.

Useful inputs include:

  • Provider availability and completed visits by month.
  • Service and payer mix, using categories with materially different reimbursement.
  • Gross charges, contractual adjustments and other relevant adjustments.
  • Net revenue under the practice's reporting basis.
  • Payer receipts, patient receipts and accounts receivable aging.
  • Bank deposits and reconciled accounting records.

Check that the reports measure the same thing. A service-date report, a payment-posting report and a bank-deposit report will not necessarily agree for a given month because they capture different events.

Document timing differences rather than forcing the totals to match. Also separate current-period activity from refunds, recoupments and adjustments relating to earlier services.

The IRS guidance on business recordkeeping supports maintaining complete business records, separate business accounts and reconciled bank records. Those practices provide a stronger foundation for forecasting; they do not replace the operational reports needed to estimate future activity.

2. Project Provider Availability and Completed Visits

Start with the schedule the practice can realistically staff—not its theoretical maximum capacity.

For each provider or provider group, record available working days and planned appointment capacity. Reflect known leave, administrative time, planned closures and actual start dates. For a new provider, separate the employment start date from the date the practice expects the provider to begin generating billable activity and receiving payer payments.

Then estimate booking and completion separately:

Available appointment slots × booking rate × completion rate = projected completed visits

The completion rate should reflect the share of booked appointments expected to occur. If your source report already measures completed visits as a share of available slots, do not apply a second cancellation adjustment.

Illustrative example: monthly completed visits

Every number in the following example is illustrative, not a benchmark or recommendation.

Input Illustrative assumption
Providers 5
Available days per provider 16
Appointment slots per provider-day 20
Total available slots 1,600
Share of slots booked 75%
Booked appointments 1,200
Share of booked appointments completed 90%
Projected completed visits 1,080

Use provider-specific assumptions when availability or visit patterns differ materially. A single average can conceal the effect of a provider's leave or a new hire's gradual schedule buildup.

This is a financial capacity model, not a recommendation to change clinical schedules or care decisions. Operational and clinical leaders determine appropriate scheduling; the forecast translates their approved plans into financial expectations.

3. Convert Completed Activity Into Expected Net Revenue

Do not multiply completed visits by the practice's standard charge and call the result revenue. Gross charges may differ substantially from the amount the practice expects to realize.

Instead, estimate net revenue by meaningful service and payer categories:

Completed activity in each category × expected net revenue per unit = projected net revenue

A unit might be a visit, procedure or another service measure appropriate to the practice. Use separate categories when a blended visit average would conceal important differences. Avoid counting a service twice if its revenue is already included in an encounter-level estimate.

Base rates on the practice's own evidence, such as applicable contracted reimbursement and mature historical service cohorts. Recent cohorts may be incomplete because payments and adjustments are still arriving. Comparing this month's collections with this month's visits can therefore produce a misleading rate.

Illustrative example: payer mix and net revenue

This simplified example uses the 1,080 completed visits above and assumes a comparable service mix within each payer group. All figures are illustrative.

Payer group Share of completed visits Completed visits Expected net revenue per visit Projected net revenue
Commercial group 60% 648 $110 $71,280
Other contracted group 25% 270 $130 $35,100
Self-pay group 15% 162 $90 $14,580
Total 100% 1,080 $112 blended average $120,960

A practice with materially different service categories should expand this into a service-by-payer table. More detail is useful only when the underlying data can support it.

Define what each net rate includes. If it already incorporates expected contractual reductions and collection shortfalls, do not subtract the same amounts again elsewhere in the model.

4. Document Revenue Recognition Assumptions

An operational estimate of net service revenue is not automatically the same as revenue reported in the accounting books.

For an accrual-based management projection, the model generally attributes estimated revenue to the period in which services are provided, subject to the practice's accounting policies and applicable recognition requirements. Collection timing belongs in a separate schedule.

For cash-basis books, receipts may drive reported revenue. In that situation, label the service-based schedule as an operational estimate and bridge it to the cash-basis forecast. Do not present the two as interchangeable.

Have the CPA or finance lead confirm how the model handles:

  • Contractual adjustments and expected collection shortfalls.
  • Later revisions to estimates for earlier service periods.
  • Refunds, payer recoupments and unusual settlements.
  • Services that do not fit a visit-based model, such as certain recurring or bundled payment arrangements.

The forecast should state its reporting basis and the assumptions behind its rates. Consistent treatment is more useful than a precise-looking total built from incompatible definitions.

5. Build a Separate Collection Schedule

Once net revenue is projected, estimate when the related cash will arrive. Revenue and collections should connect, but they should not be the same row copied twice.

Build the receipt forecast from two sources:

  1. Opening receivables: amounts outstanding before the forecast starts, grouped by realistic expected payment timing.
  2. New activity: expected collections from each future service month's projected revenue.

Use the practice's historical payment patterns, separating payer and patient receipts when their timing differs materially. Older balances should not automatically receive the same collection assumptions as recent balances.

Illustrative example: one service month's collection pattern

The following allocation is illustrative. It assumes the full $120,960 net estimate is expected to be collected across the periods shown; actual timing and ultimate realization will vary.

Collection period Share of the service month's net estimate Expected receipts
Service month 50% $60,480
Following month 35% $42,336
Second following month 15% $18,144
Total 100% $120,960

If opening receivables are also expected to produce an illustrative $45,000 of receipts in the service month, total projected receipts for that month would be $105,480: $60,480 from new activity plus $45,000 from prior activity.

Do not add an entire receivables balance to cash receipts without estimating its collectibility and timing. Likewise, a balance expected to remain unpaid is not simply a payment delayed indefinitely.

Where applicable, reconcile opening receivables, new receivable activity, collections, adjustments and ending receivables. Investigate unexplained differences before relying on the forecast.

6. Connect the Forecast to the Owner's Decision

Revenue projections become useful when they inform a specific commitment.

For a proposed provider hire, model the available start date, expected schedule buildup, reimbursement assumptions and collection lag. Then compare receipts with the timing of compensation and associated operating costs.

For a location expansion, show revenue and collections by location alongside direct expenses. Keep shared administrative costs visible and use a documented allocation method for location-level P&Ls. Shared-cost allocations affect reported profitability, not the amount of practice revenue.

For multiple entities, identify which entity earns the revenue, holds the receivable and receives the cash. An intercompany transfer is not new consolidated revenue, and a bank balance in one entity should not silently become assumed funding for another.

Test a small set of scenarios:

Scenario change What to adjust Decision it informs
Provider start is delayed Availability and later collections Whether hiring costs need additional funding
Fewer appointments are completed Completed activity Whether expected receipts still support fixed obligations
Payer or service mix changes Net revenue per category Whether the revenue target remains realistic
Payments arrive later Collection schedule, not necessarily earned revenue Whether the cash cushion is sufficient

A payment delay may create a cash problem without changing expected earned revenue. A lower net reimbursement assumption affects revenue and eventual collections. Keeping those effects separate helps owners choose the right response.

7. Review Variances and Use AI With Human Oversight

Update the model after each monthly close and review near-term cash more frequently when payroll funding is tight. Preserve the original forecast so the team can compare it with actual results.

Explain differences through availability, completed visits, service/payer mix, net rates and collection timing. Assign each material assumption to someone who can validate it: the practice manager for schedules, the revenue-cycle lead for payment patterns, and the finance team for accounting treatment and reconciliations.

AI-assisted analysis can help organize aggregate reports, draft variance explanations or flag assumptions for review. It should not invent reimbursement rates, treat incomplete payment data as final or replace the underlying reconciliation.

Use aggregate financial information where possible, and do not put patient-identifiable information into ordinary Slack messages or general-purpose AI tools. HHS provides guidance on business-associate responsibilities and the minimum necessary standard and its exceptions; appropriate handling depends on the workflow and parties involved.

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/CPA team. Clean books and location/entity visibility provide a useful foundation for reviewing projections against actual results.

FAQs

Should a medical practice forecast charges, revenue or collections?

Forecast net revenue and collections separately. Gross charges can help reconcile billing activity, but they are not a substitute for expected reimbursement. Net revenue supports performance planning; collections support cash planning.

What if the practice has limited historical data?

Start with documented provider availability, supported reimbursement assumptions and clearly labeled booking and completion estimates. Use a range rather than a single confident result. Update the assumptions as completed activity and payment evidence become available.

How should a practice handle a new provider?

Model the provider separately until the activity and collection pattern is established. Include the expected start of billable activity, schedule buildup, applicable reimbursement and payment delays. Do not assume an established provider's monthly revenue begins immediately.

Can AI create the projection on its own?

AI can assist with organizing inputs and checking calculations, but the practice still needs accountable owners for availability, reimbursement, accounting and collection assumptions. A transparent model that staff can explain is more useful than an unsupported prediction.

Build a Forecast You Can Explain

A dependable medical practice revenue projection follows a clear chain: available provider time, completed activity, expected net revenue and eventual receipts. Keep those stages separate, document their assumptions and compare them with actual results. That gives owners a practical basis for staffing, expansion and cash decisions without mistaking a busy schedule for money available to spend.