A/R Aging, A/R over 90 Days and Days in A/R
This lesson is part of the course
In this lesson
You age every open claim from its date of service, sort it into aging buckets with an approximate lookup, and calculate the share of A/R over 90 days and the days in A/R.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Charges vs Allowed vs Paid: the Contractual Adjustment Locked
- Clean Claim Rate and First-Pass Resolution Rate Locked
- Denial Rate by Reason and Payer with COUNTIF and a Pareto Chart Locked
- A/R Aging, A/R over 90 Days and Days in A/R Locked
- Net Collection Rate by Payer and the Gap to Target Locked
- Patient Responsibility per Claim: Deductible, Copay and Coinsurance Locked
- Cost to Collect and Write-Off Rates by Quarter Locked
- RCM Dashboard: Status, Gaps and Red Flags Locked