Free template
Bar inventory count sheet
A spreadsheet to take your weekly count, laid out the way a bar is: one row per product, one column per section. Use it on paper, in Excel or Google Sheets, or import it straight into Bar Ledger.
How to use it
- List your products with their category, vendor, bottle cost and par (how many you want on hand).
- Rename the section columns (Well, Back Bar, Storage) to match your bar. Add a column for each place stock sits.
- Count each section and write what's there. Count open bottles in tenths: 0.7 is a bottle that's 70% full.
- Add up each row for what's on hand, and multiply by unit cost for its value. Anything under par goes on the order.
Importing it into Bar Ledger
The column names are the ones Bar Ledger reads, so you can import this file as your product list. Your sections are created from the section columns, and any counts you've filled in come across as your starting stock. After that, counts happen on your phone and the totals, values and orders are worked out for you.
Count sheet Date: ____________ Counted by: ____________
| Product | Category | Par | Well | Back Bar | Storage |
|---|---|---|---|---|---|
| Tito's Handmade Vodka | Vodka | 3 | |||
| Espolòn Blanco | Tequila | 2 | |||
| Jameson | Irish Whiskey | 2 | |||
| Aperol | Liqueur | 1 | |||
| Miller Lite | Beer | 48 | |||
Skip the clipboard next week.
Bar Ledger turns this sheet into a count on your phone, with totals, values and orders worked out for you. 14 days free, no card required.