Revenue Cycle KPI Dashboard

Cash Flow Velocity & AR Aging Optimization — 450-bed Academic Medical Center, Southeast US

Reporting Period: October 2024 – March 2025 | $310M Net Patient Revenue

Target DSO
<42.0
Current DSO
44.8
DSO (All Payers)
44.8
-3.5d vs Target
Cash Coll. Rate
97.3%
+2.3% vs Target
AR 90+ Days
18.2%
+3.1% vs Prior
Cash Post Lag
16.4h
-7.6h vs Prior
Unapplied Cash
2.8%
+0.9% vs Target
Bad Debt Rate
3.4%
-0.6% vs Prior

AR Aging Waterfall Migration — 6-Month Trend

Note: Spike in Month 2 (Nov 2024) reflects Change Healthcare clearinghouse outage (3,200 claim delay). Recovery visible in Months 3-4.

DSO by Payer Class

Payer-Specific Payment Velocity

Daily Cash Collection Pacing — Last 30 Days

Collector Productivity Rate

Promise-to-Pay Conversion

AR Aging Detail Table — Top 10 Payer-Bucket Combinations

Payer Name Aging Bucket Balance ($M) % of Total AR Accounts Avg Balance Status
UnitedHealthcare 90+ days $4.23M 8.9% 1,248 $3,389 Critical
Blue Cross Blue Shield 61-90 days $3.87M 8.2% 1,094 $3,538 Review
Medicare FFS 31-60 days $3.21M 6.8% 2,147 $1,495 Normal
Aetna 90+ days $2.94M 6.2% 823 $3,572 Critical
Medicaid Managed Care 61-90 days $2.68M 5.7% 1,567 $1,710 Review
Self-Pay 90+ days $2.45M 5.2% 3,921 $625 Critical
Cigna 31-60 days $2.13M 4.5% 612 $3,480 Normal
Humana 61-90 days $1.89M 4.0% 534 $3,539 Review
Blue Cross Blue Shield 0-30 days $1.76M 3.7% 487 $3,614 Normal
UnitedHealthcare 31-60 days $1.52M 3.2% 421 $3,611 Normal

Credit Balance Aging Distribution

Follow-Up Activity Heatmap

Accounts Worked per Collector per Day (Last 4 Weeks)
Mon
Tue
Wed
Thu
Fri
Week 1
52
48
54
51
46
Week 2
49
53
55
47
50
Week 3
56
54
49
52
45
Week 4
50
53
51
48
44
<47
47-51
52+

Executive Summary

DSO improved 3.5 days from 48.3 to 44.8, driven by accelerated commercial payer follow-up on 60-90d AR cohort.
90+ day AR increased 3.1% due to Nov 2024 Change Healthcare outage (3,200 claims). Reversal underway in Month 4-5.
Cash posting lag reduced 7.6h (24h → 16.4h), improving daily treasury visibility by $2.1M average float correction.
Collector productivity +8% (46 → 51 accounts/day avg), contributing to faster follow-up cycle on UHC and Aetna 90+ inventory.

Priority Action Items

1
UHC 90+ AR ($4.23M): Deploy dedicated 2-person team for systematic outreach on 1,248 accounts; target 30% resolution in 14 days.
2
Unapplied cash at 2.8%: Weekly reconciliation sprint to clear $870K backlog; assign temp resource for 30-day deep dive.
3
Self-pay 90+ AR ($2.45M): Increase promise-to-pay outreach cadence; test SMS reminder pilot to lift 68% conversion rate.
4
Sustain cash posting gains: Lock in 16h SLA as standard; automate remittance parsing for top 5 payers to eliminate manual delays.