Free Medical Billing Audit

Guide

Days in Accounts Receivable and Clean Claim Rate: Formulas and Worked Examples

Days in accounts receivable (days in A/R) measures how long, on average, it takes your practice to collect what it is owed. You calculate it by dividing your total outstanding A/R by your average daily charges, or by average daily net revenue if you prefer a net view. Clean claim rate, first-pass rate, denial rate, and net collection rate explain why that number moves. This guide gives each formula, a worked illustration, the common mistakes in measurement, and cautions about comparing your numbers to anyone else’s.

Person holding printed paperwork
In this article
  1. Why these five numbers belong on one page
  2. Clean claim rate: formula and variations
  3. Two definitions
  4. Decisions to write down
  5. Denial rate and rejection rate
  6. Days in accounts receivable: the formula
  7. Method one: based on gross charges
  8. Method two: based on net revenue
  9. Which method to use
  10. Worked illustration: calculating days in A/R
  11. Reading the A/R aging report
  12. Checks to run on any aging report
  13. Net collection rate and related revenue measures
  14. Worked illustration: reading all five metrics together
  15. Measurement pitfalls that distort the numbers
  16. Benchmarking cautions
  17. How each metric improves: causes and levers
  18. A reporting routine that works
  19. What to review and when
  20. Fields every monthly report should show
  21. What Mednex handles and what the practice handles
  22. Next steps
Key takeaways
  • Days in A/R is a lagging, blended number. Use it with A/R aging by payer and the share of balances older than 90 days.
  • Clean claim rate and first-pass rate are leading indicators. They tell you about problems before the A/R balance grows.
  • Every metric needs a written definition: numerator, denominator, time window, and whether you count claims or dollars.
  • Define it once and keep it. A change in definition looks like a change in performance.
  • Outside benchmarks depend on specialty, payer mix, and definitions. Compare against your own trend first.

Why these five numbers belong on one page

A revenue cycle is a pipeline. Claims enter, some leak out early through rejections and denials, and the rest turn into cash after a delay. Each metric looks at a different stretch of the pipe:

Metric Pipeline stage Leading or lagging
Clean claim rate Claim creation and submission Leading
First-pass payment rate Submission through first adjudication Leading, with a short delay
Denial rate Adjudication Mid-stream
Days in A/R Entire cycle to cash Lagging
Net collection rate Final result against what was collectible Lagging

If you only watch days in A/R, a problem that began in registration three months ago shows up late, after the money has already slowed. If you watch only clean claim rate, a payer that pays slowly can hide behind a good submission number. Use them together.

Clean claim rate: formula and variations

A clean claim is a claim that passes front-end edits and is accepted for processing without needing a correction or manual touch. “Clean” has two common meanings, and mixing them causes confusion, so choose one and label it.

Two definitions

Version Formula Question it answers
Submission-level clean claim rate Claims accepted by the payer for adjudication on first submission divided by claims submitted How often do claims pass the front-end checks?
First-pass resolution (payment) rate Claims paid on first submission, with no rework, divided by claims submitted How often does a claim turn into payment without extra work?

The first version covers rejections only. The second also covers denials, so it is lower or equal and is a stricter view. Some payers and vendors define “clean claim” in contracts or prompt-pay rules to mean a claim with no defect or special circumstance that prevents timely payment. That legal definition is separate from your internal metric, so read your payer agreements and state rules if the distinction matters to you.

Decisions to write down

  1. Count basis. Claims, or claim lines? Claims is more common.
  2. Cohort basis. Group claims by submission date or by date of service. Submission date is simpler for front-end metrics.
  3. Edits caught in-house. If your scrubber stops a claim and staff fix it before it leaves, does it count as clean? Under a strict view it does not, since it needed a touch. Under a payer-facing view it does. Record both if you can.
  4. Partial payments. Decide whether a partially paid claim counts as first-pass success. Many practices count only claims paid in full as expected.
  5. Waiting period. First-pass results need time to mature. Measure a cohort after enough days for most claims to adjudicate.

Denial rate and rejection rate

These two are separate because the stage differs. For the full distinction and how each is worked, see the claim rejection vs denial guide.

Metric Formula Notes
Rejection rate Claims rejected before adjudication divided by claims submitted Covers practice software, clearinghouse, and payer front-end rejections
Denial rate (claims) Claims with at least one denied line divided by claims adjudicated Shows how many claims met resistance
Denial rate (dollars) Denied charges divided by charges adjudicated Shows financial weight and can differ sharply from the claim view
Final write-off rate for denials Denied dollars written off divided by denied dollars Shows how much is never recovered
Overturn rate Denied claims that were later paid divided by denials appealed Tests whether appeals are chosen well

Do not combine rejections and denials into one rate, because the fix and the owner are different. Break each down by payer, provider, location, and reason. A high overall rate often comes from one payer or one provider.

Days in accounts receivable: the formula

Days in A/R answers a simple question: if you stopped billing today, how many days of charges are sitting uncollected? There are two standard ways to calculate it.

Method one: based on gross charges

  1. Choose a period, such as the last 90 days (three months is common because a single month is noisy).
  2. Add up total charges posted in that period.
  3. Divide by the number of days in the period. This is average daily charges.
  4. Take the total A/R balance at the end of the period.
  5. Divide total A/R by average daily charges.

Days in A/R = total A/R balance divided by (charges in period divided by days in period)

Method two: based on net revenue

If your A/R is carried at expected collectible value (net of contractual adjustments), divide it by average daily net revenue. This is more accurate when your charges are much higher than what payers allow, because gross charges inflate the denominator. Your accounting system may report A/R in one form or the other, so check which one it is before you compare periods.

Days in A/R (net) = net A/R divided by (net patient revenue in period divided by days in period)

Which method to use

Situation Better choice
Practice management system reports A/R at gross charge value Gross method, with gross daily charges
Accounting system carries A/R at expected payment Net method
Comparing two periods or two payers Whichever you use, use it every time
Fee schedule changed during the period Note the change, since gross charges move with it

Worked illustration: calculating days in A/R

Hypothetical example. All numbers below are round illustrations and do not represent any practice or benchmark.

  • Charges posted over the last 90 days: $450,000
  • Average daily charges: $450,000 divided by 90 = $5,000
  • Total A/R at the end of day 90: $270,000

Days in A/R = $270,000 divided by $5,000 = 54 days.

Now see what a total number hides. The $270,000 is split by age as follows:

Age bucket Balance Share of A/R
0 to 30 days $135,000 50%
31 to 60 days $54,000 20%
61 to 90 days $27,000 10%
91 to 120 days $27,000 10%
Over 120 days $27,000 10%

The share of A/R older than 90 days is $54,000 divided by $270,000, which is 20%. The blended average of 54 days looks acceptable by itself, but 20% of the balance is old and may be hard to collect. Another practice might show the same 54 days with only 5% over 90 days. They have the same headline number and very different risk. This is why aging buckets matter as much as the average.

Reading the A/R aging report

Aging reports can be built by date of service or by date of last billing. Check which one yours uses, since a rebilled claim can look young on one and old on the other.

Checks to run on any aging report

  1. Split by payer. One slow payer can pull the overall average up. Look at each payer’s own days and over-90 share.
  2. Split insurance from patient balances. Patient balances age differently and need a different workflow.
  3. Look at credit balances. Overpayments and credits can make total A/R look lower than the real unpaid amount. Report credits separately.
  4. Find unbilled charges. A visit not yet billed is not in A/R, but it is revenue waiting. Track charge lag separately.
  5. Find claims with no activity. Sort by last action date and list claims untouched for many days.
  6. Check denied balances. Denials that were posted but not worked sit in A/R and age.
  7. Reconcile to the general ledger. The aging total should match the balance your accountant sees.

The workflow for working old balances is covered in how to reduce A/R over 90 days, and the service description is on the accounts receivable recovery page.

Net collection rate and related revenue measures

Metric Formula What it shows
Net collection rate Payments received divided by (charges minus contractual adjustments), for a cohort of claims How much of what you could collect, you did collect
Gross collection rate Payments received divided by gross charges Mostly reflects your fee schedule vs payer rates. Weak for performance review
Charge lag Average days from date of service to charge entry How quickly work reaches billing
Days to submission Average days from date of service to claim submission Front-end speed. Affects the whole cycle
Payment lag by payer Average days from submission to payment, by payer Isolates slow payers
Cost to collect Billing cost divided by dollars collected Efficiency of the process
Adjustment and write-off mix Contractual vs bad debt vs administrative write-offs, by share Shows avoidable write-offs

Net collection rate depends on when you measure it. Measure it for a cohort of claims after enough time has passed for most to resolve, otherwise recent claims drag the number down. Contractual adjustments are expected and should be excluded from the denominator. Write-offs for timely filing, missing authorization, or lack of response are not contractual and should be tracked as avoidable losses.

Worked illustration: reading all five metrics together

Hypothetical example. Round numbers for illustration only. A practice submits 1,000 claims in a month.

Step Result
Claims submitted 1,000
Rejected at the front end 50
Accepted for adjudication 950
Denied at least in part 120
Paid with no rework 830
  • Submission-level clean claim rate: 950 divided by 1,000 = 95%
  • Rejection rate: 50 divided by 1,000 = 5%
  • Denial rate (claims): 120 divided by 950 = about 12.6%
  • First-pass payment rate: 830 divided by 1,000 = 83%

The 95% looks reassuring until you see the 83%. The 12 point gap between them is the denial effect. If the practice only reported the 95% figure, it would miss that one in eight adjudicated claims met resistance.

Next, look at dollars. Suppose the month’s charges for these claims were $1,000,000, contractual adjustments were $400,000, and after resolution payments totaled $540,000, with $20,000 written off as avoidable (timely filing and no response). Then:

  • Collectible amount: $1,000,000 minus $400,000 = $600,000
  • Net collection rate: $540,000 divided by $600,000 = 90%
  • Remaining $40,000 is patient balances or still in process, and $20,000 of it is a loss that was preventable.

Conclusion from this example: the first controls to examine are the denial drivers and the avoidable write-offs, not the front-end scrubber. A different set of numbers would point elsewhere. That is the value of reading the metrics together.

Measurement pitfalls that distort the numbers

Pitfall How it distorts Fix
Mixing gross and net A/R Days in A/R jumps between periods without any real change Write down the method and keep it
Using one month of charges Seasonality and holidays swing the denominator Use a 90-day window or a rolling average
Fee schedule change Gross charges rise, so days in A/R falls with no real improvement Use the net method or annotate the change
Writing off old balances A/R falls, so days in A/R improves, but cash did not Track write-offs next to A/R and review the reasons
Rebilling resets the age Old claims look young Age by date of service as well as by last billing date
Unposted payments A/R looks higher than reality Check payment posting lag and unapplied cash
Counting resubmissions as new claims Clean claim rate falls or rises falsely Count original submissions only
Averages across payers Hide a single problem payer Report by payer and by provider
Different definitions between report sources EHR, clearinghouse, and accounting disagree Pick one source of truth and document it

Benchmarking cautions

Public figures for days in A/R, clean claim rate, and denial rate circulate widely, and they rarely match your situation. The reasons are straightforward:

  • Different definitions. A vendor’s “clean claim rate” may be a submission-level rate while another source means first-pass payment. Industry groups, including the Healthcare Financial Management Association, publish standard metric definitions, but many articles and tools do not follow them.
  • Specialty differences. A procedure-heavy specialty with prior authorization and high-dollar claims has different patterns from a primary care office with many small claims. See the primary care billing and cardiology billing pages for examples of how workflows differ.
  • Payer mix. Medicare, Medicaid, commercial, workers’ compensation, and self-pay each pay at different speeds.
  • Patient balances. A practice with a high-deductible population carries more patient-responsibility A/R, which collects more slowly.
  • Source and sample. Surveys of volunteer respondents, vendor customer data, and academic samples are different populations.

Use outside numbers as a rough orientation only. Set your own target based on your trend over the last four to eight quarters, your payer contracts, and your specialty. A steady decline in over-90 share, in avoidable write-offs, and in repeat denial reasons is more informative than hitting a quoted figure.

How each metric improves: causes and levers

Symptom Likely causes Levers
Low clean claim rate Registration errors, invalid IDs, provider setup problems, code or format errors Eligibility check at scheduling, card scan, payer ID audit, scrubber rules, daily rejection work
Low first-pass rate with a good clean claim rate Authorization, medical necessity, coding, coordination of benefits denials Authorization tracking, coding review, documentation templates, other-insurance capture
High days in A/R Slow charge entry, slow submission, unworked denials, slow payers, unposted payments Charge lag target, daily claim submission, denial work queues, follow-up cadence, posting accuracy
High over-90 share Claims with no follow-up, denials past appeal windows, secondary billing gaps Worklist by age and value, appeal calendar, secondary claim checks
Low net collection rate Avoidable write-offs, underpayments, patient balances not collected Underpayment review against contract, patient billing workflow, timely filing controls

Underpayments deserve special attention. If payments are posted without comparing them to the contracted rate, a payer paying less than the contract allows will never appear as a denial or an aging problem. Where the fee schedule is available, spot-check payments against it. More on this kind of hidden loss is in revenue leakage in healthcare.

A reporting routine that works

What to review and when

  • Daily: rejection report, unsubmitted charges, payments to post.
  • Weekly: denials by reason and payer, claims untouched for more than a set number of days, charge lag, top five reasons for any new problem.
  • Monthly: clean claim rate, first-pass rate, denial rate, days in A/R, over-90 share, net collection rate for a mature cohort, write-offs by reason, payer-level summary.
  • Quarterly: trend review, payer contract and fee schedule check, process changes and their effect.

Fields every monthly report should show

  1. Metric definition in one line, so a new reader knows how it is computed.
  2. The current value, the prior period value, and the trailing average.
  3. The count and dollar basis.
  4. Breakdown by payer and by provider.
  5. A short note on anything that changed: fee schedule, new payer, new staff, system change.

What Mednex handles and what the practice handles

Mednex can support The practice keeps
Defining metrics in writing and building the regular report from exports Choosing targets and approving the definitions
Working rejections, denials, and aged balances against a follow-up cadence Clinical documentation and registration quality at the front desk
Identifying causes by payer, provider, and reason and recommending fixes Carrying out workflow changes inside the practice
Flagging underpayments against contract rates when the fee schedules are supplied Payer contract negotiation, which is outside Mednex scope

Mednex cannot guarantee a particular days in A/R figure, a clean claim rate, or collection result, because payment decisions and timing belong to payers and patients. The reporting cadence, access method, and report formats are agreed in writing at the start. A wider view of the service is on the medical billing page and the revenue cycle management page.

Next steps

Start with a one-page baseline. Pull the last 90 days of charges, the current A/R aging by payer, and a claims list with acknowledgment and remittance outcomes. Compute the five metrics with written definitions. Note the oldest buckets and the payers behind them. Then pick the single largest cause of delay and measure it again next month.

If you would like an outside review of those numbers, the Free Medical Billing Audit looks at a de-identified or secure-portal sample of recent claims, denial and rejection reasons, and A/R aging by payer. You provide report exports and never send patient records through the website form. You can also use the contact page, or read more in the Mednex blog.

General information only

This guide is educational. It is not legal, coding, compliance or clinical advice. Rules differ by payer, plan, state and contract, so confirm against the payer's current policy before acting.

Frequently asked questions

How do you calculate days in accounts receivable?

Divide your total outstanding A/R by your average daily charges. Average daily charges equal total charges over a set period divided by the number of days in that period. For example, in a Hypothetical example with 300,000 dollars in A/R and 10,000 dollars in charges per day, days in A/R is 30. Some practices use average daily net revenue instead, which gives a different but valid result. Pick one method, write it down, and keep the period the same each month, because a change in method looks like a change in performance. Always read the number alongside an aging report by payer, since one average can hide a few very old balances.

What is a good days in accounts receivable number?

There is no single good number, because it depends on specialty, payer mix, how you define the metric, and how quickly your payers pay. A practice with mostly commercial payers and one with a large self-pay share will look different. Use outside benchmarks, such as published industry measures, only as rough context after you confirm the definition matches yours. The more useful comparison is your own trend over several months, broken out by payer. A rising number, or a rising share of balances past 90 days, is a reason to investigate, whatever the starting point. Check the payer's current policy and contract terms for expected payment timing.

What is the difference between clean claim rate and first-pass resolution rate?

Clean claim rate usually measures how many claims the payer or clearinghouse accepts for processing on first submission. First-pass resolution rate is stricter: it counts claims that are paid on first submission with no rework, so denied claims are excluded. The first catches rejections and format problems; the second also catches denials. Payer contracts and prompt-pay laws may also define a clean claim in their own legal terms, which is separate from your internal metric. Write down which definition you use, whether you count claims or lines, and whether you group by submission date or date of service.

How do you calculate denial rate?

Denial rate is the number of claims denied divided by the number of claims submitted, or the dollars denied divided by the dollars billed, over the same cohort and time window. Decide whether to count the initial denial only or also denials after resubmission, and whether to count rejections at the clearinghouse. Many practices track both a count-based and a dollar-based rate, and split them by payer and reason category. A claim-based rate shows how often problems occur; a dollar-based rate shows where the money is. Compare against your own history before comparing with any outside figure.

Why is my days in A/R high even though collections look fine?

The number can be inflated by a few large old balances, by patient balances that are not being worked, by uncollectible accounts that were never written off, or by rapid charge growth in a way that changes the denominator. It can also reflect a definition problem, such as including credits or mixing gross and net methods. Review the aging by payer and by bucket, list the oldest balances, and separate patient from insurance A/R. If collections are steady but the number is high, the cause is often balances that should be resolved or written off under policy.

What is net collection rate and how is it different from gross collection rate?

Net collection rate compares what you collected with what you were actually entitled to collect after contractual adjustments, so it is payments divided by charges minus contractual write-offs. Gross collection rate compares payments with total billed charges, which drops whenever payers allow less than your fee, so it can look low even when you are paid correctly. Net collection rate is a better measure of billing performance, but it relies on accurate contractual adjustments. If adjustments are posted incorrectly, the net rate will mislead. Define the period and the adjustment types you include.

How often should a practice review these metrics?

Review leading measures such as clean claim rate, rejections, and charge lag weekly, because problems there show up quickly. Review denial rate, days in A/R, and the aging report at least monthly, and look at net collection rate monthly or quarterly once enough claims have settled. Do an annual or event-driven deeper review when you change systems, payers, or staff. A short written routine helps: who pulls the report, which fields it contains, who reviews it, and what triggers an investigation. The cadence matters less than doing it consistently with fixed definitions.

Can I compare my numbers with industry benchmarks?

You can, with caution. Benchmarks vary by specialty, payer mix, practice size, and how each metric is defined, so a published figure may not match your formula. Before comparing, confirm that the source defines the numerator, denominator, period, and cohort the same way you do. Treat the comparison as a prompt for questions, not a verdict. The most reliable benchmark is your own trend, split by payer and provider. If you want an outside look at your numbers, a billing audit can review them against your own data and report patterns.

What can a billing company do about a high days in A/R?

A billing company can analyze the aging by payer, sort claims by cause, work denials and unpaid claims in priority order, fix front-end problems that create rework, and report results in a consistent format. It cannot guarantee payer decisions or a specific result, because payers decide what they pay under their policies and your contracts. Ask for the definitions behind any metric it reports, and for how it handles balances that are near filing or appeal limits. A free review of a sample of claims and your A/R aging is a reasonable first step.

Sources

Want this reviewed against your own claims?

The free medical billing audit looks at a sample of your recent claims, denial reasons and A/R aging. You get a written summary and a walkthrough call.

Do not include patient names, insurance IDs or clinical details. If records are needed later, we set up a secure way to share them.