Choose five or six numbers that tell you whether an outlet is healthy, pull them for every outlet for the same week, and put them side by side on one page each Monday. Look for the outlet that moved, not the one that’s always lowest. Then pick one thing to ask its manager about that week.
Why it matters
Monthly profit statements arrive too late to fix a bad week, and daily sales alone hide the real problems: a cashier giving discounts, a cook over-portioning, a manager rostering too many people on a quiet day. A weekly comparison catches these within days, while you can still ask what happened.
Comparing outlets with each other is what makes the numbers useful. One outlet’s 34% material cost means little on its own; next to three others running at 29%, it’s a question. Each outlet already has its own profit statement from tracking each outlet separately; this page is the quicker weekly habit that sits on top of it, for when you have too many sites to visit every day.
How to do it
Pick the numbers, and stop at six
For most shops and food businesses: net sales (without GST), number of bills, average bill value, material or food cost as a share of sales, staff cost as a share of sales, and wastage or discounts. A salon might swap material cost for services per stylist; a tuition centre might use attendance and fees collected. Same list for every outlet, every week.
Fix the week and the definitions
Decide the week runs Monday to Sunday and write one line defining each number, such as “material cost = opening stock + purchases and transfers in − closing stock”. Without fixed definitions, one manager counts transfers and another doesn’t, and the comparison is meaningless.
Get the data out with as little typing as possible
Sales, bills and discounts come straight from the shared billing system. Material cost needs a weekly closing stock count of the main items at each outlet on Sunday night, entered by the manager. Staff cost comes from the roster: days worked × daily cost per person. Set a deadline, for example 11 a.m. Monday, for every outlet’s figures.
Lay it out in one sheet
In Google Sheets, outlets go down the side, numbers across the top, with this week next to the four-week average. Colour a cell only when it moves more than an agreed amount from that outlet’s own average. The page should be readable in two minutes.
Read it in a fixed order
First the total: is the business up or down? Then look for the biggest change against each outlet’s own average, not against the other outlets, because a smaller location will always sell less. Then check whether the change has an obvious outside cause: a festival, rain, a road closure, a local exam week.
Ask one question per outlet that moved
Send the manager a short message or call them: “Food cost went from 30% to 35%, what changed?” Write their answer and the action next to the number. Next Monday, check whether it came back. Over months this column becomes the record of how each outlet is managed.
| Illustrative week | Outlet A | Outlet B | Outlet C |
|---|---|---|---|
| Net sales | ₹2.1 lakh | ₹1.6 lakh | ₹1.9 lakh |
| Bills / average bill | 1,050 / ₹200 | 820 / ₹195 | 760 / ₹250 |
| Material cost (4-week avg) | 30% (30%) | 34% (29%) | 31% (31%) |
| Staff cost | 18% | 21% | 17% |
| Discounts and voids | 1.2% | 1.1% | 3.4% |
Your result
A one-page weekly comparison and a short list of questions you actually asked.
My weekly numbers (max 6): ________ Week runs: Mon–Sun figures due by: ____ Monday Definitions written and shared with managers: yes / no Closing stock count done by: ________ (each outlet) Sheet link: ________ Flag a cell when it moves more than: ____ % from own average This week’s question per outlet: ________ Last week’s question fixed? yes / no
Fill it in on your checklist, next to this topic. It stays in this browser.
Time and cost
- Time
- Half a day to build the sheet and agree definitions with managers. After that, about an hour every Monday for the owner, and 20–30 minutes on Sunday night for each manager’s stock count.
- Cost
- Free in Google Sheets if your billing system exports sales by outlet. Some multi-outlet systems build this comparison in; check before paying for a separate reporting tool.
Ballparks to verify: prices and fees change by city and over time, so check current rates before you budget.
Common mistakes
Ranking outlets against each other
A small outlet in a quiet area will always look worse. Compare each outlet with its own recent weeks first.
Too many numbers
A sheet with twenty columns gets glanced at and closed. Keep the few that lead to a decision.
Skipping the stock count
Without a weekly closing count, material cost is a guess, and it’s usually the number that matters most.
Asking questions as accusations
Managers who are blamed for every red cell learn to fudge the count. Ask what changed, then agree a fix.
Go deeper
- Read nextTrack each outlet’s profit →The monthly per-outlet profit statement this weekly view sits on top of.
- Read nextTargets for outlet managers →Turn the weekly numbers into targets each manager owns.
- Business playbookSoftware to run it: cafe →Cafe billing and stock tools that report sales and cost by outlet.
The playbooks are written for one business each. Start with the full playbook or find yours.
Questions people ask
Should I share the comparison with all managers?
Many owners do, once the definitions are fair and trusted, because managers see what other outlets achieve. Share the numbers, keep the individual questions private.
Is weekly enough, or should I check daily?
Look at daily sales from the morning report, but judge costs weekly. Material and staff cost swing too much day to day to read sensibly.