A CFO revenue cycle dashboard should track eight metrics: net days in A/R, aged A/R over 90 days, clean claim rate, initial denial rate, discharged-not-final-billed (DNFB) days, cash collections as a percentage of net revenue, patient payment collections at or before service, and cost to collect. Together they cover speed, quality, and cost. Show each as a 13-month trend, not a single number, and segment by payer and facility.
Revenue cycle teams can track well over a hundred metrics. CFOs do not need all of them. They need a short, trusted view that shows whether cash is arriving on time, whether claims are clean, and whether the cost of getting paid is under control. For a deeper look at metrics across the full cycle, see RCR|HUB's Complete Guide to Revenue Cycle Management Metrics. This article focuses on the eight that belong on one page.
Targets below are commonly cited industry ranges, not HFMA standards, and they vary with payer mix, service lines, and facility type. Some formulas are simplified for a dashboard view. Where a KPI has a related HFMA MAP Key, we note the MAP Key definition, but not all eight are MAP Keys. Benchmark against your own trend and against frameworks such as HFMA's MAP Keys, using matching definitions.
1. Net Days in Accounts Receivable
What it tells you: How long it takes to turn services into cash.
How to calculate: Net A/R divided by average daily net patient service revenue. HFMA's MAP Key uses the daily average from the most recent three months.
Watch for: A slow upward drift. It often shows up months before cash drops.
Target: A commonly cited industry target is the 40s, depending on payer mix. This is not an HFMA MAP Key standard.
2. Aged A/R Over 90 Days (% of Total A/R)
What it tells you: How much of your A/R is at risk of never being collected.
How to calculate: A/R older than 90 days divided by total A/R. HFMA's MAP Keys split aging into 91–120 days and more than 120 days, and separate total billed A/R from total A/R, so state which denominator you use.
Watch for: A rising share, especially concentrated in one payer or facility.
Target: Set an internal ceiling and review it monthly. Old balances lose value quickly.
3. Clean Claim Rate (First-Pass Rate)
What it tells you: How many claims go out right the first time.
How to calculate: Claims that pass all edits with no manual intervention divided by claims accepted into the claims processing tool for billing, before submission. This follows the HFMA MAP Key definition. It measures claims before they reach the payer, not payer acceptance.
Watch for: Drops after system changes, new payer rules, or staffing changes.
Target: A commonly cited industry target is 95 percent or higher.
4. Initial Denial Rate
What it tells you: How often payers push back on the first submission.
How to calculate: Denied claims divided by total claims, tracked by count and by dollars. This is a simplified operational view. HFMA's related MAP Key is the Remittance Denial Rate, which divides denied claims by total claims remitted and has specific inclusions and exclusions.
Watch for: Concentration by payer, denial reason, or service line. Track the final write-off rate too, so you can see how much is never recovered.
Target: A commonly cited goal is single digits, though results vary widely.
5. Discharged, Not Final Billed (DNFB) Days
What it tells you: How long finished cases sit unbilled, which delays cash.
How to calculate: Gross dollars in discharged-not-final-billed accounts divided by average daily gross patient service revenue, following the HFMA MAP Key method.
Watch for: Coding backlogs, documentation holds, and missing authorizations.
Target: Most organizations aim for a low number of days and treat sustained increases as an alert.
6. Cash Collections as a Percentage of Net Revenue
What it tells you: Whether you are collecting what you earn.
How to calculate: Total patient service cash collected divided by average monthly net patient service revenue. HFMA's MAP Key bases the denominator on the most recent three-month average.
Watch for: A persistent gap, which points to leakage from denials, underpayments, or write-offs.
Target: Close to 100 percent over time.
7. Patient Payment Collections at or Before Service
What it tells you: How well the front end collects patient responsibility.
How to calculate: Patient payments collected at or before service divided by estimated patient responsibility. This is an operational KPI, not an HFMA MAP Key. HFMA's related Patient POS Payments metric divides point-of-service patient payments by total self-pay cash collected.
Watch for: Facility-level differences, and whether estimates are accurate. See Patient Cost Estimator Tools: What They Do and Who Provides Them.
Target: No universal benchmark. Track the trend by location and improve it steadily.
8. Cost to Collect
What it tells you: How efficiently the revenue cycle operates.
How to calculate: Total revenue cycle operating cost divided by total cash collected. Define cost the same way every period. HFMA's definition includes a broad set of Patient Access, Patient Accounting, HIM, IT, transaction, legal, collection, and other revenue cycle expenses.
Watch for: Costs that fall while denials or A/R rise. Cutting cost too far can reduce cash.
Target: A commonly cited range for hospitals is the low-to-mid single digits, but results vary widely by organization and by which costs are included. Compare against similar organizations using the same definition.
Designing the Dashboard
One page. If it needs scrolling, it is not a CFO view.
13-month trends. They show seasonality and direction.
Red, amber, green thresholds set in advance, with an owner named for each metric.
Segment by payer, facility, and service line. Averages hide problems.
Pair speed and quality. Days in A/R with clean claim rate, for example, shows whether faster billing is also accurate billing.
Mix leading and lagging indicators. Clean claim rate and DNFB warn early. Cash collections confirm the result.
Where the Data and Help Come From
If your reporting is manual or inconsistent, consider revenue cycle data analytics and performance measurement partners. If the KPIs reveal deeper problems, a revenue cycle assessment can help find the cause. Browse all categories in the RCR|HUB directory, where Business Partners are listed by function. Business Partners can subscribe to RCR|HUB's RFP Access Network for access to researched, live RFP opportunities and the hospital and healthcare organization directory.
Frequently Asked Questions
-
Review the dashboard monthly, with weekly operational views for revenue cycle leaders on DNFB, denials, and clean claim rate.
-
Check that your definitions match. Then compare against your own history and similar organizations before acting.
-
No single one. Net days in A/R and cash as a percentage of net revenue show the result, while clean claim rate and denial rate explain why.
-
Yes, with different targets. Add patient-pay and payer-mix views for ambulatory settings.