Paid days = Present + Leave with wages, from the muster roll (H counts ½, D counts 2). Basic = Paid days × Per-day salary. OT pay = OT hours × Per-day ÷ 8. PF = PF % × Basic (capped at the PF wage ceiling), rounded to the rupee. ESI = ESI % × Gross, rounded up, only when Gross is within the ESI wage limit. Net pay = Gross − PF − ESI − PT (professional tax, typed each month) − Advance / deductions. Tick or untick PF / ESI on each department row, or under an employee's name for individual exemptions. The PF and ESI boxes start with the calculated amount; type a figure to use your own amount for that month (clear the box to go back to the calculation). Payslips, the PDF and the Excel use exactly the amounts shown here. Changing a per-day salary here also makes it the default for that employee in later months. Only you and your Editors can see this tab.