[13]
Hello Viewers today we will learn how to make salary sheet or Payroll or Payslip in excel
[22]
First you need to create payhead for salary sheet
[44]
You must know about the payhead of salary sheet or Payroll
[52]
Start entering data for Salary sheet
[66]
type s.no, empname designation and basic salary for employee
[115]
Calculate DA for basic salary which is 10% of basic salary
[124]
Drag it down to copy it bellow
[131]
Now calculate HRA which is 8% of basic salary
[143]
Drag it down to copy it bellow
[157]
Calculate PF which is 14% of basic salary
[166]
Drag it down to copy it bellow
[170]
Now findout the Gross Salary
[175]
By adding DA+HRA+PF this will be equal to gross salary
[194]
second method to add the DA HRA and PF
[225]
Now find EPF which is half of PF
[249]
Now find LIC which is half of EPF
[261]
EPF and LIC are the deduction of Employee which is to be subtracted from gross salary
[273]
So Net salary will be equal to Gross salary -deduction
[287]
So viewer you learn how to make a salary sheet in excel
[291]
If you like my videos kindly SUBSCRIBE MY CHANNEL
