Enter your UCR (usual, customary, and reasonable) fees alongside the insurance allowed amounts for each procedure. Add annual volume for total impact 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 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
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.
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%.
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.
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 Rate | Gross Production ($100,000) | Write-Off Amount | Net 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.
Related Dental & Dental Practice Calculators
Dental Production per Hour Calculator
Benchmark your dental production per hour against 2026 industry targets of $438 to $625 per hour, and identify scheduling and efficiency gaps.
Use CalculatorDental & Dental PracticeTreatment Plan Value Calculator
Analyze case acceptance rates and treatment plan value with 2026 benchmarks showing the national average at 40% to 60% and top practices exceeding 70%.
Use CalculatorDental & Dental PracticeDental Overhead Percentage Calculator
Calculate your dental practice overhead percentage across staff, supplies, lab fees, rent, and technology, and compare against 2026 benchmarks of 60% to 65%.
Use CalculatorDental & Dental PracticeCrown and Bridge Material Cost Calculator
Analyze lab fee margins for crowns and bridges by material type including PFM, zirconia, e.max, and implant-supported restorations using 2026 lab fee data.
Use CalculatorDental & Dental PracticeDental Hygiene Production Calculator
Calculate hygiene revenue per hour, per provider, and hygiene department contribution to total practice production with production-to-wage ratio analysis using 2026 benchmarks of $200+ per hour.
Use CalculatorDental & Dental PracticeNew Patient Value Calculator
Calculate the lifetime value of a new dental patient including initial treatment, recall visits, case acceptance, referral value, and maximum acquisition cost using 2026 practice benchmarks.
Use CalculatorYou May Also Find Useful
Tax Calculator
Estimate your 2026 federal income tax based on filing status, gross income, deductions, and current tax brackets. See your marginal and effective tax rates instantly.
Use CalculatorFinance & AccountingSalary to Hourly Calculator
Convert your annual salary to an hourly wage instantly. Adjust for hours per week, weeks per year, and overtime to find your true hourly rate.
Use CalculatorFinance & AccountingCommission Calculator
Determine sales commissions based on revenue, rate tiers, and bonus structures.
Use Calculator