Heron

Every number behind this morning's letter.

The figures, where the money is leaking, and the charts to argue with, as of 7:42 this morning.

Total A/R
$729,339
24.9% of it over 90 days
Days in A/R
29d
MGMA benchmark under 40 days
Denial rate
11.1%
industry benchmark under 10%
Net collection rate
98.5%
benchmark above 95%

Where the money is leaking

each one opens its queue

A/R trend

Rolling 12 months, hover a month for detail

$729,339
-15.0% vs Sep
SepOctNovDecJanFebMarAprMayJunJulAug
Total A/ROver 90 daysCurrent month28d in A/R

Expected collections

probability weighted
Next 30 days$300,787
across 89 open claims
Next 60 days$382,350
across 114 open claims
Next 90 days$420,610
across 129 open claims
Recovered to date$208,068
0-30 days
$366,814
89 claims
31-60 days
$114,877
25 claims
61-90 days
$65,965
15 claims
91-120 days
$89,189
17 claims
120+ days
$92,494
23 claims

A/R by payer

Outstanding balance, split by age

UnitedHealthcare · 49 claims$179,292
28.8% over 90 days, escalate
BCBS · 32 claims$177,960
20.7% over 90 days
Aetna · 33 claims$120,573
12.6% over 90 days
Medicaid · 13 claims$99,883
49.6% over 90 days, escalate
Medicare · 18 claims$66,755
30% over 90 days, escalate
Cigna · 19 claims$60,579
10.2% over 90 days
Humana · 5 claims$24,297
9.6% over 90 days
0-30 days31-60 days61-90 days91-120 days120+ days

Denial outcomes

Where denied dollars end up

77%
win rate on settled
Denied · 197$1,233,861
In queue · 73$483,300
Under appeal · 66$512,774
Recovered · 44$183,901
Written off · 14$53,886
$183,901 recovered against $53,886 written off. Everything still in queue or under appeal is money the outcome is not decided on yet.

Priority worklist

What to work first, in one list

across all queues

Denial rate by payer

Coral is over 25%, sun is over 15%

What the payers cite

The five reasons behind the most open denials