Behavioral health KPI dashboard: capacity and revenue

A behavioral health KPI dashboard should show how available clinic capacity becomes completed appointments and recognized revenue. Use aggregate operating exports, with denominators that remain consistent across clinics. The purpose is to support staffing and commercial decisions; appointment activity alone does not establish clinical quality or patient outcomes.

Define the operating unit before the measures

Choose one reporting period, one clinic mapping, and one definition of available capacity. A slot is available only when a clinician and the necessary resources were available for that appointment. Keep planned leave and administrative time outside the denominator according to a documented policy.

For this example, all appointments have equal scheduled length. If your mix includes different visit lengths, compare minutes instead of counts. A clinic offering longer appointments should not look less productive merely because it completes fewer visits.

The operations manager owns the capacity and appointment definitions. The revenue-cycle lead owns revenue attribution and adjustments. Finance owns the cost scope and ledger reconciliation. Keep those owners visible beside each measure, using the KPI dashboard template for the general register and target rules.

The required exports are clinic-level appointment outcomes, available capacity, recognized service revenue, and operating costs. Do not include patient names or patient-level narratives for this aggregate review. If the export is incomplete at the reporting cutoff, mark the affected measure incomplete rather than publishing a percentage that looks final. The daily KPI dashboard covers the separate problem of comparing partial operating days.

A worked example for two US clinics

Harbor Counseling Group is an illustrative US organization reviewing September 2026. Its final schedule export contains the following equal-length appointment slots. No canceled slots were refilled in this example, and each slot appears in exactly one final category.

First reconstruct the booked population. North has 720 + 140 + 60 = 920 booked slots. South has 640 + 80 + 40 = 760. The organization therefore has 920 + 760 = 1,680 booked slots, with the other 120 never booked.

Use these definitions for this particular dashboard:

Appointment utilization = Completed appointments / Available slots

Unfilled cancellation share = Canceled and unfilled appointments / Booked slots

No-show share = No-show appointments / Booked slots

For example, organization utilization is 1,360 / 1,800 = 75.56%, and its no-show share is 100 / 1,680 = 5.95%. Percentages are rounded to two decimal places after calculation. Calculate organization percentages from summed counts, rather than averaging the clinic percentages.

North's lower utilization invites a scheduling review. It does not identify the cause. Managers need to distinguish unbooked capacity, late cancellation patterns, appointment mix, and the completeness of the schedule export before choosing an intervention.

Connect completed appointments to revenue and cost

Use recognized revenue attributed to the completed services in the period, after the organization's revenue adjustments. Do not divide cash received this month by this month's visits when the receipts relate to earlier services. The IRS explanation of accrual accounting distinguishes income earned from the timing of payment; the dashboard must state which basis its revenue export uses.

This example uses a uniform realized revenue of $120 per completed visit. That is an assumption for the example, not a reimbursement benchmark. CMS publishes Physician Fee Schedule payment files and locality configuration; those Medicare resources should not be mistaken for a single realized rate covering every payer and clinic service.

The cost export includes assigned clinic labor and occupancy costs. Corporate expenses remain outside this subtotal, so call the result clinic operating contribution rather than organization net income.

North's revenue is 720 × $120 = $86,400, and its contribution is $86,400 − $72,000 = $14,400. The total check is $163,200 − $136,000 = $27,200. Revenue per completed visit is $163,200 / 1,360 = $120, using total revenue and total visits.

Prove the totals before discussing performance

The capacity reconciliation is 1,360 completed + 220 canceled and unfilled + 100 no-show + 120 never booked = 1,800 available slots. Perform the same test for each clinic. Any unexplained remainder means the categories overlap or a status is missing.

Tie recognized revenue to the closed revenue report and assigned costs to the approved cost workbook. Keep the reconciliation of prior-period adjustments visible; do not remove them just to make revenue equal visits multiplied by a convenient rate. Real clinics can have different service and payer mixes.

For presentation choices, the dashboard software guide explains how to evaluate whether readers can inspect a KPI's definition and source. The operating proof here matters before choosing a chart style.

Change one input: realized revenue per visit

Now change only the assumed realized revenue per completed visit from $120 to $125. Keep capacity, appointment outcomes, and costs unchanged. This isolates revenue yield from scheduling performance.

The revenue change is 1,360 × ($125 − $120) = $6,800. Contribution rises by that same amount because cost is held constant. Utilization does not improve, so the dashboard should not describe this as a capacity gain. Finance would investigate revenue assumptions, while operations would continue its separate scheduling review.

Where it goes wrong

• Counting cancellation events as lost slots. A refilled slot can generate a cancellation event and a completed visit; it cannot occupy both final capacity categories.
• Mixing appointment lengths. Compare equal units or use minutes before comparing clinics.
• Using receipts as current-service revenue. Collection timing can obscure the revenue associated with completed appointments.
• Ignoring unavailable time. Leave, closures, or administrative blocks can distort capacity if their treatment changes between periods.
• Inferring outcomes from attendance. These measures describe business operations and cannot establish treatment effectiveness or patient need.

Review your clinic exports in Covirage

Bring aggregate clinic capacity, appointment outcomes, and revenue and cost files; Covirage maps the columns, and its tools compute and check the comparisons while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for healthcare for the industry context.