Free pub management templates for UK licensees

Last updated: 11 April 2026

Most pub operators spend three hours a week managing spreadsheets that don’t talk to each other, and half the data disappears when someone forgets to update the file. You’re running a pub, not an accounting firm—yet your Excel workbook has become your de facto management system. The reality is that you don’t need expensive EPOS software or management platforms to get the basics right; you need a properly designed template that actually reflects how a pub operates. I’ve built and tested these templates across Teal Farm Pub in Washington, Tyne & Wear, which handles wet sales, dry sales, quiz nights, and match day events simultaneously—so they work in real conditions, not just theory. In this guide, you’ll find free templates covering staff scheduling, stock management, cash reconciliation, and compliance checklists, plus the specific metrics that actually matter to your bottom line. By the end, you’ll know which templates solve your biggest operational headache and where to find or build them.

Why Pub Operators Need Dedicated Templates (Not Generic Ones)

The most important thing to understand is that pub management is structurally different from restaurant management, and restaurant templates won’t work for you. A restaurant focuses on table turnover, covers, and kitchen prep. A pub has to juggle draught beer inventory, cash-heavy payments, standing bar traffic, quiz nights, football matches, and the occasional private function. Most templates you find online are built for cafes or restaurants. They assume food is your primary revenue driver. They don’t account for the fact that you might need three staff on a Saturday night for a quiz with 60 people, and zero additional staff the following Tuesday.

I learned this the hard way. When I first started using generic business templates at Teal Farm, I spent 90 minutes every Friday doing a manual cellar count because the spreadsheet had no logic for par levels, supplier rotation, or tied product flagging. A pub-specific template would have automated half of that work. The real cost of poor templates isn’t the money you pay for them—it’s the 15 hours a month you lose to manual data entry and re-checking figures that should’ve been automated.

UK pubs also operate under specific regulatory constraints. You need to track staff hours for working time regulations, maintain age verification logs for the licensing authority, document food hygiene procedures if you serve food, and keep evidence of your premises licence compliance. Generic templates don’t include these fields because a normal business doesn’t need them. Your template must include them or you’ll be scrambling to recreate records during a premises licence renewal or a local authority spot-check.

Staff Scheduling Templates for Pubs

Pub staffing is not nine-to-five. You need a template that handles variable hours, covers, shift swaps, and the fact that you have completely different staffing needs on a quiz night versus a quiet Tuesday lunchtime. A basic scheduling template will show you who’s working when, but a pub-specific one will also flag understaffing during predicted busy periods, track rota compliance against working time regulations, and highlight cover shortages.

What a good pub scheduling template should include:

• Shift patterns by day type: Separate templates or views for match days, quiz nights, food service days, and quiet periods. This is non-negotiable because your staffing model for a Saturday with food service is completely different from a Wednesday quiz.
• Staff role assignments: Bar staff, kitchen (if applicable), floor cover, and management. This prevents you rostering a kitchen-only person to cover the bar.
• Working time regulation tracking: A rolling 17-week view showing hours per staff member to ensure you stay within the 48-hour per-week average (with rest day tracking). The Health & Safety Executive has clear guidance on this, and licensees get audited.
• Cover request log: A simple field where staff can request specific dates off, which auto-populates into your main rota so you never accidentally double-book someone.
• Shift cost calculation: If you’ve logged hourly rates, this template can auto-calculate your wage cost for the week against forecasted covers or revenue.

When I’m managing 17 staff across front-of-house and kitchen, I use a master template that covers a rolling four-week period. It’s colour-coded by shift type (day, evening, full, quiz cover), and I review it every Sunday evening against the following week’s events. A pub staffing cost calculator helps you stress-test your planned rota against payroll budget, but the template itself should be simple enough that a manager can update it in 20 minutes.

One specific insight from running real rotas: always build in one named ‘floater’ shift per week that can be assigned on short notice. You’ll use it for cover, for busy events you didn’t predict, and for training. The best pub schedulers I know build this in from the start rather than scrambling on Wednesday when someone calls in sick.

Stock Control and Cellar Management Templates

Cellar management integration matters more than most operators realise until they’re doing a Friday stock count manually, which takes two hours and still doesn’t reconcile. A dedicated stock control template doesn’t replace a full inventory system, but it absolutely removes the chaos from weekly counts and helps you spot shrinkage patterns fast.

Core elements of a usable cellar management template:

• Par level tracking: What quantity of each product should you have in stock? The template lists par (e.g., 20 kegs of bitter, 8 boxes of house wine), current stock, and a red flag if you’re below par. This prevents running out of your best-seller mid-service.
• Supplier rotation: If you’re tied to a pubco or use multiple suppliers, flag which product comes from which supplier. This matters enormously when you’re reconciling invoices or when the pubco asks about product mix. I use a simple colour-coding system: tied products in red, free-pour wine in green, spirits in blue.
• Delivery logging: Date received, quantity, invoice number, cost per unit. This is your evidence trail if figures don’t match at month-end.
• Weekly usage calculation: Opening stock + deliveries − closing stock = usage. A good template calculates this automatically so you can spot unusual weeks at a glance (which might indicate theft, spillage, or over-pouring).
• Variance tracking: Most pubs accept 2–3% shrinkage (breakage, spillage, tasting pours). Your template should flag anything above that threshold so you know when to investigate.

The template I use at Teal Farm is deliberately simple: columns for date, product name, opening stock, deliveries, closing stock, usage, cost, and notes. The notes field is crucial—if a keg was dropped, or someone was training on espresso, you log it there. Otherwise you’re staring at an unusual figure and guessing.

One operational detail that matters: take your stock count at the same time every week (I do Friday morning at 11am), before service starts. If you count on Tuesday and then again Friday, you’re including Wednesday and Thursday sales—which means you can’t directly compare to previous weeks or spot inconsistencies. Consistency in counting method is half the battle.

Cash Handling and Till Reconciliation Templates

Cash reconciliation is non-negotiable for a pub. Your till should balance every day, but reality is messier—staff shortages, forgotten cash-ups, card-only payments, and the occasional till error. A cash reconciliation template isn’t fancy, but it’s essential for spotting patterns and for your accountant.

The absolute minimum template should track:

• Till opening balance and closing balance (physical count).
• Expected closing balance (based on till read-out or Z-report from your EPOS system).
• Variance (actual minus expected).
• Explanation of variance (staff training, void, customer refund, etc.).
• Name of person doing the count and date/time.

I’ve seen licensees lose thousands because they didn’t notice a consistent £50 shortage every Tuesday until it was too late to investigate. A simple rolling 13-week template flagged the pattern immediately—it turned out a staff member wasn’t closing out their float properly. When running a pub profit margin calculator, you need clean cash data or the figures are meaningless.

If you’re using card payments alongside cash (which almost all pubs do now), add a column for card float and track it separately. Many till reconciliation mistakes come from people mixing cash and card floats together.

Financial Tracking Templates for Pubs

You don’t need an accountant’s ledger system to track basic pub finances. A simple monthly income and expense template gives you early warning if costs are creeping up or if revenue is dropping. The most useful template separates wet sales (draught, bottles, spirits) from dry sales (food) from other income (gaming, quiz fees, quiz machine takings), because they have different margins and different operational drivers.

A working pub finance template includes:

• Weekly revenue by category: Separate lines for draught, bottled drinks, spirits, food, other. This tells you immediately if draught sales are down (which might mean a cellar issue, pricing problem, or changed customer preference).
• Cost of goods sold (COGS) by category: What did that week’s stock cost you? This is where your cellar counts feed in. A good template auto-calculates COGS percentage (cost ÷ revenue) so you spot when margins are tightening.
• Fixed costs: Rent, rates, utilities, insurance, licence fees. These shouldn’t move weekly, but log them monthly so you know your true breakeven point.
• Variable costs: Wages (pulled from your rota template), supplier invoices, cleaning, repairs. These are where most drift happens.
• Monthly profit: The template auto-calculates this, so you know your actual position every month, not just at year-end.

The most effective way to track pub finances is to separate controllable costs from fixed costs, because they require completely different management responses. If your rent goes up, you have limited options. If your wage bill is creeping up because you’re over-staffing quiet periods, you can fix that immediately. A good template makes this distinction obvious.

Use your pub drink pricing calculator in tandem with this template. If your margins are below target, you need to know whether it’s a pricing issue, a COGS issue, or a sales mix issue. The pricing calculator helps you model changes without guessing.

Compliance and Health & Safety Checklists

UK pubs operate under multiple layers of compliance: the Licensing Act 2003, food safety regulations (if you serve food), working time regulations, and data protection. A compliance template isn’t exciting, but it’s the difference between a smooth premises licence renewal and a licensing hearing.

Essential compliance checklists for any UK pub:

• Age verification log: The Licensing Act requires you to have a system for recording refused sales and age verification challenges. A simple template with columns for date, time, product, customer detail (if applicable), and staff member doing the refusal. You don’t need to refuse 50 people a week to be compliant, but you must have evidence of your procedures.
• Premises licence compliance checklist: Your licence has specific conditions (maybe no noise after 11pm, maybe you’re required to have CCTV, maybe you’re tied to a specific pubco). A monthly checklist confirming you’re meeting each condition. This isn’t paranoia—it’s evidence if ever questioned.
• Staff training log: Document when staff have been trained on age verification, safeguarding, health & safety, and food hygiene (if applicable). Your local licensing officer will ask for this at renewal. A simple template with staff name, training topic, date, and trainer name.
• Health & safety checklist: Equipment maintenance (fire extinguishers, fryers, ice machines), accident log, spillage and breakage log. These aren’t optional—they’re required under general health and safety law.
• Food safety (if applicable): Temperature logs for fridges and freezers, cleaning schedules, pest control records, supplier documentation. If you serve food, the Environmental Health Officer has access to these during routine inspections.

One of the most valuable compliance templates I’ve seen is a “red flag” checklist that triggers an action. For example: “Temperature log shows fridge above 5°C” → immediate action is to get fridge serviced and get temperature back down, and that action is logged. When an inspector asks, “Show me your fridge maintenance history,” you have a paper trail showing you spotted and fixed the issue.

Your pub IT solutions should ideally integrate with your compliance records, but at minimum, your templates should be stored securely (not in random email attachments) and backed up monthly. If a licensing officer asks for your staff training records and they’re lost, that’s a compliance failure.

For more information, visit pub staffing cost calculator.