epf ecr file format in excel download 2021

It will save the employer’s EPF contribution for 3 years so that they will bring more employees under EPFO scheme.

If you are registering employees for the first time in EPFO scheme i.e earlier they didn’t have any EPF accounts then the central government will pay the total employer contribution for 3 years which include both 3.67 PF contribution and 8.33% pension contribution of employer. EPF Refund to Employers Under PMRPY Scheme (Pradhan Mantri Rojgar Protsahan Yojana) PF & ESI Calculation Excel Format 2021 Download by Rajesh If you are looking for a simple and easy to use excel format to calculate your monthly PF & ESI contributions, then the below format of the excel sheet will be helpful to you. If the details in Aadhar card and EPF text file don’t match then the employer will get an error file, after correcting those errors only employer can able to generate PF numbers to the employees. 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. If their Aadhar details are wrong then tell them to correct their Aadhar details first. This is very simple and easy to prepare the ECR file, just login into the employer portal and download the ECR Instructions. Employer Contribution (Basic Salary + DA) X 3.67 X 12 months. Company Yearly Contribution: Employer or company’s contribution to EPF is 3.67 according to the EPF and MP Act. By using the fill handle function of excel, copy the formula till the end. Note: The details of the employees mentioned in the text file will be authenticated as per the details present in UIDAI, so enter the details of the employees as per the Aadhar card. Employee contribution (Basic Pay + DA) X 12 X 12 months. The upload of ECRs that are backed with remitted Challan in the EPFO application will result in the updating of member balances on a monthly basis. If you upload the ECR, there is no need to file Forms 5/10/12A, 3A, and 6A. Once the employer approves the text file then PF numbers will generated to employees. The monthly upload of ECR will relieve the employer from manual filing of returns both monthly and annually. Step 3: After uploading the text file of employees, employer needs to approve the text file.

Epf ecr file format in excel download 2021