Do you need an editor that will let you make that last-moment edit and Chart Salary Record For Free? Then you're on the right track! With DocHub, you can easily apply any needed changes to your document, no matter its file format. Your output files will look more professional and compelling-no need to download any heavy-wight software. You can use our editor at the convenience of your browser.
When using our editor, stay reassured that your sensitive information is encrypted and kept from prying eyes. We adhere to major data protection and eCommerce regulations to ensure your experience is secure and enjoyable at every point of interaction with our editor! If you need assistance with optimizing your document, our professional support team is always ready to answer all your questions. You can also take advantage of our advanced knowledge hub for self-guidance.
Try our editor today and Chart Salary Record For Free with ease!
Hello Viewers today we will learn how to make salary sheet or Payroll or Payslip in excel Let start now. First you need to create payhead for salary sheet As you can see above You must know about the payhead of salary sheet or Payroll Start entering data for Salary sheet type s.no, empname designation and basic salary for employee Calculate DA for basic salary which is 10% of basic salary Drag it down to copy it bellow Now calculate HRA which is 8% of basic salary Drag it down to copy it bellow Calculate PF which is 14% of basic salary Drag it down to copy it bellow Now findout the Gross Salary By adding DA+HRA+PF this will be equal to gross salary second method to add the DA HRA and PF Now find EPF which is half of PF Now find LIC which is half of EPF EPF and LIC are the deduction of Employee which is to be subtracted from gross salary So Net salary will be equal to Gross salary -deduction So viewer you learn how to make a salary sheet in excel If you like my videos kindly SUBS