| Author |
Replies: 29 / Views: 4,457 |
|
Valued Member
United States
420 Posts |
Hello,
I have this spreadsheet that is very elaborate for my coin inventory and it is getting tedious to keep up on so I was wondering how necessary an inventory really is? If your collection, regardless of size, gets stolen and you don't have some sort of inventory then what? I'd rather spend time showing off my coin pictures than plugging things into a spreadsheet, on the other hand that is just how my brain works. Any ideas?
Thanks, Rich
|
|
|
|
Pillar of the Community
United States
3076 Posts |
I guess the main point is, if you need to insure your collection against theft, and inventory with verifiable grading is required for some kind of claim settlement for the collections value......Pictures would be required, so not only your inventory list but pictures and established grading is a must, or one could simply make a list and turn it in......sounds like a trememdous amount of work to me......
|
|
Moderator
 Australia
16826 Posts |
I use my coin database primarily as a memory aid. I'm the forgetful type, and my collection is spread out over lots of albums, bags, boxes etc in various locations; my database not only lets me know whether or not I own a particular coin, and the condition, purchase price etc, but where it is so I can find it if I need to.
If you find you're spending lots of time entering all sorts of statistics for your coins that you rarely if ever need to know and if you did you could just as easily get them out of a book, then stop entering them.
Don't say "infinitely" when you mean "very"; otherwise, you'll have no word left when you want to talk about something really infinite. - C. S. Lewis
|
|
Moderator
 United States
6563 Posts |
 For a darkside collector it's Very easy to forget which coins we have from where and such. Also if I have doubles I have a nice easy access to my collection for trade possibilities.
|
|
Pillar of the Community
United States
921 Posts |
I keep a tracking spreadsheet of where I got a coin and how much I paid. Do most people here have additional insurance coverage for their collection? My current insurance company doesn't do additional coverage for coins.
|
|
Pillar of the Community
United States
2335 Posts |
I think it's important to point out that most homeowner/renter insurance policies DON"T cover coins. You have to purchase a rider to get coverage.
|
|
Pillar of the Community
United States
1745 Posts |
I started with a spreadsheet and migrated to a database. It helps me keep track of what I have and where it is. Each coin (or set) gets a serial number, grade, price paid, etc. It enables me to "see" my collection on paper to see if I have an extra, what I need, etc. For me, entering into a database and sorting is much easier using a DB than using a spreadsheet, especially as it gets larger.
I also send a copy to my insurance agent every once in awhile.
|
|
Moderator
 Australia
16826 Posts |
I also find my coin database very useful for supporting my coin clubs. Every meeting night they have a theme, like "bridges" or "birds" or "transport tokens", and members are encouraged to bring along a small display to match the topic. I can simply go to my database, type in the theme for the night's meeting, and let it do the searching for me. It's much less hassle than actually hunting through the albums, searching in vain for coins with bridges on them.
Of course, it only works if I've done the hard yards beforehand and entered in all the possible themes a coin could be used to support.
Don't say "infinitely" when you mean "very"; otherwise, you'll have no word left when you want to talk about something really infinite. - C. S. Lewis
|
|
Pillar of the Community
United States
6326 Posts |
Would anyone volunteer to do all of this work "for" me ? .....  I'm VERY unorganized with my collection....and have "no" database or program.......few pictures........no "list" of any kind....and have many "duplicates" as a result.....  So......I'd bring all of my coins home from the SDB's (one large one which is FULL....two medium sized one which are also FULL !) .....and then on a pre-arranged day.....you could arrive at the house.....go through all of my stuff......inventory it....organize it....put it in a "spreadsheet program".... and I'll feed ya Kansas City style ribs slow cooked ALL DAY LONG for your trouble !! ......(of course travel to and from my house for this "occasion" would need to be out of "your" pocket....because of current financial difficulties !......  ) ..........  .....  ..... Now.....I'll just sit back and wait for all of the offers and volunteers to "chime in" ! ......  ................  .................
|
|
Bedrock of the Community
United States
20753 Posts |
I UESD to keep an elaborate spreadsheet in Excel for coins. Then one day I noticed as I printed out all that stuff, it took up about an inch of paper and for what? I had all kinds of info that I really didn't care about anymore. Then too if it's for insurance purposes, they seldom believe you from just a pile of your records. You need receipts and photos and even then, the photos must be dated and even then you will only get a small proportion of what was stolen if they insured it at all. As for myself, I just gave up a long time ago as the collection grew way to much in quantity. For example to just record each Mercury dime would take me forever. I've got over 3,000 of those alone. Over 100 Whitman Albums. Documenting all that STUFF would take up all my time. NO, I'd just rather look at what I've got and ignor attempting to document it all.
|
|
Valued Member
United States
125 Posts |
The first thing you need to do is decide what kind of data you want to keep in a coin inventory. Personally I don't care who I bought a coin from or what price I paid. I collect coins that I like!! - Yes, I've been riped off a couple of time and I also had "hell of good deals". To keep my inventory, I'm putting them online at http://bills-stuff.net/ That way when I'm traveling, I can see what I have, what I need and what needs to be upgraded. I don't think there will be a problem finding an Internet connection. Time - yes tons of it.
|
|
Valued Member
 United States
420 Posts |
Hello, Sounds like most people keep something. My current spreadsheet is really a lot of stats. I put in the year of the coin, the mint mark, the coin description, when I bought it, who I bought it from, the current prices from several price guides and ebay, what I paid and whether or not I got a deal plus a notes column for any special notes or oddities. Does that sound like too much? I'm thinking of scaling it down to just the coin info itself (i.e. the stuff I can get off the coin.) My want list has all the price analysis info on it so I think I can get rid of that stuff, and once I get a coin home and know I haven't overpaid I'm happy. My want list helps make sure that I don't overpay. Here is my current problem I attended a couple of coin shows 3 or so months ago and bought some proof sets and commems and I didn't enter it in right away and can't remember what I paid or who I bought it from. That messes up my inventory if I'm keeping track of all of that. I'm not worried about theft because my collection isn't really worth a lot from a dollar point of view, from a sentimental point of view is another story. My homeowner's insurance only covers up to $2000 if my collection ever grows past that point then I'd be losing money in the long run if it ever got stolen. I also keep a pictorial inventory of all the coins I purchase. I know the dealers I buy from and I can always look up values and as I said as long as I know tat I didn't overpay for a coin I don't care what I paid for it 1 month or even several years later, especially because of situations like my problem mentioned above. Any further advice? Am I even on the right track? Rich
|
|
Pillar of the Community
United Kingdom
1682 Posts |
I think you need to do what works best for you and what the goal of the spreadsheet is.
I have several spreadsheets.
What I am looking for so I can quickly check common change for missing coins or on the forums here.
What I am looking for forum members that I am trading with, so I can fill their want lists.
What I have available for trade, so I don't promise something more than once.
What I have in a bit of detail, like mintage, amount of gold or silver, country, description, and comments. This could be useful, if in the future when I am not around, my family can ask you kind folks about the coins that I have, if they want to sell them. More detail is added for stuff that is not common change type coins.
Hope this makes some sense.
Ken
|
|
Pillar of the Community
United States
921 Posts |
You need to track your cost basis when/if you sell since it's taxable. ;-) I have to admit I was surprised my insurance company doesn't offer a rider for coins since they do for other types of personal property.
|
|
Valued Member
 United States
420 Posts |
|
|
Pillar of the Community
Philippines
1156 Posts |
the excel spreadsheet has helped me keep track of the coins I love to have and the direction to go for my collection. All the other unimportant coins, for me, they dont get listed at all
|
| |
Replies: 29 / Views: 4,457 |