How to Track Bar Profits Properly in 2026

Last updated: 6 April 2026

Most pub owners have no idea how much profit they’re actually making on individual bars, drinks, or even entire product categories. They run the numbers once a year for tax, then wonder why cash flow feels tight despite what the P&L says looks acceptable. That gap — between what you think you’re making and what you’re actually making — is where hundreds of pounds disappear every month without anyone noticing.

If you’re managing a bar without real-time profit visibility, you’re flying blind. You can’t optimise what you don’t measure. And spreadsheets don’t cut it — they’re either outdated the moment you close the till, or they require so much manual entry that most landlords give up after week two.

In this article, I’ll show you exactly how to implement bar profit tracking that actually works. Not theoretical frameworks. Not software that requires a PhD to set up. Real systems you can start using today that will show you exactly where your money is going, which drinks are actually profitable, and where you’re bleeding cash without knowing it.

What Bar Profit Tracking Actually Is

Bar profit tracking is the process of measuring exactly how much profit each drink category, or individual product, generates after accounting for all direct and indirect costs. Not revenue. Profit. After cost of goods sold (COGS), after labour, after waste.

The most effective way to track bar profits is to separate sales data from cost data, then measure the margin on each product category weekly, not annually. This allows you to spot problems in real time instead of discovering them months later when the damage is done.

Most pubs track one thing: total takings. They know how much money came through the till. But they don’t know whether that £2,000 revenue day came from profitable spirits sales or low-margin beer volume. They don’t know if their wine sales are actually making money or if they’re shifting volume at prices that barely cover the cost of the bottle plus a tiny markup.

At The Teal Farm, I started tracking bar profit by category about eight years ago. The first week I did it properly — actual pour costs, actual staff hours allocated to the bar, actual waste — I found nearly £400 a week in untracked loss from one product category alone. Overpoured measures, employee theft, simple waste. Multiplied across 52 weeks, that’s £20,000 a year going nowhere.

That’s what bar profit tracking reveals. Not just whether you’re profitable. Where the profit actually is, and where it’s leaking away.

Why Most Pub Owners Get This Wrong

The reason most pub owners don’t track bar profit properly is simple: it’s invisible without a system. Your till tells you total takings. Your supplier invoices tell you what you spent. But nothing connects those two things to show you actual profitability by drink type, by category, or by time of day.

You can see that you sold 150 pints of lager last Tuesday. You can see that lager cost you £8.50 per case. But without a connected system, you won’t know whether those 150 pints generated profit or loss. You won’t know if your barstaff are pouring 25ml or 35ml measures. You won’t know if waste is costing you more than your profit margin.

Most pubs end up in one of two situations:

• No tracking at all. Total guesswork. Owners assume they’re profitable because the till shows money, then panic at tax time when actual profit is half what they thought.
• Spreadsheet hell. Someone (usually a harried manager) spends 15–20 hours monthly updating spreadsheets with data they’ve manually entered from invoices, till reports, and waste sheets. The spreadsheet is always out of date. Numbers are entered wrong. Formulas break. After a few months, nobody trusts the data, so tracking stops.

Both approaches fail because they’re disconnected from reality. They don’t capture what’s actually happening in the bar in real time. By the time you spot a problem in a spreadsheet, you’ve already lost a month’s profit.

Real bar profit tracking requires a system that pulls data directly from your till, your inventory, and your labour records — and shows you what’s actually happening without manual data entry. Pub Command Centre does this automatically because it’s designed by someone (me) who ran the numbers at The Teal Farm for 15 years and knows exactly what information a pub owner needs and when they need it.

The Problem With Current Tracking Methods

Spreadsheets Fail Fast

Spreadsheets are the default tool most hospitality businesses reach for. They’re familiar. They feel like they’re free. And they fail spectacularly once you try to maintain them long-term.

Here’s what happens in reality: Week one, the manager sets up a spreadsheet. It’s beautiful. Rows for every product, columns for cost, sales, waste, margin. Formulas calculated. Looks professional. Week two, someone forgets to enter the Monday night waste sheet. Week three, the lager supplier changes price and nobody updates the COGS column. Week four, the spreadsheet is so full of manual errors that nobody trusts it anymore, so tracking stops entirely.

The labour cost alone kills spreadsheet tracking. If you’re trying to calculate true bar profitability, you need to know how many staff hours were spent on the bar, at what wage rate, during which service. That means exporting data from your payroll system, your till system, and your scheduling system — then manually matching them up in a spreadsheet. Most people give up before they start.

Till Data Alone Isn’t Enough

Your till tells you what was sold. It doesn’t tell you what should have been sold based on how many measures were poured. It doesn’t tell you what happened to the bottle that went missing. It doesn’t tell you whether your staff are ringing in drinks correctly or pocketing cash.

Without inventory data connected to your till data, you have no way to calculate actual pour cost versus theoretical pour cost. You can’t spot whether you’re selling 10 fewer measures per bottle than you should be (which suggests overpours or theft). You can’t see whether waste is tracking higher than industry standard.

Monthly Reporting Is Too Late

Most pub owners see their profit numbers once a month, usually when the accountant sends the management accounts. By then, 30 days of decisions have already been made on incomplete information. If the profit was poor, you’re four weeks too late to do anything about it.

Real bar profit tracking requires data to be visible within 24 hours of sale, not 30 days later. That’s the only way you can spot a problem and fix it before it costs you serious money.

How to Set Up Real Bar Profit Tracking

Step 1: Get Your COGS Data Clean

Before you can track profit, you need to know your cost of goods sold for every product you sell. This means:

• Recording the actual price you pay for every product (not the list price — the price you actually pay)
• Recording the size of every bottle, measure size, and serving unit
• Calculating the cost per measure for every drink
• Updating this data whenever a supplier price changes

At The Teal Farm, I learned this lesson the hard way. I thought I knew our spirit costs. Turns out, we’d been buying from two different suppliers for the same product at different prices, and nobody had updated the cost data when we switched. That meant our profit calculations were completely wrong for six months.

You can do this in a spreadsheet, but you need discipline. Set a rule: every time a new supplier invoice comes in, one person updates the cost data immediately. Don’t batch it. Don’t do it “next week.” Do it that day. Otherwise costs drift out of sync with reality.

Better: use a system that’s connected to your supplier data and till system, so costs update automatically. That removes the manual entry step entirely.

Step 2: Track Sales by Category (Not Just Total Revenue)

Your till already knows how many pints of lager you sold, and at what price. But you need to see that data grouped in a way that means something: spirits, beer, wine, soft drinks, food. Or even more granular: draught beer, bottled beer, premium spirits, well spirits.

The more granular your categories, the more insight you get. But don’t go overboard. Start with 6–10 main categories. That’s enough to spot where profit actually is without creating tracking chaos.

Export your till data weekly (or pull it directly from your till system if it integrates with your tracking tool). Group it by category. Calculate total revenue per category. That’s the foundation everything else builds on.

Step 3: Calculate Theoretical Versus Actual COGS

This is where the real money appears. Theoretical COGS is what you should have spent on ingredients based on sales. Actual COGS is what your inventory records show you actually spent.

The gap between those two numbers is profit loss from waste, overpours, or theft.

Here’s how to calculate it:

• Starting inventory + purchases – ending inventory = actual COGS used
• Number of measures sold × cost per measure = theoretical COGS
• Actual COGS – theoretical COGS = unaccounted loss

Do this for each product category weekly. If you sold 200 spirits measures this week, and spirit bottles cost £0.75 per measure, your theoretical COGS is £150. If your actual inventory tells you £180 worth of spirits were used, you’ve got £30 unaccounted for. That’s 20% loss — well above the 10% standard for waste and overpour.

That number is your action item. Investigate. Watch pours. Check till accuracy. Check for theft. That £30 gap represents real money you’re losing every single week.

Step 4: Include Labour Costs in Bar Profitability

This is where most pubs get it completely wrong. They calculate drink profitability without including the staff cost to serve that drink. That means they think their wine sales are profitable when actually, after you account for the barstaff hours spent opening bottles and explaining the wine list, the margin is razor-thin or nonexistent.

Real bar profit tracking means allocating labour cost to the bar. You need to know:

• How many hours your bar staff worked this week
• What you paid them (including employer costs)
• How much revenue was generated during those hours
• Therefore: labour cost as a percentage of bar revenue

At The Teal Farm, labour is about 28% of bar revenue on average. That means on a £1,000 bar revenue day, £280 went to pay staff. Once you include that in your profit calculation, drinks you thought were profitable suddenly show much tighter margins.

SmartPubTools automatically tracks labour hours and cost, so you see real bar profitability including the cost to serve, not just theoretical margin on ingredients.

Step 5: Set Up Weekly Review Cycles

Once you have the data, you need a rhythm for reviewing it. I recommend weekly. Every Monday morning, pull last week’s numbers and spend 20 minutes looking at:

• Which product categories had the highest margin
• Which had the lowest
• Any unaccounted loss (waste/theft/overpour)
• Labour cost as a percentage of revenue
• Any anomalies compared to last week

If something looks wrong, dig into it immediately. Don’t wait until month-end. That’s the difference between catching a small problem and it becoming a £2,000 disaster.

Key Metrics That Actually Matter

Not all metrics are created equal. Most pub owners track dozens of numbers and understand none of them. Here are the metrics that actually drive decision-making:

Gross Margin by Category

This is revenue minus cost of goods sold, expressed as a percentage. A spirit with a £3 selling price and £0.75 cost has a gross margin of 75%. That’s your ingredient profit. But remember: this doesn’t include labour.

Target: spirits 70–75%, wine 60–65%, beer 55–65%, soft drinks 80%+. If you’re below those ranges, either your costs are too high or your prices are too low.

Net Margin (Including Labour)

Gross margin minus labour cost allocated to that category. This is what you actually keep. It’s always lower than gross margin, and it’s more honest about real profitability.

Target: spirits 45–50%, wine 40–45%, beer 30–40%, soft drinks 60%+. If net margin on a category is below 25%, question whether you should be selling it at all.

Variance (Theoretical vs Actual COGS)

The gap between what you should have used and what you actually used. Expressed as a percentage of sales. Target: under 10%. Anything above that indicates waste, overpour, or theft that needs investigation.

Track this weekly by category. If spirits variance is consistently 15%, something is systematically wrong. If it spikes one week to 20% then drops back to 8%, something happened that week (staff change, till error, theft) that you need to investigate.

Labour Cost as % of Bar Revenue

Total labour cost divided by total bar revenue. At The Teal Farm, we target 28% during normal weeks. During quiet weeks it can run 35–40% because staff cost is fixed but revenue drops. During busy weeks we try to hit 22–25% by optimising scheduling.

If this metric creeps above 32% consistently, you’re either overstaffed, understaffed for the revenue you’re generating, or paying staff too much for the roles they’re doing. Something needs to change.

Top 20 Products by Profit

Not by revenue. By profit. You need to know which 20 products generate 80% of your bar profit. Focus promotions, training, and upselling on those. Don’t waste effort pushing drinks that barely contribute to the bottom line.

Common Tracking Mistakes (And How to Avoid Them)

Tracking Revenue Instead of Profit

Most pubs obsess over whether revenue hit target. Revenue is not profit. You can have a £3,000 revenue day and make less profit than a £2,000 day if the £3,000 day was heavy on low-margin products.

Stop tracking revenue. Start tracking profit. And specifically, profit margin percentage, not total profit pounds. A £1,000 day with 40% margin made more profit than a £1,500 day with 30% margin.

Ignoring Waste and Overpour

Most pub owners are shocked when they first calculate the variance between theoretical and actual COGS. They assume “it’s just waste.” But waste should be 5–8% maximum. Anything above that is money walking out the door.

Measure it. Set a target. Hold staff accountable. At The Teal Farm, we made it clear: our theoretical COGS should be 85–90% of actual COGS. Anything worse gets investigated. That single focus saved us nearly £3,000 last year.

Not Allocating Labour Cost

I see pubs calculating drink profit as if labour is free. It’s not. Your barstaff cost £40 a day to employ (including tax, NI, costs). If they’re working four shifts a week, that’s £160 weekly. Allocate that to the revenue they generate. It completely changes your view of profitability.

Trying to Track Everything

Some pub owners want to track 100 different metrics. They create spreadsheets with 50 columns and wonder why nobody uses them. Start with five metrics: margin by category, variance, labour %, top 20 products, and weekly profit. Once those are solid, add more if you need them.

The key to effective bar profit tracking is simplicity first, detail second. Get the basic system working and trusted. Then expand it. Don’t try to build the perfect system on day one — you’ll give up before you start.

Waiting Too Long to Review Data

Monthly reviews are too slow. Weekly is minimum. Daily is better. At The Teal Farm, I look at variance and labour cost daily. Margin by category I review weekly. That rhythm keeps problems small.

Not Acting on the Data

The worst mistake is tracking data and then ignoring it. If you see that wine margin is 48% while spirits margin is 52%, and you have limited shelf space, why are you stocking wine at the same level as spirits? If you see that 10% of your sales come from three products, and 20% of your staff time goes to serving slow-moving products, why aren’t you training staff to upsell the profitable ones?

Data is only useful if it changes your decisions. Set up tracking. Review it weekly. Act on what you find. That’s the cycle.

For more information, visit RankFlow free trial.

For more information, visit RankFlow marketing tools.