Automated Food Cost Variance Reporting
Every Monday, WebRun opens Restaurant365, reads each location's theoretical food cost against actual usage for the past week, logs the variance by unit and category into a Google Sheet trend, and sends you a Telegram digest of the locations and categories where food cost is drifting most.
How do I get a weekly food-cost variance report per location automatically?
Every Monday, WebRun reads each location's theoretical versus actual food cost in Restaurant365, breaks the variance down by category, logs it into a Google Sheet trend, and sends you a Telegram digest ranking the units drifting most. Because it names the driving category and tracks the trend, a slipping location is visible weeks before the P&L confirms it.
- Drifting units surface weekly, well before the monthly P&L
- Variance is broken down to the category driving it, not just a total
- A running Sheet trend shows whether a location is improving or slipping
Built for multi-unit operators · restaurant controllers · operations directors · franchise 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
my.restaurant365.comin a real browser with your saved login - no setup, no API keys. -
1
Restaurant365 - read theoretical vs actual cost
restaurant365.com
WebRun reads theoretical versus actual food cost per location in Restaurant365. - Open Restaurant365 and read theoretical food cost against actual usage for each location for the week
- Break the variance down by category such as protein, produce, and dairy
- Capture the dollar and percentage variance per unit and category
Done when Every location has a theoretical versus actual food-cost variance for the week.
-
2
Google Sheets - log the weekly variance
google.com
WebRun logs each week's food-cost variance into a Google Sheet trend. - Open the food-cost variance Sheet and append this week's figures per location and category
- Keep the running weekly trend so drift over time is visible
- Highlight units whose variance widened versus the prior weeks
Done when This week's variances are logged into the trend Sheet by location and category.
-
3
Telegram - send the variance digest
telegram.org
WebRun sends the per-location food-cost variance digest to Telegram. - Send a digest ranking the locations with the widest food-cost variance
- Name the category driving each unit's drift and whether it is worsening
- Link back to the Sheet for the full weekly trend
Done when You have this week's per-location food-cost variance digest in Telegram.
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
Is this an internal report or does it message anyone outside?
It is purely internal. WebRun reads Restaurant365, writes to your Google Sheet, and sends the digest to your own Telegram. Nothing is sent to vendors, staff, or anyone outside your finance team.
How is the variance calculated?
WebRun compares theoretical food cost, what recipes should have used, against actual usage from Restaurant365 for the week, per location and category, so you see exactly where consumption ran over the recipe.
Can I see the trend over time, not just this week?
Yes. WebRun appends each week's figures to a running Google Sheet, so you can watch a unit's food-cost variance widen or recover across weeks instead of seeing a single snapshot.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.