How Do You Keep Track Of Your Collection?

For me I keep an excel database. At present I find it fustrating as I am constantly downsizing my collection so I can buy some nicer coins.

Mind you once the project is complete I will be happy with my database. Then I might take Lim's advice and add photos.

I use a legal pad and pen. Keep purchase price, date, seller, sellers est grade (if given) Have a separate checklist for coins I'm actively collecting (Frankies, washies, and Walkers) where I keep all date/mm combos and check em off, with multiples listed with an abbrev to id seller.
Link to prior threads on this topic (to have them ion one spot): http://www.coincommunity.com/forum/...OPIC_ID=2159

http://www.coincommunity.com/forum/...OPIC_ID=2014

http://www.coincommunity.com/forum/...&TOPIC_ID=34

http://www.coincommunity.com/forum/...OPIC_ID=2572

Don

All I do is use a microsoft word document to record what coins I have, sorted by country and I keep a coin total at the end of the document, 120 so far but I have not got around to include my Australian 1c and 2c coins, my newest stuff and the Turkish coins.

quote:

---

Originally posted by bm1947

I use a Microsoft Excel spreadsheet originally set up by bigfella. This has been modified to suit my needs. I keep one for coins and another for notes with totals for each.

---

Any one wanting a copy of this spreadsheet it is on my website. FREE It is located at the top of the LINKS page

Note: the prices are from the 2005 Maccas- I only update the prices on the site every two years.

If you need a specific current price-
feel free to email me.

I see everyone has an inventory problem. Back in the days When we had MS DOS- I spent at least a couple years doing inventory and finally had a complete inventory except for a couple boxes of foreign.However. if you ever get burglarized as I have been-(twice) then you will need an inventory for the police-Fortunately for me- the police made an 85% recovery of what had been taken out of one of my safes-(the one that could be carried out) I had a huge Indiana safe in my garage but a sledge hammer would not open it. They thieves had thrown the safe in the Tuoloumne River near where we lived. Some of you may know Insurance adjusters are real picky- you must be able to prove what was taken- in order to get compensated-and this usually never happens. Afer MS-Dos like all of you, I had to start over again. So for a long time now, I have been using my Sony digital-I take one category at a time- Say My Conder tokens and photo them- they are in the white 2x2's and placed in a 2x2 coin box(es)on the photo I name them and place them in a folder on my desk top (Keeping the labeled disk) In my master folder (Dewey's Coins) I have many other folders named with each category, types etc inside this master folder. Ancient, Great Britain,VIctoria Major types etc;, With thousands of a 50 year accumulation, I will never be able to get in complete but you can at least have a pictorial inventory for your most treasured items. From what I have just read on all of you with this same problem, we seem to be a bunch of gluttonous additics. We have a disease which I call COINITIS. However, We need not let it frustrate us too much if we remember this-- The best thing about the future is that it comes one day at a time. habiru001-- call me Dewey

I use a program called "coin manage" it works very well even though my version is a older version, but it tells you the value of the coins,date purchased,what you paid,and so on. I found it was alot easier to keep up with than the paper and pen I started out with. you can download a trial version of it at libertystreet.com

LOL renal, aren't we all.....