PPO Write-Off & Ranking Worksheet

Every practice has a production report that makes it look busier than it is paid. This worksheet is the eight-step math for finding out which PPO plan is actually costing you the most: pull a three-month production report, compare your full fee to each plan's allowed fee across the top ten procedures you bill, and let the formulas turn that into lost revenue per year.

The write-off percentage is the loudest number, but it isn't the only one that decides which plan to drop first. The second sheet scores every plan on patient count, admin friction and growth potential too, because the plan costing you the most on paper isn't always the plan you should touch first. There's no formula that blends those four columns into one score, on purpose: read the table left to right and use your own judgment, the way the article that this worksheet is built from describes it.

What's inside#

• Write-Off by Plan: monthly and annual lost revenue by formula, break-even patient loss percentage, and a rank by dollars lost
• Fee Comparison: the same ten CDT codes used in the source article, with your full fee against up to four plans' allowed fees, averaged into each plan's write-off percentage
• An illustrative example table showing how four plans score across write-off percent, patient count, admin friction and growth potential
• A Notes sheet explaining every input, formula and the sequencing logic, with sources

How to use it#

1. Pull a three-month production report by plan, by doctor, and by hygiene.
2. On the Fee Comparison sheet, enter your full fee and each plan's allowed fee for the ten listed procedures; the discount percentage and each plan's average write-off percentage calculate automatically.
3. On Write-Off by Plan, enter each plan's average monthly production, patient count, admin friction and growth potential; the lost revenue, break-even patient loss and dollar rank calculate automatically.
4. Read the table left to right: your smallest, simplest plan is the rehearsal, not necessarily your worst-paying one.
5. Run your worst two or three plans through the PPO drop calculator before you tell anyone which one is going first.