Every month an HR or accounts team works out Provident Fund (PF) and Employees' State Insurance (ESI) for every employee, checks the wage ceilings, prepares the ECR file for the EPFO portal and the contribution sheet for ESIC, and pays both by the 15th. Done in spreadsheets, one wrong formula or one missed new joiner shows up as a penalty, a mismatch or an employee complaint. Payroll software turns this into a repeatable routine: set the rules once, process attendance, and the system calculates, validates and produces the files.
This guide explains exactly what the software calculates, what it needs from you, and the checks to run before you lock payroll.
Why manual PF and ESI calculation goes wrong
Most errors come from the same few places:
- Wrong wage base. PF is calculated on PF wages (basic plus dearness allowance and retaining allowance), not on gross salary. ESI is calculated on gross wages. Mixing the two is the most common mistake.
- Ceilings applied inconsistently. The pension (EPS) share is capped at the statutory wage ceiling, and ESI coverage depends on a gross wage limit. A formula copied down a sheet rarely handles every case.
- Loss-of-pay days. PF and ESI should be on wages actually earned for the month, so unpaid leave must reduce the base before contributions are worked out.
- Joiners and leavers. Mid-month joiners, exits, and employees who cross the ESI limit mid-year need special handling.
- Re-typing into portals. Copying figures into the ECR template invites transposition errors and UAN mismatches.
Inputs the software needs: wage heads, PF wages and ESI wages
Automation starts with a correct salary structure. In Netmore HRMS each earning head is marked once:
| Salary head | Part of PF wages? | Part of ESI wages? |
|---|---|---|
| Basic | Yes | Yes |
| Dearness allowance | Yes | Yes |
| HRA | No | Yes |
| Conveyance / special allowance | Usually no (check your policy) | Yes |
| Overtime | No | Yes |
| Annual bonus | No | No |
You also record each employee's UAN, ESI IP number, date of joining, whether they are a PF member, and whether PF is restricted to the ceiling or paid on full PF wages. Once this is in place, nobody needs to remember the rules each month.
How the monthly calculation runs - employee and employer shares
After attendance and leave are finalised, the payroll run works out earned wages for the month and then applies the contribution rules. The rates most establishments apply are:
- PF - employee: 12% of PF wages.
- PF - employer: 12% of PF wages, split into 8.33% to the pension scheme (EPS), capped on the statutory wage ceiling of ₹15,000 (so at most ₹1,250 a month), with the balance going to the employee's PF account. EDLI and administrative charges are added on top.
- ESI: applies to employees whose gross wages are within the ESI limit (₹21,000 a month at the time of writing). Employee 0.75% and employer 3.25% of gross wages.
Rates, ceilings and definitions of wages are revised from time to time, including under the new labour codes - always confirm the current notifications from EPFO and ESIC. Good software lets you change a rate in one place and applies it from a date.
A worked example: an employee earns basic + DA of ₹14,000 and gross wages of ₹19,500 with no unpaid leave. PF employee share is 12% of ₹14,000 = ₹1,680. Employer EPS is 8.33% of ₹14,000 = ₹1,166, and the rest of the employer's 12% (₹514) goes to EPF. Because gross is under the ESI limit, ESI is 0.75% of ₹19,500 = ₹147 (employee, rounded up) and 3.25% = ₹634 (employer). The software does this for every employee in seconds, with the rounding rules each scheme expects.
Wage ceilings, new joiners and leavers
These are the cases where software saves the most time:
- EPS ceiling: pension is calculated on the lower of PF wages and the ceiling; the remainder of the employer share goes to EPF automatically.
- Restricting PF: if your policy restricts PF to the ceiling for higher earners, the employee setting does it without manual overrides.
- ESI contribution periods: ESI runs in two six-month contribution periods. An employee covered at the start of a period generally stays covered for that period even if their wages rise above the limit - the software tracks this so you don't drop them by mistake.
- Joiners and exits: partial-month wages, date of exit and reason for leaving are carried into the ECR, so the portal records stay clean.
Generating the ECR file and ESI contribution sheet
Once payroll is locked, the system produces the ECR text file in the format the EPFO unified portal accepts, with UAN, member name, gross wages, EPF wages, EPS wages, EDLI wages and each contribution. Upload it, generate the challan and pay. For ESI it produces the monthly contribution sheet with IP numbers, days worked and wages, ready for the ESIC portal. Registers and summaries are saved with the payroll, so an inspection months later takes minutes, not days.
Because Netmore HRMS also posts payroll to Tally, Busy or Dynamics 365 Business Central, the same figures reach your books without re-typing.
Checklist before you lock payroll
- Attendance, leave and loss-of-pay days are approved for every employee.
- New joiners have UAN and ESI IP numbers; exits have a date and reason.
- The PF wages and ESI wages columns match the salary-head rules in your policy.
- Employees near the ESI limit are covered correctly for the current contribution period.
- The variance report against last month is reviewed - large changes are explained.
- ECR and ESI files are generated from the locked payroll, not from a copy.
With the rules in the software, this checklist is a fifteen-minute review instead of a two-day exercise.
Frequently asked questions
Can payroll software calculate PF on full basic instead of the ceiling?
Yes. Each employee can be set to contribute on full PF wages or on wages restricted to the statutory ceiling, and the software applies the choice every month.
Does the software create the ECR file for the EPFO portal?
Yes. After payroll is locked it generates the ECR text file with UAN-wise wages and contributions, ready to upload on the unified portal.
What happens when an employee crosses the ESI wage limit?
The software keeps the employee covered until the end of the current ESI contribution period and stops deductions from the next period, as the ESI rules require.
How long does it take to switch from spreadsheets?
Most organisations run their first parallel payroll within two to three weeks - salary structures and employee data are imported, rules are set once, and the first month is checked against your existing sheet.