MIS Reporting Digitization

Problem
  • The client had manual excel based reporting. High probability of human error.
  • No real-time data on the spending of the organization of team-wise and identification of profitability and billable teams.
  • No salary trend analysis, sales analysis, and expense analysis other data analysis for business decisions.
  • The recurring process involving the manual effort of 8-10 hours per month i.e. 96-120 hours per annum.
Solutions
  • Due to the reporting being a completely manual process, prone to human errors, so we suggested digitization of MIS report with reduced human effort.
  • Wherein input sheets containing details of monthly income and expenses along with details of employees’ salaries were extracted from Tally into excel and passed through the Bot.
  • The Bot based on input sheets identified the month and prepared MIS report providing team-wise reporting along with standardized reports of Salary trends, expense analysis and prediction, and other analysis.
  • The Bot updates the same excel with these reports and the same can be shared with management/stakeholders. The Bot can create these reports in less than a minute.
Achievements
  • The manual effort was reduced to only 2 hours per month being 24 hours per annum.
  • Saved 12 man-days per annum.
  • Reduced 80% manual work.
  • Digitization of 80% of the entire process.
  • Less than a minute for the creation of MIS based reporting using Bot.
  • Standardized reporting.
  • No human error.
  • Automation of the MIS reporting process.
  • Seeing success client went on to automate other recurring processes such as Attendance, Time-sheet, Account receivables, invoicing processes, etc.