Inventory Management Template

Inventory Management Template for Store

In this article, we have created Excel and VBA based Inventory Management Template. This Template is useful to manage the Store Inventory and to search the Product Drawer. This can be used wherein hundreds or thousands of small products are kept in the drawers. It can easily tell which product is available in which drawer and how many units are in stock.

Search form:

You can search for the product by typing the name in the search box. After selecting the product you will the product report in the Report Frame.Search Form

Search Form

Update Inventory form:

You can IN or OUT your stock using this form. We have given a product search box on the left-hand side.

Update Inventory Form
Update Inventory Form


In the Report Sheet, you can see all product inventory, Re-order product report, or Out of Stock Product Report.



Watch the step by step video tutorial:

Click here to download the practice files.

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.