Bar Inventory & Shift Control System — Complete Excel Workbook

Know what's on your shelf, what's walking out the door, and what every drink actually costs you.

Most bars lose money in three places: over-ordering, under-counting, and drinks that cost more to pour than anyone realised. None of it shows up on the P&L until the quarter is already gone.

This is the system I build for the venues I consult with, packaged for you to run yourself.

Six tabs. One file. Works in Excel, Google Sheets, or Numbers.

Master Inventory — Every spirit, beer, mixer, juice, syrup, garnish and consumable in one place. Set your par level once. The sheet tells you what to order, what it's worth, and flags anything running low before service, not after.

Wine Cellar — Bottle-level tracking by producer, region and vintage, with by-the-glass flags and live cellar valuation.

Cocktail Builds — Your house recipes, specced to the quarter-ounce, with pour cost calculating on every drink. Change a supplier price and every affected cocktail updates. This is the tab that pays for the file.

Opening Shift & Closing Shift — Printable checklists covering setup, prep, counts, equipment, clean-down and security. Initials and notes on every line. No more "I thought someone else did it."

Built in, ready to overwrite: 49 stocked inventory items, 18 wines, and 10 classic cocktail builds — so you're editing a working system, not staring at an empty grid.

Every formula is live. Nothing to install, no subscription, no account. Download it and it's yours.

Choose your option

Workbook Only — Instant download. Yours in under a minute.

Workbook + 30-Minute Setup Session — Everything above, plus half an hour with me by video. We set your par levels against your actual turnover, cost your top-selling drinks, and adapt the shift sheets to how your bar really runs. You leave the call with a working system, not homework.

Bring your current stock list and a recent supplier invoice. Limited to 4 sessions per month.

Written by Andrel N.K. Andrew — certified rumologist, National Cocktail Champion, and former National Brand Ambassador for the House of Angostura.

Single-bar licence. Use it across your own outlets. Not for resale or redistribution.