Return details
Saved establishments fill in automatically.
Wage rules
Salary sheet
Excel (.xlsx, .xls) or CSV. Any layout, any column order, merged headers, extra rows and totals are fine.
Members
Click a row to see its ECR line and working, and to edit it.
How the sheet was read
Rules applied
Wage ceiling. ₹15,000 up to 16 Sep 2026; ₹25,000 from 17 Sep 2026 under Ministry of Labour & Employment notification S.O. 5109(E). EPS and EDLI wages never exceed the ceiling.
September 2026. One ECR, computed in two parts as EPFO's FAQ directs: 16/30 of wages at the ₹15,000 ceiling plus 14/30 at ₹25,000. Employees outside PF until 16 Sep contribute only for 17–30 Sep; EPF-only members join EPS from 17 Sep.
PF wages. Basic + DA + retaining allowance. Under the Code on Social Security 2020, if excluded allowances exceed half of total remuneration the excess counts as wages, so PF wages are never below 50% of gross.
Contributions. Employee 12% of EPF wages. EPS 8.33% of EPS wages. Employer EPF is 12% of EPF wages less EPS. Each figure is rounded to the nearest rupee, 50 paise upward.
Age 58. When a date of birth is present, EPS stops once 58 is completed and the full employer share goes to EPF; in the month of turning 58 EPS is pro-rated to the days before the birthday.
NCP days. Whole days only, never more than the days in the month. A member with no wages is reported with NCP equal to the days in the month.
Challan. A/c 1 = employee + employer share; A/c 2 admin 0.50% of EPF wages, minimum ₹500 (₹75 with no contributing member); A/c 10 = EPS; A/c 21 EDLI 0.50% of EDLI wages; A/c 22 nil. Due on the 15th of the following month.
File. ECR 2.0 text: one line per member, 11 fields joined by #~#, whole numbers, no header. The official challan with TRRN is generated on the EPFO unified portal after this file is uploaded and approved.