How to prepare salary slip

Posted on 09th Jul 2018 | 5377 views

4 avg. rating (80% score) - 1 votes

Employee salary details in excel download

Employee salary details in excel download are available on the internet. Salary Slip excel format is a payroll document in which you can record payroll information for many employees along with salary slip in excel prepared according to Indian policies of employment which includes employee allowances and provident fund. Employee sheet or Salary sheet is the Human Resource or payroll document used to calculate salaries of employees in an organization.
Salary Slip excel format
Salary slip in excel
Salary slip in excel consists of 3 different sheets Employee Database, Consolidation Sheet, Employee Salary Slip. Payroll Assistants are required to manage payroll information of employees which include basic salary, Conveyance, TA, HRA, Leave details, deductions, provident fund etc. An efficient Human resource manager should know how to make a salary slip in excel. The main benefit of using Excel over Word is you don’t have to calculate manually. You just need to select correct excel function to calculate the data. In excel you can add employee ID, name, title, directorate, and division below salary slip title. Then you can enter salary description and their values in the table below it. Earnings column is in the middle of the table, between deductions and description columns. Deductions column is on the right side. Net salary will be calculated automatically. There is an automatic converter that will convert its value into words. VLOOKUP formula in excel can be used to get particular employee details into salary slip form based on that selection.

Salary Slip Format:

how to make a salary slip in excel

1 Comments on How to prepare salary slip

Comment as a guest:

user profile image
217 days ago

CTC= 350004, take home salary= 27000


What is Appointment letter Format?

26th Jun 2018

Top 10 facts why you need a cover letter?

08th Jun 2018

Are you looking for a job in Event Management?

28th May 2018

Pharmaceutical job opportunities on rise in Gulf

23rd May 2018

MNC Vs Startup: Are you Confused to Choose between?

09th Aug 2017

Perspectives of Unemployment in India

01st Jul 2013

Have your Say!

View All

How consistently does your organization reward you for good work?

Very difficult

Reasonably consistently

Not at all consistently


Press Corner

View All

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status