Liquor Inventory Management System in Excel 🍾 | Stock Control & Mixed Drink Consumption & Excel tips

Managing liquor inventory manually often results in stock mismatch, wastage, pilferage, and profit loss. In this video, you will learn how to build and use a complete Liquor Inventory Management System in Excel that helps you control stock accurately without any expensive software.

Link for Download-
https://docs.google.com/spreadsheets/...
Excel formula
if(countif

🔍 What you will learn in this video:

How to maintain opening stock, purchases, sales, and closing stock

Bottle-wise and ML-wise stock calculation

Peg-wise liquor consumption system

Mixed drink & cocktail consumption tracking (auto stock deduction)

Daily and monthly stock reconciliation

Shortage, excess & wastage analysis

Low stock alert system using Excel formulas

Smart Excel tips to improve accuracy and control losses

🍸 Mixed Drink Example Explained:

If 1 cocktail uses:

60ml Vodka

30ml Rum

Excel will automatically deduct the exact quantity from the respective liquor stock when the cocktail is sold.

🧮 Excel Formula Concepts Covered:

Bottle to ML conversion

SUMIFS for consumption tracking

IF formula for alerts

Stock variance calculation

Auto closing stock formulas

👥 This video is useful for:

✔ Bar & Pub Owners
✔ Restaurants & Hotels
✔ Liquor Shop Managers
✔ Accountants & Auditors
✔ Inventory & Store Managers

This Excel-based liquor inventory system is simple, practical, and customizable for any size of business. Watch till the end to understand how Excel can help you reduce liquor loss, improve control, and increase profitability.

📌 Like, Share & Subscribe for more Excel, accounting, and inventory management tutorials.

🔖 Hashtags

#LiquorInventory
#BarManagement
#ExcelInventory
#StockControl
#LiquorStock
#CocktailConsumption
#ExcelFormulas
#RestaurantManagement
Welcome to Balaji Education Hub – your complete learning destination for Accounts, Commerce, and Taxation. This channel helps students, beginners, and working professionals build strong knowledge in business accounting, GST, Income Tax, TDS, PF/ESI, and other compliance work.

We cover practical training in Tally, SAP, Busy, Cloud Accounting Software, Advanced Excel, Corporate Accounts, and more.
You will also learn essential career skills like Team Management, Analytical Thinking, Problem Solving, Organizational Skills, Cash Flow & Fund Management, and preparation of Profit & Loss Accounts & Balance Sheets.

Our goal is to guide you toward job opportunities in Accounts, Audit, and Taxation, helping you build a confident and successful career.

📌 Subscribe now and start your journey to becoming a skilled accounting and taxation professional!