Home / Services / Healthcare Revenue Cycle Management / RCM Diagnostic Data Checklist

Preparation Guide

Revenue Cycle Diagnostic Data Checklist: What to Gather Before an RCM Review

A healthcare revenue cycle review is only as useful as the data behind it. This guide identifies the specific reports, metrics, and records that CFOs, RCM leaders, and practice administrators should assemble before engaging any reviewer — so the review focuses on root causes and measurable opportunities rather than data gathering.

Denial analysis Aging AR review Charge capture
Analyzing Medical Coding Audit Reports On Doctor's Office Computer

Guide Contents

Data checklist covering patient access, charge capture, coding, claims, denials, AR, payment posting, and reconciliation — plus the diagnostic flow to connect them

Who This Guide Is For

This guide is for healthcare CFOs, revenue cycle directors, practice administrators, and RCM leaders at provider organizations — including hospital-affiliated groups, independent practices, and specialty clinics — who are preparing for a revenue cycle diagnostic review. It is also relevant for private-equity operating partners and healthcare consultants who support portfolio companies or clients through RCM evaluations.

1. Common Business Triggers

  • Days in AR have increased by more than five days over two consecutive quarters
  • Denial rates have climbed above industry benchmarks for the organization's specialty mix
  • A new provider group has been added and revenue has not grown proportionally
  • Leadership cannot explain why net collection rates vary significantly across payers or service lines
  • Billing staff turnover has created institutional knowledge gaps
  • A merger or acquisition has combined two revenue cycle operations with different systems and workflows
  • The organization is preparing for a transaction and needs to demonstrate normalized revenue cycle performance

2. Warning Signs Leadership Should Recognize

  • No centralized denial-tracking log. If denials are managed by individual billers without aggregation, root-cause analysis is nearly impossible.
  • Aging AR dominated by small balances. A high volume of small-dollar aged balances often indicates systematic underpayment or write-off policy problems.
  • Charge-capture gaps between clinical documentation and claims. If providers document services not appearing on claims, revenue is being left with each billing cycle.
  • Credentialing tracked informally. Spreadsheet-based credentialing that is not updated in real time creates silent payment delays when providers see patients before payer enrollment is complete.
  • Payment-posting backlog exceeding five business days. Delayed posting makes AR aging unreliable and masks collection problems.

3. The Revenue Cycle Diagnostic Flow

A complete RCM review follows the patient and claim lifecycle end to end. The diagram below shows each stage, along with the key data or report required at that point.

Illustrative Framework

Stage Revenue Cycle Stage Key Data or Report Required
1 Patient Access / Registration Registration error rate report; eligibility verification rate; demographic completeness score; prior-auth capture rate by payer
2 Charge Capture Charge-lag report by provider and service line; comparison of clinical documentation volume to claim volume; missing-charge reconciliation log
3 Coding Coding accuracy audit results; modifier usage report; diagnosis-code distribution by provider; coding turnaround time by coder
4 Claim Submission Clean-claim rate by payer; first-pass acceptance rate; claim rejection breakdown by reason code; time from coding complete to claim submission
5 Denials Management Denial rate by payer and reason category; denial write-off rate; appeal success rate; denial turnaround time; top-10 denial reasons with dollar impact
6 AR Follow-Up Aging AR by payer class (0–30, 31–60, 61–90, 91–120, 120+); AR days trend over 12 months; collection rate by aging bucket; percentage of AR > 90 days
7 Payment Posting Payment-posting backlog (days); unexplained payment variance report; contractual adjustment accuracy audit; recoupment and offset tracking
8 Reconciliation Monthly reconciliation of payments posted to deposits; payer-mix revenue trend; net collection rate by provider and payer; write-off analysis by category

Illustrative framework — specific reports and metrics will vary by organization size, specialty, system configuration, and payer mix.

4. Data Checklist by Revenue Cycle Stage

In addition to the stage-specific reports above, assemble the following cross-cutting data before any RCM review:

  • Twelve months of charge and payment data by provider, by payer, by service location
  • Current fee schedule for each major payer and a copy of the most recent payer contract amendments
  • Provider roster with credentialing status, payer enrollment dates, and recredentialing deadlines for each provider
  • Current billing and coding staff roster with tenure, certification status, and workload allocation
  • List of all systems in the revenue cycle workflow and whether they are integrated or require manual data transfer
  • Twelve months of write-off detail segmented by reason category (contractual, administrative, bad debt, charity)
  • Patient-payment policy and current patient-collection rate
  • Any recent external audit reports, payer scorecards, or RCM vendor performance reviews

5. How to Prioritize Findings

Once the diagnostic data is assembled, leadership should rank issues by three criteria:

  • Dollar impact. Which issues represent the largest recoverable or preventable revenue loss?
  • Fix timeline. Can the root cause be addressed in weeks (e.g., a payer configuration error) or will it require months (e.g., a system migration)?
  • Recurrence risk. Is this a one-time problem or a systemic issue that will continue to generate losses until the root cause is addressed?

Prioritize issues that score high on all three dimensions. Issues with high dollar impact but long fix timelines should be started immediately. Issues with low dollar impact but high recurrence risk should be addressed before they compound.

6. Common Preparation Mistakes

  • Reviewing only billed claims without examining what was never billed. The largest revenue loss often hides in services that were documented but never converted to a claim.
  • Aggregating denial data without categorizing by root cause. A 12% denial rate is unhelpful until you know whether the primary driver is registration errors, coding, medical necessity, or authorization.
  • Excluding small-dollar write-offs from analysis. Small underpayments that recur across thousands of claims can exceed the dollar impact of a few large denied claims.
  • Reviewing credentialing only for employed physicians. Locum tenens, part-time, and contracted providers often have credentialing gaps that delay payment.
  • Neglecting patient-payment performance. Rising patient responsibility means that front-end collections and patient-payment workflows now materially affect net revenue.

7. When a Review Is Likely Relevant — and When It May Not Be

Likely relevant when: AR days are rising, denial rates are above specialty benchmarks, collections have not kept pace with provider growth, credentialing delays are creating payment gaps, or the organization is preparing for a transaction.

May not be the highest priority when: The organization has recently completed an external RCM review within the last 12 months, is in the middle of an EHR migration, or has had stable KPIs across multiple quarters and the primary concern is cost reduction in non-revenue areas.

8. What Blackspire Evaluates — and What We Do Not Claim

Blackspire evaluates: denial patterns, AR aging trends, charge-capture completeness, coding accuracy, credentialing status, payment-posting timeliness, payer-contract compliance, and the end-to-end workflow from patient access through reconciliation.

Blackspire does not claim or guarantee: specific collection-rate improvements, specific denial-rate reductions, that any particular claim will be paid, or that identified issues will result in recoverable revenue. Blackspire does not provide medical coding, legal advice, payer-contract negotiation, or clinical documentation improvement services. All findings require validation by qualified revenue cycle professionals and may require payer-specific follow-up.

9. Practical Next Steps

  1. Map your revenue cycle. Identify every system, handoff, and manual step from patient access to reconciliation.
  2. Pull the stage-specific reports. Use the checklist above to gather data from each stage of the cycle.
  3. Identify the largest variance. Where does your organization's performance deviate most from specialty and payer-class benchmarks?
  4. Schedule a confidential RCM diagnostic. If you want an independent, senior-led evaluation of your revenue cycle before engaging vendors, learn more about the Healthcare Revenue Cycle Management review or request a consultation.

10. Frequently Asked Questions

Healthcare Revenue Cycle Management

If your revenue cycle data is raising questions you cannot answer internally, Blackspire's senior-led RCM diagnostic can help you identify where revenue is leaking and what to address first.