Alcohol Inventory Spreadsheet

Have you been asked to make an alcohol-inventory spreadsheet? I’ve seen it happen so many times, the person making the request is either a customer service rep or someone with a significant amount of time on their hands.

The main goal of the alcohol inventory spreadsheet is to create a record of how much the client has had and where and when they bought it from. I’m not sure that this information is ever used to discipline any of the people responsible for selling it. Some people may have purchased the product and later returned it due to intoxication, but others probably did not know they had been drinking.

Alcohol Inventory Control Sheet
Alcohol Inventory Control Sheet

The typical response to a request for this information is; “So, the customer service representative can come in and take a sample inventory, right?” This isn’t a good idea. Let’s review the process involved in taking a complete inventory of all the alcohol in your home.

The problem with this step in an alcohol-inventory spreadsheet is that you don’t know where the alcohol came from or if it was even consumed by you. You don’t know how much alcohol you have in your refrigerator, cabinets, and so forth.

The next most important step is to determine how you are going to distribute the inventory among your family members. Now you will have to figure out who is getting a bottle a day, and who is getting two bottles a day, etc. All of this is a recipe for trouble. The more people you assign responsibility for your alcohol, the more likely it is that some will be drinking too much and others will be under the influence of alcohol without even knowing it.

The other thing you have to do is figure out who is getting alcoholic beverages on a regular basis, and who is just drinking when they want to. How are you going to know how much is too much, when to give up alcohol, and when it’s just not the time. It is very difficult to deal with a lot of drunkenness at once, let alone deal with alcoholism as a whole.

Alcohol Inventory Spreadsheet Template
Alcohol Inventory Spreadsheet Template

The last step in an alcohol-inventory spreadsheet is to determine how you are going to distribute the alcohol among all your members of your family. You will need to figure out how many bottles they are taking every month, and what portion each person is supposed to get. Once you’ve figured out how you are going to divide up the responsibility, you’ll need to figure out who you’re giving it to, and how often.

The fact of the matter is, the person who asks you for an alcohol inventory spreadsheet doesn’t want to get it. They are there to profit from the sale of alcohol and to scare you into buying their product.

Alcohol Inventory Spreadsheet
Alcohol Inventory Spreadsheet

So to create an effective alcohol inventory spreadsheet, you need to first get rid of the people you don’t want to deal with. Next, figure out how much you can afford to spend per month on the supplies.

Once you’ve done this, you can start to work on developing an inventory. There is no one single way to do it, but I recommend starting by collecting all your receipts from purchases. The point at which you start getting receipts, you can work your way from the highest purchase to the lowest.

Once you have the receipts, you then have to figure out how many bottles you’ve bought from each person, and how many each purchase has cost. Now you can divide this number by the number of bottles purchased to get a reasonable estimate of how much each person is getting a month. And that number divided by the average bottle purchased per person, you can give them their own portion. So it becomes clear to everyone that each person needs to pay for his or her own portion of the purchases.

Once you have that figured out, you can figure out the amounts each person should get for his or her own portion. This will tell you what percentage of the sale price each person will get. Once you have figured out these numbers, you can set limits for each member of your family.