Medical Revenue Cycle Metrics Template
Four documents and four sheets, every metric computed per payer, because the practice-wide average hides the payer dragging it.
Free download · No account needed
Clean Claim Rate
One row per payer, not one number for the practice
Every metric in this pack is computed per payer and carries its own denominator on the row. The three rejection columns are what the single rate hides.
| Payer | Period | Claims submitted | Adjudicated first pass | Clean claim rate | Rejected at clearinghouse | Rejected pre-adjudication | Denied first pass | Prior period | Movement | Outside noise band |
|---|---|---|---|---|---|---|---|---|---|---|
The definition this sheet holds itself to
Clean claim rate is claims adjudicated on first pass with no edit, no rejection and no denial, over claims submitted. Three separate failure modes sit in the denominator, and a rate that rises because one of them was reclassified has not improved.
Why the noise band column exists
A metric that moves every month is a metric nobody acts on. The band is set once per metric in the definitions document, and only a movement outside it goes on the review agenda. Everything inside it is recorded and left alone.
The other three sheets
Days in AR, denial rate by payer with cash at risk, and net collection rate, each per payer and each carrying its own denominator. Four metrics is the whole dashboard. A fifth is usually a metric somebody wanted rather than a decision somebody makes.
A practice-wide clean claim rate of 88.7 percent and 33.2 days in AR is a pair of unremarkable numbers. Computed per payer, the same quarter contains a payer at 82.7 percent and 44.5 days, and that payer is a quarter of the charges. So every metric in this pack carries a payer on the row and its own denominator beside it. An aggregate is an average of four different relationships, and the averaging is what hides the one relationship that has moved. Ranking the payers is what makes the numbers arguable instead of merely reported.
Two of the four metrics lead and two lag. Clean claim rate and denial rate by payer are measurable the week a claim goes out, and they set what the next quarter's cash will be. Net collection rate tells you what happened, months later, and it is provisional until runout closes. So the sheets state months of runout on the row and compare against a like-aged prior period, rather than against the most recent closed quarter.
Then one derived column turns the leading pair into money: cash at risk, which is denied charge times one minus that payer's own appeal recovery rate. At Bellhaven Family Health, Summit Advantage is 26.3 percent of charges and 64.4 percent of the 59,375 at risk, because it denies at 12.9 percent and overturns 38 percent of appeals. Which denial categories to work is denial root cause analysis.
What's in the pack
Metric Definitions
The numerator and denominator of each of the four metrics, written down, plus the noise band that decides whether a movement reaches the agenda or is recorded and left alone.
How Clean Claim Rate Predicts Days in AR
The one relationship that makes the dashboard worth building, the two payers that swap rank and why that is informative, and the three separate actions a finding can license.
Clean Claim Rate
Per payer, with clearinghouse rejections, pre-adjudication rejections and first-pass denials kept in separate columns so a rate cannot improve by reclassifying one of them.
Days in AR
Ending AR over average daily charge on a trailing 90 day base, per payer, with the daily charge shown so a small payer's number is readable as the small denominator it is.
Denial Rate by Payer
Per line rather than per claim, with the largest reason and remark code pair, the practice's own appeal recovery rate, and cash at risk derived from the two.
Net Collection Rate
Payments over net charges after contractual adjustments, marked provisional, with runout months on the row and a like-aged prior period as the comparison.
Review Cadence and Escalation Basis Note
A monthly agenda that reads only the rows outside their band, and the rule that an escalation needs a written obligation behind it rather than a metric.
Handoffs from a finding to the work
A payer paying late on clean claims goes to the AR and collections pack. A payer paying the wrong amount goes to the underpayment recovery pack.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent compute the four metrics from your claims and remittance exports, or download the blank Word and CSV files instantly and fill them in.
- 2
Fix the definitions before computing anything
Especially what counts as clean and what counts as a denied line. A metric whose denominator is not written down will be quietly redefined the first month it looks bad.
- 3
Compute all four per payer, then rank
Ranking is what makes the numbers arguable. Put each payer's share of charges beside its rank so a bad rate on two percent of the charges is read as what it is.
- 4
Read only the rows outside their band
Then decide which of three things the row licenses: a submission fix, a payer escalation, or a contract conversation. Those are different actions and the metrics distinguish them.
Frequently asked questions
Is this template free?
Yes. The four documents and four sheets download as Word and CSV files with no signup and no card. "Edit with AI" is the optional path for practices that want the four metrics computed from their own exports. The rest of the library is at the template library.
What format are the downloaded files?
Word documents for the definitions, the clean claim rate note, the review cadence and the escalation basis note, plus CSV for the four metric sheets, zipped into one file. They open in Word, Pages, Google Docs, Excel, Numbers and Sheets with nothing to convert first.
Why only four metrics?
Because each of the four changes a decision, and a fifth usually does not. Clean claim rate and denial rate say what next quarter's cash will be. Days in AR says when money arrives. Net collection rate says whether the practice eventually got what the contracts promised. Anything past that gets reported and never acted on.
What is cash at risk?
Denied charge times one minus that payer's own historical appeal recovery rate, computed from your appeal outcomes rather than an industry figure. It converts a denial rate into the money you expect to lose, which is why a payer overturning 71 percent of appeals and one overturning 38 percent stop looking comparable.
Why compare against a like-aged prior period?
Because net collection rate rises for months after a quarter closes as runout arrives. Comparing a three-month-old quarter against a fully run-out one manufactures a decline that is not there. Each row states its runout months so the comparison is between two numbers of the same maturity.
Can we escalate a payer using these numbers?
The numbers identify which payer, and then the escalation needs a written obligation rather than a metric. Two exist by regulation: a Medicare Advantage contract must provide that the plan pays 95 percent of clean claims within 30 days for the claim types named there.
Does the same obligation exist for Medicaid?
For claims paid by the state agency, yes, and the thresholds are different again. The agency must pay 90 percent of clean claims from practitioners within 30 days of receipt, and 99 percent within 90 days. Managed Medicaid runs through the plan contract instead, so read that before writing.
Find out which payer is dragging both numbers
Send a claims export, a remittance file and your appeal outcomes. The first thing back is the four metrics per payer, ranked, with cash at risk derived from your own recovery rate.
Edit with AI