Free Weekly Report Templates for UK Pubs

Last updated: 7 April 2026

Most UK pub landlords spend 5 to 10 hours every week buried in spreadsheets, chasing numbers that should be instant and obvious. Yet the moment they stop doing that work, they’ve lost control entirely. This isn’t a problem with your discipline — it’s a problem with your tools. The real opportunity isn’t better spreadsheets. It’s stopping the spreadsheet work altogether by using a system that reports to you, not the other way around.

A weekly pub report template should do one thing: show you instantly whether your pub is on track or heading for trouble. Not next month. Not after you’ve spent three hours reconciling numbers. Right now. Most pub owners I’ve worked with — from tenants managing single units to freehold operators — tell me the same thing: they have no idea what their actual weekly position is until it’s far too late to do anything about it.

In this guide, I’ll show you exactly what belongs in a weekly report template, why most templates fail, and how to move from manual reporting to real-time control. You’ll also discover why SmartPubTools users stop doing weekly reports entirely because their system shows them the same data automatically.

What a Pub Weekly Report Template Actually Needs

A pub weekly report template isn’t a fancy document. It’s a signal. Every week, it should answer four simple questions: Did we hit sales target? Are labour costs in line? Is our cash safe? Are we finding money or losing it? If your template can’t answer those four questions in under 60 seconds, it’s too complicated.

I built The Teal Farm from the ground up, and the first thing I stopped doing was creating elaborate reports that looked professional but told me nothing useful. The most effective pub weekly reports are brutally simple: one page, five numbers, one decision point.

Here’s what must be in every pub weekly report:

• Sales vs target — This week’s revenue against your plan. If you hit 95% or above, you’re on track. If you’re at 90%, you need to know why before Monday morning.
• Labour cost percentage — Total labour spend divided by sales. For most UK pubs, this sits between 25-32%. Anything above 35% is a red flag that week.
• Cash position — How much money do you actually have available right now? Not profit. Cash. The difference kills more pubs than bad profit.
• Margin variance — What you expected to make vs what you actually made. This catches theft, waste, and pricing problems in real time.
• Stock movement — Bottles sold vs bottles recorded. Shrinkage over 3% per week is abnormal and needs investigation immediately.

The reason most templates fail is because they’re built around data entry, not insight. They require you to manually input numbers from three different sources, reconcile discrepancies, and then calculate ratios. By the time you’ve finished, the week is already gone and nothing has changed. Pub manager reporting should be automated, not manual.

Why Most Templates Fail (And What Works Instead)

I’ve seen hundreds of pub weekly report templates. Excel spreadsheets with colour-coded tabs. Google Sheets shared between managers. PDF templates filled in by hand. Almost all of them share the same fatal flaw: they measure last week’s performance, not this week’s decisions.

By Friday afternoon when you sit down to create your weekly report, the week is finished. You can’t change what happened Monday through Wednesday. You can only see it. So a traditional weekly report template is really just a post-mortem — a way to confirm you either made money or you didn’t.

What works instead is real-time visibility into the numbers that matter. Instead of waiting until Friday to know your labour percentage, you know it every single shift. Instead of discovering margin problems when you reconcile stock on Sunday, you spot them the moment a transaction doesn’t match your pricing.

The businesses that scale — whether they’re pubs, bars, or restaurants — aren’t the ones with the best templates. They’re the ones that stopped using templates and started using systems. The template is just the thinking that went into building the system.

At The Teal Farm, I used to spend Thursday evenings creating a weekly report. It took about 90 minutes. I’d pull data from my till, my labour scheduling software, my stock take records, and my bank account. Then I’d build a spreadsheet, calculate ratios, highlight anomalies, and file it away. Did I act on those reports? Sometimes. Did they prevent problems? Almost never, because by the time I saw the problem, a full week had passed.

Now I don’t create a weekly report at all. I check the numbers I need every morning in about 3 minutes, and if something’s wrong, I’m dealing with it that day, not that week. That’s the shift you need to make. Your template isn’t the destination — moving past templates is.

The Key Metrics Every Report Must Show

If you’re building a free weekly report template right now, these are the five metrics that actually matter. Skip everything else. No executive summaries. No trend analysis that you won’t read. Just these five numbers.

1. Weekly Sales vs Target

Write down your sales target for the week. For most UK pubs, this is based on a rolling 13-week average. Every Friday, you should know: did we hit 95%+ of target, or did we fall short?

If you fall short, write down why. Event cancelled? Bad weather? Staff absence? Competitor opened nearby? This is your only narrative field. Everything else is numbers.

2. Labour Cost as Percentage of Sales

This is the single biggest controllable cost in any pub. Calculate it this way:

Total labour cost this week ÷ Total sales this week × 100 = Labour percentage

For example: £2,400 labour ÷ £8,000 sales × 100 = 30% labour cost.

What’s the right number? 30% is generally acceptable for a typical UK pub, but this varies. Food-heavy venues run higher. Quiet country pubs run lower. Know your benchmark, and flag any week that’s 3+ percentage points above your target.

Tracking staffing costs alone saved The Teal Farm thousands in the first 12 months because it forced conversations about scheduling, break relief, and whether casual staff numbers matched actual demand.

3. Cash Position (Not Profit)

This is the number that keeps pub landlords awake. You can be profitable on paper and broke in the bank account. Your weekly report must show:

• Opening bank balance Monday morning
• Total cash in (sales, loans, investor funds)
• Total cash out (wages, suppliers, rent, utilities)
• Closing bank balance Friday evening

If your closing balance is below one week of operating costs, you’re at risk. Most pub landlords should maintain a cash buffer of at least two weeks of expenses. Cash flow kills more pubs than lack of profit, and your weekly report is your early warning system.

4. Actual Margin vs Expected Margin

This catches everything: theft, waste, pricing errors, and free pours.

Calculate it like this:

Expected cost of goods sold = Opening stock + Purchases – Closing stock

Actual cost of goods sold = (Bottles in – Bottles out) × Average selling price

If these numbers don’t match, you have a problem. Most pubs accept 2-3% variance due to spillage, sampling, and rounding. Anything above 5% needs investigation that week.

5. Stock Shrinkage Rate

Every bottle that walks out the door should be rung through the till or written down as waste. If bottles are disappearing with no record, you have a problem.

Calculate it like this:

Bottles unaccounted for ÷ Total bottles purchased × 100 = Shrinkage percentage

Acceptable shrinkage is 1-2% per week (mostly spillage and waste). Anything above 3% suggests theft or incredibly loose control. If you see 5%+ consistently, you need to look at your staff, your systems, or both.

Spirit margin tracking is where most pub owners find thousands of pounds in hidden losses because it forces you to match transactions to physical stock every single week.

How to Build Your Own Free Template

If you want to create a basic free weekly report template right now, here’s the structure that works:

Step 1: Create a Simple Spreadsheet

Open Google Sheets or Excel. Create columns for:

• Week ending (date)
• Weekly sales
• Sales target
• % of target achieved
• Labour cost (£)
• Labour % of sales
• Opening cash balance
• Closing cash balance
• Variance from expected margin (%)
• Stock shrinkage (%)
• Notes (one sentence max)

Step 2: Set Up Formulas (Not Manual Entry)

Don’t manually calculate these numbers every week. Build formulas instead. Set up your spreadsheet so that you only enter the raw numbers (sales, labour total, opening/closing cash, stock counts), and everything else calculates automatically.

This saves time and eliminates calculation errors.

Step 3: Set Thresholds and Flags

Use conditional formatting (the colour-coding feature in Google Sheets and Excel) so that:

• Green = all metrics on target
• Amber = one metric is 5%+ off target
• Red = two or more metrics are significantly off, or cash position is dangerously low

This gives you a visual signal immediately. If your report is mostly green, you’re winning. If you see red, you have work to do this week.

Step 4: Fill It In Every Friday (15 Minutes Maximum)

Every Friday afternoon, spend 15 minutes entering the five raw numbers. Everything else happens automatically. Review the flags. If anything is red or amber, write a one-sentence note about why and what you’re going to do about it.

That’s your entire weekly reporting process. Save the spreadsheet. You now have a permanent record of your pub’s performance.

Step 5: Act on It

A template is useless if you don’t use it. If labour cost is consistently 5% above target, you need to address scheduling, break relief, or pricing. If cash is tight, you need to look at creditor payment terms or slow-moving stock. If shrinkage is high, you need better till discipline or staff conversations.

The template is just a tool. The work is in the decisions that follow.

The Problem With Manual Reporting (And When to Stop)

Let me be direct: if you’re still creating manual weekly reports in 2026, you’re burning time you don’t have.

A free spreadsheet template might cost you nothing upfront, but it costs you 60-90 minutes every single week. That’s 3,000-4,500 minutes per year. That’s over 60 hours of admin work that you’ll never get back. Most pub owners find thousands of pounds in hidden savings in their first week once they move from manual tracking to automated systems, and that’s because they suddenly have time to actually manage the business instead of reporting on it.

Here’s the hidden problem with templates: they only show you last week’s numbers. By the time you see a problem, it’s too late to do anything about it. Your labour cost was high last week? You can’t change what happened. You can only plan better next week. Your margins were soft? That stock has already been sold. Your cash is low? You should have dealt with that three weeks ago when creditor payments were due.

The moment you have the chance to move to a real system — one that shows you today’s numbers in real-time and flags problems the same day they happen — you should make that leap. Pub Command Centre users don’t create weekly reports because the system delivers the same insight automatically. They spend 30 minutes on setup and never touch a spreadsheet again.

Most businesses stay with spreadsheets because they’re free. The real cost isn’t the software. It’s the time you spend maintaining it, the errors that slip through, and the decisions you make too late because you didn’t have current information. Pub money management tools have moved far beyond templates. They show you what’s happening right now.

If you’re ready to move past weekly reports entirely and get real-time visibility instead, that’s the moment you’ve solved the actual problem, not just the symptom.

When Weekly Reports Actually Work (And When They Don’t)

A free weekly report template works when:

• You’re willing to spend 15 minutes every Friday entering data consistently
• You have discipline to act on what the report shows you
• Your team understands the metrics and can help you gather the raw numbers
• You’re not trying to track 20+ different metrics — you’re focused on five that matter

A weekly report template doesn’t work when:

• You skip weeks because you’re too busy or forget
• The data is always days old by the time you compile it
• Different team members pull numbers from different sources and they never match
• You spend more time fixing calculation errors than actually reading the report
• You spot a problem in the report but have no way to dig deeper into why it happened

The most effective way to use a pub weekly report template is to treat it as a transition tool, not a permanent solution. Use it for 8-12 weeks to understand what metrics matter in your business. Once you know that, move to a system that automates the reporting and gives you real-time data.

According to Federation of Small Businesses research on small business management practices, businesses that use automated financial tracking make faster, better decisions than those relying on manual reports. The difference in profitability is measurable within the first quarter.

For more information, visit RankFlow free trial.

For more information, visit RankFlow marketing tools.