Pub Staff Rota Template: The UK Landlord’s Practical Guide

Last updated: 10 April 2026

Most UK pub landlords are still managing staff rotas in Excel spreadsheets that break every time someone inserts a row, or worse—on scraps of paper pinned behind the bar. You know the problem: staff texting last-minute to swap shifts, no visibility into who’s actually working tonight, labour costs creeping up without warning, and hours wasted each week manually juggling names across a chaotic spreadsheet.

A proper pub staff rota template isn’t just a nice-to-have admin tool. It’s one of the fastest ways to cut hidden labour costs, prevent understaffing disasters, and reclaim the 15-20 hours per month you’re currently losing to scheduling admin. I’ve tracked this at The Teal Farm—when we moved from scattered rotas to a structured system, we saw labour visibility improve immediately and costs drop within the first two weeks.

This guide will show you exactly what a working rota template looks like, how to set one up (even if you’ve got no spreadsheet skills), the common mistakes that spike labour costs, and how to automate the entire process so it actually works in real life.

What a Pub Staff Rota Template Actually Is

A pub staff rota template is a pre-built scheduling framework that shows who works which shifts across a defined period (usually a week or fortnight), along with their pay rates, break times, and labour costs. It’s not just a list of names against dates—it’s a working document that tracks labour spend in real time.

In practice, a rota template includes:

• Staff names and roles (manager, experienced bar staff, new starters, kitchen)
• Shift times (opening, afternoon, evening, late close)
• Hourly rates (so you see actual cost per shift, not just hours)
• Break allocations (prevents unpaid breaks from being missed)
• Running labour cost (shows if you’re on budget for that shift or over)
• Notes column (for swaps, training, or special requirements)

The real value isn’t the pretty layout. It’s that a proper rota template forces visibility into labour spend—you can see at a glance whether your Friday night shift costs £280 or £340, whether you’re over-staffed on quiet Tuesday lunchtimes, and whether a staff member’s sick day actually hurt your margin or gave you a free cost reduction.

Why Your Current System Is Costing You Money

If you’re managing staff rotas in Excel, Google Sheets, or (heaven forbid) a wall-mounted paper chart, you’re losing money in ways you probably can’t see. Here’s what I’ve observed at The Teal Farm and across dozens of pubs I’ve worked with:

The Hidden Costs of Manual Rotas

Labour cost blindness. Most manual rotas show who’s working—not what it costs. You schedule “John” on Friday evening without seeing that John’s on £12.50/hour and the shift is 6 hours—that’s £75 in labour cost before you even consider whether Friday evening is busy enough to justify it. Multiply that across a full week and you’re guessing about your single biggest controllable cost.

Overstaffing creep. Without real-time cost visibility, it’s easy to accidentally schedule too many people during quiet periods. You think “better safe than sorry,” but “safe” is costing you £30-50 per shift on a slow Tuesday. That’s £150-250 lost per week—over £7,000 per year—from a simple visibility problem.

At The Teal Farm, tracking pub staffing costs alone in the first week revealed we were overstaffed by roughly one person per shift on Monday-Wednesday lunchtimes. One small change saved us nearly £300 per week.

Admin time that doesn’t earn revenue. Manual rotas take 3-5 hours per week to build, update, handle shift swaps, chase confirmations, and resolve scheduling conflicts. That’s 15-20 hours monthly. At £15/hour of your time (conservative for a pub owner), that’s £225-300 per month you’re not spending on marketing, customer experience, or profit-generating activities.

Scheduling errors that cost more to fix than prevent. No-shows, double bookings, forgotten swaps, and last-minute overtime requests are all symptoms of a rota system that isn’t working. One unexpected £20 taxi fare to cover a no-show, or 4 hours of emergency overtime at 1.5x rates, and you’ve wiped out your rota-building time savings.

Essential Elements of an Effective Rota Template

If you’re starting from scratch, your rota template needs specific columns and structure to actually control costs. Here’s what a working template looks like:

Column Headers (Minimum)

• Staff Name — clear, full first and last name (prevents confusion)
• Role — manager, bar, kitchen, cleaner (shows who covers what)
• Mon-Sun — shift times or “OFF” (one column per day)
• Hourly Rate — exact rate for that person (critical for cost calculation)
• Shift Cost — hours × rate (or formula-calculated)
• Weekly Labour Cost — sum of all shifts for that staff member
• Total Labour Cost (week) — grand total across all staff
• Labour % of Forecast Revenue — your actual spend vs. target (usually 20-28%)

Layout Structure

The most effective rotas use this structure:

Week-view format (not day-view). Show one person per row and all seven days across the top. This makes it easy to spot over-scheduling and under-scheduling at a glance. A person who works 6 shifts one week and 2 shifts the next is immediately visible.

Shift times, not just names. Instead of “John — Fri”, write “John — 18:00-23:00” (or “6pm-11pm”). This prevents confusion, ensures everyone knows their start and end time, and makes it easy to calculate actual hours worked.

Separate section for shifts by time slot. Create a sub-table showing how many bar staff you need during opening (10am-12pm), lunch rush (12pm-2pm), afternoon quiet (2pm-5pm), dinner prep (5pm-6pm), evening service (6pm-10pm), and late close (10pm-close). This forces you to schedule staff to actual demand, not guesses.

How to Build Your First Rota Template

Here’s the fastest way to get a working rota template in place, even if you’ve never built a spreadsheet before:

Step 1: Create the Framework

Open Excel or Google Sheets. Create these rows:

• Row 1: “Week of [date]” and “Forecast Revenue: £[amount]”
• Row 2: Days of the week (Mon, Tue, Wed, Thu, Fri, Sat, Sun)
• Row 3: Shift times for each day (or leave blank if shifts vary)
• Row 4 onwards: One person per row

This layout makes it instantly obvious what week you’re viewing and what you’re budgeted to earn.

Step 2: Add Staff Names and Rates

List every person who might work that week. Include:

• Full name
• Role (manager, bar, kitchen, casual)
• Hourly rate
• Any constraints (can’t work after 11pm, only weekends, etc.)

This is where you prevent future arguments. Once you’ve written someone’s rate, there’s no confusion about what they should be paid. Keep a master staff list that never changes unless someone gets a pay rise.

Step 3: Fill In Shifts Against Demand

For each day, write the shift time next to the staff member’s name. Use a format like “18:00-23:00” or “OFF” if they’re not working.

The critical rule: Schedule based on expected revenue and customer volume, not on “who asked for hours.” If Tuesday lunch is quiet, you need one bar person, not two, even if both asked for shifts.

Step 4: Add Cost Calculations

Create a formula that multiplies hours worked × hourly rate. At the bottom, sum all staff costs for that week.

Compare this total to your forecast revenue. Labour should be 20-28% of revenue for most pubs (varies by style—gastropub higher, basic pub lower). If you’re at 35%, you need to reduce staff or increase sales.

Step 5: Build in a Swaps and Notes Section

Add a column for notes: “Swap with Tom Fri”, “Training day”, “Holiday cover”, “1.5x pay (bank holiday)”. This creates an audit trail and prevents last-minute surprises.

Common Rota Mistakes That Spike Labour Costs

Even experienced pub owners make these errors—and they cost real money:

Mistake 1: Not Scheduling to Actual Demand

You look at next week’s rota and add staff because “it’s a bank holiday” or “it’s summer”—without checking whether your forecast revenue actually justifies it. Bank holidays are busy, but if your forecast shows only 10% more customers, you don’t need 25% more staff.

Fix: Link your rota directly to your forecast revenue. If you forecast £1,200 Tuesday lunch, work backwards: £1,200 × 25% labour target = £300 labour cost. At £12/hour, that’s 25 hours. One person working 12-4 (5 hours) needs backfill. Two people working 12-2 covers it. That’s your schedule. Done.

Mistake 2: Forgetting Break Costs

You schedule John for a 6-hour shift and assume 6 hours × £12 = £72. But John takes a 30-minute unpaid break, so you pay for 5.5 hours. Except you’ve also paid him for a 15-minute paid break. Your calculation was wrong by 45 minutes.

Multiply that across a full team and you’re off by hours every week.

Fix: Build break time into your cost formula. For a 6-hour shift, calculate as (6 hours – 0.5 unpaid break + 0.25 paid break) × rate.

Mistake 3: Hidden Overtime Creep

Someone calls in sick. You ask John to stay an extra 2 hours at 1.5x pay. You don’t put it in the rota because “it’s just covering.” By week’s end, you’ve authorized £80 in unbudgeted overtime without realizing it.

Fix: Create an “actual hours worked” rota below your “planned” rota. Update it in real time. Every shift change, every swap, every overtime request goes in immediately. This forces you to see actual vs. planned labour cost before it surprises you at payroll.

Mistake 4: Over-Scheduling “Just in Case”

You schedule three bar staff on a Tuesday night “to be safe.” Tuesday is quiet. Two of them spend the night on their phones. You’ve wasted 4 hours of labour (roughly £50) on a precaution that didn’t pay off.

Fix: Build a “minimum viable staffing” rule. Tuesday lunch needs one bar person and one backup (kitchen/manager overlap). That’s non-negotiable. Thursday-Saturday nights need three. Monday is one. Write it down. Follow it. Only break the rule if you have actual evidence (a private party, unexpected event) that demand is higher.

Moving Beyond Spreadsheets: Automation That Works

A spreadsheet rota is better than no rota. But it still requires you to manually update it, calculate costs, and chase confirmations.

The problem with manual rotas gets worse as your pub grows. If you have 25 staff instead of 8, a spreadsheet becomes a liability—it breaks, formulas disappear, people don’t see updates, and you’re back to scheduling chaos.

The better approach is a system that automates three things:

1. Automatic cost calculation. The moment you enter a shift time, the system calculates labour cost and shows you immediately whether you’re over budget. No manual math. No errors.

2. Real-time visibility for staff. Staff see their shifts on a mobile app or dashboard. When someone needs to swap, they request it in the system—not via text. You approve or deny in seconds. The rota updates automatically. No confusion.

3. Actual vs. planned tracking. As staff clock in and out (via a system or manually), your actual labour cost is calculated in real time. Friday ended up costing £340 instead of £280? You see it immediately and know why. At The Teal Farm, this visibility alone has helped us catch overstaffing and cost overruns before they become problems.

The issue is that most generic hospitality software charges £30-50 per month and makes you pay for features you don’t need. That’s why most pub owners stick with broken spreadsheets—the math doesn’t work for a small team.

What actually works for most UK pubs is a system designed specifically for pub management. Pub Command Centre is built for exactly this—it’s a one-time £97 investment (no monthly fees, no subscriptions) that includes rota management, labour cost tracking, cash flow forecasting, and inventory integration. Setup takes 30 minutes even if you’ve never used software before.

The return on that single investment is usually visible in the first week. You catch one overstaffing mistake, you save £50. Prevent one scheduling error (no-show, overtime), you save another £20-30. By the end of the first month, you’ve recouped the cost and gained a system that eliminates 10-15 hours of admin per week.

Frequently Asked Questions

For most pub owners, the rota is where operational chaos begins. Hours are lost to admin, costs creep up unnoticed, and staff feel confused about their schedule. A proper rota template—whether you build it in a spreadsheet or move to a dedicated system—is one of the fastest ways to regain control of your single biggest controllable cost.

The UK pub owners winning right now aren’t necessarily the ones with the most customers. They’re the ones who see their labour costs in real time and adjust before the problem becomes a crisis. Control your staffing costs properly and the rest of the business becomes easier to manage.

For more information, visit RankFlow free trial.

For more information, visit SmartPubTools.

For more information, visit RankFlow marketing tools.