The thing most people call a cocktail worksheet is basically just a spreadsheet that tracks what goes into every drink on your menu.
It started as a cost-control tool back when bartenders were still figuring out how to make consistent drinks at volume. A bar with twenty cocktails and three bartenders needs some way to make sure the gin pour isn't drifting between shifts. That's what the worksheet does. It records the exact ounce amounts, the brand specifications, and the cost per serving for every single item you put on a list. At its core, a cocktail mixing worksheet is a document that standardizes recipes across your entire operation. It covers measurements in both fluid ounces and milliliters because different liquor distributors use different systems and you'll need both depending on where you source your spirits. It lists the garnish specification down to the gram because a lime twist that weighs 4 grams costs something different than one that weighs 7 grams. It tracks the theoretical cost of each drink before you add markup, and it calculates the pour cost percentage so you can see at a glance whether aNegroni at $14 is actually making you money or just looking profitable on paper while the inventory says otherwise. I built my first one in 2014 for a twenty-four cocktail menu at a hotel bar. The problem wasn't creating the basic version. It was dealing with seasonal product substitutions. We switched from Campari to an Italian-specific batch import that had a different alcohol by volume and a slightly higher pour rate per ounce. The old worksheet still showed 0.75 oz per drink and a pour cost of 18 percent. The new spirit needed 0.82 oz to hit the same flavor balance because of the ABV difference. If I hadn't recalculated the weight-to-volume conversion using specific gravity rather than just adjusting the price line, we'd have been giving away free alcohol for three months and not knowing it. I wrote a small lookup table that cross-referenced each spirit's ABV against the standard recipe pour and auto-adjusted the cost column. Took me an afternoon to set up. Saved about four hundred dollars a month in waste.
How to build one that actually works
Start with a flat file. Excel, Google Sheets, whatever your kitchen and bar staff can access without needing special software. Most places I've seen fail at this point because they overcomplicate it. They build dropdown menus and VLOOKUP chains and conditional formatting before they've even recorded a single recipe. Just open a blank grid and type columns until it feels right. Your columns should include: Drink name - keep it simple and consistent. If you call it a "Whiskey Sour" in one section and "Bourbon Sour" in another, your report will duplicate it and you'll think you're selling more drinks than you actually are.
Category - Sours, Collins, Highballs, Spirit-forward, House cocktails, Seasonal. This matters because pour cost varies dramatically by category and you'll want to compare them later. Ingredient - List each component on its own row under that drink name. Don't compress ingredients. A Martini with gin, vermouth, and orange bitters needs three separate ingredient rows, not one cell with everything jammed together. Volume per serving (oz) - This is your base measurement. Use a jigger you trust and test it. The difference between what you think a shot is and what it actually is when someone is pulling a heavy bottle at 11 PM on a Saturday can be a full quarter ounce.
Get the Full Details
Volume per serving (ml) - Include this because you'll need it for inventory ordering. Most liquor comes in 750ml and 1.75L bottles and your purchasing system won't convert for you. Spirit brand and spec - Brand matters. A recipe calling for "gin" costs a very different amount than one specifying "Tanqueray No. Ten." If your bartender swaps brands without updating the worksheet, your pour cost numbers become fiction. Write the spec in the document and require a change order when someone wants to substitute. Cost per unit - This should pull from your current purchase price per ounce, not a generic estimate. Divide the case cost by the number of ounces in the case. A 750ml bottle of gin at $22 costs $0.92 per ounce. A case of twelve costs $264 and also works out to $0.92 per ounce. The math is the same but tracking it per-case makes reordering easier.
Total cost per drink - Sum of all ingredient costs plus garnish. This is your floor price. Suggested retail price - This is your sell price. The difference between total cost and retail price determines your gross margin. Pour cost percentage - Total cost divided by retail price. Industry standard for cocktails sits between 18 and 24 percent. Anything above 26 percent on a regular menu drink is usually a warning sign unless it's a premium spirit play where you're intentionally capturing a different customer segment.
One thing most people miss: the garnish. People forget it or list it as zero cost. A dehydrated lemon wheel costs about $0.18. A large luxardo cherry costs about $0.22. A sprig of fresh rosemary costs roughly $0.09 if you're buying it wholesale. On a twenty-dollar drink with a 20 percent pour cost target, those garnishes push you to 21 or 22 percent. That might seem small but it compounds across hundreds of drinks per night.
Where this breaks down
A cocktail mixing worksheet is only as good as the data you put into it and the discipline you maintain around it. Here are the failure modes I've seen repeatedly. Outdated pricing. If your liquor supplier raised prices last week and you haven't updated the worksheet, every pour cost number on it is wrong. I've seen bars run with stale pricing for months because someone forgot to refresh the cost column. Set a calendar reminder for the first of every month to pull invoices and update. Takes twelve minutes. Recipe drift. Bartenders will pour differently on a busy shift. The worksheet assumes 2 oz of spirit. Reality is often 2.25 oz when the bar is moving fast and nobody's counting. The gap between worksheet assumptions and actual pours is called "spill and error" in the industry and it typically runs 3 to 8 percent of total pour volume. Your worksheet doesn't capture that unless you build in a buffer line. I add a 5 percent waste factor to every high-volume drink and flag any drink that uses an expensive base spirit for a higher buffer.
No volume integration. A worksheet that only shows cost per drink is useless for forecasting. You need to know how many of each cocktail you're actually selling. Pull your POS data weekly and match it against the worksheet to see which drinks are actually meeting their pour cost targets and which ones are bleeding. The drinks that look profitable on paper but are underperforming in reality are usually the ones with the most expensive ingredients or the widest gap between assumed and actual pour volume. Too much detail too fast. Don't build a worksheet for your entire menu at once. Start with your top twenty selling drinks. Those twenty drinks probably represent seventy percent of your cocktail revenue. Get those right first. The obscure seasonal cocktail your head bartender invented last week can wait until you've validated the system on the core menu. I've also seen operators try to force worksheets onto cocktails that change every two weeks. Seasonal menus with ingredient substitutions that shift based on supplier availability are a terrible fit for static worksheets. If your menu turns over faster than you can update the cost data, the worksheet becomes a liability. In that case, switch to a simple per-recipe cost card system where each drink has its own single-page sheet and you update only what's changing. It's less elegant but it actually works for fast-changing menus.
The workflow in practice
Here's what a typical week looks like for someone maintaining this system. Monday morning: pull the POS report from the previous week and export sales by drink name. Tuesday: update any ingredient cost changes from supplier invoices. Wednesday: recalculate pour cost percentages and flag any drink that crossed a threshold. Thursday: review the top ten cost-drivers and decide if any pricing adjustments are needed. Friday: communicate changes to the bar team. That's it. About two hours spread across five days. If you're spending more time than that, you're probably over-engineering the spreadsheet instead of just keeping it simple. The real value isn't in building the document. It's in using it every week to catch the gap between what you think your costs are and what they actually are. Most bars operate on guesswork for drink costing and only find out they're wrong when inventory audits reveal they've been selling a drink at a loss for three months without noticing. A worksheet forces you to look at the numbers before that happens. If you want a starting template, I keep a basic one in Google Sheets that has the columns I described above and formulas that calculate pour cost percentage automatically. You can adapt it to your menu size and pricing structure. The key is to treat it as a living document, not something you build once and file away. Update it weekly. Check it against your POS every Friday. Adjust pricing when the numbers tell you to. The system only works if you work it.
