Catch rebate claim variances before they cost you
When you upload the period's rebate claim file, WebRun pulls the verified shipment volume by account from rfxcel, compares it line by line against the claim recorded in Model N, and logs every variance to a Google Sheet reconciliation summary with the account, SKU, and dollar difference.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile pharmaceutical rebate claims against actual shipment volume?
WebRun reconciles your rebate claims when you upload the period's claim file. It pulls verified shipment volume by account from rfxcel, compares it line by line against the claim recorded in Model N, and logs every variance to a Google Sheet with the account, SKU, and dollar difference, so mismatches surface before your finance team signs off on the payment.
- Rebate variances are logged the same day the claim file lands
- Every mismatch is documented by account, SKU, and dollar amount
- Finance reviews a reconciled summary instead of raw claim data
Built for pharmaceutical wholesalers · drug distributors · trade relations teams · finance and rebate analysts
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.rfxcel.comin a real browser with your saved login - no setup, no API keys. -
1
rfxcel - pull verified shipment volume by account
rfxcel.com How to Automate rfxcel
WebRun opens rfxcel to pull verified shipment volume by account. - Open rfxcel and pull verified shipment volume by account for the claim period
- Group volume by account and SKU to match the claim structure
- Exclude any shipment still in dispute from another workflow
Done when Verified shipment volume for the period is grouped by account and SKU.
-
2
Model N - compare against the submitted rebate claim
modeln.com
WebRun opens Model N to compare against the submitted rebate claim. - Look up the submitted rebate claim for the same period in Model N
- Compare the claimed volume and rebate amount against the rfxcel figures line by line
- Flag any account or SKU where the two do not match
Done when Every account and SKU has been compared and mismatches are flagged.
-
3
Google Sheets - log the reconciliation summary
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the reconciliation summary. - Log the reconciliation summary with account, SKU, claimed amount, and verified amount
- Calculate the dollar variance for each flagged line
- Keep a running tab per rebate period for your finance team to review
Done when The reconciliation summary sheet reflects this period's variances by account and SKU.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it dispute the rebate claim for me?
No. It only reconciles the claimed amount in Model N against your verified shipment volume in rfxcel and logs the variance. Filing a dispute is still your team's decision.
What file does it need to run?
The rebate claim file for the period, in whatever format your GPO or manufacturer sends it. Upload it and WebRun runs the reconciliation against that period's shipments.
How is the variance calculated?
It compares the claimed volume and rebate amount in Model N line by line against the verified shipment volume in rfxcel for the same account and SKU, and reports the dollar difference.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.