I'll admit it: I used to trust my bartenders to eyeball bottle levels and estimate what we had left. That trust cost me thousands before I realized alcohol inventory needs the same precision as food costs. Here's how to actually track your beverage inventory and connect it to real cost control.
Why beverage inventory is so important
Alcohol often represents 20-30% of your total revenue, but it's also one of your biggest cost items. A bottle of whisky worth €80 that vanishes without you noticing hits your profit directly. And drinks are ridiculously easy to take home or pour with a heavy hand.
💡 Example:
Your bar generates €8,000 per week. Your beverage inventory:
- Beer: €1,200
- Wine: €2,400
- Spirits: €1,800
Total: €5,400 in stock
If just 5% disappears untracked, you're losing €270 weekly = €14,040 annually.
Calculating beverage cost
Beverage cost follows the same logic as food cost, just for drinks. The formula:
Beverage cost % = (Drink costs / Sales price excl. VAT) × 100
Remember: alcoholic drinks carry 21% VAT (not the 9% rate for food).
💡 Calculation example:
Beer priced at €3.00 incl. 21% VAT:
- Sales price excl. VAT: €3.00 / 1.21 = €2.48
- Beer cost per glass: €0.45
- Beverage cost: (€0.45 / €2.48) × 100 = 18.1%
⚠️ Note:
Always calculate with the price EXCLUDING VAT. For alcohol that's 21%, so divide by 1.21. Too many operators skip this step and think their beverage cost looks better than reality.
Daily bar inventory checks
A solid daily routine stops drinks from vanishing unnoticed. Check these points every single day:
- Tap count: How much beer got poured? Does it match what the register shows?
- Bottle count: Count open bottles of wine and spirits
- Register vs reality: Sales according to your system vs what actually got poured
- Spillage and tastings: How much got "lost" to tastings or accidents?
Weekly inventory count
Every week, you'll count your complete beverage inventory. Do this systematically by category:
- Beer: Number of crates × price per crate
- Wine: Number of bottles per type × purchase price
- Spirits: Full bottles + estimated value of open bottles
- Soft drinks: Number of bottles/cans × purchase price
💡 Practical example:
Open bottle of whisky worth €80 (750ml):
- Still 60% full = 450ml remaining
- Value: €80 × 0.60 = €48
- Note: "Jameson 0.6 bottle = €48"
Linking to beverage cost
Now you connect your inventory to actual sales. From tracking this across dozens of restaurants, I've seen this formula catch profit leaks that owners never knew existed:
Actual beverage cost = (Beginning inventory + Purchases - Ending inventory) / Beverage sales excl. VAT
💡 Example weekly calculation:
- Beginning inventory: €5,400
- Purchases this week: €1,200
- Ending inventory: €5,100
- Beverage sales excl. VAT: €2,400
Actual beverage cost: (€5,400 + €1,200 - €5,100) / €2,400 = 62.5%
This number screams trouble! Normal beverage cost runs around 20-25%.
Warning signs that something's wrong
Watch for these red flags in your beverage inventory:
- Beverage cost above 30%: Drinks are vanishing or portions are too generous
- Inventory declining faster than sales: Possible theft or excessive spillage
- Certain bottles disappearing quickly: Check if staff are "sampling" these regularly
- Register doesn't match counted pours: Not everything's getting recorded
⚠️ Note:
Keep an eye on your staff too. Free drinks for friends or "tasting" expensive whisky can drain hundreds monthly. Set clear rules about when staff drinks are acceptable.
Digital vs manual tracking
Many bars still rely on paper lists or Excel spreadsheets. The downsides:
- Calculation errors (especially with VAT)
- Hours spent adding and calculating numbers
- Difficult to spot trends across multiple weeks
- No automatic beverage cost calculation per drink
A food cost calculator like KitchenNmbrs automatically calculates your beverage cost per drink and connects your inventory to sales. You'll instantly see which drinks generate the most profit and where money's slipping away.
How do you set up beverage inventory? (step by step)
Create a list of all your drinks
Note every type of drink with purchase price and unit (per bottle, crate, etc.). Don't forget soft drinks, mixers and garnishes. This becomes your base database.
Count your current stock
Go systematically through your bar and cellar. Count full bottles, estimate open bottles (in 10% increments). Note everything in your list with current quantities.
Calculate your beverage cost per drink
For each drink: divide the purchase costs by the sales price excl. 21% VAT. This shows you which drinks are profitable and which are too expensive to sell.
Set up a weekly counting routine
Choose a fixed day (for example Monday morning) to count your inventory. Compare with the previous week and check if the decrease matches your sales.
Monitor your total beverage cost
Calculate weekly: (beginning + purchases - ending) / beverage sales excl. VAT. If this goes above 25-30%, investigate where your drinks are going.
✨ Pro tip
Track your top 3 cocktails and 2 wine pours every Tuesday for 8 weeks straight. If these five drinks maintain proper beverage cost, you've locked down 75% of your bar profit.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
How often should I count my beverage inventory?
Complete inventory weekly minimum. But check open bottles and tap levels daily. This prevents drinks from disappearing without a trace.
What's a normal beverage cost for a bar?
For beer and wine: 20-25%. For cocktails with premium spirits: 18-22%. Anything above 30% means drinks are vanishing or portions are too heavy.
How do I estimate open bottles accurately?
Work in 10% increments: full, 90%, 80%, down the line. If you're unsure, estimate conservatively. A 10% error on one bottle beats consistently overestimating everything.
Should I include VAT in beverage cost calculations?
Never. Always calculate excluding VAT. Alcohol carries 21% VAT, so divide your sales price by 1.21 first. Otherwise your beverage cost looks artificially low.
What if my beverage cost runs too high?
Check three areas: is everything hitting the register, are portions too generous, and are drinks walking out with staff. Tackle the biggest leak first.
Can I automate beverage inventory tracking?
Partially. Apps handle calculations, but you still need manual counting. However, automation saves massive time on beverage cost calculations per drink.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Calculate your cocktail costs down to the ml
Drink margins seem high, but spillage and free pours eat them up. KitchenNmbrs calculates the exact cost price of every cocktail and drink. Try it free.
Start free trial →