I am a CT delinquent.

[Cris Whetstone]

Do you guys include tax and shipping in your price per bottle?

Maybe it’s subconscious denial of my spending, but I like to have a lower price/higher valuation...

I will usually add shipping costs because they can vary quite a bit. They can often be the difference between a purchase or not as I usually buy in smaller quantities.

[sdfruman]

Do you guys include tax and shipping in your price per bottle?

Maybe it’s subconscious denial of my spending, but I like to have a lower price/higher valuation...

I do because it is a significant cost component for me. Usually about $10 per bottle. I however do not think there is any consistency among CT users.

Same, but not consistent across users (and debate ensues). I do it to create parity between wines shipped to me (shipping but not always taxed) and local purchases (tax but no shipping).

I do it because I have friends who like to shop my inventory and that means I get the landed cost back. I started my cellar inventory today. Lots of time spent trying to organize and relocate bottles from the same producer together. It's going to be brutal.

[Dale Bowers]

I’m OCD about my CT. Will miss a few here and there. But, about once a month I use the location feature to give me the number of bottles that should be in a rack and inventory that way. Haven’t gone to barcoding just yet.

One thing I’m not OCD about is the exact location. I list the specific rack the bottle is in, but not the exact bin in that rack. How many people list the exact bin? For those that list the bin, do you have a numbering system?

"Exact location" for me is "somewhere in the cellar. I think. Maybe in one of those boxes over there I have been meaning to unpack since last June. Or maybe not."

Ha! I have a CellarTracker entry called “In box on floor”.

[Rich K0rz€nk0]

I’m OCD about my CT. Will miss a few here and there. But, about once a month I use the location feature to give me the number of bottles that should be in a rack and inventory that way. Haven’t gone to barcoding just yet.

One thing I’m not OCD about is the exact location. I list the specific rack the bottle is in, but not the exact bin in that rack. How many people list the exact bin? For those that list the bin, do you have a numbering system?

"Exact location" for me is "somewhere in the cellar. I think. Maybe in one of those boxes over there I have been meaning to unpack since last June. Or maybe not."

Ha! I have a CellarTracker entry called “In box on floor”.

Guilty

[JDavisRoby]

Do you guys include tax and shipping in your price per bottle?

Maybe it’s subconscious denial of my spending, but I like to have a lower price/higher valuation...

I do not just because I have some bottles that have no shipping because the broker is still storing them, some that have shipping to storage in another state and some that have shipping to Oklahoma. Same with tax. Although, one retailer in town adds the liquor tax to her shelf price and then charges only sales tax.

I consider the shipping and tax my tariff for collecting. If I sell bottles I just add back $10-$15 bucks for shipping and then go from there.

[Neal.Mollen]

I never include shipping and/or tax for the same reason some of you include it; it can vary so much. I suppose it depends on why you are collecting the data. If it is to have a record of landed price, I can see including it, but I can't think of how I would use that data. I am more interested in following what has happened to the price of a wine over time, and I can't do that if the price I kept is inclusive of the add-ons

[Mont Stern]

I am also in the delinquent group. Having to work with electronic medical records has made me come to detest all "busy work." My solution is that I bought a Dymo printer and bar code reader. I am paying one of my daughter's friends to bar code and organize my wine. She is about halfway through the task. I have been able to keep everything in my head pretty well but if something happens to me, I would be dumping a mess on my family.

[David Glasser]

I never include shipping and/or tax for the same reason some of you include it; it can vary so much. I suppose it depends on why you are collecting the data. If it is to have a record of landed price, I can see including it, but I can't think of how I would use that data. I am more interested in following what has happened to the price of a wine over time, and I can't do that if the price I kept is inclusive of the add-ons

This is my approach to recording price.

[dsimmons]

Anyone willing to share their bottle entering methodology (or habit)? I would do much better if didn’t seem so tedious.
One thing that would help me tremendously is if the vendors I purchase from would include a detailed packing list, showing price per bottle, shiiping, taxes imposed, etc.

Carlton,

Here is the steps I go through when entering wine in inventory. IN my case almost all of my bottles are purchased online and then received at a later date.

1 under the top drop down menu select "Wine"
2 enter the vintage and producer of the bottle(s) to be entered
3 select your purchase from the drop down list
4 in the wine screen that comes up look on the right side right above "tasting notes" and click "add to my cellar"
5 fill in the information requested on quantity, size, etc. You can leave some of these blank if you wish.
6 Hit Save and Done

The information you are looking for on the packing slip is normally included only on the invoice and almost never on the packing list.

Hope this helps.

[AndrewH]

^ I have found that wineries uniformly include the necessary information in their invoices, usually sent when the order is complete. Same thing for most stores, especially online (in store receipts are a bit less robust).

Biggest challenge for me is adding tax and shipping when I have to allocate across bottles.

[Mike Evans]

^ I have found that wineries uniformly include the necessary information in their invoices, usually sent when the order is complete. Same thing for most stores, especially online (in store receipts are a bit less robust).

Biggest challenge for me is adding tax and shipping when I have to allocate across bottles.

I allocate tax using the calculator function in the CT price field by multiplying the price times 1 plus the tax rate, so if the tax is 7.75%, I multiply price times 1.0775. I allocate shipping per bottle and use the same function to add it to the price.

[AndrewH]

^ I have found that wineries uniformly include the necessary information in their invoices, usually sent when the order is complete. Same thing for most stores, especially online (in store receipts are a bit less robust).

Biggest challenge for me is adding tax and shipping when I have to allocate across bottles.

I allocate tax using the calculator function in the CT price field by multiplying the price times 1 plus the tax rate, so if the tax is 7.75%, I multiply price times 1.0775. I allocate shipping per bottle and use the same function to add it to the price.

Yes, that's how I do it as well. Then allocate shipping, which is per bottle basis regardless of price. It's not a mathematical challenge, just a keystrokes challenge.

[Rich K0rz€nk0]

I never include shipping and/or tax for the same reason some of you include it; it can vary so much. I suppose it depends on why you are collecting the data. If it is to have a record of landed price, I can see including it, but I can't think of how I would use that data. I am more interested in following what has happened to the price of a wine over time, and I can't do that if the price I kept is inclusive of the add-ons

This is my approach to recording price.

That

I want to track the price of a wine exclusive of the other variables.