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

From India, Solan

Attached Files (Download Requires Membership)
File Type: xls ECR EPF March. 2012.xls (23.5 KB, 7150 views)

Dear All, But this sheet is not working. actually we are facing problem in date format. can any one help us.
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,
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,
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,

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

From India, Bareli
Hi any body help me....i could nt upload ECR format in PF portal.........showing continuously not supported...
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..............

From India, Solan
Dear All, Please find attached ECR Sheet and process sheet of PF . Thanks You, Regards, J.N.Modi
From India, New Delhi

Attached Files (Download Requires Membership)
File Type: pdf ProcessFlowECR.pdf (1.73 MB, 433 views)
File Type: pdf EPFO Eseva data uploding Guidlines[1].pdf (1.65 MB, 301 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server