How To Track Inventory In Excel Spreadsheet. Most inventory managers use the first column to track item name, then add columns for information like upc/serial number, location, description, quantity, par, vendor, item value, and more. It also does a fairly decent job to manage your orders and products as well.
The critical basic inventory management fields you need to track in excel include: You can track the number of your stocks, your sales numbers and much more. What does inventory tracking look like.