Days-in-A/R Benchmark & Tracker (2026)

1Tell us where to send it
Your name and work email — nothing more.
2Check your inbox
Your tracker arrives in seconds, not days.
3Use it with your team
Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template

Spotsaas · 2026

Days-in-A/R Benchmark & Tracker

✓ Instructions

✓ Monthly Tracker

✓ Benchmark & Trend

Get the tracker →

What it is

The Days-in-A/R Benchmark & Tracker is a downloadable Excel workbook for tracking the single most-watched revenue-cycle metric — Days in Accounts Receivable — month over month, and grading it against MGMA-style best-practice benchmarks. Days in A/R measures how long, on average, it takes to collect payment after a service is billed; lower is better, because it means faster cash and a healthier revenue cycle. The tracker takes two simple monthly inputs — total A/R (the ending receivable balance) and total charges for the period — and computes average daily charges, Days in A/R, and a Green/Amber/Red status against the benchmark.

The workbook is organized across three tabs. The Instructions tab explains the metric, the calculation, and the benchmarks: Days in A/R under 30 is best practice, 30-40 is acceptable, and over 40 needs attention, with the share of A/R over 90 days targeted below 15-18% and ideally below 10%. The Monthly Tracker tab is where the user enters total A/R, total charges, days in the period, and the percent over 90 days for each month; the workbook auto-calculates average daily charges (total charges ÷ days in the period), Days in A/R (total A/R ÷ average daily charges), and the status flag. The Benchmark & Trend tab summarizes a blended Days-in-A/R figure across all tracked months and returns a plain-language verdict.

The calculation it automates is the standard revenue-cycle formula: average daily charges equals total charges for the period divided by days in the period, and Days in A/R equals total A/R divided by average daily charges — so $480,000 in A/R against $20,000/day in charges yields 24 days in A/R. Because the workbook grades each month and blends across months, it shows not just where the practice stands today but whether the trend is improving or deteriorating against the benchmark.

What it's used for

Practices and billing companies use the tracker to monitor the headline revenue-cycle KPI consistently and to see at a glance whether collections are speeding up or slowing down relative to industry benchmarks. It turns a metric that's often calculated inconsistently into a standardized, month-over-month trend.

✓ Calculating Days in A/R each month automatically from two inputs — total A/R and total charges — so the metric is computed the same way every time.
✓ Grading each month Green/Amber/Red against MGMA-style benchmarks (under 30 days best practice, 30-40 acceptable, over 40 needs attention) for an instant read on revenue-cycle health.
✓ Tracking the share of A/R over 90 days against the target of under 15-18% (best practice under 10%), since the aged bucket is where revenue quietly turns into bad debt.
✓ Producing a blended Days-in-A/R figure across all tracked months on the Benchmark & Trend tab, so a single bad month doesn't distort the longer-term picture.
✓ Returning a plain-language verdict — strong, acceptable, or needs attention — that tells the practice whether to protect the process or audit claim follow-up, denials, and the 90+ bucket.
✓ Comparing performance against external benchmarks so a practice knows whether its A/R turns faster or slower than peers, not just whether it's moving.
✓ Supporting board, owner, or management reporting with a clean monthly trend and benchmark comparison that's easy to present and defend.

Who uses it

The tracker is used by the people accountable for cash flow and the speed of collections — from hands-on A/R staff to practice owners. It gives each of them the same number, calculated the same way, every month.

Revenue cycle managersDays in A/R is their headline KPI; the tracker lets them monitor the trend, grade it against benchmarks, and pinpoint when collections start slowing before it shows up in cash flow.

Billing managers and A/R supervisorsThey use the monthly status flags and the 90+ bucket to decide where to direct follow-up effort — a rising Days-in-A/R or aged bucket signals where the team should focus.

Practice managers and administratorsThey report cash-cycle health to owners and use the blended figure and verdict as a defensible, benchmark-anchored summary of how the revenue cycle is performing.

Practice owners and physiciansThey care about how fast the practice converts care into cash, and the Green/Amber/Red trend gives them a non-technical read on whether the billing operation is healthy.

Billing-company account leadsCompanies billing for multiple clients use a standardized Days-in-A/R tracker per client to demonstrate performance and flag accounts whose collections are drifting.

Context & good to know

Days in A/R is the metric every revenue-cycle leader watches first because it compresses the entire collections process into one number: how long, on average, money sits unpaid after a service is billed. A practice can have a good clean-claim rate and still have rising Days in A/R if denials aren't worked promptly or the 90+ aging bucket is growing — which is why the tracker pairs the headline figure with the percent over 90 days. Together they show both the average speed of collection and the tail of stubborn, hard-to-recover claims.

The benchmarks the tracker uses are widely referenced industry standards: best-practice Days in A/R under 30, acceptable up to 40, and a 90+ bucket ideally under 10%. These numbers give a practice an external yardstick — without them, a Days-in-A/R figure is just a number with no sense of whether it's good or bad. The tracker's Green/Amber/Red grading and blended-trend verdict translate the raw figure into an actionable assessment, telling the practice whether to protect a strong process or audit claim follow-up, denials, and the aged bucket.

On Spotsaas, A/R analytics and aging dashboards are core to how billing platforms differentiate — many now compute Days in A/R automatically and surface the 90+ bucket without requiring a spreadsheet. The tracker is a strong starting point and a useful benchmark even for practices whose software already reports the metric, because it standardizes the definition and benchmark. It pairs naturally with the Denial Management Playbook and the Patient Statement & Collections Workflow, the two operational levers that actually move Days in A/R, and practices comparing software on Spotsaas should weigh how clearly each platform reports this KPI and its aging breakdown.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 23 medical billing software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What is Days in A/R and how is it calculated?

Days in Accounts Receivable measures how long, on average, it takes to collect payment after a service is billed. It's calculated by dividing total A/R (the ending receivable balance) by average daily charges, where average daily charges equals total charges for the period divided by the number of days in the period. For example, $480,000 in A/R against $20,000/day in charges equals 24 days in A/R. Lower is better — it means faster cash.

What is a good Days-in-A/R benchmark?

MGMA-style best practice is under 30 days; 30-40 days is acceptable but above best practice; and over 40 days needs attention. The tracker grades each month against these thresholds — Green under 30, Amber 30-40, Red over 40 — so you can see at a glance whether your collection speed is healthy or slipping relative to industry norms.

Why track the percentage of A/R over 90 days separately?

Because the average can hide a problem in the tail. A practice can have an acceptable Days-in-A/R figure while a growing share of receivables sits past 90 days — and that aged bucket rarely recovers, often becoming bad debt. The target is under 15-18% of total A/R, with best practice under 10%. Watching this number alongside Days in A/R shows both the average speed and the stubborn claims that need escalation.

How often should I update the tracker?

Monthly. Days in A/R is a trend metric — a single month tells you little, but month-over-month movement reveals whether collections are speeding up or slowing down. Enter total A/R, total charges, days in the period, and the percent over 90 days each month, and the workbook computes the metric and grades it so you can spot a deteriorating trend early.

What drives Days in A/R up?

Slow or inconsistent claim follow-up, a rising denial rate, an aging 90+ bucket that isn't being worked, eligibility errors that delay payment, and slow patient collections all push Days in A/R higher. The tracker's verdict points you to the likely culprits: if the figure is in the Red, it recommends auditing claim follow-up, denials, and the 90+ aging bucket — the operational levers that actually move the metric.

What's the difference between Days in A/R and the 90+ bucket?

Days in A/R is an average across all receivables — the typical time to collect. The 90+ bucket is a slice — the share of receivables that have aged past 90 days. The average tells you overall speed; the bucket tells you about the worst, least-collectible claims. A healthy practice keeps both low: Days in A/R under 30 and the 90+ share under 10-15%.

Does my billing software already calculate Days in A/R?

Many modern platforms compute Days in A/R automatically and display an aging dashboard with the 90+ breakdown, so you may not need a spreadsheet to see the number. The tracker is still valuable for standardizing the definition and benchmark, and for practices whose software doesn't report it clearly. When comparing platforms on Spotsaas, how prominently and clearly each one surfaces this KPI is a useful differentiator.

Can I use this tracker if I have multiple practice locations or providers?

Yes — you can track blended Days in A/R for the whole organization, or maintain a copy per location or provider to compare them. The workbook's Benchmark & Trend tab blends across the months you enter; to break it down by location you'd run a separate tracker for each. Billing companies often keep one per client to demonstrate and compare performance.

What does the tracker's verdict mean?

The Benchmark & Trend tab returns a plain-language recommendation based on your blended Days in A/R: 'strong' if you turn A/R faster than the best-practice benchmark (protect the process), 'acceptable' if you're within range but above best practice (target the 90+ bucket and denials), or 'needs attention' if collections are slow (audit claim follow-up, denials, and the aged bucket). It translates the raw number into a clear next step.

Is a lower Days in A/R always better?

Generally yes — lower Days in A/R means faster collection and healthier cash flow. The main caveat is that an artificially low figure caused by aggressive write-offs of older claims isn't truly good, because it improves the average by removing the hard claims rather than collecting them. That's why the tracker pairs Days in A/R with the 90+ bucket: together they show whether a low average reflects genuinely fast collection or just a cleaned-up tail.

Keep exploring