For Stock Maintenance, we first give titles to the columns of Excel. Each title should represent a different and distinct product category. In count sheet we will majorly discuss particular item or product purchased information, storage information and supplier detail. We write the number of each product in its column. The number of products can be totaled to find a net number of products available in the stock.
For the Products in the Stock that are Weighed:
If you are dealing with the products that are not counted but weighed, then you should write the weights of products in their respective column in the spreadsheet.
How to Get It?
You can get a suitable template of Excel from TrainingAble for free. You can download a template and can use it for your inventory management. Most of the templates downloaded are easily customize for the users to change the design of Excel sheet as per their preferences.