All templates

Automated Restroworks Menu Margin Report

Every Monday, WebRun opens Restroworks, pulls the recipe cost and units sold for every menu item across the chain, calculates the margin and total contribution for each one, ranks items from best to worst, and logs the report to a shared Google Sheet for the chef and finance team.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Restroworks calculate margin and contribution per menu item
2 Google Sheets log the ranked margin report
In short

How do I see the true margin on every menu item automatically?

Every Monday, WebRun opens Restroworks, pulls the recipe cost and units sold for every menu item across the chain, and calculates each item's margin and total contribution. It ranks items from best to worst, calls out high-volume items with low margin, and logs the full report to a shared Google Sheet.

  • Every menu item's real margin is visible weekly, not estimated at review time
  • Popular low-margin items are called out before they quietly drag down profit
  • Each item's rank movement is visible week to week, not just a single snapshot

Built for executive chefs · restaurant menu engineers · F&B finance teams · multi-outlet restaurant chains

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.restroworks.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Restroworks - calculate margin and contribution per menu item
    restroworks.com
    WebRun in Restroworks: calculate margin and contribution per menu item
    WebRun opens Restroworks to calculate margin and contribution per menu item.
    • Open Restroworks recipe costing and pull the food cost for every active menu item
    • Pull units sold for each item across the chain for the past 7 days
    • Calculate margin percentage and total contribution per item, and rank from best to worst

    Done when Every active menu item has a calculated margin, contribution, and rank.

  3. 2
    Google Sheets - log the ranked margin report
    google.com
    WebRun in Google Sheets: log the ranked margin report
    WebRun opens Google Sheets to log the ranked margin report.
    • Open the shared menu margin tracker in Google Sheets
    • Log this week's ranked margin report, with low-margin high-volume items called out separately
    • Keep the prior week's ranking alongside so an item's movement up or down is visible

    Done when This week's ranked menu margin report is logged with each item's prior rank visible.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.restroworks.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Menu margin report · Google Sheets
OutputWhat each run produces - A ranked report of every menu item's margin and total contribution for the week, with low-margin high-volume items called out.
Report
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it change any menu price or recipe?

No. WebRun only reads the recipe cost and sales mix Restroworks already has and calculates margin from them. Changing a menu price or a recipe is a decision for the chef and management.

Which items get flagged as the biggest concern?

High-volume items with low margin are called out separately, since a popular item selling below a healthy margin drags on the whole menu's profitability more than a rarely ordered low-margin item does.

Does it cover every outlet or just one?

It covers every outlet on the shared menu, so a margin problem specific to one outlet's local pricing or portioning still shows up in that outlet's own numbers, not just the chain average.

Keep going

Related templates

Automated Restroworks Payout Reconciliation
Every morning, WebRun opens Restroworks, totals what each delivery aggregator owes after commission, checks the actual deposit against Xero, and posts finance a Microsoft Teams list of every shortfall still unexplained.
Restroworks›Xero›Microsoft Teams
Automated Restroworks Royalty Reconciliation
Once a month, WebRun opens Restroworks, calculates the royalty each franchisee owes on their recorded sales, checks what has actually been received in Xero, and drafts a royalty invoice for any shortfall, leaving it unsent for finance to review.
Restroworks›Xero›Microsoft Teams
Automated Restroworks Guest Feedback Alerts
Within minutes of a low guest rating landing in Restroworks, WebRun drafts an empathetic reply in Gmail for a manager to review and send, and pings the outlet's Microsoft Teams channel so nobody misses a guest who needs a fast response.
Restroworks›Gmail›Microsoft Teams

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.

Deploy this workflow Talk to us