Dental Insurance Aging Report: What It Shows You
By Robert Del Grande · November 19, 2026 · 7 min read
The short answer
A dental insurance aging report lists every claim your office sent to insurance that hasn't been paid yet, sorted by how many days it's been outstanding. Most practice management software breaks it into 0 to 30, 31 to 60, 61 to 90, and 90-plus day buckets, so your billing team knows which claims to work first. Read it by payer and by age, not just by total dollars, or you'll miss claims that are close to a payer's timely filing limit.
Every dental practice that takes insurance ends up with a list of claims that are billed but not paid. A dental insurance aging report is how you see that list in one place, sorted by how long each claim has been open. Pull it wrong, or ignore it, and claims sit past a payer's filing deadline before anyone notices. We hear the same question from office managers every week: which claims do I work first, and what does each column on this report actually mean?
What a Dental Insurance Aging Report Shows
A dental insurance aging report is a list of every claim a dental office has billed to a payer that has not yet been paid in full. Each line usually shows the patient's name, the payer, the date of service, the amount billed, the amount still owed, and the number of days since the claim was sent. Most practice management software groups these claims into age buckets, typically 0 to 30 days, 31 to 60 days, 61 to 90 days, and 90 days or more. A claim sitting in the 90-plus bucket is not automatically a lost claim, but it is a claim close to or past many payers' timely filing limits, where the payer can deny it outright for being late. The report exists so a billing team can work claims by age instead of guessing which ones need attention, and so a practice can see, payer by payer, where its money is actually stuck.
The best version of this report is the one your team actually opens every week, sorted by payer and by days outstanding, not a total that sits unread at the bottom of a menu.
How the 30, 60, and 90 Day Buckets Work
Think of the buckets as a triage list, not just a timestamp. A claim in the 0 to 30 day bucket is still inside most payers' normal turnaround time, so it may not need a call yet, just a check that it was received. A claim in the 31 to 60 day bucket has gone past normal turnaround for most payers, so this is where a first follow-up call or portal check makes sense. A claim in the 61 to 90 day bucket needs a person looking at the actual payer response, not another wait. A claim past 90 days needs to be checked against that payer's timely filing limit before anyone decides it's still worth chasing.
If your practice sends 40 claims a week and even one in ten lands in the 60-plus bucket, that's 4 claims a week, or about 200 claims a year, sitting past normal turnaround. Run that math on your own claim volume to see what a stalled aging report actually costs in hours your billing team spends finding and rechasing old claims, not revenue promised, just time.
How to Get an Aging Report From Your Practice Software
Every major dental practice management system has a built-in insurance aging report. In Open Dental, it's under Reports, then Standard Reports, listed as either the Insurance Aging Report or the Outstanding Insurance Claims Report, depending on which view you want. In Dentrix, go to the Office Manager, click Reports, point to Ledger, then click Insurance Aging Report, and choose whether to include dental carriers, medical carriers, or both. Eaglesoft and most other systems use the same report under Reports or Ledger.
Run it by payer, not just by total, and sort by days outstanding so the oldest claims show at the top. Pulling the report is the easy part. The harder part is deciding what to do with each line, which claims need a call, which need a corrected resubmission, and which are actually paid but just not posted yet.
Working the Report: What to Check at Each Stage
Working an aging report means doing something with each claim, not just reading the total. For claims 31 to 60 days old, check the payer's portal or call to confirm the claim was received and is in process. For claims 61 to 90 days old, pull the actual denial code if there is one. A missing modifier, a missing attachment, or a frequency limit on a procedure are common reasons claims stall at this stage.
Claims that are both old and only partly paid are often a coordination of benefits problem, where the primary and secondary plan didn't apply in the right order, so a balance sits on the patient's account instead of getting billed correctly to the second plan. For anything near a deadline, check the payer's own timely filing limit before writing a claim off. Aetna, for example, publishes its own limit, and you can look it up by name on Aetna's payer page. An aging report that never gets worked turns into dental accounts receivable that only grows, because every unworked claim just ages into the next, worse bucket.
What Valian's e-Reporting Adds
A practice management system's built-in aging report is a list. At Valian, e-Reporting takes the same claims and shows what was billed, paid, and still owed, by claim and by payer, so a dental insurance aging report turns into a worklist instead of a spreadsheet to sort through by hand. When a payer answers a claim, we post what they paid and what the patient still owes straight to that claim. We also follow up on every open claim with the payer and show what each claim still needs, whether that's a resubmission, a call, or an appeal, instead of leaving your team to guess from a stale report.
Medical and chiropractic claims are built in the Valian dashboard and sent electronically today, and we review every claim before it goes. If you want this kind of reporting built into the same dental billing software you use to send claims, rather than a report you export and sort by hand, that's what our dental billing services and revenue cycle analytics software are built for.
Your billing, streamlined in our software. Keep managing it yourself, or have us take it over.
If you want to see how that works for your practice, you can Book a discovery call.