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:
<link outdated-removed> ( Search On Cite | Search On Google )
Posted 10th April 2012 From India, Vijayawada
Attached Files
Shared By Cite.Community Member "kvjraghunath" For Public Download
File Type: pdf EPFO Eseva data uploding Guidlines.pdf (1.65 MB, 5541 views)
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.
Posted 11th April 2012 From India, Delhi
Dear Sunil, You need to remove the Header line when you are uploading text file in portal. KVJ Raghunath
Posted 11th April 2012 From India, Vijayawada
Thank you Mr Raghunath. Plz mail updates frequently for awareness to others, regards venkataratna s
Posted 12th April 2012 From India, Hyderabad
Dear Raghunath Very good information & explanation too. A lot of compliments to u. Regds, ANIL
Posted 12th April 2012 From India, Mumbai
Hi Use E-Return Tool for and u can easy to upload and no age calculations for EPS and EPF wage.....
Posted 12th April 2012 From India, Hyderabad
Dear All Can anyone help me in this regard. I am attaching a error file.
Posted 12th April 2012 From India, Gurgaon
Attached Files
Shared By Cite.Community Member "VEDPRAKASH SINGH" For Public Download
File Type: txt HRKNL38360000_1334138972_err.txt (647 Bytes, 500 views)
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
Posted 12th April 2012 From India, Mumbai
dear raghu your file is really useful for us to prepare online PF Returns. ganesh waghchoure.
Posted 12th April 2012 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....
Posted 12th April 2012 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.
Posted 12th April 2012 From ,
Attached Files
Shared By Cite.Community Member "rajeshprabhuk" For Public Download
File Type: xls ECR FILING UTILITY.xls (81.0 KB, 272 views)
that excel file I had tried to fill and submit got error in pf as given 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
Posted 12th April 2012 From India, Delhi
I have successfully uploaded the text file created using the test dats. There should be something wrong in your data.

Please find attched the text file geneated by the test data which was accepted without errors.
Posted 12th April 2012 From ,
Attached Files
Shared By Cite.Community Member "rajeshprabhuk" For Public Download
File Type: txt jk1.txt (8.1 KB, 118 views)
BHAVAN 
Dear Mr.Raghunath Your guidelines are very informative. Thanks for sharing. Regards Bhavan
Posted 12th April 2012 From India, Bangalore
Hi, what is ncp days can we include weekly off , esi leave and absents in this regds Ashok
Posted 12th April 2012 From India, Bangalore
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?
Posted 12th April 2012 From India, New Delhi
Dear all members, To day we have generated on line EPF challans for our 4 clients. Raju Consultancy Bangalore
Posted 12th April 2012 From India, Bangalore
Hi, How we can incorporate employees Voluntary PF contribution in this formate? Regards, Rakesh Sharma
Posted 13th April 2012 From India, Chandigarh
Hi, How we can incorporate employees Voluntary PF contribution in this formate? Request you please guide me on this. Regards, Rakesh Sharma
Posted 13th April 2012 From India, Chandigarh
Hi,

I want to know 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
Posted 13th April 2012 From India, Pune
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
Posted 13th April 2012 From India, Hyderabad
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
Posted 13th April 2012 From India, Mumbai
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
Posted 13th April 2012 From India, Delhi
Hi all,

This month we generated the PF challans through E-tool, and sent the same to Bank, bank people telling that they need TRRN no compulsary.

Where we will get that no?

and is it compulsory to upload the data in E sewa for generation of challans !
Kindly revert me !!

Regards,

Nagaraj
Posted 13th April 2012 From India, Dharwad
BHAVAN 
Dear Mr.Raghunath

I followed your guidlines 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
Posted 13th April 2012 From India, Bangalore
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?????
Posted 13th April 2012 From India, New Delhi
After using E return Tools. The ECR File is not complete. Again & Again shows Err001. Please help me.
Posted 14th April 2012 From India, Delhi
Dear All,

Actually i got information about E-Sewa after March-12 P.F Challan submition only so can i register in April-12,if so than how can i submit the annual return and other processes so please inform to me regarding as same mentioned.

Thanks.. RAMA,
+918790292222.
Posted 15th April 2012 From India, Hyderabad
BHAVAN 
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
Posted 16th April 2012 From India, Bangalore
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
Posted 17th April 2012 From India, Madras






 
 
 
 







Found This Useful? +Vote Up This 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.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright © 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network