How To Make Worksheet For Cocktail Mixing

Setting Up a Practical Cocktail Mixing Worksheet

A cocktail worksheet is just a structured document that tracks recipes, ratios, inventory needs, and sometimes costing for a bar or home setup. The main goal is to have something you can reference quickly without flipping through a cookbook or searching notes on your phone. I built my first one back when I was working a small bar in Portland, mostly because the owner kept changing recipes and nobody wrote anything down. We ran out of Campari on a Friday night because the person who ordered the last round didn't think to log it. You don't need fancy software for this. A spreadsheet works fine, and honestly, most people overcomplicate it. I recommend starting with a simple Google Sheet or Excel file, because you can share it across devices and update it on the fly during service.

How To Make Worksheet For Cocktail Mixing

Start by listing out the cocktails you actually serve. Don't include the twenty variations you made once at a party. Real ones. Then for each cocktail, create columns for the following: the base spirit, the modifier, the sweetener, the sour component, garnish, glassware, and method (shaken, stirred, or built). I also add a column for cost per ounce and a calculated total recipe cost, which turns out to be more useful than you'd expect. One thing beginners miss is that most recipe books list volumes in ounces or milliliters, but your inventory is bought by the bottle. Convert everything to milliliters early. It saves you from recalculating costs later. I used to do mental conversions during inventory night and regret every single time. Here's the structure I use:

Column A: Cocktail name
Column B: Base spirit + volume
Column C: Modifier + volume
Column D: Sweetener + volume
Column E: Sour + volume
Column F: Garnish
Column G: Glass type
Column H: Method
Column I: Total recipe cost
Column J: Suggested sell price
Column K: Food cost percentage The cost calculation itself is straightforward. Take your bottle price, divide by the total milliliters in the bottle, then multiply by the recipe volume. For example, if a 750ml bottle of gin costs $24, each milliliter is about ten cents. A 60ml gin measurement costs roughly $0.60. Do this for every ingredient and sum them up. It takes about ten minutes per recipe once you set up the formula, but doing it manually for forty drinks will eat an hour of your life. I also include a batch size column for bars that pre-mix certain cocktails. Negronis and Aperol Spritzes are common candidates. If you batch three parts gin to three parts Campari to three parts sweet vermouth, you can calculate the batch yield and how many servings it produces. This helps with forecasting order quantities.

Another detail people skip: add a substitution notes column. When you're out of a specific vermouth or a guest asks for a variation, having pre-noted alternatives prevents decision paralysis mid-shift. I once had a bartender who didn't know how to make a Boulevardi with rye instead of bourbon because there was no note in the recipe. The drink was fine, but the pause cost us two other orders while he figured it out.

Inventory Tracking Integration

The worksheet becomes significantly more powerful when you link it to a par sheet. A par sheet tells you the minimum stock level before you reorder. If your Negroni recipe calls for 30ml of Campari per drink and you sell fifteen per night, you're using roughly 450ml daily. A 750ml bottle lasts less than two days. Without tracking this, you'll be caught flat on a slow Tuesday. I keep a separate tab in the same spreadsheet for inventory. Columns include product name, current stock in milliliters, par level, reorder threshold, supplier, and price per bottle. The reorder threshold can be a simple formula: par level minus safety buffer. I use a safety buffer of one day's projected usage to account for delivery delays. When you combine the recipe costs with inventory data, you can flag menu items that are bleeding margin. A few years ago I noticed our Old Fashioned was costing 38% of the sell price when the target was under 20%. The issue wasn't the whiskey quality, it was that the recipe called for a 60ml pour but we were actually measuring closer to 75ml because the jigger was worn. Switching to a calibrated pour spout cut the waste and brought the cost down to 22%. That one change recovered about four hundred dollars a month in margin.

Common Problems and Fixes

Some recipes list ingredients by dash or splurge. That's a problem for costing. You have to estimate a dash as roughly 0.25ml or 0.5ml depending on the bottle and your pour. I standardize dashes at 0.5ml in my worksheets and note the assumption. It's not perfect, but it's consistent, and consistency matters more than precision for this kind of thing. Annoying edge case: if a recipe calls for "to taste" or "a splash," you have two choices. Either assign a fixed measurement based on your standard practice, or create a separate notes section with the range. I went with the first approach. "A splash" of simple syrup became 7.5ml across the board. It took some adjustment but eliminated the ambiguity during busy shifts. Another real issue is temperature and dilution. The worksheet doesn't track that, but it should influence your process notes. A stirred drink like a Martinez loses less water than a shaken one, so the balance between spirit and vermouth might need to shift slightly. I've seen bartenders use the same ratio for both methods and wonder why the shaken version tastes watered down. The fix is adding a method-specific note in the recipe description, not changing the numbers themselves.

What This System Doesn't Do Well

For one, a spreadsheet won't catch when you forget to update a price. If your supplier raises the cost of vermouth by fifteen percent and you don't adjust the master list, every cost calculation stays wrong until someone notices. Set a calendar reminder to review the sheet quarterly. It also doesn't handle variable yields from fresh ingredients. Lemon juice from a hand-squeezed fruit varies by maybe ten percent depending on the fruit size and ripeness. That variance is real and it affects cost, but tracking it precisely is overkill for most operations. Accept the margin of error and move on. If you're running a high-volume bar with fifty-plus cocktails, a spreadsheet gets unwieldy fast. At that scale you'd be better off using a dedicated beverage management tool like BevSpot or Xola, which connect directly to your POS and automate inventory and costing. The spreadsheet approach is fine for ten to thirty recipes, which covers most standalone bars and serious home setups.

The key is to start simple, get the core recipes documented with accurate volumes, add costing once the structure is stable, and iterate from there. Trying to build a perfect system on day one usually results in abandoning it after two weeks because the initial effort feels overwhelming.