Revenue Cycle Management Reporting: What a Good Monthly Scorecard Shows
Revenue cycle management reporting puts 8 numbers on 1 page each month. Formulas, benchmarks, red lines, owners, and worked cash math for your practice.

Revenue Cycle Management Reporting: What a Good Monthly Scorecard Shows
Revenue cycle management reporting is a 1-page monthly scorecard with 8 numbers, a benchmark for each number, and a named owner for each fix. You pull the numbers on the same day each month. You review them in 45 minutes. You leave with owners and due dates.
Good reporting catches a denial spike in month 1. Weak reporting finds it in month 4, after the cash already missed.
The pressure is real. Kodiak Solutions tracked an 11.6% initial denial rate in 2025 and $48.4 billion lost to final denials and bad debt, up 25% from $38.6 billion in 2024, across 2,300 hospitals and 350,000 physicians. AMS Solutions put the average denial rate at 9.0% and days in AR at 42 in 2026.
Your scorecard tells you which side of those lines your practice sits on. This guide gives you the 8 numbers, the formula for each one, and the cash math for a late catch.
Table of contents
- What revenue cycle management reporting covers
- The monthly scorecard: 8 numbers on 1 page
- Cash numbers: days in AR, AR over 90 days, net collection rate
- Claim numbers: clean claim rate, denial rate by payer, first-pass rate
- Front-end numbers: charge lag and point-of-service collections
- How to run the 45-minute monthly review
- Worked math: the cost of catching a denial spike 3 months late
- What to ask your billing vendor for each month
- Get your scorecard checked
- Frequently asked questions
Key takeaways
- Kodiak Solutions tracked an 11.6% initial denial rate in 2025, a 2.7% median final denial rate, and $48.4 billion lost to final denials and bad debt.
- AMS Solutions put the average denial rate at 9.0% and days in AR at 42 in 2026, against targets of under 5% denials and 30 to 40 days in AR.
- HFMA MAP targets: clean claim rate 98%, days in AR 30 to 40, AR over 90 days under 10%, net collection rate 95% or higher.
- A 45-minute monthly review with owners and due dates beats a year-end report with no owners.
35 days in AR is the benchmark. Anything over 50 is uncollected revenue.
We conduct a forensic 90-day cash flow audit to identify unworked claims, fee schedule underpayments, and clearinghouse leaks.
Audit My Cash Flow Leaks →What revenue cycle management reporting covers
Revenue cycle management reporting covers cash, claims, and front-end work in 1 view. Cash numbers show how fast money lands. Claim numbers show how clean your claims leave. Front-end numbers show how fast charges and patient payments start.
You need all 3 groups. A practice can post a strong net collection rate and still bleed cash through slow charges.
HFMA publishes 29 MAP Keys across patient access, pre-billing, claims, account resolution, and financial management. Your monthly scorecard picks 8 of those keys and watches them every month.
The GetPracticeHelp dashboard guide for small practices uses 7 metrics on 1 page with a 30 to 45 minute monthly review. The Impact Innovations KPI guide uses 7 KPIs with payer scorecards and workqueue views.
Both guides agree on the core set. Your job is to lock the formulas, lock the pull day, and lock the owners.
Our revenue cycle management service runs this scorecard for you each month. You get the 8 numbers, the change from last month, and the fix in plain words.
The monthly scorecard: 8 numbers on 1 page
Use this table as your scorecard. Print it. Fill it on the 5th business day each month. Score each number green, yellow, or red against the lines below.
Number | Formula | Good | Red line | Source report | Owner |
|---|---|---|---|---|---|
Days in AR | Total AR divided by average daily charges | 30 to 40 days | Over 50 days | AR aging report | Billing lead |
AR over 90 days | AR aged over 90 days divided by total AR | Under 10% | Over 15% | AR aging report | Billing lead |
Net collection rate | Payments divided by charges minus contractual adjustments | 95% or higher | Under 90% | Billing summary report | Practice manager |
Clean claim rate | Claims accepted on first submission divided by total submitted | 95% or higher, HFMA MAP target 98% | Under 90% | Clearinghouse report | Billing lead |
Denial rate by payer | Denied claims divided by total submitted, split by top 5 payers | Under 5% | Over 10% | Clearinghouse or denial log | Billing lead |
First-pass rate | Claims paid in full on first submission divided by total submitted | 90% or higher | Under 80% | Clearinghouse report | Billing lead |
Charge lag | Days from date of service to charge posted | 2 days or less | Over 5 days | Charge lag report | Front desk lead |
Point-of-service collection rate | Patient payments at check-in divided by patient payments collected | Track your trend, see below | Falling 3 months in a row | Patient payment report | Front desk lead |
The DataDrivenDoctor 2026 revenue cycle benchmarks publish the AMS Solutions averages behind the denial and AR lines. The GoSvizzera 2026 medical billing benchmarks publish the clean claim, days in AR, and net collection lines from MGMA and HFMA sources.
The 2026 RCM benchmarks report splits best-in-class, average, and needs-improvement bands by specialty. The A3 Medical Billing 2026 RCM guide lists monthly CFO metrics with HFMA MAP Keys 2026 and MGMA DataDive 2026 as sources.
Pick 1 benchmark set and stay with it for 12 months. A moving target hides a real trend.
Write each scorecard row like this, word for word: "Denial rate, Payer A: 9.2% in October, 6.1% in September, red line 10%, owner billing lead, fix due November 12: pull top 20 denial codes and add scrubber edit." That 1 line carries the number, the trend, the line, the owner, and the fix.
Our revenue cycle management KPIs guide gives you the formula for each of the 6 core numbers. Start there if your reports use different names.
Cash numbers: days in AR, AR over 90 days, net collection rate
Days in AR tells you how many days of charges sit unpaid. Divide total AR by average daily charges.
The target is 30 to 40 days, with over 50 days as the red line. AMS Solutions put the 2026 average at 42 days, up from 38 days, per the DataDrivenDoctor 2026 benchmarks.
A July 2026 MGMA Stat poll found 32% of groups reported days in AR higher than a year earlier, 43% flat, and 22% lower. Your trend matters more than 1 month. Pull days in AR every Monday and review it monthly.
AR over 90 days tells you how much cash sits in the oldest bucket. Keep it under 10% of total AR, per the HFMA target.
Old AR pays at a low rate. Work the 61 to 90 day bucket before it rolls into 90 plus.
Net collection rate tells you how much of your allowed amount you collect. Divide payments by charges minus contractual adjustments.
The target is 95% or higher, with 97% to 99% as the top band. Under 90% means write-offs, missed underpayments, or patient balances nobody worked.
Split net collection rate by payer each quarter. A strong total can hide 1 payer paying under contract.
The AMS Solutions billing company guide lists a 2026 snapshot of 95% plus clean claims, denials under 5%, 30 to 40 days in AR, under 10% AR over 90 days, 96% net collection, and 90% plus first-pass. Use those lines to score a vendor report.
Our revenue cycle audit guide shows you how to price each cash leak in dollars. Run it when 2 cash numbers sit red for 2 months in a row.
Claim numbers: clean claim rate, denial rate by payer, first-pass rate
Clean claim rate tells you how many claims pass on first submission. Divide claims accepted first pass by total submitted.
The target is 95% or higher, with an HFMA MAP target of 98%. Under 90% means eligibility, coding, or enrollment errors reach the payer.
Rework costs $103 per denied claim against $6.50 for a clean claim, per HFMA in Fall 2025. Track clean claim rate weekly until it holds at 95% or higher for 4 straight weeks.
Denial rate tells you how many submitted claims payers deny. Divide denied claims by total submitted.
Split denial rate by your top 5 payers by volume. A 4% total can hide a 15% rate with 1 payer, and that payer needs a different fix.
The target is under 5%, with over 10% as the red line. Kodiak Solutions tracked an 11.6% initial denial rate in 2025, up from 11.4% in 2024, per TechTarget coverage of the Kodiak report.
The DataDrivenDoctor denial leakage analysis puts the median final denial rate at 2.7% in 2025, up from 2.5% in 2024, with an appeal overturn rate of 42.1%. The Flobotics denial guide splits denial causes by category for the same Kodiak data set.
Rank denials by dollars each month, top 5 codes first. Fix the scrubber edit, the note template, or the eligibility step behind code 1 before you touch code 5.
First-pass rate tells you how many claims pay in full on first submission. Divide claims paid in full first pass by total submitted.
The target is 90% or higher, with under 80% as the red line. Clean claim rate measures acceptance. First-pass rate measures payment. You need both.
Our revenue cycle management workflow guide maps where each claim number gets created. Fix the stage, and the number moves next month.
Front-end numbers: charge lag and point-of-service collections
Charge lag tells you how long a visit waits for a charge. Count days from date of service to charge posted.
The target is 2 days or less. A visit with no charge bills $0, and a late charge ages your AR before the claim leaves.
Reconcile your schedule to charges every day. Hold the day open until every completed visit carries a charge.
Point-of-service collections tell you how much patient money you collect at check-in. Divide patient payments at check-in by total patient payments collected.
Patient responsibility hit 22.99% of allowed amounts in Q1 2026, with point-of-service collections at 24.8% of patient payments, per Kodiak Solutions in Q1 2026. Health systems collect 31% of patient billings, per the HFMA and PayZen survey from May 2026 with 205 respondents.
Track your rate monthly and watch the trend. A fall 3 months in a row means estimates, card on file, or check-in scripts slipped.
The Becker's ASC dashboard guide tracks charge lag, statement lag, clean claim rate, and denial rate on a daily, weekly, and monthly cadence. The SVMIC revenue cycle dashboard guide pairs days in receivables with payer mix and aged trial balance on 1 dashboard.
You do not need new software to start. Your EHR, your clearinghouse, and 1 spreadsheet hold every number on this scorecard.
Our medical billing services run eligibility, charge review, and submission as 1 queue. Front-end fixes show up in claim numbers 30 days later.
How to run the 45-minute monthly review
Run the review on the 5th business day each month. Same day. Same 8 numbers. Same owners in the room.
Minutes 1 to 10: read each number against last month and the 3-month trend. Flag any number that moved 2 points or more.
Minutes 11 to 25: pull the detail behind each flag. For denials, pull top codes by payer. For AR, pull accounts that rolled into 90 plus this month.
Minutes 26 to 40: assign each fix to a named owner with a due date. No fix leaves the room with no owner.
Minutes 41 to 45: write 1 paragraph that sums up the month and lists open fixes. File it with the scorecard. You now hold a trend and an audit trail.
A single bad month with a clear cause is a blip. Two red months in a row with no clear cause is a system fault. Book a deeper review that week.
Our how to improve revenue cycle management guide turns each red number into a weekly fix. Use it in minutes 26 to 40.
Worked math: the cost of catching a denial spike 3 months late
Here is the cost of a late catch. Assumptions, each labelled: your practice submits 500 claims a month and collects $180,000 a month. Denial rate jumps from 5% to 9% in January. Nobody catches the jump until the April scorecard.
Extra denied claims per month. 500 claims times 4 points equals 20 extra denied claims a month.
Extra denied claims over 3 months. 20 times 3 equals 60 extra denied claims.
Rework cost. 60 times $103 equals $6,180 in rework labor, at the HFMA Fall 2025 rate of $103 per denied claim. Submitted clean, those 60 claims cost 60 times $6.50, or $390.
Cash stuck in AR. Average daily charges: $180,000 divided by 30 days equals $6,000 a day. Days in AR rise from 35 to 48, a gain of 13 days. Cash stuck: 13 times $6,000 equals $78,000 sitting in AR instead of your bank.
Final-denial risk. Kodiak Solutions tracked a 2.7% median final denial rate in 2025 and a 42.1% appeal overturn rate. Extra denials that nobody works on time carry a higher write-off risk than denials worked in week 1.
A monthly scorecard catches the jump in February, after 1 month and 20 extra denials. Rework cost at that point: 20 times $103 equals $2,060. You save $4,120 in rework and free the $78,000 cash pile 2 months sooner.
GetPracticeHelp estimates, on operational estimates and not survey data, that an independent practice with $800,000 to $2 million in revenue can lose 4% to 8% of net collectible revenue a year to leaks nobody watches. On $2.16 million in collections, that claimed range equals $86,400 to $172,800 a year.
Your scorecard costs 45 minutes a month. The late catch costs thousands in rework and weeks of cash. Our pricing page shows what full-cycle reporting costs with MD Revenue Group.
What to ask your billing vendor for each month
Ask for the 8 numbers, by payer, with last month and the 3-month trend on the same page. Ask for the top 5 denial codes by dollars. Ask for accounts that rolled into AR over 90 days.
Send this email, word for word: "Please send the monthly scorecard by the 5th business day with these 8 numbers: days in AR, AR over 90 days, net collection rate, clean claim rate, denial rate by top 5 payers, first-pass rate, charge lag, and point-of-service collection rate. Include last month, the 3-month trend, top 5 denial codes by dollars, and a named owner plus due date for each red number."
A vendor that cannot produce denial rate by payer each month is guessing. A vendor that sends totals with no payer split hides your worst payer inside the average.
Compare vendor numbers against the AMS Solutions 2026 snapshot: 95% plus clean claims, denials under 5%, 30 to 40 days in AR, under 10% AR over 90 days, 96% net collection, 90% plus first-pass. Score your vendor against the same lines each month.
Read our revenue cycle management software guide before you buy a dashboard tool. Most practices need locked formulas and a pull day first. Software comes second.
Get your scorecard checked
Build the 8-number scorecard this month. Pull the numbers on the 5th business day. Review them for 45 minutes with owners in the room.
MD Revenue Group runs this reporting for you. Start with a free audit of your last 90 days and get your 8 numbers scored against the lines in this guide. Or read how our revenue cycle management service reports to you each month.
Frequently asked questions
Revenue cycle management reporting is a monthly scorecard that tracks cash, claim, and front-end numbers against fixed benchmarks. A good scorecard holds 8 numbers on 1 page, each with a formula, a benchmark, a red line, and a named owner.
Put 8 numbers on the scorecard: days in AR, AR over 90 days, net collection rate, clean claim rate, denial rate by payer, first-pass rate, charge lag, and point-of-service collection rate. Targets include 30 to 40 days in AR, under 10% AR over 90 days, 95% or higher net collection, and 95% or higher clean claims.
Review the full scorecard monthly in a 45-minute meeting on the 5th business day. Pull days in AR and clean claim rate weekly, because a monthly look catches a denial spike 4 weeks late.
A good days in AR runs 30 to 40 days, with over 50 days as the red line. AMS Solutions put the 2026 average at 42 days, and a July 2026 MGMA Stat poll found 32% of groups higher than a year earlier.
A billing vendor should report the 8 scorecard numbers by payer, with last month and the 3-month trend, top 5 denial codes by dollars, and a named owner plus due date for each red number. Denial rate by payer is a must, because a practice-wide average hides your worst payer.
See your revenue leaks in dollars.
Get a forensic 90-day cash flow audit of your practice. 100% confidential, 48-hour delivery, zero obligation.
