Automated Cantaloupe Commission Statement Drafts
On the first Monday of each month, WebRun opens Cantaloupe Seed Pro, pulls the prior month's sales totals for every commission-eligible location, calculates the commission owed at each account's agreed rate, and writes draft statements to a Google Sheet for your team to review and approve before sending to location managers.
How do I automatically draft monthly commission statements for vending machine locations?
WebRun pulls prior month sales from Cantaloupe Seed Pro on the first Monday of each month, calculates the commission owed for every eligible location at its agreed rate, and writes draft statements to Google Sheets. Your team reviews and approves each statement before sending, so nothing goes to a location manager without a human check.
- Monthly commission statements are drafted automatically without manual Cantaloupe exports
- Human approval is required before any statement reaches a location manager
- Commission errors are caught during review before they damage location relationships
Built for vending operators · accounting managers · route managers · convenience service operators
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 - pull prior month sales by commission location
cantaloupe.com
WebRun opens Cantaloupe to pull prior month sales by commission location. - Open Cantaloupe Seed Pro and navigate to the commissions or location sales report
- Set the date range to the prior calendar month
- Pull total gross sales for each commission-eligible account or location
- Apply the commission rate configured for each account to calculate the amount owed
Done when Every commission-eligible location has a calculated commission figure for the prior month.
-
2
Google Sheets - write draft commission statements for review
google.com
WebRun opens Google Sheets to write draft commission statements for review. - Open the commission statements Google Sheet
- Write one row per location with location name, gross sales, commission rate, and commission owed
- Mark all rows as DRAFT so reviewers know these have not been sent yet
- Leave the statements in the sheet for your team to review and approve before sending to location managers
Done when Draft commission statements are written to Google Sheets and flagged 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
Will it send commission statements to location managers automatically?
No. WebRun writes draft statements to Google Sheets and marks them as DRAFT. Your team reviews and approves each statement before sending. Nothing is emailed or delivered to location managers without your sign-off.
Where does it get each location's commission rate?
It reads the commission rates configured in Cantaloupe Seed Pro for each account. If you manage commission rates outside Cantaloupe, you can maintain a rate table in the Google Sheet and WebRun will reference it.
What if a location's sales data is incomplete because of a machine outage?
The statement is flagged with a note if any machine at that location had offline periods during the month. Your team can review the outage impact before approving the statement.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.