Short answer: Since 17 September 2026 the PF wage ceiling is ₹25,000 a month. EPF wages are earned basic plus DA up to that cap; EPS wages are the same for EPS members under 58 and zero for everyone else; EDLI wages equal EPF wages. Put the 11 fields in a #~# text file, one line per UAN, and check it against payroll before you upload. An AI agent can do the check, but it may not know a rule this new.
The ECR is a plain text file, but every line carries five decisions: the wage cap, EPS membership, age, days not worked and whether the UAN is already in the file. One wrong line and the challan is wrong, or the portal rejects the file.
Here is the method from a recent tutorial, then an agent checking HR's October draft for a 60-person forging company. It stuck to the old ₹15,000 ceiling until it was shown the new notification.
The tutorial this is based on
October 2026 PF ECR Sheet Kaise Banaye? | EPF Calculation for HR by HR with Rajat Sir, published 31 October 2026 (in Hindi). Builds the October sheet in Excel on the ₹25,000 ceiling and turns it into the upload file. It takes basic as 50% of gross, which is a shortcut, and doesn't cover members aged 58, admin and EDLI charges or the due date; we added those.
How do you make the PF ECR file in Excel?
- Lay out the 11 ECR columns: UAN, name, gross wages, EPF wages, EPS wages, EDLI wages, EPF contribution, EPS contribution, the employer's EPF share, NCP days and refund of advances. Add a helper column for members who are already in EPS.
- EPF wages are earned basic plus DA, capped at ₹25,000 a month from 17 September 2026 (S.O. 5109(E) under the Code on Social Security, 2020). The cap was ₹15,000. The video takes basic as 50% of gross with =ROUND(MIN(C2*50%,25000),0); use the real basic plus DA if you have it.
- EPS wages equal EPF wages for EPS members under 58. They are zero for people who are not EPS members, such as those who joined after September 2014 above the old ceiling, and for anyone who has turned 58. The video's formula: =IF(OR(C2*50%<=25000,L2="Y"),D2,0).
- EDLI wages equal EPF wages.
- The employee's EPF is 12% of EPF wages and EPS is 8.33% of EPS wages. The employer's EPF share is the difference.
- Put the days not paid in NCP days and use the month's earned wages, not the full-month figure.
- Paste as values, delete the header, save as CSV, replace each comma with #~# and check that no UAN appears twice. Upload against the month's challan and pay by the 15th: A/c 1 (both shares), A/c 2 admin at 0.50% of EPF wages (minimum ₹500), A/c 10 pension, A/c 21 EDLI at 0.50%, A/c 22 nil.
Where it usually goes wrong
- The old ₹15,000 cap still in a formula or the payroll settings.
- EPS paid for someone who isn't an EPS member.
- EPS left at zero for a member who has been in EPS for years.
- EPS paid for someone who turned 58.
- Loss-of-pay days not reported as NCP days, with full-month wages.
- The same UAN twice in the file.
How an AI agent does it from Slack
We gave the agent three files for a made-up Rajkot forging company, Mahalaxmi Forgings, with 60 employees: October's payroll register with each member's UAN, dates of birth and joining, EPS flag and days paid; HR's draft ECR text file; and HR's challan summary. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.
What the agent did
- Compared the payroll register with HR's draft ECR line by line, wrote a new ECR file and a workbook, and uploaded and paid nothing.
- Found a UAN twice in HR's file, EPS paid for a non-member and for a member who turned 58 on 1 October, and two loss-of-pay days reported as a full month.
- Used the old ₹15,000 ceiling for pension and EDLI wages while capping EPF wages at ₹25,000 for some members, and left one member's EPF wages at ₹15,000. Its challan was ₹2,30,027.
- When asked which ceiling applies and which notification sets it, it said ₹15,000 under the 2014 notification and that ₹25,000 had no basis, and redid everything on ₹15,000 (₹1,91,160).
- Given the September 2026 notification, it looked it up, redid the file on ₹25,000 and listed the six changed lines, including an EPS member HR had left at zero. Its 60-line file matches ours line for line. The challan is ₹2,32,470 against HR's ₹2,33,284.
What it found
| Member | Problem in HR's draft | Fix |
|---|---|---|
| Arvind Dodiya | UAN twice | Delete the second line |
| Dilip Bhatt | EPS ₹2,083 for a non-member | EPS 0; employer's ₹3,000 to EPF |
| Hardik Chauhan | EPS 0 for a member since 2011 | EPS ₹2,083 on ₹25,000 |
| Vipul Makwana | EPS after turning 58 on 1 October | EPS 0; employer's ₹1,620 to EPF |
| Ketan Solanki | 2 LOP days not reported | NCP 2; EPF wages ₹13,920 |
| Tushar Vyas | Still capped at ₹15,000 | EPF wages ₹21,600 |
| Challan | ₹2,33,284 in HR's draft | ₹2,32,470 |
What you still check
- The wage ceiling in your payroll software and formulas. The agent used ₹15,000 until it was given the notification.
- Each member's EPS status in the EPFO record. The EPS rules are still being amended after the new ceiling, so check EPFO's latest circulars.
- That the challan heads add up from the ECR lines. The agent's employer and pension heads were ₹3 off its own file.
- The portal's validation of the file before you pay. You upload the ECR and pay by 15 November yourself.
Questions accountants ask
What is the PF wage ceiling now?
₹25,000 a month from 17 September 2026, under S.O. 5109(E) of the Code on Social Security, 2020. It was ₹15,000. At 12%, the most an employee contributes is ₹3,000 a month. Check EPFO's circulars for the pension rules, which are still being amended.
What is the ECR file format?
A text file with one line per member and 11 fields separated by #~#: UAN, name, gross wages, EPF wages, EPS wages, EDLI wages, EPF contribution, EPS contribution, the employer's EPF share, NCP days and refund of advances. No header row.
Does the agent upload the ECR or pay the challan?
No. It builds the file and the challan figures. You upload the ECR and pay the challan yourself. It asks before it changes or submits anything.
Hand this job to an agent
Bring one of your own files to a 30-minute call and watch an agent do it.
Book a 30-min demo