Payroll Report
Net pay = monthly salary − (per-day rate × days marked absent). Half-day and leave entries don't reduce pay in this simple calculation — adjust the formula below to match your own policy.
| Employee | Monthly Salary | Days Absent | Deduction | Net Pay |
|---|---|---|---|---|
| Deepa Nair (EMP-005) | ₹19,000.00 | 0 | −₹0.00 | ₹19,000.00 |
| Harish Gupta (EMP-006) | ₹18,000.00 | 1 | −₹580.65 | ₹17,419.35 |
| Imran Qureshi (EMP-004) | ₹36,000.00 | 1 | −₹1,161.29 | ₹34,838.71 |
| Neelam Arora (EMP-007) | ₹24,000.00 | 0 | −₹0.00 | ₹24,000.00 |
| Pooja Menon (EMP-003) | ₹27,000.00 | 1 | −₹870.97 | ₹26,129.03 |
| Ritu Malhotra (EMP-001) | ₹42,000.00 | 0 | −₹0.00 | ₹42,000.00 |
| Sameer Kulkarni (EMP-002) | ₹28,000.00 | 0 | −₹0.00 | ₹28,000.00 |
| Total Net Payout | ₹191,387.09 | |||