Report labor cost as a percentage of sales for every location weekly
Every Monday, WebRun opens Revel Systems, reads the prior week's labor hours, pay rates, and net sales for every location, calculates labor-to-sales percentage for each, compares it against your target, and writes the full comparison report to Google Sheets so you can spot overstaffing or understaffing before it repeats.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track labor cost as a percentage of sales across all my locations?
WebRun reads Revel Systems labor hours, pay rates, and net sales for every location each Monday, calculates labor cost as a percentage of net sales, and writes the comparison to Google Sheets with variance flags. Operators see which locations are over or under their labor target without pulling a single manual report.
- Weekly labor-to-sales percentage visible for every location without manual calculation
- Over-target locations flagged in color every Monday before the new week begins
- Historical labor trend data accumulates automatically in one Google Sheet
Built for multi-location restaurant operators · retail chain managers · franchise owners · operations 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
my.revelsystems.comin a real browser with your saved login - no setup, no API keys. -
1
Revel Systems - read weekly labor hours, pay rates, and net sales by location
revelsystems.com How to Automate Revel Systems
WebRun opens Revel Systems to read weekly labor hours, pay rates, and net sales by location. - Open the Revel Management Console and navigate to the Labor and Sales reports
- Set the date range to the prior full week for all locations
- Export total labor cost and net sales for each location
- Calculate labor percentage as total labor cost divided by net sales for each location
- Flag locations where labor percentage exceeds the configured target
Done when Every location has a labor-to-sales percentage and a variance against target for the prior week.
-
2
Google Sheets - write labor-to-sales comparison report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to write labor-to-sales comparison report. - Open the weekly labor cost report sheet
- Append a new row for each location with labor cost, net sales, percentage, and target variance
- Highlight any location over the target threshold in red for quick identification
Done when This week's labor-to-sales report is written into Google Sheets with variance highlights.
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 include all employee types or only hourly staff?
It reads all labor tracked in Revel Systems, including hourly and salaried employees who are clocked into the system. You can configure it to exclude specific job types if needed.
Can it break down labor by role or department within a location?
Yes. If Revel is configured with job titles or departments, WebRun can break the labor percentage down by role so you can see whether front-of-house or back-of-house is the cost driver.
Will it alert me immediately if a location goes over target mid-week?
This template runs weekly. For real-time labor alerts, you can set up a daily version that checks cumulative weekly labor cost versus pace, flagging locations tracking above target before the week closes.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.