One sheet for your whole team for the month. Type each person's pay and paid days. Earned pay, PF, ESI and net pay work out by themselves.
Free · No sign-up · Room for 50 employees
The first rows of the Excel file, for a month with 31 days.
| Employee | Paid days | Gross (full month) | Earned gross | Overtime | PF | ESI | PT | Advance | Net pay |
|---|---|---|---|---|---|---|---|---|---|
| Rahul Singh | 30 | 20,000 | 19,355 | 0 | 1,394 | 146 | 200 | 1,000 | 16,615 |
| Priya Sharma | 31 | 30,000 | 30,000 | 0 | 1,800 | 0 | 200 | 0 | 28,000 |
| Anil Verma | 29 | 15,000 | 14,032 | 1,200 | 1,010 | 115 | 0 | 500 | 13,607 |
| Sunita Devi | 31 | 11,000 | 11,000 | 0 | 0 | 83 | 0 | 0 | 10,917 |
Priya earns more than ₹21,000, so there is no ESI. Her basic is above ₹15,000, so PF stops at ₹1,800. Sunita is not in PF.
Yellow columns are for you to type. White columns work out by themselves.