Denial Rate by Reason and Payer with COUNTIF and a Pareto Chart
This lesson is part of the course
In this lesson
You count one week's 30 denials by reason, build the cumulative share for a Pareto analysis, calculate each payer's denial rate and draw the Pareto chart.
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