Two ways Open Dental shows unpaid insurance, and why they disagree

The two reports and what each answers

Report names and menu positions move between Open Dental versions, so it is safer to think in terms of what a view is built from than what it is called this year. There are two shapes. One starts with account balances. One starts with claim records. Everything else about the confusion follows from that single difference.

The aging view

Built from balances. It takes what the ledger says is owed, separates the portion the system expects insurance to cover from the portion the patient owes, and drops each amount into a bucket based on how long it has been sitting there. Its unit is money on an account. When a balance moves, the aging moves with it, immediately, without anyone touching a claim.

The outstanding claims view

Built from claim records. It lists claims whose status still says unresolved, generally with the payer, the date the claim was sent, and the amount billed. Its unit is a claim. A claim stays on this list until the claim record itself is marked finished, no matter what the ledger already did.

Now put a single ordinary claim through both. The payer paid it last week. Somebody posted the payment against the account correctly, so the account balance dropped that day, which means the insurance portion of that balance dropped, which means the aging view stopped showing it at once. Nothing else had to happen for that to be true.

The claim record is a separate object. Until somebody opens it and marks it as received, it still carries an unresolved status, so it is still on the outstanding claims view. On Monday morning the aging view says that money is no longer owed and the claim view says that work is still sitting with a payer. Same office, same day, two truthful answers, because two different questions were asked.

That is why the question of which report is right does not have an answer. The useful question is which job you are doing. And the follow up question, the one that actually earns money back, is what the difference between the two totals is made of, because that difference is a work list.

Why their totals differ

Five things account for most of what you will find in the gap. They are worth going through in order, because the first one is the cheapest to clear and clearing it tells you how much of the gap the other four have to explain.

1. 1Claims received but never closed. The payer paid, the payment was posted, the account balance went down, and nobody went back to the claim record to mark it finished. The aging view has already forgotten it. The claim list has not. Clear this one first: it grows quietly because nothing about it looks like an error, and clearing it is mechanical work rather than detective work, so it is the cheapest way to find out how much of the gap it was.
2. 2Estimated insurance against what was billed. The aging view is working from what the system expects insurance to pay, calculated from the plan and fee information on file. The claim list shows the amount that actually went out on the claim. Those two figures agree only when the estimate was correct. Every plan that changed, every fee schedule that was updated after treatment was planned, and every estimate nobody revisited widens the gap without breaking anything.
3. 3Preauthorizations counted as claims. A request for approval is stored much like a claim, and if the claim view is not filtered to leave those out, it is counting paperwork that was never a bill. Nobody owes money on a preauthorization. It still ages like a real claim, so it lands in the older buckets and makes the list look worse than the practice is.
4. 4Secondary claims that have not been sent. They exist as claim records, they are attached to real treatment, and they have never reached a payer. They are outstanding in the sense that something still has to happen, and not outstanding in the sense that a payer is sitting on them. Whether they appear depends entirely on how the claim view is filtered.
5. 5Which party the balance is assigned to. A balance can sit against the guarantor rather than against the patient who was treated, and a view built around one will not show it where you go looking. This matters most for families. One guarantor with several patients can appear as several balances or as one, depending on which view produced the export, and that is a real source of double counting the moment somebody pulls both into a spreadsheet and adds up the columns.

Which one to use for which job

Pick the view by the job in front of you, not by which total you like better.

Calling payers about unpaid work

The claim list. A payer conversation needs a claim: the date it went out, the amount billed, the payer, the patient. An aging bucket cannot tell you which claim to ask about, so working from it means guessing at the ledger and calling about money that may already have arrived.

Saying what the practice is owed

The aging view. It is denominated in money, it splits the insurance portion from the patient portion, and it is comparable month to month because it is built the same way every time. This is the number for an owner conversation or a monthly review.

Finding claims near a filing deadline

The claim list, aged from the original date of service rather than from the last date the claim was sent. If your view ages from the date sent, every resubmission makes an old claim look new and the claims closest to a deadline hide in the newest bucket.

Deciding who gets a statement

Neither one on its own. The decision depends on whether a claim is still outstanding AND on the estimated insurance figure for that account at the same time, and only looking at both together answers it.

When custom aging is the right tool

Open Dental can age balances as of a date you choose rather than as of today. It is easy to treat that as a curiosity, and it is easy to reach for it in the wrong situation, so it is worth being precise about the one job it is genuinely required for.

The job it is for

Comparing today against a month end that has already gone by. Standard aging recalculates against the current date every time it runs, which means it cannot tell you what the report said at the end of March. It tells you how the balances that exist right now would be aged if you pretended it was March, which is a different sentence. If you need the March figure itself and nobody saved it, the honest answer is that it is gone, and the useful habit is to start saving the total each month so the comparison exists next time.

Claims that are sent but not received

There is one category both views handle badly, and it is not a flaw in either of them. A claim can be marked sent inside the practice software and never have arrived at the payer at all. The software records what it did. It has no way of knowing what the payer received, because nothing ever came back to tell it.

So a claim in this state looks completely normal. It sits on the outstanding claims view with a sent date, aging steadily, indistinguishable from a claim a payer is genuinely working. It contributes to the insurance portion of the balance on the aging view too. Both views are reporting exactly what they were told. Neither can see the gap.

What actually settles it

• The clearinghouse acknowledgement, not the sent flag. The acknowledgement is the first piece of evidence created outside your own building, and it is the only one that shows a claim left the practice and was accepted downstream.
• The payer confirmation of receipt. A payer that can find the claim by number has it. A payer that cannot find it by number, by patient, or by date of service does not, no matter what the sent column says.
• The absence of a rejection is not evidence. A claim can fail before it ever reaches the payer and produce a report nobody opened, which reads inside the office as silence.

This is the case where working from either view alone will keep an office busy and get nowhere, because both of them will keep showing the claim, correctly, forever. What to do when a payer says the claim never arrived is its own subject, covered in what to do when insurance says they never received the claim. The broader question of why two reports in the same system disagree at all is covered in why your A/R numbers do not match, and the estimate that sits underneath the aging view is covered in estimated insurance and your A/R.