Why Open Dental's Procedures Not Billed to Ins Report Under-Counts Your Real Number

Every Open Dental practice has a report that is supposed to answer one question: are we billing everything we finished? The report is called Procedures Not Billed to Ins, and most offices trust it completely.

In a de-identified twelve-month audit of one practice’s own database, that report surfaced 3.4 percent of the never-billed work in the system, measured by dollar value of the procedures. The other 96.6 percent was structurally invisible to the practice’s own report, not lost, not hidden by anyone, simply excluded by design.

We do not publish a dollar figure for that gap. How much of it is money owed depends on what each patient already paid. That is the next question, and we answer it by running the collection split against your own data, not by estimating.

What does the Procedures Not Billed to Ins report actually check for?

According to Open Dental’s own manual, the report lists a procedure only if the procedure has a fee and the patient has an active insurance plan attached, and it always excludes any procedure marked Do Not Bill Ins. Those are the three tests, and all three have to pass for a procedure to appear at all.

Each filter reads as sensible in isolation. A procedure with no fee is not billable. A patient with no active plan has nothing to bill against. A procedure flagged do-not-bill was excluded on purpose. But run all three together and a fourth thing happens that the report’s designer was not solving for: every filter is a data-completeness test wearing the costume of a relevance test. A procedure fails to appear for the exact same reasons it never got billed in the first place. The report cannot distinguish “this should not be billed” from “we do not have the data needed to bill this.”

Where did the invisible 96.6 percent actually go?

In the audited practice, the gap split three ways, and the split itself is the diagnostic.

No insurance plan on the patient record accounted for 85 percent of the never-billed work. This is not a case of a patient declining coverage. It is a patient record where the plan was never attached in the system, so the procedure never had anything to bill against and never qualified for the report in the first place.

A plan attached but missing a fee schedule accounted for 19 percent. The patient has coverage on file. The system has no rate table to estimate against. Same invisibility, different cause. In this practice, 434 of 575 insurance plans on file carried no fee schedule at all.

A do-not-bill flag accounted for roughly zero, effectively noise. The report’s third filter, the one it was arguably built for, explained almost none of the gap. The shares sum to slightly over 100 percent because a small number of procedures carried more than one cause. They are shares of the never-billed work, not of money owed.

Why does a worse intake process make the report look cleaner, not worse?

This is the part that should worry a practice more than the dollar figure. The report only shows what clears all three filters. The more procedures that fail those filters, the shorter and tidier the report looks. A practice with clean intake data sees its real backlog reflected honestly. A practice with gaps in plan attachment or fee schedule setup sees a short, reassuring list, precisely because the incomplete work has already been filtered out before anyone looks at the screen.

Ask the question “are we billing everything” and the report answers yes with more confidence exactly when the underlying data is worst. That is not a training problem. Training assumes staff already know there is a category of work to go looking for. Here, the report itself is the thing telling them there is not.

Filter	What it checks	Share of the never-billed work, by dollar value
Active insurance plan on patient	Plan attached to the patient record	85%
Fee schedule on the plan	Rate table configured for that plan	19%
Do Not Bill Ins flag	Manual exclusion marker	roughly 0%
Total invisible to the native report		96.6%

Does this mean that work is all money owed?

No, and this has to be said before the ratio, not after it. The comparison measures what the report can and cannot display. It does not measure what a patient already paid, and a procedure a patient settled in cash is not an uncollected balance no matter which filter hid it. Timely filing limits then govern how much of whatever remains can still be filed at all. Those are two separate questions from the one this report answers, which is why we publish the ratio and not a dollar total.

What holds up regardless of timely filing is the ratio itself and the mechanism that produces it. Any Open Dental practice running the same report with the same inclusion logic will under-count in proportion to its own intake gaps. The worse the data, the larger the invisible share, by construction, not by chance.

Is this specific to one practice, or does the mechanism generalize?

The mechanism is a property of the report’s logic, not of any single office. Every Open Dental installation applies the same three-part inclusion rule: fee present, active plan present, not flagged do-not-bill. A practice with tight intake discipline, where every patient’s plan is attached and every plan carries a fee schedule, will see a report that closely tracks reality. A practice with common intake gaps, patients whose plans were never linked, plans onboarded without a fee schedule configured, will see a report that looks clean while a large balance sits outside its view. The size of the gap will differ practice to practice. The direction of the error will not: it always under-counts, never over-counts, because every excluded procedure is real completed work, not a false positive.

What should a practice actually check first?

Run a count of completed, fee-bearing procedures in a fixed window with no claim ever attached, then compare that number to what the Procedures Not Billed to Ins report shows for the same window with the same date range settings. The difference between those two numbers is the size of the blind spot. Break the difference down by the same three reasons: no plan attached, plan with no fee schedule, and do-not-bill flag. That breakdown tells you which fix moves the needle first, and in most cases it will be the plan-attachment and fee-schedule gaps, not a policy about who gets flagged do-not-bill.

Attaching fee schedules to plans that are missing one is the fastest fix available, because it is a configuration change with no clinical review required, and it makes that entire share of the balance visible to the practice’s own report the moment it is done.

Where this comes from: the report’s inclusion logic is documented at opendental.com/manual, “Procedures Not Billed to Insurance Report.” The 96.6 percent gap and the three-way cause breakdown are drawn from a de-identified 12-month audit run directly against one practice’s Open Dental database via the Open Dental API, read-only, with the underlying query versioned and reproducible. That run measured what the report displays against what the procedure log contains, and every share quoted here is by dollar value of the procedures rather than by procedure count. It did not check what patients had already paid, so no dollar total from it is published here as identified or uncollected revenue.

If you want to know what your own report is not showing you, ClaimRail runs a free audit against your own Open Dental data and shows you the gap between what your report says and what actually happened.