Kpi dashboard for medical billing


Are you able to assist with a KPI dashboard for medical billing  that includes benchmarks. Also attached is a dashboard but it doesn’t include measurements to show on or below target.

  • The KPIs and benchmarks will include Net Collection Rate (Internal Benchmark >97%-Industry Benchmark >95%)
    • (Payments-Credits)/(Charges-contractual adjustments)X100
  • Days in AR (Internal Benchmark < 40 days-Industry Benchmark < 45 Days)
    • Divide Total AR by Average Daily Charges
  • AR % over 120 days (Internal Benchmark <20% of Total AR-Industry Benchmark <25% of Total AR)
    • Divide Total AR by AR over 120 days
  • Net AR ( Internal Benchmark <10% of annual charges-Industry Benchmark <10% of annual charges)
    • 6 Month Avg Charges-Payments-Adjustments=Net AR
  • Clean Claim Rate (Internal Benchmark Under 2%-Industry Benchmark 5%)