Automated Monthly ATM Terminal Profitability
On the last day of each month, WebRun opens Switch Commerce to total each terminal's surcharge revenue and transaction volume, pulls each terminal's rent, telecom, and processing costs from QuickBooks, ranks every terminal from most to least profitable, and saves the finished workbook to Google Drive.
How do I rank my ATM terminals by monthly profitability?
On the last day of each month, WebRun totals each terminal's revenue and transaction volume in Switch Commerce and pulls its rent, telecom, and processing costs from QuickBooks. It calculates net profit per terminal, ranks every one from most to least profitable, and saves the workbook to Google Drive with the bottom 3 terminals highlighted for review.
- Every terminal gets a real profit number monthly, not just a revenue total
- The 3 least profitable terminals are highlighted automatically for your placement review
- A missing cost entry is flagged instead of quietly overstating a terminal's profit
Built for independent ATM operators · ISO ATM deployers · ATM portfolio managers · route managers
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
switchcommerce.comin a real browser with your saved login - no setup, no API keys. -
1
Switch Commerce - total each terminal's monthly revenue
switchcommerce.com
WebRun opens Switch Commerce to total each terminal's monthly revenue. - Open the Surcharge Revenue and Transactions reports in Switch Commerce for the closing month
- Capture surcharge revenue, interchange income, and transaction count for every terminal
- Match each terminal to its route and location owner
Done when The month's revenue and transaction count are captured for every terminal.
-
2
QuickBooks - pull each terminal's monthly costs
- Open QuickBooks and pull each terminal's location rent, telecom, and processing fees for the month
- Subtract total cost from total revenue to get net profit for each terminal
- Flag any terminal missing a cost entry so its profit figure isn't understated
Done when Net profit is calculated for every terminal with a complete cost entry.
-
3
Google Drive - save the ranked profitability workbook
drive.google.com
WebRun opens Google Drive to save the ranked profitability workbook. - Build the workbook ranking every terminal from most to least profitable for the month
- Highlight the bottom 3 terminals so they are easy to find for a placement review
- Save the workbook to the monthly profitability folder in Google Drive
Done when This month's ranked profitability workbook is saved to Google Drive with the bottom terminals highlighted.
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 costs get subtracted from revenue?
Whatever you have booked against that terminal or location in QuickBooks, typically location rent or commission, telecom, and processing fees. If a cost is missing for a terminal, that terminal is flagged instead of shown with an inflated profit.
Does it decide which terminals to pull?
No. It only ranks and highlights the bottom 3 for you to review. Whether to renegotiate a location's rent, move a terminal, or pull it entirely stays a decision for you.
Can I see this broken down by route as well as by terminal?
Yes. The workbook ranks every individual terminal, and since each one is tagged with its route and location owner, you can filter or subtotal by route inside the sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.