epf arrear ecr file format in excel download

If the employee salary is above 15000 Rs, still the employee and employer can contribute to the EPF scheme based on their mutual interest.įor employers, they must have minimum 10 or above employees to register their establishment under EPFO scheme 1952.Įvery employee whose monthly gross salary is below 21000 Rs will be eligible for ESIC scheme.įor employers they must have 10 or above 10 employees to register their establishment under ESIC scheme 1948.

So overall 4% of employee gross salary will be paid towards ESIC account in every month.Įvery employee whose monthly basic wage + Dearness Allowances (DA) is below 15000 Rs will become eligible for the EPF scheme. ESI Calculation Formula Percentages 2021 ESI calculated on EPF ECRFile ARREAR EPF CALCULATIONHOW TO CREATE ARREAR ECR TEXT FILE FOR EPF.

Note: If there is no DA then only basic wage is considered to calculate the EPF monthly contributions. Click Here To Download New PF ECR File Format in Excel Sheet norfolk. So total employee will contribute 12% of basic wage + DA for PF and employer will pay 13% towards employee PF and pension accounts together. PF Calculation Formula Percentages 2021 PF calculated on Not only employees even employers can also use the above format to calculate the monthly contributions of employees towards PF and ESI.

The above excel format is updated as per the latest EPF and ESIC calculation formulas. Another main difference is the gross wages entry, in the old ECR format there is no need to add gross wages but in the new ECR file, we employer has to show the gross wages of employees also.Download PF & ESI Calculation Excel Format 2021 The major differences in Old ECR format and the new UAN-based format are Universal Account Number, in the ECR text file 2 version UAN is mandatory in the old format we don’t need to add a UAN number. The latest ECR text file contains 11 fields, you can find the below to the table to know what details you need to enter in each field of ECR version 2.0 Excel. If is there any advance taken by the employee from the PF account, then he can repay that amount here. Noncontribution period days of employee i.e absenteeism days. Generally it 3.67% of employer contribution towards PF, when the basic wage of an employee is greater than 15000 then it will automatically calculate the PF contribution of employer This is also new in the ECR file, here we have to add the gross wages of employees Here we have to put the UAN number of the employee New Excel Format For Upload EPF Monthly Return & KYC File Format Xls Download New ECR 2.0 File.xls.

Epf arrear ecr file format in excel download