Remember that your employees fill out the lists by hand. Try not to place too many items on one page. For example, it is important to leave enough space for entries. When you create your template, pay particular attention to the requirements of the employees who actually perform the count. You can create a neat and helpful inventory list with almost any spreadsheet program (like Excel), but this also works with modern word processing software. In addition, each sheet must be dated and signed. Each sheet is given a number so that you can keep track of it and it can be better understood at a later date (not only by you, but also by an auditor). In addition to the actual table, the physical inventory list also contains additional information that is used to ensure that the documentation is as accurate as possible. Only at the end, on a separate sheet, do you add all the totals together. Then start over and over again with a new sheet. First, you enter the value of the individual item and then the total value resulting from the count.Īt the end of each sheet, you calculate the sum of the total values of each product group so there is no carryover onto other sheets. Value: You divide the value of the items into two columns.Unit of measurement: This column indicates whether you’re measuring in quantity, weight, length, or another unit of measurement.Quantity: In this column, the employee enters the result of their counting or measuring.It may be useful to sort the list by item number and move this column more to the left, depending on how your warehouse is sorted. Item number: In your company, each item has its own inventory number.Article description: Enter the exact description for each article.You distribute the lists to your employees or inventory assistants, who use the documents to record the actual stock in your company. Inventory lists are used for physical inventory.