General hospitality
The neutral version — duty manager, bar, kitchen, floor.
Cellar, bar, glass collector and door already in the role list. Late shifts that finish after midnight count properly. And it flags the close-then-open before you publish it — the rota mistake every licensee has made at least once.
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.
A televised fixture does not just fill the pub, it changes the shape of the shift. You want two behind the bar rather than one, a glass collector from kick-off, and often door staff for the evening game — and all three land on the labour line.
Build the fixture week as its own copy of the sheet, cost it, and compare it against a normal week before you commit. A big fixture that takes 40% more but costs 60% more in labour is a busy night that made you poorer, and the only way to know is to have costed it beforehand.
The rota module does this with saved shift templates — a “Sports fixture” pattern you apply to a day and it brings the extra roles with it. In the spreadsheet, keep a second tab as your fixture-day pattern and paste it in.
“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 — duty manager, bar, kitchen, floor.
Cocktail bar, barback and door, for later trading.
If the food side is the bigger half of the business.
See also: everything else we build for pubs, 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.
Yes — both are in the role list already, along with cellar. They are rostered hours with a cost attached, and leaving them off the rota is how a labour figure ends up flattering.
Yes. That is the main reason this template exists. A 17:00 to 01:00 shift is calculated as eight hours, not minus sixteen, so you do not have to split the row or fix it by hand.
Yes. Take a copy of the file for the fixture week, add the extra bar cover, glass collector and door hours, and compare the labour percentage against a normal week before you commit to the staffing.
No — it is a rota, not a licensing tool. If you serve hot food or drink between 23:00 and 05:00 you need the late-night refreshment permission on your premises licence, and that is a licensing matter rather than a rostering one.
Yes. No email, no sign-up. Download it, change it, share it with the next licensee who asks.