Electronic Challan cum Return Format (FOR EMPLOYERS)

I have attached new PF ECR File Format in Excel Sheet and in PDF format.

 

ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT
(FOR EMPLOYERS)

 

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). The separator between fields should be #~# ( hash tilda hash).
Sl. No        Column Name        Column Width       Whether                        Remarks

mandatory

1.                Member ID            Number (7)             Yes                Only account number(maximum

7 digits)Value should be >0
                                                                                                    Two lines with same member id will

                                                                                                     not be accepted in a single ECR text

                                                                                                      file

 

 

 

2.                Member Name      Character (85)           Yes            No special characters other than ‘.’

are allowed

 

 

3.                 EPF Wages            Number (10)            No            Numbers only, no special character and

not in decimals

 

4.                 EPS Wages           Number (10)             No            Numbers only, no special character

And not in decimals

                                                                                                 Wages on which Pension contribution

                                                                                                 is due. In case of the member over 58

                                                                                                 years age, the wages should be ‘0’

                                                                                                 even in case there are PF wages.

                                                                                                 Also  in case of employer contributing 

                                                                                                over the wage ceiling, the pension

                                                                                                wages should be maximum 6500/- if

                                                                                                Pension contribution is restricted to Rs

                                                                                                541/-.

 

5.             EPF Contribution        Number (10)               No       Numbers only, no special character and

(EE Share) due                                                                        not in decimals, should be equal to or

more than EPF Contribution (EE Share)

being remitted.Employee share deducted

and due for remittance

 

 

6.      EPF Contribution             Number (10)                 No      Numbers only, no special character, not in

(EE Share)being                                                            decimals:
Employee share being remitted through

this ECR

 

7. EPS Contribution due           Number (10)                 No     Numbers only, no special character and

not in decimals, should be equal to or

more than EPS Contribution being remitted

8.EPS Contribution being         Number (10)                 No   Numbers only, no special character, not in

remitted                                                                            decimals

9.Diff EPF and EPS                   Number (10)                 No    Numbers only, no special character and not

Contribution (ER Share)                                                       in decimals, should be equal to or more due

than Diff EPF and EPS Contribution (ER

Share) being remitted
10.Diff EPF and EPS               Number (10)                  No       Numbers only, no special character, not in

Contribution (ER Share)                                                    decimals,

being remitted

 

11. NCP Days                        Number (2)                    No       Numbers only, no special character, not in

decimals.Number of days in the month for

which wages are not due.

 

12.Refund of Advances         Number (10)                  No       Numbers only, no special character and

not in decimals

13.Arrear EPF Wages           Number (10)                   No       Numbers only, no special character and

not in decimals

14.Arrear EPF EE Share       Number (10)                    No      Numbers only, no special character and

not in decimals

15.Arrear EPF ER Share       Number (10)                    No      Numbers only, no special character and

not in decimals

16. Arrear EPS                     Number (10)                    No      Numbers only, no special character and

not in decimals

ELECTRONIC CHALLAN CUM RETURN (ECR) FILE FORMAT
(FOR EMPLOYERS)

Share
17.Father’s/Husband’s       Character (85)                  No      No special characters are allowed. Please

Name                                                                                provide only if the member has joined in

the wage month. (for new member only)
18.Relationship with the    Character (1)                    No      Relationship of the member with column

Member                                                                          17 above. Value should be F(for father) or

S (for Husband). Please provide only if the

member has joined in the wage month.

(for new member only)

19. Date of Birth                  Date (10)                       No        Valid date in dd/mm/yyyy format. Please

provide only if the member has joined in

the wage month. (for new member only)

20.  Gender                       Character (1)                   No         M(Male) , F(Female) or T (Transgender).

Please provide only if the member has

joined in the wage month. (for new

member only)

21.Date of Joining EPF       Date (10)                         No       Valid date in dd/mm/yyyy format, not later

than the month of ECR. Please provide

only if the member has joined in the wage

month. (for new member only)

22.Date of Joining EPS      Date (10)                         No       Valid date in dd/mm/yyyy format, not later

than the month of ECR. Please provide only

if the member has joined in the wage

month. (for new member only)

23.Date of Exit from EPF  Date (10)                           No      Valid date in dd/mm/yyyy format, cannot be

prior to date of joining. Please provide only

if the member has left in the wage month.

(for exiting member only)

24.Date of Exit from EPS  Date (10)                         No      Valid date in dd/mm/yyyy format, cannot be

prior to date of joining. Please provide only

if the member has left in the wage month.

(for exiting member only)
25.Reason for leaving    Character (1)                     No     C (Cessation) , S (Superannuation) , R (

Retirement), D (Death in Service), or P

(Permanent Disablement).Please provide

only if the member has left in the wage

month. (for exiting member only).

Mandatory, if “Date of Exit from EPF” is not

blank.
Sample ECR text file with three members for the month of March 2012 paid in April 2012 for establishment id DLCPM0001234000 is as follows for reference:
12#~#SANJAY#~#7000#~#6500#~#840#~#840#~#541#~#541#~#299#~#299#~#0#~#0#~#10000#~#1500#~#1000#~#500#~##~##~##~##~##~##~#20/03/2012#~#20/03/2012#~#S
13#~#BIRENDRA#~#6000#~#6000#~#720#~#720#~#500#~#500#~#220#~#220#~#8#~#0#~#0#~#0#~#0#~#0#~##~##~##~##~##~##~##~##~#
16#~#SHEELA#~#5000#~#5000#~#600#~#600#~#417#~#417#~#183#~#183#~#4#~#0#~#0#~#0#~#0#~#0#~#VINEET#~#F#~#05/03/1990#~#F#~#05/03/2012#~#05/03/2012#~##~##~#
How to Generate ECR Text file:
Step 1: Use any Spreadsheet (OpenOffice, Excel, Lotus etc,) for creating the member details as per the prescribed format and save the file in CSV format.
Step 2: Open the CSV file in any text editor (notepad, editplus, etc.,) and replace all “,” with “#~#” . Save the file.

Click Here To Download New PF ECR File Format in Excel Sheet

 

Click Here To Download ECR Format

Search Sample Formats: