Building Better Visibility Through Reporting & Dashboards

One of the most consistent gaps I see in home care agency management is the disconnect between the data agencies generate and the insight they actually extract from it. Home care is a data-rich environment — every visit, every authorization, every billing transaction, every caregiver interaction produces structured data. But most agency leaders are making decisions from intuition, anecdote, and a handful of canned reports that don't reflect the operational complexity they're actually managing.

Good business intelligence in home care starts with defining the KPIs that actually matter. Not every metric is equally useful, and chasing too many metrics creates noise. The following are the indicators I consider most operationally critical.

Fill rate — the percentage of scheduled visits that are successfully completed — is the single most important operational metric in a home care agency. It combines scheduling efficiency, caregiver reliability, and client retention into one number. A healthy fill rate for a well-run agency is above 92 percent. Rates below 85 percent indicate systemic problems that need immediate attention.

Fill rate should be tracked at multiple levels: agency-wide, by branch or region, by payer, by service line, and by individual scheduler. A fill rate problem that looks minor at the aggregate level often reveals concentrated failure when broken down. A specific scheduler consistently filling at 80 percent while others run at 95 percent is an operational and coaching opportunity that aggregate data won't surface.

Authorization utilization — the percentage of authorized hours that are actually delivered and billed — is a revenue metric that most agencies undertrack. When authorized hours go undelivered, the agency loses revenue it's already been approved to collect. Common causes include scheduling gaps, caregiver no-shows, and client cancellations that aren't followed up on.

Tracking authorization utilization by payer and service type reveals where the leakage is happening. A managed Medicaid contract running at 70 percent utilization when 90 percent is achievable represents significant recoverable revenue.

EVV compliance rate — the percentage of visits with valid electronic verification — needs to be tracked daily, not monthly. Agencies that review EVV compliance at month-end are discovering problems too late to address them before billing submission. Daily compliance monitoring, with exception alerts routed to the relevant coordinator, allows problems to be resolved within 24 hours rather than lingering for weeks.

Billing lag — the time between visit completion and claim submission — is a controllable KPI that directly affects cash flow. Industry best practice is claim submission within 3 to 5 business days of visit completion. Agencies running 10 to 14 day billing cycles are leaving cash on the table and creating denial risk as payer timely filing deadlines approach.

Days in accounts receivable (AR) by payer is the companion metric. A healthy overall AR is under 30 days for commercial payers and under 45 days for Medicaid. Medicaid AR above 60 days usually indicates a systemic problem — incorrect billing, authorization mismatches, or a denial backlog.

Caregiver retention, tracked at 30, 60, and 90 days of employment, is the leading indicator of turnover problems. The industry loses a disproportionate share of new caregivers in the first 90 days — often because of poor onboarding, schedule problems, or case-fit issues that show up immediately. A 90-day retention rate below 60 percent is a warning sign that needs to be addressed at the recruitment and onboarding level, not the retention level.

The most effective dashboards in home care separate executive views from operational views. Executive dashboards — consumed by the CEO, COO, and CFO — should show 5 to 8 KPIs at the agency level with trend lines. Weekly snapshots work better than real-time feeds at this level; the goal is pattern recognition, not crisis response.

Operational dashboards — used by scheduling coordinators, billing managers, and branch directors — need to be real-time and actionable. A billing coordinator's dashboard should show today's unbilled visits, outstanding denials by age, and authorization utilization alerts. A scheduling coordinator's view should show open shifts, fill rate by caregiver, and EVV

Most home care agencies are working with data spread across multiple systems: a scheduling/EVV platform, a billing system, a payroll system, and possibly a clinical documentation platform. Building unified dashboards requires either a platform that integrates all of these natively or a business intelligence layer — Power BI or Tableau are the most common — that connects to each system via API or scheduled data export.

Power BI in particular has become a common choice for home care agencies because of its relatively low cost, integration with Microsoft's ecosystem (which many agencies already use for email and document management), and the availability of pre-built healthcare data connectors. A well-configured Power BI environment can pull daily data from HHAeXchange, the billing system, and the payroll platform and produce a unified dashboard that updates overnight — giving leadership current-day visibility every morning.

The investment in building this infrastructure pays back quickly. Agencies with real-time operational dashboards consistently identify problems faster, respond more effectively, and make better resource allocation decisions than agencies operating from weekly or monthly reporting cycles. In a margin-compressed environment, that visibility is not a luxury — it's a competitive necessity.