Skip to main content

Pour Cost Calculator in Bar & Nightclub

A suggested spreadsheet layout for bar & nightclub work, tracking drinks, ingredients, cost, price, pour %.

Last updated: August 2026

We haven’t built a ready-made workbook for this one yet. The templates below do the same job, with formulas and sample data, and you can download them today. The suggested columns are further down if you’d rather build your own.

Build your own

Suggested columns for “Pour Cost Calculator”

Format: No ready-made file yet (column guide)Columns: 5

Columns to start with

  • Drinks
  • Ingredients
  • Cost
  • Price
  • Pour %
  1. Copy the column list and paste it into cell A1 of a new Google Sheet or Excel workbook.
  2. Split it into columns: Google Sheets Data → Split text to columns; Excel Data → Text to Columns (comma).
  3. Or skip the setup and start from one of the working templates on this page.

Review evidence

What to verify before choosing Pour Cost Calculator

Use the review criteria below to decide whether this template fits your workflow.

Review criteria

  • +Pour cost and margin per drink
  • +Target pour-cost percentage and price
  • +Cocktail recipe costing
  • +Works in Google Sheets and Excel

Often worth considering when

  • +Bars pricing cocktails for margin
  • +Anyone checking pour cost per drink

Pause before choosing when

  • -Live liquor price feeds
  • -POS integration

About Bar & Nightclub

Why people consider this option

  • +Track inventory, pour cost, and sales without paid bar software
  • +Protect margins with real pour-cost math
  • +Catch shrinkage between counts

What to review before acting

  • -No POS or scale integration
  • -High-volume bars eventually need inventory software

Trust FAQ

Questions people ask before copying a template

Does the Pour Cost Calculator work in both Google Sheets and Excel?
Yes. It is built with standard functions and no macros, so it opens and works the same in Google Sheets or Microsoft Excel — on desktop or your phone.
Is the Pour Cost Calculator really free?
The core template is free to copy and use. There is no paid tier — copy the suggested columns into a new sheet, or start from one of the working templates on this page.
What does the Pour Cost Calculator track?
It tracks drinks, ingredients, cost, price, pour %. The suggested columns are listed in order; add totals or highlights with basic formulas like SUM once your data is in.