Employee Salary Slip Format Excel {2020 Tracker}

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

Note: Update Sheet of Attendance (2020 Year)

This template consists of a set of 5 worksheets, which ensure recording and calculating accurately and instantly. This is prepared in an 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.

  1. Microsoft Excel Sheet (2020 Calender)
  2. Absent and Holidays Tracker includes
  3. PTO Tracker Linked with this sheet
  4. Small business best employee attendance tracker
  5. Ask for more customization
  6. Help in creating Payroll

Let’s take a look at these spreadsheets:

Key Features of Employee Salary Slip

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:

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

How to Create Employee Salary Slip Format?

Check out some useful article on the employee management system, as a project manager I strongly recommend you.

Settings of Template

To help you save time and effort, a separate spreadsheet for the settings is added to the template. Here you are able to make changes according to your company and it will be helpful when filling the employee datasheet 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)
  • Create Monthly sheet easily, Weekly base salary require some customization

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:

  1. Employee ID, name and designation and employee net salary which fills automatically.
  2. Monthly working days and present days. These must be filled manually and absent days will be added automatically.
  3. Daily working hours must be filled manually.
  4. Total required hours and total monthly hours will be generated automatically.
  5. Enter overtime in hours manually and overtime hourly 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

Printable Salary Slip Layout

This is 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 with all the other data of the employee salary.

So if you have any questions regarding employee data, then you should reply to us for customization requests. Template124 Team always ready for your support.

Relevant Template: Time-Sheet Tracker of Employee

Just One click and system ready any particular employee data instantly. Different type of designing options is also available for you on request only. You can request us VIA Commenting or Direct Email.

Premium quality small business management template in multiple format of Microsoft Excel. Production plan to inventory and project management template according to market situation. Contact with us Facebook - Google Plus

Leave a Reply

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.