EPFO Employer e-sewa data uploading Guidelines - annual returns
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

EPFO Employer e-sewa data uploading Guidelines

kvjraghunath Started The Discussion:

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: (Human Resources Info) at http://www.hrinfo.in


Attached FilesProvided by community member kvjraghunath. Join us to learn and grow with your peers.
File Type: pdf EPFO Eseva data uploding Guidlines.pdf (1.65 MB, 2290 views)
sunil_0012 - Contributing Member
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.

kvjraghunath - Contributing Member
Dear Sunil, You need to remove the Header line when you are uploading text file in portal. KVJ Raghunath

kvjraghunath - Contributing Member
Dear all

Please find the small tool for Convert Excel Spreadsheet To CSV Format file

And

2nd Method – Using Google Docs Spreadsheet for Convert Excel Spreadsheet To CSV Format file

This method is the most easiest and in fact doesn’t require any tool at all. Just head over to Google Docs and login with your Google account. Click New and select Spreadsheet.

The downside of using this tool is that only XLS format can be converted, it doesn’t support the latest XLSX format.


This will open a new window where you will find the spreadsheet. Now click File and then select Import.

You can import the following format, .xls, .xlsx, .ods, .csv, and .txt. Click choose file and select the Excel Spreadsheet you want to convert. Once importing is done, hit Open Now link.


Once your new spreadsheet is open, click File, select Download As, and choose CSV format.

Once your new spreadsheet is open, click File, select Download As, and choose CSV format.


KVJ Raghunath


Attached FilesProvided by community member kvjraghunath. Join us to learn and grow with your peers.
File Type: zip xls2csv.zip (56.9 KB, 728 views)
sanagapalli - Contributing Member
Thank you Mr Raghunath. Plz mail updates frequently for awareness to others, regards venkataratna s

anilrsv sharma - Contributing Member
Dear Raghunath Very good information & explanation too. A lot of compliments to u. Regds, ANIL

sateeshsl - 
Hi Use E-Return Tool for and u can easy to upload and no age calculations for EPS and EPF wage.....

Dear All Can anyone help me in this regard. I am attaching a error file.


Attached FilesProvided by community member VEDPRAKASH SINGH. Join us to learn and grow with your peers.
File Type: txt HRKNL38360000_1334138972_err.txt (647 Bytes, 194 views)
y123-56 - Contributing Member
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

dear raghu your file is really useful for us to prepare online PF Returns. ganesh waghchoure.



Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


4
LIKES

9884
VIEWS

43
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network