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.