No Tags Found!


How can prepare the ECR file for uploading on Employer E Seva. If anybody have any formate with example, pls provide us. Mukesh Kumar Saini
From India, Bareli
Acknowledge(3)
HH
RS
Amend(0)

This is very simple and easy to prepare the ECR file. Just log in to the employer portal and download the ECR instructions. The format is attached for your ready reference. Delete the first row when you enter the whole data, then save the Excel file as comma-delimited. After that, replace all "," with "#~#" as per the instruction file.

Hope the above information will help you.

Regards,

From India, Solan
Attached Files (Download Requires Membership)
File Type: xls ECR EPF March. 2012.xls (23.5 KB, 7370 views)

Acknowledge(0)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is [B]correct[/B]. Thank you for providing clear steps on preparing the ECR file. Your guidance will help others navigate the process effectively. (1 Acknowledge point)
    0 0

  • Kindly provide us with the formula for each column. I have listed the formulas below; please confirm if they are correct:

    - **EPF Wages:** Basic + DA
    - **EPS Wages:** Basic + DA
    - **EPF Cont (EE Share):** 12%
    - **EPF Cont (EE share remitted):** 12%
    - **EPS cont due:** 8.33%
    - **EPS cont. being remitted:** 8.33%
    - **Diff EPF & EPS:** 3.67%
    - **Diff EPF & EPS being remitted:** 3.67%

    Please advise on where to include the administrative charges of 1.1%, 0.5%, and 0.01% respectively.

    Kindly reply as soon as possible.

    Thanks and regards,
    Vinita

    From India, Bharuch
    Acknowledge(2)
    DE
    RO
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The formulas provided for EPF Wages, EPS Wages, EPF Cont, EPF Cont (EE share remitted), EPS cont due, EPS cont. being remitted, Diff EPF & EPS, and Diff EPF & EPS being remitted are correct. The admin charges of 1.1%, 0.5%, and 0.01% should be included in the calculation separately. It's advisable to verify the specific requirements for admin charges in the ECR Instructions. (1 Acknowledge point)
    0 0

  • EPF and EPS Contributions Breakdown

    EPF Wages - Basic + DA: ok

    EPS Wages - Basic + DA: There is a ceiling of Rs. 6500.00.

    EPF Cont (EE Share) - 12%: ok

    EPF Cont (EE share remitted) - 12%: ok

    EPS cont due - 8.33%: 8.33% up to 6500.00, maximum EPS amount 541.00

    EPS cont. being remitted - 8.33%: See the comment above.

    Diff EPF & EPS - 3.67%: If basic and DA <= 6500, then ok.

    Diff EPF & EPS being remitted - 3.67%: See the comment above.

    Please let us know where we should mention the admin charges of 1.1% (of EPF Wages - Basic + DA), 0.5% (EPS Wages - Basic + DA), and 0.01% (EPS Wages - Basic + DA) respectively.

    Regards,
    Mukesh Kumar Saini

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

    Hi any body help me....i could nt upload ECR format in PF portal.........showing continuously not supported...
    From India, Madras
    Acknowledge(0)
    Amend(0)

    All formulas seem okay except the following:

    1. EPS wages = if(basic + DA > 6500, 6500, basic + DA)
    2. Diff EPS & EPS = EPF Cont (EE Share) - EPS cont due - 8.33% i.e., 3.67%, but sometimes higher due to 8.33% on max. 6500.

    The admin charges A/C 2 @ 1.1%, A/C 21 @ 0.5% on Max, 6500/-, and A/C 22 @ 0.01% are to be calculated manually and will be entered later when you proceed for ECR upload.

    Hope the above will help you.

    Regards,

    From India, Solan
    Acknowledge(1)
    SG
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The information provided in the user reply is correct and relevant for preparing the ECR file for uploading on Employer E Seva. Thank you for sharing your insights. (1 Acknowledge point)
    0 0

  • Dear All, Please find attached ECR Sheet and process sheet of PF . Thanks You, Regards, J.N.Modi
    From India, New Delhi
    Attached Files (Download Requires Membership)
    File Type: pdf ProcessFlowECR.pdf (1.73 MB, 452 views)
    File Type: pdf EPFO Eseva data uploding Guidlines[1].pdf (1.65 MB, 307 views)

    Acknowledge(0)
    Amend(0)

    you can this excel utility you have to enable macro
    Attached Files (Download Requires Membership)
    File Type: xls ecr_filing_utility.xls (81.0 KB, 563 views)

    Acknowledge(0)
    Amend(0)

    Dear Friends, Can anybody explain the difference between E-return tool application and E - Sewa. Rupan K S
    From India, Madurai
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The E-return tool application is used for filing returns, while E-Seva is a portal for managing employer-related tasks. They serve different purposes. (1 Acknowledge point)
    0 0

  • I am quite confused about preparing the text file with the specified ECR format because, for the employees who are under non-EPS, what is the content for EPS Contribution due? I also need the formula to calculate the columns' content like EPF Contribution due, EPS Contribution due, etc. Could you please share your uploaded file? It would be really helpful for us. Looking forward to your post.

    ---

    I corrected the spelling and grammar errors in your text and formatted it for better readability. Let me know if you need further assistance!

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

    Important Notice on Filing Monthly Returns

    Please note that after generating and submitting the ECR to the bank, we also need to file the monthly return, i.e., Form 12A and 5/10, to the concerned office until you receive any letter of discontinuity from the department.

    Regards,

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

    EPFO Launches Online Receipt of Electronic Challan cum Return (ECR)

    Dear Employers,

    EPFO has launched the online receipt of the Electronic Challan cum Return (ECR) starting from April 2012 (March paid in April). Employers are requested to register their establishments and create their user ID and password through this portal. The registered employers can upload the Electronic Return, and the uploaded return data will be displayed through a digitally signed copy in PDF format, available for printing as well. Once approved by the employer, an online Challan will be generated based on the uploaded return. The employer may choose to make the payment through internet banking of SBI or take a printout of the Challan and pay at any designated branch of State Bank of India (SBI).

    Benefits:

    - No paper return needs to be prepared and submitted to EPFO.
    - No need to submit other returns such as Form 5/10/12A, 3A, and 6A.
    - Employers will receive confirmation of payment instantly through SMS.
    - The contribution will be credited to the members' accounts on a monthly basis.
    - Employers can view the annual accounts slip for the accounting year 2011-12 online.
    - For earlier years, employers can request the annual slips through this portal.

    Employer registration starts from 20.03.2012.

    Regards

    From India, Delhi
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user reply contains accurate information regarding the process of preparing and uploading the ECR file on Employer E Seva. Well done! (1 Acknowledge point)
    0 0

  • dear all, this is the simplified format for epf ecr txt file to generate.... hope ur work will b easy ..
    From India, Hyderabad
    Attached Files (Download Requires Membership)
    File Type: xls ECRfile_Template_version1.2.xls (95.5 KB, 462 views)

    Acknowledge(0)
    Amend(0)

    Hi sir i JAKIR hUSSAIN I WANT TO EPF E-SEWA ECR HOW TO PREPAER I HAVE TAKE A PART TIME IN RETURNS OF EPF PLEASE HELP ME PLEASE SEND ECR EXCEL FORMET
    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    Actually, I am also facing the same problem. Please refer to the ECR file format demo. We should include additional details. For example, the dates of joining and relieving, along with all other date formats, should be in text. Just give it a try and upload the file.
    From India, Madras
    Acknowledge(0)
    Amend(0)

    hi frnds i am a employer how to create a pf challan and upload the challan i need full information of pf and also formulas.
    From India, Bengaluru
    Acknowledge(0)
    Amend(0)

    i need full information of how to create pf challan and upload, edit and all please give me the formats of pf. i am a employer i dont know english very well . kannada dali helidare thumba upayoga
    From India, Bengaluru
    Acknowledge(0)
    Amend(0)

    I need full information on how to create PF challan, upload, edit, and all. Please provide me with the formats for PF.
    I am an employer, and I don't know English very well. Kannada dalli helidare thumba upayoga.

    Posted Today
    kanthu.9864@gmail.com

    From India, Bengaluru
    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.