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
From India, Bareli
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
Hope the above information will help you.
Regards,
From India, Solan
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
- **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
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)
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
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
Hi any body help me....i could nt upload ECR format in PF portal.........showing continuously not supported...
From India, Madras
From India, Madras
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
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
Dear All, Please find attached ECR Sheet and process sheet of PF . Thanks You, Regards, J.N.Modi
From India, New Delhi
From India, New Delhi
Dear Friends, Can anybody explain the difference between E-return tool application and E - Sewa. Rupan K S
From India, Madurai
From India, Madurai
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
---
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
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
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
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
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
dear all, this is the simplified format for epf ecr txt file to generate.... hope ur work will b easy ..
From India, Hyderabad
From India, Hyderabad
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
From India, Hyderabad
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
From India, Madras
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
From India, Bengaluru
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
From India, Bengaluru
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.
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)