As I have been more seriously ramping back up into collecting (and am getting older
) I have realized that I can no longer solely rely on my memory to keep track of what I have in my collection and what I need. With 90% of my collection still boxed up in storage, I've realized that I have accidentally purchased some unintended doubles lately, luckily it hasn't been anything expensive or that I can't use for custom fodder, but I'd still rather not do that if I can help it.
I decided it is time to really do a full inventory and create some sort of spreadsheet/catalog for myself to make it easier to keep track of all this stuff I have. I've been using Jeff's checklists here on JD and various other image databases and checklists to make my spreadsheet. So far I have just made it through The Vintage Collection basic figures and exclusives. I have been trying to include all loose and carded variations, repack/repaint/retool notes on each release, etc. My plan is to repeat this for each of the main Hasbro lines, and then do a more limited version for all of the other non Hasbro and non-SW lines that I collect.
This is something I figure will take awhile to really complete but I think it is really going to help me. Aside from just buying doubles the other motivation for me is somewhat estate-planning and insurance based. If something were to happen to me, I'd hate for my wife to get stuck with my collection and have no idea what to do with it. I'd want her (or whomever ends up with this stuff one day) to have a full list of items, quantities, and approximate values to be able to decide how to sell it all or what to keep.
My wife works in art restoration and deals frequently with insurance loses after fires and floods. Most homeowners tend to get screwed on their art or other home items because insurance companies require that you list everything you owned from memory after a total loss in a fire or flood. Homeowners that have everything cataloged tend to get the most money back in an insurance loss and have the most things covered. Collectibles are often
NOT covered in a home insurance policy, I know my insurance unfortunately doesn't cover it, but that is another topic altogether.
I have a few questions, has anyone built out a spreadsheet or catalog of your own? What kind of organizational strategies did you use (or wish you had used)? Do you find it helpful to managing your purchases/preorders/trades/etc, or is it too burdensome to keep up with?