Are Your Drink and Food Margins Where They Need to Be?

I walked into my cellar one Tuesday afternoon and found a cask ale sitting on the floor half-empty. Not fresh — sat there for three days after I’d pulled it. Cost me £48 to put on, and I’d maybe served 8 pints from it before it went off. That’s £48 lost, on top of the 40% margin I’d already lost on those 8 pints I’d actually sold. All told, that one cask cost me roughly £80 in lost profit.

The annoying part? I didn’t even know it had gone bad because I don’t actually track my per-product margins in real time. I know what I paid for the ale. I know what I sell it for. But I don’t actively monitor whether I’m hitting my target margin on each product line. Which means problems like waste, spillage, pilferage, or pricing that’s crept down over time go unnoticed.

Most pub operators are the same. We know our gross margins roughly — we think “beer is about 60%, spirits is about 70%, food is about 55%.” But do we actually measure it? Do we track it weekly? Do we notice immediately when a margin slips? Almost never.

And that’s where money goes in pubs. Not in the big things. In the 1% here, 2% there. A margin that slips from 62% to 59% on draught lager doesn’t sound like much until you realise that’s £40-50 a week in missing profit on a 100-pint-a-week draught line.

I needed a way to track gross profit margins in real time, by product category. And I needed to be able to see immediately when something slipped.

The Problem with “Rough” Gross Profit Tracking

Most pub operators manage margins the way I used to: roughly. You know spirits are more profitable than beer. You know food is less profitable than drink. You price things based on what feels right and what you think the market will bear. And then you hope it all works out at the end of the month when you do your P&L.

The problem with this approach is that you’re flying blind. You can’t see:

• Real-time product profitability: Is your draught lager actually selling at 62% margin, or has your supplier cost increased and you haven’t adjusted your sell price? You don’t know until you calculate it. And if you’re just guessing, you might not know for months.
• Price elasticity: You increased your spirit prices by 30p and now you’re selling fewer measures. Is the margin improvement worth the volume loss? You have no idea because you’re not tracking both numbers at the same time.
• Waste and shrinkage: If your actual COGS on a product is higher than it should be, it’s usually because of waste, spillage, pilferage, or over-pouring. But if you’re not tracking actual margin by product, you won’t spot the problem. You’ll just wonder why your beer margin is only 58% instead of 62%.
• Seasonal variation: Maybe your food margin drops in summer because you’re doing barbecue nights with thin margins. Maybe your draught lager margin improves in summer because you’re selling more volume. You won’t spot these patterns if you’re not tracking them actively.
• Mix issues: If your profit is down but your revenue is up, it means your product mix has changed. Customers are buying lower-margin products. But if you’re not tracking margin by line, you won’t see this until it’s a crisis.

Flying blind is fine until it isn’t. And for a lot of pubs, it isn’t.

What a Real Gross Profit Tracker Needs to Do

A proper gross profit calculator for pubs needs to show you:

Revenue per category: How much did you actually sell in beer, spirits, food, gaming, etc. this week? This should come directly from your till system, not from memory or estimates.

COGS per category: What did that stock actually cost you? This is where most systems fail, because it requires you to actually know your delivered costs and track them properly. Not just “beer costs 35%,” but “what did I actually pay for the specific beers I sold this week?”

Gross profit £ and % per category: For each category, what’s your actual margin? If you sold £1,200 in spirits and your COGS was £360, your GP is £840 and your GP% is 70%. Simple maths, but you need to do it properly for each category.

Trending: Is your beer margin trending up or down over the last four weeks? Is your food margin more volatile than your drink margin? These patterns matter, and you won’t see them without tracking over time.

Variance from target: You’ve decided your target beer margin is 62%. This week it’s 59%. You’re £15 below where you need to be. Is this a one-week blip or a trend? You need to know.

Visibility of problem areas: If your draught lager margin is significantly lower than your bottled beer margin, even though they’re the same supplier, something’s wrong. Maybe you’re over-pouring. Maybe your post-mix is gassing badly. Maybe it’s going off too quickly. A good gross profit tracker should flag these inconsistencies so you can investigate.

How I Built My Tracking System at Teal Farm

I started simple. I printed out my till report every Friday and looked at revenue by category. Then I looked at my invoices for the week and worked out what my COGS was for each category. Then I calculated the margin. Dead simple, but it took 45 minutes every week and I was still doing it manually.

The problem was that manual calculation means errors. And errors in your margin tracking means you’re making decisions based on wrong data. I’d miscalculate, or I’d miss a delivery invoice, or I’d forget to account for waste. And then I’d make a pricing decision based on dodgy numbers.

So I built a spreadsheet that automated the calculations. I put in my revenue by category from the till, I put in my COGS by category from my invoices, and the spreadsheet calculated the margins. I added a column for last week and last month so I could see trends. And I added a “variance from 10% target variance from target” column so I could see immediately if something was out of line.

Within the first month, this system flagged something I’d completely missed: my food margin was trending down. Not catastrophically, but week by week it was slipping. When I dug into it, I found that my food supplier had quietly increased their prices on vegetables by about 8% without telling me, and I hadn’t adjusted my menu prices to match. Once I knew, I could fix it. I raised the menu prices on food items by roughly 10%, and my food margin recovered immediately.

That single finding paid for a year’s worth of tracking labour. And I’ve used the system to catch dozens of smaller issues since.

The Pub Operator Console Gross Profit Tracker

Once I’d built my tracking spreadsheet, I realised I was still doing a lot of manual work. Every week, I had to pull my till report, pull my invoices, enter data into a spreadsheet, and run the calculations. If something went wrong, I’d have to go back and fix it.

This is where the Pub Operator Console made a huge difference. The Console’s gross profit tracker is built specifically for pubs and it automates the entire process.

Here’s what this means:

• Automated data collection: If your till system integrates with the Console, your revenue by category flows in automatically every day. You don’t have to manually pull a report and enter data. It’s just there.
• Cost tracking by product: You input your delivered costs for stock (either manually for each delivery, or via automatic import if your supplier supports it). The Console knows what you paid for each product.
• Real-time margin calculation: As soon as you’ve entered your stock costs, the Console calculates your actual GP% by category. You don’t wait until Friday. You can see your margins daily.
• Weekly and monthly rollup: You want to see your margins by week, by month, by product category? The Console shows you all of it. You want to compare this week to last week and to this week last year? Click a button.
• Variance alerting: You set your target margins (e.g., “beer should be 62%, spirits should be 70%, food should 55%”). The Console constantly compares actual to target and flags anything that’s off. If your beer margin drops to 59%, you see it immediately.
• Waste and shrinkage calculation: If your theoretical margin (based on delivery costs and standard pricing) doesn’t match your actual margin, that difference is waste, shrinkage, or over-pouring. The Console shows you this gap. If it’s growing, you’ve got a problem to investigate.
• Category trending: You can see your margins trending over 4 weeks, 13 weeks, or 52 weeks. If beer margin is trending down, you see it immediately. If it’s seasonal, you see the pattern.
• Benchmarking: The Console lets you compare your margins to industry standards for UK pubs. If your spirits margin is 70% and the industry average is 72%, you’re slightly below average. Is that a concern? Depends on your business model. But at least you know.

The effect of this is that you move from guessing about margins to measuring them continuously. And once you’re measuring something, you can manage it.

What Changes When You Track Gross Profit Properly

Once I started tracking margins actively with the Console, several things happened:

First, pricing discipline: I realised I hadn’t raised prices on spirits in 14 months, but my costs had increased 8%. My actual spirits margin was trending down as a result. The moment I could see this clearly, I adjusted prices. Spirits now sell at a slightly higher price, but the margin recovered. And I did it without any customer backlash because the increases were small and justified (increased cost of stock).

Second, operational discipline: When I started seeing waste/shrinkage data in the Console, I got serious about it. I watched my draught lager waste metric like a hawk. I trained staff on proper pour technique. I got the post-mix calibrated properly. I reduced spillage significantly. That single improvement increased my draught beer margin from 58% to 61% — about £60 a week in extra profit from better operational discipline.

Third, product mix management: I noticed that my profit was down last month even though revenue was up. Looking at the margin breakdown, I saw that my soft drinks sales had increased but my spirit sales had decreased. Soft drinks are lower margin. Once I knew this, I could adjust. We started training staff to upsell spirits more actively. We featured cocktails more prominently on our menu. Within three weeks, the product mix shifted back and profit recovered.

Fourth, supplier accountability: When my food COGS started creeping up unexpectedly, the Console let me pinpoint exactly when it happened (a Wednesday delivery in week two) and by how much (roughly 8%). This let me go back to my supplier with a specific complaint about specific items. Instead of saying “your prices have gone up,” I could say “your vegetable costs went up 8% on 23rd March.” This is a much harder conversation for them to wiggle out of, and we negotiated a small credit to offset the increase.

Fifth, strategic decisions: I’ve got real data now on which products are actually worth pushing. Spirits are 70% margin. Cask ales are 55% margin. But cask ales generate more return customers and are better for the pub’s reputation. So I don’t just look at raw margin — I look at customer lifetime value. But I can only make that balanced decision because I understand the actual margins.

The Objections (And Why They’re Wrong)

Does this really make a difference? Yes. A 1% improvement in gross profit margin across your product lines is roughly £50-100 a week in extra profit for a typical pub. That’s £2,500-5,000 a year from a single percentage point. Most operators can find multiple percentage points of improvement once they start tracking properly.

Is this just more admin for me to do? No. The Console automates the tracking. You input your costs once (usually from delivery invoices), and the system automatically calculates margins going forward. It’s less admin than doing it manually.

What if my till system doesn’t integrate? You can still use the system. You just enter your revenue manually from your till report once a week. It’s not fully automated, but it’s still far better than guessing. And it’s 10 minutes of data entry that saves you from missing margin problems.

Will this tell me if my staff are stealing? Not directly. But if your waste/shrinkage metric suddenly spikes, that’s a red flag worth investigating. Most waste is honest mistakes (over-pouring, spillage, giving free drinks), but the metric will help you spot if something more serious is happening.

Is the Console expensive? £97. One payment, no subscription. Compared to what you can save in a single margin improvement, it pays for itself in a day.

Getting Your Margins Under Control

Most pub operators leave money on the table because they’re not tracking their margins properly. They price based on intuition instead of data. They don’t notice when a supplier increases their costs. They don’t catch waste and shrinkage. They don’t see seasonal patterns. And so profits stay lower than they should be.

The Pub Operator Console’s gross profit tracker gives you visibility into all of this. Real-time. By category. With trending and variance alerts. Once you can see your margins clearly, you can start managing them properly.

Get the Pub Operator Console — £97

30-day money-back guarantee. No subscription. No hidden fees. Just real gross profit tracking that actually works for pubs.

Want to know what your margins should actually be? Use the pub drink pricing calculator to work out your target prices and margins for your location and market. Enter it into the Console, and the system will track you against those targets.

Need more free tools to run your pub? SmartPubTools has everything you need: explore all the pub management tools and find out what else you can optimise.