Dental Aging Reports: How to Read and Work Your A/R by Bucket
How to read a dental accounts receivable aging report, separate insurance from patient balances, set benchmarks by bucket, and run a weekly workflow that keeps A/R from aging out.
Dental Aging Reports: How to Read and Work Your A/R by Bucket
TL;DR
- Always split the aging report into insurance A/R and patient A/R. They are different problems with different solutions.
- Healthy practices keep more than three quarters of total A/R inside the zero to thirty day bucket.
- Total A/R should sit near one month of average production. Twice that is a collection problem, not a growth problem.
- Work the report weekly by bucket with a named owner. Monthly review is too slow to save claims approaching timely filing limits.
- Anything over ninety days is where money actually disappears, and most of it was preventable at the front desk.
What an Aging Report Shows
An accounts receivable aging report groups every outstanding balance by how long it has been unpaid, counted from the date of service or the claim submission date depending on your software setting. Standard buckets are zero to thirty, thirty-one to sixty, sixty-one to ninety, and over ninety days.
The report is only useful if it is run separately for insurance and patient balances. A combined report hides which side is failing, and the two require entirely different work: insurance A/R is claim follow-up and appeals, patient A/R is communication, payment options, and front-desk collection policy.
Benchmarks by Bucket
| Bucket | Healthy share of total A/R | What it means when it is high |
|---|---|---|
| 0 to 30 days | 75% or more | Normal processing time |
| 31 to 60 days | 10 to 15% | Follow-up cadence is slipping |
| 61 to 90 days | 5% or less | Claims are stalling or being ignored |
| Over 90 days | Under 10%, ideally under 5% | Real risk of permanent loss |
Two summary numbers are worth tracking alongside the buckets. Total A/R divided by average monthly production should be at or below one. Insurance A/R over ninety days as a percentage of total insurance A/R should be under five percent, because beyond that timely filing limits start closing.
Working the Insurance Side
Insurance claims older than thirty days are almost always in one of four states: never received by the carrier, rejected at the clearinghouse and never reworked, pending clinical review or missing an attachment, or denied with nobody assigned to appeal.
Work them in a fixed order. Start with the over-ninety bucket because it is closest to timely filing loss, then work sixty-one to ninety, then thirty-one to sixty. Within each bucket sort by dollar amount descending. For each claim, confirm receipt, get a status and a reference number, identify the specific obstacle, resolve it that day where possible, and log the contact with the date and representative name.
If the same reason code keeps appearing, stop working claims for a moment and fix the upstream cause. Twenty claims denied for the same missing attachment is one process problem, not twenty separate incidents.
Working the Patient Side
Patient balances behave differently. Collectability falls sharply with age, and a balance past six months is largely lost. The leverage is almost entirely upstream: accurate treatment estimates before treatment, collecting the estimated patient portion at the time of service, a card on file or a payment plan for larger cases, and a written financial policy the patient has actually seen.
For balances that do exist, use a predictable escalation: a statement at the time the balance is created, a text or email reminder at two weeks, a phone call at thirty days, a firmer written notice at sixty days, and a decision at ninety days about a payment plan or outside collections. Consistency matters more than intensity, because patients learn what your practice actually does.
Credit Balances Are Not Free Money
Aging reports also surface credit balances, and they are frequently ignored. Most arise from duplicate insurance payments or patient overpayments after an estimate came in high. Unrefunded credits are a compliance exposure and often a state unclaimed property obligation. Review the credit balance report monthly and refund promptly.
A Weekly Workflow That Holds
Assign a named owner for insurance A/R and a named owner for patient A/R. Block two hours weekly for each. Start every session in the oldest bucket. Require a documented note on every account touched. Report three numbers to the owner each month: total A/R as a multiple of monthly production, the percentage over ninety days, and the net collection percentage against net production.
The practices that stay clean are not the ones that work harder on collections; they are the ones that look at the report every week so nothing has a chance to get old.
Frequently Asked Questions
What is a dental aging report?
It is a report that groups outstanding account balances by how long they have been unpaid, typically in thirty-day buckets, so the practice can prioritize follow-up on the oldest and most at-risk balances.
What is a healthy accounts receivable level for a dental practice?
Total accounts receivable of roughly one month of average production, with more than seventy-five percent of it inside the zero to thirty day bucket and less than ten percent over ninety days.
How often should a dental practice work its aging report?
Weekly. Monthly review allows claims to drift toward timely filing deadlines and lets patient balances age past the point where they are realistically collectible.
Should insurance and patient A/R be tracked separately?
Yes. They have different causes, different owners, and different remedies. A combined report obscures whether the problem is claim follow-up or front-desk collection.
When should a dental practice send a balance to collections?
Usually after ninety to one hundred twenty days with a documented sequence of statements, reminders, and at least one direct conversation, and after a payment plan has been offered.
What causes accounts receivable over ninety days?
Rejected claims that were never reworked, denials that were never appealed, missing attachments, incorrect insurance information collected at intake, and patient balances that were never estimated or collected at the time of service.