Download Employee Salary Slip format in Microsft excel for project manager, finance manager, automatically tracker help you to generate payslip within seconds.

This template consists of set of 5 worksheets, which ensure recording and calculating accurately and instantly. This is prepared in excel tool, which is already popular for ease of use and its user friendly features. Although the template is available in ready to use format, still you are able to make changes in it according to your preferences and company paying policy. Let’s take a look at these spreadsheets:

Employee Data

Once downloaded, this part of the template consists of the general and personal information of your employees. Your template helps you monitor and provide this information regarding your employees as well. Just fill this sheet manually and the other worksheets of the template will fill automatically based on this information. It consists of:

  • Employee ID (it is identification number of your employee, and each employee is given some specific number which must be entered here)
  • Employee name (enter first and last name of your employees here)
  • Designation (add position of your employee here)
  • Per month salary (here add basic salary of your employee as shown in agreement as well)
  • Hire date/year (add date when the employee has joined your organization)
  • Contact (add contact number of your employee here)
  • State/region (do add state and region of your employee)
  • Country
  • Address (add your employee address here)

Helpful Articles on Employees Management System

Check out some useful article on employee management system, as an project manager i strongly recommend you.

Settings

To help you save time and effort, a separate spreadsheet for the settings is added in the template. Here you are able to make changes according to your company and it will be helpful when filling the employee data sheet of the template. It consists of:

  • Designation (add all the positions available in your company here like director, Manager, HR manager, programmer, IT manager, project manager etc)
  • State/ region: (add all the states and regions of the countries, where your company is operating)
  • Country (add countries name, where your company is operating)

Employee Overtime Data

This part of the template consists of your employee overtime worked details. Most of it is filled automatically by just entering your employee ID; however some part is required to fill manually as well. It consists of:

  • Employee ID, name and designation and employee net salary which fills automatically.
  • Monthly working days and present days. These must be filled manually and absent days will be added automatically.
  • Daily working hours must be filled manually.
  • Total required hours and total monthly hours will be generated automatically.
  • Enter over time in hours manually and over time hour rate, overtime pay and absent days deductions will be added automatically in employee salary slip format excel.

Employee Salary Data

Check out your employee salary data from this sheet and it is filled automatically once you have added employee ID. It consists of:

  • Employee name and designation
  • Gross salary (without additions and deductions)
  • Tax deduction 9% (you can edit this rate)
  • Provident fund deduction 10%
  • Insurance deduction 6%
  • Absent days deduction
  • Total deduction
  • Overtime payment
  • Net salary without overtime

Salary Slip

This is the ready to use employee salary slip format for the specific month. Just enter your employee ID and it will be filled automatically, taking information from all the worksheets filled before. It is excellent for tracking and recording purpose as well as it consists of your company name and payment date as well, along all the other data of the employee salary.

So if you have any questions regarding employee data, than you should must reply us for customization request. Template124 Team always ready for your support.

Leave a Reply

Your email address will not be published. Required fields are marked *