Denial Exposure & Recovery Worksheet

Enter amounts from your own denial reports. Use gross charges, the same reporting period and the same level (claim or line) for every amount.

Current initial denials

Gross charges on claims whose first denial falls in your reporting period. Leave out rebills.

The part of the amount above with no follow-up yet (no appeal, correction or documented decision) as of your reporting date. It is a subset of the amount above and is never added to it.

Optional: your practice’s history

Use a closed past period and your own records. Leave both fields blank to skip — no default rate is used.

Gross charges of initial denials that reached final resolution — paid or adjusted. Leave out denials that are still open.

Gross charges of the resolved initial denials above that were overturned and ultimately paid.

Calculated in your browser. Nothing you enter is sent or stored.

Enter your amounts to see results

Results show your measured amounts, your unworked share and — only if you add your own history — an illustrative projection. Nothing is estimated for you.

How this worksheet calculates

The worksheet reports the amounts you enter and calculates three ratios from them. It uses no industry, specialty or built-in rates.

  • Unworked shareUnworked initial-denial gross charges ÷ initial-denial gross charges × 100CureAdvantage operational definition. Shown only when initial-denial gross charges are above $0.
  • Practice historical overturn rateGross charges of initial denials overturned and paid ÷ gross charges of initial denials paid and adjusted × 100HFMA Claim Integrity Task Force (percentage of initial denials overturned, gross charges). Resolved initial denials only — open denials are excluded; numerator and denominator cover the same period.
  • Projected gross charges potentially recoveredUnworked initial-denial gross charges × practice historical overturn rateCureAdvantage operational definition. An illustrative projection, shown only when you enter your own history.

Read the results carefully

  • All amounts are gross charges — not allowed amounts, payments or collections. A denied charge is not automatically lost revenue.
  • The three amounts overlap: unworked charges are part of initial-denial charges, and the projection is part of unworked charges. They are never added together.
  • An initial denial is the first denial on a claim; rebills are excluded (HFMA Claim Integrity Task Force). Rejected or returned claims are not denials.
  • Partial payments and corrected claims: HFMA’s definition is based on the final resolution of initial denials but does not say how to count a partially paid denial or one resolved through a corrected claim. Apply one consistent internal rule to both history amounts. The most conservative rule is to count as “overturned and paid” only the gross charges of lines that were actually paid.
  • Your historical overturn rate describes past results. It does not predict future results, and filing and appeal deadlines still apply.
  • Related HFMA measure: denial write-offs (net of recoveries) as a percentage of net patient service revenue (MAP Key AR-6). It needs income-statement data, so this worksheet does not calculate it.
  • For denial rates by claim count or by dollars, and why different definitions give different results, use the Denial Rate Calculator.
Illustrative example — not a benchmark
Initial-denial gross charges
$24,000
Unworked initial-denial gross charges
$6,000
Resolved initial-denial gross charges (history)
$50,000
Of those, overturned and paid (history)
$21,000
Unworked share
25.0%
Practice historical overturn rate
42.0%
Projected gross charges potentially recovered
$2,520

Sources