How to make salary sheet || Payroll or Payslip in excel 2016

In this Tutorial you will learn how to make salary slip or salary sheet in excel 2016, also you will be able how to make payroll system in excel for employees.
thanks for watching, subscribe my channel for more videos...
   / yadonlinetrainingacademy  
=====================================================================
IF YOU ARE NEW TO THIS CHANNEL, Please 😊 Like ❤️ Subscribe & turn 🔔 notifications on! Thank you for watching!
=====================================================================
Website
https://yadonline.blogspot.com/
Facebook
  / kpcomuterskills  
=====================================================================
Complete Ms-Excel Course Tutorials
   • Five Common Excel Errors and how to f...  
========================================================================
Download Excel File from the link given bellow
https://drive.google.com/open?id=1agw...
========================================================================
Pay Head in Payroll are given bellow
DA
The Dearness Allowance (DA) is a cost of living adjustment allowance paid to Government employees, Public sector employees (PSU)and pensioners. Dearness Allowance is calculated as a percentage of basic salary to mitigate the impact of inflation on people.
EPF/PF
The Employee Provident Fund, or provident fund as it is normally referred to, is a retirement benefit scheme that is available to salaried employees. Under this scheme, a stipulated amount (currently 12%) is deducted from the employee's salary and contributed towards the fund.
=====================================================================
Use the following formulas in Payslip or Payroll
DA formula = basic salary * 10/100
House Rent = Basic Salary * 8/100
PF = Basic Salary * 12/100
Gross Salary =Basic salary + DA + House Rent + PF
EPF = PF / 2
LIC = EPF/2
Deduction = EPF + LIC
Net salary = Gross Salary - Deduction
=====================================================================
Resume Templates Microsoft word
   • Professional Resume Writing and Desig...  
=====================================================================
How to create Question paper in Microsoft word
   • How to create question paper in ms wo...  
====================================================================
Advance Excel formulas and Functions
   • Five Common Excel Errors and how to f...  
====================================================================
Complete Course of Accounting through tally erp 9
   • How to Install Tally erp 9 software o...  
======================================================================

#payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe