Revenue Analysis for Medical Practices: How to Diagnose Your Revenue Cycle with Data

Most medical practices have a general sense of their revenue performance: total collections this month, how it compares to last month, whether the checking account is comfortable. What most practices lack is a structured analysis that explains the numbers — that tells you not just how much is coming in, but why, where it's leaking, and what specific changes would improve it.

That's what a proper revenue analysis does. It's not a financial report — it's a diagnostic tool. And like a good diagnostic workup, it asks the right questions in the right order, follows the findings to their source, and identifies the specific intervention each finding requires.

Here's the framework.

The Four Dimensions of Revenue Analysis

A complete practice revenue analysis examines four interconnected dimensions. Each one reveals a different aspect of financial performance, and gaps in any dimension create blind spots.

Dimension 1: Revenue by Source

Break down your collections by payer, by provider (if multi-provider practice), and by service line. This breakdown immediately answers several critical questions:

Payer concentration: What percentage of your revenue comes from your top three payers? Concentration above 50% in a single payer creates vulnerability — a contract dispute, a rate reduction, or a network exit by a single payer can meaningfully impact the practice's finances. Knowing your concentration informs negotiation posture and business development priorities.

Payer performance comparison: Payers don't all reimburse equally for the same services. Comparing reimbursement per visit or per procedure across payers reveals which relationships are most valuable and which may be below market. This analysis is the foundation of contract renegotiation: you can't negotiate effectively without knowing where you stand.

Service line profitability: Not all service lines have equal margins. A detailed revenue-by-service-line analysis may reveal that a specific procedure type consumes significant clinical time for modest reimbursement, while another produces disproportionate revenue relative to time invested. These insights inform scheduling priorities and strategic service development.

Provider performance: In multi-provider practices, revenue and productivity often vary significantly across providers. Analysis by provider reveals who's above and below the practice average, enables targeted coaching conversations, and identifies whether high-performing providers are compensated appropriately relative to their contribution.

Dimension 2: Collection Rates

Net collection rate — what percentage of the net amount due (after contractual adjustments) you actually collect — is the most fundamental measure of billing effectiveness.

Net collection rate = (Payments received) ÷ (Gross charges − Contractual adjustments)

A net collection rate above 96% is strong. Below 93% indicates significant revenue leakage. The question is where the leakage is occurring:

• High contractual adjustments relative to gross charges: Your fee schedule may be too low — you're giving away write-offs that aren't contractually required. Or your coding may be conservative, with charges not reflecting the full value of services rendered.
• Denial-related write-offs: You're writing off revenue to uncollectable denials — claims that were accurate but denied and never successfully appealed.
• Patient balance write-offs: A significant portion of patient responsibility is not being collected, resulting in uncollectable write-off decisions.

Tracking net collection rate separately by payer identifies the payers with the worst collection performance — often a combination of aggressive denial practices and below-market contracted rates.

Dimension 3: Denial and Adjustment Analysis

Every dollar not collected falls into one of three categories: (1) legitimate contractual adjustment, (2) revenue you didn't collect but potentially could have, or (3) revenue you appropriately wrote off. The second category — recoverable revenue — is the one most worth understanding.

Denial rate by category: What percentage of claims are denied, and for what reasons? Tracking denial reasons (eligibility, authorization, coding, timely filing, medical necessity) separately reveals which process failures are costing you the most revenue.

Denial write-off rate: Of the claims denied, what percentage are ultimately written off rather than successfully collected? High denial write-off rates indicate either that appeals are not being pursued aggressively enough, or that the underlying denial reasons are legitimate and the upstream problems need to be addressed.

Contractual adjustment variance: Are your contractual adjustments consistent with your contracted rates? Payers sometimes apply the wrong fee schedule, bundle services they shouldn't, or downcode without authorization. Running a payment reconciliation analysis — comparing what was paid against what the contract specifies — often reveals systematic underpayments that are recoverable through the dispute process.

Dimension 4: A/R Aging

Accounts receivable aging tells you how long it's taking to collect payment after services are rendered — and where payment velocity is breaking down.

Days in A/R: The average number of days between service date and payment. Target under 40 days for most specialties. Days in A/R above 50 is a warning sign; above 65 indicates significant revenue cycle dysfunction.

A/R by aging bucket:

• 0–30 days: Normal processing
• 31–60 days: Follow-up should be underway
• 61–90 days: Active pursuit required
• 90+ days: Priority recovery or write-off decision

A/R over 90 days as a percentage of total A/R: Should be below 15%. Rising over-90 A/R indicates that older claims aren't being worked aggressively enough before they become unrecoverable.

A/R by payer: Payers with disproportionate A/R relative to their share of volume have specific payment velocity problems — slow adjudication, high denial rates, or secondary billing delays.

The Metrics Dashboard

Track these monthly and build a simple trend chart for each:

Metric	Target	Frequency
Days in A/R	< 40	Monthly
A/R over 90 days	< 15% of total	Monthly
Net collection rate	> 96%	Monthly
Clean claim rate	> 95%	Monthly
First-pass denial rate	< 5%	Monthly
Patient balance collection rate	> 60%	Monthly

The trend is as important as the absolute number. A net collection rate of 94% that's been steady for 18 months is different from a 94% rate that was 97% six months ago. The trend tells you whether the revenue cycle is improving, stable, or deteriorating.

Common Findings and What They Mean

Payer-specific high denial rate: Investigate authorization requirements, LCD coverage policies, and billing guideline changes from that payer. Review appeals for patterns in how denials are worded.

Service line with low collection rate: Evaluate coding accuracy for that service line, check for payer-specific coverage limitations, and verify that modifiers are being applied correctly.

Rising days in A/R: Investigate whether clean claim rate has declined (more denials in the pipeline), whether specific payers have slowed payment, or whether the A/R follow-up process has gaps.

Declining patient balance collection rate: Review patient financial communication at check-in, evaluate whether payment plan options are being offered, and consider whether the timing of patient statements is optimal.

Each finding points to a specific intervention. Analysis without action is expensive observation.

Making Revenue Analysis a Monthly Practice

A one-time revenue analysis is a snapshot. The compounding value comes from doing it monthly and trending the data over time. Monthly analysis reveals:

• Whether interventions are working (denial rate fell after implementing eligibility verification — did the reduction persist?)
• Whether new problems are emerging (days in A/R spiking in a specific payer category)
• Seasonal patterns in volume and revenue that inform staffing and cash flow planning

The practices with the most consistently strong financial performance aren't necessarily the ones with the highest charge volumes — they're the ones that understand their revenue cycle data well enough to identify and fix problems before they compound.

---

Want a complete revenue analysis for your practice? Talk to our team — we build comprehensive revenue cycle analyses including payer mix, denial patterns, A/R aging, and collection rate assessment, with specific recommendations for each finding.