UPLOAD BULK IP
Click the link "INSERT IP DETAILS"
Click "INSERT BUTTON".
Click "EXCEL TEMPLATE EXCEL" and then save the EXCEL sheet in your PC.
Enter the data in(IP Number,Name,DOB,DOA,Gender) 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 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.Eg: 14/04/2011 or 14.04.2011 is correct format(14/04/2011 or 2-Apr-11 are not acceptable)
• Following figure shows a sample excel format
Click the Browse button and select the excel file from your PC then click "UPLOAD" button.
"IP INSERTED SUCCESSFULLY" Message will display in 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 employee has left service, Retired, Out of coverage, Expired, Non-Implemented area or Retrenchment. For other reasons, last working day must be left BLANK)
Excel sheet upload will lead to successful transaction only when all the Employees’ (who are currently mapped in the system) details are entered perfectly in the excel sheet.
In case IP Number is entered wrongly(less than 10 digits) –Excel upload will throw error to modify the IP Number.
Calculations –IP Contribution and Employer contribution calculation will be automatically done by the system.
Reasons are assigned numeric code.
Once 0 wages given, IP will be removed from the employer’s record. Subsequent months will not have this IP listed under the employer.
Note that all the column including date column should be in ‘Text’ format.
Date column format is dd/mm/yyyyor dd-mm-yyyy. Pad single digit dates with 0. Eg:-01/01/2011 or 01-JAN-201 is NOT acceptable. Correct format is 01/01/2011 or 01-01-2011.
Excel should be saved in .xlsfile type (Excel 97 –2003).