Free tool · Pub rota template

A pub rota template built for a Friday night.

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.

No email required

Download the pub rota template

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

Roles included: Duty manager, Bar, Cellar, Kitchen, Floor, Glass collector, Door

Why this one

What makes it a pub rota template.

  • The roles are already there. Duty manager, bar, cellar, kitchen, floor, glass collector and door. You are not deleting restaurant job titles out of it before you can start.
  • Late shifts add up correctly. A bar shift from 17:00 to 01:00 is eight hours. Most spreadsheet rotas return minus sixteen and the manager quietly rounds it by hand every week.
  • The close-then-open is flagged. Finish at 01:00, back on at 09:00 is eight hours' rest — under the eleven the Working Time Regulations provide for. On a short-staffed week it is astonishingly easy to roster, and the template catches it.
  • Cellar work is a shift, not an afterthought. Line cleaning and a delivery are real rostered hours with a real cost. Give them a row and they show up in the labour figure where they belong.
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

Sports fixtures and the double-handed bar.

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.

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 pubs, 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.

Does it cover door staff and glass collectors?

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.

Will it handle a shift that finishes at 1am?

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.

Can I use it for a sports fixture week?

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.

Does it know about late-night refreshment rules?

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.

Is it really free?

Yes. No email, no sign-up. Download it, change it, share it with the next licensee who asks.