No Tags Found!


Dear Seniors, Can anybody provide me New PF ECR Fiel format in Excel Sheet. its help me to upload date in new PF registraion on deposit contrubution I am very thankful of you. Yours Rakesh Kaushik
From India, Alwar
Acknowledge(9)
DH
YA
SC

+4 more

Amend(0)

Dear Rakesh, kindly find attached the ECR format in PDF format. 

Regards

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: pdf ECR_ForEmployers_FileStructure.pdf (173.8 KB, 22640 views)

Acknowledge(0)
Amend(0)

ECR Excel File Format as per EPF Guidelines

Please find the ECR Excel file format as per EPF guidelines. When entering and uploading the ECR return, please read and follow the instructions specified in the ECR_ForEmployers_FileStructure.pdf file.

With warm regards,
Jayakumar.K

From India, Coimbatore
Attached Files (Download Requires Membership)
File Type: xls ECR format.xls (22.5 KB, 39659 views)

Acknowledge(6)
SS
GS
AL

+1 more

Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user reply is correct. Thank you for providing the ECR excel file format as per EPF guidelines. Your attention to detail is commendable. (1 Acknowledge point)
    0 0

  • Enter the data in mm/dd/yyyy format; it automatically converts to the required format, i.e., dd/mm/yyyy. I have already uploaded the online return using this file format. FYI.

    Regards,
    Jayakumar K.

    From India, Coimbatore
    Acknowledge(0)
    Amend(0)

    Dear jayakumar is it neccessary to fill all the coloumns in the format. ex- diff eps and epf
    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    Dear Nidhin Biju/Y-123-56 Please find the format along with few sample records. Feel free to contact if you have any more queries. Regards Jayakumar.K
    From India, Coimbatore
    Attached Files (Download Requires Membership)
    File Type: xls ECR formatsample.xls (49.5 KB, 13854 views)

    Acknowledge(5)
    M
    VE
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-[response] (1 Acknowledge point)
    0 0

  • hi HOW NEW FORMAT FOR EPFO ONLINE ANY DOUBTS CONTACT
    From India, Madras
    Attached Files (Download Requires Membership)
    File Type: ppt E SEVA PRESENTATION-C3FSI.ppt (593.0 KB, 4597 views)

    Acknowledge(0)
    Amend(0)

    we have enter member id as pf a/c no i.e. - 3 it is correct as per your sample list but one error comes in same column. please help us.
    From India, Pune
    Acknowledge(0)
    Amend(0)

    dear, I have prepare all file but the upload error codes that the data is not as per ecr format sunny
    From India, Shimla
    Acknowledge(0)
    Amend(0)

    I have uploaded the ECR text format online and approved it. However, there are some changes that need to be rectified in wages. I have submitted a "Request ECR rejection" for this purpose. Can I now upload the new text file for the same month of March? Your urgent assistance is greatly appreciated as I need to make a payment promptly.

    Thank you for your help.

    Regards

    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    Dear Rithwik Pls go thro my reply dated 11 th Apr 2012 file name ecrformatsample.xls. Regards Jayakumar.K
    From India, Coimbatore
    Acknowledge(0)
    Amend(0)

    here is the New PF ECR Fiel format in Excel Sheet.Hope this will help you. regards, asmita
    From India, Mumbai
    Attached Files (Download Requires Membership)
    File Type: zip ECR Format.zip (1.05 MB, 1095 views)

    Acknowledge(0)
    Amend(0)

    In ECR how we have to enter voluntary payment by individual employees. Please advice There is columns only for regular payments.
    From India, Belgaum
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-In the ECR, voluntary payments by individual employees should be entered in separate columns provided for such transactions. Refer to EPFO guidelines for specific details. (1 Acknowledge point)
    0 0

  • Dear Kalpesh Please find the sample file as requested. Feel free to contact if you have any more queries. Regards Jayakumar K
    From India, Coimbatore
    Attached Files (Download Requires Membership)
    File Type: xls ECR formatsample.xls (50.0 KB, 871 views)

    Acknowledge(0)
    Amend(0)

    Dear All When we upload the ECR, it shows the error code 37, can somebody help me what is the meaning of this? Regards Rajesh Beedkar
    From India, Mumbai
    Acknowledge(1)
    BH
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The error code 37 in PF ECR upload signifies "Invalid ECR file format." Please review the file format and ensure it complies with PF guidelines. Thank you for seeking clarification. (1 Acknowledge point)
    0 0

  • Dear all, while ecr upload, it does’nt allow to upload xls file...? PLS HELP ME IN THIS REGARD GANESH
    From India, Nasik
    Acknowledge(0)
    Amend(0)

    Queries Related to PF

    I have some queries related to PF. If possible, kindly revert as this will be helpful for everyone.

    1. Can we calculate the arrears on EPS? If yes, then should the maximum limit of 6500 be considered or not?
    2. Is there any statutory document that will explain the queries related to arrear calculation?
    3. In the Electronic Challan format, separate columns are provided to display the PFArrWages, Arr-EE-PF, Arr-ER-PF, Arr-EE-EPS, but there is no column to display the EPS-Arr-Wages.
    4. Can EPS contribution be more than 541 (due to the arrears calculation)?

    I am eagerly waiting for the replies.

    Thanks in advance.
    Regards

    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    Dear SIR how we fill wages in ecr format if we given the arrier in the month of may. Regards, Bharpoor
    From India, Shimla
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The query is about filling wages in the ECR format if arrears were given in May. The ECR format should reflect actual wages paid in the respective months, not the arrears month. Ensure accurate wage details are provided. (1 Acknowledge point)
    0 0

  • I am attaching herewith the Excel file, which will automatically generate the required ECR file for uploading to the site. This is a macros-based file created by Datacure. Just fill in the required data and click on the "Create ECR File" button.

    Thanks & Regards,
    NEERAJ R. WARRIER
    Head - Payroll Dept.
    BENSON MOVERS LTD.

    From India, Delhi
    Attached Files (Download Requires Membership)
    File Type: xls ECR CREATOR-NEERAJ WARRIER.xls (94.0 KB, 1129 views)

    Acknowledge(2)
    MU
    M
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The information provided in the user reply is accurate and helpful for generating the required ECR file for uploading to the PF site. Well done! (1 Acknowledge point)
    0 0

  • dear sir i would like know that were should we add the arrears contribution of PF in ECR sandeep
    From India, Thana
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The arrears contribution of PF should be added in the ECR under the column "Arrears EPF (Column 6D)" for accurate record-keeping. Thank you for your question! (1 Acknowledge point)
    0 0

  • please find attached new ecr 2.0 uan based ecr format in excel from december 2016
    From India, Pune
    Attached Files (Download Requires Membership)
    File Type: xls UAN BASED ECR EXCEL.xls (52.0 KB, 483 views)

    Acknowledge(0)
    Amend(0)

    hi i m sandeep sachdeva i m asking one query....please ttell me how to make ecr file in new format
    From India, Delhi
    Acknowledge(0)
    Amend(0)

    new ECR changes only UAN No And EDLI Wages.. please confirm....
    From India, Pune
    Acknowledge(0)
    Amend(0)

    Dear Rakesh I would like your good self to kindly provide new ecr formate. Thank you very much
    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    In the new format, there is a column for Gross wages: If an employee's Gross is 22000 and his basic is 9000, HRA is 4500, CCA is 2250, Conveyance is 1600, and special allowance is 4650. According to the new format, what amount should appear in the column of EPF wages? Please help me out immediately.

    Venkat

    From India, Chennai
    Acknowledge(0)
    Amend(0)

    Dear team please upload any new ECR Excel format. It help full all very need also.
    From India, Bangalore
    Acknowledge(0)
    Amend(0)

    hello sir, i want to know what is gross_wages to show in epfo ecr excel file
    From India, Mumbai
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The term "gross_wages" should represent the total earnings of an employee before any deductions, including bonuses. It is a critical factor in EPFO ECR reporting to ensure accurate contributions. (1 Acknowledge point)
    0 0

  • New ECR file format enclosed herewith for the new web page: https://unifiedportal-emp.epfindia.gov.in/epfo/
    From India, Chennai
    Attached Files (Download Requires Membership)
    File Type: csv NEWECRFILEJAN16.csv (1.9 KB, 298 views)

    Acknowledge(2)
    A1
    ND
    Amend(0)

    Dear Sir,

    I do not know how to upload ECR for December 2016 on the latest Unified Portal. When I upload it, it shows an error. Can you please help me or teach me how to do these tasks? If possible, could you upload snapshots for guidance?

    With Regards

    From India, Thanjavur
    Acknowledge(0)
    Amend(0)

    Hi,
    Follow the steps to upload the ECR v2.0. Have attached screenshots as well.
    Step 1: Login as an ‘Admin' under new PF portal. https://unifiedportal-emp.epfindia.gov.in/epfo/
    Step 2: Go to ‘Payments' & Click ‘ECR/Return Filing'
    Step 3: Click ‘ECR Upload'
    Step 4: Upload the ECR file and Submit

    From India, Bengaluru
    Attached Files (Download Requires Membership)
    File Type: png 1.PNG (153.4 KB, 60 views)
    File Type: png 2.PNG (112.9 KB, 24 views)
    File Type: png 3.PNG (84.9 KB, 19 views)
    File Type: png 4.PNG (123.3 KB, 26 views)

    Acknowledge(1)
    ND
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user reply is correct in guiding the process to upload the ECR file on the new PF portal. No amendments needed. (1 Acknowledge point)
    0 0

  • Sir, I require UAN based ECR format As the format with me is contineously showing invalid file error
    From India, Pune
    Acknowledge(0)
    Amend(0)

    Can anyone guide where to show Voluntary EPF contribution in ECR ?
    From India, Panskura
    Acknowledge(1)
    VC
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The voluntary EPF contribution should be shown in the ECR under the column "Voluntary PF." Ensure it is accurately reflected to avoid discrepancies. Thank you for seeking clarification on this matter. (1 Acknowledge point)
    0 0

  • Dear Kamlesh, I Hope that the attached excel files with macros will help you to auto generate monthly ECR text and arrears text files. Regards.
    From India, Mumbai
    Attached Files (Download Requires Membership)
    File Type: xls ECRfile_Template_v2.1.xls (102.5 KB, 317 views)
    File Type: xls ECR_Arrear_Template_v1.0.xls (84.5 KB, 164 views)

    Acknowledge(0)
    Amend(0)

    Dear Kamlesh, I Hope that the attached excel files with macros will help you to auto generate ECR arrears text file. Regards.
    From India, Mumbai
    Attached Files (Download Requires Membership)
    File Type: xls ECR_Arrear_Template_v1.0.xls (84.5 KB, 139 views)

    Acknowledge(0)
    Amend(0)

    Hi Sir, while I am uploading my text file in ecr it is showing error in UAN format how can I correct it .
    From India, Gurgaon
    Acknowledge(0)
    Amend(0)

    CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.