Revenue Cycle Analytics

Revenue Cycle Analytics:
Denial Management & Billing Optimization

A 5-provider practice seeing 25 patients each per day, 5 days per week, 50 weeks per year generates 31,250 encounters. If 20% are coded at Level 3 when Level 4 is supported, that is $481,250 in uncaptured revenue — every year.

Find Your Coding Gaps →Schedule RCM Review
$481KAnnual undercoding loss for a typical 5-provider practice
E&M Coding Gap Analysis

Level 3 vs Level 4: A $77 Difference Per Encounter

CPT 99213 (Level 3 established patient office visit) reimburses approximately $158 under Medicare. CPT 99214 (Level 4) reimburses approximately $235 — a $77 difference on a single encounter. The 2021 E&M documentation guidelines eliminated the requirement to count history and physical exam elements, making the Level 4 threshold more achievable for complex chronic disease visits.

Vizier compares your Level 3 to Level 4 coding ratio against specialty-specific national benchmarks. When your 99213 rate significantly exceeds the benchmark, Vizier surfaces a random audit sample of those encounters — with the documentation already pulled — so your coding team can validate in minutes rather than hours.

The same analysis applies to new patient visits (99202–99205), preventive visits (99381–99397), and procedure coding. Undercoding and overcoding risks are both surfaced — protecting revenue and reducing audit exposure simultaneously.

The Undercoding Math — 5-Provider Practice
Encounters/year (5 providers × 25/day × 250 days)31,250
Undercoded at 20%6,250 encounters
Revenue gap per encounter (99214 − 99213)$77
Annual uncaptured revenue$481,250
35–45
Days in AR Benchmark
Commercial insurance
<30
Days in AR Benchmark
Medicare
Denial Management

Root Cause Denial Analysis by Reason Code

Commercial payers deny 7–12% of claims on first submission. Medicaid managed care denial rates run 15–20%. Vizier maps every denial to its reason code, tracks denial rates by payer, provider, and procedure, and surfaces the upstream workflow failure causing each category.

CO-4
Incorrect CPT Code
Procedure code inconsistent with modifier or place of service. Common with split/shared visits and modifier 25 combinations.
CO-97
Duplicate Claim
Claim submitted more than once for same service, date, and beneficiary. Often caused by clearinghouse routing delays or EHR rebilling errors.
PR-204
Service Not Covered
Service is not covered by the patient's plan, not a covered benefit, or requires prior authorization not obtained. High volume in Medicaid managed care.
CO-11
Diagnosis Inconsistent with Procedure
ICD-10 diagnosis code does not support medical necessity for the billed procedure. Requires clinical documentation review before resubmission.
CO-16
Claim Lacks Information
Missing required data elements: NPI, referral number, authorization number, or rendering provider credentials. Fix upstream in the intake workflow.
CO-22
Coordination of Benefits
Another payer may be primary. COB issues are most common in patients with both Medicare and commercial coverage (Medicare Secondary Payer rules).
Commercial InsuranceStable
Denial Rate
7–12%
Days in AR
35–45 days
Medicaid Managed CareIncreasing
Denial Rate
15–20%
Days in AR
45–60 days
Medicare Fee-for-ServiceStable
Denial Rate
3–5%
Days in AR
14–21 days
Medicare AdvantageIncreasing
Denial Rate
8–14%
Days in AR
30–45 days
Payer Performance Benchmarks

Clean Claim Rate Directly Impacts Cash Flow

A clean claim rate below 90% means more than 1 in 10 claims requires rework before payment — adding cost, delay, and write-off risk at every step. Industry top performers maintain clean claim rates above 95%.

Prior authorization denial trends are tracked by procedure code and payer, surfacing which combinations generate the most auth-related denials. Vizier identifies whether your prior auth submission rate matches your order rate — catching the gap before the denial reaches your billing team.

Days in accounts receivable is tracked by payer bucket (0–30, 31–60, 61–90, 90+). Aging above 90 days typically signals either a disputed claim, a payer contracting issue, or a missing authorization — all identified automatically by Vizier.

AR Aging Waterfall

Where the Cash Sits — Aging Buckets and Collection Probability

AR aging tells you which dollars are still recoverable and which are headed for write-off. Collection probability collapses sharply after 90 days, then again at 120 and 180 — and those are the buckets that move net collection rate.

Illustrative — $5M Outstanding AR at a 50-Provider Group
0–30 days
Active claim cycle. Most clean claims pay within this window. Healthy organizations carry the largest concentration of AR here.
$1,950,000
39.0% of AR
98%
Collection
31–60 days
First-touch denial rework window. Most CARC-flagged claims should resubmit successfully here. Above 25% of total AR signals upstream first-pass denial issues.
$1,100,000
22.0% of AR
92%
Collection
61–90 days
Second-touch rework — appeals, additional documentation, payer escalation. Anything still here usually has a specific cause; the worklist should not be FIFO.
$750,000
15.0% of AR
82%
Collection
91–120 days
Recovery probability drops sharply. Past 90 days is the industry concern threshold — benchmark is to keep over-90 AR below 15–20% of total.
$525,000
10.5% of AR
62%
Collection
121–180 days
Most commercial timely-filing windows expire in this range. Recovery requires escalation to payer reps; many practices outsource this bucket to specialty collection vendors.
$385,000
7.7% of AR
38%
Collection
180+ days
Write-off zone. Recovery is unlikely without litigation or third-party collection. The dollar value here is the proxy for systemic upstream failure.
$290,000
5.8% of AR
12%
Collection
AR over 90 days (combined)
$1,200,000 — 24% of total AR
Above the 15–20% benchmark. Vizier prioritises the over-90 bucket by CARC root cause and payer — so the rework team works the recoverable dollars first, not the oldest claims regardless of cause.
How Your Data Gets In

How revenue cycle data gets into Vizier

Direct connectors to your EHR or PM system, scheduled CSV/SFTP from your clearinghouse, or upload claim and ERA files directly.

01 · DIRECT CONNECTOR (RECOMMENDED)
FHIR R4 or HL7 v2, read-only

Connect Vizier directly to your EHR via FHIR R4 or HL7 v2 and pull Claim, ClaimResponse, Account, ChargeItem, Coverage, ExplanationOfBenefit resources for denial root-cause analysis, payer scorecards, and AR aging on a schedule or on demand. Live for Epic, Cerner / Oracle Health, AthenaHealth, Allscripts / Veradigm, MEDITECH, SystmOne, EMIS, NextGen, eClinicalWorks. OAuth 2.0 / SMART on FHIR, read-only, BAA executed before any PHI flows.

02 · SCHEDULED FEED
Your reports on a cron

Your existing reporting environment writes CSV to SFTP or secure cloud storage. Vizier picks it up. Most common path for organizations with internal data warehouses or restricted external API access.

03 · UPLOAD
Drag-and-drop CSV / Excel

When you need the answer this hour. Ad-hoc analysis, data outside your EHR (payer files, registry exports, survey data), or proof-of-value before IT approves a connector.

See all EHR connectors →How integration works →

FAQ

Revenue Cycle Analytics — Common Practice and Health-System Questions

Which CARC and RARC denial codes does Vizier track?+

All standard CARCs and RARCs published by X12 / WPC. The dashboard surfaces the top five CARCs accounting for the most denied dollars year-to-date — typically CARC 197 (precertification absent), CARC 16 (claim/service lacks information), CARC 18 (duplicate), CARC 109 (coverage mismatch), and CARC 50 (medical necessity). Week-over-week change by payer flags policy or workflow shifts before they compound.

How does the E&M coding analysis compare to my billing service?+

Vizier benchmarks each provider's distribution of 99212 / 99213 / 99214 / 99215 against CMS national distribution for that specialty. Outliers in either direction get flagged: heavy 99213 with low 99214 typically signals systematic undercoding (documentation supports more than what's billed); heavy 99214 / 99215 without supporting documentation creates audit exposure. Most billing services don't run this analysis automatically.

Can Vizier ingest claims data from a clearinghouse instead of the EHR?+

Yes. If your clearinghouse (Change Healthcare, Availity, Waystar, Trizetto) writes a scheduled CSV or 837/835 feed to SFTP, Vizier picks it up. Most health systems use a hybrid: EHR connector for clinical context and claims, clearinghouse feed for ERA / 835 detail.

Does Vizier support both professional (HB) and institutional (PB) billing?+

Yes. Both fee tickets and claim lines are normalized into the same dataset, so a CFO can see consolidated revenue cycle metrics or filter to PB or HB independently. Multi-entity health systems with separate physician group and hospital billing platforms can connect both.

How quickly does the revenue cycle workflow surface a new denial trend?+

Daily. Vizier checks denial counts by CARC and payer every refresh — direct connector pulls run hourly to daily. A new payer policy that begins generating denials October 1 surfaces within days, not at month-end close.

Is the analytics layer audit-defensible?+

Yes. Every analytics view is rendered from raw claims data with the underlying source rows accessible. Coding pattern flags are diagnostic, not directive — Vizier surfaces candidates for review and never auto-codes or auto-bills. The audit log captures every query and result.

Revenue Cycle Analytics

See What Your Practice Is Leaving on the Table

Upload your billing data and see your E&M distribution vs. national benchmarks, denial rates by payer and reason code, and the exact dollar amount recoverable with targeted workflow corrections.