Even if your unit is not whole numbers, you can still use the Quantity field.
Know how the different product categories contribute to sales.Quickly see your top customers and suppliers.Easily understand the sales and purchase patterns (monthly and cumulative).Know if the sale orders can be fulfilled.Know current inventory levels of each product.Set custom re-order points for each product.Enter and manage up to 2000 different Products.Instead, Pivot tables are provided in separate sheets. This version does not have the slicer based Report sheet.
If you use Mac and Excel 2011 (or above version) – Retail Inventory Excel Template (Mac).Sample File with some sample Data for reference – Sample File – Retail Inventory Excel Template.
If you use Windows and Excel 2010 (or above version) – Retail Inventory Excel Template (Windows).
Also, you can quickly view the purchases/sales patterns over time and the best performing products.įor Retail businesses, a new version is availableRetail inventory Tracker (Free) For Manufacturing businesses, Manufacturing Inventory Tracker Excel Template (Free) For Rental businesses, Rental Inventory Tracker Excel Template (Free) FREE DOWNLOAD This retail inventory excel template will assist in knowing the inventory levels of each product and understanding which products to re-order.