Wargame Collection Management... How do you track your toys?

[warlord frod]

My collection is in various plastic bead boxes and small tubes. I have labeled each box and using word I have made detailed list of each boxes contents. These lists enable me to find things quickly and after I have finished gaming I put them back in the appropriate box. A large portion of my collection are for games like Mage Knight, Star Wars miniatures and Hero clixs so this system helps me know what to buy as I continue to complete my collection. My Historical and Fantasy/Since fiction collections are organized by period (ACW, Ancients, WW II, WH 40K, Epic 40K, etc) Again I have made a general note on each boxes contents and keep my lists in a binder so that I can find things quickly and keep them organized when putting them away. The organization process took a couple of years to get done but has been worth it. If I had it to do over again however I think I would have done this on excel spread sheets.

[Easy E]

I don't bother. 

I keep the painted ones in unique cases or on the shelf so they are easy to see/find.  Unpainted tend to stay in the box until their time comes. 

I really do not have a backlog of unpainted, and purchase as I go to avoid one. 

[fusilierdan]

I have an Excel file for my inventory. There's a sheet for each period, not all are filled in yet.
the headers are, Unit Name, # of Figures, # of Bases, Type, Army, Manufacturer, Item #   , Painted, Unpainted, Cost, Total, Value, Total figures.

Not as detailed as the OPs and a little disjointed but works for what I need. At least if my heirs find it will give them an idea of what's what and how much it's worth.

[Tactalvanic]

Thats given me something to think on. its certainly inline with capabilities.

But really does sound to much like my day job/work  .

But damn it would be a good idea