Outstanding
$89,420+$72,870
Collected this month
$42,180+5%
Avg. days to payment
18-3
Denied still appealable
$42,1804 claims
A/R aging
how old the money is. $25,820 past 60 days collects at under half the rate of fresh money.
0 to 30 days
$41,200 owed
Paid on schedule$39,960 likely, 97%
31 to 60 days
$22,400 owed
Slow, still normal$19,940 likely, 89%
61 to 90 days
$13,900 owed
Chase these now$39,960 likely, 71%
over 90 day
$41,200 owed
Mostly gone$3,100 likely, 26%
Outstanding by payer
| Payer | Outstanding | Oldest item | Avg days to pay | Denial rate | |
|---|---|---|---|---|---|
| Medicaid Managed Care | $46,900 | 118 days | 31 | 14.1% | 6 stuck claims |
| UnitedHealthcare | $18,400 | 42 days | 14 | 5.2% | Healthy |
| Blue Cross Blue Shield | $11,320 | 67 days | 17 | 7.8% | 1 denial, 6 days left |
| Aetna | $9,840 | 51 days | 16 | 6.4% | Healthy |
| Humana | $7,620 | 38 days | 13 | 4.9% | Healthy |
Medicaid is 52% of what you are owed and the slowest to pay.
A cash-flow structure problem, not a billing one. Worth negotiating a partial advance.
Who owes it
Insurers$79,62080% of the total
Insurers$79,62080% of the totalPatients$9,800across 61 people
Patients$9,800across 61 peoplePatient balances are small and many. Chasing them individually costs more than they are worth, which is why the discharge gate matters more than a collections process.
Do these first
Appeal 4 denials
$11,830 recoverable, one closes in 6 daysSend 12 draft invoices
$3,410 not yet billed to anyoneCollected this month
$42,180+5%
From insurers$24,90050%
Card and HSA$9,70023%
Cash at desk$4,98012%
Cash that arrived. Revenue earned is a different number, in Reports.