BETA APP IN DEVELOPMENT HACCP and more are available in your dashboard — currently in beta, so minor bugs may occur. The updated app with full integration is coming soon.
📝 Wine list & beverage packages · ⏱️ 2 min read

How do I calculate the cost of a wine bottle that doesn't sell and spoils?

📝 KitchenNmbrs · updated 13 Mar 2026

Many restaurant owners think spoiled wine only costs them the wholesale price they paid. That's completely wrong. Every bottle you toss hits your bottom line for the full selling price, including all that lost profit.

What does a spoiled wine bottle really cost?

A discarded wine bottle costs you way more than just what you paid for it. You're also kissing goodbye to the profit margin you'd have pocketed. This is what accountants call opportunity cost.

💡 Example:

A bottle of wine you throw away:

  • Purchase price: €12.00
  • Selling price: €32.00 (incl. 21% VAT)
  • Selling price excl. VAT: €26.45
  • Missed profit: €26.45 - €12.00 = €14.45

Total cost of waste: €26.45

The formula for wine waste

For accurate calculations, use this formula:

Waste costs = Selling price excl. VAT

Not the purchase price. The selling price. That's your actual loss right there.

⚠️ Note:

Wine carries 21% VAT, not 9%. Always calculate excl. VAT: selling price / 1.21

Impact on annual basis

Wine waste might seem minor, but it compounds fast. Here's how the numbers stack up:

💡 Example annual calculation:

Restaurant with wine waste:

  • 2 bottles per week spoil
  • Average selling price: €28.00 excl. VAT
  • Per week: 2 × €28.00 = €56.00
  • Per year: €56.00 × 52 = €2,912

Annual waste costs: €2,912

Different types of wine waste

There are three main causes of wine waste. Each requires its own calculation approach:

  • Spoilage from improper storage: Cost = full selling price excl. VAT
  • Open bottle kept too long: Cost = selling price per glass × number of glasses remaining
  • Breakage/leakage: Cost = selling price excl. VAT + any cleanup expenses

A pattern we see repeatedly in restaurant financials shows that storage-related spoilage accounts for nearly 60% of all wine waste costs.

Calculate wine waste per glass

With wine by the glass, you need a different approach. Calculate based on how many glasses you pour from each bottle.

💡 Example per glass:

Open bottle that spoils:

  • Bottle size: 750ml
  • Per glass: 150ml (5 glasses per bottle)
  • Selling price per glass: €7.50 excl. VAT
  • 3 glasses remaining that spoil
  • Waste costs: 3 × €7.50 = €22.50

Registration for tracking

To monitor wine waste effectively, document:

  • Date of waste
  • Number of bottles/glasses
  • Reason (spoilage, breakage, etc.)
  • Selling value of waste

Digital systems can track this automatically and calculate your costs in real-time.

How do you calculate wine waste costs? (step by step)

1

Determine the selling price excl. VAT

Take the menu price and divide by 1.21 (wine has 21% VAT). At €32.00 incl. VAT this becomes €26.45 excl. VAT. This is your actual loss per bottle.

2

Count all wasted bottles/glasses

Register every day how much wine you throw away. With wine by the glass: count the number of glasses remaining from open bottles. Track this for a month to get a good average.

3

Calculate total waste costs

Multiply number of wasted units × selling price excl. VAT. For annual figures: monthly average × 12. This gives you the real impact on your profit.

✨ Pro tip

Track wine waste daily for 30 days to establish your baseline loss percentage. Most restaurants discover they're losing 40% more than they estimated, making this simple tracking exercise worth thousands annually.

Calculate this yourself?

In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.

Try KitchenNmbrs free →

Was this article helpful?

Share this article

WhatsApp LinkedIn

Frequently asked questions

Should I use the purchase price or selling price for waste costs?

Always use the selling price excl. VAT. You're losing both the purchase costs and the profit margin you'd have earned. This reflects your true financial impact.

How much wine waste is normal in a restaurant?

Typical wine waste runs 2-5% of your wine revenue. Anything above 5% usually signals issues with storage, inventory rotation, or glass portioning systems.

How do I prevent open bottles from spoiling?

Use wine vacuum pumps for reds and refrigerate whites immediately. Mark opening dates clearly and use within 3-5 days maximum. Consider smaller bottle formats if turnover is slow.

Should I include VAT in the waste calculation?

No, calculate everything excl. VAT. You don't owe VAT on unsold inventory, so your actual loss is the pre-tax selling price.

Can I deduct wasted wine from my taxes?

Business losses are typically deductible, but consult your accountant for specifics. Proper documentation with dates and reasons is absolutely essential though.

What's the difference between spoilage cost and opportunity cost?

Spoilage cost is just your purchase price. Opportunity cost includes the profit you'd have made selling that bottle. Always calculate opportunity cost for accurate loss assessment.

ℹ️ This article was prepared based on official sources and professional expertise. While we strive for current and accurate information, the content may differ from the most recent regulations. Always consult the official authorities for binding standards.

📚 Sources consulted

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.

JS

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.

🏆 8 years kitchen manager at 1NUL8 Group Rotterdam
Expertise: food cost management HACCP kitchen management restaurant operations food safety compliance

Optimize your wine list and beverage packages

From wine by the glass to cocktail packages — KitchenNmbrs calculates the cost price and margin of every drink on your menu. Try it free for 14 days.

Start free trial →
Disclaimer & terms of use

Table of Contents

💬 in 𝕏
Stel je vraag!