Dear All,

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

KVJ Raghunath

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

From India, Vijayawada
Attached Files (Download Requires Membership)
File Type: pdf EPFO Eseva data uploding Guidlines.pdf (1.65 MB, 6439 views)

Acknowledge(0)
Amend(0)

Can you tell me why when I try to enter member ID as 7 and EPF wages/EPS wages as 5000, it shows an invalid entry? Is this the wrong way to enter the member ID and EPF wage? Also, does the ECR file include column headings like member ID, member name, EPF wage, EPS wage, EPF contribution due, etc.?
From India, Delhi
Acknowledge(0)
Amend(0)

Dear Sunil, You need to remove the Header line when you are uploading text file in portal. KVJ Raghunath
From India, Vijayawada
Acknowledge(0)
Amend(0)

Dear Raghunath Very good information & explanation too. A lot of compliments to u. Regds, ANIL
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Use E-Return Tool for and u can easy to upload and no age calculations for EPS and EPF wage.....
From India, Hyderabad
Acknowledge(0)
Amend(0)

Dear All Can anyone help me in this regard. I am attaching a error file.
From India, Gurgaon
Attached Files (Download Requires Membership)
File Type: txt HRKNL38360000_1334138972_err.txt (647 Bytes, 602 views)

Acknowledge(0)
Amend(0)

Dear sir,

Please help following is the list of errors and file.

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

(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

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

dear raghu your file is really useful for us to prepare online PF Returns. ganesh waghchoure.
From India, Pune
Acknowledge(0)
Amend(0)

Dear Raghunath,

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.

From India, New Delhi
Acknowledge(0)
Amend(0)

Notes: This Excel file contains Macro which creates text file which is used for uploading Provident Fund ECR.
Enable Macros, Enter data in sheet called' FINAL’. Be aware of the data validation Rules mentioned in the 'ref2' sheets. I have incorporated some of them in excel sheet itself. Run the macro ‘createtextfile’ from this('FINAL's)Sheet .You are prompted for a name for text file to be generated. Save the text file in a location suitable for upload.

Attached Files (Download Requires Membership)
File Type: xls ECR FILING UTILITY.xls (81.0 KB, 644 views)

Acknowledge(0)
Amend(0)

The Excel file I tried to fill and submit had errors in PF as shown below:

Err 001) Data field count is incorrect on data line 1
(Err 001) Data field count is incorrect on data line 2
(Err 001) Data field count is incorrect on data line 3
(Err 001) Data field count is incorrect on data line 4
(Err 001) Data field count is incorrect on data line 5
(Err 001) Data field count is incorrect on data line 6
(Err 001) Data field count is incorrect on data line 7
(Err 001) Data field count is incorrect on data line 8
(Err 001) Data field count is incorrect on data line 9
(Err 001) Data field count is incorrect on data line 10
(Err 001) Data field count is incorrect on data line 11
(Err 001) Data field count is incorrect on data line 12

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

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.
Attached Files (Download Requires Membership)
File Type: txt jk1.txt (8.1 KB, 143 views)

Acknowledge(0)
Amend(0)

Dear Sir, as per your instruction with excel file ecr filing utility, when i am run with macros the error show "Run time error 75" what should i do?
From India, New Delhi
Acknowledge(0)
Amend(0)

Dear all members, To day we have generated on line EPF challans for our 4 clients. Raju Consultancy Bangalore
From India, Bangalore
Acknowledge(0)
Amend(0)

Hi, How we can incorporate employees Voluntary PF contribution in this formate? Regards, Rakesh Sharma
From India, Chandigarh
Acknowledge(0)
Amend(0)

Hi, How we can incorporate employees Voluntary PF contribution in this formate? Request you please guide me on this. Regards, Rakesh Sharma
From India, Chandigarh
Acknowledge(0)
Amend(0)

Hi,

I want to know the following details:

1. How to submit ESI contribution online every month. I want to know the procedure.
2. How to submit PF & P.Tax contribution online every month.

Please guide me.

Thanks & Regards,
Mrunal Tembe

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

HI Is it compulsory to submit PF annual returns thru online...... please upload csv format of form 3A and 6A for online purpose..... Thanks in advance Sateesh Kumar Hyderabad
From India, Hyderabad
Acknowledge(0)
Amend(0)

HI can any one suggest the EPF online ECR online format i have registered my establishment after how to prepare the ECR format pls help me & send the soft copy
From India, Mumbai
Acknowledge(0)
Amend(0)

Complete Web-Based Payroll and Hrms Software

Change is Choice...

To do better, you need to change the conventional ways of dealing; Innovation is part of that change.

Accent Consulting brings you the software which will change the whole payroll process for the HR management.

Payroll with various module as recruitment module ,

Payroll process module

Ess module

Appraisal module

Training module

Helpdesk module

And many more.

It's powerful software which has the qualities to process all the complex calculations of Payroll like PF, ESI, PT, TDS, Leaves, Salary disbursement, Gratuity etc... in just a matter of seconds with utmost accuracy.

We take pride in saying that we have developed it with the best and the latest technology available, so that you can have a smooth and error free processing.

It doesn’t require a man on the machine to administer it. It is easy, being web-based solution you can always check from any of your computer with a click.

• Files your returns on time

• Makes PF status checking easier than ever

• Provide TDS E-Return information with a click

• Makes disbursement of Salary easy

• Generates Salary-slip

• Employees can always find their leave, salary and other details

• Provides Income Tax details & others

Now, why would you sit to calculate, plan and strategize with a pen and paper when everything is just a click away with our payroll software solution.

Change and be the Change!!

Call us on 0120-4782600 , 9999143778

regards ravi

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

Hi all,

This month, we generated the PF challans through the E-tool and sent the same 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

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

Dear Mr. Raghunath,

I followed your guidelines and could upload ECR successfully. Only one error came. In Bangalore SBI Main branch where we used to remit PF challans, they are insisting for ECR and they are not accepting the manual challans.

Regards,
Bhavan

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

Dear Mr. Raghunath i had sent you already mail regarding the issue....please help the EXCEL file you provided "ECR FILING UTILITY.XLS" always show run time error....can we talk on mobile?????
From India, New Delhi
Acknowledge(0)
Amend(0)

Dear All,

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
+918790292222.

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

Dear Mr.Raghunath I need one clarification. whether we have to submit Monthly return from April 2012 onwards as we used to do before. Regards Bhavan
From India, Bangalore
Acknowledge(0)
Amend(0)

Dear All Q : How to old payment (Feb-12) in online? A : It is very simple go to online challan entry and enter the amounts
From India, Madras
Acknowledge(0)
Amend(0)

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

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

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

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

Mr Rajesh, Does that mean I don’t have to save as csv file or replace "," with "#~#"?If these functions can be done using macros it would be great.
From India, Kozhikode
Acknowledge(0)
Amend(0)

Dear friend I have developed online excel to ecr converter on HRedp(dot)com Also provided required excel file, just go through it and make your work easy Madhav Gore
From India, Delhi
Acknowledge(0)
Amend(0)

Excellent write-up of EPFO employer e-sewa data uploading guidelines with screenshots and explanations. Keep it up. Can you please explain about the "filing of Forms 3A and 6A for the year 2011-2012" in E-Sewa?
From India, Coimbatore
Acknowledge(0)
Amend(0)

Plz attend a free programme conducted by EPF authorities at Provident Fund offices for generating challans which is very useful.
From India, Coimbatore
Acknowledge(0)
Amend(0)

Dear Raghunath Sir,

I have a problem with the ECR Excel file. Actually, I want to add arrears in the ECR format. There are 4 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 4 columns? Please help me.

Thanks & Regards,
Vikas Yadav

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

Dear All,

I am facing an issue. I need to upload the exit details of any 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

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

Furnish the number of working days as O date of leaving in dd/mm/yyyy format. Please mail me whether this is worked out correctly.
From India, Coimbatore
Acknowledge(0)
Amend(0)

Nope, it didn't work out. I even talked with PF guys and they looked questioned. 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 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.
From India, Valsad
Acknowledge(0)
Amend(0)

Dear Rajesh,
your file is working perfectly and it is very useful. Thank you so much.
But it how to work with windows 7. this file work only with windows xp. please help me. hope you should reply soon.

From India, New Delhi
Acknowledge(0)
Amend(0)

Dear Mr. Raghunath, When I run with macros the error show "Run time error 75" what should i do? Regards H Singh
From India, Raurkela
Acknowledge(0)
Amend(0)

Anonymous
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.

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

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.