Coin Records

Discussion in 'Coin Chat' started by Mike Drop, Apr 10, 2018.

  1. Mike Drop

    Mike Drop I don't expect you to get that reference.

    Do you guys inventory and keep a recordbook of your collection. If so, how?
    I dont have enough coins for that to be nessacary for me, just curious.
     
  2. Avatar

    Guest User Guest



    to hide this ad.
  3. CamaroDMD

    CamaroDMD Supporter! Supporter

    I use excel spreadsheets.
     
    serafino likes this.
  4. ken454

    ken454 Well-Known Member

    i use excel for all purchases, and coin manage deluxe for my collection...
     
  5. Mike Drop

    Mike Drop I don't expect you to get that reference.

    Can you explain what data you put in each cell, colluum or row?
     
  6. ken454

    ken454 Well-Known Member

    for my purchases i put coin year, coin type, description and/or my personal coin number, date purchased, quantity purchased, price paid per coin, total price for multiple coins, shipping fees, total cost, where or who purchased from and last column- personal notes...
     
    Mike Drop likes this.
  7. Mike Drop

    Mike Drop I don't expect you to get that reference.

    lot of info
     
  8. mynamespat

    mynamespat Dingus

    Learning to create spreadsheets is a super useful skill that can used in so many different fields. I highly suggest you play around with it and learn to make something simple. Then as you learn more your spreadsheet can become more advanced. Even if the spreadsheet is only 4 or 5 columns of data, it will be a great learning experience.
    As someone who is perpetually adding my old inventory to my computerized list, I can say for a fact the best time to start is when a collection is small. I'm at the point where it's easier to just sell some coins than it is to catalogue every single one.

    My spreadsheet is pretty darn complicated. It's about 6 or 7 different layers. I have a summary page, individual coin inventory page, group coin inventory page, sold individual coin page, sold group coin page, and a group purchase page. Each page has a column for: Country, Date, MM, denomination, catalogue ID, grade, grading company, purchase date, purchase price, purchased from, notes, sale date, sale price, and buyer. I like a lot information. :) However, even if you just start with the basic info (country of origin, date, mm, denomination), it will make it easier in the long run if you decide to make your sheet more complex. Good Luck!
     
    Stevearino, Nyatii and Mike Drop like this.
  9. ken454

    ken454 Well-Known Member

    yea, no reason for my kid to complain when he inherits my collection and the flash drive with all the info i keep updated, make it easier for him to liquidate it if he is so inclined..oh yea, and on each sheet is a separate tab for all bullion and i keep a separate spreadsheet for year of purchases
     
    Last edited: Apr 10, 2018
    Stevearino and Mike Drop like this.
  10. Mike Drop

    Mike Drop I don't expect you to get that reference.

    Oh I defintley know how to use a spreadsheet. Took a college course over Microsoft programs including Excel,Word, Powerpoint and Access. Just not sure how to implement one in a collection.
     
  11. Mike Drop

    Mike Drop I don't expect you to get that reference.

    Question- Do you record small value items such as 25 cent wheat pennies and such?
     
  12. Cherd

    Cherd Junior Member Supporter

    Maintaining my spreadsheet is a huge chunk of the enjoyment that I get out of collecting, it's almost embarrassingly complex.

    I have a few type collections going. I have tabs for each major category and columns for each coin containing general information (Name, denomination, varieties, etc), the KM#, example pictures of the obverse and reverse, a section with the grades within the ranges that I'm looking for along with PCGS, NGC, or book price guide values. In that section I also catalog all sales that I've been able to find in each grade color coded by sale type (Ebay auction, Buy it now, Best offer, other auction). Then I have the PCGS and NGC population report values for the top 3 grades. There's also a column where I include a picture of my coin after I've purchased that type.

    I then have a tab where I enter and tally the total prices that I paid for each coin.
     
    Mike Drop likes this.
  13. Mike Drop

    Mike Drop I don't expect you to get that reference.

    Whats KM#
     
  14. JPeace$

    JPeace$ Coinaholic

    I use excel. I keep date, mm, description, grade, grading service, serial number, date purchased, cost (including BP), s/h, where I purchased the coin. I have many sheets/tabs depending on series. Morgans (multiple sheets, it's complicated), Peace Dollars, US Gold, Type Set (Dansco 7070) and on and on.
     
    STU, Stevearino and Mike Drop like this.
  15. Santinidollar

    Santinidollar Supporter! Supporter

    I use a program called US Coin for MacIntosh. It can be had in the Apple App Store. Very logical and simple to use.

    I don’t know if they have a Windows version.
     
  16. ken454

    ken454 Well-Known Member

    i do, so i have an accurate total of what i've spent each year...
     
    Mike Drop likes this.
  17. Cherd

    Cherd Junior Member Supporter

    KM# is named after Krause and Mishler, they orginally authored the Standard Catalog of World Coins. They assigned the numbers to designate all the different types and varieties of world coins. KM# isn't all that useful for US coins, but I collect Mexican coins, where it can be pretty useful to know.
     
    Stevearino and Mike Drop like this.
  18. ken454

    ken454 Well-Known Member

    the number given to a coin in the Standard Catalog of World Coins by Krause-Mishler
     
    Mike Drop likes this.
  19. Mike Drop

    Mike Drop I don't expect you to get that reference.

    I consider that a waste of time becuase I would probably give it away and forget to change my excel sheet.
     
  20. Mike Drop

    Mike Drop I don't expect you to get that reference.

    You record any gift coins you didnt pay for?
     
  21. ken454

    ken454 Well-Known Member

    yes, as my son will still get those and have the info on them..
     
    Mike Drop likes this.
Draft saved Draft deleted

Share This Page