All templates

Automated Craneware Department Charge Reconciliation

Every Monday, WebRun opens Craneware, compares each department's posted charge volume against its own service log, builds a department-by-department reconciliation sheet with a 4-week trend, and posts your revenue integrity team a Slack summary ranked by the size of the gap.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:30 AM WebRunorchestrates each step
1 Craneware compare posted charges to department logs
2 Google Sheets build the department reconciliation sheet
3 Slack summarize gaps by department
In short

How do I reconcile charges by department every week?

WebRun compares each department's posted charges in Craneware against its own service log every Monday, builds a reconciliation sheet with the count and dollar gap by department, and posts your revenue integrity team a ranked Slack summary with a four-week trend. It flags a growing gap for a department instead of just this week's snapshot, so process problems surface early.

  • Department-level gaps surface weekly instead of at month-end close
  • A two-week growing trend gets flagged before it becomes a quarter-long problem
  • Every department is compared to its own service log, not a generic benchmark

Built for revenue integrity teams · department charge coordinators · revenue cycle directors · HIM leadership

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.craneware.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Craneware - compare posted charges to department logs
    craneware.com
    WebRun in Craneware: compare posted charges to department logs
    WebRun opens Craneware to compare posted charges to department logs.
    • Open Craneware and pull last week's posted charges grouped by department
    • Compare the count and dollar total against each department's own service log or order volume
    • Capture the gap in count and dollars for any department that doesn't reconcile

    Done when Every department's posted charges are compared against its service volume with any gap captured.

  3. 2
    Google Sheets - build the department reconciliation sheet
    google.com
    WebRun in Google Sheets: build the department reconciliation sheet
    WebRun opens Google Sheets to build the department reconciliation sheet.
    • Build a department-by-department reconciliation sheet with posted count, expected count, and dollar gap
    • Sort departments by the size of their gap
    • Keep a rolling 4-week history so a department's trend is visible, not just this week's snapshot

    Done when The sheet shows every department's reconciliation status and 4-week trend.

  4. 3
    Slack - summarize gaps by department
    slack.com
    WebRun in Slack: summarize gaps by department
    WebRun opens Slack to summarize gaps by department.
    • Post the revenue integrity channel a summary ranked by department, largest gap first
    • Call out any department whose gap has grown for two weeks running

    Done when The team has this week's department reconciliation summary in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.craneware.com
ScheduleRuns automatically on this cadence
Every Monday at 7:30 AM
DeliveryHow each run's result reaches you
Department reconciliation · Slack
OutputWhat each run produces - A weekly department-by-department reconciliation of posted charges against service volume, with a 4-week trend and a ranked Slack summary.
Spreadsheet + digest
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

What is it comparing to catch a gap?

Each department's posted charge count and dollar total in Craneware against that department's own service log or order volume for the same week, so a gap points to a specific department, not just a system-wide number.

Does it fix the reconciliation itself?

No. It only builds the sheet and posts the summary. Your revenue integrity team investigates and corrects each department's gap, WebRun doesn't touch the charges or the chargemaster.

Why track a 4-week trend instead of just this week?

Because a department with a small gap two weeks running is often a bigger problem than one large gap that was already fixed. The trend shows you which departments need a process fix, not just a one-time catch-up.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.