Automated Liquor Store Weekly Margin Report
Every Monday, WebRun opens City Hive, pulls last week's sales revenue and cost of goods sold by category, calculates gross margin for each category and the top-selling SKUs, logs the results in Google Sheets, and posts a margin summary to Slack so management can see what is driving and what is eroding profitability.
How do I get an automated weekly gross margin report for my liquor store?
WebRun pulls last week's sales and cost data from City Hive every Monday, calculates gross margin by category and top SKU, logs the results in Google Sheets, and posts a summary to Slack. Management sees which categories are protecting margin and which are eroding it, without anyone pulling a report by hand.
- Margin by category is visible in Slack every Monday morning
- Week-on-week margin declines are flagged before they compound
- No manual report pulling needed from City Hive
Built for liquor store owners · bottle shop managers · wine and spirits buyers · beverage retail finance 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.cityhive.netin a real browser with your saved login - no setup, no API keys. -
1
City Hive - pull last week's sales and cost data
cityhive.net
WebRun opens City Hive to pull last week's sales and cost data. - Open City Hive and navigate to the sales or reporting dashboard
- Set the date range to the prior seven days
- Capture total revenue, cost of goods sold, and units sold for each product category
- Identify the top 20 SKUs by revenue and capture their individual revenue and cost figures
Done when Last week's revenue and cost data for all categories and the top 20 SKUs are captured.
-
2
Google Sheets - calculate and log margin by category and SKU
google.com
WebRun opens Google Sheets to calculate and log margin by category and SKU. - Open the weekly margin report sheet
- Append a new dated row for each category with revenue, cost, gross profit, and margin percentage
- Add the top 20 SKUs with their individual margin figures
- Flag any category or SKU where margin fell more than two percentage points from the prior week
Done when Last week's margin data is logged in Google Sheets with week-on-week variance flags.
-
3
Slack - post the weekly margin summary
slack.com
WebRun opens Slack to post the weekly margin summary. - Post a margin summary to the management channel: overall gross margin, top three categories by margin, and any categories that declined
- List the top five margin-driving SKUs and any SKUs flagged for margin erosion
- Include a link to the Google Sheets report for full detail
Done when Management has last week's margin summary in Slack with a link to the full report.
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 need cost of goods data to be set up in City Hive first?
Yes. WebRun reads the cost and revenue figures that are already in City Hive. Make sure your product costs are entered accurately in the platform for the margin calculations to be correct.
Can it break margin down by supplier or distributor instead of category?
Yes. Tell WebRun which grouping matters most to your buying decisions and it will structure the report accordingly, whether by category, supplier, or both.
Is any financial data shared outside the store team?
No. The report goes to your internal Slack channel and Google Sheets workspace. No data is sent to third parties or outside your accounts.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.