DenQAI decision lab

Payer offer comparison

Compare allowed amounts code by code using actual volume, collection probability, direct cost, and chair time.

Read the method
Illustrative example values. Changes stay in this browser tab; DenQAI does not upload or save them.

Calculator 04

Insurance fee-schedule comparator

Do not judge a network by a headline discount. Weight every offered code by the practice’s real utilization, collection, time, and direct cost—and read the contract that controls how claims are processed.

Download template

Use the template headers for the cleanest import.

Procedure codeOffice feeCurrent allowedOffered allowedAnnual unitsVariable costChair min.Offer / officeAnnual changeContribution / chair hr.SignalRow
$0Enter data
$0Enter data
$0Enter data
Weighted offer / office fees
Offer vs. current annual revenue$0
Modeled cash after collection$0
Contribution after direct + admin cost$0
Weighted contribution / chair hour
Annual modeled units0
Fee schedule questions
  • Which codes drive the most total revenue and write-off?
  • Are preventive codes attractive while high-cost or high-time services are deeply discounted?
  • Does the offered schedule beat the current contract after real utilization?
  • What access, wait-time, location, or patient-volume leverage can be documented?
Contract questions
  • Bundling, downcoding, LEAT, alternate benefits, and non-billable policies
  • Network leasing, silent PPO access, most-favored-nation terms, and plan hierarchy
  • Unilateral amendments, notice, termination, appeals, audits, recoupments, and records
  • Noncovered-service limits, assignment, virtual-card fees, and credentialing after a sale

Method, not magic

Every output should create a diligence request.

01Reconcile

Use adjusted production, collections, units, provider days, patients, and source reports. One percentage cannot carry the conclusion.

02Segment

Separate provider, procedure family, payer, patient cohort, and month. A blended average can hide the exact thing the buyer will lose.

03Stress

Run buyer-fit, staff-loss, no-show, denial, wage-reset, and entrant cases. Record the case that breaks the deal.