Profession Calculators
Dental & Dental PracticePopular

Dental Insurance Write-Off Calculator

Compare your UCR fees against PPO and insurance fee schedules to calculate total write-offs, effective reimbursement rates, and revenue impact per procedure.

Share:
Procedure Fee Comparison

Enter your UCR (usual, customary, and reasonable) fees alongside the insurance allowed amounts for each procedure. Add annual volume for total impact analysis.

Procedure 1
UCR Fee ($)
Insurance Fee ($)
Annual Volume
Procedure 2
UCR Fee ($)
Insurance Fee ($)
Annual Volume
Procedure 3
UCR Fee ($)
Insurance Fee ($)
Annual Volume
Procedure 4
UCR Fee ($)
Insurance Fee ($)
Annual Volume
Write-Off Analysis

Enter your UCR fees and insurance allowed amounts per procedure to analyze your total write-off exposure and effective reimbursement rate.

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

A dental practice billing $1.1 million in gross production and collecting $820,000 has written off $280,000, about 25.5% of everything it produced. That write-off figure is not a rounding error. It is the direct cost of insurance participation, and most dentists do not track it precisely enough to understand which contracts are worth renewing. The American Dental Association has documented steady fee compression from major PPO networks over the past decade, with some plan fees 20 to 40% below the dentist's usual and customary rate. This calculator takes your gross production, the contracted fee schedules or write-off percentages for each insurance plan, and returns your total write-off amount and effective net collection rate so you can evaluate individual plan profitability and make data-driven contract decisions.

What This Calculator Does

This calculator takes your gross production and your contracted fee reductions (by insurance plan or as a blended percentage) for a given period, then returns the total write-off dollar amount, the write-off percentage, and your net collectible production after adjustments. It helps you understand what portion of your billed production you are giving back to insurance plans, compare write-off rates by carrier, and identify contracts where the fee schedule has eroded to the point that participation may no longer be profitable.

The Formula

Write-Off Amount ($) = Gross Production x Write-Off Rate (%) | Net Collectible = Gross Production - Write-Off Amount

Write-off rate is the percentage difference between your full fee and the contracted insurance fee. If your fee for a crown is $1,400 and the insurance contracted rate is $980, the write-off rate is ($1,400 - $980) / $1,400 = 30%. Applying this rate to your gross production gives the total dollar value written off. Net collectible production equals gross production minus total write-offs. Tracking this by plan reveals which carriers are creating the largest discount burden.

Step-by-Step Example

1

Identify gross production by insurance plan

Pull a production report from your practice management software filtered by insurance carrier. Example: Delta Dental PPO patients generated $38,000 in gross production in Q1. Cigna PPO patients generated $22,500. Out-of-pocket (FFS) patients generated $18,000.

2

Determine the write-off rate for each plan

Find your contracted fee schedule write-off rate per plan. If your full crown fee is $1,400 and Delta's contracted rate is $980, the write-off rate is 30%. If Cigna pays $1,050, their rate is 25%. Your FFS rate is 0%.

3

Calculate write-off by plan

Delta: $38,000 x 30% = $11,400 written off. Cigna: $22,500 x 25% = $5,625 written off. FFS: $18,000 x 0% = $0. Total write-offs: $17,025 on $78,500 gross production = 21.7% blended write-off rate.

4

Calculate net collectible production

Net collectible = $78,500 - $17,025 = $61,475. This is your expected collections baseline before any patient portion adjustments. If actual collections fall below this number, investigate patient payment follow-up and deductible tracking.

Real-World Use Cases

Annual Insurance Contract Renegotiation

A practice manager preparing for annual contract review runs the write-off calculator for each participating carrier. One plan shows a 34% write-off rate on $47,000 in gross production, equaling $15,980 written off. After comparing this to the overhead cost of seeing those patients and the volume of patients who would likely remain with the practice if the plan was dropped, management initiates a fee renegotiation with data in hand.

Evaluating Whether to Drop a Low-Fee PPO

A dentist is considering dropping a plan that reimburses 60 cents on the dollar (40% write-off). The plan accounts for $31,000 in quarterly gross production, meaning $12,400 is written off. After subtracting overhead for those hours, the net contribution is minimal. The calculator makes this visible and supports the decision to drop or renegotiate before the next renewal period.

Setting Net Production Targets for Staff Incentive Bonuses

A practice wants to set a staff bonus based on net production rather than gross production. Running the write-off calculator monthly allows the team to see the actual net collectible figure, aligning bonus targets with real revenue rather than an inflated gross number that includes write-offs.

Comparison

Write-Off RateGross Production ($100,000)Write-Off AmountNet Collectible
10%$100,000$10,000$90,000
15%$100,000$15,000$85,000
20%$100,000$20,000$80,000
25%$100,000$25,000$75,000
30%$100,000$30,000$70,000
40%$100,000$40,000$60,000

Common Mistakes to Avoid

  • Confusing write-offs with uncollected accounts receivable. Write-offs are the contractual adjustment between your full fee and the insurance-contracted rate. Bad debt (patients who owe money and do not pay) is a separate problem. Mixing these two distorts both your write-off rate and your collections efficiency metrics.

  • Applying the same blended write-off rate to all production without separating by plan. A blended 22% average hides the fact that one plan may be at 35% and another at 12%. The high-write-off plan deserves individual attention; the blended figure masks it.

  • Failing to update write-off rates when insurance fee schedules change. Many carriers quietly reduce fees at contract renewal. If your practice management software does not automatically update contracted fees, the write-off calculation becomes inaccurate and you may unknowingly be writing off more than you realize.

Frequently Asked Questions

Accuracy and Disclaimer

This calculator provides write-off estimates based on the production figures and write-off rates you enter. Results are for internal analysis purposes only and do not constitute financial, legal, or contracting advice. Insurance contract terms, fee schedules, and reimbursement policies vary by carrier and region. Consult a dental-specific CPA, billing specialist, or attorney before making decisions about insurance participation.

Conclusion

Insurance write-offs are the largest invisible expense in most dental practices. A carrier paying 68 cents on the dollar is not just reducing your revenue, it is also consuming chair time that could be used for higher-fee-for-service production. Use this alongside the Dental Overhead Calculator to see how write-off rate affects your true overhead percentage, and run the Dental Production Per Hour Calculator to calculate what your effective production rate looks like after insurance adjustments.