resources

free bar inventory
spreadsheet template.

what to track, how to count, when to count, and the mistakes that cost you money every single week.
the template

what your inventory
spreadsheet needs.

required columns

the eight fields every bar inventory sheet should have.

1. item name — the specific product (e.g., "Tito's Handmade Vodka 1L," not just "vodka"). be precise enough that anyone on your team knows exactly which bottle you mean.

2. category — group items for analysis: vodka, gin, rum, tequila, whiskey, cordials/liqueurs, beer, wine, mixers, garnishes, non-alcoholic. this lets you see cost by category.

3. unit size — 750ml, 1L, case of 24, keg (1/2 barrel), etc. always track the unit you purchase in.

4. unit cost — what you pay per unit from your distributor. update this every time pricing changes.

5. par level — the minimum quantity you want on hand at all times. more on this in our par level guide.

6. current count — what's actually on the shelf right now, as of your last count.

7. variance — the difference between what you should have (based on sales data and deliveries) and what you actually have. this is where you catch problems.

8. order quantity — par level minus current count, rounded up to your supplier's minimum order quantity.
optional but useful

extra columns that pay for themselves.

distributor / vendor — who you buy this item from. useful when you have multiple suppliers and need to combine orders.

distributor SKU / item number — speeds up ordering dramatically. copy the SKU directly into your order form.

storage location — "main bar," "service well," "back bar," "walk-in," "dry storage." makes counting faster because you can count by location instead of hunting for items.

last order date — helps you spot items you're ordering too frequently (cash flow issue) or too rarely (potential stockout).

cost per ounce — unit cost divided by ounces in the container. essential for calculating pour cost. see our pour cost calculator for the formula.

weekly usage — average units used per week over the last 4–8 weeks. the foundation for setting accurate par levels.
how to count

the right way to take
bar inventory.

counting method

tenthing: the industry standard for open bottles.

for sealed bottles and cases, counting is straightforward — count the units. for open bottles, use the tenthing method:

hold the bottle up to eye level and estimate how full it is in tenths. a bottle that's about three-quarters full is 0.7. half full is 0.5. a quarter left is 0.3.

this isn't perfectly precise, but it's consistent enough for bar inventory purposes. the key is consistency — the same person estimating the same way each time reduces variance.

tips for accuracy:
• count at the same time every period (e.g., Monday at 9am before deliveries)
• count by location, not by category — go shelf by shelf
• have one person count and another record
• never round up — if it looks like 0.3, write 0.3, not 0.5
• weigh high-value items (top-shelf spirits) for better precision
when to count

weekly is the minimum. here's when and why.

weekly counts are the industry best practice for bars. monthly counts let problems compound for 30 days before you catch them — that's four weeks of potential over-pouring, theft, or waste going undetected.

best time to count: before the first delivery of the week, when the bar is closed. this gives you a clean snapshot — nothing has come in, nothing has gone out.

how long it takes: a well-organized bar with a standardized count sheet can complete a full inventory count in 45–90 minutes with two people. the first few counts take longer. by the fourth week, your team will have the rhythm down.

what to count: everything behind the bar, in the walk-in, in dry storage, and in any satellite bars or service wells. don't skip backup stock — that's where variance hides.

high-value items: consider counting your top 20 items (by dollar value) twice per week. these typically represent 60–80% of your total inventory value.
common mistakes

seven inventory mistakes
that cost you money.

process errors

mistakes in how you count.

1. inconsistent timing. counting on Monday one week and Thursday the next makes your data useless for trend analysis. pick a day and stick with it.

2. counting after deliveries. if a delivery arrives mid-count, you'll either double-count or miss items. always count before deliveries, or hold the delivery until counting is done.

3. skipping the back stock. the bottles behind the bar are the visible inventory. the cases in storage are where the real money sits. count both, every time.

4. not updating costs. your spreadsheet says Espolon Blanco costs $24/bottle but your distributor raised it to $27 two months ago. now every calculation based on that item is wrong. update costs with every delivery.
system errors

mistakes in how you track.

5. no variance tracking. counting inventory without comparing it to expected usage is just an exercise in writing numbers down. the value of inventory is in the variance — the gap between what you should have and what you actually have. if you're not calculating variance, you're not doing inventory.

6. not acting on the data. you counted, you found a $400 variance on Hendrick's gin, and then... nothing. inventory data is only valuable if it triggers action: a conversation with your bar team, a recipe audit, a lock on the storage room.

7. using one giant spreadsheet. a single tab with 200+ items becomes unmanageable fast. separate by category or location. better yet, use a system that handles the organization for you.

the fundamental problem with spreadsheets is that they're static. you enter data once a week and hope the formulas don't break. there's no live connection to your sales, your recipes, or your purchasing. every insight requires manual work.
or skip the spreadsheet — olldae. does it all.
start free trial
14 days free · no card required · set up before service