Pub rota template
Adds cellar and a wet-led role list.
Cocktail bar, barback, glass collector and door in the role list. Shifts that cross midnight count properly, prep time gets its own line, and the eleven-hour rest rule is checked before you publish.
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.
Trading two extra hours looks like free revenue until you cost the labour behind it. Those hours usually need the full bar team, a glass collector and often door staff — and they are your most expensive hours of the week, because the wage bill keeps running while the rate of sale drops off after last orders.
Roster a normal night and a late night as two separate copies of this sheet and put the labour percentages side by side. Operators are regularly surprised: the extra hours take perhaps 15% more money and add 30% more labour cost, which makes the late licence a marketing decision rather than a profit one.
That is the entire argument for costing a rota before you publish it rather than reviewing it afterwards.
“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.
Adds cellar and a wet-led role list.
The neutral starting point.
If you run a serious food offer alongside the bar.
See also: everything else we build for bars, 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. Any end time earlier than the start time is treated as the following day, so 19:00 to 03:00 is eight hours. This is the single most common thing a homemade bar rota gets wrong.
Give it its own row, usually against the barback or cocktail bar role, starting before doors. If it is paid time it belongs in the labour figure; leaving it off does not save money, it just hides it until payroll.
Yes — add them as rows with their charge rate in the Rate column. The cost is what matters for the labour percentage, whether or not they are on your payroll. Bear in mind an agency charge rate is not the same as a wage, so your labour percentage will read a little differently.
It flags any shift starting less than eleven hours after the same person's previous shift ended. The Working Time Regulations 1998 provide for eleven consecutive hours of rest in each 24-hour period, and a 03:00 close followed by a lunchtime open breaches it.
Yes. No email address, no sign-up, no trial. Use it and pass it on.