Automated Cantaloupe DEX Discrepancy Worklist
Every morning, WebRun opens Cantaloupe Seed Pro, reviews the DEX electronic audit data uploaded from the previous day's service visits, compares actual counts to expected fills for each machine, flags discrepancies above your tolerance threshold, and writes a prioritized worklist to Google Sheets so your team can investigate and correct records before they affect cash reconciliation or inventory reports.
How do I automatically find and review DEX discrepancies in my vending machines?
WebRun reviews DEX electronic audit data in Cantaloupe Seed Pro every morning, compares actual machine counts to expected fill quantities, and flags every discrepancy above your tolerance. The results go into a Google Sheets worklist sorted by variance size, so your team can investigate and correct records before they flow into cash reconciliation or inventory reports.
- DEX variances are caught daily instead of discovered in monthly reconciliation
- Largest discrepancies are prioritized so investigators focus where it matters most
- Cash and inventory records are corrected quickly before they affect financial reporting
Built for vending operators · inventory managers · route supervisors · accounting 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.cantaloupe.com/products/software/seed-proin a real browser with your saved login - no setup, no API keys. -
1
Cantaloupe - compare DEX audit counts to expected fills
cantaloupe.com
WebRun opens Cantaloupe to compare DEX audit counts to expected fills. - Open Cantaloupe Seed Pro and navigate to the DEX audit or inventory reconciliation report
- Pull DEX data for machines serviced in the prior day
- Compare actual DEX counts to the expected fill quantities for each machine and product
- Flag discrepancies that exceed your configured tolerance (e.g. more than 2 units difference)
- Capture machine ID, location, product, expected fill, actual DEX count, and variance for each flag
Done when Every DEX discrepancy above threshold from yesterday's service visits is listed with its variance details.
-
2
Google Sheets - write discrepancy worklist for team review
google.com
WebRun opens Google Sheets to write discrepancy worklist for team review. - Open the DEX discrepancy worklist Google Sheet
- Write each flagged discrepancy with machine, product, expected fill, DEX count, and variance
- Sort by largest absolute variance first
- Add a status column for your team to mark each item as investigated or corrected
Done when Google Sheets has today's DEX discrepancy worklist ready for team review.
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
What is DEX data and where does it come from?
DEX (Data Exchange) is an electronic audit standard that vending machines transmit when a technician or driver connects a handheld device during a service visit. Cantaloupe Seed Pro receives and stores this data after each visit.
Does it automatically correct the discrepancy in Cantaloupe?
No. WebRun only surfaces the discrepancy in Google Sheets for your team to investigate. Any inventory corrections are made manually in Cantaloupe after a human reviews the cause of the variance.
What if a machine was not serviced yesterday and has no DEX data?
Machines with no DEX upload for the prior day are excluded from the discrepancy check and noted separately in the sheet so your team can confirm whether a service visit was expected.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.