Free tool · Kitchen & FOH

Kitchen and front-of-house on one rota sheet.

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.

No email required

Download the kitchen & front-of-house rota template

Works in Microsoft Excel (2016 or newer), Google Sheets, Apple Numbers and LibreOffice Calc.

Roles included: Head chef, Sous chef, Chef de partie, KP, Pass, Host, Server, Runner

Why this one

Why both halves belong on one sheet.

  • One labour figure, not two. Kitchens and floors are usually rostered by different people on different documents, and nobody sees the total until the wage bill lands. Costing them together is the whole point.
  • Split shifts work properly. A chef on 11:00–15:00 and 18:00–23:00 is two rows, two sets of hours, and the eleven-hour rest check reads them as one day — which is exactly how you catch a brigade being quietly overworked.
  • Prep time is rostered. Service is the visible part; the four hours of prep before it are the expensive part. Give prep its own rows or your food labour percentage will never make sense.
  • KP hours are real hours. The most commonly under-rostered role in the building, and the one that quietly wrecks a service when it is short.
What it looks like

One row per shift. The maths looks after itself.

The two check columns stay blank until something needs a second look.

DayRoleNameStartEndBreakHoursRateCostBreak checkRest check
FridayDuty managerAlice09:0017:00307.50£12.50£93.75
FridayBarBob17:0001:0008.00£12.50£100.00Needs a 20-min break
SaturdayBarBob09:0017:00307.50£12.50£93.75Under 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.

Going further

The chef who resigns at four o'clock.

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.

The two checks

What the flags mean.

“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.

Other versions

Same engine, different role list.

See also: everything else we build for restaurants, and the labour-cost percentage guide for how to set the target you are rostering against.

Being honest about it

When the spreadsheet stops working.

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.

See how the rota module works Pricing from £49

Common questions

About this template.

How do I roster a split shift?

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.

Should prep time go on the rota?

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.

Can I separate kitchen and floor labour?

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.

Does it work for a restaurant that opens lunch and dinner?

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.

Is it really free?

Yes. No email, no sign-up. Download it, adapt it to your brigade, share it with whoever needs it.