So I wanted to do a post on how I keep track of my make-up. What I own, what I've purchased and am waiting to be delivered, etc. It really helps me keep track of everything so I don't double-purchase and of course for insurance purposes. If anything was to happen to your make-up, having an "inventory" list as I like to call it, will help you with your insurance claims.
I use Excel for mine, however I'm sure there are many other ways you can do this, I just find Excel the easiest. I have 7 pages and everything is divided into product type. Eyeshadow, Blush, Lips, Misc. (all other face stuff), Palettes, Brushes and Nail Polishes. I then break it down into colours. From there, I give the name of the product, the brand, item description, finish, collection and RRP.
Something to note: If I have purchased back-ups of products, I put them in the spreadsheet as well. For instance I own 3 of the Forever Marilyn Beauty Powders that MAC released with the Marilyn Monroe collection in October 2012, so I've put that in three times. If I use something up, it gets removed.
You also may notice the red text. I use red text on items I have ordered or are being CP'd for me. They'll be changed to black once I have received them and I know they're here. If for whatever reason I don't get them, they stay red until I can re-purchase or I delete the item if it's something that is Limited Edition and I won't be able to get.
I also total the price up at the bottom of each page.
For reference, the A-F columns are a width of 26.71, I find this gives a decent enough space for typing everything I need. Everything is also aligned in the middle.
I have taken screenshots of my 7 pages to show you, so hopefully you can get a rough idea!
Forewarning, I do own a lot of MAC. I am working on expanding my collection outside of MAC, but I will admit it is my current favourite brand so that is what I have the most of. Keep in mind you also can't see everything on every page. I plan on making some Inglot purchases soon, so I can't wait to add them to my collection!
All images are clickable to make them larger so you can read them better!
As you can see, everything is easily able to be seen and I can check what I have before buying something online very easily.
I hope this is helpful to some of you. If you have any questions please don't hesitate to ask.
How do you keep track of your purchases and collection? Please let me know in the comments!