Back to templates
Synthetic data
RCM · Live template preview
AR aging dashboard
Payer-mix breakdown, days-in-AR, and collector worklist prioritization.
Authored byAnonymous Owl — Developer 3915@anon-owl-3915
Vibe-coded in JetBridge AI · clone in one click on launch day
Total AR
$1602k
Across 7 payers
Days in AR
18
MGMA target: 35
>90 days
13.6%
Target: <18%
Net collection
96.2%
Trailing 90d
Aging by payer
Hover a cell to inspect; darker = larger balance
lowhigh
| Payer | 0-30 | 31-60 | 61-90 | 91-120 | 120+ | Total |
|---|---|---|---|---|---|---|
| Aetna PPO | $142.0k | $88.0k | $41.0k | $22.0k | $11.8k | $304.8k |
| UHC Choice Plus | $168.0k | $102.0k | $54.0k | $19.5k | $8.2k | $351.7k |
| BCBS IL | $121.0k | $76.0k | $38.0k | $26.5k | $14.4k | $275.9k |
| Medicare A/B | $96.0k | $58.0k | $19.0k | $6.2k | $2.1k | $181.3k |
| Medicaid (Molina) | $71.0k | $44.0k | $31.0k | $18.8k | $12.1k | $176.9k |
| Cigna OAP | $88.0k | $39.0k | $22.0k | $9.1k | $4.8k | $162.9k |
| Self-pay | $32.0k | $28.5k | $24.8k | $21.9k | $41.2k | $148.4k |
Collector worklist · prioritized
92
Lillian FerraroACC-771248
BCBS IL · 134d aged · Call patient · payment plan offer
$4820.00
88
Devon SutherlandACC-770984
Aetna PPO · 78d aged · Refile with corrected modifier 25
$2410.50
85
Mira SundaramACC-771016
UHC Choice Plus · 65d aged · Status check via 276/277
$9120.00
71
Tomás VerlaineACC-770411
Self-pay · 142d aged · Send pre-collection letter
$612.40
81
Ophelia DrozdovACC-771320
Cigna OAP · 51d aged · Appeal denied units (CO-151)
$3340.80
76
Reginald AkpabioACC-770655
Medicare A/B · 44d aged · Verify secondary COB
$1180.00
Collector capacity
Priya Anand184/220
Recovered $73.6k MTD
Marcus Beale162/200
Recovered $58.2k MTD
Yusuf Halim211/220
Recovered $81.1k MTD
Camila Ortiz145/180
Recovered $49.4k MTD