Liquor Inventory Excel Template
Manage your liquor inventory with our free, easy-to-use Excel template
Download Template
Get instant access to our professional liquor inventory tracking template
Access TemplateAvailable in Google Sheets format. Can be exported to Excel.
Liquor Inventory Management Made Simple
Managing liquor inventory is crucial for operational success. Our free Excel template simplifies inventory tracking, helping you maintain accurate records and make informed purchasing decisions.
Perfect for bars, restaurants, and retail stores that need a simple yet effective way to track their liquor inventory and understand their stock levels.
How the Liquor Inventory Tracker Works
Inventory Sheet Features
Record all your liquor inventory details by filling out these essential columns:
- Category: Specify the type of liquor (e.g., Whiskey, Vodka, Rum, Gin, Tequila)
- Brand Name: Enter the name of the liquor brand (e.g., Jack Daniels, Grey Goose)
- Bottle Size (ml): Specify the size of the bottle in milliliters (e.g., 750 ml, 1 L)
- Stock Quantity: Enter the quantity of bottles currently in stock
- Unit Cost: Enter the cost per bottle
- Total Cost: Automatically calculates the total cost as Stock Quantity × Unit Cost
- Last Restocked Date: Record the date when the item was last restocked
- Supplier Name: Enter the name of the supplier for the liquor
- Supplier Contact: Provide the supplier's contact details
Summary Sheet Features
The summary sheet is your inventory command center, providing instant insights into your liquor stock:
- Automatic calculation of total bottles in stock
- Calculation of total inventory cost
- Count of items below restock level (threshold of 10 bottles)
Benefits of Using Our Template
- Save time with automated calculations
- Track inventory with organized categories
- Maintain accurate stock records
- Make better purchasing decisions
Download and Get Started
Access our free liquor inventory tracker template and start organizing your stock today.
Access Template