| Bucket | Claims | Amount | Action |
|---|---|---|---|
| Current 0–30d | 16 | $9,200 | Monitor |
| 31–60 days | 6 | $3,800 | Follow up |
| 61–90 days | 3 | $2,400 | Urgent |
| 90+ days | 6 | $3,000 | ESCALATE |
| Payer | Open | $ AR | Denied |
|---|---|---|---|
| BCBS | 8 | $4,800 | 2 |
| UHC / Optum | 6 | $3,900 | 3 |
| Cigna | 4 | $2,800 | 0 |
| Medicare | 3 | $1,900 | 1 |
| Patient | Carrier | Auth Expiry | Visits Left | Risk |
|---|---|---|---|---|
| Martinez, C. | Travelers | 3d left | 2 left | High |
| Nguyen, K. | Hartford | Expired | Exhausted | High |
| Thompson, R. | Liberty Mutual | Jun 15 | 8 of 20 | Low |
| Patient | Adjuster | Direct Line |
|---|---|---|
| Martinez, C. | Tom Brady | 555-201-3341 |
| Nguyen, K. | Mary Jones | 555-301-4412 |
| Davis, M. | Bob White | 555-501-3381 |
| Patient | Attorney | LOP | Days Treating | $ At Risk |
|---|---|---|---|---|
| Williams, J. | Smith & Assoc. | No LOP | 65d | $1,850 |
| Brooks, T. | Lee & Partners | No LOP | 44d | $2,200 |
| Clark, D. | Doe Law Group | Pending | 22d | $980 |
| Attorney / Firm | Cases | Balance | No LOP |
|---|---|---|---|
| John Smith / Smith & Assoc. | 5 | $12,400 | 2 |
| Jane Doe / Doe Law Group | 4 | $9,800 | 0 |
| Bob Lee / Lee & Partners | 6 | $15,200 | 1 |