HOW TO GENERATE AUTOMATIC SALARY SLIP USING EXCEL FORMAT?

Posted on 31st Jul 2018 | 7348 views

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

Automatic Salary Slip Generator

Salary slip is a document with complete details of the salary of the employee a payslip generator is used by the employer for generating the salary information and record of the salary that needs to be paid /or already paid it to calculate the salaries of the employees in the company mostly the salary slip is generated by the human resource department of the company. payroll assistants or automatic salary slip generator needs to manage salary details of the employee which include.

Automatic Salary Slip Generator

Following components

1. Employee code

2. Employee name

3. Department

4. Basic pay

5. Dearness allowance

6. House rent allowance

7. Travel allowance

8. Conveyance

9. Leave details

10. Provident fund

11. Other allowances

12. Other deductions

13. Salary paid for the month

With the help of the automatic salary, slip generate the salaries of multiple employees can be calculated within minutes it generates of the salaries of employees of the company and also a salary slip of every individual employee,

It consists of the 3 different sheets

a. Employee database

b. Consolidation sheet

c. Employee salary slip

Employee database

TOTAL GROSS SALARY

TOTAL DEDUCTIONS

Consolidation sheet

Salary Slip Generator Excel

1 Comments on HOW TO GENERATE AUTOMATIC SALARY SLIP USING EXCEL FORMAT?

Comment as a guest:

user profile image
KAMLESH SINGH
806 days ago

in insert field not shown heads only shows F2 ,F3.......F24

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

<