DRP Supplement Reconciliation for Collision Shops

A DRP supplement reconciliation workpaper compares the carrier side of each repair order with the shop side of the job. It captures the Estimate of Record, supplements requested and approved, denied or partial amounts, final payment, actual RO costs, and the margin target the job had to meet.

That is the difference between a denied-line list and a real short-pay tracker. A denied supplement tells you one carrier rejected one request. A reconciliation workpaper tells you whether the approved and paid amounts on an RO covered the economics your shop incurred, and whether the shortfall is concentrated in a carrier, an estimator, a line-item family, or a documentation gap.

For a collision shop reconciling DRP supplements, the useful question is not "Did the carrier pay the EOR?" It is "After all supplements, sublet invoices, scan charges, calibration invoices, parts credits, and carrier payments are matched to the RO, how many dollars did this job miss by, and why?"

Most shops feel the problem before they can measure it: the estimator remembers a carrier cutting refinish hours, the parts department knows a credit never landed, the bookkeeper sees the EFT deposit but not the line-by-line supplement disposition, and the owner hears that a DRP carrier is "killing us on supplements." The workpaper turns that complaint into finance evidence.

The workbook should produce six outputs: per-RO carrier variance, RO margin gap, carrier scorecard, line-item scorecard, documentation status, and a follow-up queue. That is enough for month-end review without turning the workbook into a second estimating system.

Build One Repair-Order Row From the Supplement Report

CCC, Mitchell, and Audatex/Qapter supplement reports are source documents. They are not, by themselves, a management report for the owner or controller. Their job is to show the estimating and supplement history for a repair. Your workpaper's job is to pull that history into a consistent row structure so the shop can compare it across ROs, carriers, locations, estimators, and months.

The first design choice is the grain of the table. A one-row-per-RO model works well for month-end carrier scorecards because each repair order produces one final variance. A one-row-per-supplement model works better when the estimator needs to see which supplement round, line item, or disposition created the loss. Many shops keep both: a detailed supplement tab for investigation and a summarized RO tab for owner review.

At minimum, the detailed row should capture:

• Carrier and DRP program
• Claim number and RO number
• Vehicle, VIN, and repair location if useful
• Original EOR amount
• Supplement number
• Supplement requested amount
• Supplement approved amount
• Denied or partial amount
• Disposition: approved, partial, denied, pending, or closed
• Final approved or billed amount
• Final paid amount
• Actual labor, parts, paint and materials, sublet, scan, calibration, tow, and other cost buckets
• Target margin or target gross profit dollars
• Carrier disposition variance dollars
• RO margin gap dollars
• Documentation status
• Follow-up owner and next action
• Source file name and page reference

Source references turn the workbook into a review file. When it says a carrier partially approved a calibration line, the estimator should be able to open the exact supplement report page, scan invoice, calibration invoice, or remittance page behind the number.

The platform reports also prove the data exists, even if the shop still has to aggregate it. The Society of Collision Repair Specialists notes that Solera Qapter users can view a Supplement Reconciliation report under available documents, according to the SCRS estimating tip on Qapter Supplement Reconciliation. CCC's 2026 Crash Course report shows why this deserves a repeatable control: supplement activity stayed elevated in 2025, with Figure 40 showing claims with supplements near 70% in the first three quarters (CCC Crash Course 2026).

Use column names that match how the shop reviews the work. "Requested Amount," "Approved Amount," and "Denied Amount" are clearer than generic amount fields; "Final Paid Amount" should stay separate from "Final Approved Amount" because an approved supplement can still be unpaid, delayed, batched into a remittance, or offset by a prior credit. The goal is not to recreate the estimating platform. It is to compare supplement history, actual repair cost, and payment evidence without reopening every file manually.

Separate True Short-Pays From Low-Margin Repair Orders

A short-pay calculation needs stricter definitions than everyday shop conversation. If the team uses "short-pay" to describe every disappointing RO, the scorecard loses credibility. The workpaper should separate carrier underpayment from low gross margin, production variance, estimating misses, parts issues, and unapplied cash. Use two named columns, not one catch-all short-pay number.

Start by keeping these amounts separate:

• Original EOR: the carrier-approved estimate before supplements.
• Requested supplement: the amount the shop asked the carrier to approve after teardown or later discovery.
• Approved supplement: the amount the carrier accepted.
• Denied or partial amount: the difference between requested and approved, by supplement or line item.
• Final billed amount: the repair amount the shop billed after supplements.
• Final paid amount: the amount actually paid through remittance and EFT.
• Actual RO cost: labor, parts, paint and materials, sublet, tow, scan, calibration, and other costs incurred by the shop.
• Target margin: the gross profit or margin requirement the shop expects the RO to meet.

The analysis should read as a sequence from EOR to supplement to final bill, not as a pile of totals. The initial EOR sets the starting point. Supplements explain what changed as the repair developed. The final billed amount shows what the shop expected to collect. The final paid amount shows what actually came in. Actual cost and target margin show what the job needed in order to be financially acceptable.

A practical carrier-side formula is:

Carrier disposition variance = requested, billed, or approved amount minus carrier-approved or paid amount

The exact starting amount depends on the shop's policy. Some shops measure from requested supplement to approved supplement to quantify cuts during disposition. Others measure from final approved amount to final paid amount to identify payment leakage. Keep both columns if the shop needs both views.

Then keep the economics column separate:

RO margin gap = required revenue for actual cost and target margin minus final paid amount

That second formula is useful only if the workpaper also preserves the reason codes. A margin gap could mean the carrier denied a supplement line, partially approved a scan charge, capped paint and materials, refused a sublet markup, delayed a payment, or paid the estimate correctly while the job ran over budget. Those are different management problems.

If the carrier approved the supplement and paid the final billed amount, but the RO missed target because parts costs rose, a credit memo was not applied, or labor hours ran over, route it to repair-order job-cost review, estimator coaching, parts reconciliation, or production review. Calling it a short-pay will inflate the carrier scorecard and weaken any later DRP conversation.

If the carrier cut a calibration invoice, approved fewer refinish hours than requested, denied OEM parts markup, capped paint and materials below the documented job need, or paid less than the final approved amount, the issue belongs in the carrier variance column. The carrier scorecard should use that metric. If the carrier paid correctly but the RO still missed target margin, the item should route to job-cost review, parts reconciliation, production review, or cash application instead of inflating the carrier short-pay scorecard.

Insurance work often carries lower margin expectations than cosmetic or customer-pay work, so the target margin field should reflect the shop's real DRP economics rather than a generic ideal. The point is not to make every DRP repair look bad. The point is to measure whether each carrier-approved repair order covered the cost structure the shop actually incurred.

Join Supplement Reports to Parts, Sublet, and Carrier Cash

The supplement report gives the carrier-side change history. It does not prove the shop's actual cost, and it does not prove the carrier paid. The reconciliation workpaper becomes useful when it joins the estimating record to the financial documents around the RO.

The first join is the per-RO cost ledger. Each supplement row should connect to actual cost buckets for labor, parts, paint and materials, sublet, scan, calibration, tow, and other charges. If the shop already tracks RO job cost, the supplement workpaper should reference that ledger rather than rebuilding it. If the ledger is incomplete, the short-pay tracker will overstate carrier issues and understate internal cost variance.

Parts require their own discipline. A supplement line for an OEM part may look underpaid until the parts statement shows a return, credit memo, price change, or part substitution. The parts input should come from the same controls used for body shop parts statement reconciliation, especially when a month-end variance depends on whether the vendor credit actually posted.

Sublet and documentation-heavy costs need direct evidence. Scan invoices, calibration invoices, tow bills, glass, frame, alignment, ADAS, and specialty sublet should link back to the RO and claim number. If the carrier partially approved a calibration line, the workpaper should show the requested amount, approved amount, denied amount, invoice source, and whether the supporting document was attached before the supplement was submitted.

The final paid amount should come from carrier remittance and bank deposits, not from estimate status. A repair order can show a final approved amount in the estimating workflow while cash lands later, lands in a batch, lands net of an offset, or requires unapplied-cash cleanup. DRP carrier remittance repair order reconciliation should match claim number, RO number, carrier, deposit date, payment amount, and variance notes. The paid-amount loop belongs with collision shop DRP EFT reconciliation, because the supplement scorecard is only as good as the cash application behind it.

This is where extraction becomes the bottleneck. A shop may have hundreds of CCC, Mitchell, Audatex/Qapter supplement reports, remittance PDFs, scan invoices, calibration invoices, sublet bills, and vendor statements for one month. Invoice Data Extraction fits the workflow when the team needs to extract supplement and remittance data into spreadsheets: users upload PDFs or images, describe the fields they need in a prompt, and download structured Excel, CSV, or JSON rows. The product can process mixed-format batches, keeps source file and page references in the output, and lets users save prompts for repeat extraction tasks, so the same field structure can be reused for the next month-end close.

A useful prompt for this workpaper is specific about both fields and grain. It might ask for one row per supplement line, with claim number, RO number, carrier, EOR amount, supplement number, requested amount, approved amount, denied amount, line-item description, disposition, source file, and page number. The output still needs review, but the reviewer is checking structured rows against source documents instead of typing the workpaper from scratch.

Turn the Workbook Into Carrier and Line-Item Scorecards

The detailed workpaper explains individual ROs. The scorecards show whether the shop has a pattern worth acting on.

A body shop carrier short-pay scorecard should not be a simple list of unpaid invoices. It should summarize, by carrier and DRP program, how much money is being cut, where it is being cut, and whether the issue is improving or getting worse. Useful columns include:

• RO count
• Supplement count
• Requested supplement dollars
• Approved supplement dollars
• Denied dollars
• Partial approval dollars
• Final paid variance
• Carrier disposition variance dollars
• RO margin gap dollars
• Carrier disposition variance rate as a percentage of supplement dollars or final billed dollars
• Average days open
• Count of ROs still pending documentation or follow-up

Name carriers the way management reviews them, and add location as a slicer if one carrier pattern could hide a location-specific estimator or documentation issue.

The line-item scorecard answers a different question: what exactly is getting cut? Normalize messy estimating, carrier-note, and invoice language into families management can act on: refinish hours, P&M cap, blend allowance, OEM parts markup, aftermarket variance, sublet markup, scan, calibration, tow/storage, OEM procedure items, and documentation-related lines. Without that normalization, the same dispute can be scattered across dozens of text strings.

The scorecards should drive specific management action. A high carrier variance rate may support a DRP renegotiation conversation. A high denial rate on scan invoices may point to missing attachments before submission. A cluster of refinish-hour cuts may require estimator review, better labor-note language, or a different escalation standard. A parts-markup variance may lead back to vendor statement review rather than carrier behavior.

For owner review, keep the scorecard blunt. Show the top carriers by carrier disposition variance dollars, the top line families by denied or partial amount, the oldest unresolved items, and the ROs above the shop's escalation threshold. Keep the RO margin gap visible, but do not let it inflate carrier short-pay totals. The detailed rows stay available for proof, but the monthly meeting should make the pattern visible in minutes.

The scorecard should end in a follow-up queue. Each open item needs a dollar amount, carrier, RO number, age, documentation status, owner, next action, and source documents. Sort by dollars first, then age; a five-hundred-dollar partial approval that is thirty days old usually deserves action before a fifty-dollar variance from yesterday.

Classify the cause before escalation:

• Missing document
• Weak line-item description
• Unsupported requested amount
• Carrier partial approval despite supporting documentation
• Final payment short of final approved amount
• Internal cost overrun, not carrier short-pay
• Awaiting remittance or cash application
• Ready for manager or DRP review

A carrier conversation is stronger when the manager can show repeat patterns by carrier and line family, with source documents tied to each RO. "We have twelve Progressive DRP repairs this quarter with partial approvals on calibration lines despite invoices and procedures attached" is a different conversation from "we think we are being short-paid."

The same evidence supports DRP decisions. If one carrier consistently cuts the same line families and the dollars exceed the relationship value, the owner has a basis for renegotiation, a documentation-process change, or a decision to reduce exposure to that program. If the short-pay pattern is concentrated in one estimator's files, the response is training and review. If final paid amounts trail final approved amounts, the problem may sit with remittance matching and unapplied cash rather than supplement approval.

At month-end, update the workbook, review high-dollar variances, close the remittance loop, assign unresolved items, and watch the trend. One disputed RO may be noise. A ninety-day pattern by carrier, line family, documentation status, and final payment variance is management evidence.