Sample A/R Aging Report

SAMPLE / DEMONSTRATION DATA. This report describes a fictional practice. It is not a real client.

1. A/R by aging bucket

Bucket	Balance	Share
0 to 30 days	$186,400	52%
31 to 60 days	$75,300	21%
61 to 90 days	$55,900	15.6%
91 to 120 days	$22,900	6.4%
Over 120 days	$17,900	5%
Total	$358,400	100%

2. Over 90 days by payer

Payer type	Balance	Oldest claim	Note
Commercial	$16,200	148 days	Two claims near filing limit
Medicare Advantage	$11,400	131 days	Pending medical records
Medicaid managed care	$7,800	122 days	Resubmitted with corrected ID
Self-pay	$5,400	160 days	Statements cycle 3

3. Priority worklist (top 5)

Claim	Balance	Days	Next action
Claim 1041	$2,840	146	Call payer, filing limit in 34 days
Claim 1187	$1,960	118	Send records requested on letter
Claim 1203	$1,720	104	Appeal CO-197 with auth number
Claim 1290	$1,410	97	Correct subscriber ID, resubmit
Claim 1312	$1,180	93	Check status, no response yet

Benchmarks are common industry targets, not guarantees. Results vary by practice, specialty, payer mix, claim volume, billing history and documentation.