Automated Craneware CDM Price Variance Alerts
Every Monday, WebRun opens Craneware, finds every CDM item priced outside your defined variance band, logs the detail to a Google Sheet, drafts a proposed correction in Outlook for finance and the CDM committee, and posts a Slack alert once the weekly review is ready.
How do I catch chargemaster price variances before they hit a claim?
WebRun checks Craneware every Monday for chargemaster items priced outside your variance band, logs the detail to a sheet, and drafts a proposed correction in Outlook for finance and the CDM committee to review, with a Slack alert when it's ready. No price goes live until a person approves it and the coordinator applies the change.
- Price variances get a proposed fix the same week they're found, not at year-end audit
- Every correction is reviewed by finance before it ever reaches a claim
- Pending items stay visible instead of falling off between review cycles
Built for CDM committees · hospital finance teams · revenue integrity directors · chargemaster 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.craneware.comin a real browser with your saved login - no setup, no API keys. -
1
Craneware - find CDM items priced outside range
craneware.com
WebRun opens Craneware to find CDM items priced outside range. - Open Craneware and pull CDM items whose current price falls outside your defined variance band against peer or historical benchmark
- Capture the item, department, current price, and benchmark price for each
- Separate variances that look like a data entry error from ones that may be intentional
Done when Every CDM item outside its variance band is listed with its current and benchmark price.
-
2
Google Sheets - log the variance detail
google.com
WebRun opens Google Sheets to log the variance detail. - Log each flagged item as a row with the variance amount and percentage
- Sort by dollar impact across expected volume
- Carry forward any item still pending finance sign-off from last week
Done when The variance tracker lists every flagged item ranked by dollar impact.
-
3
Outlook - draft the proposed correction
microsoft.com
WebRun opens Outlook to draft the proposed correction. - Draft an email to finance and the CDM committee with the proposed price correction for each item
- Note which items look like a likely data entry error versus a pricing decision to confirm
- Leave the draft unsent. WebRun never pushes a price change live, finance approves and the CDM coordinator applies it
Done when A proposed correction draft is waiting in Outlook for finance to review.
-
4
Slack - alert the committee
slack.com
WebRun opens Slack to alert the committee. - Post the CDM committee channel a short alert that this week's price variance review is ready
- Link to the Outlook draft and the sheet for detail
Done when The committee has this week's price variance alert in Slack.
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
Will it change a chargemaster price on its own?
No. WebRun only drafts the proposed correction in Outlook for finance and the CDM committee to review. A price never goes live until a person approves it and the CDM coordinator applies the change.
How is a variance defined?
A CDM item's current price falling outside the band you set against a peer or historical benchmark. You control how tight or loose that band is.
What happens to items pending review?
They carry forward into the next week's tracker as still pending, so a slow approval never means the item quietly drops off the list.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.