A Pub P&L Template That Actually Works for Licensed Premises

Last year, I spent three hours trying to fit Teal Farm’s financials into a generic restaurant P&L template I found online. I got about halfway through before I realised: it had 47 line items that didn’t apply to us, was missing everything about cask ales, had nowhere to track keg swaps, and grouped our entire spirit stock into one line. By the time I’d finished trying to force our numbers into this template, I’d wasted an afternoon and my P&L was no more useful than when I started.

That’s when it hit me: pubs don’t operate like restaurants, yet most P&L templates are designed for restaurants. They assume you’ve got prep kitchens, waste tracking, multiple service periods, standard COGS percentages. They don’t assume you’re managing a cellar with 12 different cask ales on rotation, plus draught lager, plus bottled beer, plus a spirits stock worth £3,000. They don’t account for the fact that your biggest revenue line might be gaming machines, or that your food operation might be a sideline.

I needed a P&L template that understood how pubs actually work. And when I couldn’t find one, I had to build one myself.

Why Generic Templates Fail Pub Operators

Most P&L templates you’ll find online — whether they’re in Excel, Xero, or whatever accounting software you’re using — are built around restaurant economics. They assume:

• Single revenue stream: Food and beverage sales bundled together, or separated only at the most basic level. They don’t account for the fact that a cask ale might have a 40% margin, lager a 60% margin, and spirits a 70% margin. These are different products with totally different economics, and lumping them together is useless.
• Standard COGS percentage: Most templates assume your cost of goods sold is somewhere between 25-35% of revenue. In pubs, it varies wildly by product. A pint of Guinness might have a 45% COGS; a Coca-Cola has a 20% COGS. Your food might be 35% COGS, your spirits 25%. If you don’t break these down separately, you can’t actually manage your margins.
• Linear staffing: They assume your wage bill is relatively stable month to month. But pubs are seasonal. Bank holidays vary. School holidays hit you differently. You’ve got shift patterns, casual staff, agency costs, and weekend premiums. A generic template doesn’t capture any of this nuance.
• Single location: Most templates are built for a single venue. But if you’re operating a pub chain (or thinking about expanding), you need a system that lets you compare P&Ls across multiple sites and roll them up into a group total.
• Ignorance of licensing costs: Rent, rates, utilities — sure. But premises licences, PubWatch fees, local authority charges, licensing consultants? Most templates don’t even have a line for these because they’re unique to licensed premises.

The result is that most pub operators end up with a P&L that’s technically correct according to accounting standards, but strategically useless. You can’t see where your profit actually comes from. You can’t compare your margins to last year. You can’t identify which product lines are actually profitable.

And if you can’t see it, you can’t manage it.

What a Proper Pub P&L Actually Looks Like

A good pub P&L template needs to show:

Revenue, broken down by product line:

• Cask ales (by product, if you want detail)
• Draught lager and other standard draught
• Bottled beer and cider
• Spirits and cocktails
• Soft drinks and mixers
• Food (or food separated into lunch/dinner/snacks if you want that level)
• Gaming machines
• Other revenue (room hire, events, etc.)

Cost of Goods Sold, broken down the same way: So you can see your COGS and GP% for each line. If you’re selling spirits at £5 a measure and your COGS is £1.50, that’s a 70% GP. If you’re selling draught lager at £4.20 and your COGS is £1.80, that’s a 57% GP. These aren’t just interesting numbers — they tell you which products are worth pushing and which might be the problem.

Gross Profit (both £ and %), by line: This is the figure that matters. After you’ve paid for the stock, what’s left to cover your overheads and deliver profit? If your food GP% is 55% but your spirits GP% is 72%, you know where to focus.

Operating expenses, structured for pubs: Wages (split by FOH, kitchen, management if you want), rent, rates, utilities, insurance, maintenance, licencing costs, PubWatch, marketing, professional fees. Not grouped into vague categories like “general expenses,” but broken down so you can actually see what’s costing you money.

EBITDA and net profit: So you know whether you’re actually making money, and how much is being consumed by debt servicing or tax.

How I Built My Pub P&L Template

I started by looking at my till system and asking: what revenue lines can I actually measure separately? The answer was: all of them. My till software tracks every category. So I made sure my P&L matched those categories.

Then I looked at my invoices and asked: which expenses are fixed (rent, rates, insurance) and which are variable (cleaning supplies, maintenance, professional fees)? I reorganised my expenses to show both, because understanding which costs flex with your revenue and which don’t is crucial for forecasting.

Then I added a “budget vs actual” column. Because a P&L is only useful if you can compare it to what you expected. If you budgeted for £8,000 in wages but actually spent £9,200, you need to know that and understand why.

Finally, I added a “same period last year” column. Because you need to see trends. Is your beer margin shrinking? Are your wages creeping up? You won’t know unless you can compare month to month, and year on year.

The template I built is simple but comprehensive. It’s not fancy. It doesn’t have charts or graphs (though you can add those yourself). But it shows me exactly what I need to know to run my pub profitably.

What Changed When I Started Using a Proper Template

Within the first month of using my new P&L template, I spotted something I’d completely missed before: my soft drinks margin was 42%, but my spirits margin was 70%. And I was pushing spirits because they’re more profitable per measure. But I was measuring profitability per measure, not per customer visit. A customer who has two pints of lager spends £8.40 and generates roughly £3.50 GP. A customer who has two gin and tonics spends £10 and generates £7.20 GP. On a per-customer basis, spirits customers are nearly twice as profitable.

This changed how we run the bar. We don’t ignore lager — lager is 40% of our revenue — but we’re now actively upselling spirits and cocktails to customers who are open to them. Because we can now see on the P&L that it moves the needle on our bottom line.

The second thing I spotted was that my wage bill, broken down properly, showed that my Friday and Saturday labour costs were 32% of revenue (including all shifts), while my Monday-Thursday labour costs were 18%. This seemed wildly out of proportion. When I dug into it, I found I was overstaffed on certain shifts and understaffed on others. I reshuffled the schedule, cut unnecessary shifts, and reduced my monthly wage bill by £1,200 without cutting service.

The third thing? I realised my rent was 8% of revenue. For a pub, that’s actually pretty good — a lot of operators are at 10%+. But combined with rates and utilities, my occupancy costs were 13.5% of revenue, which is getting tight. This informed my negotiation with my landlord when it came time to renew the lease.

None of these insights were possible with a generic template or with spotty financial tracking. The P&L forced me to look at the numbers properly, and the numbers told me where I was wasting money and where I could do better.

The Pub Operator Console P&L Dashboard

Once I’d built my template, I realised I was still doing a lot of manual data entry. I’d print out my till reports, add them up, enter them into the spreadsheet, then wait for month-end to close my books. If I needed to check something mid-month, I’d have to do it all again.

This is where the Pub Operator Console made a fundamental difference. The Console’s pub-specific P&L dashboard is built around the same logic as the template I’d created, but it’s automated. Instead of manually entering numbers, the Console pulls in your revenue and costs and builds your P&L in real time.

Here’s what this means in practice:

• Live revenue tracking: If you’re tracking your revenue by till category (which you should be), the Console pulls this in daily. You can see your YTD revenue by category without waiting for month-end. If beer sales are down this month, you know it immediately, not a month later when you’re analysing the financials.
• Automated cost allocation: Your rent doesn’t change month to month (usually), but the Console knows that. You set it once, and it automatically allocates properly. Same with rates, insurance, and other fixed costs. You only update them when they actually change.
• Real-time COGS tracking: If you’re using the Console to manage your stock (which integrates with your ordering), you can see your actual COGS and GP% in real time. You’re not guessing. You’re not estimating shrinkage. You’re measuring it.
• Budget vs actual comparison: You set your budget once (based on your business plan or last year’s results), and the Console constantly compares your actuals to that budget. You’ll see immediately if you’re tracking ahead of or behind your financial targets.
• Multi-site rollup: If you run multiple pubs, the Console lets you build a P&L for each location, then automatically rolls them up into a group P&L. You can see which of your pubs is pulling its weight and which one needs attention.
• Historical comparison: The Console stores every month’s P&L automatically. You want to compare this April to last April? Click a button. You want to see your five-year trend on spirits margin? It’s there.
• Export and reporting: When you need to give your accountant your numbers, or present to your bank, or show your partner the state of the business, the Console exports everything cleanly into a format your accountant will actually want to work with.

The Console’s P&L isn’t a generic template forced into a pub context. It’s a pub P&L dashboard built by someone who actually runs a pub and knows what we need to see.

How This Translates to Better Decision-Making

When you’ve got a proper P&L that updates in real time, you can actually run your pub like a business instead of hoping it’s profitable at the end of the year. Here’s what this looks like:

Cost control: You see your wage bill is tracking 2% ahead of budget. Instead of waiting until month-end and panicking, you adjust staffing this week. You’ve just saved yourself a few hundred quid and you’ve demonstrated cost control to your bank (which matters if you’ve got a loan).

Margin management: Your draught lager margin is trending down. You pull a report and see that your cost price has increased but you haven’t adjusted your sell price. You raise the price on lager by 20p, and your margin recovers. That’s not greed — that’s business. But you can’t do it if you can’t see it.

Mix management: Your profit is down month on month, but your revenue is up. Something’s wrong with your product mix. The P&L shows you that your spirits sales are down and your soft drinks sales are up. Soft drinks have half the margin. You adjust your strategy: train the staff to upsell, run a promotion on cocktails, feature spirits more prominently. Your margin recovers.

Growth planning: You want to expand to a second pub. Your bank wants to see a properly kept P&L and evidence that you can manage costs effectively. If you’ve got a year of solid P&Ls from the Console showing consistent management, consistent profitability, and clear understanding of your numbers, you get that loan. If you don’t, you don’t.

This isn’t theoretical. This is how pubs actually succeed or fail. The ones that do it right are the ones that watch their numbers closely and adjust quickly. The ones that guess or wait until their accountant tells them the bad news don’t survive.

Why Your Current System Probably Isn’t Good Enough

You might have a P&L in your accounting software. But I’d bet money that:

• You don’t look at it until your accountant sends it to you
• It’s not broken down by product (so you can’t see which products are profitable)
• It doesn’t have budget vs actual (so you don’t know if you’re on track)
• It doesn’t have the comparison columns (so you can’t spot trends)
• It groups your revenue in ways that don’t match how you actually sell (so it’s not useful for decision-making)
• It’s a month or more behind (so you’re making decisions based on old data)

If any of that sounds like you, your P&L isn’t working for you. It’s just a financial record. A proper P&L is a tool for running your business.

Getting Your P&L Working for You

The Pub Operator Console is £97. One payment. It includes a pub-specific P&L dashboard built to show you exactly what matters: revenue by product line, COGS by line, gross profit and margin by line, your full operating costs, and your bottom line. Updated whenever you update your revenue and cost data. Compared to budget and last year.

Is a proper P&L going to make you profitable if you’re not already? No. But it will show you where the problem is, and that’s the first step to fixing it. A lot of pub operators are losing money and don’t even know where. They think their food operation is dragging them down, but they haven’t actually measured it. They think their wage bill is the problem, but they haven’t broken it down properly. They just have a sense that something’s wrong.

With a proper P&L, you don’t have to guess. You know.

Get the Pub Operator Console — £97

30-day money-back guarantee. No subscription ever. Just a system that shows you what’s actually happening in your pub.

Once you understand your P&L, you can start optimising. One of the quickest wins most pub operators find is their pricing. If your draught margins are slipping or you’re not pricing to market, use the pub drink pricing calculator to work out what you should actually be charging. It’s free, and it often pays for the Console in a single menu adjustment.

Want more free tools to run your pub properly? SmartPubTools has everything you need to understand your numbers: check out all the pub management tools available.