Skip to content
TaxColony
हिन्दी

Payroll workspace

Monthly payroll run: register, payslips, PF ECR and bank file

Import your employee sheet and run the month's payroll in the browser: salary register, payslips for everyone as one PDF, the EPFO ECR text file, ESIC upload sheet and a bank transfer file.

Runs in your browserNothing uploaded or storedRules with cited sources
! Needs reviewLast verified:

1Month and company

2Employees

Drop your employee sheet (Excel or CSV)

Columns: name, UAN, ESIC no, PAN, basic, DA, HRA, special, other, LOP days, TDS, advance, state, bank account, IFSC. Monthly full-month amounts.

3Payroll for the month

EmployeeDays paidGrossPFESIPTTDS + otherNet pay
Import a sheet or load the sample.

ECR follows the EPFO ECR 2.0 text layout (fields separated by #~#). Upload it on the EPFO employer portal, which validates it. Check the ESIC and bank files against your portal's or bank's current format before uploading.

This tool is for understanding and preparation only. Results are estimates based on the assumptions shown. File on the official channels.

What it calculates

  • Pay for days worked. Each component is pro-rated for loss-of-pay days in the calendar month.
  • PF. 12% of basic plus DA, capped at the PF wage ceiling (₹25,000). Employer share is split into EPS (8.33%) and EPF. Employees above the ceiling without a UAN are left out.
  • ESI. 0.75% employee and 3.25% employer when gross is ₹21,000 or less (₹25,000 for persons with disability), rounded up.
  • Profession tax by state, and TDS and advances as you enter them.

Nothing you upload leaves your browser. Check the files against the EPFO, ESIC and bank portals, which validate them on upload.

Sources

  1. EPF Scheme, 1952 and EPFO ECR 2.0 file format
  2. ESI contribution rates (0.75% employee, 3.25% employer)
  3. Payment of Wages and state profession tax laws

Last verified: 6 Nov 2026