Hospitality Inventory: The Complete Guide for Operators

Inventory is one of those things no hospitality operator enjoys doing. It is late, the team is tired, and somebody has lost the sheets from last time. Yet by the end of the evening one thing is clear: without inventory you are flying blind. You do not know how much stock you really have, where shrinkage occurs, whether your costings are accurate, or what to report to the tax office.

This guide covers everything you need to know about inventory in hospitality – from the legal obligation through the step-by-step process to the mistakes almost every business makes. No textbook theory, just what works in practice.

1. Why Inventory in Hospitality Is Not Optional

Most operators think of the legal obligation first when they hear “inventory”. That is the wrong starting point. Even if you were not required to carry out inventory, you should still do it. The reasons:

Your cost of goods is the single biggest lever for your profit. In German hospitality the cost-of-goods share typically sits at 28 to 35 per cent of revenue. Every percentage point you cut here goes straight to profit. And you can only reduce cost of goods if you know it. For that you need inventory.

Shrinkage is not a fringe issue in hospitality. Waste, spoilage, incorrect portioning, and occasionally theft – it all adds up. Industry figures show that hospitality businesses without regular inventory lose on average 5 to 10 per cent of their stock value to uncontrolled shrinkage. For a business with €500,000 annual revenue and 30 per cent cost of goods, that is €7,500 to €15,000 per year simply vanishing – without anyone noticing.

On top of that: your accountant needs the inventory data for the balance sheet, your purchasing team needs it for better orders, and your kitchen team needs it for accurate recipe costings. Regular inventory is not a bureaucratic exercise – it is the foundation for every commercial decision in your business.

Recommended reading: How to calculate your cost of goods in practice and what constitutes a good ratio is covered in the article “Food Cost Formula: How to Calculate Your Cost of Goods”.

2. Legal Obligation: Who Must, Who May, Who Should

The legal position is more straightforward than many operators think. Three pieces of legislation govern the inventory obligation:

§ 240 HGB: The Basic Rule

Every merchant is required to prepare an inventory at the start of business and at the end of every financial year. This means: all assets and liabilities must be recorded by type, quantity and value. In hospitality that means you must know on the reporting date 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 inventory obligation if they do not exceed the following thresholds on two consecutive reporting dates: a maximum of €80,000 annual profit AND a maximum of €800,000 revenue. Note: both values must be below the threshold, and on two consecutive dates. If you exceed either value in one year, you are obliged to keep books and carry out inventory the following year.

Fiscal Code (Abgabenordnung): Retention

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

What happens if you do not carry out the inventory?

During a tax audit the inventory is the first thing checked. If it is missing or flawed, the tax office may estimate your profit – and that estimate, by experience, does not work in your favour. On top of that come potential fines and the loss of the burden of proof: you can no longer demonstrate that your figures are correct.

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

3. How Often? Annual, Monthly, Perpetual Inventory

Annual Inventory (Key-Date Inventory)

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 period of the year – between Christmas parties and New Year’s Eve. That is why most businesses shift the count to the first days of January, which is legally permissible as long as it remains close to the reporting date.

Problem: an annual inventory alone gives you no ongoing visibility. You only spot shrinkage at year-end, when it is too late to take corrective action.

Monthly Inventory

The most practical option for most businesses. 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 develops, and the inventory takes 60 to 90 minutes for a typical bar or restaurant.

Monthly inventory enables you to calculate the actual cost of goods per month. The formula is simple: opening stock + purchases – closing stock = consumption. Compare consumption with revenue and you see immediately whether your cost of goods is on track – or whether stock is disappearing somewhere.

Perpetual Inventory

With perpetual inventory, stock is recorded continuously throughout the year. Every addition (delivery) and every withdrawal (sale, shrinkage) is posted in real time. This requires a digital system that integrates goods-in and POS data. The tax office accepts perpetual inventory as long as orderly stock records are maintained and every item is physically counted at least once a year.

For most hospitality businesses, monthly inventory is the best compromise: frequent enough to catch shrinkage, but less involved than perpetual stock management.

4. Step by Step: How an Inventory Works

Whether you are counting for the first time or want to improve your system – this process works for any hospitality business.

Preparation (1–2 Days Before)

‍Set the date: After closing or on a quiet day. Carrying out inventory during service creates chaos and errors.

‍

Define areas: Decide which rooms will be counted: counter, bar store, kitchen dry, kitchen chilled, kitchen frozen, cellar, dining area. Each area is recorded separately.

‍

Assign teams: Pairs are standard. One person counts, the other records. One team per area. Appoint one person to check the results at the end.

‍

Prepare materials: Inventory lists (printed or digital), pens, scales, a torch for dark shelves, gloves for cold storage.

‍

Tidy up: The day before: organise shelves, group like products, sort out obviously spoiled goods. This saves enormous time when counting.

Counting

‍Work systematically: Start top-left on the shelf, work right, then down. Row by row, shelf by shelf. Never jump around.

‍

Count full units: Sealed bottles, cases, cans: simply count. For large packs (e.g. a 24-unit tray of cola), take the tray as a unit, not each individual can.

‍

Record partial quantities: For opened bottles, estimate the fill level in tenths: 0.1 (almost empty) to 0.9 (almost full). For food: weigh open packages.

‍

Document spoiled goods: Do not discard spoiled or damaged goods; count them, mark as “breakage/spoilage” and value separately. The tax office wants to see that you documented the write-off.

‍

Do not accept deliveries: On inventory day, no goods-in may be recorded. Deliveries arriving during the count stay untouched at the goods-in area and are only shelved after the count is complete.

Valuation

After counting comes valuation: every 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) at fill level 0.4 = €7.20. The end result is the total stock value – the sum of all individual valuations. This figure goes into the balance sheet and forms the basis for calculating cost of goods.

Documentation

The finished count sheets – whether on paper or digital – must be archived. Ten-year retention obligation. In addition, you produce a summary inventory report showing the total stock value, broken down by area (bar, kitchen, cellar). This report goes to your accountant for the bookkeeping.

Tip: If you need a template for counting, you can find free Excel and PDF templates in our article “Hospitality Inventory List”.

5. Beverages vs. Food: What Is Different?

The inventory process is fundamentally the same, but the details differ by product group.

Beverages

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

The Excel solution: estimate fill levels in tenths and enter as a decimal (3.4 = three full bottles and one at 40 per cent content). The software solution: an inventory app like BarBrain offers a visual slider for capturing fill levels more precisely and quickly.

Additionally for beverages: keg stocks (beer, cider) must be estimated or weighed. Record wine with vintage separately. Do not forget CO₂ cylinders and syrups – they often carry a surprisingly high stock value.

Food

With food, the variety of units is the challenge: kilograms, grams, litres, pieces, bunches, trays. Consistent recording is important so that 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 you can follow FIFO principles (First In, First Out). Stock close to expiry must be flagged separately – it can either be consumed or written off as spoilage next month.

Prepared dishes – soups, sauces, marinated meat, desserts – are the most thankless part of a food inventory. Here you need to estimate the value of the ingredients used. A 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 Inventory Mistakes

‍Counting during service. If goods are being sold or prepared during the inventory, the figures no longer add up. Always count after closing or on a day off.

‍

Forgetting areas. The reserve fridge in the cellar, the cleaning-supplies store, the drink crates in the yard – these locations are regularly overlooked. Create a complete location list once and use it as a checklist for every inventory.

‍

Guessing partial quantities. There is 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 time. Consistency beats perfection.

‍

Accepting deliveries during the inventory. If a delivery arrives mid-count and is shelved, the figures are no longer date-specific. All deliveries stay at goods-in until the count is complete.

‍

Simply discarding spoiled goods. Spoiled goods must still be recorded, valued and documented as spoilage. Otherwise there is no evidence of where the stock went – and the tax office does not interpret gaps charitably.

‍

Only carrying out inventory once a year. With an annual inventory you only spot shrinkage after twelve months. By then it is too late to investigate causes. Monthly inventory takes 60–90 minutes and uncovers problems early.

‍

Not analysing the results. Most operators dutifully count their stock – and then the list disappears into a folder. Inventory only delivers value through the target-vs-actual comparison: what should you have had according to purchase 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 inventory is not an end in itself. It answers three questions:

What is my stock value?

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

What is my actual cost of goods?

The formula: opening stock + purchases in the month – closing stock = goods consumed. Divide goods consumed by net revenue and you get the cost-of-goods ratio. Benchmarks for hospitality: 25–30 per cent for beverages, 28–35 per cent for food, depending on the concept. If your ratio is persistently above that, you have a costing or shrinkage problem.

Where is my shrinkage?

The real lever. Compare theoretical consumption (what should have been used according to till data and recipes) with actual consumption (what is actually gone per the inventory). The difference is your shrinkage. Typical causes: over-pouring on cocktails, inaccurate portioning in the kitchen, spoilage from poor storage, and in rarer cases theft.

Without inventory, shrinkage stays invisible. You only notice that less money is left at month-end than there should be – without knowing why.

8. Inventory for Different Business Types

Bar / Cocktail Bar

High proportion of spirits with varying fill levels. Sort the inventory list by shelf order, not alphabetically. Count back-bar and store separately. Allow 60–90 minutes for a typical bar with 100–150 products. More on bar inventory in our blog post: “Inventory in Bars and Cocktail Bars – Precise Stock-Taking Made Easy”

Restaurant

Greater product variety (food + beverages) but less of the opened-bottle issue. Separate kitchen and bar. Count chilled goods quickly – the door should not stay open longer than necessary. Allow 90–120 minutes for a restaurant with 200–300 items. We also have a dedicated blog post: “Restaurant Inventory – Digital, Reliable and Simple”

Hotel

Multiple outlets (restaurant, bar, room service, banquet kitchen, minibar). Each outlet is recorded separately, then consolidated. Minibar inventory can be coupled with housekeeping. Allow half a day for a hotel with 3–4 outlets. Blog post on hotel inventory: “Inventory in Hotel Bar and Hotel Restaurant – Efficient, Precise, Flexible”

Catering / Event Hospitality

Here, inventory comes into play before and after events. Count the stock you take to the event and record the return. This shows what was actually consumed – and whether the costing for the next event is on track.

9. Excel, App or Software? Which Tool Fits

There are three ways to document an inventory. Each has its place:

Pen and Paper

The oldest method. It works but is slow and error-prone. The count results then have to be manually transferred into Excel or an accounting programme – an extra step where mistakes happen. Acceptable for micro-businesses with fewer than 30 items; no longer fit for purpose beyond that.

Excel / Google Sheets

The most widely used approach. Free, flexible, automatable with formulas. Works well for businesses that carry out inventory infrequently and have fewer than 100 items. Hits its limits as soon as several people need to count simultaneously (version conflicts), the product master grows (manual maintenance) or a target-vs-actual comparison is required (not straightforward in Excel).

Free Excel and PDF templates for download: Hospitality Inventory List

Inventory App / Software

The most efficient route for businesses that inventory regularly. An app like BarBrain runs on a smartphone, several team members count in parallel on different devices, and the inventory report is ready immediately after the last scan – with no post-processing. The product catalogue with over 30,000 items largely eliminates the need to set up products manually. And the fill-level slider for opened bottles is a genuine time-saver in bars.

The decisive question is not “Which tool is best?” but “How often do I inventory, and how many items do I have?”. With monthly inventory and more than 50 items, software typically pays for itself within the first month – through time savings alone.

10. Frequently Asked Questions

Am I legally required to carry out inventory as a hospitality operator?

Yes, if you are obliged to prepare financial statements. Sole traders below €80,000 profit and €800,000 revenue (on two consecutive reporting dates) are exempt. Everyone else must carry out inventory at the end of the financial year. Regardless of the obligation, regular inventory is almost always worthwhile from a business perspective.

How long does an inventory take in hospitality?

That depends on the size of your business. A typical bar with 100–150 items: 60–90 minutes. A restaurant with 200–300 items: 90–120 minutes. A hotel with several outlets: half a day. With an inventory app the time is roughly halved.

What do I do with opened bottles?

Estimate the fill level in tenths and enter as a decimal. Example: 3.4 = three full bottles and one at 40 per cent content. The stock value is calculated proportionally: 0.4 × purchase price of the full bottle.

When is the best time for inventory?

After closing or on a day off. Ideally always on the same day each month so that results are comparable. Many operators count on the first Monday of the month.

What is the difference between inventory and stock register?

The inventory (Inventur) is the process – counting, measuring and weighing. The stock register (Inventar) is the result – the schedule in which all assets are listed by type, quantity and value.

Can I delegate the inventory?

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

Is an Excel template enough for inventory?

For getting started and for small businesses: yes. As soon as you carry out inventory regularly, have more than 50 items, or need several people counting simultaneously, an inventory app is worthwhile. The biggest advantage of an app over Excel: no duplicate data entry and instant reports.