Weekly Pub Reports: Free Templates That Actually Work

Last updated: 7 April 2026

Most pub landlords spend 3-5 hours every week manually collating numbers from cash registers, till receipts, staff timesheets, and delivery invoices into a spreadsheet that tells them almost nothing until it’s already too late. By the time you’ve added up last week’s figures, the damage has already been done.

Weekly reporting is the single most underrated business habit in pub management. It’s not glamorous. It doesn’t sell beer or attract customers. But a proper weekly report catches problems in real time — staff cost creep, unexplained till shortfalls, slow-moving stock, margin collapse — before they compound into monthly disasters.

I’ve used everything from handwritten notes in a notebook to complex Excel spreadsheets with 47 columns to real-time dashboards. And after 15 years running The Teal Farm in Washington, I can tell you exactly which approach works and why free templates aren’t always the answer.

This article covers what belongs in a weekly pub report, why most templates fail, and whether a free template or a live system actually saves you time and money. You’ll also get access to a working template you can download right now.

What Should Be In Your Weekly Pub Report?

A weekly pub report doesn’t need to be complex. In fact, complexity is why most templates fail. You need four things and four things only:

1. Sales by Category

Not just total till revenue. You need to see beer separately from spirits, cider from soft drinks, food from drinks. Why? Because if your beer sales drop 12% week-on-week but spirits are up 8%, that tells you something is wrong with supply, pricing, or promotion. A flat total revenue number tells you nothing.

At The Teal Farm, tracking spirits separately revealed that our margin on certain brands had been crushed by a pricing error in the system. We caught it in week two instead of discovering it in month-end reconciliation.

2. Labour Cost as a Percentage of Sales

Not raw labour hours. Not total wage bill. Percentage of sales. This single metric tells you instantly whether your staffing levels are aligned with demand. If labour is 28% in week one and 34% in week two with the same revenue, you either over-scheduled or had unplanned absences. You know this by Wednesday instead of discovering it on the 5th of next month.

3. Cash Position

Opening balance, cash in (sales), cash out (wages, suppliers, rent), closing balance. This is survival data. Cash flow kills more pubs than lack of profit. You might be profitable on paper but unable to pay your staff because money is stuck in stock or the landlord’s rent check cleared unexpectedly early. Weekly visibility of actual cash movement stops this dead.

4. Key Inventory Movement

Which stock lines didn’t move this week? Which are moving faster than expected? A single line of slow-moving stock bleeding margin for six weeks costs more than the entire cost of a proper reporting system. Weekly visibility catches this by week two.

That’s it. Four metrics. Everything else is noise.

Why Most Free Templates Don’t Work

I’ve downloaded dozens of free pub report templates over the years. They look professional. They have all the right columns. They promise to save time. And almost every one gets abandoned after two weeks.

Here’s why:

Manual Data Entry Is Punishment, Not Work

A spreadsheet template requires you to manually type numbers from five different sources: your till, your staff timesheets, your bank account, your supplier invoices, and your stock system. You’re not doing the work once. You’re doing it twice — once to run the business, once to report on it. Most pub owners quit after the second or third week.

Spreadsheets Don’t Catch Errors

You type in £2,450 instead of £2,540. The spreadsheet doesn’t know. It calculates and moves on. You’ve now got a corrupted report that you’re basing decisions on. Or worse, you didn’t notice the error and you’re investigating a fake problem for days.

There’s No Accountability for Updates

A spreadsheet sits on your laptop. Your manager might not fill it in. Your accountant might not see it. There’s no reminder, no alert, no system that says “this hasn’t been updated in three days.” Six weeks pass. You’re reviewing data that’s now completely stale and you don’t even know it.

They Don’t Connect To Your Real Systems

Your till is recording data live. Your bank is recording transactions live. Your staff scheduling system knows who was on shift and for how long. A spreadsheet template has none of this. You’re manually re-entering data that your systems already captured, which means it’s immediately out of date and wrong.

This is why I moved away from templates years ago. Not because templates are bad — they’re free and they’re better than nothing. But they’re friction. And friction kills consistency.

How to Build a Weekly Report That Actually Helps

If you’re going to use a template, here’s the only version that actually works: one that pulls data automatically from your till system and does the maths for you. You still need to add manual inputs (cash position, specific inventory checks), but 70% of the work is done by the system.

Here’s the structure:

Section 1: Revenue Summary

• Total till sales (automatic from POS)
• Beer sales (automatic from category codes)
• Spirits sales (automatic from category codes)
• Soft drinks / other (automatic)
• Food sales (automatic)
• Week-on-week percentage change for each category

Section 2: Labour Analysis

• Total hours scheduled (from staff rota system)
• Total hours worked (from clocking-in system or timesheets)
• Total wage cost (from payroll system)
• Labour as % of sales (calculated automatically)
• Variance vs target (calculated automatically)

Section 3: Cash Position

• Opening bank balance (Monday morning)
• Cash sales into bank (automatic from till)
• Payments out (wages, suppliers, rent if weekly)
• Closing bank balance (Sunday evening)

Section 4: Inventory Notes

• Stock lines with zero sales this week
• Stock lines with higher-than-normal movement
• Any deliveries missed or delayed
• Stock take variance (if doing weekly stock)

That’s your complete weekly report. Takes 5 minutes to review once the automatic data is populated. Takes 15 minutes to add the manual inputs. Done.

The key difference between a working template and a failing one is this: 90% of your report should come from automatic data feeds, not manual typing. If you’re spending an hour on it, the template is wrong.

Template vs Live Dashboard: Which Actually Works?

This is the honest conversation most people avoid.

A free template gives you a weekly snapshot. You download it on Sunday night, fill in the blanks, look at the numbers, feel either good or worried, and then do nothing until next Sunday. You’re always one week behind. You can’t drill into why something happened because the data is static. You can’t adjust staffing or pricing on Wednesday because you don’t know if Wednesday is a problem until Friday when you’re filling in your template.

A live dashboard — either built into your SmartPubTools system or through a proper pub management platform — shows you real-time data. You see Thursday’s sales at 10 p.m. Thursday night. You see labour percentage as it happens. You see cash position live. If something is wrong, you know about it within hours, not days.

The choice comes down to this: Do you want a historical record of what happened last week, or do you want a real-time operating system for your pub?

Most landlords choose the template because it’s free. And then they wonder why they’re still surprised by problems at month-end.

Here’s the real math: A spreadsheet template costs you nothing upfront but 15-20 hours of monthly data entry work (which is worth roughly £300-500 at even £20/hour). A proper pub reporting system costs £97 one-time and saves you that work forever.

At The Teal Farm, tracking staffing costs alone saved thousands in the first month once we could see labour percentage in real time instead of discovering staffing problems in the monthly reconciliation. We could see exactly which shifts were over-staffed and make adjustments immediately.

The question isn’t “free or paid?” It’s “do I have 20 hours to spend on data entry this month, or would I rather spend 30 minutes on a real dashboard?”

If you’re testing the concept and you genuinely have limited budget, download the free template and use it for one month. But set a date in your calendar for 30 days from now to evaluate whether you actually filled it in consistently. Most landlords will answer honestly: “No, I abandoned it after week two.”

When that happens, you’ll know it’s time for a proper system.

How to Implement Weekly Reporting in 5 Minutes

If you’re using a template, here’s the implementation that actually works:

Step 1: Connect Your Data Sources (15 minutes, one-time setup)

Get access to automatic exports from: your till system, your staff scheduling system, your payroll system, your bank account. Most modern systems offer CSV exports or API connections. If yours doesn’t, you need a new system.

Step 2: Build Your Template Structure (20 minutes, one-time)

Use the four-section structure above. Set up formulas for automatic calculations (labour %, week-on-week variance, cash flow). Test it with last week’s data to make sure the formulas work.

Step 3: Set a Fixed Review Time (1 minute)

Every Sunday at 7 p.m. You sit down with a coffee, you open the template, automatic data has already been pulled in, you add the three manual inputs (cash position, inventory notes, anything unusual), you spend 5 minutes reviewing. That’s it.

Step 4: Write One Action Point (2 minutes)

Based on what you saw in the report, write one thing you’re going to do this week to address a problem or capitalize on an opportunity. Not three things. One. This stops the report becoming a document you read and forget.

That’s your system. 5 minutes weekly review time, 2 minutes for action planning. Everything else is setup you do once.

Now, if you find yourself still not filling it in after three weeks, you know the answer. You need to move to pub manager reporting that’s built into your operations system, not bolted on top of it.

Frequently Asked Questions

For more information, visit RankFlow free trial.

For more information, visit RankFlow marketing tools.