Bar Business Operations + Pour Cost Tracker | Google Sheets

Your bar is leaking money. You just can't see where.Every shift ends and you have a rough revenue number — but no idea what your actual pour cost was, which cocktails killed your margin, or how much product went missing. You're running a bar on gut feel, and gut feel doesn't pay the rent.This Google Sheets tracker puts every number in front of you, automatically.Enter your bottles once. The Pour Cost Calculator auto-computes your cost per oz and cost per drink from your actual bottle size and distributor price — no guessing, no manual math. Set your sell prices and your pour cost % populates instantly.Build your cocktail menu inside the Cocktail Menu Cost sheet. Type in each ingredient, enter the ounces, and your recipe cost calculates live from your bottle library. You'll see exactly which cocktails are earning their place on the menu and which ones are quietly draining your margins.Log every shift in Shift P&L — date, bartender, revenue, drinks sold — and watch your gross margin calculate in real time. Run the Variance Log weekly to compare what your POS says you sold against your physical count. That gap is your shrinkage. Now you'll see it.The Dashboard pulls everything together in one view: blended pour cost %, gross margin, variance dollars, top-selling cocktail, and which products need reordering — live, every time you open the file.WHAT'S INCLUDED: 7-sheet Google Sheets bar operations OS Pour Cost Calculator — auto-calc from bottle size + cost + pour size Cocktail Menu Cost Builder — recipe costing with live VLOOKUP to bottle library Shift P&L Tracker — per-shift revenue, COGS, gross margin Liquor Variance Log — weekly shrinkage and overpour detection Inventory Reorder Alerts — automated REORDER NOW flags at 25% par Dashboard — live metrics: pour cost %, margin, variance $, top cocktail Setup Guide sheet — step-by-step onboarding in under 10 minutes WORKS WITH: Google Sheets (free) and Microsoft ExcelDELIVERY: Instant download — .xlsx file direct to your deviceSETUP TIME: Under 10 minutesPerfect for: bar owners, bar managers, cocktail bar operators, restaurant bar programs, craft cocktail bars, sports bars, hotel bars, nightclub operations

Found on Devadex — the discovery index for independent software the big search engines bury. More from gumroad.

Report this listing