epf arrear ecr file format in excel download

If the member has left in the wage month.Ģ4.Date of Exit from EPS Date (10) No Valid date in dd/mm/yyyy format, cannot beĢ5.Reason for leaving Character (1) No C (Cessation), S (Superannuation), R ( Please provide onlyĢ3.Date of Exit from EPF Date (10) No Valid date in dd/mm/yyyy format, cannot be Only if the member has joined in the wageĢ2.Date of Joining EPS Date (10) No Valid date in dd/mm/yyyy format, not later Gender Character (1) No M(Male), F(Female) or T (Transgender).Ģ1.Date of Joining EPF Date (10) No Valid date in dd/mm/yyyy format, not later Date of Birth Date (10) No Valid date in dd/mm/yyyy format. Name provide only if the member has joined inġ8.Relationship with the Character (1) No Relationship of the member with column Not in decimals ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMATġ7.Father’s/Husband’s Character (85) No No special characters are allowed. Arrear EPS Number (10) No Numbers only, no special character and NCP Days Number (2) No Numbers only, no special character, not inġ2.Refund of Advances Number (10) No Numbers only, no special character andġ3.Arrear EPF Wages Number (10) No Numbers only, no special character andġ4.Arrear EPF EE Share Number (10) No Numbers only, no special character andġ5.Arrear EPF ER Share Number (10) No Numbers only, no special character andġ6.

More than EPS Contribution being remittedĨ.EPS Contribution being Number (10) No Numbers only, no special character, not inĩ.Diff EPF and EPS Number (10) No Numbers only, no special character and notĬontribution (ER Share) in decimals, should be equal to or more dueġ0.Diff EPF and EPS Number (10) No Numbers only, no special character, not inġ1. EPS Contribution due Number (10) No Numbers only, no special character and EPF Contribution Number (10) No Numbers only, no special character, not inħ. (EE Share) due not in decimals, should be equal to orĦ. EPF Contribution Number (10) No Numbers only, no special character and EPS Wages Number (10) No Numbers only, no special characterĥ. EPF Wages Number (10) No Numbers only, no special character andĤ. Member Name Character (85) Yes No special characters other than ‘.’ģ. Member ID Number (7) Yes Only account number(maximumĢ. No Column Name Column Width Whether Remarksġ. The separator between fields should be #~# ( hash tilda hash). The Electronic Challan cum Return (ECR) will be an electronic return in plain text format and will consist of DETAILED lines (one line for each member). ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT

Epf arrear ecr file format in excel download