Solutions / Medical and dental practices / Loading a contracted fee schedule into the plans that use it

Loading a contracted fee schedule into the plans that use it

The schedule turns up as a spreadsheet or a PDF keyed by procedure code, and it has to become fee rows against the right plan before the next estimate is quoted at the desk. Write off is the gap between the office fee and the contracted one, so a schedule a year out of date produces a number the remittance later contradicts. Alternate benefit sharpens it. A posterior composite paid at the allowance for an amalgam is still written off against the contracted fee for the code that was actually billed.


Context / medical and dental practices Why this one is worth doing here

Electronic eligibility answers whether a patient is covered, and then somebody opens the payer portal anyway to find out what is actually payable.

There is a mandated electronic standard for eligibility, and it works. It confirms that a plan is active. What it routinely omits is the detail the front desk actually needs: frequency limitations, waiting periods, alternate benefit provisions and remaining annual maximum. That gap is the origin of most manual verification in this sector.

Systems this usually touches

  • Open Dental
  • Dentrix
  • Excel

When this is the wrong thing to build

Pick something else if the practice is out of network everywhere and quotes from a single fee list, or if plans were set up with write offs entered by hand on each claim, because importing a schedule over that arrangement gives two different answers for one estimate.

The constraint that shapes it

A practice is a covered entity, and any vendor that creates, receives, maintains or transmits protected health information on its behalf is a business associate, which requires a written agreement in place before any disclosure. More on how this sector works.

The same shape elsewhere / Document extraction 12 sectors run it

A file arrives. The fields come back typed and checkable. Read what this shape is, or start from one of these.

Real estate
Reading dates out of a ratified contract
Real estate
Abstracting a commercial lease into dated fields
Real estate
Filling an MLS input sheet from the listing agreement
Law firms
Turning a docket entry into a calendar
Law firms
Turning a delivered transcript into a usable set of cites
Law firms
Coding a filing fee to the matter that will repay it
What people ask about this 5 of them
  • How do I import a PPO fee schedule into Open Dental?
  • Why is the insurance estimate at checkout different from what the payer paid?
  • How does a downgrade to amalgam affect the write off?
  • Where do I get an updated contracted fee schedule from a payer?
  • How often do PPO fee schedules actually change?

Back to medical and dental practices, or see how this is priced and scoped.