Build an excellent inventory management system in excel for my business

Job ID: 32318925

Budget: ₹600 – ₹1,500 INR

I run a multi designer store, we have multiple vendors/designer brands whom we so source our products from.
We maintain our store inventory in excel sheet which is unorganised.
We get challan on purchase orders, and then for every sale we made we send our month end reports to designers for stock and sales reports.

Develop a system and design my excel sheet in such a way that every month sending them their stock and sales report is story easy, efficient fast and fool proof