Revenue Cycle Management KPIs / Board Playbook
Read the waterfall first. The 38 KPIs explain what it shows.
A cohort collections waterfall is the single view that ties every revenue cycle management KPI back to cash. Line up each service-date cohort against the deposit dates that paid it, and two numbers fall out for free: the column-sums equal the cash you actually banked, and the open-cohort balances equal your accounts receivable. Everything else on the board, from net collection rate to days in AR, is a lens on that same grid.
The methodology
The cohort waterfall, in three reads of one matrix
Group every claim by its month of service (the cohort, or vintage). Across the top, lay out the deposit months in which cash landed: M0 is the month of service, M1 the next month, and so on. Each cell is the dollars collected for that cohort in that deposit month. Read it three ways: raw dollars, the independent percent collected that month, and the cumulative percent of expected net revenue recovered to date.
| Cohort (DOS) | M0 | M1 | M2 | M3 | M4+ | Open / AR | Expected |
|---|---|---|---|---|---|---|---|
| Apr | $0.44M | $1.18M | $0.67M | $0.29M | $0.18M | $0.14M | $2.90M |
| May | $0.41M | $1.20M | $0.66M | $0.33M | $0.12M | $0.35M | $3.07M |
| Jun | $0.45M | $1.19M | $0.60M | $0.15M | — | $0.76M | $3.15M |
| Cash by deposit | $1.30M | $3.57M | $1.93M | $0.77M | $0.30M | $1.25M | $9.12M |
Illustrative sample data for a generic multi-specialty RCM book of business. Not a client's actuals. Figures are labeled benchmarks for teaching the method only.
Velocity
Velocity bands: how fast a cohort clears
Cumulative percent by cohort age sorts your book into velocity bands. A newer cohort sitting in a slow band is an early warning the front end broke, months before it shows up as aged AR. Bands below are illustrative benchmarks, not a promise of results.
Fast
Cumulative collected by end of M2. Clean claims, verified eligibility, low denial drag.
Standard
Cleared by M3. Normal payer float plus a manageable appeal tail.
Slow
Still open at M4. Usually auth, coverage, or coding rework upstream.
At risk
Structural leak: registration, contracting, or a payer edit nobody is working.
The measurement framework
The 38 KPIs, each with a formula, a standard, and a target
Every KPI below maps to the HFMA MAP Keys and to HBMA best-practice definitions, so the board is reading against a real standard, not a house metric. Note the two bases for days in AR (gross charges and net revenue), net collection rate as the ceiling on how much of the contractually allowed amount you actually keep, clean-claim and first-pass rate as the front-end health check, and cost to collect as the efficiency backstop. Targets are illustrative benchmarks.
Clean claim rate
- Formula
- Claims passing all edits first submission / total claims
- Standard
- HFMA MAP: first-pass clean
- Target
- 95%+
First-pass resolution rate
- Formula
- Claims paid on first submission / total submitted
- Standard
- HBMA FPRR
- Target
- 90%+
Point-of-service cash rate
- Formula
- POS collections / total patient cash
- Standard
- HFMA MAP: POS cash
- Target
- ≥30%
Insurance verification rate
- Formula
- Encounters with verified eligibility / total encounters
- Standard
- Access best practice
- Target
- 98%+
Prior-auth secured rate
- Formula
- Auth-required services with valid auth / total requiring auth
- Standard
- Auth denial prevention
- Target
- 98%+
Registration accuracy
- Formula
- Error-free registrations / total registrations
- Standard
- HFMA access
- Target
- 98%+
Patient-access denial rate
- Formula
- Access-caused denials / total claims
- Standard
- HFMA MAP
- Target
- <2%
Patient estimate accuracy
- Formula
- Estimates within tolerance / estimates issued
- Standard
- Price transparency
- Target
- 90%+
Charge lag (days)
- Formula
- Avg days from service to charge entry
- Standard
- HBMA charge capture
- Target
- ≤2 days
Charge capture accuracy
- Formula
- Correctly captured charges / expected charges
- Standard
- Mid-cycle integrity
- Target
- 99%+
Coding accuracy
- Formula
- Correctly coded lines / audited lines
- Standard
- HBMA / AHIMA audit
- Target
- 95%+
DNFB days
- Formula
- Discharged-not-final-billed $ / avg daily net revenue
- Standard
- HFMA MAP
- Target
- ≤4 days
Late charge rate
- Formula
- Charges posted after bill drop / total charges
- Standard
- Charge integrity
- Target
- <2%
Coder productivity
- Formula
- Charts coded / coder / day at quality
- Standard
- Specialty benchmark
- Target
- band by specialty
Coding query rate
- Formula
- Charts requiring provider query / total charts
- Standard
- CDI benchmark
- Target
- <10%
Days in AR (gross)
- Formula
- Total AR / (gross charges / days)
- Standard
- HFMA MAP: AR days
- Target
- ≤45 days
Days in AR (net)
- Formula
- Total AR / (net revenue / days)
- Standard
- HFMA MAP: net basis
- Target
- ≤35 days
AR over 90 days %
- Formula
- AR aged >90d / total AR
- Standard
- HFMA MAP aging
- Target
- <15%
AR over 120 days %
- Formula
- AR aged >120d / total AR
- Standard
- HFMA MAP aging
- Target
- <10%
Net collection rate
- Formula
- Payments / (charges − contractual adjustments)
- Standard
- HFMA / HBMA NCR
- Target
- 96%+
Gross collection rate
- Formula
- Payments / gross charges
- Standard
- HBMA (payer-mix dependent)
- Target
- context
Cash as % of net revenue
- Formula
- Cash collected / net patient service revenue
- Standard
- HFMA MAP
- Target
- ≥100%*
Bad debt rate
- Formula
- Bad debt write-offs / net revenue
- Standard
- HFMA MAP
- Target
- <3%
Credit balance days
- Formula
- Credit balance $ / avg daily net revenue
- Standard
- HFMA MAP
- Target
- ≤2 days
Aged AR by payer
- Formula
- AR aging distribution segmented by payer
- Standard
- HFMA payer view
- Target
- no outlier payer
Initial denial rate
- Formula
- Denied claims / total claims submitted
- Standard
- HFMA MAP: denials
- Target
- <5%
Denial write-off rate
- Formula
- Denial-caused write-offs / net revenue
- Standard
- HFMA MAP
- Target
- <2%
Denials overturned on appeal
- Formula
- Appeals won $ / appealed $
- Standard
- HBMA appeal yield
- Target
- 65%+
Denial appeal rate
- Formula
- Denials appealed / appealable denials
- Standard
- Work-rate discipline
- Target
- 90%+
Days to appeal
- Formula
- Avg days denial to appeal filed
- Standard
- Timely-filing guard
- Target
- ≤7 days
Denials as % of charges
- Formula
- Denied charge $ / total charge $
- Standard
- HFMA MAP
- Target
- <5%
Underpayment recovery rate
- Formula
- Recovered underpayments / identified underpayments
- Standard
- Contract yield
- Target
- 85%+
Cost to collect
- Formula
- Total RCM cost / total cash collected
- Standard
- HFMA MAP: cost to collect
- Target
- ≤4%
Cost to collect per FTE
- Formula
- Cash collected / RCM FTE
- Standard
- Productivity benchmark
- Target
- band
Net days in credit balance
- Formula
- Net credit balance / avg daily net revenue
- Standard
- HFMA MAP
- Target
- ≤1.5 days
Cash as % of net patient revenue
- Formula
- Cash / NPSR (rolling 3-mo)
- Standard
- HFMA MAP
- Target
- ≥99%
Contractual variance rate
- Formula
- |Expected − posted allowed| / expected
- Standard
- Contract modeling
- Target
- <2%
Discharge-to-payment cycle
- Formula
- Avg days discharge to full payment
- Standard
- End-to-end velocity
- Target
- ≤40 days
*Cash as a percent of net revenue can read above 100% when prior-period AR is converting faster than current-period revenue accrues. Targets shown are illustrative industry benchmarks, not guaranteed outcomes.
Denial suite
Four views that turn denials into prevention
A denial rate on its own is a scoreboard, not a plan. Read it four ways: the trend tells you if it is moving, by-reason tells you what to fix, by-payer tells you where, and the prevention taxonomy tells you which team owns the fix. Denials are cheapest to solve before the claim ever leaves.
Denial rate trend
6-month, illustrative
By reason
By payer
Prevention taxonomy
- ACCESSEligibility and benefit checks at scheduling kill the largest denial class before a claim exists.
- AUTHAuth secured and matched to the ordered service, not just requested. Owns the second-largest class.
- CODINGBundling and edit checks pre-bill. This is where accuracy above 95% keeps rework off the board.
- SUBMITClearinghouse edits and payer-specific rules catch missing-info denials at first pass.
- FOLLOW-UPTimely-filing clock managed by cohort age so no dollar dies in the Open column.
Where ASP-RCM Solutions fits
We build the waterfall, then we work the Open column
The methodology on this page is exactly how our teams read a multi-specialty book: reconcile the columns to cash, reconcile the Open cohorts to AR, sort by velocity band, then attack the reasons behind the slow bands with the denial taxonomy. Our coding runs at 95% or higher accuracy, so the pre-bill edits actually prevent denials instead of generating appeals. You get a board deck where every one of the 38 KPIs traces back to a dollar you can see.
Read your waterfall with us →Frameworks referenced: HFMA MAP Keys (Healthcare Financial Management Association); HBMA (Healthcare Business Management Association) best-practice metric definitions; net collection rate; days in AR on gross and net bases; clean-claim / first-pass resolution rate; denial rate; cost to collect; cohort / vintage collections methodology. All dollar figures, percentages, and targets on this page are clearly-labeled illustrative benchmarks for a generic multi-specialty RCM book of business and do not represent any client's actual results.