What's inside?
- A single Inventory Sheet that tracks every SKU by beverage type and bottle format — recording quantity, par, and unit cost, then auto-calculating total cost per item, order quantity (par − on-hand), order cost, and your running SKU count, bottle count, and total inventory value.
Know What's on Your Shelves — and What It's Worth
A bar inventory is a full count and valuation of your beverage stock at a point in time: what you have, what it cost, and what it is worth sitting on the shelf. That figure is not just a count — it is working capital. Every unopened bottle is cash you have already spent and have not yet sold.
For most bars, beverage stock is one of the largest controllable assets in the building, and beverage variance commonly runs 18–24% without tracking. A structured count is the first control: you cannot measure pour cost, spot shrinkage, or reorder accurately until you know exactly what is on hand and what it is worth.
How Do I Turn a Count Into Control?
Enter three numbers per item and the sheet does the rest:
- Quantity — your current on-hand count, bottles and partials.
- Par — the level that carries you to the next delivery for that item.
- Unit Cost — what you pay per bottle.
From those, Total Cost values each line, Order Quantity shows the gap to par, and Order Cost tells you what the replenishment will run — while the header totals your SKUs, bottles, and full inventory value. Count on the same day each period, and the trend in total value becomes an early read on overstock, dead stock, and cash tied up behind the bar.
An unopened bottle isn't just stock — it's cash sitting on a shelf. A bar inventory is how you find out how much of your money is waiting there, and how much to order to keep it working.
.svg)