Starting Some Serious Inventory

Discussion in 'Coin Chat' started by Inspector43, Jan 6, 2025.

  1. KBBPLL

    KBBPLL Well-Known Member

    I won't ever inventory all of mine either. Some of the coins I inherited 50+ years ago just aren't worth the effort, and whoever's lap they end up in can have fun looking them up (world coins). I buy so few new coins that I photograph each one upon arrival and put the images and invoice into a separate folder under "coins" on my laptop and backup drive. If I get run over by a Loomis truck someone would have to poke through all those folders, but at least it's there. For a guy who used to architect and code entire enterprise databases, it's pretty stupid that I never did something like that for my coins, but work was work and fun was not work.
     
    Inspector43 likes this.
  2. Avatar

    Guest User Guest



    to hide this ad.
  3. geekpryde

    geekpryde Husband and Father Moderator

    I use Excel and update the spreadsheet after every purchase or sale. Much easier to do at one coin at a time. I can't even imagine having a large collection without having an inventory system.

    Knowing exactly what you have and being able to look up information and cross reference is vital do the way that I enjoy the hobby. And having this inventory systems makes posting about your coins or sharing photos so much easier. If I want to know every half dollar I've owned and the years they were purchased and their average value, it's just a few clicks for me. If I want to rename a bunch of photos, there's no hand typing involved. I just form a new string as a column on the inventory system based on existing data fields and all the new file names populate for every coin. These are just two simple examples but you get the idea.

    Even if you didn't care about all that, it'd be nice for insurance purposes to have an actual list of what you own. I doubt many people could from memory create an inventory of all their coins that were lost in a fire for instance, or that were stolen in a robbery.

    I'm far too neurotic to not document every purchase in minute detail. To each their own.
     
    Last edited: Jan 6, 2025
  4. Collecting Nut

    Collecting Nut Borderline Hoarder

    Sounds like it but I’m still finding them.
     
    Inspector43 and -jeffB like this.
  5. Hambone1946

    Hambone1946 Well-Known Member

    According to my coin database, I have 9054 coins in there. Seems like a lot.
     
    Eric Babula and Inspector43 like this.
  6. Inspector43

    Inspector43 More than 75 Years Active Collecting Supporter

    My general coin inventory is very simple. From 1900 to 2018 (when I quit adding new issues to my collection) I am missing 4 Wheat Cents, 2 Barber Quarters and 7 Standing Liberty Quarters. The ASE collection has so many different variations that I had to do an inventory.
     
  7. medoraman

    medoraman Supporter! Supporter

    I hear you man, but sometimes you just get busy. I usually open it up, but many times nowadays do not have time to attribute group lots. I am getting lazy and just putting the whole bag into a box and into the SDB. I just did that the other day, had about 80 REALLY NICE duel head bronzes from NN I had bought, (really, smooth flan, gVF or higher all of them), and simply threw them in a cardboard 2x2 box and into the SDB. I tell myself I will sort and attribute when I am retired, but I literally have thousands of such coins like this now. Not sure if I ever will.
     
    Inspector43 and Eric Babula like this.
  8. Jersey magic man

    Jersey magic man Supporter! Supporter

    Doe most homeowners insurance policies cover coins? Or do you need a separate rider for coverage?
     
  9. okbustchaser

    okbustchaser I may be old but I still appreciate a pretty bust Supporter

    Most home owner policies only cover coins for face value (at most bullion value). A rider is needed--or, IMO, better yet, a separate policy issued from a company that specializes in insuring collectables such as Hugh Woods.
     
    medoraman, Dimedude2 and ldhair like this.
  10. -jeffB

    -jeffB Greshams LEO Supporter

    I think ours has some ridiculously low limit for claims on coins/precious metals/jewelry. Beyond that, you need a rider, and IIRC they're very expensive (multiple % of total insured value per year).
     
    KBBPLL likes this.
  11. ldhair

    ldhair Clean Supporter

    Hugh Wood is the best option in my opinion. They make it really easy and are trusted by many in this hobby.
     
    Dimedude2, geekpryde and -jeffB like this.
  12. geekpryde

    geekpryde Husband and Father Moderator

    +1
     
    ldhair likes this.
  13. rte

    rte Well-Known Member

    Any sort of a list would make me accountable for my gathering :p let's not go there :D
     
    Eric Babula likes this.
  14. samclemens3991

    samclemens3991 Well-Known Member

    I guess I am t upload_2025-1-8_7-32-41.jpeg he old school
     
  15. Inspector43

    Inspector43 More than 75 Years Active Collecting Supporter

    Wow! Time takes over and we realize what we have accumulated.
     
    SensibleSal66 and Eric Babula like this.
  16. Eric Babula

    Eric Babula Well-Known Member

    I take it you didn't capture ALL of your coins in your data base, individually, did you? I mean, I probably have half that many in Wheaties that I saved up over the years. I'm not going to catalog all of those! And, how do you handle rolls of coins (e.g. I bought three rolls of the Washington Dollars when they came out in 2007. I also have rolls of Mercury Dimes, Franklin Halfs, WLHs.

    Gonna have to figure out how to catalog stuff like that.

    I'm just starting my inventory as well (I'm cheating and using a program called Exact Change, rather than creating my own database). Finally getting "A Round Tuit"! I have exactly 51 coins input, so far! Long, loooong way to go! And, that's just inputting them (Date, MM, grading company, grade, date purchased, buy price, date sold, sell price, where it's stored, slab number, notes). And, I haven't started imaging any of them. It's a lot of work!
     
    medoraman and Inspector43 like this.
  17. medoraman

    medoraman Supporter! Supporter

    Yeah, its an entire retirement project for me if I get around to it.

    I am like you, having individual coins but then having bags, boxes, rolls, etc of others. For my US I have bags and bags of buffalo nickels, wheat cents, etc. For ancients I have bags of different things above and beyond individual coins. This does not even count things like junk silver, etc. Then there are world coins, mostly in bags. Just lots of "stuff", which is why I am getting leery of buying things with boxes or slabbed anymore. Too much space. I am a hoarder, but concentrate on coins to minimize space concerns, but boxes and slabs accentuate the space issue.

    I think my retirement will start with the boxed, better coins and ignore the rest. The rest to me are just "hobby junk" really.
     
    -jeffB and Inspector43 like this.
  18. Eric Babula

    Eric Babula Well-Known Member

    I think I'm planning on getting rid of a lot of my "hobby junk" - sell it and use the proceeds to get individual coins that I really appreciate.
     
  19. Hambone1946

    Hambone1946 Well-Known Member

    My coin program has places for rolls and groups of coins but the database is 99.9 percent individual coins.
    I have been adding to this program (Coin Elite) for close to 40 years now.
     
    Eric Babula and Inspector43 like this.
  20. Dimedude2

    Dimedude2 Member

    I need to update the Excel file today, thanks for reminding me.
     
    Eric Babula likes this.
  21. LakeEffect

    LakeEffect Average Circulated

    I collect mostly mid-grade stuff that's all over the map, so I realized a long time ago I needed to create a spreadsheet (OpenOffice for me) because there's no way I was going to remember it otherwise :). Plus I'm a nerd.

    Screenshot 2025-01-10 084557.jpg
     
    Eric Babula and Inspector43 like this.
Draft saved Draft deleted

Share This Page