Every practice management system has a denial report. Almost nobody reads it, because it is a list of 400 lines sorted by claim number, and a list is not a dashboard. When we ask a practice what its denial rate was last month, the usual answer is a guess, and when we ask what the top denial reason was, the answer is "eligibility" because it always is. Neither answer tells anyone what to fix.
A denial dashboard is a small set of numbers, updated weekly, that a practice manager, a billing lead and a physician owner can look at in ten minutes and agree on one thing to change. You can build the first version in a spreadsheet. Most practices should, before they buy anything, because the hard part is not the software. It is deciding what to count, and agreeing once on how to count it.
Key takeaways
- Capture eight fields on every denied line at posting time; six come from the 835 and two, category and owner, are added by a person using a fixed map.
- Map every CARC to one of eight categories that name the process that failed, and never let individual posters choose.
- Exclude contractual adjustments (CO-45) and patient responsibility (PR codes); they are not denials and they make the rate meaningless.
- Six weekly numbers are enough: denial rate, denied dollars by category, preventable share, days to first action, appeal overturn rate, and write-offs without appeal.
- Report dollars, not counts, and track the process change you made alongside the number it was supposed to move.
Eight fields on every denial
The dashboard is only as good as what is captured when a denial is posted. Whoever posts remittances needs to record, for each denied line:
- Payer, as a standardized name (not "BCBS", "Blue Cross" and "Anthem" for the same plan).
- Rendering provider.
- CPT or HCPCS code and modifiers.
- Date of service and date of denial.
- Billed amount of the denied line.
- CARC and RARC codes from the 835, exactly as received.
- Denial category, assigned from the CARC using a fixed map (below).
- Owner and status: to be corrected, to be appealed, written off with reason, or resolved.
Most of this is already in the 835 and can be exported. The category and owner are the two fields a human adds, and they take seconds if the category map is fixed in advance. A claim adjustment reason code (CARC) is the payer's standardized reason on the remittance, such as CO-197 for a missing precertification; a remittance advice remark code (RARC) adds detail. If your practice management system does not store both on the line, the export from the clearinghouse will.
The category map
The point of categories is to connect a denial to the process that produced it. We use eight, and we map every CARC to one of them. The map is more important than the exact categories; arguing about it once and then never again is what makes the dashboard consistent.
| Category | Typical CARC codes | Process that owns it |
|---|---|---|
| Eligibility and registration | CO-27, CO-31, CO-109, CO-140, CO-A1 with eligibility remarks | Front desk, pre-visit verification |
| Authorization and referral | CO-197, CO-15, CO-62, CO-198 | Referral and authorization staff |
| Coding | CO-4, CO-11, CO-146, CO-181, CO-182 | Coders and providers |
| Bundling and edits | CO-97, CO-234, CO-236 | Coders; claim scrubber configuration |
| Medical necessity | CO-50, CO-56, CO-167 | Providers; documentation; payer policy review |
| Timely filing | CO-29 | Billing operations |
| Duplicate | CO-18 | Billing operations (often not a real denial) |
| Missing or invalid information | CO-16 with its remark code | Depends on the remark; usually registration or billing setup |
Two things are not denials and should be excluded: contractual adjustments (CO-45) and patient responsibility (PR-1, PR-2, PR-3). Practices that count these as denials report a 40% denial rate and then ignore the number because it is obviously wrong.
Six numbers for the weekly view
- Denial rate: denied lines as a share of adjudicated lines, overall and by payer. We watch for anything above 8% overall or above 12% for a single payer, though the right benchmark depends on specialty.
- Denied dollars by category: the billed amount in each of the eight categories for the period. This is the chart that tells you where to work.
- Preventable share: the portion of denied dollars in eligibility, authorization, coding, timely filing and duplicate categories. These are process failures. Medical necessity and bundling are partly payer behavior.
- Days to first action: median days from denial date to the first correction, appeal or write-off decision. A number above 10 means denials are sitting.
- Appeal overturn rate: appeals decided in the practice's favor as a share of appeals decided. Low overturn rates on a category mean either weak appeals or a payer policy you should stop fighting and start preventing.
- Write-offs without appeal: dollars written off with a denial reason and no appeal record. This is the number physician owners should ask about, because it is money that was never argued for.
A worked example: one month on the dashboard
Here is what the view looks like for a fictional six-provider multispecialty practice with about 3,200 claims a month, after four weeks of capturing the eight fields. The numbers are typical of a practice that has never looked at this before.
| Category | Denied lines | Denied dollars | Share of denied dollars | Preventable |
|---|---|---|---|---|
| Eligibility and registration | 96 | $14,200 | 29% | Yes |
| Authorization and referral | 31 | $11,800 | 24% | Yes |
| Coding | 44 | $6,100 | 12% | Yes |
| Bundling and edits | 38 | $3,900 | 8% | Partly |
| Medical necessity | 17 | $7,400 | 15% | Partly |
| Timely filing | 9 | $2,600 | 5% | Yes |
| Duplicate | 52 | $2,100 | 4% | Yes, usually noise |
| Missing or invalid information | 21 | $1,300 | 3% | Yes |
| Total | 308 | $49,400 | 100% | Preventable share 77% |
The six numbers for the month: denial rate 7.9% overall, with one payer at 14%; denied dollars led by eligibility; preventable share 77%; days to first action 16; appeal overturn rate 61% overall but 22% on medical necessity; write-offs without appeal $8,900. Read together, they say three things. Eligibility is the biggest preventable bucket, so the front-desk process is the first change. Authorization denials are fewer but expensive, because they sit on procedures, so the tracker for those needs a look next. And the practice is appealing medical necessity denials it mostly loses, which means either the appeals are weak or the ordering pattern does not match the payer's policy. Nobody in this practice knew any of that from the 400-line report.
Building it in a spreadsheet
One tab for the raw denial lines exported from the 835 or the practice management system, one tab for the CARC-to-category map, and one tab for the dashboard, with the six numbers calculated by lookup and pivot. Refresh weekly by appending the new lines. A practice with 3,000 claims a month will have a few hundred denial lines a month, which a spreadsheet handles without complaint. Add a fourth tab, dated, where you write down the process change made each week and the number it was supposed to move. When the practice outgrows this, the categories and the fields transfer to any reporting tool, and you will know exactly what you want it to show.
What the weekly meeting looks like
Fifteen minutes. Denial rate by payer versus last month. Denied dollars by category, and which category moved. One category chosen for a process change this week: a front-desk script, a scrubber edit, a provider conversation about a code. Last week's change reviewed: did the number move? Then the aging list of unworked denials, oldest first, with names next to them. That is the whole agenda. Practices that keep this meeting for three months usually see the preventable share fall and stop needing the meeting to be weekly.
Mistakes that make dashboards useless
Counting contractual adjustments as denials. Letting each poster choose the category, so the same CARC lands in three buckets. Reporting counts instead of dollars, which makes a hundred $12 lab denials look bigger than five $3,000 procedure denials. Tracking denials but not the practice actions that were supposed to reduce them, so nobody knows whether anything worked. Mixing clearinghouse rejections into the denial count, which inflates the eligibility and information categories with claims the payer never saw. And building the dashboard once, for a board meeting, and never refreshing it.
Questions we hear
What denial rate should we aim for?
It depends on specialty and payer mix, and anyone who gives you a single number is guessing. Aim for a falling number with a rising preventable share being worked. In our experience, primary care practices with a solid pre-visit process run well under 5%; procedural specialties with heavy authorization requirements run higher.
Should we track rejections on the same dashboard?
Separately. Clearinghouse rejections never reached the payer and have different causes (format, identifiers, missing fields). Put them on a second tab with their own categories, and watch the resubmission time.
Can our billing company give us this?
They should. Ask for denials by category and by payer, in dollars, monthly at minimum, with the write-offs-without-appeal number. If they cannot, that is a conversation about the relationship. Revelrex denial management clients see these numbers in the client dashboard, and our RCM audit builds the first version of this view from your last 90 days of remittances.
What to do this week
- Export the last 90 days of denied lines from the 835 files or the practice management system with the CARC and RARC codes intact.
- Write the CARC-to-category map on one tab and get the billing lead and the practice manager to sign off on it once.
- Standardize the payer names so each plan appears exactly once.
- Build the six numbers on the dashboard tab and fill in the category table for the most recent month.
- Pick the largest preventable category and write down one process change for next week.
- Put the fifteen-minute meeting on the calendar for the same time every week.
