Struggling with ECR File Preparation for Employer E Seva? Let's Share Formats and Tips

How can I prepare the ECR file for uploading on Employer E Seva? If anybody has any format with examples, please provide us.

Regards,
Mukesh Kumar Saini

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,

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

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

Hi, can anybody help me? I could not upload the ECR format in the PF portal. It keeps showing "not supported" continuously.

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,

Please find attached the ECR Sheet and process sheet for PF. Thank you.

Regards,
J.N. Modi

You can use this Excel utility, but you have to enable macros.

Regards.

Difference Between E-Return Tool Application and E-Sewa

Can anybody explain the difference between the E-return tool application and E-Sewa?

Regards,
Rupan K S

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!

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,

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

This is the simplified format for the EPF ECR TXT file to generate. I hope your work will be easy.

Regards

Hi, I am Jakir Hussain. I want to know how to prepare the EPF E-Sewa ECR. I have taken a part-time position in returns of EPF. Please help me. Please send the ECR Excel format.

Regards,
Jakir Hussain

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.

Hi friends, I am an employer. How do I create a PF challan and upload the challan? I need full information on PF and also the formulas.

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. If you can explain in Kannada, it would be very helpful.

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