← All free tools

Free Bar Inventory Sheet Generator.

Pick your venue, keep the bottles you carry, download a count sheet with the math built in. Excel, Google Sheets, or print. No signup, no email.

Cocktail Bar stock list (38 of 38 + 0 custom)

Uncheck anything you don't carry. Starter pars are included — tune them to your volume in the sheet.

Cocktail Bar · 38 items

✓Count columns: full bottles + open tenths
✓Auto math: totals, shelf value, order qty
✓Opens in Excel & Google Sheets
✓Printable count-sheet layout

Google Sheets: File → Import → Upload. Excel: double-click the file. Formulas for totals, value and order quantities work in both.

Sheet done? Automate the rest.

OrderingExpress counts against these pars and turns low stock into vendor orders — no more Sunday spreadsheet sessions.

Start free →

How to count a bar with this sheet.

Walk in shelf order, not alphabetical order — well and back bar first, then the cooler, then mixers. Full bottles count as ones, open bottles as tenths: 2.4 is two sealed bottles plus one at four-tenths. Count before service, on the same day every week, and the numbers stay comparable week to week.

Fill in full bottles, open tenths and your invoice cost per bottle. The sheet does the rest: total bottles on hand, shelf value, and — once pars are set — exactly what to order. Unsure about pars? Run your numbers through the par level calculator.

FAQ.

Does this work in Excel and Google Sheets?

Yes. The CSV opens directly in Excel and imports into Google Sheets via File → Import → Upload. Total, value and order-quantity formulas are written into the file, so the math works in both.

How do I count open bottles?

Estimate by eye in tenths — 0.7 for just under three-quarters, 0.5 for half. Tenths are the industry standard for speed: weighing every bottle is more precise but rarely changes an ordering decision on a weekly count.

How often should I count inventory?

Weekly for the full bar, same day each week, before service. Monthly counting is too slow to catch over-pouring or shrinkage while the cause is still findable. Spot-count high-velocity wells mid-week if theft is a concern.

What's the difference between this and your inventory spreadsheet?

This generator builds a customized starting sheet for your venue type in seconds, free with no email. The full inventory spreadsheet template is a deeper workbook with cost formulas, reorder levels and multi-location sheets.

Is this really free?

Yes — no account, no email, no watermark. Your list never leaves your browser until you hit download.

Next steps: Par Level Calculator, Pour Cost Calculator, or the Bar Efficiency Scorecard.