How to Use a Monthly Worksheet for Tracking and Mixing Cocktails
A cocktail mixing worksheet is basically a grid where you log what you are making each month, how much of each ingredient you use, and what you need to reorder. It keeps your bar from running out of gin while you have ten cases of vermouth sitting unused. I have seen bars try to do this on napkins or in their heads, and it never works past the third week because the numbers drift and nobody checks them. The monthly version adds a layer that simple daily sheets miss. You are looking at trends over 30 days, comparing pours against sales, and catching when waste or theft starts eating into margin. Most people set one up with columns for date, cocktail name, ounces poured, cost per ounce, total cost, and notes. That is enough to get started, but you will want to add a par level column and a variance column once you have a month of data. The variance shows the gap between what you think you used and what actually moved through the bottle. I used to track cocktail mixing with a loose notebook until I lost a whole bottle of Aperol between Friday night and Monday morning. I had no idea where it went. After that, I built a monthly worksheet that required a pour count at the start and end of each shift, with a running total that had to match the POS report. The first month I ran it, the numbers did not match by nearly two bottles. I found a bartender who was topping off highball glasses at the bar station instead of using the measured jigger. We fixed the technique, and the variance dropped to less than half a bottle a month.
Here is how to set it up in something simple like a spreadsheet. Create columns for Date, Drink, Quantity Made, Base Spirit (oz), Liqueur (oz), Fresh Juice (oz), Other Ingredients, Bottle Count Start, Bottle Count End, Variance, and Cost. Fill in the pour cost from your current invoice prices. At the end of each shift, update the bottle counts and mark any spills or broken glass in the notes column. At the end of the month, sum the quantities and compare to what the POS says you sold. If the ratio of spirit to finished drink does not match your recipe, something is off. There are a few things that make this actually useful instead of another chore you abandon after two weeks. First, put a recipe reference sheet next to the worksheet so every cocktail has a standard pour. Second, calculate a target cost per drink and color-code any entry that goes over by more than five percent. Third, review the variance column every Friday before you place orders. That is when small errors become big problems. I also learned the hard way that a monthly worksheet does not catch daily seasonality. My whiskey sours sold three times more on Saturdays than on Tuesdays, and my reorder numbers were way off until I broke the monthly totals into weekly buckets and adjusted the par levels accordingly. Another trap is assuming that one bottle size fits all cocktails. I kept using 750 ml as the base unit even though I was pouring a lot of 1.75 L spirits. Switching to a single unit and converting on the fly cut my calculation errors in half.
If you want something ready to go, I put together a downloadable monthly cocktail mixing worksheet that includes the columns above, pre-set formulas for variance and cost, and a small recipe reference table. It is plain, it prints well, and it works in Google Sheets or Excel. You can grab it at the link below. Download Worksheet For Cocktail Mixing Monthly Use it for a full month before you tweak anything. Once you have real data, adjust the par levels and the waste factor, then let it run again. The point is not to make the sheet perfect on day one; the point is to keep looking at it and correct the drift before it becomes a shortage.
Get the Full Details
