How to upload Bulk IP

                                          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).

Insert IP Details

                                                       INSERT IP DETAILS

• Click the Insert IP Details Link.   

 

                                                                                                                                                                     
 
     This option is used to insert any missing out IPs in to the application. Insert IP can be done in two ways,

·         MANUAL INSERT IP : 

      If you want to insert IPs one by one, use this option. After clicking on the Insert IP link, click on “INSERT” button and fill in IPs details and press “SAVE” button.

·         EXCEL TEMPLATE UPLOAD :

      If you want to Insert too many IPs, use this option. After clicking on the Insert IP link, download “Excel Template” in blue color. Save the excel sheet and fill the in the IP details. After saving the excel sheet come to the same page and click on “BROWSE” button, attach the excel sheet and click on “UPLOAD” button.