Inventory management

Discussion in 'Coin Chat' started by Patrick M, Oct 3, 2019.

  1. Patrick M

    Patrick M Razor edge MD

    What are you guys using to manage your coins and currency inventory? I'm using my own custom made spreadsheets in excel but as my collection is growing and sometimes I'm selling stuff it become hard to keep track. I was wondering if you guys use some specific software or something like that to make it easier.
     
  2. Avatar

    Guest User Guest



    to hide this ad.
  3. Islander80-83

    Islander80-83 Well-Known Member

  4. Patrick M

    Patrick M Razor edge MD

  5. kanga

    kanga 65 Year Collector

    I like Excel since I can tailor the content to suit my tastes.
    I even learned to insert links to coin images stored on my computer.
     
    Patrick M likes this.
  6. JickyD

    JickyD Active Member

    Excel. I have a worksheet for each denomination, with each year being a row having a column for quantities & price for 5 grades, AG, G, F, EF, and UNC. A couple times a year I update my price list using CoinStudy. They don't give a price for AG, so I just use half the cost of Good unless that falls below the bullion value, then I use that. I have the spot price of silver in one cell in the workbook that all the worksheets pull from to summarize the silver value in my collection.
     
    Patrick M likes this.
  7. Patrick M

    Patrick M Razor edge MD

    Excel is good because you can customize everything but when you have like 500 items it becomes kind of cluttered and things are hard of find and keep track when something is sold or given away...maybe it's just me...even thou I know how to use the find button :)
     
  8. -jeffB

    -jeffB Greshams LEO Supporter

    Polyethylene and cardboard.

    Bags and boxes.

    And I'm not sure what the SDB is made of, probably steel. But that's a higher-level organizational tool; within the SDB, it's still plastic bags.
     
  9. LakeEffect

    LakeEffect Average Circulated

    I like Excel, here's a screen shot of what I dreamed up.

    CoinSheet.JPG
     
    Paul_62, Patrick M and micbraun like this.
  10. Collecting Nut

    Collecting Nut Borderline Hoarder

    I have my own Excel spreadsheets which I tailored to my needs.
     
    Patrick M likes this.
  11. micbraun

    micbraun coindiccted

    This. I spend a lot of time keeping it accurate. I usually add links to web sites describing types and varieties and also to NGC’s coin explorer, price guide etc.
     
    Patrick M and LakeEffect like this.
  12. ldhair

    ldhair Clean Supporter

    Patrick M likes this.
Draft saved Draft deleted

Share This Page