This sheet allows you to easily track invoices sent to vendors. It will pool all data inputted and track total money owed, amount collected, outstanding balances and calculate how much you should withhold for taxes.
​

There are 3 areas where your setup can leak CO2.

1. The inlet at the 3 o'clock position of the regulator
2. The outlet at the 6 o'clock position of the regulator.
3. The connection at the end of your hose where the ball lock quick disconnect is attached.

To test the inlet located at the 3 o'clock position on the regulator:

1. Make sure your regulators “Shut off Valve” (located at the 6 o’clock position of the regulator) is in the OFF position.
2. Turn the valve on top of the tank all the way to the on position.
3. At this point gas should be leaving the tank and entering the regulator. You will see the dials on the regulator move. 

One of 3 things will happen now:

• What we want: You should see the dials on the regulator move, and briefly hear the gas enter the regulator and then stop.
• What is OK: Gas will enter the regulator and exit out of the pressure release valve. This is a built in safety precaution. It happens because the pressure in the regulator is set too high.
  • To Fix: Lower the pressure on your regulator with the dial in the center. (Turn it towards the minus sign ( - ) until the sound stops. You can now continue to check the second potential leak.
• Not Good: You continue to hear gas coming out from the connection between the regulator and the CO2 Tank.
  • Fix: Turn the CO2 tank valve to the off position and remove and reattach the regulator to the CO2 tank. Repeat the steps below "To test the inlet located at the 3 o'clock position on the regulator".

If you have confirmed there are no leaks in your regulator to CO2 tank attachment it is time to check the 2 connections on the hose.

• ​With your CO2 Tank valve turned completely to the ON position, open the shutoff valve located at the 6 o’clock position on your regulator completely to the ON position. This will allow gas to leave the regulator and enter the hose.
• Some of these valves look like those shown in the “CO2 Wrench” photo vs the “Regulator” photo above. In that case make sure the valve is turned pointed down, in line with the hose. (Perpendicular with the hose is considered the "off" position.) 
• Consult your regulators instructions if these instructions are unclear.

One of 2 things will happen now. 

• What we want: You will briefly hear gas flow from the regulator into the hose and stop.
• Not Good: You hear or feel gas coming out from one of the 2 connections on the hose.
  • Fix: Close the shutoff valve (located at the 6 o'clock position of the regulator) Turn off the gas, and try to tighten your clamps. If this does not work, try loosening them so you can reposition them and tighten them. The name of the game is to stop gas from escaping.​

This sheet eliminates all of the headaches that come with batching. You're going to save so much time and make fewer mistakes compared to doing your calculation by hand.  This sheet can be extremely useful to bars that feature batching in their cocktail programs regularly, or for bars that are batching cocktails for the first time as part of their togo drinks program. . It currently supports drinks with 2-8 ingredients. 
There are 3 built in calculators on this sheet with unique functions.

• The first calculator is for when you know the final number of bottled cocktails you'd like to make but are unsure how much batch you need for that.
• The second calculator is for situations that come up when you have a set amount of one product (lets say 500ml) and you want to know how much of every other ingredient you need to add.
• The last calculator will tell you the batch recipe based on a final ending volume. All are extremely useful in different scenarios and come up all of the time during batching. 

To use:

1. Copy cells from the "Template" Tab, to the "Your Drinks" tab.
2. Replace the sample data with the single serve cocktail recipe.
3. Determine which of the 3 calculators you want to use and plug in your data.

Note: Only edit the yellow cells. Once you are on the google sheets page, you'll need to select File> Make a copy in order to edit the file.

     Each time a guest breaks a glass and your bar needs to buy more, you incur an expense. In his seminar The Cost of a Cocktail Seminar Bobby Heugel suggests adding the cost incurred from glassware breakage to the Cost of the beverage. This calculator automates that process for you and takes it one step further by also calculating the cost of "missing" glassware. These missing glasses can be broken and not accounted for or stolen.

This spreadsheet shows the financial impact waste has on your bar.

• Calculates your bar's Juice Pars based on weekly and daily use.
• Tracks Daily Waste, YTD Waste, and Projects Yearly Fruit Waste, Juice Wasted, and Money Wasted by over producing juice (or any other ingredients) in your bar.
• Logs YTD pieces of Fruit wasted, $$$ spent on wasted juice, and Volumes of juice not used.
• Figures out your Juice and Fruit cost
• Calculates Daily Pars​

See how much you stand to gain by reducing your waste.

How much money have I made this year? Which days do I make the most tips? 
This spreadsheet tracks your YTD earnings, and provides the average tips earned each day of the week. ​