I use excel. My columns/fields are:
+ Total collection count
+ Series (e.g. G1 1984, Transformers Prime etc.)
+ Toy name
+ Function
+ Sub Group/Class
+ Notes -- this is where I may mention what peripheral figures are included, e.g. Nebulans, Action Master Partners, if it's exclusive or whatever doesn't fit in other fields
+ Condition
+ Series count; so this will let me instantly know how many say Beast Machines Transformers I have.
I find the Excel formula useful as it automatically updates counts as I add new toys, all I have to do is copy-paste the formula from the cell above.