andytv
  • andytv
  • Herf-A-Holic Topic Starter
Monday, March 21, 2005 5:18:00 AM
I spent a couple days getting my inventory list together, and now I am committed to keep it accurate. I began to think about the best way to do this and fooled with creating a database, etc for a little while this morning.

Then I glanced over at my software shelf and noticed our old version of quickbooks.

Anybody use anything like this for cigar inventory???

I figure I can enter cigars as stock; issue them out to smoke, or issue then to "orders" for trades.

I know QB may be overkill, but it is readily available and old versions are cheap.

thoughts???

Schmitty22
Monday, March 21, 2005 5:31:00 AM
seek professional help NOW!
MSR
  • MSR
  • Enthusiast
Monday, March 21, 2005 5:37:00 AM
andytv, I have a custom access db that I've created to do just what you are looking for. Send me a note at mrees5 at ford dot com and I'll send you a copy to look at.

Mark in GPWoods.

BLISTER
Monday, March 21, 2005 5:37:00 AM
I usually do one potato, two potato, three potato, four.

My method also lets me uncover forgotten treasures from years past.

sneech
Monday, March 21, 2005 5:37:00 AM
I started one with Excel but lost interest in my layout.

I've got some new ideas that I'd like to try when I get some time, all using Excel.

With excel I'll probably have a general inventory page, maybe link the cigars to another page dedicated to my reviews. Page for trade contacts. Maybe something to track my bids.

drnos
Monday, March 21, 2005 5:38:00 AM
Interesting idea. For a simple database in-n-out program I would first think of MS Access, or Borland Paradox, or even MS Excel (even tho it's a spreadsheet, it's the world's most widely-used database manager).

I use QB quite a lot, and tho I haven't looked at the inventory fields and reports with a specific view of a cigar DB, my first impression is that you would find the inventory reports to be rather inflexible. I generally like Peachtree better for their more flexible report formats. While either of these G/L programs may work, neither is really set up to be a DB mgr.

John hay Cigars
Monday, March 21, 2005 5:39:00 AM
Andy, thats what we use for our cigar inventory. Works great. Any questions about it...."ping- cbidwidow". She takes care of all that.
andytv
  • andytv
  • Herf-A-Holic Topic Starter
Monday, March 21, 2005 5:42:00 AM
I have been using excel, and have a really great access database that a BOTL has sent me in the past.

BUT.....

If you are involved in trading and want to keep track of things, you almost have to operate as if you were a cigar shop. Also. I believ that newer versions of QB may interface with UPS/USPS and print labels, etc.

We'll see. If I can find a "cheap" version; I'll give it a shot.

SteveS
Monday, March 21, 2005 5:48:00 AM
If someone were to tell me that having such an inventory would be a good idea to document a potential insurance claim (ie house and all contents swept away in a tornado), I could understand why someone might want to maintain an inventory of their "stash" ...

But even if one of you were to come by the house and present me with a computerized up-to-date listing of all my cigars, it'd be out of whack within a week ... there's not a snowballs chance in hell I'd credit the books with every cigar I bought and debit them for ever one I smoked ...

And, if such an inventory ISN'T for something like insurance, what on earth would you WANT one for ?????

andytv
  • andytv
  • Herf-A-Holic Topic Starter
Monday, March 21, 2005 5:51:00 AM
MSR,

I have your database; it is a fine database and I have used it.

What I want to do though is create "shipments" and log receipts; and then track all of this financially.

andytv
  • andytv
  • Herf-A-Holic Topic Starter
Monday, March 21, 2005 5:54:00 AM
SteveS,

I get on these kicks. You are probably right, but it is part of my personality to put a ton of work into something and then abandon it or destroy it.

Plus it will give customs some nice professional evidence when they search my abode.

stogiepa
Monday, March 21, 2005 5:58:00 AM
Andy~

You really need to get a life....LMAO

stogiepa

Goody
Monday, March 21, 2005 6:12:00 AM
Actually Steve,

You debit inventory when you buy and credit inventory when you smoke. LOL.

Heck I don't have enough time to smoke there is no way I am going to spend the kind of time it would take to do inventory (I gave up after a few hours with the exact same thoughts as Steve....why the heck am I doing this?)

Goody

John hay Cigars
Monday, March 21, 2005 6:22:00 AM
Andy, QB sounds like what you want. It will keep track of what you send to whom and and their address and automatically keep track of your inventory. I wish you luck though. Is still have trouble with anything that is not shipped. You could even input what you receive and their address. Makes a nice automatic address book.
mrtelcom
Monday, March 21, 2005 6:51:00 AM
Someone posted links to a couple programs a year or two ago. I'm too lazy to search for you.
cjmkcm
Monday, March 21, 2005 7:12:00 AM
I can picture the XL spreadsheet. Columns across titled Igloo, Coleman. Rows titled, downstairs closet, guest room by window.........

cigarbidwidow
Monday, March 21, 2005 11:13:00 AM
Andy, as JHC said we use Quick Books for our business. I do have the newest version. It works very well but for the inventory to PROPERLY work, you have to be very diligent in your record keeping. When hubby smokes one or sends a few freebies out, sometimes he doesn't always tell me. That completely screws it up. I have pretty much decided that it isn't worth trying to be perfect. Way too stressful.

Also, since we only have 6 varieties, it was pretty easy to input the info. You are talking lots of different kinds. That could take many hours to input. Personally, unless you need to track it for orders, I think QB would be way beyond what you need.

It does have an ok way to track addresses but Excel is much better for using as a database. It also has the shipping capability but I never use it. I go directly to USPS or UPS websites to ship.

Good luck. You can always email us at johnhaycigars at aol dot com if you would like further info.

Lauren

John hay Cigars
Monday, March 21, 2005 11:32:00 AM
Sorrry. But you really need to keep track of how many I smoke and give away....second thought, forget I said that.
andytv
  • andytv
  • Herf-A-Holic Topic Starter
Monday, March 21, 2005 12:09:00 PM
I'll screw around with it later this week. I know it's WAY more than I need, but hey....its free! thanks for your help guys.

Andy

jlambert
Monday, March 21, 2005 9:40:00 PM