Most denials in medical billing are preventable, and the same handful of reasons recur across every client — eligibility, coding, missing authorization, timely filing. The problem is that denials arrive as remits scattered across each client's clearinghouse and PM system, so the firm never sees the consolidated pattern. This dashboard ranks denials by reason and dollars so the team works the vital few instead of churning through the pile.
What this dashboard answers
It answers the four questions a denials lead needs every week: how much is being denied (rate and dollars), how much of it could we have prevented, and how well are our appeals doing? The overview shows denial rate, denied dollars, preventable-denial %, and appeal overturn rate, with denied dollars ranked by CARC-style reason — CO-27 coverage terminated, CO-16 missing info, CO-197 no auth, CO-29 timely filing, CO-50 not medically necessary, CO-18 duplicate — and a denial-rate cut by payer.
The metrics that matter
Denial rate alone doesn't tell you where to act; preventable-denial % does, because it splits the denials your front end should have caught from the ones that are genuinely the payer's call. Appeal overturn rate tells you whether working a denial is worth the labor — a high overturn rate on a reason means those denials are recoverable and should be appealed every time. Recovered dollars closes the loop on whether the appeal effort is paying for itself.
Why the data is trapped across the systems
Denial reasons come back through the clearinghouse and post into each client's PM system as remits — athenahealth, AdvancedMD, eClinicalWorks, each holding only its own client's denials. No single system aggregates denials across the book, so the recurring root causes that span clients stay invisible. Ranking them requires pulling every client's denial export and categorizing the CARC codes by hand.
How to read it
Start with the Pareto: denied counts by reason with a cumulative-percent line, so the vital few reasons driving most denials jump out. Then use the root-cause matrix — denied count, denied dollars, preventable %, overturn rate, and recovered dollars per reason — to decide where to invest: prevention for the high-preventable reasons, appeals for the high-overturn ones. The denial-rate-by-client bar finds the practices generating the most. The sample uses entirely synthetic, anonymized data, so there is no PHI.
Metrics it tracks
| Metric | What it means |
|---|---|
| Denial Rate | Share of adjudicated claims the payer denied — SUM(denied) ÷ total claims. |
| Denied Dollars $ | Billed charges on denied claims — revenue at risk from denials. |
| Preventable-Denial % | Share of denials flagged as front-end/preventable — SUM(preventable) ÷ SUM(denied). |
| Appeal Overturn Rate | Appeals won ÷ appeals filed — how effective the appeal process is. |
| Denied Claim Count | Count of denied claims in the period. |
| Recovered Dollars $ | Dollars paid after a successful appeal or rework. |
Used by: Denials team leads and RCM operations directors
Frequently asked questions
What are the most common medical-billing denial reasons?
The recurring categories are eligibility/registration (CO-27), coding and charge-entry errors (CO-16), prior auth or referral missing (CO-197), timely filing (CO-29), medical necessity (CO-50), and duplicate/COB (CO-18). Ranking denied dollars by these CARC reasons shows whether the fix belongs in front-end registration, coding, or billing throughput.
What does preventable-denial percentage tell me?
It splits denials your front end should have caught — eligibility, missing auth, coding — from denials that are genuinely the payer's adjudication call. A high preventable percentage means the highest-leverage work is process change upstream, not appeals downstream. Most billing-industry guidance treats a large share of denials as preventable.
How does appeal overturn rate guide where to fight?
Overturn rate is appeals won divided by appeals filed, by reason. A high overturn rate means those denials are recoverable and worth appealing every time; a low one means the labor rarely pays off and prevention is the better play. Reading overturn rate next to recovered dollars tells you whether the appeals process earns its keep.
Build this report on your own data
Clone this RCM / billing companies template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →