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.
The batching spreadsheet Download
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.
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.
Glassware Audit Calculator Download
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.
To properly use this calculator, you will need:
Input your glassware costs as well as the # of glasses broken and served and the sheet will tell you the % chance each glass will break when given to a guest, and the dollar amount associated with breaking that glass. It will also summarize the results in a small box on the bottom, telling you how much more you should add to your "Cost" to account for missing and broken glasses.
(Note: This spreadsheet assumes you are not buying glassware and putting it in your stock during a set period of time as it is used just as a guide)
Juice Yield Calculator Download
Bar Waste Calculator Download
This spreadsheet shows the financial impact waste has on your bar.
Tip Tracker Spreadsheet Download
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.
There are always potential risks in everything you do. The below safety guidelines come from Beverage Factory.
1. What you’ll need to buy
Links above are just examples to illustrate the parts you will need. Shop around at local businesses, order from wherever you want.
Use the chart below to figure out what works best for your space. Yield estimates are conservative. I use a 5lb tank at home and replace my tank every few months.
Cost to refill/swap and empty CO2 tank
This is going to vary greatly based on your location, the size of your tank, and the shop you go to. A welding shop might refill your 5lb tank for $10 where a homebrew shop might charge $28 to swap your empty tank for a full one. There’s no point in paying for a new shiny tank, just get the cheapest one you can get from a reputable source.
Co2 Wrench (Optional But recommended)
2. Assemble your tank
You’re almost ready to make some soda.
If you are completely unfamiliar with how a system like this works, you should probably read section 3, but don't allow it to discourage you from buying a CO2 tank. It takes less than a minute to check. It is just an added precaution to make sure your CO2 tank is set up correctly.
3. Check for Leaks
There are 3 areas where your setup can leak CO2.
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.
You’re now leak free and ready to make some carbonated beverages
Make some soda or carbonated cocktails