How to Navigate EPFO Employer e-Sewa Data Uploading with Step-by-Step Screenshots

EPFO Employer e-Sewa Data Uploading Guidelines

I have prepared EPFO Employer e-Sewa data uploading guidelines with screenshots. It may be useful to all.

Visit for more details: [link outdated-removed] (Search On Cite | Search On Google)

Regards,
KVJ Raghunath

Can anyone help me in this regard? I am attaching an error file.

Regards.

Please help; the following is the list of errors and file.

Error Details

- Member ID: Member Name, EPF Wages, EPS Wages, EPF Contribution (EE Share) due, EPF Contribution (EE Share) being remitted, EPS Contribution due, EPS Contribution being remitted, Diff EPF and EPS Contribution (ER Share) being due, Diff EPF and EPS Contribution (ER Share) being remitted, NCP Days, Refund of Advances, Arrear EPF Wages, Arrear EPF EE Share, Arrear EPF ER Share, Arrear EPS, Father's/Husband's Name, Relationship with the member, Date of Birth, Gender, Date of Joining EPF, Date of Joining EPS, Date of Exit from EPF, Date of Exit from EPS, Reason for leaving.

1. M, 6500, 6500, 780, 780, 541, 541, 239, 239, 0, 0, 0, 0, 0, 0, 26/03/12, 26/03/12, C

2. S, 6500, 6500, 780, 780, 541, 541, 239, 239, 0, 0, 0, 0, 0, 0

3. D, 6500, 6500, 780, 780, 541, 541, 239, 239, 0, 0, 0, 0, 0, 0

4. H, 6500, 6500, 780, 780, 541, 541, 239, 239, 0, 0, 0, 0, 0, 0

6. A, 2555, 2555, 307, 307, 213, 213, 94, 94, 9, 0, 0, 0, 0, 0

7. R, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

8. B, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

9. S, 3057, 3057, 367, 367, 255, 255, 112, 112, 3, 0, 0, 0, 0, 0, 28/03/12, 28/03/12, C

10. M, 2491, 2491, 299, 299, 208, 208, 91, 91, 9, 0, 0, 0, 0, 0

16. V, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

22. R, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

23. S, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

24. C, 3510, 3510, 421, 421, 292, 292, 129, 129, 0, 0, 0, 0, 0, 0

25. A, 0, 0, 0, 0, 0, 0, 0, 0, 31, 0, 0, 0, 0, 0, 31/03/12, 31/03/12, C

26. L, 0, 0, 0, 0, 0, 0, 0, 0, 31, 0, 0, 0, 0, 0, 31/03/12, 31/03/12, C

Error Codes

- (Err 002) Member ID is incorrect on data line 1
- (Err 005) EPF Wage value is incorrect on data line 1
- (Err 006) EPS Wage value is incorrect on data line 1
- (Err 007) EPF Contribution due value is incorrect on data line 1
- (Err 008) EPF Contribution remitted value is incorrect on data line 1
- (Err 009) EPS Contribution Due value is incorrect on data line 1
- (Err 010) EPS Contribution remitted value is incorrect on data line 1
- (Err 011) Diff EPS & EPF Contribution due data is incorrect on data line 1
- (Err 012) Diff EPS & EPF contribution remitted data is incorrect on data line 1
- (Err 013) NCP days data is incorrect on data line 1
- (Err 014) Refund advance data is incorrect on data line 1
- (Err 015) Arrear EPF wages data is incorrect on data line 1
- (Err 016) Arrear EPF EE share data is incorrect on data line 1
- (Err 017) Arrear EPF ER share data is incorrect on data line 1
- (Err 018) Arrear EPS share data is incorrect on data line 1
- (Err 019) Either Father or husband name contains more than 85 Characters or Contains special characters on data line 1
- (Err 020) Relationship value is incorrect on data line 1
- (Err 021) DOB is incorrect on data line 1
- (Err 024) Gender value is incorrect on data line 1
- (Err 025) DOJ EPF is incorrect on data line 1
- (Err 27) DOJ EPS is incorrect on data line 1
- (Err 29) DOE EPF is incorrect on data line 1
- (Err 31) DOE EPS is incorrect on data line 1
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving have some value data line 1
- (Err 29) DOE EPF is incorrect on data line 2
- (Err 31) DOE EPS is incorrect on data line 2
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving have some value data line 2
- (Err 29) DOE EPF is incorrect on data line 9
- (Err 31) DOE EPS is incorrect on data line 9
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving have some value data line 9
- (Err 29) DOE EPF is incorrect on data line 15
- (Err 31) DOE EPS is incorrect on data line 15
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving have some value data line 15
- (Err 29) DOE EPF is incorrect on data line 16
- (Err 31) DOE EPS is incorrect on data line 16
- (Err 36) Date of Exit EPF Mandatory If Reason of leaving have some value data line 16

Regards,

Asmita

Your file is really useful for us to prepare online PF returns.

Regards,
Ganesh Waghchoure.

Thank you for sending the information. I am already using eSewa, but the main problem I am facing is after filling all 16 columns, how can I replace the text in column 9 with #~#? I have tried many alternatives, but without success. Please help me.

Thank you.

Notes on Provident Fund ECR Uploading

This Excel file contains a macro that creates a text file used for uploading the Provident Fund ECR. Enable macros and enter data in the sheet called 'FINAL'. Be aware of the data validation rules mentioned in the 'ref2' sheets. I have incorporated some of them into the Excel sheet itself. Run the macro 'createtextfile' from this ('FINAL') sheet. You will be prompted for a name for the text file to be generated. Save the text file in a location suitable for upload.

Regards.

I have successfully uploaded the text file created using the test data. There seems to be something wrong with your data. Please find attached the text file generated by the test data, which was accepted without errors.

Regards.

How can we incorporate employees' voluntary PF contributions in this format?

Regards,
Rakesh Sharma

How can we incorporate employees' voluntary PF contribution in this format? Requesting you to please guide me on this.

Regards,
Rakesh Sharma

I want to know the following details:

How to Submit ESI Contribution Online Every Month

1. I want to know the procedure.

How to Submit PF & P. Tax Contribution Online Every Month

Please guide me.

Thanks & Regards,
Mrunal Tembe

Hi all, this month, we generated the PF challans through the E-tool and sent them to the bank. The bank personnel mentioned that they need the TRRN number compulsorily. Where can we obtain that number? Also, is it mandatory to upload the data in E-sewa for the generation of challans? Kindly revert to me!

Regards,
Nagaraj

I followed your guidelines and was able to upload the ECR successfully. Only one error occurred. At the Bangalore SBI Main branch, where we used to remit PF challans, they are insisting on ECR and are not accepting manual challans.

Regards,
Bhavan

I recently obtained information about E-Sewa after submitting the March-12 P.F. Challan. Can I register in April-12? If so, how can I submit the annual return and complete other necessary processes? Please provide me with the relevant details.

Thanks,

RAMA
[Phone Number Removed For Privacy Reasons].

I need one clarification on whether we have to submit the monthly return from April 2012 onwards as we used to do before.

Regards,
Bhavan

Thanks to all for sharing their views. Due to that, I am able to prepare EPFO Employer e-sewa data uploading. But please, can someone tell me if, in case of any mistake in any of the fields other than the amount, can we edit that field online?

Thanks,
Vikash Sharma

Dear Seniors,

How do I enter the exit data of the members for the previous month, i.e., for the members who left during March in the wage month of April 2012, since we could not upload the exit details in the wage month of March? As per e-SEWA, the exit data should be uploaded only for the wage month. I would be grateful if seniors could clarify the above.

Regards,
Karunakaran

I have a problem with the ECR Excel file. Actually, I want to add arrears in the ECR format. There are four columns for arrears: arrear wages, arrear EPF EE share, arrear EPF ER share, and arrear EPS. If an employee's arrears for the month of April in basic is 533, how can I segregate it into the four columns? Please help me.

Thanks & Regards,
Vikas Yadav

Issue with Uploading Exit Details for Deceased Employee

I am facing an issue. I need to upload the exit details of an employee who passed away in June 2012. We have already submitted returns for June 2012. However, the ECR upload will not display the name of the deceased employee in July 2012. Can anyone assist me with how to upload the exit details of members online?

Regards,
Vivek

Nope, it didn't work out. I even talked with the PF guys, and they looked puzzled. According to their software policy, you can only upload exit details of an employee who left in the wage month for which the challan is being deposited. The way out given by the PF guys was that we don't need to mention the exit details now, and we will include the exit details in Form 10 when the family member of the employee fills out the form for the PF amount payout.

Dear Rajesh, your file is working perfectly, and it is very useful. Thank you so much. However, I am unsure how to make it work with Windows 7, as this file seems to work only with Windows XP. Please help me. I hope you can reply soon.

Respected sir,

One of my employees passed away on 14/02/2018. He had taken sick leave from 01/11/2017 to 15/02/2018 under ESIC. I made a mistake by not uploading his data for the last three months in the PF ECR. What can I do? Please help me. I am waiting for your reply.

Thank you.