Dear All,
I have prepared EPFO Employer e-sewa data uploading Guidelines with screen shot, it may useful to all.
KVJ Raghunath
visit for more details:
<link outdated-removed> ( Search On Cite | Search On Google )
From India, Vijayawada
42I have prepared EPFO Employer e-sewa data uploading Guidelines with screen shot, it may useful to all.
KVJ Raghunath
visit for more details:
<link outdated-removed> ( Search On Cite | Search On Google )
From India, Vijayawada
Can u tell me when I try to enter mamber id as 7
and epf wages/eps wages 5000 it shows invalid entry.
is it wrong way to enter the memeber id and epf wage.
whether ecr file include column heading like member id member name epf wage eps wage epf cont due etc.
From India, Delhi
and epf wages/eps wages 5000 it shows invalid entry.
is it wrong way to enter the memeber id and epf wage.
whether ecr file include column heading like member id member name epf wage eps wage epf cont due etc.
From India, Delhi
Dear Sunil, You need to remove the Header line when you are uploading text file in portal. KVJ Raghunath
From India, Vijayawada
From India, Vijayawada
Dear Raghunath Very good information & explanation too. A lot of compliments to u. Regds, ANIL
From India, Mumbai
From India, Mumbai
Hi Use E-Return Tool for and u can easy to upload and no age calculations for EPS and EPF wage.....
From India, Hyderabad
From India, Hyderabad
Dear sir,
please help following is the list of error 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
please help following is the list of error 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
dear raghu your file is really useful for us to prepare online PF Returns. ganesh waghchoure.
From India, Pune
From India, Pune
Dear Raghunath,,
Thanks for sending,
i am already using the esewa but the main problem which i am facing is.
after filling the 16 column completely how can i fill or replace in the text file 9 column with #~#. i have so much tried with many alternate but no success.
please help me....
From India, New Delhi
Thanks for sending,
i am already using the esewa but the main problem which i am facing is.
after filling the 16 column completely how can i fill or replace in the text file 9 column with #~#. i have so much tried with many alternate but no success.
please help me....
From India, New Delhi
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.
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.
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EPFO Eseva data uploding Guidlines[1].pd f