Contribution

                                                        MONTHLY CONTRIBUTION

     You can use this option for submitting the contribution every month. MC (Monthly Contribution) can be submitted in the following ways.

   

·         Online MC :

This option is for the employer who is having less number of IPs. After selecting on “SUBMIT MONTLY CONTRIBUTION”, you need to select the correct month & year and click on “SUBMIT” button.  All the IP NOs and Name will be displayed. All you need is to enter the correct details (Wage & Day details) in each box. After completing the data entry, you can click on “PREVIEW” button. The application will calculate the contribution amount. You can click on submit button if the contribution amount is matching as per your records.

·         Offline MC :

  1.  Once the List of Employees is complete, download the IP list available in Insert IP Link.

  2.  Download Sample MC Template from the portal. Only this Template should be used, Please refrain from using        any other sheet even if prepared in similar looking format.

 3.  Copy ALL IP No and Names from the downloaded list of employees to the MC Excel. Make sure to “paste values” only. Leave out the IPs whose DoJ is after the month for which the Contributions are being filled.

   

 4. Enter days and wages as per employer’s record sheet / ESIC 32 Register. You may use VLOOKUP formula to extract no of days and wages from the excel brought by employer, if the no of IP is large.

 5.  Make sure all the entries have same format, keep note of the small green symbol at top left of the cell, That sign is for “number stored as text” so you can convert them to text by selecting entire cells, go to

      DATA -> Text to Column -> Select “Delimited” -> Next -> Finish.

  6.    Ensure that there are no formulas in the Excel that you are uploading in the portal. Remove them by copying & pasting (Paste Values) again on the same cells (this is especially required if you have used VLOOKUP in step 4.)

 7. Format for all fields should be TEXT, including for the Date column (format for date column is dd-mm-yyyy).

 8.  Now Upload the excel sheet, after checking the sum total of wages entered in the MC Excel sheet.