How Can I Streamline Daily Store Updates into a Single Excel Report? Seeking Advice!

Hi seniors, I am working at Cellpoint India Pvt Ltd as an admin. There are two hubs available in Vijayawada and Vizag. Mostly, I am focused on Vijayawada, which consists of 14 stores. For these fourteen stores, we currently receive manual updates through telecalling. I am seeking these updates in an Excel sheet in a single, updated format by the store manager daily.

Contents Required

The contents required are as follows:
1. Attendance
2. Commitment for sale
3. Cash invoice deposits and dues
4. Service issues, including any job sheets raised or not
5. Expenses report

These aspects are crucial. If anyone can assist me in resolving this issue, I would greatly appreciate it. Otherwise, I will try to address it to satisfy my boss. We discuss these matters daily, so please help if you can.

Thank you.

Dear 9059038014,

Your requirement spans across various departments such as HR, Sales, Customer Service, Accounts, MIS, etc. Therefore, it is worthwhile for you to invest in ERP software for the retail stores. There are many software options available with cloud support, which means you may not need to maintain your own server. Kindly instruct your IT team to explore the market and identify the most suitable solution.

Thanks,

Dinesh Divekar