A medical practice can miss its budget even when the schedule looks full. Collections may arrive later than expected, provider availability may change, or overtime and supply purchases may outpace the activity they support.
Budget variance reporting compares actual financial results with the approved plan and explains the differences. For a staffed private practice, its purpose is practical: help the owner decide whether to adjust staffing, investigate collections, control purchasing or revise the cash forecast.
A useful report answers four questions: What changed? Why did it change? Will it continue? Who will act? A spreadsheet showing red and green cells is only the starting point.
Establish a Consistent Budget-to-Actual Comparison
Before interpreting a variance, confirm that the budget and actual results measure the same thing. Match the reporting period, accounting basis, account categories and organizational scope.
Separate revenue performance from collection timing
On a cash-basis report, revenue generally reflects receipts. A shortfall may mean fewer services were provided, but it may also reflect delayed payer payments or slower collection of patient balances.
On an accrual-basis report, recognized revenue and cash receipts are different measures. A practice can meet its revenue budget while receiving less cash than expected. Review the income statement alongside a collections schedule and cash forecast rather than treating them as interchangeable.
Use a consistent revenue definition. Gross charges are not a substitute for expected collectible revenue. If the books require revenue adjustments or estimates, have the finance team explain those assumptions before using the figures to judge performance.
Confirm that the books are ready
Before the monthly review:
- Reconcile bank and credit-card accounts.
- Confirm that payroll, vendor bills and other material transactions are included under the practice's accounting method.
- Investigate duplicate entries, missing receipts and unusual account classifications.
- Separate owner distributions, financing activity and capital purchases from operating expenses as appropriate.
- Check that transactions belong to the correct location and entity.
The IRS guidance on business recordkeeping supports maintaining complete records, separate business accounts and reconciled bank records. Those foundations also make management reporting more dependable.
Keep the original approved budget visible. A revised forecast should show the current outlook without erasing the plan against which the practice committed resources.
Use a Clear Variance Sign Convention
A straightforward convention is:
Dollar variance = Actual − Budget
Percentage variance = (Actual − Budget) ÷ Budget × 100
With this convention, a positive number means actual results exceeded budget—not necessarily that performance was favorable.
- For revenue, a positive variance is generally favorable.
- For expenses, a positive variance is generally unfavorable.
- For operating profit, a positive variance is generally favorable.
Label favorable or unfavorable separately. Lower payroll spending caused by an unfilled position may look favorable financially while creating a capacity problem. Likewise, higher supplies expense may be justified by higher activity.
If the budget is zero, report the dollar difference and mark the percentage as not applicable rather than dividing by zero.
Illustrative example: a monthly practice report
All figures in this example are illustrative, not benchmarks. Assume the practice uses an accrual-basis management income statement with consistent revenue recognition and expense classification.
| Line item | Budget | Actual | Actual − Budget | Interpretation |
|---|---|---|---|---|
| Net revenue | $200,000 | $189,000 | −$11,000 | Unfavorable |
| Provider and administrative payroll, including employer costs | $100,000 | $106,000 | +$6,000 | Unfavorable |
| Medical supplies | $20,000 | $23,000 | +$3,000 | Unfavorable |
| Occupancy | $20,000 | $20,000 | $0 | On budget |
| Other operating expenses | $10,000 | $9,000 | −$1,000 | Favorable |
| Total operating expenses | $150,000 | $158,000 | +$8,000 | Unfavorable |
| Operating profit | $50,000 | $31,000 | −$19,000 | Unfavorable |
The revenue variance is −$11,000 ÷ $200,000, or −5.5%. Operating profit is $19,000 below plan because revenue fell $11,000 short and expenses exceeded budget by $8,000.
That calculation identifies the gap. It does not explain the cause.
Explain Variances Through Volume, Mix, Rate and Timing
Use a consistent set of explanations so the owner can distinguish an operating problem from a reporting or payment-timing issue.
| Driver | What it means for a practice | Evidence to review |
|---|---|---|
| Volume | More or fewer completed encounters, procedures or provider sessions than planned | Aggregate activity, provider availability and schedule utilization |
| Mix | A different combination of services, providers or payers | Aggregate service and payer categories with comparable definitions |
| Rate | A change in revenue per comparable service, wage rates or supply unit costs | Payment information, payroll rates and vendor invoices |
| Timing | Receipts or expenses fall in a different reporting period | Deposit records, payment activity, invoice dates and payroll calendar |
| One-time items | A nonrecurring cost or receipt affects the month | Supporting documents and confirmation of whether it will recur |
Do not label every unexplained difference “timing.” Identify what shifted, when it is expected to resolve and what evidence supports that expectation.
Build a simple revenue bridge
Continuing the illustrative example, assume the budget anticipated 1,000 completed encounters at average net revenue of $200 per encounter. Actual results were 900 encounters at $210, producing $189,000.
One consistent decomposition is:
- Volume effect: (900 − 1,000) × $200 = −$20,000.
- Combined rate and mix effect: 900 × ($210 − $200) = +$9,000.
- Total revenue variance: −$20,000 + $9,000 = −$11,000.
This suggests that lower volume drove the revenue shortfall, partly offset by higher average revenue per encounter. It does not prove that payment rates improved. The average could have changed because of payer mix, service mix or revenue adjustments.
For a practice with varied services, analyze meaningful categories before drawing conclusions from an overall average. Keep collection timing in a separate cash bridge so delayed receipts are not counted again as a revenue-performance problem.
sbb-itb-17e8ec9
Investigate the Practice's Main Controllable Costs
Staffing and payroll
Separate provider compensation, administrative wages, employer payroll costs, benefits, overtime and temporary coverage where material. A single payroll total can hide very different decisions.
Ask whether the variance came from paid hours, compensation rates, coverage needs or timing. Compare staffing costs with actual activity and provider sessions, not just the original budget.
For cash-basis reporting, an additional payroll payment within a month can create a timing variance. Under accrual accounting, expense recognition may differ. Confirm the accounting treatment before describing an extra pay period as the explanation.
Do not respond automatically by reducing hours. First assess whether the additional cost supported activity, covered an absence or compensated for a workflow problem. Financial analysis should inform staffing decisions without substituting for operational judgment.
Supplies and purchasing
Supply expense can rise because of greater activity, higher unit prices, a different service mix or bulk purchasing. Determine whether purchases and consumption fall in different periods under the practice's reporting method.
In the illustrative report, supplies exceeded budget even though encounter volume fell. That warrants review of purchase quantities, unit prices, purchasing timing and service mix. It does not, by itself, establish waste.
Separate a recurring cost increase from a one-time stock-up. Otherwise, the owner may either overreact to one month or overlook a continuing increase.
Payer receipts and patient balances
Compare actual receipts with the collection forecast, using aggregate categories that help explain the shortfall. Review payer receipts and patient payments separately when useful.
Ask the billing lead to distinguish lower underlying activity from delayed payments, unresolved balances or other collection issues. The finance report should record the cash impact and expected resolution; detailed billing follow-up belongs with the responsible operational team.
A payment expected next month is not available for this month's payroll. Update the cash forecast even when the underlying revenue outlook has not changed.
Make Location and Entity Comparisons Fair
For a multi-location practice, show location-level results alongside the consolidated report. A strong location can otherwise conceal a shortfall elsewhere.
Directly assign identifiable costs to the location that incurred them. For shared administration, rent or other common costs, document a reasonable allocation method and apply it consistently. Show material allocation changes separately so a bookkeeping change does not appear to be an operating trend.
For multi-entity owners, preserve entity-level reporting and reconcile intercompany activity before interpreting consolidated results. An internal transfer is not new revenue for the combined group.
When a location is ramping up or a provider joins partway through a period, compare results with the assumptions in that location's budget. A mature-location comparison alone may not answer whether the new operation is on plan.
Turn Each Material Variance Into an Owned Action
Set review thresholds appropriate to the practice's size and cash position. Use both dollar amounts and percentages: a large percentage on a small account may matter less than a modest payroll overrun. Also flag smaller recurring variances that accumulate over time.
Each material explanation should state the cause, supporting evidence, expected duration and next action. Assign one accountable person by name, even if several people contribute.
The following is an illustrative action register; replace the role labels with the responsible employees' names in the working report.
| Finding | Accountable owner | Next action | Evidence for the next review |
|---|---|---|---|
| Lower activity reduced revenue | Practice manager | Compare completed sessions with the staffing and scheduling plan | Aggregate activity and provider-availability summary |
| Overtime exceeded plan | Administrative manager | Identify coverage gaps and revise the coverage plan | Paid-hours and overtime comparison |
| Supply costs rose despite lower activity | Purchasing lead | Separate quantity, price and bulk-purchase effects | Purchase summary and vendor-price comparison |
| Payer receipts arrived below forecast | Billing lead | Validate delayed receipts and revise expected collection timing | Aggregate receipts and outstanding-balance summary |
Replace “monitor next month” with a specific deliverable and review date. The owner should be able to tell whether the action was completed and whether it changed the outlook.
Run a Repeatable Monthly Review
A practical reporting package includes:
- Monthly and year-to-date budget versus actual results, using the same sign convention throughout.
- A short variance commentary covering material revenue, payroll, supply and overhead differences.
- A cash outlook reflecting current payer receipts, patient payments, payroll and vendor obligations.
- An action register with named owners, deadlines and unresolved questions.
Use the meeting to make decisions, not to discover unreconciled transactions. Review prior actions first, then discuss new exceptions and update the forecast. Timing differences should be tracked until they reverse or receive a different explanation.
A revised forecast should reflect what management now expects. Keep it separate from the original budget so the practice can see both its initial commitments and its current financial direction.
Use AI Assistance Without Outsourcing Judgment
AI-assisted financial work can help organize comparisons and draft explanations from reviewed data. A human finance professional still needs to verify classifications, calculations and proposed causes. An unusual expense is a question to investigate, not proof of an error or misconduct.
Keep routine variance reports at an aggregate financial level. Patient names and clinical details generally are not needed to explain payroll, supplies or collections. The HHS guidance on minimum necessary information provides context for limiting access and disclosure where that standard applies. Do not place patient-identifiable information into ordinary Slack messages or general-purpose AI tools.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for U.S. private medical practices with staff. Its AI-assisted work is supported by a human finance/CPA team, with services including clean books, catch-up bookkeeping, location/entity financial visibility and support through Slack.
The goal of budget variance reporting is not a more elaborate dashboard. It is a dependable explanation of what changed, a realistic view of cash and a clear decision assigned to the person who can act.