Step 1: Access the Consultant Import Section
- Go to the Consultant module from the main menu
- Click on the Import button
- Select Consultant Details Import
Step 2: Download the Sample Excel Template
- Click on Update Consultant Details
- Download the Sample Excel Template
The template will include:
- Sheet 1: Instructions
- Sheet 2: Data entry for consultant resignation details
Step 3: Fill in Employee Resignation Details
In Sheet 1 (Instructions), update the following fields for each employee:
Field Name | Description |
Resigned Date | Date when the employee submitted resignation |
Last Working Day | Official last working date of the employee |
Remark Notes | Any remarks or notes regarding the resignation |
Ensure date format is consistent (e.g., YYYY-MM-DD)
Only use the provided template format; modifying columns may cause import errors.
Step 4: Upload the Completed Excel Sheet
- Return to the Import section in the Consultant module
- Select the updated Excel file
- The system will validate the data
- Upon successful validation, the resignation details will be saved in the system
Post-Upload Outcome
- The employee’s employment status will be automatically updated to "Resigned"
- The resignation and last working dates will reflect in the employee profile
- The system will update all related modules, including payroll and reports, accordingly
Notes
- This bulk update process is recommended for handling multiple resignations efficiently
- Ensure proper role-based access is granted to use this import feature
After update, verify data via the Employee Master or Contract
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article