Automated Coil Usage Reconciliation
Every evening, WebRun opens HI-IQ, pulls the embolization coils scanned as used in that day's cases, compares them against the charge capture and inventory depletion records, logs any coil used but not charged or charged but not depleted to a Google Sheet, and posts a reconciliation summary to Microsoft Teams.
How do I reconcile embolization coil usage against charges each day?
WebRun opens HI-IQ every evening and pulls the embolization coils scanned as used in that day's cases. It matches each against the charge capture and inventory records, logs any coil used but not charged to a Google Sheet, and posts a Microsoft Teams summary with the value at risk, so no coil slips through unbilled.
- Coils used but not charged are caught the same night
- The value at risk is totaled instead of discovered at month end
- Recurring gaps by physician or case type become visible over time
Built for IR billing specialists · interventional radiology coders · angio lab materials managers · IR revenue cycle teams
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.hi-iq.comin a real browser with your saved login - no setup, no API keys. -
1
HI-IQ - pull coils scanned as used today
hi-iq.com
WebRun opens HI-IQ to pull coils scanned as used today. - Open HI-IQ and pull today's completed embolization cases
- List each coil scanned as used by case, catalog number, and quantity
- Read the matching charge capture line and inventory depletion for each coil
- Flag coils used but not charged, charged but not depleted, or quantity mismatches
Done when Every coil used in today's cases has been matched to its charge and depletion record, and mismatches are identified.
-
2
Google Sheets - log usage versus charge mismatches
google.com
WebRun opens Google Sheets to log usage versus charge mismatches. - Open the Coil Reconciliation sheet and add a dated block for today
- Append one row per mismatch with the case, catalog number, quantity, and the type of gap
- Total the count and estimated value of coils used but not charged
- Keep prior days so recurring gaps by physician or case type are visible
Done when Today's mismatches are appended with case, catalog number, gap type, and a total value at risk.
-
3
Microsoft Teams - post the reconciliation summary
microsoft.com
WebRun opens Microsoft Teams to post the reconciliation summary. - Post a summary to the IR revenue channel with the count of clean cases and cases with a mismatch
- List the coils used but not charged first, with case and catalog number
- Show the estimated value at risk and link to the full Google Sheet
Done when The revenue channel has today's reconciliation summary with mismatches and value at risk.
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 post or correct charges automatically?
No. WebRun only compares coils used against coils charged and reports the gaps. Your billing team reviews the Google Sheet and posts or corrects any charge inside your billing system.
What counts as a mismatch?
Three cases: a coil scanned as used but not charged, a coil charged but not depleted from inventory, and a quantity that differs between the two. Each is listed with the case and catalog number.
Does patient information leave HI-IQ?
No. The Teams summary references cases by case number and catalog number, not patient identifiers. Reconciliation detail stays in your internal Google Sheet and Teams channel.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.