Insurance aging reports: the money sitting on your shelf

A practice producing $1.44 million a year with $186,000 sitting in accounts receivable is carrying about $66,000 more than it should, and roughly a quarter of that will never be collected at all. That money isn't lost. It's filed.

Here's the claim we'll defend: your insurance aging report is not a collections problem, it's a contracting problem, and the most valuable column on it isn't the dollar amount. It's the payer name. Most owners read the report as a worklist, assign the oldest balances to whoever has time, and feel productive when the number comes down. We think that's backwards. Aged claims cluster by payer, not by accident, and once you know which plans reliably park your claims past 60 days, you're no longer looking at a billing failure. You're looking at a fee schedule that's worse than the one you signed.

An aging report isn't a list of what you're owed. It's a list of which payers have figured out you don't follow up.

The Benchmark You're Probably Failing Without Knowing It

There are three numbers worth memorizing. A healthy practice collects 99% of production annually, holds an accounts-receivable ratio of 1.0 (total AR roughly equal to one month of average production), and keeps no more than 20% of receivables aged 60 days or older, according to Dental Economics.

Run those against our $1.44 million practice. Average monthly production is $120,000, so a healthy AR is $120,000. At $186,000, the ratio is 1.55. The excess is $66,000 of production already delivered, already costed, already paid for in supplies and payroll, and still unbilled cash.

Now the aging split. Suppose 40% of that AR sits at 60 days or more, which is $74,400 against a healthy ceiling of $37,200. You're running double the tolerable aged balance. If $44,000 of that has crossed 90 days and your historical recovery on 90-plus claims is 65%, you're writing off $15,400 a year as a matter of routine. That's 1.07% of production evaporating annually with no line item, no invoice, and nobody's name on it.

And if you're collecting 95.5% of production instead of 99%, that 3.5-point gap is $50,400 a year. Most owners we talk to can quote their production to the dollar and have no idea what their collection percentage was last quarter.

What Most Owners Get Wrong: Working the Report Instead of Ranking the Payers

The specific mistake: owners treat the aging report as a staff performance issue. The report gets long, the owner gets frustrated, the front desk gets told to "stay on top of claims," and someone spends Friday afternoons on hold. Six weeks later the report is long again. The owner concludes the problem is the hire.

Usually it isn't. It's the mix. Sort the same report by payer instead of by age and the pattern shows up immediately: two or three plans generate a disproportionate share of everything past 60 days. Those plans have higher first-pass denial rates, request attachments more often, and restart their own clocks more aggressively. The staff member isn't slower on those claims. The claims are structurally slower.

Our view: collection percentage is the wrong metric to manage this with, because it's an average that hides exactly the thing you need to see. A 95.5% collection rate across eight plans tells you nothing actionable. A payer-level report showing that one plan runs 54 days to payment while another runs 18 tells you what to do on Monday. The owners who make this mistake most often are the ones with strong production and a long-tenured business lead, because the aging report never gets bad enough to force a hard look. It just stays 50% too high forever, and $15,000 a year walks out the back.

Plan B's Real Discount Is 34.4%, Not 32%

This is where the contracting argument gets concrete. Take two plans in the same practice.

• Plan A: 1,100 claims a year, average claim $210, 18 days to payment, 6% first-pass denial rate, contracted write-off 28% off your full fee.
• Plan B: 1,400 claims a year, average claim $210, 54 days to payment, 22% first-pass denial rate, contracted write-off 32%.

On paper Plan B costs you four more points of discount. In practice it costs more than that, because somebody has to rework the denials. At the Bureau of Labor Statistics median annual wage of $45,590 for billing and posting clerks (430,220 employed nationally, mean wage $47,120), the base hourly rate is $21.92. Assume three touches to resolve a denied claim and five touches an hour, so 36 minutes of work per resolved claim, which is $13.15.

Plan B generates 308 first-pass denials a year. Reworking all of them costs $4,050 in direct wages. Plan A generates 66, costing $868.

If Plan B pays you $168,000 net a year, that $4,050 of rework is 2.4 points of your fee schedule. Add it to the contracted 32% and Plan B's real discount is 34.4%, against Plan A's 28.5%. You negotiated one number and are living with another, and the difference never appears anywhere in your P&L because it's buried inside a salary you'd be paying anyway.

That last point is the common objection: the biller is salaried, so the rework is free. It isn't. It's 185 hours a year that could have gone to treatment-plan follow-up, insurance verification before the appointment, or outstanding patient balances. Free labor is just labor you've stopped measuring.

Sixty Days Can Be Perfectly Legal, Which Changes the Fix

Owners assume a claim sitting 70 days means someone dropped it. Often nobody did. Under the North Carolina Department of Insurance prompt-pay requirement, an insurer must pay a claim or notify the claimant within 30 calendar days of receipt, and the clock restarts for another 30 days once any requested additional information arrives. One information request, properly issued, legally buys 60-plus days. Specifics vary by state, but the structure is common.

Read that as an operator and the conclusion is uncomfortable: the 60-day bucket is partly a design feature of the system, not a measure of your team's diligence. Which means chasing claims after they age is the low-value half of the job. The high-value half is never giving the payer a reason to issue the information request in the first place: narrative on the claim, perio charting attached, radiographs attached, eligibility and frequency limits checked before the patient sits down. Every attachment you send up front deletes a 30-day restart you'd otherwise be calling about in October.

We'd shift the ratio deliberately. If your business team spends 12 hours a week on aged follow-up and two on pre-submission completeness, flip it toward six and eight and watch the 60-day bucket for one quarter. The follow-up hours shrink because the denials never happen.

What $13.15 a Claim Actually Buys

None of this argues against working the report. The arithmetic on recovery is excellent. Spending $13.15 of loaded clerk time to collect a $210 claim returns roughly 16 to 1. There is almost nothing else in a dental practice with that return, which is why the practices that genuinely cannot afford a dedicated biller are usually the ones losing the most.

Put real hours on it. One person at 12 hours a week on 60-plus follow-up is 624 hours a year, or $13,678 in base wages, call it $17,500 fully burdened. If that work recovers even half of the $50,400 collection gap, it nets $7,700 and also prevents most of the $15,400 in routine 90-day write-offs. Combined, that's a $23,000 swing on a $17,500 investment.

Just don't mistake it for strategy. Recovering claims is maintenance. Repricing or exiting the plan that generates them is the decision.

When the Scorecard Says Leave

Suppose you take Plan B's admin drag seriously and start thinking about the exit. Run the Break-Even Retention Test: break-even retention equals net collections per visit under the plan divided by net collections per visit out of network.

Plan B nets $152 per visit. Out of network, those same visits net $230. Break-even retention is 66%. Keep more than two-thirds of those patients after leaving and the exit wins on collections alone.

Now fold in the drag. At 1,400 claims a year, $4,050 of rework is $2.89 per visit, so Plan B's true net is $149.11 and break-even retention falls to 64.8%. It's a 1.3-point move, not a dramatic one, and we'd rather report it honestly than inflate it. But it moves the bar in the direction that matters, and it's the only version of the number that reflects what the contract actually costs to operate.

If Plan B were in front of us at those terms, with 54-day payment and a 22% denial rate, we'd renegotiate first and set a hard date. No improvement in two quarters, we'd drop the plan.

Why the Slow Payers Get Slower From Here

Two data points suggest this pressure increases. Total dental spending rose nearly 5% in 2024 for both third-party payers and consumers, while dental benefits premiums rose just 0.1%, per the National Association of Dental Plans. More money flowing out of the system, essentially flat money flowing in. Plans close that gap through use management, which on your end looks like more information requests, more clock restarts, and a fatter 60-day bucket.

Dentists are already feeling it. Among the 29.1% of dentists who reported skepticism about the dental sector in Q1 2026, 36.3% named low reimbursement and insurance pressures as their top reason, the single largest driver, according to the ADA Health Policy Institute. That sentiment is rational. The response, though, is usually vague frustration rather than a payer-by-payer accounting, and vague frustration doesn't change a fee schedule.

Three Moves Before Friday

Pull your aging report and re-sort it by payer, not by age, then calculate days-to-payment and first-pass denial rate for each of your top five plans. Price the denial rework at your actual loaded clerk wage and add it to each plan's contracted write-off so you're holding a real effective discount, not a contracted one. Take the worst plan to renegotiation with that single number and a date attached, and run the Break-Even Retention Test on it before the meeting so you know whether you can walk. Then shift a third of your aged-follow-up hours to pre-submission completeness and recheck the 60-day bucket in 90 days.

We'll be watching one thing in particular: whether payer days-to-payment keeps stretching through 2027 as that premium-to-spending gap persists. If it tightens instead, the admin-drag argument weakens and staying in network gets cheaper, and we'll say so. If you want to see what your slowest plan is really costing against its contracted discount, our PPO-exit calculator takes your fee schedule, visit counts and net-per-visit figures and gives you the break-even retention you'd need to walk away clean. It takes about ten minutes to run your own numbers.