Overview Of The Company
- File Download: The scheduled bot retrieves the monthly Working File and Gross to Net (GTN) File from the designated folder, generated by the business and provided by the payroll vendor, respectively.
- Line-by-Line Comparison: The bot meticulously compares each line item of the Working File with the GTN File for every entity, accounting for over 20 tabs per entity. A modular approach was adopted to accommodate varying tax laws and market nuances across different entities.
- Discrepancy Logging: When a mismatch is detected, the bot records the tab and column of the variance in the Output Report. This method enhances efficiency by providing analysts with precise locations of the discrepancies, eliminating time spent on manual searching within the large file.
- Rebalancing and Finalization: The bot continues the process until all variances are resolved. Once rebalancing is complete, payroll is finalized and approved.
- Entities Processed: Successfully processed reconciliation for 27 entities each month.
- Processing Time Reduction: Achieved a remarkable 78% reduction in processing time, saving valuable resources and enabling analysts to focus on higher-value tasks.
- Data Management Accuracy: The payroll automated solution demonstrated exceptional accuracy, achieving a 99% accuracy rate in data reconciliation.