Quick answer
Inventory sheet built for bars: Bars rotate taps, adjust cocktail batches, manage happy hour rules, and need clear drink descriptions that help guests choose quickly.
What this template helps you do
This inventory sheet helps bars connect stock counts to menu decisions. Bars rotate taps, adjust cocktail batches, manage happy hour rules, and need clear drink descriptions that help guests choose quickly.
Best use case
Use it before busy shifts, delivery days, events, and any service where low stock should change what guests see. Use the QR menu to update rotating taps, feature cocktails, clarify happy hour windows, and add ABV or flavor notes without reprinting.
Bars inventory sheet example
| Item | Unit | Par level | Current count | Menu action |
|---|---|---|---|---|
| House tequila | Bottle | 12 | 4 | Limit margarita promo |
| Local IPA keg | Keg | 2 | 0.5 | Mark tap nearly out |
| Limes | Case | 3 | 1 | Adjust citrus-heavy drinks |
| Coupe glasses | Rack | 8 | 3 | Avoid large martini push |
| NA spirit | Bottle | 6 | 2 | Keep mocktail feature |
Bars inventory checklist
How to use the inventory sheet
Count before service decisions
Run the count early enough to change prep, purchasing, or menu availability.
Compare against par
Highlight low-stock items and items with more stock than expected.
Choose menu actions
Mark items limited, pause promos, adjust specials, or remove sold-out items.
Review after service
Use sell-outs and waste to refine the next par level.
Inventory is a menu visibility input
For bars, a stock count should affect guest-facing availability before guests try to order unavailable items.
How this connects to your QR menu
Use the QR menu to update rotating taps, feature cocktails, clarify happy hour windows, and add ABV or flavor notes without reprinting. Use FlipMenu to update live menu availability after each stock decision.
Use the worksheet first, then publish the guest-facing result only after the manager review is complete. That keeps the digital menu useful without turning it into an unapproved operations notebook.