How to Calculate Dental PPO Write-Offs by Carrier

Use this as a pre-recording briefing, not as article copy.

The goal is to help Joey record a practical explanation for an established private-practice owner who can see "write-offs" in the practice management system but does not trust the number enough to make a PPO decision.

Before recording, study for three things:

- The calculation problem: a blended write-off percentage hides carrier, network path, CDT code, volume, posting, and fee schedule issues.

- The cleanup problem: contractual PPO write-offs must be separated from courtesy discounts, bad debt, recoupments, refunds, claim corrections, COB timing issues, and non-PPO adjustments.

- The decision problem: write-off analysis can show where to investigate, negotiate, verify, clean up, or model further, but it should not by itself tell the practice to drop a carrier.

During recording, keep the tone practical and diagnostic. The owner is probably not asking for an accounting lecture. They are asking, "Which PPO relationship is costing us, and can I trust the report I am looking at?"

Do not draft final article prose from this guide. Use these notes to prompt Joey for definitions, report names, formulas, real examples, field warnings, and the exact language he uses with owners and office managers.

"PPO write-off" is not one practice-wide percentage. For decision-making, it is a carrier-by-carrier, network-path-by-network-path, CDT-code-by-CDT-code signal that should be weighted by the practice's actual procedure volume and verified against EOBs.

The article should move the reader away from broad assumptions:

- "Our PPO write-offs are too high."

- "Write-off means production minus collections."

- "The PMS write-off dashboard tells us which PPO is worst."

- "The carrier with the highest write-off should be dropped first."

- "A normal PPO write-off percentage exists for everyone."

And toward an evidence workflow:

- Which fees are being compared?

- Which adjustments belong in the contractual PPO write-off calculation?

- Which carrier, plan, or network path produced the allowed amount?

- Which CDT codes and procedure volumes drive the annual dollars?

- Does an EOB sample prove the PMS fee schedule and posting setup are correct?

- Is the next step negotiation, implementation cleanup, EOB verification, deeper profitability analysis, or exit planning?

The buyer-facing standard to remember: write-off percentage is a pricing signal, not a profitability verdict.

The reader is likely an established private-practice owner with an office manager or billing lead who sees write-offs every month but cannot translate them into a confident PPO decision. They may be busy, financially pressured, and unsure whether the problem is low fees, messy posting, an old loaded fee schedule, shared-network routing, or a carrier that truly needs renegotiation.

Common reader language from the audience research:

- "We are busy, but the money is not showing up."

- "I can see write-offs, but I cannot tell which plan is actually hurting us."

- "How do I know whether our PPO fee schedules are too low?"

- "Isn't write-off just production minus collections?"

- "My office manager is already overloaded."

- "I do not need another report. I need to know what to do with the numbers."

Key definitions Joey should be ready to explain simply:

- Office fee or UCR fee: the practice's own base fee for the procedure.

- Submitted fee: the amount submitted on the claim. If it differs from the office fee, confirm which baseline Unlock uses.

- PPO allowed amount: the maximum contracted or plan-allowed amount for the covered service under the applicable plan or network path.

- Payment: the carrier's payment amount after deductibles, coinsurance, plan limits, COB, and patient responsibility.

- Patient portion: the amount the EOB says belongs to the patient, before collections reality.

- Contractual PPO write-off: the difference between the practice's fee baseline and the PPO allowed amount for an in-network claim, subject to Joey's preferred baseline.

- Adjustment: a broader PMS category that may include contractual write-offs plus non-contractual items that should not be mixed into this analysis.

- Carrier-level write-off: the weighted total contractual write-off across selected claims or codes for one carrier, plan, or network path.

- Weighted write-off percentage: total contractual write-off dollars divided by total baseline fee dollars for the selected procedure mix.

Core formulas to understand before recording:

```text

per_unit_writeoff = office_or_submitted_fee - allowed_amount

annual_code_writeoff = per_unit_writeoff * annual_units

code_writeoff_percentage = per_unit_writeoff / office_or_submitted_fee

carrier_weighted_writeoff_percentage =

sum(annual_code_writeoff) / sum(office_or_submitted_fee * annual_units)

```

Important distinction:

- A high write-off can point to a low allowed amount.

- A high write-off can point to an old or wrong fee schedule in the PMS.

- A high write-off can point to all adjustments being posted under one generic category.

- A high write-off can point to the wrong network path being attached to the carrier label.

- A high write-off can still be tolerable if volume, capacity, chair time, patient mix, or broader profitability supports it.

The core article, prompt, research pack, SEO pack, and raw strategy files all point to the same practical framework:

1. Clean the category.

2. Calculate by carrier, path, code, and volume.

3. Verify with EOBs.

4. Interpret before acting.

There is a dedicated structured research pack for core-014, but no matching deep-research file was found at `research/raw/deep-research/core-014-calculate-dental-ppo-write-offs-by-carrier.md`. That gap should be noted before final drafting. The article currently relies on the core article stub, recording prompt, research pack, SEO pack, broader raw reports, and adjacent fee-economics research.

Study these research findings:

- The strongest article angle is that a blended PMS write-off percentage hides the useful signal.

- The useful unit of analysis is not "the practice" first. It is carrier or plan path, CDT code, annual units, baseline fee, allowed amount, per-unit write-off, annual write-off, write-off percentage, and EOB verification status.

- Public research supports the need for code-level and payer-level economics, but not a universal "normal PPO write-off percentage."

- ADA-related raw research supports EOB interpretation, COB caution, contract review, network leasing awareness, and the need to check EOBs after fee changes.

- The broader expert report says PPO participation should be evaluated at multiple levels: network-level access, payer-level rules, code-level profitability, and state-law overlays.

- The write-off calculator and worksheet opportunity is strong in the keyword gap research, but any public tool should stay directional unless the input data is clean.

- The competitor media audit argues for participation execution, not generic fee negotiation: signed fee schedules, loaded fees, provider records, and EOB validation determine whether the strategy actually reaches collections.

Reports and records Joey should be ready to name:

- Production by carrier or plan.

- Procedure production by CDT code.

- Adjustment or write-off report by adjustment type.

- Insurance payment report.

- Carrier or plan aging and payment detail, if useful.

- Fee schedule report: office fee, loaded PPO fee, effective date, and plan mapping.

- Top CDT code report for the lookback period.

- Recent EOBs or ERAs for sampled claims.

- Participation map showing carrier, network path, provider, TIN, location, fee schedule, and effective date.

Fields to study for the worksheet:

| Field | Why It Matters |

|---|---|

| Carrier or plan label | Starting point for owner-facing decision. |

| Network path | Prevents direct, shared, leased, or TPA routes from being mixed. |

| Provider, TIN, and location | Fee schedules and credentialing can vary by identifier. |

| CDT code | Keeps the analysis code-specific. |

| Procedure description | Makes the worksheet readable. |

| Annual units | Prevents rare codes from distorting the answer. |

| Office or submitted fee | Baseline for the write-off calculation. |

| Allowed amount | The contracted or plan-allowed amount being tested. |

| Per-unit write-off | Shows code-level discount pressure. |

| Annual write-off | Shows real dollar impact. |

| Write-off percentage | Helpful but secondary to annual dollars. |

| Payment and patient portion | Useful for reconciliation, but not the same as allowed amount. |

| Adjustment type | Confirms only contractual PPO adjustments are included. |

| Date of service and payment date | Prevents timing distortion. |

| EOB verification status | Shows whether the worksheet matches actual claim evidence. |

Deep report source leads to remember:

- ADA EOB resources are useful source leads for plan allowance, patient responsibility, remark codes, COB, and posting timing.

- ADA negotiation and termination resources support reviewing top procedures, write-offs, contract terms, network leasing, and EOB follow-up before acting.

- ADA COB materials are a source lead for the caution that write-offs should not be posted prematurely before all plans pay.

- Broader reports warn that public carrier materials are only proxies; the practice's own contract, fee schedule, EOB, TIN, provider, location, and product details control the analysis.

The topical authority map places this article in the PPO profitability analysis cluster:

- Core-013: full PPO profitability analysis.

- Core-014: calculating write-offs by carrier.

- Core-015: weighted PPO fee schedule comparison.

- Core-016: plan profitability scorecard.

- Core-017 and core-018: capacity cost and decision calculator.

Search and AI-answer opportunities:

- "how to calculate dental PPO write-offs"

- "dental PPO write-off calculator"

- "contractual write-off vs adjustment"

- "normal PPO write-off percentage"

- "allowed amount vs office fee"

- "PPO write-offs by carrier"

- "how to know if my dental PPO fee schedule is too low"

- "dental PPO EOB audit"

SERP gaps to exploit after recording:

- Most owners can find generic fee negotiation advice, but not a clean carrier-by-carrier write-off workflow.

- "Normal PPO write-off percentage" is a weak answer topic because benchmarks depend on specialty, market, carrier mix, code mix, hygiene volume, and calculation method.

- Calculator intent is strong, but a generic aggregate calculator is too thin. Unlock's better angle is a worksheet that uses the practice's own carrier, network path, code volume, office fee, allowed amount, and EOB proof.

- Competitor content often leads with negotiation. Unlock can lead with the operational proof: the PMS number must be cleaned, weighted, and verified before it drives a participation decision.

Potential extractable assets after Joey records:

- Definition block: PPO contractual write-off.

- Formula block: per-unit, annual, and weighted carrier write-off.

- Contractual write-off vs other adjustments table.

- Reports-to-pull checklist.

- Carrier write-off worksheet table.

- EOB verification checklist.

- "High write-off does not automatically mean drop" decision table.

- FAQ for normal percentages, collections vs write-offs, and carrier-level interpretation.

Best positioning line to study, not necessarily publish verbatim:

- A blended write-off percentage tells you there is fog. The carrier-and-code worksheet shows where the fog is coming from.

Use these as recording prompts. They are not final article examples unless Joey validates, replaces, or de-identifies them.

### Scenario 1: Blended PMS Write-Off Number

The owner says the PMS dashboard shows a 37 percent PPO write-off.

Study angle:

- That number may combine carriers, plan paths, procedure codes, adjustment types, timing periods, and claim statuses.

- The first step is not to react to 37 percent. The first step is to ask what is inside the number.

- Joey should separate contractual PPO write-offs from other adjustments before using it in a decision.

Potential Joey prompt:

- "When an owner says, 'Our write-offs are too high,' what do you ask before you trust the report?"

### Scenario 2: Carrier A Looks Worst Until Weighted

Synthetic study structure:

| Carrier | Code | Annual Units | Office Fee | Allowed Amount | Annual Write-Off |

|---|---|---:|---:|---:|---:|

| Carrier A | D2740 | 20 | 1450 | 900 | 11000 |

| Carrier B | D1110 | 700 | 125 | 82 | 30100 |

| Carrier B | D2391 | 220 | 215 | 126 | 19580 |

Study angle:

- A carrier can look painful on one high-dollar code, while another carrier creates a larger annual write-off through high-volume hygiene or restorative codes.

- The owner needs annual dollars and procedure mix, not just the biggest per-procedure discount.

Potential Joey prompt:

- "How do you explain weighting without making the owner feel like they need to become a spreadsheet person?"

### Scenario 3: Adjustment Category Is Dirty

The adjustment report includes contractual PPO adjustments, courtesy discounts, refund corrections, bad debt, recoupments, and secondary insurance timing adjustments under one category.

Study angle:

- This is a data hygiene problem before it is a PPO strategy problem.

- The practice may need to clean adjustment types or sample claims before calculating.

- A messy category can make a carrier look worse than it is.

Potential Joey prompt:

- "What are the adjustment types you do not want mixed into the PPO contractual write-off calculation?"

### Scenario 4: EOB Does Not Match Loaded Fee Schedule

The worksheet says the allowed amount should be $940 for a crown, but the EOB shows $890.

Study angle:

- Possible explanations include an old fee schedule, wrong plan mapping, wrong provider/location, shared-network path, effective-date problem, alternate benefit logic, or PMS setup error.

- The article should teach the owner to verify the allowed amount before treating the worksheet as truth.

Potential Joey prompt:

- "What does an EOB audit add that the PMS report cannot prove by itself?"

### Scenario 5: Highest Write-Off Carrier Is Not Automatically First To Drop

One carrier has a high weighted write-off percentage, but it brings new patients, fills otherwise idle chair time, or skews toward low-cost/high-retention services. Another carrier has a lower write-off percentage but consumes constrained chair time or produces poor contribution after lab, chair time, denials, and admin burden.

Study angle:

- Write-off analysis is one input into profitability.

- The article should point to core-013, core-016, and core-017 for the broader decision.

Potential Joey prompt:

- "When do you tell an owner, 'This is a write-off problem, but not enough information for a keep/drop decision'?"

### Scenario 6: Shared Network Path Hides Under A Carrier Label

The PMS report groups claims under a familiar carrier, but EOBs show that some claims priced through a shared, leased, or TPA path.

Study angle:

- Carrier-by-carrier analysis must sometimes become carrier-by-network-path analysis.

- A participation map and EOB sample can prevent the practice from blaming the wrong relationship.

Potential Joey prompt:

- "How do you decide whether to split one carrier label into multiple plan or network-path rows?"

### Scenario 7: COB Or Secondary Insurance Timing

A claim has primary and secondary insurance. The office posts a write-off before all plans have paid or treats a secondary adjustment as a PPO discount.

Study angle:

- COB can distort write-off reports if posting timing and adjustment categories are not reviewed.

- This is source-needed territory for final instructions. Keep it as a caution unless Joey and sources support exact guidance.

Potential Joey prompt:

- "What should the team hold for review when secondary insurance is involved?"

### Scenario 8: The Worksheet Reveals The Next Step

The carrier-level worksheet shows three different outcomes:

- Carrier A: high write-off, clean data, EOBs match loaded schedule. Likely negotiation or broader profitability review.

- Carrier B: high write-off, EOBs do not match PMS loaded fee. Implementation cleanup first.

- Carrier C: moderate write-off, high patient concentration, constrained capacity. Deeper add/keep/renegotiate/drop modeling.

Study angle:

- The worksheet is not just math. It routes the next operational question.

Potential Joey prompt:

- "What result makes you say 'negotiate' versus 'clean up the data first'?"

Treat these as study notes and source-needed guardrails.

Safer claims:

- A practice-wide PPO write-off percentage can hide carrier, code, network-path, and posting differences.

- Contractual PPO write-offs should be separated from other adjustments before analysis.

- A useful write-off calculation compares a practice fee baseline with the PPO allowed amount.

- Carrier-level write-offs should be weighted by actual procedure volume.

- EOB samples help verify whether the PMS allowed amount and loaded fee schedule match actual claim payment.

- Write-off percentage is not the same as profitability.

- A high write-off does not automatically mean the carrier should be dropped.

Source-needed or high-risk claims:

| Claim | Treatment |

|---|---|

| A universal normal PPO write-off percentage exists. | Source-needed. Avoid universal benchmarks unless Unlock has segmented data and source review. |

| The highest write-off carrier should be dropped first. | Source-needed and usually incomplete. Requires profitability, patient concentration, capacity, contract, and retention analysis. |

| Production minus collections equals PPO write-off. | Correct carefully. Collections include timing, patient balances, deductibles, denials, AR, and non-contractual issues. |

| All PMS write-off reports are reliable out of the box. | Source-needed. Data depends on setup, adjustment categories, fee schedules, claim status, and reporting basis. |

| Office fee is always the right baseline. | Joey-needed. Submitted fee may matter if submitted and office fees differ. |

| COB write-offs should be handled in one universal way. | High-risk. Requires source review and payer/plan timing context. |

| Carrier-specific write-off conclusions can be generalized publicly. | Source-needed. Varies by market, plan, network path, provider, location, and date. |

| A high write-off means the carrier made an error. | Source-needed. It may be correct, misposted, misloaded, misrouted, or strategically unacceptable. |

Legal, compliance, and operational caveats:

- Do not publish actual client fee schedules or identifiable EOBs.

- Do not encourage dentists to share current fee schedules or coordinate fee strategy with competitors.

- Do not give legal advice about balance billing, noncovered services, COB, ERISA, state law, termination, opt-outs, or patient responsibility.

- Do not treat public carrier pages as substitutes for the practice's signed contract, fee schedule, EOB, provider record, TIN, location, and product details.

- Mark all numerical examples as synthetic unless Joey provides an approved anonymized example.

- If discussing state-law or ERISA issues, keep them caveated and source-reviewed.

Ask Joey before final drafting:

- What exact PMS reports does Unlock usually ask for when calculating write-offs by carrier?

- Which PMS platforms need special caveats: Dentrix, Eaglesoft, Open Dental, Curve, or others?

- What is Joey's preferred baseline: office fee, UCR/master fee, submitted fee, or another field?

- What is Joey's recommended lookback period for this calculation?

- Does Unlock prefer top 10, top 20, top 25, top 50, or a coverage-threshold method?

- Which adjustment types should always be excluded from contractual PPO write-off analysis?

- How does Joey handle refunds, recoupments, claim corrections, courtesy adjustments, and bad debt in the data cleanup?

- How does Joey handle COB and secondary insurance claims in the first pass?

- What minimum EOB sample does Joey want before trusting the allowed amounts?

- What EOB fields best prove the allowed amount and network path?

- When does Joey split a carrier into multiple plan, product, or network-path rows?

- What red flags suggest the wrong fee schedule is loaded in the PMS?

- What red flags suggest the practice is posting all adjustments under a generic category?

- What result makes Joey recommend negotiation instead of cleanup?

- What result makes Joey recommend profitability modeling instead of a write-off-only conclusion?

- What anonymized example can Joey approve for a simple worksheet walkthrough?

- Should the article point to a worksheet, calculator, checklist, fee schedule review, or service inquiry?

Research still needed before publication:

- Dedicated deep research for core-014, if desired. No matching deep-research file exists in `research/raw/deep-research/` as of this study guide.

- Source-reviewed definitions of allowed amount, contracted fee, contractual adjustment, and EOB fields.

- ADA or other authoritative support for EOB posting and COB timing language.

- Joey-approved worksheet example.

- Joey-approved PMS report names and data cleanup rules.

- Current source review before naming any carrier, network, state, or product-specific rule.

This article should connect naturally to Unlock's fee economics and participation execution offers.

Relevant internal concepts and tools:

- PPO Write-Off Calculator.

- Carrier Write-Off Worksheet.

- PPO Fee Schedule Review Prep Generator.

- PPO Plan Impact Estimator.

- Weighted Fee Schedule Comparison calculator.

- PPO Participation Map.

- Effective-Date and EOB Verification Tracker.

- Add, Keep, Renegotiate, or Drop Scorecard.

- Annual Dental PPO Review Checklist.

- Service Inquiry Prep Packet.

Relevant internal articles:

- `content/core/core-004-analyze-dental-ppo-fee-schedule-top-procedure-codes.md`

- `content/core/core-005-ucr-master-fees-ppo-contracted-fees-allowed-amounts.md`

- `content/core/core-010-complete-dental-ppo-participation-map.md`

- `content/core/core-011-ppo-layering-contract-stacking.md`

- `content/core/core-013-dental-ppo-profitability-analysis.md`

- `content/core/core-015-weighted-ppo-fee-schedule-comparison.md`

- `content/core/core-016-dental-ppo-plan-profitability-scorecard.md`

- `content/core/core-017-capacity-cost-low-fee-ppo.md`

- `content/core/core-018-interactive-ppo-decision-calculator.md`

- `content/core/core-019-add-keep-renegotiate-drop-decision-tree.md`

- `content/core/core-033-load-maintain-ppo-fee-schedules-practice-management-software.md`

- `content/core/core-034-verify-negotiated-ppo-fees-on-eobs.md`

- `content/core/core-035-annual-dental-ppo-review-checklist.md`

Offer connection:

- Unlock can help the practice pull the right reports, separate adjustment categories, map carriers and network paths, build the weighted worksheet, verify EOBs, and interpret the result.

- The CTA should sound diagnostic, not alarmist: bring actual data so the next step is based on clean evidence.

- The article should not promise that every high-write-off carrier can be fixed or should be terminated.

Possible lead magnet or derivative:

- Carrier write-off worksheet with columns for carrier, network path, CDT code, annual units, office fee, allowed amount, per-unit write-off, annual write-off, write-off percentage, and EOB verification status.

- Checklist: adjustments to exclude before calculating PPO write-offs.

- Video: "Why your blended PPO write-off percentage is lying to you."

- FAQ: "Is production minus collections the same as PPO write-off?"

- Calculator: directional PPO write-off estimate, with heavy caveats around clean data and EOB verification.

1. Read the core article stub.

Focus on the stated intent: distinguish contractual write-offs from other adjustments.

2. Read the recording prompt.

Notice how often it asks for concrete report names, formulas, examples, EOB fields, and warning signs.

3. Study the research pack and SEO pack.

Carry forward the worksheet structure, formulas, extractable answer blocks, and risk flags.

4. Review the fee economics neighbors.

Core-004 covers top-code fee schedule analysis. Core-013 covers full profitability. Core-015 covers weighted comparison. Core-016 turns the analysis into a scorecard.

5. Study the raw research cues.

Use the topical map, keyword gap, citation-magnet questions, competitor audit, and user profile to stay focused on the owner who needs decision support, not generic education.

6. Prepare one simple calculation.

Use a synthetic three-code or five-code example to prompt Joey, then ask him to replace it with a better anonymized field example if available.

7. Prepare one messy-data story.

The article needs a moment where high write-offs turn out to be adjustment-category cleanup, wrong PMS fee schedule, or EOB mismatch before anyone talks about dropping a PPO.

8. Prepare one true-decision story.

The article also needs a moment where clean carrier-by-code write-off analysis makes the next step obvious: negotiate, verify, score profitability, or plan a participation change.

9. Keep caveats visible.

When tempted to say "normal," "worst carrier," "drop," "always," or "PMS report proves," stop and mark the condition or source-needed.

10. Record for field judgment.

The final article can be shaped later. The recording needs Joey's exact definitions, practical sequence, report names, data cleanup rules, EOB verification habits, and owner-friendly explanation.

- Written contractual write-off articles were useful but not podcast or YouTube media.

- Consumer EOB dispute guides were rejected as patient-facing.

- Open Dental PPO Writeoffs Report documentation was useful software documentation, not public media.

- Social reels about adjustments were too short and too noisy.

"PPO write-off" is not one practice-wide percentage. It is a carrier-by-carrier, code-by-code signal that shows which PPO relationships reduce collections, which are tolerable, and which need negotiation, cleanup, or exit planning.

The reader can see write-offs in the PMS but does not trust the numbers enough to make a decision. They ask which carrier costs the most, whether write-offs are normal, whether adjustments are posted correctly, and whether the right fee schedule is being used.

1. Open with the mistake of using one blended write-off percentage.

2. Define write-off as office fee minus PPO allowed amount.

3. Separate contractual write-offs from other adjustments.

4. Pull production by carrier, procedure detail, adjustment report, EOB samples, fee schedule, payment report, and top CDT volume.

5. Build the worksheet: carrier, plan/network path, CDT code, units, office fee, allowed amount, per-unit write-off, annual write-off, percentage.

6. Show formulas.

7. Explain weighting.

8. Add EOB audit layer.

9. Interpret results.

10. Close with keep, renegotiate, cleanup, or termination next steps.

- When a practice says write-offs are too high, what is the first question?

- What do offices include in write-offs that should be separated?

- How do you explain production, allowed amount, collections, and contractual adjustment?

- What reports should be pulled?

- When does a high write-off not automatically mean drop the PPO?

- What red flags tell you the issue is implementation, not negotiation?

- What is a dental PPO write-off?

- How do I calculate PPO write-offs by carrier?

- Should I use production, submitted fees, office fees, allowed amounts, or collections?

- What is contractual write-off vs adjustment?

- How many months of data should I use?

- What write-off percentage is too high?

- Can a carrier with high write-offs still be profitable?

- ADA guidance on EOB posting and COB.

- Public carrier definitions of allowed amount.

- Joey examples of PMS report mistakes.

- Anonymized sample calculation.

- Recommended lookback period.

- Whether to include calculator CTA.

- `research/raw/topical-authority-map.md`

- `research/raw/keyword-gap-analysis.md`

- `research/raw/chatgpt-user-profile.md`

- `research/raw/deep-research-report-12.md`

- `research/raw/deep-research-report-11.md`

- `research/raw/citation-magnet-questions.md`

- `research/raw/competitor-media-audit.md`

- Dental PPO Write-Off Calculator.

- Carrier Write-Off Worksheet.

- Normal PPO Write-Off Percentage explainer.

- EOB audit guide.

- Video: "Why your blended write-off percentage is lying to you."

- Any "normal" write-off percentage.

- High write-offs mean drop the PPO.

- Direct contract always overrides shared schedule.

- Noncovered/nonbillable billing advice.

- COB posting instructions before secondary payment is resolved.

Not started.

Distinguish contractual write-offs from other adjustments.

an established private-practice owner

Use this fee economics article to move the reader from vague PPO concern to a concrete decision, workflow, or next question.

See `content/prompts/core-014-calculate-dental-ppo-write-offs-by-carrier.md`.

- `research/raw/topical-authority-map.md`

- `research/raw/keyword-gap-analysis.md`

- `research/raw/deep-research-report-11.md`

- `research/raw/deep-research-report-12.md`

- Source-needed from Joey transcript.

1. Open with the practical situation that makes "How to Calculate Dental PPO Write-Offs by Carrier" urgent.

2. Clarify the misconception or hidden complexity.

3. Show the decision inputs the practice needs.

4. Explain the workflow or framework Unlock uses.

5. Close with the next step, related tool, or article.

- What is the owner really trying to decide when they ask about "How to Calculate Dental PPO Write-Offs by Carrier"?

- What data, documents, or examples would make the answer concrete?

- What can go wrong if the practice acts on a generic answer?

- What should the office manager or team know?

- What should the reader do next?

- Find Joey's clearest spoken explanation of "How to Calculate Dental PPO Write-Offs by Carrier".

- Pull examples from raw research that can become decision tables or checklists.

- Identify claims that need source review before publication.

Do not draft final prose until a real transcript or Joey-authored notes are added. Use the raw research for structure and questions; use Joey's recording for voice.

- How to Calculate Dental PPO Write-Offs by Carrier checklist

- Fee Economics decision table

- Talking-head video with slide beats

This funnel is anchored to `content/core/core-014-calculate-dental-ppo-write-offs-by-carrier.md`, not to generic PPO education. The article's job is to help established dental practice owners understand the specific decision behind **How to Calculate Dental PPO Write-Offs by Carrier**: calculating PPO write-offs by carrier.

The narrow reader movement is from a vague operational or financial symptom to the realization that this exact topic needs a structured review. The social posts should surface the symptom. The questions should name the practical uncertainty. The article should teach the operating model. The follow-up sequence should show why the issue becomes safer and more profitable when Unlock handles the analysis, strategy, negotiation, and implementation work.

- **Article-specific angle:** This funnel is about calculating PPO write-offs by carrier for established dental practice owners.

- **Generic angle avoided:** It avoided another broad "PPO participation is confusing" campaign and did not reuse a general add/drop/renegotiate message unless the assigned article specifically called for it.

- **Asset fit:** PPO Fee Schedule Data Pull Guide narrows the reader's next step to the article's problem rather than becoming a duplicate general PPO checklist.

- **Service bridge:** The emails bridge from this article's narrow issue to the done-for-you service by showing where data review, payer/network interpretation, sequencing, implementation, and verification exceed what a practice should have to manage alone.

- Primary answer intent: show owners how to separate contractual PPO write-offs from other adjustments and calculate them by carrier, code, and volume.

- Extractable answer blocks needed: definition of PPO write-off, contractual write-off vs adjustment, required reports, formula, weighted carrier worksheet, and EOB audit check.

- Best AI-citation angle: "a blended write-off percentage hides which carrier, plan path, or code is creating the problem."

- Query fan-out to cover: dental PPO write-off calculation, allowed amount vs office fee, contractual adjustment, carrier fee schedule audit, top CDT code analysis, EOB posting errors.

- Authority signals needed: Joey workflow notes, anonymized worksheet example, PMS report screenshots or field names, EOB examples, and source-backed definitions of allowed amount/contractual adjustment.

- Risk flags: do not publish universal "normal write-off percentage" claims, drop-carrier advice, COB posting instructions, or carrier-specific conclusions without review.

- Best scalable pattern: calculator or worksheet pages before carrier-specific pages; the data must come from the practice, not public assumptions.

- Useful template fields: carrier, network path, CDT code, annual units, office fee, allowed amount, per-unit write-off, annual write-off, write-off percentage, EOB verification status.

- Derivative candidates: "dental PPO write-off calculator," "carrier write-off worksheet," "contractual write-off vs adjustment," and "normal PPO write-off percentage" with heavy caveats.

- Internal-link hub fit: Fee Economics hub with spokes for UCR/master fees/allowed amounts, fee schedule analysis, PPO negotiation prep, and EOB verification.

- Avoid thin pSEO: do not generate "[carrier] dental PPO write-off" pages until Unlock has verified carrier-specific fee schedule data, rules, and unique examples.

- Potential reusable asset: downloadable carrier worksheet tied to top CDT volume and EOB audit prompts.

- Search intent: established owner trying to turn PMS write-off reports into a PPO participation, negotiation, cleanup, or exit decision.

- Title/H1 alignment: keep "How to Calculate Dental PPO Write-Offs by Carrier" intact; it matches the operational how-to query.

- On-page gaps in current draft: no Joey voice source, no worked example, no formulas, no source notes, and no author/update trust signals.

- Needed SERP features: formula block, step list, worksheet table, FAQ answers, and a comparison of contractual write-offs vs other adjustments.

- E-E-A-T gaps: add expert attribution, last-updated date, source-reviewed definitions, and claim caveats before publication.

- Internal links to add when available: UCR/master fees/allowed amounts, top procedure code fee schedule analysis, PPO negotiation guide, and participation strategy.

1. Capture Joey's explanation of how Unlock separates contractual write-offs from other adjustments.

2. Build the draft around one worksheet: carrier, code, units, office fee, allowed amount, per-unit write-off, annual impact, percentage.

3. Add formulas for per-unit write-off, annual write-off, and weighted carrier write-off percentage.

4. Include an EOB audit layer so the article does not rely only on PMS reports.

5. Mark normal-percentage, carrier-specific, COB, and drop/terminate recommendations as Source-needed until reviewed.