Question: How Do I Convert Excel To ECR?

What is ECR salary?

he EPFO has introduced a new field called ‘Gross Wages’ in the ECR.

From our understanding, this refers to the Gross pay of an employee, including all salary heads / components that are paid to the employee..

How is PF administration charges calculated?

EPF Administration charges, also to be rounded up to the next value. Employer to remit @ 0.5% of contributions (subject a minimum of Rs….Option 1.ParticularsEmployeeEmployerEPS Contribution-15000 x 8.33% = 1250EDLIS Contribution-15000 x 0.5% = 75EPF Administrative Charges-18000 x 0.5% = 901 more row

How do you convert Excel to txt file for EPF?

How to Upload PF Return NotepadCopy paste PF File Format in separate excel file.Fill with data of salary sheet and pf no sheet (check format from help sheet)File → Save as → CSV format in pf return folder.Close CSV file.Right Click CSV file → open with notepad.Make changes in notepad like.File → Save as → PF Return Notepad.

How can I upload ECR Challan?

Step By Step Process To File ECR Version 2.0 On EPFO Unified Web Portal:Step 4: Select your ECR text file to be uploaded.Step 5: Select the remaining fields like File Type (Select ECR), Contribution Rate % (Default value is 12%), add comment, and click on Upload Button:More items…

How do I open an ECR file?

Five Steps to Open ECR FilesStep 1: Double-click the file. Locate the ECR file icon and double-click it. … Step 2: Look for another program. … Step 3: Check the file type. … Step 4: Get help from a developer. … Step 5: Find a universal file viewer.

What is ECR file?

ECR stands for Electronic Challan cum Return. This is an electronic monthly return to be uploaded by the employers through the Unified Portal.

What is ECR Challan?

ECR stands for Electronic Challan cum Return. It is an electronic monthly return to be uploaded by employers through the Employer e-Sewa portal. … The approval of uploaded ECR will result in the generation of a Challan using which the employer has to remit the dues through online payment.

How is PF Challan calculated?

PF admin charges are the contribution from the employer’s end. It is calculated on the basis of your Basic+DA from your salary. … In addition to 12% of employer PF/PS contribution, the employer also has to pay other charges.

How is PF amount calculated?

Break up of the Contribution RateEmployees’ Basic Pay + DA: Rs 50000.Employee contribution towards EPF: 12%*50000 = Rs 6000.Employer contribution towards EPF = 3.67% of 50000 = 3.67%*50000 = Rs 1835…. ( … Employer contribution in Employee Pension Scheme (EPS): 8.33% * 50000 = Rs 4165 …. (More items…•

How can I cancel EPF payment online?

you have to login then go to payment option you will get sub menu ecr/ return filing click on that then cancel your prepared challan.

How do I convert an Excel file to ECR?

Steps to Create Text File. First, open the ECR file excel format and fill all the details. Now, go to save as and choose CSV(Comma Delimited) under save as type and save the file. Once, the file is successfully saved as CSV, go to the destination folder and open it with notepad.

How can I file ECR in EPF?

3. Steps for PF Payment OnlineEnsure PF details of establishment such as establishment ID, Name, address, exemption status etc shown are correct.From ‘Payment’ option drop down select ‘ECR upload’Select ‘Wage Month’, ‘Salary Disbursal Date’, Rate of contribution and upload ECR text file.More items…•

How can I revise ECR?

For revising the erroneous ECR files the employer will have to submit a request letter along with the duly signed revised ECR generated through e-sewa portal. The total amount of the revised ECR generated should match with the erroneous ECR and should include the unaltered details of the settled members.