How Do I Convert An Excel File To ECR?

How is EPF and Challan calculated?

This completes our blog of PF/EPF admin charges….Calculation of PF admin charges.Accounts of pf challanEmployer ContributionCalculationA/C no 2: PF admin account0.5%15000*0.005=75A/C no 10: EPS account8.33%15000*8.33%=1249.5A/C no 21: EDLI account0.5%15000*0.005=75Total19501 more row•Jun 5, 2018.

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

What is ECR in PF?

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

Can NCP days be zero?

NCP full form: During NCP days Pf contribution is not credited to the concerned employee PF account. Many employers fill the column of NCP days to ‘0’ and it does not pose a problem while finalizing the returns but the employer will face the risk of providing inadequate or insufficient information.

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

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.

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…•

What is meant by NCP days?

NCP days stands for “Non Contributing Period” Days. It means the days for which PF contributions has not been paid. In other words, the AB days of employee’s, for which he is not being paid and his PF contributions have not been calculated are NCP days.

How do you calculate NCP days?

It helps in calculating the days you have worked from your joining to leaving. It you have worked for 6 months, according to you, you have completed 180 days. But if the employer has entered in ECR that there were 4 NCP days in each month. So u fall short of 24 days.

What is ECR revision?

Issue of Incorrect month or year was mentioned in ECR- In the EPFO application, ECR Revision has been provided to revise ECRs where month and year needs to be changed. This can be done only if there is no settlement and no PMRPY beneficiary exists. … payment entry in the application software may be made.

What is PPO number?

Pension Payment Order or PPO number is a unique 12-digit number that helps pensioners receive their pension. It is an important number for pensioners or those individuals who are on the verge of retirement. PPO number helps in getting the pension.

How do I file an ECR?

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…