How to calculate days in A/R for a medical practice

The formula

Days in A/R divides what is still owed to the practice by the amount the practice charges on an average day. The American Academy of Family Physicians describes it in two steps: work out average daily charges for a period, then divide total receivables by that daily figure. ¹

HFMA gives the same calculation with a 12-month base: divide current receivables, net of credits, by the average daily charge, where the average daily charge is gross charges for the previous 12 months divided by 365. ²

• Average daily charges = total gross charges for the period ÷ days in the period
• Days in A/R = total A/R (net of credit balances) ÷ average daily charges

A worked example

Take a hypothetical three-provider clinic. Over the last 12 months it posted $2,190,000 in gross charges, so its average daily charge is $2,190,000 ÷ 365 = $6,000. Its A/R report shows $270,000 outstanding after credit balances are removed. Days in A/R is $270,000 ÷ $6,000 = 45 days.

Use the same window every month. A three-month window reacts faster to a change in volume or payer mix. A 12-month window is steadier and is the version HFMA describes. Either is fine as long as you do not switch between them when comparing months.

What the published targets say

AAFP says days in A/R should stay below 50 at a minimum and that 30 to 40 days is preferable. ¹ HFMA also puts the target range at 30 to 40 days, and adds two aging checks: A/R older than 90 days should be under 10% of the total, and self-pay A/R older than 90 days should be under 30%. ²

Treat these as reference points, not a grade. Specialty, payer mix and how much patient responsibility sits in your A/R all move the number. A practice with a large share of high-deductible plans will carry more patient balances than one that is mostly Medicare.

Read the aging report next to the number

A single days-in-A/R figure can hide the problem. Pull the aging report and split it into 0 to 30, 31 to 60, 61 to 90, 91 to 120 and over 120 days. Then split each bucket by payer and by insurance versus patient balances.

Common patterns to look for:

• One payer carries most of the over-90 balance. That usually points to a credentialing, enrollment or contract issue with that payer.
• Patient balances grow while insurance balances hold steady. That points to front-desk collection at the time of service and statement follow-up.
• Many claims sit in the 31 to 60 bucket with no payer response. That often means claims were rejected at the clearinghouse and never resubmitted.
• Credit balances are large. Unapplied payments and overpayments make A/R look smaller than it is, which is why both AAFP and HFMA net them out.

Mistakes that distort the result

Mixing gross and net figures is the most common one. If your A/R is stated net of contractual adjustments, divide by net daily revenue, which HFMA calls net days in A/R. ² Dividing net A/R by gross charges makes the practice look faster than it is.

The second is a write-off sweep right before month end. Writing off old balances lowers days in A/R without collecting anything. Track write-offs as a separate line so the trend stays honest. HFMA's MAP Keys exist to keep these definitions consistent across organizations. ³

What to do with the number

Calculate it on the same day each month and chart it next to the share of A/R over 90 days. If both rise together, look at the claims workflow first: charge lag, rejections and denials. If days in A/R is stable but the over-90 share grows, the issue is follow-up on older claims. Fix the bucket that holds the most dollars before chasing the oldest balances.