Score every payer on how often they deny you
On the first business day of each month, WebRun opens Waystar, pulls total claims and denials by payer for the prior month, builds a scorecard in Google Sheets ranking each payer by denial rate and dollars denied, and emails contracting leadership an Outlook summary to bring into the next payer negotiation.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I score and rank payers by denial rate from Waystar data?
On the first business day of each month, WebRun pulls claim and denial volume by payer from Waystar, builds a Google Sheets scorecard ranking every payer by denial rate and dollars denied, and emails contracting leadership an Outlook summary naming the worst performers. Revenue cycle teams walk into payer negotiations with current, ranked data instead of a manual pull.
- Payer denial rates are ranked and current every month instead of pulled manually before a negotiation
- The worst performing payers and their top denial reasons are named in one Outlook summary
- Six month trend comparison shows whether a payer's behavior is improving or getting worse
Built for revenue cycle directors · payer contracting teams · hospital CFOs · finance leadership
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.waystar.comin a real browser with your saved login - no setup, no API keys. -
1
Waystar - pull claims and denials by payer
waystar.com How to Automate Waystar
WebRun opens Waystar to pull claims and denials by payer. - Open Waystar and pull total claims submitted and total claims denied for the prior month, grouped by payer
- Capture the dollar amount denied and the dollar amount ultimately recovered through appeal for each payer
- Note each payer's top 3 denial reason codes by volume
Done when Every payer's claim volume, denial volume, dollars denied, and top reasons for the prior month are captured.
-
2
Google Sheets - build the payer scorecard
google.com How to Automate Google Sheets
WebRun opens Google Sheets to build the payer scorecard. - Open the payer scorecard and add the new month's tab
- Calculate each payer's denial rate as denied claims divided by total claims submitted
- Rank payers from highest to lowest denial rate, showing dollars denied and top reason codes alongside
- Compare each payer's rate against their trailing 6 month average
Done when The scorecard ranks every payer by denial rate with dollars denied and a 6 month trend.
-
3
Outlook - email leadership the summary
microsoft.com How to Automate Outlook
WebRun opens Outlook to email leadership the summary. - Draft an internal Outlook summary to contracting and revenue cycle leadership naming the top 3 highest denial rate payers
- Include the dollar amount denied and the leading reason code for each flagged payer
- Send it as a routine internal report, since it only reaches your own leadership team
Done when Leadership has an Outlook summary naming the highest denial rate payers ahead of contract discussions.
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 recommend renegotiating a payer contract?
No. It ranks payers by denial rate and dollars denied so the data is ready for a negotiation, but deciding whether and how to renegotiate a contract stays a leadership decision.
How is denial rate calculated?
As total claims denied divided by total claims submitted to that payer for the month, so a payer with a small claim volume is not automatically shown as riskier than a high volume payer with the same number of denials.
Who receives the monthly Outlook summary?
Whoever you name as contracting or revenue cycle leadership. It is an internal report only, so no payer or outside party ever receives the scorecard or the summary.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.