Bar Pour Cost From Spirits and Beer Invoices

Bar pour cost from spirits and beer invoices starts with one conversion: each distributor invoice line has to become a usable serving cost. For spirits, divide the bottle's wholesale cost by its usable pours. For draft beer, divide the keg's net beer cost, excluding refundable deposits, by expected sellable pours. For cocktails, add every ingredient in the recipe, including mixers and garnish, then divide the full recipe cost by the menu price.

A 750ml bottle gives about 17 measured 1.5oz pours before practical loss. A 1L bottle gives about 22, and a 1.75L handle gives about 39. A US half-barrel keg gives about 124 sixteen-ounce pours before foam, line cleaning, and other draft loss; a sixth-barrel gives about 41. Those working yields turn Southern Glazer's, RNDC, Breakthru, regional beer distributor, and mixer supplier invoices into the cost basis behind every well drink, call drink, cocktail, draft pint, bottle, and can on the menu.

The mistake most pour-cost calculators make is starting after the hard part. They ask for a bottle cost or keg cost as if that number is already clean. In a real bar, the cost comes from a PDF invoice with case packs, bottle sizes, deposits, discounts, taxes, delivery fees, package descriptions, and sometimes inconsistent brand names across suppliers. The useful workflow starts one step earlier: extract the invoice line items, normalize the package size, remove costs that do not belong in beverage COGS, calculate serving cost, then update the recipe and menu-price worksheet.

The core formulas are short:

• Spirit pour cost: bottle wholesale cost divided by usable pours per bottle
• Draft beer pour cost: net keg beer cost divided by sellable pours after draft loss
• Packaged beer cost: invoice cost per bottle or can
• Cocktail recipe cost: sum of each ingredient cost by recipe quantity
• Pour cost percentage: drink recipe cost divided by menu price

Weekly control adds one more layer. Theoretical pour cost comes from POS sales mix multiplied by the current recipe costs in the spreadsheet. Actual beverage cost comes from beginning inventory plus invoice purchases minus ending inventory. The gap between those two numbers is where over-pouring, comps, draft waste, stale recipes, missing mixer costs, or supplier price increases show up.

Read the Invoice Lines Before You Touch the Formula

The pour-cost workbook should begin as an invoice-line table, not as a finished calculator. Each row needs enough detail to explain where the cost came from and how it should be used: supplier, invoice number, invoice date, brand or SKU, package type, bottle or keg size, case pack, quantity, unit cost, extended cost, taxes, fees, discounts, and refundable deposits.

For spirits, the fields that drive the math are bottle size, case pack, bottle cost, and the specific brand or SKU. A case price is not enough unless the workbook also knows whether the case holds six 750ml bottles, twelve 1L bottles, or some other pack. If the distributor invoice lists a posted case price and a line-level discount, the cost used for pour math should be the net bottle cost after the discount, not the list price.

Beer invoices need a slightly different structure. A keg line should identify the brand, keg size, net beer cost, deposit, and any taxes or fees that belong in beverage cost. A packaged beer line should identify the pack size, for example twenty-four 12oz cans or twelve bottles, so the spreadsheet can calculate cost per unit. The same supplier may deliver half-barrels, sixth-barrels, cases, and credit lines on one invoice, so package type needs its own field instead of being buried in the description.

Mixer and garnish invoices look more like foodservice invoices. Lime juice, fresh citrus, tonic, ginger beer, syrups, bitters, cherries, olives, and garnish packs may come from Sysco-style foodservice suppliers, specialty mixer vendors, or produce vendors. Those lines still belong in the drink-cost workbook when they affect cocktail profitability. A $14 cocktail with a low base-spirit cost can stop looking profitable once premium tonic, fresh juice, bitters, and garnish are counted.

Some invoice fields support pour-cost math; others support AP and audit trail. The beverage manager needs net bottle, keg, can, and mixer costs. The bookkeeper still needs invoice number, supplier, date, total, tax, deposit, GL category, and payment status. That is where restaurant supplier invoice coding sits next to the pour-cost worksheet rather than replacing it.

Invoice Data Extraction fits at this input layer. A bar team can upload supplier PDFs or images, prompt for line items such as invoice date, supplier, brand, SKU, package size, case pack, quantity, unit price, extended cost, taxes, fees, and deposits, then download the extracted data as Excel, CSV, or JSON. The spreadsheet still owns the beverage formulas; the extraction step keeps the starting data from being retyped by hand.

Calculate Spirits by Bottle Size, Pour Size, and Recipe Quantity

Spirit costing starts by converting the invoice's bottle cost into cost per ounce and cost per measured pour. A 750ml bottle contains about 25.36 fluid ounces. At a 1.5oz measured pour, that is 16.9 theoretical pours, so most bar spreadsheets use 17 as the working count before loss. A 1L bottle contains about 33.81oz, or 22.5 theoretical 1.5oz pours. A 1.75L handle contains about 59.17oz, or 39.4 theoretical pours.

The exact formula is:

• Cost per ounce: bottle wholesale cost divided by bottle ounces
• Cost per pour: cost per ounce multiplied by pour size
• Liquor cost percentage: portion cost divided by selling price

That last relationship is not just bar-manager shorthand. The IRS restaurant and bar glossary defines liquor cost percent as portion cost divided by selling price, and portion cost as unit cost times the portion served. The same terms appear in operating worksheets because they map cleanly to both drink pricing and audit review.

Suppose a 750ml well vodka bottle costs $13.60 from the latest liquor invoice. The bottle has about 25.36oz, so the cost per ounce is about $0.54. A 1.5oz well pour costs about $0.81. If the vodka soda sells for $7.00 before tax, the base spirit alone is about 11.6% of the selling price. The full drink cost may be higher after soda, garnish, straw, and expected waste, but the spirit line gives the manager the starting point.

For call and premium pours, percentage is only part of the decision. A premium whiskey sold neat may show a higher liquor cost percentage than a well drink, while still producing a much larger dollar margin per order. That is why the workbook should keep both numbers visible: cost percentage for control and gross profit dollars for menu strategy.

Measured pours matter because the whole calculation assumes a portion standard. A jigger keeps the worksheet close to actual service. Free-pour service can work in a disciplined bar, but it needs periodic testing because a small over-pour changes the cost materially across hundreds of drinks. Spillage, staff tastings, comps, bottle residue, and unrecorded voids should not be hidden inside the bottle yield forever. If those losses are real, they belong in the variance review or in a documented loss allowance.

Separate Draft Beer, Packaged Beer, and Keg Deposits

Draft beer pour cost uses the keg's beer cost, not the invoice line total if that total includes a refundable deposit. The formula is net keg beer cost divided by expected sellable pours. The deposit still matters for AP and cash reconciliation, but it is not beverage COGS for pour-cost math because the bar expects to recover it when the empty keg is returned.

A US half-barrel keg holds 15.5 gallons. That is about 1,984 fluid ounces, or roughly 124 sixteen-ounce pours before loss. At a twelve-ounce serving, the same keg gives about 165 pours. A sixth-barrel holds about 5.16 gallons, or roughly 661 ounces, which gives about 41 sixteen-ounce pours or 55 twelve-ounce pours before loss.

Draft loss turns those theoretical counts into operating counts. Foam, line cleaning, warm kegs, staff mistakes, freshness loss, and end-of-keg waste all reduce sellable beer. If a half-barrel costs $132 after excluding the deposit and the bar expects a 7% draft-loss allowance, the 124 theoretical pints become about 115 sellable pints. The beer cost is then about $1.15 per pint. At an $8.00 menu price, the draft beer pour cost is about 14.4%.

That example changes quickly when the wrong cost is used. If the invoice line shows $132 for beer plus a $30 refundable deposit, treating the full $162 as keg cost pushes the same pint to about $1.41 and the pour cost to 17.6%. The bar did not become less profitable; the spreadsheet classified a balance-sheet item as beverage expense.

Packaged beer is more direct. If the invoice shows a case of twenty-four cans at $31.20, the starting cost is $1.30 per can before any taxes or fees that belong in beverage cost. If the bar sells the can for $6.00, the packaged beer cost percentage is 21.7%. Packaged beer still needs brand, package, unit count, tax treatment, and supplier fields, but there is no keg yield or draft-loss allowance to calculate.

Because alcohol invoices often carry deposits, credits, delivery charges, and compliance-sensitive records, the pour-cost workbook should not be the only record. When the issue turns from pricing to retention, audit trail, and supplier documentation, alcohol distributor invoice recordkeeping for restaurants is the adjacent control.

Cost the Cocktail, Not Just the Base Spirit

A cocktail recipe cost is the sum of every ingredient in the glass. Base spirit is usually the largest line, but it is not the whole drink. Vermouth, liqueurs, bitters, juice, syrup, tonic, ginger beer, fruit, olives, cherries, herbs, rims, and expected waste can change the true cost enough to affect menu pricing.

Take a Manhattan as a working example. If a 750ml bottle of bourbon costs $20.49, the cost per ounce is about $0.81. A 2oz pour costs $1.62. If a 750ml bottle of sweet vermouth costs $24.99, the cost per ounce is about $0.99, so a 1oz pour costs $0.99. Add $0.05 for bitters and $0.10 for a cherry garnish, and the recipe cost is $2.76. At a $14.00 menu price, the cocktail's pour cost is 19.7%. That tells the manager something useful: premium modifiers can push a classic cocktail into signature-cocktail cost territory even when the base spirit looks reasonable on its own.

The example is less important than the spreadsheet pattern:

• Ingredient
• Supplier or source invoice
• Bottle, package, or unit size
• Invoice cost
• Cost per ounce, unit, or serving
• Recipe quantity
• Ingredient cost
• Menu item
• Menu price
• Pour cost percentage

This is where many bar spreadsheets understate signature cocktail cost. Spirits come from liquor distributors, so they are visible to the beverage manager. Mixers and garnishes often arrive through foodservice purchasing, where they sit beside produce, kitchen supplies, and prep ingredients. If the bar uses premium tonic, fresh citrus, bottled juices, house syrups, and garnish packs, the relevant lines from the foodservice wholesaler invoice purchase log belong in the cocktail-cost table.

Well drinks, signature cocktails, and premium pours should not all be forced into one target. A well drink made with the house vodka may be priced to run at a low cost percentage because the portion is predictable and the customer is buying speed and familiarity. A signature cocktail may tolerate a higher cost percentage if it supports the venue's identity and carries good gross profit dollars. A premium neat pour may look expensive as a percentage but still be worth carrying because the absolute margin per sale is strong.

Category targets should be operating guideposts, not universal rules. A bar might expect well drinks to sit in a tighter cost band than signature cocktails, while premium pours, draft beer, and packaged beer each get their own range. Set those targets by category, compare the worksheet against them every time invoice prices update, and investigate persistent drift rather than one noisy service period.

The spreadsheet should let the manager see both views: recipe cost as a percentage of selling price, and gross profit dollars per drink. Percentage protects the beverage-cost target. Dollar margin keeps the menu from punishing items that earn money even when their percentage is not the lowest on the list.

Build the Pour-Cost Spreadsheet Around Normalized Line Items

A useful bar pour-cost spreadsheet is usually a small workbook, not one crowded sheet. Keep invoice lines, product normalization, serving yield, recipe costing, menu prices, and variance review separate enough that each table has a clear job.

The invoice-line tab should capture supplier, invoice number, invoice date, brand or SKU, package type, bottle or keg size, case pack, quantity, current invoice cost, prior invoice cost, extended cost, taxes and fees, refundable deposit, net beverage cost, price-change flag, and date of last price change. The normalization tab should map messy supplier descriptions to the product names the bar actually uses: house vodka, rail gin, Maker's Mark, Aperol, house tonic, half-barrel lager, rotating sixth-barrel IPA. This protects the recipe table when one distributor calls an item by a brand-family name and another uses a SKU-heavy description.

The yield tab converts normalized products into usable serving costs. Spirits need bottle ounces, pour size, cost per ounce, and cost per pour. Draft beer needs keg size, net beer cost, draft-loss allowance, and sellable pours. Packaged beer needs cost per bottle or can. Mixers and garnishes need package size and recipe unit, such as ounce, dash, slice, wedge, cherry, or bottle.

The recipe tab connects those serving costs to menu items. Each recipe line should include menu item, ingredient, recipe quantity, ingredient cost, and total recipe cost. The menu-price tab then carries selling price, target cost range, actual pour cost percentage, and gross profit dollars. A price-change field is useful because the manager does not only need today's margin; they need to know which distributor line moved since the last invoice.

This is the point where Invoice Data Extraction is most relevant: use it to extract distributor invoice line items into spreadsheets before the workbook formulas run. A prompt can ask for supplier, invoice date, brand or SKU, package size, case pack, quantity, unit price, extended cost, taxes, fees, refundable deposits, and source file details. The output can be downloaded as Excel, CSV, or JSON, and the product's line-item extraction is designed for invoice rows rather than only invoice totals.

The tool should not be treated as the bar's pricing brain. It does not decide whether a cocktail should sell for $14 or $16, whether a venue should accept a higher cost percentage on a premium pour, or how tightly the bar should run inventory counts. Its role is narrower and more useful: convert supplier PDFs and images into structured line-item data so the beverage workbook starts from clean, traceable inputs.

Use Theoretical Versus Actual Cost to Find Variance

The spreadsheet becomes a control tool when it compares theoretical cost with actual cost. Theoretical pour cost comes from POS sales mix multiplied by the current recipe costs. If the bar sold 210 vodka sodas, 140 Manhattans, 95 draft lagers, and 60 canned IPAs, the workbook can calculate what those sales should have cost based on the latest invoice prices and recipe standards.

Actual beverage cost comes from inventory movement:

Beginning inventory + purchases from invoices - ending inventory = actual beverage cost

Beginning and ending inventory need enough precision to make the comparison useful. High-volume bars often count weekly; lower-volume programs may count monthly. Bottles are commonly counted to tenths, so a bottle of gin might be recorded as 0.4 remaining. Kegs, cases, and packaged beer need consistent counting rules. Inventory extension should use the latest relevant invoice price, otherwise the actual-cost side of the workbook drifts away from current purchasing reality.

Variance is the gap between what the bar should have used and what it actually used. A small gap can be normal operating noise, especially in a busy bar with draft loss, comps, staff training, and occasional voids. A persistent gap needs investigation by category, then by SKU or menu item. As an operating guidepost, a gap under 2% is usually tight control, 2% to 5% deserves routine review, and a recurring gap above 5% should trigger a deeper look at recipes, counts, purchasing, and service behavior. Spirits variance points toward over-pouring, unrecorded comps, theft, stale recipes, bottle-count errors, or POS buttons that do not match the drink served. Beer variance can point toward foam, line-cleaning loss, warm kegs, partial returns, package-count errors, or deposits and credits coded incorrectly. Cocktail variance often comes from ignored mixers, garnish creep, undocumented recipe changes, or a supplier price increase that never made it into the recipe table.

The review should feel routine, not punitive. Start with the largest dollars, not the loudest theory. Check whether the latest invoices were imported, whether refundable deposits were excluded from beer cost, whether foodservice mixer lines were included, whether recipes match the way bartenders actually build drinks, and whether inventory counts were extended at current prices. If those controls are clean, then service behavior and loss become easier to isolate.

Clean invoice line data does not remove the manager's judgment. It gives that judgment a reliable base: current supplier costs, normalized package sizes, traceable recipe inputs, and a repeatable way to see when the bar's actual beverage cost moves away from the theoretical cost implied by the menu.