Blog · Board and management reporting
Medical billing KPIs compare denials, collections, and receivables aging using consistent populations. Work through payer-level examples, define the export fields, and reconcile the results before acting.
A KPI in medical billing measures denials, collections, or receivables aging against a clearly defined population. Use the measures together: a lower denial rate can coexist with slower payments and a growing overdue balance. The useful comparison is by payer and period, with every total tied back to the billing report.
A key performance indicator needs a business question, a formula, an owner, and an action. For billing, the question might be whether initial adjudications are producing more denials, whether an established service cohort is collecting as expected, or where unpaid balances are accumulating.
Keep three clocks separate. Adjudication measures follow decisions made during a reporting period. Collection measures follow a service cohort through a cutoff. Aging measures describe the unpaid balance at a single date. Putting them on the same report does not make their populations interchangeable.
CMS explains that a remittance advice reports adjudication and payment information, including adjustments. An adjustment is not automatically a denial: its reason and level matter. Agree with the billing owner how the existing status categories map into the management report before counting them.
Use authorized aggregate exports prepared by the billing team. The comparison needs payer groups and financial totals, rather than names, diagnoses, or individual claim records. Provider billing also differs from medical and healthcare supplier sales KPIs, which follow a commercial sales process.
Ask for these summaries, with a definition sheet describing exclusions and cutoff dates:
| Export | One row represents | Required measures |
|---|---|---|
| Initial adjudication summary | Payer and first-decision month | Initially adjudicated claims; claims with an initial denial |
| Collection cohort summary | Payer and service cohort | Gross charges; contractual adjustments; net payments through cutoff |
| Receivables snapshot | Payer and snapshot date | Outstanding balances in mutually exclusive age bands |
For this example, a claim with any denied line counts once as an initially denied claim. Later appeals and resubmissions do not create another initial decision. That is a stated management convention, not a claim that every organization defines denial rate this way.
Initial denial rate = Initially denied claims / Initially adjudicated claims
Cohort collection rate = Net payments for the cohort / Collectible charges for the cohort
Collectible charges = Gross charges minus contractual adjustments
Over-90-day receivables share = Outstanding balance older than 90 days / Total outstanding receivables
The collection example assumes no other adjustments, refunds, or write-offs. In a real export, state how those items affect payments and the denominator. Do not quietly shrink collectible charges by bad-debt write-offs and interpret the resulting improvement as better collection.
Consider a fictional US outpatient group reviewing three payer groups. The first table covers first adjudications during September 2026. The second follows a closed June service cohort through September 30, 2026. Percentages are rounded to two decimal places; calculations use unrounded values.
| Payer group | Initially adjudicated claims | Initially denied claims | Initial denial rate |
|---|---|---|---|
| A | 800 | 64 | 8.00% |
| B | 400 | 60 | 15.00% |
| C | 300 | 15 | 5.00% |
| Total | 1,500 | 139 | 9.27% |
Group B's rate is 60 / 400 = 15.00%. The combined rate is 139 / 1,500 = 9.27%. Divide the summed counts; an average of the payer percentages gives each payer equal importance regardless of volume.
| Payer group | Gross charges (USD) | Contractual adjustments (USD) | Collectible charges (USD) | Net payments (USD) | Unpaid cohort balance (USD) | Collection rate |
|---|---|---|---|---|---|---|
| A | 160,000 | 60,000 | 100,000 | 92,000 | 8,000 | 92.00% |
| B | 100,000 | 40,000 | 60,000 | 48,000 | 12,000 | 80.00% |
| C | 60,000 | 15,000 | 45,000 | 40,500 | 4,500 | 90.00% |
| Total | 320,000 | 115,000 | 205,000 | 180,500 | 24,500 | 88.05% |
The collectible amount is 320,000 minus 115,000 = $205,000. Payments of $180,500 divided by $205,000 give 88.05%. The remaining $24,500 is still unpaid at the cutoff; it is not automatically uncollectible.
The identity proves the table: $180,500 collected plus $24,500 unpaid equals $205,000 collectible. Each payer row must satisfy the same identity. Tie gross charges, contractual adjustments, and payments separately to the source cohort report so offsetting mistakes cannot disappear in the total.
The following table covers all open receivables at September 30, 2026, aged from the original billing date. It includes more service periods than the June collection cohort, so its total should not equal that cohort's unpaid balance.
| Payer group | 0-30 days (USD) | 31-60 days (USD) | 61-90 days (USD) | Over 90 days (USD) | Total (USD) | Over-90-day share |
|---|---|---|---|---|---|---|
| A | 60,000 | 20,000 | 10,000 | 10,000 | 100,000 | 10.00% |
| B | 30,000 | 20,000 | 15,000 | 15,000 | 80,000 | 18.75% |
| C | 20,000 | 5,000 | 3,000 | 2,000 | 30,000 | 6.67% |
| Total | 110,000 | 45,000 | 28,000 | 27,000 | 210,000 | 12.86% |
The bands reconcile: 110,000 + 45,000 + 28,000 + 27,000 = $210,000. The old balance is 27,000 / 210,000 = 12.86%. Tie the total to the approved receivables control balance and explain any excluded credit balances separately.
Group B deserves the first review: its initial denial rate is highest, its cohort collection rate is lowest, and its older-balance share is highest. Those observations identify a queue for investigation; they do not prove a common cause. The billing manager should examine approved denial-reason summaries and unresolved balance categories with the payer owner.
Keep status and cash evidence separate. CMS describes claim-status requests and responses as a way to obtain processing status. A status update is not proof that a payment reached the bank or was posted to the correct cohort.
The billing manager owns definitions and follow-up. Finance owns payment and receivables reconciliation. Broader healthcare KPIs cover access and capacity; they should support this billing review without turning financial results into clinical judgments. A dashboard review is useful only after these definitions and ties hold.
Upload authorized aggregate billing files or a Google Sheet with payer counts, cohort payments, and aging balances; Covirage maps the columns, and its tools compute the rates and check the totals. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See self-service analytics for the supporting file-based workflow.
Either can be useful, but they answer different questions. A claim-count rate measures how often claims encounter denials. A dollar rate measures the financial exposure. Label the unit and never divide denied dollars by a count of claims.
That is a cash-to-charges period ratio, not a matched collection rate. Payments often relate to earlier services. For collection effectiveness, follow a defined service cohort through a stated cutoff and compare its payments with its collectible charges.
It is the outstanding balance whose age exceeds 90 days under your stated aging convention. Specify whether age starts at service, billing, or another approved date. The ratio divides that balance by total receivables from the same snapshot.
No. Billing staff can prepare approved aggregates by payer, period, and status in the existing billing process. Those summaries can include counts, charges, adjustments, payments, and aging balances without names, diagnoses, or individual claim records.