A wine cellar inventory spreadsheet is a great way to keep track of what you have and what you do not have in your wine cellar. It will also show you what you may want to sell off for extra cash or when you will need to buy more wine.
There are several ways to create a wine cellar inventory spreadsheet. You can use Microsoft Excel, Microsoft Word, Google Docs, or any other computer software program that allows you to type out the data. The choice is yours, but I recommend going with the one that you are most comfortable with.
The first thing you need to do is come up with a layout for your wine cellar inventory spreadsheet. Use the space that you have available. You can decide whether to include the entire cellar, just part of it, or even the wine bottles that you do not have in your cellar right now. Whatever works best for you.
After you are done putting everything in place, you will want to list everything out by its “location.” This will help you see what is sitting on the shelves when you look through the spreadsheet. So you might list them in alphabetical order from left to right or top to bottom.
Now that you have your wine cellar inventory spreadsheet, you need to make a note of the dates when you sold or purchased the wine that you are trying to sell. Some people do not like to list the date they purchased a bottle, but this is the best way to know when it was purchased. In this case, just write it down.
The last step for creating a wine cellar inventory spreadsheet is to list out all of the wines that you wish to keep on the shelves. Again, this should be listed in order by the year they were made and then they should be listed by the grape variety. Sort everything and label accordingly.
The final step is to start filling in the columns with the information about each bottle that you have. Remember that you will need the serial number, the winery name, the vinification year, and the store name. Take all of this information and put it on the cell phone, website, or email so that you can sell or buy it later on.
Once you are finished creating your wine cellar inventory spreadsheet, you can either put it up on the web or send it to a wine store or wine auction house so that they can keep an eye on it. Either way, you will be keeping track of what you have and what you might want to sell off at the next wine tasting event.