Bar Inventory: Spreadsheet or App?

By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Prices checked on vendor websites November 10, 2026. Part of our spreadsheet or software series.

Bar inventory is slow because of partial bottles. Every open bottle has to be estimated, and a full count of a busy back bar can take two people a couple of hours. Apps make the count faster and the variance report sharper. A spreadsheet gives you the number that matters most, pour cost, for almost nothing. This page shows how to run it both ways and how to tell which one fits your bar.

The short answer

A single bar with a weekly count and a pour cost target runs well on a spreadsheet. You will know your pour cost by category and whether it is moving, which is enough to manage most bars.

An app is worth paying for when the count takes so long it gets skipped, when you run several bars or a large wine list, or when pour cost is off and you need to see variance by bottle against what the POS says you sold.

We sell spreadsheet templates, so weigh our view with that in mind. The main comparison covers the full cost math and a five question test.

What the job takes

A bar count that produces a trustworthy pour cost has the same steps in any tool.

1. List every product in shelf order. Back bar, wells, coolers, storeroom, keg room. One line per product per location.
2. Count full units and estimate partials in tenths. A bottle that is 60% full is 0.6. Tenths are accurate enough and fast.
3. Count kegs. By weight if you have a scale, or by a consistent estimate.
4. Extend at current cost. Quantity times the last price paid.
5. Calculate usage and pour cost. By category: liquor, beer, wine.
6. Compare with target and with last week. Then look at the products that moved most.

How to run it in a spreadsheet

A bar inventory spreadsheet needs a product list with sizes and costs, a count sheet by location, and a summary by category. The weekly routine looks like this.

1. Count on the same day each week, before the bar opens and before deliveries.
2. Two people is fastest: one calls full bottles and tenths, one writes.
3. Enter the counts and the week's purchases by category.
4. Update any bottle cost that changed on this week's invoices.
5. Read pour cost by category against target.
6. For the five or ten products with the highest spend, compare usage with POS sales to spot over pouring or missing bottles.

The bar inventory guide covers the count in detail and the pour cost guide covers targets. The pour cost calculator and cocktail cost calculator are free. Our Bar Inventory, Par Sheet and Order Guide has the count, pars and order guide in one workbook, and the Bar Inventory Count Sheets are a simpler option.

What software adds, and what it costs

Bar apps are built around making the count faster and the variance visible.

• Phone counting. You tap or slide to set the bottle level, and the count is entered as you go. Some systems use a Bluetooth scale for partial bottles and kegs.
• Variance by product. With a POS link and drink recipes entered, the app compares what was poured with what was rung in, bottle by bottle.
• Ordering. Pars and usage build an order you can send from the app.
• Invoice capture. On higher plans, invoice photos update costs and purchases.
• Drink costing. Cocktail recipes are costed from current bottle prices.

Prices are from each vendor's website on November 10, 2026. Plan names and limits change often in this category, so confirm before you sign.

Side by side

Stay or switch

Mistakes either way

Most bar inventory problems come from the count, not the tool.

• Counting monthly. A month of over pouring is expensive. Count weekly, or count your top sellers weekly and everything monthly.
• Inconsistent partials. Pick tenths and have the same people count the same way each week.
• Forgetting comps, spills and staff drinks. If they are not recorded, they show up as unexplained variance.
• Fixing variance with software before fixing pours. Jiggers, spec sheets and training move pour cost more than any app. The bartender training guide is a good place to start.

Questions

Keep reading