Bar & Liquor Inventory Template
Count full and partial bottles, compare against par and know the value behind your bar every week.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Product | Category | Size | Full Bottles | Partial | Totalƒ | Par | To Orderƒ | Bottle Cost | Valueƒ |
|---|---|---|---|---|---|---|---|---|---|
| House vodka | Vodka | 1L | 6 | 0.4 | auto | 10 | auto | 14.5 | auto |
| Bourbon | Whiskey | 750ml | 3 | 0.7 | auto | 4 | auto | 27 | auto |
ƒ = calculated automatically by formula.
What's included
- Product
- Category
- Size
- Full Bottles
- Partial
- Total — calculated automatically
- Par
- To Order — calculated automatically
- Bottle Cost
- Value — calculated automatically
Tips for using this template
- Count partial bottles in tenths (0.1–0.9).
- Weekly usage = last count + received − this count.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.