In this guide 6 sections
A weekly rollup is one page that gives each outlet a row, with identical columns every week: covers, average cheque, food cost, wastage, labour hours and open issues. Each outlet fills its row. The brand view adds the rows, then flags any outlet whose food cost, wastage or labour drifts outside its own band.
One row per outlet, same columns every week
The template fails the moment two outlets define a column differently, so fix the definitions first and write each one on the sheet. A cover is a seated guest. Takeaway orders get their own column, and delivery orders get another, because neither one fills a seat and both distort the average cheque if mixed with dine-in.
Keep the sheet narrow. Eight to ten columns is enough for an owner who reads it on Monday morning, and anything more belongs in the outlet manager’s own tracker.
Lock the week from Monday to Sunday and close it by Tuesday noon with the same cut-off for every outlet, because loose edges let numbers drift between outlets. Late edits go in a note. Never into the number.
- Covers dine-in, delivery and takeaway orders
- Net sales and average cheque per cover
- Food cost from opening stock, purchases and closing stock
- Wastage logged by reason: spoilage, prep error, returned plate
- Labour hours by kitchen and floor
- Open issues: equipment down, staff gaps, supplier shortfalls
Food cost needs a stock count, not a guess
Food cost per outlet only means something when each outlet counts stock on the same day, and Sunday close is common. Opening stock plus purchases minus closing stock gives the kitchen’s usage, which is the figure everything else is compared with.
Compare that usage with what the point of sale says was sold, using recipe cards that turn each dish into grams of chicken and litres of oil. The gap is your variance.
Over-portioning, an unrecorded staff meal and a supplier short-weighing a delivery are the usual causes of a large variance on one item, so name it in the sheet. Hold the count on one fixed evening. Use the same two people. Different counters give different numbers.
Wastage and labour tell you where the week leaked
Log wastage the moment it happens, with a reason, because a tray of cut fruit binned at close is spoilage while a remade order is a service fault. They need different fixes.
Labour is hours against covers. A Tuesday with a full roster and thin footfall shows up straight away when you divide covers by hours worked in each department.
Do not average across outlets. A flagship with a bar and a food court kiosk run on different shapes, so show each outlet against its own last four weeks.
- Wastage by reason code and item
- Covers per labour hour, kitchen and floor separately
- Overtime hours and who approved them
- Comp meals and voids over the threshold
Build the brand view from the outlet rows
The brand view is a sum of the outlet rows plus a ranking, with total covers, total sales, blended food cost and wastage at the top. Each outlet gets one trend arrow.
Add a column for exceptions only. Food cost above its band, wastage above its band and labour hours up while covers fell all qualify, and the owner reads exceptions first and totals second.
If the sheet is rebuilt by hand each week, errors creep in through copy and paste, which is where a shared system reading each till earns its place.
Run the review and keep the loop short
Hold a fifteen minute call on Tuesday afternoon and cover exceptions only, with each outlet manager answering what changed and what they will do before Monday.
Write the action beside the outlet row, so next week’s review begins with last week’s action and nobody can skip the follow-up. That loop is the real value.
Start with one outlet and its last seven days, fill every column, note each missing number and fix those gaps before rolling the sheet out.
Weekly outlet rollup sheet
One printed page, one row per outlet. Ten columns hold dine-in covers, delivery orders, net sales, average cheque, food cost against recipe cards, wastage by reason, kitchen hours, floor hours, open issues and the action owner. Tab two holds the brand total. Beside each outlet sits an exceptions list showing its last four weeks of food cost, wastage and labour hours against the band.
Open a blank worksheet to printQuestions owners ask
How many columns should a weekly restaurant rollup have?
Eight to ten columns. The owner reads it in ten minutes. Detail such as item level wastage stays with the outlet manager and is pulled in only when an exception needs explaining. A short sheet gets filled in on time, while a long one gets skipped by the busiest managers, usually during the Monday rush.
Should every outlet use the same food cost target?
No. A bakery counter, a bar led venue and a full kitchen carry very different costs, so one target would flag the wrong outlets every week. Set a band for each outlet from its own recent weeks, and flag movement outside that band instead of comparing outlets with each other.
Who fills the sheet, the outlet or head office?
The outlet enters stock counts and wastage. Tills and payroll supply the rest. Head office only reviews the rows and builds the brand view, so no number is ever retyped between outlet sheets and the group file.
When does a spreadsheet stop being enough?
When filling it takes longer than reading it, or when two outlets give different answers to the same question about food cost, labour or last week’s covers. Then a shared system is next. Groups often reach that point around the third or fourth outlet, when Monday morning is spent chasing files, correcting copied totals and arguing over whose column means what.