Dear Folks, please share the payroll calculation format in Excel when there is a salary cut (50%) due to the COVID-19 outbreak. Will there be any change in the gross salary, or will it be calculated on the net take-home after the necessary deduction?
Example of Salary Cut Calculation
For example, if the employer decides to pay his employee 50% of his gross salary per month till Diwali '20, please help me out with the following questions:
1. What will be his gross salary?
2. If we keep 50k as this gross salary, then 25k will be shown as what for the accounting purpose in the salary sheet?
3. How will PF, ESIC, and other statutory deductions take place?
From India, Mumbai
Acknowledge(0)
Amend(0)
Example of Salary Cut Calculation
For example, if the employer decides to pay his employee 50% of his gross salary per month till Diwali '20, please help me out with the following questions:
1. What will be his gross salary?
2. If we keep 50k as this gross salary, then 25k will be shown as what for the accounting purpose in the salary sheet?
3. How will PF, ESIC, and other statutory deductions take place?
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls
Salary calculation.doc