Inventur & Warenwirtschaft

Calculating pouring loss: formula, examples and what the tax office wants to see

Calculating pouring loss: the formula, practical examples for beer, wine and spirits, and what the tax office (Finanzamt) wants to see in a tax audit.

Lukas Graf

Lukas Graf

Managing Director

11 min

Reading time

Calculating pouring loss: formula, examples and what the tax office wants to see

Imagine you buy €10,000 worth of drinks every month. Suppose 5% of that disappears – not through theft, not through breakage, but through pouring loss. That is €500 a month. €6,000 a year. Money that never reaches your till. Most operators know the problem. Very few know their actual number. And that is exactly where the risk lies – not just for your profit, but also for your next tax audit.

In this article you will learn how to calculate your pouring loss precisely, how to interpret the result and what the tax office (Finanzamt) wants to see in an audit. With concrete examples for draught beer, spirits and wine – so you can do the maths yourself.

What is pouring loss?

Pouring loss is the difference between the quantity of drinks actually used (opening stock + purchases – closing stock) and the quantity sold – minus documented losses such as breakage, spoilage or line cleaning. It is the share of your stock that "disappears" without you having sold it or demonstrably disposed of it. Pouring loss is not the same as shrinkage. Shrinkage is the umbrella term for all losses: breakage (broken bottles), spoilage (expired goods), theft and, yes, pouring loss. While breakage and spoilage are visible and can be documented, pouring loss often builds up gradually – when pulling beer, pouring, flushing lines or through missing POS entries.

You will find a detailed overview of all types of shrinkage in our guide to shrinkage and breakage in hospitality (barbrain.com/en/blog/schwund-und-bruch).

The 8 most common causes of pouring loss

1. Line loss (the “Nachtwächter”, or night watchman)

The beer that sits overnight in the lines between the cold room and the tap is poured away in the morning. The longer the lines, the higher the loss. On older systems with 10–15 metres of line, 1–2 litres are lost every night.

2. Cleaning loss

Every flush of the draught system costs beer. A thorough clean sends 3–5 litres through the line per flush. With daily flushing, that adds up to 90–150 litres a month.

3. Foaming over

Incorrectly set CO₂ pressure, kegs that are too warm or dirty couplers cause beer to foam over. The glass is skimmed and the rest goes down the drain. With poor settings this can account for 5–10% of the volume poured.

4. Over-pouring spirits

Without a jigger, it is easy to pour too much. A typical example: free pouring delivers 5 cl instead of 4 cl – that is 25% over-pour per drink. With 50 drinks a night, that is 50 cl of spirits given away.

5. Spilled cocktails

It happens especially at peak times: a cocktail gets knocked over, a shaker leaks, a glass is overfilled. At high volume, this adds up to 2–3 lost drinks per shift.

6. Forgotten POS entries

The drink is poured but not rung into the POS. That is not theft, it is a rush. But for your target-vs-actual comparison the effect is the same: the stock is gone, the revenue is not there.

7. Staff drinks without an entry

Team members drink during or after their shift – completely normal. But if these drinks are not recorded through the POS (e.g. as a void or discount entry), they show up as unexplained pouring loss.

8. Undocumented freebies

A schnapps on the house, a tasting glass for a regular, a round on the boss. All fine – as long as it is documented. Without a breakage slip or a note in the POS, every freebie becomes an unexplained loss.

Calculating pouring loss: the formula

The basic formula for pouring loss is simple:

Pouring loss (%) = ((actual consumption – quantity sold – documented loss) / actual consumption) × 100

Where:

  • Actual consumption = opening stock + goods received in the period – closing stock (in litres)
  • Quantity sold = total of all POS receipts × portion size (in litres)
  • Documented loss = breakage, spoilage, flushing losses, freebies (in litres)
  • The result is the unexplained loss as a percentage – your real pouring loss

Same result as a target-vs-actual comparison: pouring loss (litres) = target stock – actual stock. Target stock is opening stock + purchases – sales – documented losses. Actual stock is the result of your stocktake.

For a precise target-vs-actual comparison you need a clean stocktake – ideally monthly.

Step-by-step guide

  1. Set the period – month, week or accounting period
  2. Determine the quantity purchased – add up all delivery notes/invoices for the product
  3. Note the opening stock – stocktake result from the start of the period
  4. Pull the quantity sold from POS data – number of units sold × portion size
  5. Collect documented losses – breakage slips, flushing logs, freebies
  6. Record closing stock in a stocktake – estimate opened bottles (or measure them with a fill-level slider)
  7. Apply the formula – compare the result with previous months

3 worked examples

Example 1: draught beer (pub)

Item Value
Opening stock 1 keg = 50 litres
Purchased 10 kegs of 50 l = 500 litres
Closing stock (stocktake) 1 keg = 50 litres
Sold according to POS 920 × 0.5 l = 460 litres
Documented (flushing + overnight line loss + foam) 12 + 5 + 3 = 20 litres

Calculation: actual consumption 50 + 500 – 50 = 500 litres; 500 – 460 – 20 = 20 litres unexplained loss

Pouring loss: 20 / 500 × 100 = 4.0%

Interpretation: compare the figure with your previous months and keep documenting – that is how you spot whether something is changing.

Example 2: spirits (cocktail bar)

ItemValue
Purchased12 bottles of gin at 1 l = 12 litres
Opening stock3 opened bottles ≈ 1.5 litres
Total available12 + 1.5 = 13.5 litres
Sold according to POS260 × 4 cl = 10.4 litres
Closing stock (stocktake)1.8 litres
Documented: 1 bottle breakage1.0 litre

Calculation: actual consumption 13.5 – 1.8 = 11.7 litres; 11.7 – 10.4 – 1.0 = 0.3 litres unexplained loss

Pouring loss: 0.3 / 11.7 × 100 = 2.6%

Interpretation: only a small part of consumption is unexplained – precise measuring with a jigger pays off.

Example 3: wine (restaurant) – with an error

ItemValue
Purchased30 bottles of 0.75 l = 22.5 litres
Opening stockNot recorded (!)
Sold according to POS112 × 0.2 l = 22.4 litres
Closing stock2 opened bottles ≈ 0.8 litres
Documented (corked/tasting glasses)3 bottles = 2.25 litres

Calculation: actual consumption (0 [not recorded] + 22.5 – 0.8) = 21.7 litres; 21.7 – 22.4 – 2.25 = –2.95 litres

Problem: a negative value – on paper, more was sold than purchased. That is impossible. The cause: the opening stock from the previous month was not recorded. Without complete opening AND closing stock, the target-vs-actual comparison produces meaningless results.

Lesson: a target-vs-actual comparison only works if you record both opening and closing stock properly. A monthly stocktake (barbrain.com/en/blog/inventur-gastronomie-guide) is the basis for this.

How much pouring loss is normal?

There is no universally valid limit. How high your pouring loss is depends on factors such as drinks mix, line length, team size, type of service and quality of documentation. More meaningful than any benchmark, therefore, is the trend in your own venue: calculate pouring loss every month using the same method and watch whether it rises for individual products. A big lever for spirits is the jigger: it ensures every drink is poured with the costed quantity.

What the tax office wants to see – and what happens if you do not document

The tax office (Finanzamt) knows about pouring loss. But you should not assume there is a fixed rate that is always accepted without proof. In an audit, the auditor compares your figures with, among other things, the official benchmark tables (Richtsatzsammlung) published by the Federal Ministry of Finance (BMF). How much loss is plausible depends on your venue – which is why you should be able to prove losses individually:

  • Breakage slips with date, product and quantity
  • Flushing logs for the draught system
  • Documented freebies (invitations, tasting glasses)
  • Staff drinks recorded through the POS

Without proof, this is what happens: the tax office estimates your actual revenue upwards. The logic: if you bought goods but did not sell them and cannot prove a loss, you probably did not record the revenue. The result: back taxes plus interest.

If your cost of goods deviates significantly from the benchmark rates, a recalculation becomes more likely. The auditor then works backwards to see how much you should have sold.

More on tax audits and how to prepare: Tax audits in hospitality.

10 measures that reduce your pouring loss

  1. Use jiggers and pourers: the simplest and most effective lever. A jigger costs less than €10 and ensures every drink is poured with the costed quantity. No free pouring without a measure.
  2. Maintain the draught system regularly: check CO₂ pressure, temperature and lines. A badly set system wastes 3–5 litres per keg through foaming over.
  3. Document line flushes: record every flush with the date and estimated litres in a flushing log. That is your proof for the tax office.
  4. Ring it in before you pour: no drink without an entry. This has to be established as a clear rule in the team – not as a suggestion, but as the standard.
  5. Record staff drinks through the POS: either as a void with a note or as a discount to €0. That way they show up in the system and do not distort the target-vs-actual comparison.
  6. Document freebies on breakage slips: every invitation, every tasting glass, every round on the house. Without documentation it becomes an unexplained loss.
  7. Monthly stocktake for the target-vs-actual comparison: without regular stocktakes you cannot calculate pouring loss. Monthly is the minimum. More on this: barbrain.com/en/blog/inventur-gastronomie-guide
  8. Use a stocktake app with a fill-level slider: record opened bottles with a slider instead of estimating. This significantly increases accuracy – especially for spirits and wine.
  9. Standardise recipes: every cocktail gets an exact recipe with quantities in grams. No estimates, no "generous" portions. A recipe management tool helps here.
  10. Train your team and share shrinkage figures openly: show your team the monthly shrinkage figures. People who know the costs handle stock more carefully. Transparency works better than control.

Measuring pouring loss with stocktake software

You now know the formula. The challenge in practice is not the calculation but capturing the data. Three things make the difference:

  1. Precise stock recording – opened bottles are the biggest source of error in manual stocktakes. A fill-level slider (as in BarBrain) turns estimates into precise values.
  2. Target-vs-actual comparison with POS data – when your POS and stocktake tool are connected, the software compares target consumption from sales and recipes with actual consumption from the stocktake – per product.
  3. Historical comparability – month by month you see whether your measures are working. Without historical data you are optimising blind.

You will find a comparison of the most important stocktake tools here: Stocktake software for hospitality.

Pouring loss calculator

To check your pouring loss quickly, use our interactive calculator. It works directly in your browser – no download, no sign-up.

How the calculator works:

  1. Enter the total quantity available (opening stock + purchases, in litres) and your closing stock from the stocktake
  2. Enter the quantity sold according to the POS (in litres)
  3. Enter the documented loss (breakage, flushing, freebies)
  4. Result: unexplained loss (litres) + pouring loss (% of actual consumption)

The calculator is there to help. For longer-term analysis we recommend a stock list as an Excel template or, even better, a digital solution such as BarBrain.

Pouring loss calculator
Calculate unexplained loss in seconds.
Target-vs-actual comparison per product with the POS integration:
See the POS integration

Frequently asked questions about pouring loss

How much pouring loss is normal?

There is no universally valid limit – the figure depends on drinks mix, draught system, team and documentation. The most meaningful comparison is with your own previous months.

What does the tax office accept as pouring loss?

You should not assume there is a fixed rate that is always accepted without proof. Document losses with breakage slips, flushing logs or other records. Without proof, the tax office (Finanzamt) can add an estimated amount to your revenue.

How do I calculate pouring loss?

With the formula: (actual consumption – quantity sold – documented loss) / actual consumption × 100. You get actual consumption from your stocktake: opening stock + goods received – closing stock.

What is the “Nachtwächter” in beer?

“Nachtwächter” (night watchman) is the German term for the beer that sits overnight in the line between the cold room and the tap. It is poured away in the morning because it has gone flat. The longer the line, the higher the loss.

Does a jigger really reduce pouring loss?

A jigger ensures every drink is poured with the costed quantity. If a bartender free-pours 5 cl instead of 4 cl, that is 25% more spirit per drink – and exactly this over-pour disappears with a jigger. How much your pouring loss falls is shown by comparing your stocktakes before and after the switch.

What happens in a tax audit without pouring loss documentation?

The tax office calculates your theoretical revenue based on the goods purchased. If your recorded revenue is lower and you cannot explain the loss, an additional estimate follows. More on this: Tax audits in hospitality.

Can I calculate pouring loss in Excel?

In principle, yes. You need a spreadsheet with purchases, sales, documented loss and stocktake figures. Our stock list as an Excel template (barbrain.com/en/blog/inventurliste-gastronomie-bar-excel-liste) is a good starting point. For a target-vs-actual comparison based on your POS data, however, you need stocktake software with a POS integration.

How are pouring loss and cost of goods connected?

Pouring loss increases your cost of goods because you use stock without generating revenue. A rising cost of goods can be a sign of excessive pouring loss. We explain the connections in detail here: Food cost / calculating cost of goods (barbrain.com/en/blog/food-cost-formula-wareneinsatz-berechnen).

Reduce pouring loss – from your next stocktake

You now know the formula, the examples and the measures. The next step: measure. Without regular stocktakes, your shrinkage figures remain estimates. BarBrain makes your stocktake fast and precise – with a fill-level slider for opened bottles, a ready-made stock list with stock value and – with the POS integration – a target-vs-actual comparison.

Lukas Graf

About the author

Lukas Graf

Managing Director

Keep reading

All articles →

Free demo

Your next stocktake in half the time.

Book a free demo – 30 minutes, no obligation. We'll show you BarBrain using your own product range.

1,000+
Venues
80,000+
Stocktakes
up to70%
Time saved
✓ Stocktake complete
€9,672.55
Stock value · Main bar
Variance detected
−0.56 l gin
≙ 14 gin & tonics · ≈ €133 revenue
Delivery note
6× gin · cost price +2.7%