Free tool · Bar rota template

A bar rota template that understands a 2am finish.

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.

No email required

Download the bar rota template

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

Roles included: Duty manager, Bar, Cocktail bar, Barback, Glass collector, Door

Why this one

Built for the way a bar actually staffs.

  • Barback and prep are rostered, not absorbed. Someone cuts the garnish, batches the syrups and stocks the wells before doors. If that hour is unrostered it is still paid — it is just invisible in your labour figure until payday.
  • Overnight is the normal case, not the exception. A 19:00 to 03:00 shift is eight hours here. Any template that returns a negative number for your standard Saturday was not written for a bar.
  • The eleven-hour rest check is the one that matters. Close at 03:00 and open at 12:00 is nine hours. It happens constantly in late-trading venues and it is a Working Time breach, flagged here the moment you enter it.
  • Door staff cost real money. Whether they are your staff or an agency, put the hours on the sheet so the true cost of a late Saturday is visible next to what the late Saturday takes.
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

Costing a late licence honestly.

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.

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 bars, 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 handle a shift that ends at 3am?

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.

Where do I put prep and batching time?

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.

Can I roster agency door staff on it?

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.

What is the eleven-hour rest check?

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.

Is it really free?

Yes. No email address, no sign-up, no trial. Use it and pass it on.