Performance Report Automation for a Large Listed Indian Infrastructure company

Problem Definition :
A large listed Indian infrastructure company was facing a crisis with time delay in Performance Report generation. Instant Performance Report generation was essential for the Senior Management to assess the company’s performance on a real time basis, which they were unable to do. The client approached itechpath Associate to come up with a solution to overcome the problem.

Approach :
Team members of itechpath Associate had to spend sufficient time to assess the problem in detail. It was found out that the accounting entries were extracted to Excel from SAP. MIS reports were generated based on these accounting entries and presented in powerpoint to the Regional Managers. The procedure followed by the Client to generate the Company Performance Report was complex in nature and was also often time consuming resulting in more than a month delay in submission of the performance reports to the Management.

Also, it was observed that the accounting entries were not accurate when data was extracted to excel. As a result, hasty decisions were taken by the Senior Management based on the previous month’s erroneous data leading to problems for the client. Once identified itechpath Associate worked towards putting in a comprehensive solution.

Solution:
To address this issue, itechpath Associate had recommended the client, to utilize its proprietary tool – “Analyst” to generate company performance reports from SAP on a real time basis in the following scenarios :
• It was found difficult to predict the key performance metrics of the client such as net profit for the current month, without taking into account the indirect expenses such as employees’ salary which is credited towards the end of the month. Analyst tool was used to accurately predict these expenses based on slight assumptions and adjustments made in previous month overall salary expenses. Hence, based on the above, company performance reports could be generated on a real time basis during the month and interpreted by the senior management with ease.
• Senior Management required Monthly Company Performance reports with duly closed accounting entries for Monthly Review Meetings (MRM) to take constructive decisions. Actual Monthly company performance reports were available by the 4th of following month for evaluation by the senior management using Analyst tool.
Adoption of the Analyst tool by the Client to generate company performance reports took only six months due to its accuracy and efficiency. The client was able to closely monitor company performance reports with ease during this period and take action.