Key Features:
S.No.
Pay Slip No.
Pay Date
Employee ID
Employee Name
Department
Designation
Basic Salary
Allowances
Overtime
Gross Salary
Deductions
Net Salary
Payment Mode
Transaction ID
Payment Status
Month
Remarks
Formulas:
S.No.
=ROW()-4
Gross Salary
=H5+I5+J5
Net Salary
=K5-L5
Total Pay Slips
=’Pay Slips’!B108
Total Gross Salary
=’Pay Slips’!B109
Total Deductions
=’Pay Slips’!B110
Total Net Salary
=’Pay Slips’!B111
Paid Slips
=’Pay Slips’!B112
Pending Slips
=’Pay Slips’!B113
