Stocktaking in hospitality: process, obligations and practical tips

Stocktaking is one of those things no operator enjoys. It’s late, the team is tired, and someone has lost the sheets from last time. Still, by the end of the evening one thing is clear: without a stocktake you’re flying blind. You don’t know how much stock you really have, where shrinkage occurs, whether your costing is right, and what you have to report to the tax office.

This guide shows how stocktaking works in hospitality – from the legal obligation through preparation and counting to valuation and the mistakes almost every venue makes. Not textbook knowledge, but what works in practice.

1. Why stocktaking in hospitality is not optional

Most operators think of the legal obligation first when it comes to stocktaking. That’s the wrong starting point. Because even if you weren’t required to do a stocktake – you should do it anyway. The reasons:

Your cost of goods is the biggest lever for your profit. In German hospitality, the cost of goods typically accounts for 28 to 35 percent of turnover. Every percentage point you reduce here goes straight into profit. And you can only reduce the cost of goods if you know it. For that you need a stocktake.

Shrinkage is not a marginal phenomenon in hospitality. Trimming waste, spoilage, incorrect portioning, occasionally theft – it all adds up. Just one percent of shrinkage costs a venue with an annual turnover of €500,000 and a 30 percent cost of goods €1,500 a year – without anyone noticing.

On top of that: your accountant needs the stocktake data for the balance sheet, your purchasing needs it for better orders, and your kitchen team needs it for clean recipe costing. A regular stocktake isn’t a bureaucratic exercise – it’s the basis for every business decision in your venue.

Recommended reading: how to calculate your cost of goods and what a good ratio is can be found in the article “Calculating cost of goods: formula, benchmarks and worked examples”.

2. Legal obligation: who must, who may, who should

The legal situation is clearer than many operators think. In essence, three laws govern the stocktaking obligation:

§ 240 HGB: the basic rule

Under the German Commercial Code (HGB, § 240), every merchant is obliged to draw up an inventory at the start of their business and at the end of each financial year. This means: all assets and liabilities must be recorded by type, quantity and value. In hospitality this means: on the reference date you must know what is in the storeroom, in the kitchen and behind the bar.

§ 241a HGB: the exemption for small businesses

Sole traders are exempt from the stocktaking obligation if they do not exceed the following thresholds on two consecutive reference dates: a maximum of €80,000 annual profit AND a maximum of €800,000 in revenue. Note: both values must be below the thresholds, and on two consecutive reference dates. If you exceed one of the values in a year, you are subject to bookkeeping and stocktaking obligations in the following year.

German Fiscal Code (AO): retention

Inventory records must be kept for at least ten years. This applies to the count sheets, the valuation and the final stocktake report. Digital or on paper – both are permitted, as long as the records remain legible and unaltered.

What happens if you don’t do the stocktake?

In a tax audit by the tax office (Finanzamt), the stocktake is the first thing checked. If it is missing or flawed, the tax office may estimate your profit – and experience shows that this estimate doesn’t turn out in your favour. Added to this are possible fines and the loss of the burden of proof: you can no longer prove that your figures are correct.

Regardless of the obligation: most accountants recommend a monthly stocktake to operators, because it forms the basis for the ongoing management accounts (BWA) and makes problems visible early.

3. How often? Annual, monthly or perpetual stocktake

Annual stocktake (reference-date stocktake)

The classic form: you count all stock once a year on the balance sheet date (usually 31 December). In hospitality this falls right in the busiest time of the year – between Christmas parties and New Year’s Eve. That’s why most venues move the stocktake to the first days of January, which is legally permitted as long as it stays close to the reference date.

The problem: an annual stocktake alone doesn’t give you an ongoing overview. You only spot shrinkage at the end of the year, when it’s too late to take action.

Monthly stocktake

The most sensible option for most venues. You count once a month – ideally always on the same day, for example the first Monday after month-end. After 2–3 rounds a routine has set in, and the stocktake goes much faster.

The monthly stocktake lets you calculate the actual cost of goods per month. The formula is simple: opening stock + purchases – closing stock = consumption. If you compare consumption with turnover, you can see immediately whether your cost of goods is within range – or whether stock is disappearing somewhere.

Perpetual stocktake

With a perpetual stocktake, stock is recorded continuously throughout the year. Every addition (delivery) and every removal (sale, shrinkage) is booked in real time. This requires a digital system that brings together goods receipts and POS data. The tax office recognises the perpetual stocktake as long as there is proper stock accounting and every item is physically counted at least once a year.

For most hospitality venues, the monthly stocktake is the best compromise: regular enough to spot shrinkage, but not as time-consuming as perpetual stock tracking.

4. Step by step: how a stocktake works

Whether you’re counting for the first time or want to improve your system – this process works for every hospitality venue.

Preparation (1–2 days before)

• Set a date: After closing or on a quiet day. Doing the stocktake during service creates chaos and errors.
• Define areas: Decide which rooms will be counted: bar counter, bar storeroom, dry store, cold store, freezer, cellar, dining room. Each area is recorded separately.
• Divide into teams: Teams of two are standard. One person counts, the other records. One team per area. Appoint someone responsible who checks the results at the end.
• Provide materials: Stock lists (printed or digital), pens, scales, a torch for dark shelves, gloves for cold storage.
• Tidy up: The day before: tidy the shelves, group similar products together, sort out obviously spoiled goods. This saves an enormous amount of time when counting.

Counting

• Work systematically: Start at the top left of the shelf, work to the right and then down. Row by row, shelf by shelf. Never jump back and forth.
• Count full units: Unopened bottles, cartons, cans: simply count them. For bulk packs (e.g. a 24-can tray of cola), take the tray as the unit, not each individual can.
• Record opened stock: For opened bottles, estimate the fill level in tenths: 0.1 (almost empty) to 0.9 (almost full). For food: weigh opened packs.
• Document spoiled goods: Don’t just throw away spoiled or damaged goods – count them, mark them as “breakage/spoilage” and value them separately. The tax office wants to see that you have documented the write-off.
• Don’t accept deliveries: No goods receipts may be booked on stocktake day. Deliveries that arrive during the stocktake stay untouched at goods receipt and are only put away once the count is complete.

Valuation

After counting comes valuation: each item is multiplied by its net purchase price. Three bottles of Aperol at €8.50 net = €25.50 stock value. Opened bottles are valued proportionally: a bottle of gin (purchase price €18) with a fill level of 0.4 = €7.20. At the end you have the total stock value – the sum of all individual valuations. This figure goes into the balance sheet and is the basis for calculating the cost of goods.

Documentation

The completed count sheets – whether on paper or digital – must be archived. Ten-year retention obligation. In addition, you create a summary stocktake report with the total stock value, broken down by area (bar, kitchen, cellar). Your accountant receives this report for the bookkeeping.

Tip: if you need a template for counting, you’ll find free Excel and PDF templates in our article “Hospitality stock list”.

5. Drinks vs. food: what’s different?

The stocktake basically works the same way, but the details differ depending on the product group.

Drinks (beverages)

The biggest challenge at the bar: opened bottles. A restaurant mainly counts full packs. A bar has 30, 40, sometimes 80 open bottles where the fill level has to be estimated. This is exactly where the biggest inaccuracies arise – and exactly where shrinkage and over-pouring have the greatest impact.

The solution on paper or in Excel: estimate the fill level in tenths and enter it as a decimal (3.4 = three full bottles and one with 40 percent of its contents). What matters is less accuracy than consistency – if you always estimate using the same method, you get comparable monthly figures.

Also for drinks: keg stock (beer, cider) must be estimated or weighed. Record vintage wines separately. Don’t forget CO2 cylinders and syrups – they often have a surprisingly high stock value.

Food

With food, the variety of units is the problem: kilograms, grams, litres, pieces, bunches, trays. Consistent recording is important so that the figures remain comparable. Define the standard unit for each item and never change it.

Perishable goods need special attention. Record the best-before date so that you can follow FIFO principles (first in, first out). Goods that are about to expire must be marked separately – next month they can either be used up or written off as spoilage.

Prepared dishes – soups, sauces, marinated meat, desserts – are the most thankless part of the food stocktake. Here you have to estimate the value of the ingredients that went into them. Clean recipe costing helps: if you know that one litre of tomato sauce costs €2.80 in ingredients, you can value the three litres in the cold room at €8.40.

6. The 7 most common stocktaking mistakes

1. Counting during service. If goods are sold or used during the stocktake, the figures are no longer correct. Always count after closing or on a closed day.
2. Forgetting areas. The spare fridge in the cellar, the cleaning supplies store, the drinks crates in the yard – these places are regularly overlooked. Create a complete list of locations once and use it as a checklist for every stocktake.
3. Guessing opened quantities. There’s a difference between “estimating” and “guessing”. Estimating means: hold the bottle at eye level, state the fill level in tenths, stay consistent. Guessing means: “roughly half”, and different every stocktake. Consistency beats perfection.
4. Accepting deliveries during the stocktake. If a delivery arrives and is put away in the middle of counting, the figures no longer relate to the reference date. All deliveries stay at goods receipt until the stocktake is complete.
5. Simply throwing away spoiled goods. Spoiled goods must still be recorded, valued and documented as spoilage. Otherwise there’s no proof of where the stock went – and the tax office doesn’t interpret gaps kindly.
6. Only doing a stocktake once a year. With an annual stocktake you only spot shrinkage after twelve months. By then it’s too late to investigate the causes. A monthly stocktake uncovers problems early.
7. Not analysing the results. Most operators dutifully count their stock – and then the list disappears into a folder. The stocktake only delivers its value through the target-vs-actual comparison: what should you still have according to purchasing and sales data? What do you actually have? The difference is your shrinkage.

More on shrinkage: the article “Shrinkage and breakage in hospitality” shows how to analyse variances systematically.

7. What to do with the results

A completed stocktake is not an end in itself. It answers three questions:

What is my stock value?

The sum of all individual valuations gives the total stock value. This figure goes into the balance sheet and affects your profit: if closing stock is higher than opening stock, you have used less than you bought – your cost of goods falls, your profit rises (at least on paper). If closing stock is lower, you have used more – and your cost of goods rises.

What is my actual cost of goods?

The formula: opening stock + purchases in the month – closing stock = consumption. If you divide consumption by net turnover, you get the cost-of-goods ratio. Benchmarks for hospitality are: 25–30 percent for drinks, 28–35 percent for food, depending on the concept. If your ratio is consistently above this, you have a costing or shrinkage problem.

Where is my shrinkage?

The real lever. Compare theoretical consumption (what should have been used according to POS data and recipes) with actual consumption (what has actually gone according to the stocktake). The difference is your shrinkage. Typical causes: over-pouring cocktails, inaccurate portioning in the kitchen, spoilage due to poor storage, and, less often, theft.

Without a stocktake, shrinkage stays invisible. You only notice that there’s less money left at the end of the month than there should be – without knowing why.

8. Stocktaking for different types of venue

Bar / cocktail bar

A high share of spirits with varying fill levels. Sort the stock list in shelf order, not alphabetically. Count the back bar and storeroom separately. How long the stocktake takes depends mainly on the number of items, opened stock and team size. How this works in a cocktail bar with a premium portfolio is shown in the Ory Bar success story.

Restaurant

Greater variety of goods (food + beverages), but fewer issues with opened stock. Separate kitchen and bar. Count chilled goods quickly – the door shouldn’t stay open longer than necessary. A practical example from a restaurant is the Usagi success story.

Hotel

Several outlets (restaurant, bar, room service, banqueting kitchen, minibar). Each outlet is recorded separately and consolidated at the end. The minibar stocktake can be linked to housekeeping. How a resort with two bars goes about it is shown in the Schloss Elmau success story.

Catering / event hospitality

Here the stocktake comes into play before and after events. Count the stock you take to the event and record what comes back. That way you see what was actually used – and whether the costing is right for the next event.

9. What to count with: paper, Excel or app

For micro-businesses with fewer than 30 items, paper is enough. Up to around 50 items and with infrequent stocktakes, Excel works – you’ll find free templates in the hospitality stock list. As soon as you count regularly, have more than 50 items or several people are counting, both approaches hit the same limits: no parallel recording, no complete history, no reconciliation with POS data.

Which digital tools exist, what they cost and which suits which size of venue is compared in the article Stocktaking software for hospitality – eight apps and programs with features, prices and recommendations. It also explains how a pure stocktaking app differs from an inventory management system.

10. Frequently asked questions

Am I obliged to do a stocktake as an operator?

Yes, if you are required to prepare a balance sheet. Sole traders below €80,000 profit and €800,000 turnover (on two consecutive reference dates) are exempt. Everyone else must take stock at the end of the financial year. Regardless of the obligation, a regular stocktake almost always makes business sense.

How long does a stocktake in hospitality take?

That depends on the number of items, number of areas, opened stock and team size. Two examples from our success stories: at Usagi, the stocktake used to take 5–6 hours, with BarBrain 2–3 hours. At Schloss Elmau (two bars), it fell from 6–8 hours to 2–3 hours. With a stocktaking app you save up to 70 percent of the time.

What do I do with opened bottles?

Estimate the fill level in tenths and enter it as a decimal. Example: 3.4 = three full bottles and one with 40 percent of its contents. The stock value is calculated proportionally: 0.4 × purchase price of the full bottle.

When is the best time for a stocktake?

After closing or on a closed day. Ideally: always on the same day of the month, so that the results remain comparable. Many operators count on the first Monday of the month.

What is the difference between a stocktake and an inventory?

The stocktake (Inventur) is the process – counting, measuring and weighing. The inventory (Inventar) is the result – the list in which all assets are recorded by type, quantity and value.

Can I delegate the stocktake?

Yes, but avoid having people count who might have an interest in incorrect figures (e.g. the person responsible for purchasing). The stocktake should be checked by someone who reviews the results critically.

What does stocktaking software cost?

Specialised stocktaking apps cost around €30 to €400 per month, depending on the number of sites and range of features. The detailed comparison is in the article on stocktaking software for hospitality.