General hospitality
The neutral version if your roles are simpler.
Head chef through to KP, host through to runner — both halves of the building on the same week, costed together. Because the only labour number that means anything is the one that includes everybody.
Works in Microsoft Excel (2016 or newer), Google Sheets, Apple Numbers and LibreOffice Calc.
The two check columns stay blank until something needs a second look.
| Day | Role | Name | Start | End | Break | Hours | Rate | Cost | Break check | Rest check |
|---|---|---|---|---|---|---|---|---|---|---|
| Friday | Duty manager | Alice | 09:00 | 17:00 | 30 | 7.50 | £12.50 | £93.75 | ||
| Friday | Bar | Bob | 17:00 | 01:00 | 0 | 8.00 | £12.50 | £100.00 | Needs a 20-min break | |
| Saturday | Bar | Bob | 09:00 | 17:00 | 30 | 7.50 | £12.50 | £93.75 | Under 11h rest |
Bob finishes at 01:00 and is back at 09:00 — eight hours later. That is the rota mistake nobody spots until someone is too tired to be at work, and it is what the rest check exists to catch.
Every kitchen has had the Friday where someone does not turn up and the rota becomes a phone tree. The spreadsheet cannot help with that part — but it can tell you, in about ten seconds, who is not already working that day and who is not on the edge of a rest-break breach if you call them in.
Sort the sheet by name and you can see each person's week at a glance. It is a crude version of what the app does automatically, and on a bad Friday it is a great deal better than a group chat and a guess.
The rota module turns that into one tap: an open shift goes out to everyone eligible, and the first person to accept fills it. But if you are running on a spreadsheet, sorting by name is the trick.
“Needs a 20-min break” — the shift is longer than six hours and has under twenty minutes of break entered. Under the Working Time Regulations 1998 a worker is entitled to an uninterrupted twenty-minute rest break when daily working time exceeds six hours.
“Under 11h rest” — this shift starts less than eleven hours after the same person's last one finished. The Regulations provide for eleven consecutive hours of rest in each 24-hour period.
Both are a prompt to look again, not legal advice. Stricter limits apply to workers under 18, and some sectors and workforce agreements vary. Check your own obligations.
The neutral version if your roles are simpler.
For a food-led pub with a cellar to look after.
If the bar is the bigger half of the business.
See also: everything else we build for restaurants, and the labour-cost percentage guide for how to set the target you are rostering against.
A spreadsheet is genuinely fine for a small team and a steady week, and plenty of good venues run on one for years.
It stops being fine at a predictable point. It cannot tell your team the rota changed — that is still a message somebody misses. It cannot stop you rostering a person who booked the week off, because it does not know about the holiday. It cannot compare what people actually worked against what you planned, so payday becomes a negotiation. And it cannot let someone claim a shift you could not fill without you re-sending the file.
When those start costing real money, that is the point to move to something that does them. Our rota module publishes to everyone's phone, blocks a double-booking, reconciles planned against actual from clock-in punches, and shows this same labour figure live as you drag shifts around.
As two rows on the same date for the same person — 11:00 to 15:00 and 18:00 to 23:00. Hours and cost add up across both, and the rest check reads them together, so it will not wrongly flag the gap between the two halves of one day as a rest breach.
Yes. Prep is paid time and it is often the largest single block of kitchen hours in the week. If it is not on the sheet, your food labour percentage is fiction. Give it its own rows before service starts.
Not automatically in this version — but because every row carries a role, you can filter or sort by role and total each group. If you want kitchen and front-of-house costed as separate lines against separate targets, that is a reporting job rather than a spreadsheet one.
Yes, and split shifts are exactly why the rest check compares datetimes rather than dates. A lunch and a dinner shift on one day are two rows and one working day.
Yes. No email, no sign-up. Download it, adapt it to your brigade, share it with whoever needs it.