PF ECR file in Excel on the ₹25,000 ceiling: a month's working, with an AI agent

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?

  1. 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.
  2. 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.
  3. 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).
  4. EDLI wages equal EPF wages.
  5. 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.
  6. Put the days not paid in NCP days and use the month's earned wages, not the full-month figure.
  7. 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

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.

The message in SlackBuild October 2026's PF ECR for Mahalaxmi Forgings from the payroll register, check it against HR's draft file and give me the challan total by account head. Don't upload or pay anything.
Slack request to build October's PF ECR from the payroll register and check it against HR's draft, with three files
The request with the three files. The agent uploaded and paid nothing.

What the agent did

  1. 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.
  2. 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.
  3. 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.
  4. 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).
  5. 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.
The agent's findings from its first reply: EPS paid for a non-member and for a member who turned 58, and two loss-of-pay days left out
From its first reply: EPS for a non-member and for someone who turned 58, and two LOP days left out. We didn't check its claim that the portal blocks EPS over 58.

What it found

What changed in HR's ECR, after two follow-ups
MemberProblem in HR's draftFix
Arvind DodiyaUAN twiceDelete the second line
Dilip BhattEPS ₹2,083 for a non-memberEPS 0; employer's ₹3,000 to EPF
Hardik ChauhanEPS 0 for a member since 2011EPS ₹2,083 on ₹25,000
Vipul MakwanaEPS after turning 58 on 1 OctoberEPS 0; employer's ₹1,620 to EPF
Ketan Solanki2 LOP days not reportedNCP 2; EPF wages ₹13,920
Tushar VyasStill capped at ₹15,000EPF wages ₹21,600
Challan₹2,33,284 in HR's draft₹2,32,470
The agent's wrong answer that the PF wage ceiling for October 2026 is ₹15,000 and that a ₹25,000 cap has no basis
Follow-up 1, wrong: it held to the 2014 ceiling of ₹15,000 and said ₹25,000 had no basis.
John's follow-up naming the September 2026 notification, and the agent confirming the ₹25,000 ceiling after checking it
Follow-up 2, with the notification named: it looked it up and switched to ₹25,000.
The agent's PF challan by account head on the ₹25,000 ceiling: ₹2,32,470 against HR's ₹2,33,284
The challan after follow-up 2: ₹2,32,470. Its employer and pension heads are ₹3 off the sums of its own file; the total is right.

What you still check

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