Inventur & Warenwirtschaft

Inventory valuation in hospitality: methods, lower of cost or market and example

Inventory valuation in hospitality: which price counts, how average cost, FIFO and lower of cost or market work – with a worked example.

Lukas Stojetz

Lukas Stojetz

Founder

11 min

Reading time

Inventory valuation in hospitality: methods, lower of cost or market and example

The stocktake is done and every bottle has been counted. But only once each quantity has a euro amount next to it does the count sheet become a figure you can work with. That is inventory valuation: it determines how high your cost of goods is, what goes into the balance sheet and whether you can compare one month with the next. If you value stock at gross prices, with outdated price lists or with a different method every month, you make the month look better or worse than it was without noticing.

In this guide you will learn which price counts in inventory valuation, which valuation methods exist and how they differ in a worked gin example. We also show what the lower of cost or market principle means for spoiled stock or goods that have become cheaper, how to value opened bottles and why a stock value per area pays off.

1. What is inventory valuation?

Inventory valuation means assigning a euro value to every item you have counted. The stocktake delivers the quantity, the valuation turns it into the stock value: quantity times purchase price, added up across all items and storage locations. The German Commercial Code explicitly requires both in the inventory. Under Section 240 HGB, assets must be listed precisely and their value stated.

In hospitality this is mainly about beverages, food and consumables at the bar, in the kitchen, in the cellar or in the cold store. How the count itself works is described in our stocktake guide for hospitality. This article covers the next step: the right value.

2. Why inventory valuation determines your cost of goods

Closing stock feeds directly into the cost of goods formula:

Cost of goods = opening stock + purchases − closing stock

A worked example from a cocktail bar: opening stock is 9,000 €, you buy 12,000 € worth of goods during the month, and closing stock, correctly valued at net purchase prices, is 8,500 €. That gives a cost of goods of 12,500 €. With net sales of 45,000 €, this corresponds to a cost of goods percentage of 27.8%.

Now suppose someone accidentally values the closing stock at gross prices including 19% VAT. Closing stock suddenly shows 10,115 €, overstated by 1,615 €. Cost of goods falls to 10,885 € on paper, and the percentage to 24.2%. The month looks excellent. The following month, however, you start with an inflated opening stock and cost of goods jumps up. These swings have nothing to do with the work behind the bar; they are created purely by the valuation. You can find more on the formula and benchmarks in our guide calculating cost of goods.

1,000+
venues in Germany, Austria and Switzerland work with BarBrain
30,000+
items in the product catalogue with pack size and fill volume
1,615 €
Example: this is how much a closing stock of 8,500 € is overstated when valued at gross prices
Example values: closing stock 8,500 € net, valued including 19% VAT = 10,115 €.

3. Which price counts: net acquisition cost

Every inventory valuation is based on acquisition cost. Under Section 255 HGB, this includes the purchase price and incidental acquisition costs such as freight. Price reductions such as discounts, bonuses and early payment discounts are deducted. Under Section 253 (1) HGB, acquisition cost is the starting value at which an asset is recognised.

Important in practice: if you are entitled to deduct input VAT, the deductible input tax is not part of acquisition cost. This is set out in Section 9b (1) EStG. For most hospitality businesses this means you value stock at net purchase prices. A bottle of gin that costs 18.90 € net goes into stock at 18.90 €, not at the gross amount on the invoice.

The second question is: which purchase price? If you buy the same item at different prices during the month, the shelf holds bottles with different acquisition costs that you can no longer tell apart. That is what valuation methods are for.

4. Valuation methods at a glance – with a worked example

Individual valuation: In principle, each asset is valued individually. This rule is one of the general valuation principles of Section 252 HGB summarised by steuerschroeder.de. With 30 bottles of the same gin bought at three different prices, however, true individual valuation is hardly practical. That is why the law allows simplifications.

Weighted average method: Under Section 240 (4) HGB, similar inventory items may be grouped and recognised at the weighted average value. You divide the total acquisition cost by the total quantity and value the remaining stock at this average price.

Cost flow methods (FIFO and LIFO): Here you assume a sequence of consumption. With FIFO (first in, first out), what arrived first was used first, so the remaining stock comes from the most recent deliveries. LIFO (last in, first out) is the reverse. Under commercial law, both methods are possible for similar inventory under Section 256 HGB. For tax purposes, according to steuerschroeder.de, an assumed FIFO is not permitted, while LIFO is allowed under the conditions of Section 6 (1) No. 2a EStG. How to apply the FIFO principle in day-to-day storage, regardless of valuation, is covered in our article on the FIFO principle in hospitality.

Fixed value: Under Section 240 (3) HGB, property, plant and equipment as well as raw materials and supplies may be recognised at a constant quantity and value if they are replaced regularly, are of minor importance and change only slightly. A physical count is generally required every three years. For beverage stock that fluctuates from week to week, these conditions usually do not apply.

The worked example: At the start of the month there are 6 bottles of London Dry gin (0.7 l) in stock, bought at 17.50 € net. During the month, 12 bottles at 18.00 € and another 12 bottles at 18.90 € arrive. In total you had 30 bottles with an acquisition cost of 547.80 €. At the end of the month you count 10 bottles.

  • Weighted average: 547.80 € ÷ 30 bottles = 18.26 € per bottle. 10 bottles × 18.26 € = 182.60 €.
  • FIFO: The 10 remaining bottles come from the last delivery. 10 × 18.90 € = 189.00 €.
  • LIFO: The remaining bottles come from the oldest stock. 6 × 17.50 € + 4 × 18.00 € = 177.00 €.

For a single item, the results are 12 € apart. In a bar with several hundred items and rising purchase prices, such differences add up. What matters most is therefore not which method you choose, but that you agree it with your tax adviser and then stick to it. If you switch from month to month, your figures are no longer comparable.

Method
How to calculate
Stock value (10 btl.)
Weighted average
547.80 € ÷ 30 btl. = 18.26 € per bottle
182.60 €
FIFO
10 btl. from the last delivery at 18.90 €
189.00 €
LIFO
6 btl. at 17.50 € + 4 btl. at 18.00 €
177.00 €
Lower of cost or market (vs. FIFO)
Market price on the reporting date 18.20 € instead of 18.90 €
182.00 €
Example values: 6 btl. at 17.50 €, 12 btl. at 18.00 €, 12 btl. at 18.90 € (net), closing stock 10 bottles of London Dry gin (0.7 l).

5. The lower of cost or market principle: when stock is worth less

Acquisition cost is the starting value, but not always the right value. For inventory that belongs to current assets, Germany applies the strict lower of cost or market principle under Section 253 (4) HGB: if the stock exchange or market price, or the attributable value, on the reporting date is below the carrying amount, you must recognise the lower value. Under commercial law it does not matter whether the impairment is permanent. If the reasons later cease to apply, a reversal of the write-down follows under Section 253 (5) HGB.

The tax rules are narrower: according to steuerschroeder.de, a lower going-concern value may only be applied under Section 6 EStG if the impairment is expected to be permanent. How to handle individual cases is best clarified with your tax adviser.

In everyday hospitality, the lower of cost or market principle comes up mainly in three situations:

  • Spoiled or expired stock: Food past its use-by date or wine that has turned has no sales value. It is written down or written off and documented as a loss.
  • Damaged stock: Bottles with damaged closures or goods that can only be used to a limited extent.
  • Lower purchase prices: In the example above, the supplier cuts the gin price to 18.20 € shortly before the reporting date. Under FIFO, the 10 bottles would be in stock at 189.00 €. The lower value is 10 × 18.20 € = 182.00 €, and this is the value to recognise under commercial law. The example is deliberately simplified.

Austria and Switzerland: In Austria, Section 207 UGB likewise requires current assets to be written down to the lower stock exchange or market price on the reporting date, or alternatively to the attributable value. In Switzerland, Art. 960c CO stipulates that if the realisable value of inventories, taking expected costs into account, is lower than acquisition or production cost on the balance sheet date, the lower value must be recognised. Inventories there explicitly include merchandise for resale.

6. Valuing opened bottles, kegs and open stock

At the bar, a large share of stock sits in opened bottles. If you left them out, your closing stock would be too low and your cost of goods too high. They are valued proportionally by fill level:

  • Opened bottle: Gin, purchase price 18.90 € net, fill level 0.4. Value: 18.90 € × 0.4 = 7.56 €.
  • Opened keg: 30-litre beer keg, purchase price 75.00 € net, 12 litres remaining. Value: 75.00 € ÷ 30 l × 12 l = 30.00 €.
  • Loose goods by weight: 2.4 kg of limes at 3.20 € per kg come to 7.68 €.

What matters is a consistent rule in the team: do you estimate in tenths or weigh? Are bottles below a certain fill level counted? The clearer the rule, the more comparable your stocktakes become.

7. Inventory valuation in four steps: per area and outlet

A single total for the whole business tells you what is in stock. It does not tell you where. That is why it pays to determine the stock value per area, for example main bar, cellar, kitchen, banqueting or breakfast buffet. This shows you where capital is tied up and which area is developing unusually. Together with cost of goods, you can also derive the inventory turnover ratio per area.

The process is the same in every area. First, count, including opened bottles. Then value each quantity at the net purchase price using the agreed method. In the third step, check whether stock is spoiled, damaged or has become cheaper, and write it down if necessary. Finally, close the stocktake and get the stock value per area in euros.

1
Count
Per area, including opened bottles
2
Value
Quantity × net purchase price
3
Check
Write down or write off spoiled stock
4
Close
Stock value per area in euros

If you run several outlets, for example in a hotel or a group, each outlet is a separate business with its own stocktake and its own areas. The stocktakes of the outlets are not merged. Instead, you review each outlet's results individually, such as stock value, cost of goods percentage and shrinkage.

8. Common mistakes in inventory valuation

  • Gross instead of net prices: As the example above shows, VAT inflates stock and distorts cost of goods.
  • Outdated purchase prices: Valuing with last year's price list systematically understates stock when prices rise.
  • Forgetting opened stock: Open bottles, opened kegs and supplies in the kitchen belong in the stock count.
  • Switching methods: Average one month, last purchase price the next: this makes months incomparable.
  • Spoiled stock at full value: Goods with no sales value stay in stock at acquisition cost and hide losses.
  • Missing documentation: Count sheets, valuation and the stocktake report are part of the inventory records. Without complete records you are on weak ground in a tax audit.

9. Inventory valuation with BarBrain

More than 1,000 venues in Germany, Austria and Switzerland already work with BarBrain. With BarBrain's digital stocktake, your team counts via app or in the browser, even in parallel across several areas. You enter opened bottles and open containers with a slider and loose goods in kilograms. Kegs have their own counting methods. Items are taken from the product catalogue with more than 30,000 items, including pack size and fill volume.

When you close the stocktake, BarBrain automatically creates the stocktake list, organised by area, with quantities and stock values in euros. You export the list as an Excel file for bookkeeping or your tax adviser. Subsequent changes to closed stocktakes are flagged, and roles let you decide who sees purchase prices and reports.

To keep purchase prices correct, the AI delivery note and invoice scanner helps: changed purchase prices are shown during the scan and applied to the items. So the next stocktake starts with current figures. For hotels and groups, each outlet has its own account with its own areas. As soon as an outlet has closed its stocktake, you see its results and stock values in the admin overview.

Task
Without BarBrain
With BarBrain
Opened bottles
Estimate and note on paper
Fill level via slider
Purchase prices
Copied from old lists
Changed prices applied during the scan
Stock value per area
Added up manually in spreadsheets
Automatically in the stocktake list
Handover to the tax adviser
Typing up count sheets
Excel export
Changes after closing
Hard to trace
Flagged

Want to see what your next stocktake looks like with automatic stock values? Book a demo

10. Frequently asked questions

What is inventory valuation?
In inventory valuation you assign a euro value to every counted item, usually quantity times net purchase price. The total is the stock value, which feeds into cost of goods and, for businesses that prepare a balance sheet, into the balance sheet. Without valuation, the stocktake remains a list of quantities.
Is stock valued gross or net?
If you are entitled to deduct input VAT, the deductible input tax is not part of acquisition cost under Section 9b (1) EStG. You then value stock at net purchase prices. Gross prices would inflate stock by the VAT and distort cost of goods.
Which valuation method makes sense for hospitality?
The weighted average method is often practical because similar inventory may be recognised at the weighted average value under Section 240 (4) HGB. For tax purposes, an assumed FIFO is not permitted and LIFO only under certain conditions. Agree the method with your tax adviser and keep it consistently.
How do I value opened bottles?
Opened bottles are valued proportionally by fill level. A bottle with a net purchase price of 18.90 € and a fill level of 0.4 is worth 7.56 €. Agree in the team in which steps the fill level is recorded so that stocktakes remain comparable.
What happens to spoiled or expired stock?
Goods with no sales value must not stay in stock at full acquisition cost. Under commercial law, the strict lower of cost or market principle of Section 253 (4) HGB applies to current assets, so you recognise the lower value or write the goods off. Document such losses so they do not show up as unexplained shrinkage in your analysis.
How does BarBrain help with inventory valuation?
With the digital stocktake, BarBrain automatically creates a stocktake list with quantities and stock values in euros, organised by area, when you close the count. You record opened bottles with a slider and export the list as an Excel file. Changed purchase prices from the delivery note scanner are applied to the items.
Lukas Stojetz

About the author

Lukas Stojetz

Founder

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%