UPLOAD BULK IP
- Click the link "INSERT IP DETAILS".
- Click "INSERT BUTTON".
- Click "EXCEL TEMPLATE EXCEL" and then save the EXCEL sheet on your PC.
- Enter the data in (IP Number, Name, DOB, DOA, Gender) in the downloaded Excel sheet.
Instructions to Create Excel Sheet for Bulk IP Upload:
• Enter the 10-digit IP number, IP name, Date of Appointment, Date of Birth, and Gender.
• Excel sheet upload will be successful only if all the data is entered in the correct format. Use only the downloaded template for this activity.
• Kindly note that all columns should be in 'Text' or 'General' format, including date columns.
• Dates should be in either dd/mm/yyyy or dd.mm.yyyy format. For example, 14/04/2011 or 14.04.2011 is the correct format (14/04/2011 or 2-Apr-11 are not acceptable).
• The following figure shows a sample Excel format.
Click the Browse button and select the Excel file from your PC, then click the "UPLOAD" button. "IP INSERTED SUCCESSFULLY" message will display on the same screen.
Creating Excel Sheet for MC - Instructions:
Enter the IP number, IP name, No. of Days, Total Monthly Wages, Reason for 0 wages (If Wages '0') & Last Working Day (if the employee has left service, Retired, Out of coverage, Expired, Non-Implemented area, or Retrenchment. For other reasons, the last working day must be left BLANK).
Excel sheet upload will lead to a successful transaction only when all the Employees’ (who are currently mapped in the system) details are entered perfectly in the Excel sheet.
In case the IP Number is entered wrongly (less than 10 digits) – Excel upload will throw an error to modify the IP Number.
Calculations – IP Contribution and Employer contribution calculation will be automatically done by the system.
Reasons are assigned numeric codes.
Once 0 wages are given, the IP will be removed from the employer’s record. Subsequent months will not have this IP listed under the employer.
Note that all the columns, including the date column, should be in 'Text' format.
The date column format is dd/mm/yyyy or dd-mm-yyyy. Pad single-digit dates with 0. For example, 01/01/2011 or 01-JAN-201 is NOT acceptable. The correct format is 01/01/2011 or 01-01-2011.
Excel should be saved in .xls file type (Excel 97–2003).