Practice Evolved
Log in
Reading your reports

Your insurance aging report, decoded

An insurance aging report lists the claims your office has sent to payers that have not been paid yet, grouped by how long they have been waiting. It is a list of what is outstanding, not a list of what you are owed, and the difference between those two sentences is where most of the confusion about this report lives.

What the report actually counts

Every practice management system has some version of this report. The names differ, the columns differ, and the totals almost never agree with each other. What they share is the underlying question: which claims have left this office and not come back resolved.

That is a narrower question than it sounds. A claim on the report is a claim that is open. It is not a promise. The payer has not agreed to pay it, may pay part of it, may decide the patient owes it, and may already have paid it without anyone here closing the claim out. So the total at the bottom is best read as the amount you have billed and are still waiting on, which is a signal worth working, rather than as revenue you have earned and not received.

The path of a dental claim, and the three points where it can stopA claim goes from your office to a clearinghouse, then to the payer, then to paid. It can stop at the clearinghouse as a rejection, at the payer as a request for information, or at the payer as a denial. Only the last of these is a denial.Submittedleaves your officeClearinghouseformat and eligibilityPayeradjudicationPaidor patient balanceRejectionnever adjudicatedNeeds infopending, not refusedDenialdecided, and declinedResolvedoff your board
A claim can stop in three different places, and only the last one is a denial. Reports that pour all three into one column are the reason two people in the same office quote different numbers.

The three stopping points matter here because they age differently. A rejection usually comes back within hours and never reaches the payer, so it should not be sitting in your 90 day column. A request for information is pending on you, not on the payer. Only the third is the payer deciding and declining.

Why it disagrees with your A/R report

This is the question that sends people looking for a bug. There is rarely a bug. The insurance aging report and the accounts receivable report are counting two overlapping but different things, and the overlap is the part that confuses everyone.

Why the insurance aging total and the accounts receivable total disagreeTwo overlapping circles. The left holds claims sent but not yet decided, which sit on the insurance aging report. The right holds money owed by patients, which sits on accounts receivable. The overlap is the estimated insurance portion of an account balance, which appears on both.Insurance agingclaims sent,not yet decidedPatient A/Rmoney owedby peopleEstimatedinsuranceon both
The overlap is estimated insurance: money the practice expects a payer to send, which appears as an open claim on one report and as part of an account balance on the other.

Insurance aging is organised around the CLAIM. Accounts receivable is organised around the ACCOUNT, meaning the person or family responsible for the balance. A single treatment produces one claim and one account balance, and the estimated insurance portion sits inside both. So the two reports can both be right and still not add up to the same number.

Four things that inflate the total

When an insurance aging total looks too big to be real, it usually is, and it is usually one of these four. None of them is exotic and all four are common.

Already paid, never closed
The payer paid, the payment was posted to the account, and nobody marked the claim itself as finished. The money is in the bank and the claim is still on the report. Check this one first: it is the cheapest to rule out, and it is why a report total can grow while collections are fine.
Duplicates from resubmission
A claim was corrected and sent again, and both the original and the replacement are open. One piece of treatment, counted twice, in two different age columns.
Coverage that ended
The patient changed jobs or the plan lapsed between the appointment and the submission. The claim will never be paid by that payer, and until somebody moves the balance it ages quietly forever.
Estimates nobody revisited
The estimated insurance portion was set when the treatment was planned, using a fee schedule or a coverage table that has since changed. The claim is real; the amount attached to it is not.

The reason to name these specifically is that each has a different fix, and a total does not tell you which one you are looking at. A practice that treats the whole number as a collections problem will spend a week calling payers about claims that were paid months ago.

How to read it in five minutes

  1. Sort oldest first. Age is the only variable on this report that gets strictly worse with time, and the oldest claims are the ones closest to a filing deadline you cannot appeal your way out of.
  2. Check what the age is measured from. If your report ages a claim from the last date it was sent, every resubmission resets the clock and your oldest problems look new. Age from the date of service.
  3. Group by payer before you read a single line. If one payer turns out to own a large share of the old column, that is a conversation with a representative rather than a hundred small tasks, and grouping is the only way you find out.
  4. Separate the three stopping points. Rejections go back to whoever prepares claims. Requests for information go to whoever can pull the radiograph. Only real denials need a payer call.
  5. Close what is already paid. Before working the list, clear the claims that have a payment posted against them. Whatever that removes was never work in the first place, and you find out how much in one pass.

What a healthy board looks like

There is no published benchmark for this in dentistry, and anyone who quotes you one is quoting something they cannot source. What you can do, and what is more useful anyway, is watch your own shape over time.

The three things worth watching

  • The oldest column should be shrinking. Not zero. Shrinking. A practice that works its list will see the far right column fall over a few months and then stay low.
  • No claim should be a surprise. If a claim in the oldest column is one nobody recognises, the problem is not that claim, it is that the list is not being read.
  • One payer should not own the tail. When it does, that is a pattern rather than a backlog, and patterns are fixable in one conversation instead of fifty.

Everything above can be done from the reports your practice software already prints. The reason offices stop doing it is not that it is hard, it is that it takes an afternoon every time and the answer goes stale in a week.

The short version

  • An insurance aging report counts claims that are open, not money a payer has agreed to pay.
  • It disagrees with your accounts receivable report because the two are counting different things, not because one of them is broken.
  • Four things quietly inflate the total: claims already paid but never closed, duplicates from resubmission, claims for patients no longer covered, and estimates that were never adjusted.
  • The age of a claim should be measured from the date of service, not the date it was last sent, or resubmitting a claim makes it look new.
  • Read it oldest first and by payer, because a single practice wide total hides the payer that is actually costing you.

Read next

Why dental claims get deniedThe real reasons claims come back unpaid, which ones are yours to fix, and which are the plan working as written.Preauthorization and predetermination are not the same thingWhich one binds the payer, which is only an estimate, and when each is worth the wait.The dental insurance verification checklistEvery field worth capturing, why each one is there, and where to put the answers so they are found again.

Where this sits in Practice Evolved

Practice Evolved reads this same information out of your practice software, read only, and keeps the list current between syncs, so the four inflators above are visible rather than buried in a total. Claims are aged from the original date of service, so a resubmission does not reset the clock.

See your own numbers