How can prepare the ECR file for uploading on Employer E Seva. If anybody have any formate with example, pls provide us. Mukesh Kumar Saini
9th April 2012 From India, Bareli
Dear Mukesh,
This is very simple and easy to prepare the ECR file, just login into the employer portal and download the ECR Instructions.
The format is attached for your ready reference, delete the first row when you enter the whole data then save the excel file as comma delimited, then replace all "," with "#~#" as per instruction file.
Hope above will help you.
regards,
10th April 2012 From India, Solan

Attached Files
Membership is required for download. Create An Account First
File Type: xls ECR EPF March. 2012.xls (23.5 KB, 6971 views)

Dear All, But this sheet is not working. actually we are facing problem in date format. can any one help us.
10th April 2012 From India, New Delhi
The challan can be submitted by both ways i.e. through bank SBI ( by cheque or DD) or by online SBI Net Banking................ regards,
10th April 2012 From India, Solan
For change in date format you can change the format to dd/mm/yy instead of dd-mm-yy in the txt file by searching the same..... regards,
10th April 2012 From India, Solan
Dear Mr. Rana,
Kindly give us the formula for each column
I have given the formulas as given belwo, pls tell me if it is correct:-
EPF Wages - Basic + DA
EPS Wages _ Basic + DA
EPF Cont (EE Share ) - 12%
EPF Cont (EE share remitted) -12%
EPS cont due - 8.33%
Eps cont. being remitted - 8.33%
Diff EPF & EPS - 3.67%
Diff EPF & EPS being remitted - 3.67%
Pls let us know where we should mention the admin charges of 1.1%, 0.5% & 0.01% resp.
Kindly reply ASAP
Thanks & regards,
Vinita

10th April 2012 From India, Bharuch
Dear Vinita,
EPF Wages - Basic + DA ok
EPS Wages _ Basic + DA There is celling Rs.6500.00
EPF Cont (EE Share ) - 12% ok
EPF Cont (EE share remitted) -12% ok
EPS cont due - 8.33% 8.33% up to 6500.00, maximum EPS amount 541.00
Eps cont. being remitted - 8.33% See above comment
Diff EPF & EPS - 3.67% If basic and DA =<6500 than ok
Diff EPF & EPS being remitted - 3.67% See above comment
Pls let us know where we should mention the admin charges of 1.1% (of EPF Wages - Basic + DA), 0.5% (EPS Wages _ Basic + DA) & 0.01% (EPS Wages _ Basic + DA) resp.
Mukesh Kumar Saini
11th April 2012 From India, Bareli
Hi any body help me....i could nt upload ECR format in PF portal.........showing continuously not supported...
12th April 2012 From India, Madras
Dear Vinita,
All formulas seems okay except the following:-
1) EPS wages = if(basic+da>6500,6500,basic+da)
2) Diff EPS & EPS = EPF Cont (EE Share )- EPS cont due - 8.33% i.e. 3.67% but sometimes higher due to 8.33% on max. 6500.
The admin charges A/c 2 @ 1.1, A/c 21@ 0.5% on Max, 6500/-and A/c 22 @ .01% are to be calculated mannually and will be enter later when you proceeded for ECR upload.
Hope the above will help you..............
Regards,
14th April 2012 From India, Solan
Dear All, Please find attached ECR Sheet and process sheet of PF . Thanks You, Regards, J.N.Modi
14th April 2012 From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: pdf ProcessFlowECR.pdf (1.73 MB, 414 views)
File Type: pdf EPFO Eseva data uploding Guidlines[1].pdf (1.65 MB, 288 views)

you can this excel utility you have to enable macro
14th April 2012

Attached Files
Membership is required for download. Create An Account First
File Type: xls ecr_filing_utility.xls (81.0 KB, 448 views)

HI,
This is a big THANKYOU for Mukesh Saini..for the detailing out the epf and eps details.Its all there in the form, but it was a little hard to understand..for a lay person like me... Thanks a lot..
Cheers!!
Anu
14th April 2012 From India, Thiruvananthapuram
Hai, I have one doubt in created the challan. Can you clear with me? After the challan creation, in my challan there is no entry in adminstration charges. we only need to fill that charges ah?
18th April 2012 From India, Madras
Dear Friends, Can anybody explain the difference between E-return tool application and E - Sewa. Rupan K S
23rd April 2012 From India, Madurai
Hai Mukesh Kumar
I m quite confuse to prepare the text file with the specified ECR Format because for the employee's who are under non EPS what's the content for EPS Contribution due. Also i need the formula to calculate the columns content like EPF Contribution due,Eps contribution Due etc.Will you please post ur uploaded file it would really helpful for us. Waiting for ur post........

23rd April 2012 From India, Madurai
Dear All,
Please note that after generating and submitting the ECR in bank, we also need to file the monthly return i.e. Form12 A, 5/10 to the concerned office until you receive any letter of discontinuity from the deptt.
regards,
24th April 2012 From India, Solan
Dear Sir That is as per the regular submission of forms we done for earlier months continue with our corresponding office.
24th April 2012 From India, Madurai
Dear ashi kumar rana

If you see

Dear Employers !!

EPFO Launches online receipt of Electronic Challan cum Return (ECR) from the Month of April 2012 (March paid in April). Employers are requested to Register their establishments and create their user id and password through this portal. The registered employers can upload the Electronic Return and the uploaded return data will be displayed through a digitally signed copy in PDF format. It will be available for printing also. Once approved by the employer online Challan will be popped based on uploaded return. The employer may choose to make the payment through internet banking of SBI or take a print out of the Challan and pay at any designated branch of State Bank of India (SBI).

Benefits:

> No paper return to be prepared and submitted to EPFO.

> No need to submit other returns viz Form 5/10/12A,3A and 6A.

> Employers will get the confirmation of payment through SMS instantly.

> The contribution will be credited to the members' account on monthly basis.

> Employers can view the annual accounts slip for accounting year 2011-12 online.

> For earlier years employers can request for the annual slips through this portal.

Employer Registration starts from 20.03.2012
5th May 2012 From India, Delhi
dear all, this is the simplified format for epf ecr txt file to generate.... hope ur work will b easy ..
5th May 2012 From India, Hyderabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls ECRfile_Template_version1.2.xls (95.5 KB, 401 views)

Hi sir i JAKIR hUSSAIN I WANT TO EPF E-SEWA ECR HOW TO PREPAER I HAVE TAKE A PART TIME IN RETURNS OF EPF PLEASE HELP ME PLEASE SEND ECR EXCEL FORMET
31st May 2012 From India, Hyderabad
Dear Mukesh,
If you are not using a payroll software I will advice you to use one
Our Payroll Software Intellipayroll helps HR in all e-Submissions including
PF ECR, TDS 24QR and ESIC.
www.IntelliPayroll.com
7th June 2012 From India, Pune
actually me also facing same problem. refer the ecr file format demo.
we should do the extra thing.even the date of joining&relieving like all the date formats should be in text. just try it and upload the file.
7th August 2012 From India, Madras
Dear Sir/Madam, Kindly provide details of on leave employee wage month how mention details of employee. Regards, Vinay KUmar
13th June 2013 From India
Dear members...
We are doing the EPF, ESI related works of various organisation on Outsourcing basis. The work like ECR preparation from Raw data, Recover the old data lost on E-Return Tool, ESI Challan preparation(Excel file upload), conversion of PDF documents to word or excel file, data entry...etc. So please contact me for any of the related works mention above @ low charge.
Regards:
Arun Vignesh N
Executive-HR & Personnel

+91-8220826676
30th October 2013 From India, Coimbatore
hi frnds i am a employer how to create a pf challan and upload the challan i need full information of pf and also formulas.
27th July 2016 From India, Bengaluru
i need full information of how to create pf challan and upload, edit and all please give me the formats of pf. i am a employer i dont know english very well . kannada dali helidare thumba upayoga
27th July 2016 From India, Bengaluru
i need full information of how to create pf challan and upload, edit and all please give me the formats of pf.
i am a employer i dont know english very well . kannada dali helidare thumba upayoga
Posted Today
27th July 2016 From India, Bengaluru
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™