Hospitality Inventory List: Free Excel & PDF Template
Learn how to create an efficient inventory list in Excel for hospitality, to organise and track your stock.
Need an inventory list for your hospitality business? Here you go – free, instant and no email address required.
Whether you call it an inventory list, stock list or inventory template – it all means the same thing: a structured overview of all stock in your business. In this article we explain how the template is structured, how to fill it in correctly, and what specifics apply for bars, restaurants and hotels. Plus: the legal basics on the obligation to carry out inventory and when it pays to switch from Excel to dedicated inventory software.
1. Download Free Templates
We provide three templates you can download and use straight away:
Template 1 – Beverage Stock (Excel): For bars, cocktail bars and restaurants with a drinks menu. Columns for spirits, wines, beer and soft drinks. Includes pre-set SUM formulas for the total value. Download link.
Template 2 – Food / Kitchen (Excel): For restaurant kitchens and catering operations. Columns for food categories (meat, fish, dairy, vegetables, dry goods), best-before dates and storage location. Download link.
Template 3 – Print Version (PDF): For printing and filling in by hand. 4 landscape pages covering all beverage and food categories, with subtotal rows and an overall stock value. Simply print, fill in and file. Download link.
Template 4 – Print Version (Word): Same structure as the PDF but as an editable Word document. You can rename categories, add rows or adjust columns before printing – ideal if you want to tailor the template to your business. Download link.
2. How the Inventory List Is Structured
A good hospitality inventory list needs a clear structure so you can answer questions like “What is my total stock value?” or “How many bottles of Aperol are left?” at any time. The following table shows the key columns:
| Column | Example | Why It Matters |
|---|---|---|
| Product Name | Bacardi Carta Blanca Rum 0.7 l | Unique name including brand and container size. Without precise naming, mix-ups are inevitable. |
| Item Number | 4711 / EAN | Makes identification easier, especially for similar products (e.g. Aperol 0.7 l vs. 1.0 l). |
| Category | Spirits | Grouping by product type: spirits, wines, beer, soft drinks, food, non-food. |
| Storage Location | Bar / Kitchen / Cellar | Separation by physical location. Enables counting by area and tracing discrepancies. |
| Unit | Bottle / kg / Litre | Defines the unit of measurement for counting. For liquids: full bottles plus estimated fill levels of opened ones. |
| Stock (Quantity) | 12.5 | Quantity actually counted at the time of inventory. |
| Purchase Price (net) | €8.50 | Net purchase price per unit. Basis for calculating stock value and cost of goods. |
| Total Value | =Quantity×Price | Calculated via an Excel formula. Shows the stock value per item and totals to the overall stock value. |
| Best Before | 15/04/2026 | Relevant for food items. Helps with FIFO management and prevents spoilage. |
| Comment | Opened – approx. 40% full | For special cases: opened-item notes, quality remarks, supplier info. |
Our Excel template contains all these columns pre-filled, with working formulas for total value and subtotals.
Our Excel template contains all these columns pre-filled, with working formulas for total value and subtotals.
3. Step by Step: How to Fill In the Template Correctly
Here is a practical guide so you can get started straight away:
Step 1: Define areas. First decide which storage locations you have. Typical examples: bar (behind the counter + store), kitchen (dry + chilled + frozen), cellar/beverage store. In the Excel template you can create a separate worksheet for each area or enter the area in a column.
Step 2: Build your product master. Enter all products you regularly keep in stock. Use precise names: not “Aperol” but “Aperol Aperitivo 0.7 l”. This avoids mix-ups at the next inventory. You build the product master once – for subsequent inventories you only enter the quantities.
Step 3: Count. Work through area by area. In practice, working in pairs has proved effective: one person counts, the other records. Start at the top left of the shelf and work systematically to the right and down. For opened bottles: estimate the fill level in tenths (0.1 = almost empty, 0.5 = half full, 0.9 = almost full).
[SCREENSHOT: Example of a completed inventory list with 10–15 items, highlighted formulas, total value visible]
Step 4: Enter prices. Enter the net purchase price per unit. The formula =Quantity×Price calculates the total value automatically. At the bottom of the list you will see your total stock value – that is the figure your accountant needs.
Step 5: Save and archive. Save the finished inventory list with the date in the filename (e.g. “Inventory_2026-03-31.xlsx”). For your accountant, also export the file as CSV or PDF.
4. Inventory List for Bars – What Is Different
Bars face a particular challenge: the bulk of the stock consists of opened bottles. A bottle of gin at 30 % fill has a different value from a full one. This makes inventory in bars more complex than in a restaurant, where most ingredients are counted as full packages.
Our beverage-stock template therefore includes a column for the estimated fill level of opened bottles. You enter the number of full bottles plus the fill level of the open one (e.g. 3.4 for three full bottles and one at 40 % content).
Bar-specific tips: Sort spirits by shelf order – not alphabetically. This way you count faster because you simply follow the shelf from left to right. Record beer separately by keg and bottle. For wines, use a separate category with vintage.
Tip: If you stock more than 50 different spirits, estimating fill levels in Excel becomes error-prone over time. An inventory app like BarBrain offers a fill-level slider – more accurate and faster than manual estimation. You can find a blog post specifically for bars here.
5. Inventory List for Restaurants – Kitchen and Store
In a restaurant the focus is on food. Different rules apply here compared to the bar: perishable goods have a best-before date, units of measurement are more varied (kg, litres, pieces, bunches), and there are more storage locations (dry, chilled, frozen).
Our food template addresses this with pre-defined categories: meat & fish, dairy, vegetables & fruit, dry goods, spices, frozen items, consumables (napkins, candles, cleaning products).
Restaurant-specific tips: Record perishable items with their best-before date. This helps not only during inventory but also with FIFO management (First In, First Out). Do not count frozen goods with bare hands – gloves and a second team for cold rooms save time and nerves.
6. Inventory List for Hotels – Multiple Outlets
Hotels are the most complex case because stock is spread across several outlets: restaurant, bar, room service, banquet kitchen, minibar, possibly a café or a spa. Each outlet has its own stock that must be recorded separately – but ultimately flows into one consolidated report.
In Excel you solve this with separate worksheets per outlet and a summary sheet that adds the totals from all outlets using a SUM formula.
Hotel-specific tips: Schedule the inventory outside peak-occupancy periods. Minibar inventory is best coupled with room cleaning – the housekeeping team records minibar stock during the normal routine. For banquet kitchens: record event-specific stock separately so you know whether you need to reorder.
Tip: Hotels such as Schloss Elmau and the 25hours Hotels use BarBrain to run inventory across all outlets simultaneously and digitally. Learn more: Inventory in Hotel Bar and Hotel Restaurant – Efficient, Precise, Flexible
7. Legal Requirements: When Is Inventory Mandatory?
Not every hospitality business is required to carry out inventory – but most are. The German Commercial Code (HGB) sets out the obligations clearly:
General rule (§ 240 HGB): Every merchant must carry out an inventory at the start of business and at the end of every financial year. The result is recorded in the inventory register.
Exception (§ 241a HGB): 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. If you exceed either figure, you are obliged to keep books and carry out inventory.
What must be documented? Type of item, quantity, unit of measurement, storage location, individual valuation (purchase price) and total valuation. A properly maintained inventory list fulfils exactly these requirements.
Consequences of non-compliance: During tax audits, the absence of a proper inventory allows the tax office to estimate your profit – usually to your disadvantage. In addition, fines may be imposed.
Regardless of the legal obligation: a monthly inventory is almost always worthwhile from a business perspective because it makes shrinkage visible. Read more in our article “Hospitality Inventory: The Complete Guide for Operators”.
8. Seven Tips for a Faster Inventory
- Count outside peak hours. Schedule the inventory after closing or on a Monday morning. Counting during service leads to errors and stress.
- Work in pairs. One person counts, the other records. Faster and more accurate than working alone.
- Shelf order, not alphabetical. Sort your inventory list to match how products sit on the shelf. Then you count in a straight line from left to right instead of jumping back and forth.
- Standardise partial quantities. Agree on a method within the team: tenth-step estimation (0.1 to 0.9) for bottles, weighing for open food items. Consistency matters more than perfection.
- Use Excel formulas. SUM for totals, VLOOKUP for automatic price look-up, IF for threshold alerts (e.g. “Reorder” when stock falls below the minimum). Our template has the key formulas pre-set.
- Monthly, not annually. An annual inventory takes forever because nobody remembers how the system works. A monthly routine, once established, often takes just 1–2 hours per area.
- Analyse results immediately. An inventory list that disappears into a drawer after counting is useless. Compare actual stock with the target (from purchase and sales data). Discrepancies reveal shrinkage, theft or recording errors. More on this: “Spotting Shrinkage and Breakage”.
9. Excel vs. Inventory Software: When Does Switching Pay Off?
An Excel template is the perfect starting point. Free, flexible, no learning curve. But it has limits:
| Criterion | Excel | Inventory Software |
|---|---|---|
| Cost | Free | From approx. €30–80/month |
| Parallel Counting | Not possible (single file) | Multiple devices simultaneously |
| Product Catalogue | Set up manually | 30,000+ items pre-loaded |
| Automatic Reports | Manual via formulas | Instantly after counting |
| Target-vs-Actual | Not automated | Automatic via POS integration |
| Fill-Level Slider (Bottles) | Not possible | Available in BarBrain |
| Multi-Location | Separate files | Centralised in one app |
| Error Susceptibility | High (manual entry) | Low (guided process) |
As a rule of thumb: if you have fewer than 30 items and carry out inventory infrequently, Excel is sufficient. As soon as you inventory regularly, count more than 30 items, or need several team members counting in parallel, dedicated software saves more time than it costs.
Want to test the switch? Try BarBrain free for 30 days – no credit card, no risk. Book a demo now.
10. Frequently Asked Questions
What belongs on a hospitality inventory list?
All goods present in the business at the time of inventory: food, beverages, spirits, wine, beer, soft drinks, cleaning products, consumables (napkins, candles), kitchen utensils. Each item is recorded with quantity, unit, purchase price and storage location.
How often should you carry out inventory in hospitality?
By law, an annual inventory at the end of the financial year is required. From a business perspective, monthly inventory is advisable because it makes shrinkage visible early and improves cost-of-goods accuracy. Many BarBrain customers inventory monthly and need 60–90 minutes per location.
How do I value opened bottles?
Estimate the fill level in tenths: 0.1 (almost empty) to 0.9 (almost full). Multiply the purchase price of the full bottle by the fill level. Example: a bottle of gin (purchase price €18) at fill level 0.4 = €7.20 stock value. In BarBrain this is done via a visual slider.
Am I legally required to carry out inventory as a hospitality operator?
Yes, if you are obliged to prepare financial statements. The HGB prescribes an annual inventory for all merchants. Exception: sole traders below €80,000 profit and €800,000 revenue on two consecutive reporting dates. Details can be found above in the section “Legal Requirements”.
Is there a difference between an inventory list and a stock list?
No. The terms are used synonymously. Both refer to a structured record of all stock captured during an inventory. “Stock sheet” and “inventory template” mean the same thing.
Can I import my Excel data into software later?
In most cases, yes. BarBrain offers a CSV import and a product catalogue with over 30,000 items, so you do not need to set up many products manually. Switching from Excel to the app typically takes less than a day.
Book your demo now!
Want to improve your inventory? Then it’s time to book a free demo.
