Payroll Calculation Process
Pain Points:
1. Verify employee data versus the master file for the OT and incentive.
2. Calculate allowance entitlement for various project according to rates.
3. Incorrect NPL calculation due to Excel Macro limitation and needs manual correction.
4. Export processed data into csv based on layout of the month.
Solution:
Install one bot to automate sanity check and email discrepancy report as well as salary calculation, verification, and generation of csv to be uploaded.
Benefits:
1. Reduced time taken to process the calculation from 3 days to 2 hours.
2. Error free as bot is handling all the calculations and verification.
3. Payment for the payroll can be process in time without delay.
- You must be logged in to reply to this topic.
