Not only does an inventory list track physical counts but, at a higher level, it helps businesses make informed decisions about purchasing, production and sales. Maintaining accurate inventory lists is important for income tax reporting because businesses need to record their end-of-year inventory correctly in order to file taxes.Īn inventory list helps a company stay on top, and in control, of every item it has available.Inventory management tools and automation help improve accuracy, stock control and profitability, compared to manual methods.An inventory list includes item details, such as the SKU, name, description, unit cost and quantity.An inventory list is an important tool for tracking inventory performance and turnover, as well as for demand forecasting. It typically includes each item’s SKU number, name, description, unit cost, quantity in stock and reorder point. What Is an Inventory List?Īn inventory list provides an organized summary of every product a business has in stock, such as raw materials, components, works in progress and finished goods. Like so many other business processes that benefit from real-time data and automation, so, too, do the activities associated with managing and maintaining inventory lists. An inventory list also advises when to replenish products, when products are hanging around too long and other factors that can affect the company’s carrying costs and overall financials. If you don’t own Excel, you can always use either Google Docs or OpenOffice Calc (it’s free and works really well).East, Nordics and Other Regions (opens in new tab)Īny business that holds inventory can understand the challenge of keeping track of the goods it has in stock - and the more items it stocks, the harder that can be without an inventory list that details what the company has in its possession. It has some presets for colour family and finishes to help build your cosmetics inventory. Go to File, then “Download as” to save it onto your computer, save it as Microsoft Excel.Įdit: I’ve added a tab in the file called “READ ME” which details 2 ways to save a copy of this template so you can edit it. If you want to start keeping one yourself, I’ve created a Google Docs spreadsheet template for you to use: Download it here Please read: I’ve never met anyone in real life who keeps one but I have read on makeup forums that there are others out there like me. So there you have it, my cosmetics spreadsheet. I could further filter by brand or by finish, say, if I wanted to find only red Illamasquas in cream finish (I’ve got 3!) For instance, I can filter by the colour family “red” to see only the red nail polishes I own. The spreadsheet has evolved over the years – I’ve added a column for colour family and finish to help me filter by attributes more easily. Sometimes I repurchase old forgotten favourites this way. I like to track skincare items that I’ve tried and used up, and write comments about the active ingredients and how I liked the product. I also colour code the lines for easy at-a-glance differentiation. In addition to tracking products I currently own, I also use the spreadsheet to track products I have owned and finished or purged, as well as a wishlist – the “Status” column on the right hand side is as follows: o = own, g = gone, f = future purchase (aka wishlist). I like to write notes on what store I bought the item, what collection it’s from, or some comments about its performance so it’s easy to refer to later on. It’s nothing revolutionary, it’s just a database to store information including the brand, item name, official colour name, date item was acquired, weight or volume of product. (Click on any image in this post to enlarge) Some of the items have no dates because I got them so long ago. But I had to essentially do a full inventory of my stash to build the spreadsheet – item by item, line by line. If I had created the spreadsheet from the inception of my first beauty product purchase, it would have been a breeze. The initial set up of the spreadsheet was a daunting task. At the time, it was primarily a way to track my growing nail polish collection so that I didn’t duplicate any of my Essie shades (at present count, I own 73 bottles of Essies – it is my favourite nail polish formula).Įventually I expanded the spreadsheet to include the following tabs: I created my cosmetics spreadsheet on Sunday J(as revealed by the Excel file properties). There’s curiosity about my cosmetics inventory spreadsheet so I thought I would devote an entry on how it came to be.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |