A full appointment schedule does not tell you how much revenue your practice will earn—or when that money will reach the bank. Provider availability, completed visits, payer mix, patient balances and collection delays all affect the result.
For an owner deciding whether to hire, add clinic sessions or fund another location, a useful forecast answers two separate questions:
- Net revenue: What do we expect to earn from the services we provide during the forecast period, after expected contractual adjustments and collection shortfalls?
- Cash receipts: When do we expect payments for those services—and existing receivables—to arrive?
Start with a simple model your practice manager and finance team can explain. Add detail only where it changes a decision. A transparent spreadsheet with reliable inputs is more useful than a sophisticated forecast built on billed charges or unsupported assumptions.
1. Define the Decision and Forecast Period
Before collecting data, identify what the forecast needs to support. Hiring another provider requires a different view from checking whether the practice can cover its next payroll.
| Decision | Useful forecast view | Main inputs |
|---|---|---|
| Cover provider and administrative payroll | Weekly cash receipts and payments | Opening cash, expected receipts, payroll and other payment dates |
| Add provider sessions | Monthly net revenue and incremental costs | Available sessions, completed visits, payer mix and staffing costs |
| Open or expand a location | Monthly location-level revenue, expenses and cash needs | Capacity ramp, shared costs, startup spending and collection lag |
| Plan owner distributions | Consolidated cash forecast with entity detail | Operating commitments, debt payments and reserves agreed with advisers |
A practical starting point is a rolling monthly revenue forecast paired with a shorter weekly cash forecast. For example, a practice might use a 12-month revenue view and a 13-week cash view. These are planning choices, not required reporting periods.
Assign responsibility at the outset: the practice manager maintains scheduling assumptions, the billing team validates collection patterns, and the finance team reconciles the model to the books and bank activity.
2. Prepare a Small, Reliable Input Set
Use completed visits and actual collection history rather than gross charges alone. Billed charges may differ substantially from the amounts a practice expects to receive.
Gather the following inputs, summarized by month and, where useful, location or provider:
| Input | What to capture | What to check |
|---|---|---|
| Visit activity | Completed visits by payer group and relevant service category | Scheduled visits are not counted as completed care |
| Provider capacity | Working days, sessions, leave and expected appointment availability | Planned volume fits actual staffing and space |
| Payer mix | Share of activity by meaningful payer category | Changes in payer mix are reflected in expected revenue |
| Collection yield | Total expected payer and patient collections attributable to completed services | Payment periods are not confused with service periods |
| Collection timing | Receipts grouped by time since service | Older receivables are distinguished from current services |
| Financial records | Reconciled receipts, refunds, expenses and account balances | Transfers and financing proceeds are not treated as patient revenue |
Use enough history to identify recurring patterns, but do not average away a known change. A provider departure, a new payer agreement or a location closure may make older results less representative.
The IRS guidance on business recordkeeping supports maintaining complete records, keeping business accounts separate and reconciling bank records. These practices also provide a sound foundation for forecasting.
Keep patient information out of routine planning files
Most owner-level forecasting can use aggregated visit counts, payer categories and financial totals. Avoid including patient names, diagnoses or other identifying details when they are unnecessary for the analysis.
Do not put patient-identifiable data into ordinary Slack conversations or general-purpose AI tools. When financial work requires protected health information, review the appropriate arrangements and handling procedures with qualified advisers. HHS explains business-associate responsibilities and the minimum necessary standard and its exceptions.
3. Build the Baseline Net Revenue Forecast
For planning purposes, a straightforward starting formula is:
Expected net revenue = completed visits × expected net revenue per completed visit
Here, expected net revenue per visit means the amount ultimately expected from both the payer and the patient, after expected adjustments and collection shortfalls. It is a management planning measure; your CPA should align financial-statement reporting with the practice’s accounting method and policies.
Start with achievable completed visits
Estimate volume from provider sessions and realistic completed visits per session. Allow for holidays, leave, vacancies, no-shows and cancellations that are not backfilled.
Do not count planned hires at full productivity before their start dates or assume every open appointment will be filled. Confirm that rooms, administrative coverage and other operational resources can support the forecast.
Apply payer-specific yields
Illustrative example only: A practice forecasts the following monthly completed visits. The amounts are invented to demonstrate the method, not payer benchmarks.
| Payer category | Completed visits | Expected net revenue per visit | Forecast net revenue |
|---|---|---|---|
| Commercial | 600 | $120 | $72,000 |
| Medicare | 300 | $150 | $45,000 |
| Self-pay | 100 | $90 | $9,000 |
| Total | 1,000 | $126 weighted average | $126,000 |
The forecast changes when either volume or mix changes. More visits do not necessarily produce proportionately more revenue if the mix shifts toward services or payer categories with lower expected yields.
If service types vary materially, split them into a few useful categories. A single average may be misleading when office visits and procedures have substantially different economics. Avoid unnecessary detail that the team cannot maintain.
Validate the yield before using it
Dividing this month’s deposits by this month’s visits can produce a distorted result because many deposits relate to earlier services. Where possible, estimate yield from service-period groups that have had time to collect.
Review unresolved balances, unusual refunds and changes in patient payment behavior. Do not assume every outstanding dollar will eventually be collected. If recent groups are still developing, document the uncertainty rather than treating their early collections as final results.
4. Translate Revenue into a Separate Cash Receipts Forecast
A revenue forecast describes expected value from services. A cash forecast schedules when payments arrive.
Use historical collection patterns to estimate the share received during the service month and subsequent periods. Separate payer and patient timing when the difference is material. These timing assumptions should describe when the expected collectible amount arrives; they should not apply a second collectibility reduction already included in net revenue.
Illustrative example only: Assume expected net revenue is collected 25% in the service month, 55% the following month and 20% two months later. This simplified pattern is not a medical-practice benchmark.
| Source of receipts in the forecast month | Calculation | Expected cash |
|---|---|---|
| Current-month services | $126,000 × 25% | $31,500 |
| Previous-month services | $120,000 × 55% | $66,000 |
| Services from two months earlier | $110,000 × 20% | $22,000 |
| Total forecast receipts | $119,500 |
The practice forecasts $126,000 of current-month net revenue but $119,500 of receipts during that month. Neither figure is necessarily wrong: they answer different questions.
Real collection patterns may extend over more periods. Account for older receivables, payment plans and expected refunds where material. When starting the model, use a schedule for opening receivables that does not overlap with service-period receipts already included in the forecast.
Next, build the cash bridge:
Opening cash + expected receipts − expected cash payments = ending cash
Schedule provider and administrative payroll, rent, supplies, debt payments, equipment purchases and other commitments separately. Coordinate tax payments with the practice’s tax adviser. A profitable month can still create a cash squeeze if receipts arrive after major payments are due.
sbb-itb-17e8ec9
5. Test Scenarios That Change an Owner’s Decision
Scenarios should expose a specific risk or opportunity, not simply label the same model “optimistic” and “conservative.” Keep the baseline, then change clearly identified assumptions.
Illustrative example only: Using the earlier weighted yield of $126 per visit:
| Scenario | Assumption | Monthly net revenue | Owner question |
|---|---|---|---|
| Baseline | 1,000 completed visits | $126,000 | Does the current operating plan work? |
| Lower volume | 900 completed visits at unchanged mix | $113,400 | Can staffing and other commitments be supported? |
| Added capacity | 1,050 completed visits at unchanged mix | $132,300 | Does incremental revenue justify added costs? |
| Slower collections | Baseline services, but receipts shift later | $126,000 | How much additional cash cushion is needed? |
The added-capacity case is useful only if provider availability, appointment demand, rooms and support staffing can accommodate the additional visits. Compare the added revenue with incremental costs—not with revenue alone.
For slower collections, move receipts into later periods rather than reducing revenue automatically. If the issue is also expected noncollection, adjust the revenue assumption separately and document why.
Other useful scenarios include a provider absence, delayed hiring, a payer-mix shift or a slower-than-planned ramp at a new location. Change one driver at a time first so the effect remains understandable.
6. Keep Location and Entity Views Consistent
A consolidated forecast can hide an underperforming location or a cash shortage in one entity.
For multi-location practices, forecast visits and direct revenue by location. Show direct costs separately from shared administrative expenses, and use a documented allocation method for shared costs. Apply it consistently so a change in allocation is not mistaken for an operational improvement.
For multi-entity owners, map receipts and payments to the entity and account where they belong. Intercompany transfers can change individual bank balances but do not create new consolidated practice revenue.
Review both the location-level P&L outlook and the entity-level cash forecast before committing to expansion or distributions. Consolidated cash is not necessarily interchangeable across entities; review proposed transfers with the appropriate advisers.
7. Refresh the Forecast and Explain Variances
After each monthly close, replace estimates with actual results and extend the forecast forward. Review near-term cash more frequently when liquidity is tight or collection timing is changing.
Explain differences through a short variance review:
- Volume: Were fewer visits completed, and why?
- Mix: Did payer or service mix change?
- Yield: Did expected collections per visit differ from the assumption?
- Timing: Did receipts arrive later, without changing expected ultimate collections?
- Capacity: Did leave, vacancies or scheduling constraints limit activity?
Keep the original forecast alongside the updated version. Otherwise, repeated revisions can conceal whether the assumptions were useful. Record what changed, who confirmed it and whether the change is temporary or ongoing.
AI-assisted tools can help organize aggregated data, check calculations or draft variance explanations. They do not establish whether a payer assumption is reasonable or whether a hiring plan is operationally achievable. A human reviewer should validate inputs, formulas and conclusions.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for US private medical practices, combining AI-assisted financial work with a human finance team. Clean books, catch-up bookkeeping and location/entity financial visibility can provide a more reliable foundation for these planning discussions.
Frequently Asked Questions
Should we forecast from charges, revenue or deposits?
Use completed services and expected collectible amounts to forecast net revenue. Use collection timing and opening receivables to forecast deposits. Charges can provide operational context, but they should not be treated as expected collections without appropriate adjustments.
What if our practice has limited history?
Start with achievable provider capacity, available payment information and explicit collection assumptions. Use a range rather than a single confident estimate. Update the model as actual visits and receipts develop, and avoid presenting another practice’s results as your own expected performance.
Does higher revenue mean we can hire?
Not by itself. Compare incremental revenue with compensation, benefits, administrative support and other added costs. Then test whether cash remains sufficient during onboarding and the collection lag.
Do we need AI forecasting software?
No. A maintained spreadsheet can be an effective starting point. Reliable records, clear assumptions and regular review matter more than model complexity. Consider additional tools when maintaining the forecast becomes burdensome or location and entity detail becomes harder to manage.
Make the Forecast a Decision Tool
Begin with achievable completed visits, payer mix and expected net collections. Translate those services into a separate receipts schedule, then compare cash availability with actual payment commitments.
The goal is not a precise-looking prediction. It is a repeatable process that helps the owner see what must happen for a plan to work, where uncertainty sits and when action is needed.