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.
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...
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!
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
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.
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.
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.
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.
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.
I consider that a waste of time becuase I would probably give it away and forget to change my excel sheet.
