Inventory Management System, Customer and Vendor Management System in Microsoft Excel

This is an Inventory Management System developed using VBA Macros in Microsoft Excel. This template will serve the need of managing your inventory inflow outflow from vendors and customers as well as updating their balances and receiving and making payments from/to them.  You will also be able generate report on several crtieria including customer, vendor, item or certain date range.

System Requirement:

Microsoft Excel Desktop Version  (No Google Sheet)

Windows operating system is recommended.

 Macros must be enabled:  (You can enabled by simply 1) right click on file, go to property and select Unblock (skip the step if u do not see unblock).. 2) open the file and click enabled content. )  If buttons are working then it means your macro is already enabled.

Note: The File is standard inventory management system. Customization will not be provided. File demonstration is available on Youtube.

Youtube Video Link: https://youtu.be/CpUWdbgASzo