What a clean denial report looks like

If your billing partner cannot show a denial report you can audit, you do not have denial management — you have claim submission with a monthly story. This post describes the shape of a clean report: columns, CARC rollups, work status, and export hygiene. For the operational ownership frame, read Who owns denials.

ClinicBilling USA is editorial only. We do not rank vendors or host a marketplace.

Why “denial rate: 4%” is not a report

A single percentage answers one question: roughly how often claims fail. It does not answer:

Which reasons drive dollars
Whether anyone worked those denials
How old the open ones are
Whether write-offs were approved or silent

Sales decks love the single number. Operators need a table.

Minimum viable columns

A clean monthly denial extract (CSV or Excel) should let a practice manager filter without calling the vendor. Minimum fields:

Column	Purpose
Claim ID / internal ID	Join back to PM system
Patient account (or tokenized ID)	Internal research
Payer	Mix and plan-level patterns
Date of service	Timely filing context
Date denied / remit date	Aging start
CARC (code)	Standard reason
CARC short label	Human scan
Denied / adjusted amount	Dollar weight
Work status	New / in progress / appealed / corrected / written off / closed paid
Owner	Named queue or person
Last action date	SLA evidence
Next action / note code	Not a novel — a code + optional free text
Write-off flag + approver	Governance

If the only artifact is a PDF pie chart of “top denial reasons,” you cannot reconcile to remits.

CARC, not home-grown labels alone

Claim Adjustment Reason Codes travel on the 835 remittance advice. The maintained list is available via X12 Claim Adjustment Reason Codes (as of 2026-07-21). CMS provides administrative simplification context for standard transactions and code sets (CMS code sets, as of 2026-07-21).

Report CARC number + short name. Do not rely only on vendor-invented categories like “eligibility-ish” that cannot be mapped to remits. Secondary group codes and remark codes can add detail; start with CARC discipline first.

Educational examples (confirm current wording on the official list; we do not paste long AMA/CPT descriptor text here):

16 — information missing → front-end data quality
18 — duplicate → workflow discipline
29 — timely filing → process clocks
50 / 96 — non-covered patterns → benefits and medical necessity conversations
197 — authorization → prior-auth ownership

A clean report rolls up by CARC for the executive view and still offers the claim-level extract for audit.

Aging and work status on the same page

Pair reason with age:

0–30 / 31–60 / 61–90 / 90+ open denial dollars
Average days from denial to first action
Count of denials with no action in SLA window

Without aging, a vendor can “manage” denials by letting 90+ sit until write-off day.

First-pass vs worked appeals (two charts, not one)

A clean pack separates:

Rejects / scrub failures before payer adjudication
Payer denials after adjudication
Appeals filed / overturned / upheld

Conflating them inflates “success” when the team only fixes easy eligibility typos and abandons medical-necessity fights.

Reconciliation: the test that ends arguments

Once a quarter (or monthly if volume is high):

Pull 25 random denied remits from the clearinghouse or payer portal.
Find each on the vendor denial log.
Confirm CARC, amount, and current status match.
Score match rate. Below a high bar (define with your team) triggers a corrective action plan in the account review.

If the vendor refuses sample reconciliation, treat reporting as decorative.

Metric companions (define formulas)

Denial reports should sit next to:

Days in A/R with stated formula
Net collection rate with stated numerator/denominator and lag
Write-offs split contractual vs discretionary

HFMA and related RCM education materials discuss KPI framing for finance leaders (HFMA, as of 2026-07-21). Steal the discipline of defined formulas; do not outsource belief to a dashboard theme.

Patient-balance cost context: rcm.today.

What to attach to the contract

Make the report pack an exhibit:

File format and delivery day
Column list
CARC requirement
Retention of historical files after exit (Contract terms)

Example monthly narrative (what “good” sounds like)

A useful account review does not start with “we are crushing it.” It starts with:

Top five CARCs by dollars this month vs last month.
Open denial inventory by age bucket with owners.
Actions completed: corrections, appeals filed, overturns, approved write-offs.
Practice-side root causes needing clinical or front-desk change (eligibility, auth, documentation).
Risks: timely filing clocks, understaffed queues, payer outages.

If the meeting is only a collection-rate slide and a request to expand scope, you are in a sales renewal, not an operations review.

Common junk reports (and how to reject them)

Artifact	Why it fails
PDF pie of “eligibility / coding / other”	Not mappable to remits
Screenshot of vendor portal	Not archival; not joinable
”Top denials” without dollars	Count ≠ cash impact
Status = “working” for 90 days	No aging discipline
Excel with merged cells and colors only	Breaks automation and audit

Reject junk politely: “Please resend as the exhibit CSV with CARC and work status.” Put that sentence in the contract exhibit so it is not a personality contest.

How this feeds fee and make-vs-buy decisions

Denial visibility changes the fee conversation (Fee structures). If most dollars sit in authorization and medical-necessity CARCs that the vendor will not work, a low percentage is not a bargain. If in-house staff already produce a clean extract and the gap is pure capacity, outsourcing may help — or hiring might (In-house vs outsourced).

Patient residual collections still deserve a separate cost lens on rcm.today.

This post was drafted by AI and reviewed by our editorial team. Last updated 2026-07-21.