Automated SpotOn Pour Cost Variance Report
Every Monday, WebRun opens SpotOn and pulls weekly beverage sales by category, then writes the figures into your Google Sheet alongside your target pour cost percentages and flags every category where actual cost exceeds the threshold.
How can I automatically track pour cost variance from my bar POS?
WebRun pulls weekly beverage sales from SpotOn every Monday and logs the figures into your Google Sheet, where it calculates actual pour cost by category and highlights every line that exceeds your target percentage. Bar managers see exactly which spirits, beers, or wines are running over cost before the week gets away from them.
- Overrun beverage categories are flagged before they compound across the month
- Weekly pour cost figures are logged automatically without manual data entry
- Managers spend Monday reviewing variances, not pulling reports
Built for bar managers · nightclub owners · restaurant bar operators · beverage directors
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.spoton.comin a real browser with your saved login - no setup, no API keys. -
1
SpotOn - pull weekly beverage sales by category
spoton.com
WebRun opens SpotOn to pull weekly beverage sales by category. - Open SpotOn Reports and select the weekly sales report for the prior week
- Filter to beverage categories: spirits, beer, wine, and cocktails
- Capture gross sales and number of units sold for each category
- Note any voids or comps that affected beverage revenue
Done when Weekly beverage sales by category are captured with unit counts and gross totals.
-
2
Google Sheets - log figures, calculate variance, flag overruns
google.com
WebRun opens Google Sheets to log figures, calculate variance, flag overruns. - Open the pour cost tracking Google Sheet and find the current week row
- Enter the sales figures from SpotOn for each beverage category
- The sheet calculates actual pour cost percentage using the recorded cost-of-goods column
- Highlight in red any category where actual pour cost exceeds the target percentage
- Add a summary row at the top listing every flagged category and its variance
Done when The weekly pour cost report is updated and overrun categories are highlighted in the sheet.
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
Does it adjust for inventory shrinkage or breakage?
The report uses sales data from SpotOn and the cost-of-goods column you maintain in the sheet. If you record shrinkage and breakage in that column, the pour cost calculation will reflect it.
What counts as a pour cost overrun?
Any beverage category where the calculated actual pour cost percentage exceeds the target you set in the sheet. You control the targets, so you can tighten or loosen thresholds by category.
Can it cover food cost too, not just beverages?
Yes. Add food categories to the sheet with their own cost-of-goods and target columns, and WebRun will pull and log the food sales figures from SpotOn the same way.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.