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
Acknowledge(0)
Amend(0)
14From India, Bareli
Acknowledge(0)Amend(0)
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,
From India, Solan
Acknowledge(0)Amend(0)
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,
From India, Solan
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
0
0
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The issue with the sheet is due to the date format. You need to ensure the date format aligns with the requirements for proper functionality. (1 Acknowledge point)
0
0
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
Acknowledge(0)Amend(0)
0
0
From India, Solan
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The information provided is partially correct. In addition to the methods mentioned, ECR file for uploading on Employer E Seva is typically done through the EPFO portal online.
0
0
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
Acknowledge(0)Amend(0)
0
0
From India, Solan
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-[The user reply does not address the query about preparing the ECR file for uploading on Employer E Seva. It focuses on changing date formats in a text file, which is not the requested information.]
0
0
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
From India, Bharuch
Acknowledge(2)Amend(0)
0
0
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
From India, Bharuch
Acknowledge(2)Amend(0)CiteHR.AI
(Fact Checked)-The formulas provided for EPF Wages, EPS Wages, EPF Cont, EPF Cont (EE share remitted), EPS cont due, EPS cont. being remitted, Diff EPF & EPS, and Diff EPF & EPS being remitted are correct. The admin charges of 1.1%, 0.5%, and 0.01% should be included in the calculation separately. It's advisable to verify the specific requirements for admin charges in the ECR Instructions. (1 Acknowledge point)
0
0
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
Acknowledge(0)Amend(0)
0
0
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
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user reply contains some inaccuracies regarding EPS wages, EPS contribution, and administrative charges. Kindly refer to the EPF Act for accurate details.
0
0
Hi any body help me....i could nt upload ECR format in PF portal.........showing continuously not supported...
From India, Madras
Acknowledge(0)Amend(0)
0
0
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The issue might be due to the file format. ECR must be in text format, not PDF. Ensure correct data and try again.
0
0
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,
From India, Solan
Acknowledge(1)Amend(0)
0
0
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,
From India, Solan
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Checked)-The information provided in the user reply is correct and relevant for preparing the ECR file for uploading on Employer E Seva. Thank you for sharing your insights. (1 Acknowledge point)
0
0
Dear All, Please find attached ECR Sheet and process sheet of PF . Thanks You, Regards, J.N.Modi
From India, New Delhi
Acknowledge(0)Amend(0)
0
0
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply does not provide the requested ECR file for uploading on Employer E Seva. It only mentions an ECR sheet and process sheet of PF without the required format. Thank you for sharing the information.
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
EPF Sheet of Employees(ECR). xls
EPF Compliance Instructions For Establishments With Multiple Branches For ECR Filing.pdf
CiteHR.AI
(Fact Checked)-The user's reply is [B]correct[/B]. Thank you for providing clear steps on preparing the ECR file. Your guidance will help others navigate the process effectively. (1 Acknowledge point)