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.
I am a CT delinquent.
- Cris Whetstone
- GCC Member
- Posts: 11291
- Joined: January 27th, 2009, 1:09 pm
- Location: OC, CA
- Has thanked: 29 times
- Been thanked: 34 times
Re: I am a CT delinquent.
WetRock
"Man prefers to believe what he prefers to be true." - Francis Bacon
"I had taken two finger-bowls of champagne and the scene had changed before my eyes into something significant, elemental, and profound." - F. Scott Fitzgerald, The Great Gatsby
"Man prefers to believe what he prefers to be true." - Francis Bacon
"I had taken two finger-bowls of champagne and the scene had changed before my eyes into something significant, elemental, and profound." - F. Scott Fitzgerald, The Great Gatsby
- sdfruman
- BerserkerDay All-Pro
- Posts: 541
- Joined: February 4th, 2011, 1:59 pm
- Location: Waiting in Manassas
- Has thanked: 2 times
- Been thanked: 1 time
- Contact:
Re: I am a CT delinquent.
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.AndrewH wrote: ↑January 29th, 2019, 4:59 pmSame, 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).
![soap [soap.gif]](./images/smilies/soap.gif)
Sheila
“There comes a time in every woman's life when the only thing that helps is a glass of champagne.”
― Bette Davis
“There comes a time in every woman's life when the only thing that helps is a glass of champagne.”
― Bette Davis
- Dale Bowers
- Monopole Crü
- Posts: 4052
- Joined: April 27th, 2010, 9:44 pm
- Location: Boulder, Colorado
- Has thanked: 1 time
- Been thanked: 7 times
Re: I am a CT delinquent.
Ha! I have a CellarTracker entry called “In box on floor”.Neal.Mollen wrote: ↑January 22nd, 2019, 10:05 am"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."JDavisRoby wrote: ↑January 22nd, 2019, 8:12 am 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?
Cheers!
- Rich K0rz€nk0
- Monopole Crü
- Posts: 1325
- Joined: January 27th, 2009, 5:41 pm
- Location: Charlotte, NC
- Has thanked: 26 times
- Been thanked: 25 times
Re: I am a CT delinquent.
GuiltyDale Bowers wrote: ↑January 29th, 2019, 7:14 pmHa! I have a CellarTracker entry called “In box on floor”.Neal.Mollen wrote: ↑January 22nd, 2019, 10:05 am"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."JDavisRoby wrote: ↑January 22nd, 2019, 8:12 am 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?
Time Person of the Year - 2006
- JDavisRoby
- Monopole Crü
- Posts: 1423
- Joined: June 19th, 2018, 12:42 pm
- Location: Oklahoma
- Has thanked: 95 times
- Been thanked: 23 times
- Contact:
Re: I am a CT delinquent.
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.
Joshu@
- Neal.Mollen
- GCC Member
- Posts: 39900
- Joined: January 30th, 2009, 1:26 pm
- Has thanked: 14 times
- Been thanked: 13 times
Re: I am a CT delinquent.
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
I don't have to speak; she defends me
A drunkard's dream if I ever did see one
A drunkard's dream if I ever did see one
- Mont Stern
- Monopole Crü
- Posts: 777
- Joined: January 28th, 2009, 10:32 am
- Location: East Amherst, NY
- Has thanked: 43 times
- Been thanked: 5 times
Re: I am a CT delinquent.
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
- GCC Member
- Posts: 7968
- Joined: August 16th, 2009, 6:03 pm
- Location: Maryland
- Has thanked: 4 times
- Been thanked: 13 times
Re: I am a CT delinquent.
This is my approach to recording price.Neal.Mollen wrote: ↑January 30th, 2019, 6:31 am 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
- dsimmons
- GCC Member
- Posts: 874
- Joined: January 7th, 2017, 11:51 am
- Location: Anchorage, AK and Rockport, TX
- Has thanked: 1 time
- Been thanked: 3 times
Re: I am a CT delinquent.
Carlton,Carlton McCrindle wrote: ↑January 29th, 2019, 3:06 pm 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.
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.
D o n
Re: I am a CT delinquent.
^ 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.
Biggest challenge for me is adding tax and shipping when I have to allocate across bottles.
Andrew H e i m e r t
-
- Monopole Crü
- Posts: 3544
- Joined: January 30th, 2012, 9:22 am
- Location: Atlanta, GA
- Has thanked: 22 times
- Been thanked: 21 times
Re: I am a CT delinquent.
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 wrote: ↑January 30th, 2019, 2:33 pm ^ 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.
Re: I am a CT delinquent.
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.Mike Evans wrote: ↑January 31st, 2019, 6:13 amI 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 wrote: ↑January 30th, 2019, 2:33 pm ^ 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.
Andrew H e i m e r t
- Rich K0rz€nk0
- Monopole Crü
- Posts: 1325
- Joined: January 27th, 2009, 5:41 pm
- Location: Charlotte, NC
- Has thanked: 26 times
- Been thanked: 25 times
Re: I am a CT delinquent.
David Glasser wrote: ↑January 30th, 2019, 9:55 amThis is my approach to recording price.Neal.Mollen wrote: ↑January 30th, 2019, 6:31 am 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
That
I want to track the price of a wine exclusive of the other variables.
Time Person of the Year - 2006