How do you turn a dental AR report into a worklist?
Before comparing dental AR benchmarks, choose one report date and keep the report settings the same each month. Separate insurance balances from patient balances. Then give each open claim a reason it's still open and an action someone can complete.
Here's a fictional insurance aging report. It shows the arithmetic, not a recommended target. Divide each bucket by the same $80,000 total; all four shares must add to 100%.
| Age | Open insurance balance | Share of total |
|---|---|---|
| 0 to 30 days | $48,000 | 60% |
| 31 to 60 days | $16,000 | 20% |
| 61 to 90 days | $8,000 | 10% |
| Over 90 days | $8,000 | 10% |
| Total | $80,000 | 100% |
The next question is what makes up that $8,000 over 90 days. If $2,000 was already received but not posted, correcting the ledger reduces open AR to $78,000 and the oldest bucket to $6,000. The new share is about 7.7%. That improvement collected no new cash. Record posting corrections separately from money recovered.
What should the biller do with each old claim?
| What you confirm | Next action |
|---|---|
| Payer has no claim on file | Find the submission response and resolve delivery through the approved route |
| Payer is waiting for information | Name the missing item, assign its owner, and save the receipt |
| Payer denied a line | Review the reason and evidence; record the response and deadline |
| Payment was issued | Match the remittance and payment before changing the ledger |
| Payment is already posted | Check the remaining balance and claim status before closing anything |
Check deadlines before sorting work only by age or dollars. Use the claim follow-up workflow for the daily queue and the adjustment posting guide when the remaining balance needs review.
If you use Open Dental, its Insurance Aging Report instructions explain the report options. Save the settings with your monthly report so a filter change doesn't look like a collection improvement.
The benchmarks
Healthy looks like this: 92% of your insurance AR is less than 30 days old, and 3% or less is over 90. Most owners who check their own report against those two numbers for the first time do not like what they find. At one four-location group, an on-site review found 88% of the insurance AR sitting over 90 days, and nobody knew.
Nobody knew because they were reading dollar totals, and dollar totals tell you almost nothing. A busy office always has a big number in AR. What matters is where the money sits. Take the dollars in each aging bucket, divide by your total insurance AR, and compare against these targets:
| Aging bucket | Healthy target |
|---|---|
| 0 to 30 days | 92% or better |
| 61 to 90 days | 5% or lower |
| Over 90 days | 3% or lower |
Here's a worked example. Say your total insurance AR is $80,000. In a healthy office, at least $73,600 of it is less than 30 days old, and no more than $2,400 is over 90 days. If your report shows $20,000 sitting in the over-90 column, that's 25%, and you have a problem worth taking seriously.
The over-90 column deserves the most attention because that's where claims die. Payers have filing deadlines and appeal deadlines, and claims that age past them stop being collectible at all.
The second number: days in AR
The aging buckets tell you where the money sits. Days in AR tells you why. It measures the time from when a claim is created to when it's genuinely finished: payment posted, claim closed, nothing left hanging.
Most offices measure this for the first time and land around 30 to 40 days. A healthy billing department runs at 7 to 10.
Why does the number climb? Think about everything that has to happen to close one claim. It has to be created correctly, sent, actually received by the payer, processed, and then the payment has to be posted and the claim closed. If any one of those steps happens when someone has time, the number grows. Days in AR looks like a financial number, but it's really a measure of whether your billing tasks have owners and schedules.
Measure it every month. One month is a data point. Twelve months is a pattern you can act on.
What's actually inside a messy AR report
Here's what surprises practice owners in almost every AR cleanup: a lot of that outstanding money isn't outstanding at all.
Some of it was already paid. The check arrived and got deposited, but the payment was never posted, or it was posted and the claim was never closed (in some software, those are two separate steps). Post it and close it, and the report shrinks without collecting a dollar.
Some of it never reached the payer. Claims stall at the clearinghouse, and nobody checks the transmission reports. Offices routinely find claims sitting unsent in a batch from six months ago. Each one would have taken two minutes to catch the week it happened.
The rest is denials nobody worked. Follow-up done when there is time is how the over-90 column fills up. And across the industry, two out of three denials are never appealed at all, which is exactly what payers are counting on.
Underneath all three, the same root causes show up again and again: turnover with no written billing process, weak insurance verification, and benefit breakdowns that were collected on the phone but never entered into the software, so every copay since has been a guess. Messy AR is the symptom. The daily process is the disease.
The part owners don't want to hear: messy AR hides theft
Insurance checks are the number one target for embezzlement in a dental office, and a messy AR report is the cover.
Think about how it works. A claim is left open in the software, so the doctor believes it was never paid. The check actually arrived, and it went somewhere else. As long as the AR report is a mess nobody trusts, an open claim raises no questions.
This isn't rare, and the losses aren't small. In one audit, an owner found out that about $115,000 was gone. The person responsible was the office manager he had trusted for seven years. And a check made out to the doctor can absolutely be cashed by someone else. It happens.
The guardrails are simple and unglamorous. The doctor, and only the doctor, opens the mail. The insurance AR report stays clean enough that an open claim means something. Someone always knows exactly where insurance money lands. Cameras don't stop this. Systems do.
One warning that goes with this section: a clean-looking AR report doesn't automatically mean the department is healthy. Sometimes it means someone knows how to make the numbers look good. The benchmarks are where the analysis starts, not where it ends.
Frequently asked questions
What percentage of dental AR should be over 90 days?
3% or less of your total insurance AR. Above that, you're past many payers' appeal windows and the money starts becoming uncollectible. Keep patient AR on a separate report. Mixing the two hides problems in both.
What is a good days in AR for a dental practice?
7 to 10 days from claim creation to closed. Most offices that have never measured it are at 30 to 40.
How do I clean up old dental insurance AR?
Start with the oldest claims and take the easy wins first. Sort the outstanding claims report oldest first. For each old claim, log into the payer portal and confirm they actually received it, because many never arrived. Post the payments that came in but were never posted, and close claims that need manual closing. Then give follow-up an owner and a schedule so the pile doesn't come back. Posting correctly as you go matters too. Here's how to post an insurance adjustment so the cleanup sticks.
