How Do You Calculate Payroll in Excel with a 50% Salary Cut Due to COVID-19?

sneha-rawat
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?
sneha-rawat
I would like to know the basic practice or formula to be followed while calculating salaries with an 80% or 70% pay cut due to the COVID-19 outbreak.

Regards,
Sneha
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute