Looking for a great Tracking / Inventory spreadsheet

[Alex Dryden]

Looking for a great Tracking / Inventory spreadsheet to inventory and keep track of all my Bourbon collection?  Des anyone have a good  one?

[fosmith]

40 minutes ago, Alex Dryden said:

Looking for a great Tracking / Inventory spreadsheet to inventory and keep track of all my Bourbon collection?  Des anyone have a good  one?

cellartracker.com has a system for wine cellars that might work for you.  I haven't used it so I can't vouch for how good it is; I only used Cellartracker to look up and post wine reviews. 

[fishnbowljoe]

Being serious and not snarky, I made my own spreadsheet(s) using Microsoft Excel. That way I could have the number of columns that I wanted, and could also title them as I saw fit.

[Anwalt]

46 minutes ago, fishnbowljoe said:

Being serious and not snarky, I made my own spreadsheet(s) using Microsoft Excel. That way I could have the number of columns that I wanted, and could also title them as I saw fit.

 

Ditto.

[Alex Dryden]

15 hours ago, Anwalt said:

 

Ditto.

I have been using the one I made from excel as well - Just looking to see if there was a "Cooler looking" and one with more functionality that I have not thought of

[Anwalt]

49 minutes ago, Alex Dryden said:

I have been using the one I made from excel as well - Just looking to see if there was a "Cooler looking" and one with more functionality that I have not thought of

 

It was a fair question. 

 

I tried cellar tracker.  Works better for one.  Almost all of them are included in its reportoire.  Not so with liquor.  Also, in my case, I tend to have bourbon in a lot of different locations as people gather it for me.  XL is better that way.

[smokinjoe]

Paper and pencil has worked pretty well for centuries.  Or, if you want to get “cooler looking”, go with a leather bound journal and fountain pen!  
 

Your friend,

 

 

 

 

[apt43bear]

On 3/13/2023 at 10:21 AM, fosmith said:

cellartracker.com has a system for wine cellars that might work for you.  I haven't used it so I can't vouch for how good it is; I only used Cellartracker to look up and post wine reviews. 

This is what I use to keep track of all the liquor and wine I have.  Over the years, I've made it a habit to update as I buy and consume (remembering to mark as consumed is the hard part after a night of drinking haha).  I've been pretty diligent putting in my purchase price and store I purchased from too though so it's been pretty useful tool.  Suprisingly, alot of liquors and wines already have entries on there so you can just add from the existing database.  For some of the smaller releases/ store picks, you may have to input the data yourself though which isn't too bad.  You can also export your data into excel if you need it in a spreadsheet.

Edited March 15, 2023 by apt43bear

[flahute]

On 3/14/2023 at 4:38 AM, Anwalt said:

 

It was a fair question. 

 

I tried cellar tracker.  Works better for one.  Almost all of them are included in its reportoire.  Not so with liquor.  Also, in my case, I tend to have bourbon in a lot of different locations as people gather it for me.  XL is better that way.

Celler tracker allows you to sort by location. We do this with our wine so we know which rack to go to since we have several.

[Anwalt]

On 3/17/2023 at 4:11 PM, flahute said:

Celler tracker allows you to sort by location.

 

Hmmm. I'll have to revisit.  I missed that feature.  Tech incompetence is the likely explanation.

[mbroo5880i]

On 3/17/2023 at 4:11 PM, flahute said:

Celler tracker allows you to sort by location. We do this with our wine so we know which rack to go to since we have several.

 

I keep about 5 bottles of wine along with a couple of six packs for guests in the garage refrigerator.  Easier to track that way.  

 

I do occasionally scratch off the "born on" dates on the beer bottles to keep things fresh.    Maybe this should have been posted in the "Pro Tips" thread.

[Hiker Hawk]

Try the WhiskeyShelf app.  It allows you to scan the bottle barcode with your phone to add bottles to your inventory.