SNF AR Tracker — Dashboard Snapshot
Confidential — Finance Team Use Only
Filters
▼
AR by Payer Category
| Payer category | Accounts | AR balance | Tier 1 count |
|---|
Tier 1 Accounts — Action Required
Top 6 by balance
| Patient | Payer | Balance | Days | Reason |
|---|
AR Aging Summary — All Facilities
| Facility | Current | 30 days | 60 days | 90–180 days | 180+ days | Total AR | Tier 1 |
|---|
1,867 accounts
| Account | Patient | Payer | Age Bucket | Balance | Tier | Status | Owner | Next Action Due |
|---|
Import PointClickCare Aging Export
Drop PCC CSV here or click to browse
No file selected
Supports PointClickCare aging export format
Import History
| Date | Facility | Accounts | New | Tier 1 | Warnings | Imported by |
|---|---|---|---|---|---|---|
| Apr 21, 2026 | VNR / RHR / RCC | 4,695 | 1,867 | 590 | 2,818 credits | System |
Tier 1 — Escalate Now Rules
AGE-90+
Age threshold
Days outstanding ≥ 90 — any payer, any balance amount
BAL-THRESHOLD
High-balance inactivity
Balance ≥ $2,500 and 60+ days, no action logged in 14 days
MCARE-DEADLINE-21
Medicare appeal deadline
Medicare denial with Redetermination deadline ≤ 21 days away
MC-CONTRACT-14
Managed Care dispute deadline
Managed Care contract dispute deadline ≤ 14 days away
INACTIVITY-PF
Stale payer follow-up
Status = PF (Payer Follow-up) with no action logged in 30 days
BAL-CHANGE
Unexpected balance change
Balance changed by ≥ $500 without a corresponding payment posted
Tier 2 & 3 Rules
T2-ACTIVE
Active follow-up
30–89 days, action logged within 14 days, does not meet any Tier 1 rule
MCAID-PE-NEW
Medicaid pending eligibility
Status = PE with documented application date, within 90-day state processing window
DA-IN-WINDOW
Denial — appeal filed
Status = DA (Denial, Appeal Filed), within 120-day Redetermination window
T3-MONITOR
New claim — normal window
0–29 days, claim submitted, within standard processing window
PP-CURRENT
Payment plan — current
Status = PP, payment plan active with no missed payments
Payer Filing Deadlines
| Payer | Filing Limit | Appeal Window | Escalation Trigger |
|---|---|---|---|
| Medicare Part A/B | 12 months | 120 days (Redetermination) | ≤21 days |
| Managed Care | Per contract | Per contract (30–90 days) | ≤14 days |
| Medicaid (state) | 90–365 days | 30–90 days post-denial | ≤30 days |
| Private Pay | No hard deadline | Collections threshold | 90 days, no plan |
Audit Log
Upload 835 ERA File
Drop 835 ERA file here or click to browse
No file selected
X12 EDI 835 format · .835 · .edi · .txt
Payment Summary
Import ERA files to view payment analytics.
Remittance History
| Imported | Filename | Payer | Facility | Check # | Check Date | Payment | Claims | |
|---|---|---|---|---|---|---|---|---|
| No remittances imported yet. | ||||||||
Denial Analytics
Import ERA files to view denial analytics.