TIER 2 · REBATE REPORT · AUDIT WORKSHEET
Your PBM Reports 100% Pass-Through. Audit the Noun.
The Audit Worksheet to Reconcile the Rebate Report.
A 2-page printable worksheet PBS uses across 100s of PBM contract reviews annually. Free download. Sent to your inbox.
Three audit passes on the rebate report your PBM sends
Reconcile 'received' rebates against manufacturer-paid rebates
Where a rebate aggregator's cut hides before pass-through
Paste-ready broker request for the missing detail
Get the Worksheet
PDF arrives in your inbox in about 2 minutes
Welcome back! Get this one instantly:
Get the Worksheet
PDF arrives in your inbox in about 2 minutes
Please check your details and try again.
You're set — the toolkit is on its way to your inbox.
A complete audit framework you can run in half a day.
WHAT IS IN THE WORKSHEET
PASS 03
Audit the Definitions
'100% pass-through' usually means 100% of what the PBM received, not what the manufacturer paid. If a rebate aggregator took a cut first, the two numbers differ, and only one is on your report.
PASS 01
Pull the Rebate Detail
Open your most recent rebate report. Pull rebate-per-claim and total rebate by drug. The summary number is designed to reassure; the per-drug detail is where the reconciliation happens.
PASS 02
Reconcile Received vs. Paid
'100% pass-through' usually means 100% of what the PBM received, not what the manufacturer paid. If a rebate aggregator took a cut first, the two numbers differ, and only one is on your report.
ACTION PLAN
This Quarter's Action Plan
Run the three passes, document the gap between received and paid, and send the paste-ready request for aggregator-level detail to your broker before the next quarterly review.