Blog · Board and management reporting · Healthcare
Medical practice analytics connects appointment capacity with revenue and operating costs. Compare locations from aggregate exports, reconcile the figures, and assign the next business action.
Medical practice analytics compares appointment capacity, revenue and operating costs to show how each location performs as a business. Start with aggregate scheduling and finance exports for the same period, then reconcile the totals before deciding where to change resources. A useful report explains the difference between a busy schedule and an economically sustainable location.
Ask whether a location has unused appointment capacity, weak revenue per completed visit, or a cost base that its current activity does not cover. Those questions require different denominators. A full schedule does not establish that appointments happened, and completed visits do not establish that revenue was collected.
Keep the report at location and period level. No patient names, diagnoses or individual clinical histories are needed for the calculations below. The broader medical practice KPI guide covers the measure list; this example concentrates on reconciling capacity with financial performance.
Use actual approved financial summaries rather than treating a reimbursement schedule as realized revenue. CMS describes the Physician Fee Schedule as a payment method for professional services, including providers in private practice. That gives payment context; the practice's own ledger establishes its recorded revenue.
Create one row per location for the reporting month. The scheduling summary should contain released appointment slots, booked slots, completed visits, no-shows and cancellations. Use one comparable appointment unit; separate visit types with different durations before comparing capacity.
The financial summary needs billed charges, approved revenue adjustments and earned net revenue. Add labor, occupancy and other operating costs. State whether labor includes employer taxes, benefits and owner compensation, and whether shared administrative expenses have been allocated.
For this illustrative US practice, all appointments have a comparable slot duration. Booked slots are counted once at the reporting cutoff and finish in mutually exclusive outcome categories. A canceled booking remains a cancellation in this reconciliation; the report does not count every historical booking change.
| Location | Released slots | Booked slots | Completed visits | No-shows | Cancellations |
|---|---|---|---|---|---|
| North | 2,400 | 2,100 | 1,890 | 126 | 84 |
| South | 1,800 | 1,500 | 1,350 | 90 | 60 |
| Total | 4,200 | 3,600 | 3,240 | 216 | 144 |
North reconciles as 1,890 + 126 + 84 = 2,100. South reconciles as 1,350 + 90 + 60 = 1,500. The combined outcome counts equal 3,600 booked slots. The remaining released slots were unbooked under this report's definition.
Booking fill rate = Booked slots / Released slots
Completed capacity rate = Completed visits / Released slots
No-show rate = No-shows / Booked slots
These definitions are for this management report. They are not universal benchmarks. Keep the denominator visible whenever the rate is shared.
| Location | Booking fill rate | Completed capacity rate | No-show rate |
|---|---|---|---|
| North | 87.5% | 78.8% | 6.0% |
| South | 83.3% | 75.0% | 6.0% |
| Total | 85.7% | 77.1% | 6.0% |
Percentages are rounded to one decimal after calculation. The total booking fill rate is 3,600 / 4,200 = 85.7%; it is not the average of the displayed location percentages. North's completed capacity rate is 1,890 / 2,400 = 78.8%.
South has lower booking fill despite the same no-show rate. That directs the administrator toward the availability and booking process before attributing the difference to attendance. Patient access analytics examines appointment lead times and referral denominators separately.
The controller has approved the following earned revenue and expense summary for the same month. Revenue adjustments reduce the listed billings to recognized net revenue. Cash receipts are excluded because they can settle balances from other periods.
| Location | Billed charges (USD) | Revenue adjustments (USD) | Net revenue (USD) | Labor (USD) | Occupancy (USD) | Other costs (USD) |
|---|---|---|---|---|---|---|
| North | 420,000 | 79,800 | 340,200 | 190,000 | 45,000 | 32,000 |
| South | 300,000 | 43,500 | 256,500 | 145,000 | 36,000 | 28,000 |
| Total | 720,000 | 123,300 | 596,700 | 335,000 | 81,000 | 60,000 |
The revenue proof is 720,000 − 123,300 = 596,700. The expense proof is 335,000 + 81,000 + 60,000 = 476,000. Match both totals to the approved location ledger summary and explain any unallocated amount explicitly.
Reported operating surplus = Net revenue − Listed operating costs
Reported operating margin = Reported operating surplus / Net revenue
| Location | Listed costs (USD) | Reported surplus (USD) | Reported margin | Revenue per completed visit (USD) | Cost per completed visit (USD) |
|---|---|---|---|---|---|
| North | 267,000 | 73,200 | 21.5% | 180.00 | 141.27 |
| South | 209,000 | 47,500 | 18.5% | 190.00 | 154.81 |
| Total | 476,000 | 120,700 | 20.2% | 184.17 | 146.91 |
Per-visit dollars are rounded to cents. North's revenue per visit is 340,200 / 1,890 = $180.00. The practice margin is 120,700 / 596,700 = 20.2%. This is the margin on the costs included here; omitted corporate expenses would require a further deduction.
South earns more per completed visit but also spends more per completed visit. That is a specific follow-up for finance and the location manager: compare service mix, staffing coverage and allocated occupancy costs before assuming a pricing problem. Full details on the accounting measure belong in operating margin.
Scheduling should investigate South's lower booking fill rate using the aggregate availability report. Finance should separately review collection timing through days sales outstanding, rather than calling earned revenue cash. The administrator should record the proposed action, its owner and the next reporting period to review.
None of these business ratios measures clinical quality or patient experience. CMS explains that its CAHPS surveys ask patients about their experiences with providers and plans. Keep that evidence distinct from capacity and cost reporting.
Bring an aggregate location scheduling summary and the matching revenue and operating cost file to Covirage. Covirage maps the columns, its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See Covirage for healthcare teams for the supporting industry context.
Start with location-level scheduling totals, billed charges and approved revenue adjustments, plus payroll and operating expense summaries for the same period. Include capacity definitions and cost allocation rules. This business review can use aggregate reports without names, clinical details or individual appointment records.
Billed charges are the amounts initially charged. Approved contractual and other revenue adjustments can make recognized revenue different, while cash receipts can relate to earlier services. Keep charges, earned revenue and collections separate, and have finance approve the reconciliation used in the report.
Yes, as an investigation measure, provided the visit and revenue definitions match. A difference can reflect service mix, payer mix, contractual terms or timing. It does not establish staff performance or clinical value, so review the business explanation before changing resources.
The practice administrator should own the action list, with scheduling validating capacity and appointment outcomes and finance validating revenue and expenses. Each location manager should explain material differences. Agree on definitions before comparing sites, and keep an owner and review date for unresolved items.