Last updated: 6 April 2026
Your pub’s spirit margins are leaking money every single day, and most landlords have no idea how much. After 15 years running The Teal Farm in Washington, I’ve seen too many good pubs fail because they treated spirit tracking like an afterthought. The difference between a 65% margin and a 45% margin on spirits isn’t just numbers on a spreadsheet – it’s the difference between taking home a decent wage and working 70-hour weeks just to break even.
Here’s what most pub owners get wrong: they track purchases but ignore waste, theft, over-pouring, and promotional discounts that silently destroy margins. When I implemented proper spirit margin tracking at The Teal Farm, we discovered £800 monthly in hidden losses within the first week. That’s nearly £10,000 annually that was walking out the door unnoticed.
This article will show you exactly how to track spirit margins properly, the common mistakes that cost thousands, and the SmartPubTools system that automates the entire process. You’ll learn the real numbers from a working pub, not theoretical advice from consultants who’ve never pulled a pint.
Key Takeaways
- Spirit margin tracking requires monitoring cost price, selling price, waste, theft, and promotional discounts in real-time.
- Manual spreadsheet tracking costs 15-20 hours monthly and still misses critical data points that destroy profitability.
- The average UK pub loses between £600-£1,200 monthly through untracked spirit wastage and over-pouring.
- Automated tracking systems pay for themselves within the first month by identifying hidden losses most owners never spot.
What Is Spirit Margin Tracking
Spirit margin tracking is the systematic monitoring of every factor that affects your alcohol profitability, from purchase price to the final pour. It’s not just about knowing what you paid for a bottle of whisky versus what you charge for a measure. Real margin tracking captures waste, theft, promotional discounts, staff drinks, spillage, and over-pouring.
At The Teal Farm, we track six critical components for every spirit:
- Purchase price per measure (including VAT and delivery costs)
- Selling price per measure across different serves
- Actual consumption versus theoretical consumption
- Waste and spillage tracking
- Staff consumption and promotional pours
- Variance between stock levels and till records
Most pub owners only track the first two points and wonder why their margins don’t match their calculations. According to HMRC alcohol duty guidance, spirit costs include multiple tax components that change regularly, making manual tracking even more complex.
The difference between gross margin and net margin on spirits can be 15-20% when you factor in all variables. That’s the difference between thinking you’re making 70% on premium whisky when you’re actually making 50%.
Why Manual Tracking Fails Every Time
I spent three years trying to track spirit margins using spreadsheets and weekly stock takes. The system failed because it relied on perfect data entry, consistent staff compliance, and assumptions that rarely matched reality.
Manual spreadsheets cost 15-20 hours of admin time monthly and still miss the data points that matter most. You can track every purchase and calculate theoretical margins perfectly, but if you’re not capturing real-time consumption, you’re managing with outdated information.
Here’s what manual tracking can’t capture effectively:
Staff Over-Pouring
A 25ml measure that consistently pours at 30ml reduces margins by 20% instantly. Multiply that across dozens of spirits and hundreds of serves daily, and you’re looking at serious money. Manual systems can’t track individual pour accuracy without constant supervision.
Promotional Impact
Happy hour discounts, 2-for-1 offers, and staff discretionary discounts destroy calculated margins. Most spreadsheets show the standard price margin, not the actual blended margin after promotions.
Theft and Shrinkage
Stock disappears. Whether it’s theft, staff drinks, or genuine wastage, manual stock takes only show the end result. They can’t identify when losses occurred or which products are most affected.
The RankFlow marketing tools helped me understand that most pub owners search for margin tracking solutions only after discovering significant losses. By then, thousands have already walked out the door.
The Real Costs of Hidden Losses
Let me share real numbers from The Teal Farm before and after implementing proper tracking. These aren’t theoretical examples – this is actual data from our EPOS system and stock records.
The average UK pub loses between £600-£1,200 monthly through untracked spirit wastage and over-pouring. At The Teal Farm, we discovered our actual losses were £847 monthly across our spirit range.
Where The Money Goes
Our biggest loss categories were:
- Over-pouring: £312 monthly (staff pouring 30ml instead of 25ml)
- Promotional discounts not factored into margins: £289 monthly
- Staff drinks and wastage: £156 monthly
- Theft/shrinkage: £90 monthly
The over-pouring was the killer. When busy staff pour generously, customers love it, but margins evaporate. A 5ml overpour on a £45 bottle of premium gin costs £1.50 per serve. Across 200 serves monthly, that’s £300 gone.
Research from the British Institute of Innkeeping shows that pubs with systematic stock control achieve 8-12% better margins than those relying on manual methods.
The Cumulative Effect
£847 monthly equals £10,164 annually. That’s not just lost profit – it’s lost profit that compounds. Every pound leaked through poor tracking is a pound that can’t be reinvested in stock, staff, or improvements.
More importantly, inaccurate margin data leads to poor pricing decisions. If you think your whisky margins are 70% when they’re actually 52%, you might avoid necessary price increases that would improve profitability.
How Pub Command Centre Tracks Everything
After years of spreadsheet frustration, I built Pub Command Centre to automate spirit margin tracking completely. It connects to your EPOS system and tracks every transaction, every stock movement, and every factor affecting margins in real-time.
Automated tracking systems pay for themselves within the first month by identifying hidden losses most owners never spot. At The Teal Farm, Pub Command Centre identified our £847 monthly losses within the first week of implementation.
Real-Time Margin Monitoring
The system calculates true margins by comparing theoretical consumption (what should have been used based on sales) against actual consumption (what was actually used from stock). The variance report shows exactly where losses occur.
Every morning, I get a dashboard showing:
- Actual margins by product for the previous day
- Variance between expected and actual stock usage
- Products showing consistent over-consumption
- Impact of promotions on blended margins
- Staff performance on portion control
Automated Stock Reconciliation
Instead of weekly stock takes, the system tracks consumption in real-time. When stock levels don’t match consumption patterns, you know immediately. No more discovering shrinkage weeks after it happened.
The RankFlow free trial showed me how many pub owners struggle with manual tracking before finding automated solutions. The time saving alone – from 20 hours monthly to 30 minutes – justifies the investment.
Promotional Impact Tracking
The system automatically adjusts margin calculations based on actual selling prices, including discounts. You see your true blended margin across all serves, not just the theoretical margin at full price.
This feature alone saved us from a pricing disaster. Our premium vodka showed 68% margins at full price, but after factoring in happy hour sales (40% of total volume), the true margin was 51%. Without that data, we would have underpriced other products.
Step-by-Step Implementation Guide
Setting up proper spirit margin tracking takes 30 minutes with the right system. Here’s exactly how to implement it at your pub:
Step 1: Baseline Data Collection
Start with a complete stock take of all spirits. Record:
- Product name and bottle size
- Current stock level (in measures, not bottles)
- Last purchase price including VAT
- Current selling price per measure
- Measure size (25ml, 35ml, etc.)
This gives you the foundation data. Most pubs skip this step and wonder why their tracking is inaccurate from day one.
Step 2: EPOS Integration
Connect your till system to automatically record every sale. Pub Command Centre integrates with major EPOS systems and captures transaction data in real-time. No manual entry, no missed sales, no staff compliance issues.
Step 3: Set Variance Thresholds
Configure alerts when actual consumption exceeds theoretical consumption by specific percentages. At The Teal Farm, we set alerts at 5% variance for premium spirits and 8% for well brands.
These thresholds highlight problems immediately. If your Gordon’s gin shows 12% over-consumption, you know there’s systematic over-pouring or shrinkage happening.
Step 4: Daily Monitoring Routine
Check your margin dashboard every morning. Look for:
- Products with high variance from expected consumption
- Declining margins on previously stable products
- Staff members consistently showing high variance
- Promotional impact on overall margins
This 5-minute daily check prevents small problems becoming major losses. Most pub owners find £1,000+ in hidden savings within the first week of consistent monitoring.
Step 5: Weekly Action Reviews
Every week, review variance reports and take corrective action. This might mean retraining staff on portion control, investigating potential theft, or adjusting prices based on true margin data.
The key is acting on the data immediately. Tracking without action is just expensive record-keeping.
Frequently Asked Questions
How often should I check spirit margins?
Daily monitoring prevents small issues becoming major losses. A 5-minute morning dashboard review identifies problems immediately, while weekly detailed analysis ensures corrective actions are taken before margins deteriorate significantly.
What’s a good spirit margin for UK pubs?
Premium spirits should achieve 65-75% gross margins, while well brands typically run 60-70%. However, true margins after waste, theft, and promotional discounts are usually 8-15% lower than theoretical calculations suggest.
Can automated tracking prevent theft completely?
Automated systems detect theft patterns through variance reporting but can’t prevent it entirely. They identify when stock disappears without corresponding sales, allowing immediate investigation rather than discovering losses weeks later during stock takes.
How much time does proper margin tracking save?
Manual spreadsheet tracking requires 15-20 hours monthly for accurate data. Automated systems reduce this to 30 minutes weekly for review and action, while providing more accurate and timely information.
Will staff resist automated tracking systems?
Initial resistance is common but decreases when staff understand the system protects them from false accusations. Clear variance data identifies systematic issues rather than blaming individuals for unexplained losses.
Tracking spirit margins manually wastes hours every week while missing the losses that matter most.
Stop managing scattered spreadsheets and emails. One system for sales, labor, costs, cash flow, and inventory. See everything. Control everything. From one place.