Follow the step-by-step guidelines to accomplish this. Now, you need to create the salary sheet for the company.

Suppose, you have a dataset of a company for 10 employees’ names and basic salaries along with the company’s structure database.

Make a Salary Sheet in Excel with Formula: Step-by-Step Procedures Net Payable Salary = Gross Salary – Deductions And, as a result, you will get the net payable salary to an individual employee. In this component, these deductions are calculated for each employee on the base of their basic salary and the salary structure database’s deduction percentage.įinally, in this portion, the deduction is subtracted from the gross salary. There are some deductions like tax, provident fund, insurance, etc. Consequently, the basic wage and the total allowances are summed up to calculate the gross salary. For example, the allowances are the house rent allowance, transport allowance, flexible benefits plan, etc. In this portion, we calculate the allowances distinctively for each employee. Besides, It contains the information about which deductions are cut from the salary and how much of the salary. Like which allowances the company provides and how much. Here, the salary structure is also declared. This component is comprised of the employee database which means the employee’s name and their basic salary. You can discretize the salary sheet in mainly four components. Upon these calculations, gross salary and net payable salary are calculated and recorded. The basic wage of an employee, extra allowances, and deductions are recorded here. A salary sheet is a report where the net payable amount as salary to an employee is recorded.

Salary slip excel format download