I have an Excel spreadsheet with... a growing number of tabs. First is overall Lip stuff, listing just color by product (lipstick, lipglass, chromeglass, etc.) Second is overall Eye stuff, listing just color by product (eyeshadow, powerpoints, glitter liners, etc.) Then there's a Face/Multipurpose page, with colors listed by products (blushes, CCBs, pearlizers, pigments, etc.)
Then there's the detail pages, of which I've only done 3 so far. The Eyeshadow Detail page lists the color name, finish, whether I have pan, pot, or both, collection name, size, and top type (flip or screw). The Lipstick detail has color name, finish, and collection name. The Lipglass/Lustreglass detail just has color name and collection.
There's also a page for postcards/promos, but I'm still looking into a better way to organize that.
This is a listing only of what I have, not the whole product line and what I have of it. I haven't marked limited or permanent, or discontinued, but I think that's pretty easy to figure out with printouts of the Specktra color stories pages.
Mare