Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityHospitality OperationsBar Inventory and Pour Cost

SpreadsheetHospitality OperationsFree

Bar Inventory and Pour Cost

Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.

Shown with sample data

Colour

Bar Inventory and Pour Cost

Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.

Products
11
Average pour cost
20%
Above target
2
Cost of product used
$1,168
Sales value
$5,630
Actual pour cost
21%
Variance cost
$71.82
Positive = product unaccounted for
Products to investigate
2
Pour cost % by product
  • Draught lager (sixth-barrel keg)31.7%
  • House red wine (750 ml)29.1%
  • Sauvignon blanc (750 ml)27.8%
  • Bourbon (750 ml)22.3%
  • Draught IPA (half-barrel keg)19.9%
  • Blanco tequila (750 ml)19.4%
  • Aged rum (750 ml)17.8%
  • Premium vodka (750 ml)15.1%
Variance cost by product
  • Blanco tequila (750 ml)$23.04
  • Bourbon (750 ml)$22.44
  • Draught IPA (half-barrel keg)$9.25
  • Draught lager (sixth-barrel keg)$8.50
  • Premium vodka (750 ml)$3.64
  • Aged rum (750 ml)$2.10
  • Sauvignon blanc (750 ml)$1.68
  • London dry gin (750 ml)$1.44

How to use it

  1. 1List each product on the Products sheet with its bottle size in ounces, cost, standard pour and menu price.
  2. 2Set target pour cost % for each category on the Targets sheet.
  3. 3Each week, count every bottle to the nearest tenth and enter opening, received and closing counts plus pours sold from the POS.
  4. 4Investigate any product with a variance flag: check pour sizes, comps and voids, and the count itself.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Pour cost is where bar profit leaks. The Products sheet turns bottle size, bottle cost, pour size and menu price into pours per bottle, cost per pour and pour cost %, and compares each with the target for its category. The weekly count works out how many bottles you actually used from opening stock, deliveries and closing count (to the tenth of a bottle), what that cost, what the POS says you sold and the variance between the two, so overpouring, comps that were not rung in and theft show up in dollars.

Who it’s for

  • Weekly or monthly bar stock counts
  • Pricing a new cocktail or wine list
  • Finding where liquor cost is leaking

What’s included

  • Products sheet: Pours, cost per pour and pour cost % for each product.
  • Weekly count sheet: Usage from counts against what the POS sold.
  • Targets sheet: Target pour cost % for each category.

How to use it

  1. 1List each product on the Products sheet with its bottle size in ounces, cost, standard pour and menu price.
  2. 2Set target pour cost % for each category on the Targets sheet.
  3. 3Each week, count every bottle to the nearest tenth and enter opening, received and closing counts plus pours sold from the POS.
  4. 4Investigate any product with a variance flag: check pour sizes, comps and voids, and the count itself.

Tips

  • Typical targets: spirits 15–20%, draught beer 20–25%, bottled beer 25–30%, wine by the glass 25–35%. Your concept may differ.
  • Count in the same order and at the same time each week, before opening, so counts are comparable.
  • Jiggers and pour spouts are the quickest way to bring pour cost down.

Questions

How do you calculate pour cost?

Cost per pour divided by the menu price. Cost per pour is the bottle cost divided by the number of pours in the bottle (bottle ounces ÷ pour ounces).

What is a good pour cost for a bar?

Most bars aim for an overall beverage pour cost of about 18–24%, with spirits lower and wine higher.

What does variance mean?

Bottles used according to your counts minus bottles you should have used based on pours sold. Positive variance is product that left without being sold.

Related searchesbar inventory spreadsheetpour cost calculatorliquor inventory templatebar pour costbeverage cost percentagebar variance report

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHospitality OperationsFree

Bar Inventory and Pour Cost

Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More hospitality operations templates

View all
Recipe & Menu Costing Calculator2 sheets

Dishes costed

4

Average food cost

23%

Dishes above 35%

1

ABCD
1DishCategoryPortions per batchMenu price
2Tomato & basil soupStarter10$7.50
3Grilled chicken saladMain4$16.00
4Beef burger with friesMain4$13.00
5Chocolate brownieDessert12$6.50
Menu
SpreadsheetHospitality Operations

Recipe & Menu Costing Calculator

Cost every dish from its ingredients, see food cost percentage and margin, and get a price that hits your target.

10 min setupPreview
Vacation Rental Booking & Income Tracker2 sheets

Nights booked

30

Net income

$5,262

Average nightly rate

$169

Fees by platform
$309
$45.20
$38.40
Booking.comVrboAirbnb
SpreadsheetHospitality Operations

Vacation Rental Booking & Income Tracker

Bookings from every platform with nights, fees and net payout, plus occupancy and income for the season.

10 min setupPreview
Hotel Housekeeping Schedule2 sheets

Rooms to clean

6

Done

3

Early arrivals

2

ABCD
1RoomRoom statusPriorityHousekeeper
2101Check-outEarly arrivalRosa
3102Stay-overNormalRosa
4103Check-outNormalAhmed
5104Vacant cleanNormalN/A
Today
SpreadsheetHospitality Operations

Hotel Housekeeping Schedule

Assign rooms to housekeepers with room status, priority and inspection results.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ