EPF Calculation in Excel (12% + EPS Split)

Q: Is EPF 12% of basic or gross?

12% of **Basic + DA** (plus retaining allowance), not full gross. Many employers cap it on the ₹15,000 wage ceiling.

🧮 Prefer a quick answer? Try our free EPF calculator — instant, no sign-up.

Last updated: 27 June 2026 · Rates current as of April 2026; wage ceiling still ₹15,000.

EPF in Excel is calculated as 12% of (Basic + DA) from the employee and 12% from the employer. The employer's 12% is split into 8.33% to the pension scheme (EPS) and 3.67% to EPF — with EPS capped on a ₹15,000 wage ceiling, so the maximum EPS contribution is ₹1,250 per month. A single column with =ROUND(MIN(BasicDA,15000)*12%,0) gives the employee share; two more columns split the employer side.

Key takeaways

Employee EPF: 12% of Basic + DA.
Employer 12% splits: 8.33% to EPS (pension) and 3.67% to EPF.
EPS is capped on a ₹15,000 wage, so EPS ≤ ₹1,250/month; the employer's EPF share is the balance.
EDLI: 0.50% of Basic+DA, capped at ₹75/month per employee.
Admin charges: 0.50% of Basic+DA, minimum ₹500/month per establishment.
The ₹15,000 ceiling is a parameter — keep it in a Settings cell in case it is revised.

Fact box. Of the employer's 12% EPF contribution, 8.33% goes to the Employees' Pension Scheme (EPS) and 3.67% to the provident fund. EPS is calculated on a maximum wage of ₹15,000, so it cannot exceed ₹1,250 per month regardless of actual salary. (Source: EPFO.)

How is EPF calculated in Excel?

Set Basic + DA in a cell (call it BasicDA). The standard formulas, with the ₹15,000 ceiling applied, are:

Contribution	Formula	Result on ₹20,000 Basic+DA
Employee EPF (12%)	`=ROUND(MIN(BasicDA,15000)*12%,0)`	₹1,800
Employer EPS (8.33%)	`=ROUND(MIN(BasicDA,15000)*8.33%,0)`	₹1,250
Employer EPF (3.67%)	`=ROUND(MIN(BasicDA,15000)*12%,0)-EPS`	₹550
EDLI (0.50%)	`=MIN(ROUND(MIN(BasicDA,15000)*0.5%,0),75)`	₹75

If your establishment contributes on actual wages above ₹15,000, drop the MIN(...,15000) wrapper and use BasicDA directly.

Tip: Compute the employer EPF share as total 12% minus EPS rather than a flat 3.67%. This avoids a 1-rupee rounding mismatch where 8.33% + 3.67% don't add exactly to 12% after rounding.

Why split EPF into EPS and EPF?

The split decides how the employer's money is allocated. The 8.33% EPS portion funds the employee's pension; the 3.67% EPF portion adds to the provident-fund corpus the employee withdraws later. The employee's own 12% goes entirely to the provident fund.

Because EPS is capped at ₹1,250 (8.33% of ₹15,000), any employer contribution above that cap flows into the EPF account instead — which is why the 3.67% share grows for higher-paid employees if you contribute above the ceiling.

Fact box. EDLI (Employees' Deposit-Linked Insurance) is 0.50% of Basic+DA, capped at ₹75 per month per employee, and admin charges are 0.50%, with a ₹500 monthly minimum per establishment — both paid by the employer on top of the 12%. (Source: EPFO. These are long-standing figures consistent across EPFO sources; verify against the EPFO portal before filing if in doubt.)

What is the total employer cost of EPF?

The employer pays more than 12%. On Basic+DA at the ₹15,000 ceiling:

Item	Rate	Amount (₹15,000)
Employer EPF + EPS	12%	₹1,800
EDLI	0.50% (cap ₹75)	₹75
Admin charges	0.50% (min ₹500)	₹75*
Total employer EPF cost		≈ ₹1,950

*Admin charges are 0.50% but subject to a ₹500/month establishment minimum, so the per-employee figure depends on headcount.

How to build the EPF columns step by step

Add a BasicDA helper column (Basic + DA).
Put the ceiling (15000) and rates (12%, 8.33%, 0.50%) on a Settings sheet.
Add Employee EPF = =ROUND(MIN(BasicDA,15000)*12%,0).
Add Employer EPS = =ROUND(MIN(BasicDA,15000)*8.33%,0).
Add Employer EPF = employer total 12% − EPS.
Add EDLI and Admin columns for the full cost.
Total the columns for your monthly ECR challan.

How Ankeshan helps: Ankeshan computes the EPF split, EDLI and admin charges inside Excel and assembles the ECR-ready totals, with the wage ceiling as a parameter that updates if EPFO revises it. (Launching soon — join the waitlist.)

Frequently asked questions

Is EPF 12% of basic or gross? 12% of Basic + DA (plus retaining allowance), not full gross. Many employers cap it on the ₹15,000 wage ceiling.

What is the maximum EPS contribution per month? ₹1,250 — which is 8.33% of the ₹15,000 EPS wage ceiling.

Is the EPF wage ceiling still ₹15,000 in 2026? Yes, as of mid-2026 the ceiling remains ₹15,000. A revision to ₹21,000 is under active review (the Supreme Court has directed EPFO to decide on this), but no notification has issued as of mid-2026. Keep the ceiling as an editable parameter on your Settings sheet so you can update it when a revised notification is published.

Who pays EDLI and admin charges? The employer, on top of the 12% — EDLI at 0.50% (cap ₹75) and admin charges at 0.50% (₹500 monthly minimum per establishment).

Sources

EPFO — epfindia.gov.in (contribution rates, EPS/EPF split, EDLI, admin charges, wage ceiling).

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.