If You Inventory Your Collection..........

.......how do you do it?

 

Log in or Sign up to hide this ad.

Excel.

 

google drive.... that way i can access it from anywhere as long as I have internet.

 

I have everything on excel sheets. I like the google drive idea though. Would be immensely helpful when I'm out and about looking at coins.

 

Excel is great. If I had to start today, that's what I would use. I started using Coin Elite many years ago and at this point it would be too much work to move it over.

The important thing is to start early. Even a ledger is better than nothing. Information will get lost as the collection grows. That information is really important when the day comes to sell.

 

I use Google Drive as well. I have as much as I can listed - all the info on the coin, plus purchase date, place, price, pedigree, past auction info, etc...

 

Stubby pencil

 

Excel with these headings:
Country, Catalog Letter (KM/Y), Cat #, Year, Mint, Value, Comments, Location, Case (2x2, loose, or slabbed). I then sort them and make my trade list from it.

 

I find Excel the easiest and neatest way to do it

 

Excel for me as well.........That reminds me........I've got to make a few more entries.

 

I'm sooo interested in this because I suck at it. Right now I just put stickers on the slabs and flips of raws with date and price paid but then it gets sticky when I buy large lots. I do keep all receipts for taxes too. I just did a ledger inventory though of all my slabbed coins which felt good. I was stunned at how quickly many drops of water were able to fill a swimming pool so to speak

 

Excel saved in a Gmail account or Dropbox also accomplishes this.

 

Coin Elite

 

Can you edit the file with your android phone, ipad, or windows laptop.... from anywhere?

 

Probably....but it's more difficult on a phone...but I am sure it can be done, I'm just not an expert. Had Excel for our Super Bowl Box Pool and just looked at it on the Galaxy S4 but updated it on the home PC.

 

Another Excel here. I have a Master, then a subset of those categories that I am working on that I email to myself and carry on a iPad. It makes the file size smaller and easier to work with.

 

Yup, Excel.

But instead of one big file, I think it's more manageable to have a bunch of smaller files ($1, Walkers, Franklins, 25c, 10c, etc).

 

That's how I do mine.

 

Or use the TABS feature on Excel to have them all on 1 file but separate.

 

For my U.S. coins and tokens it's Excel. For my ancients I learned how to make a database in Access and really love it. The more I learn the more I can do with it. It's a bit much for moderns because there are so few variables between any two coins.