Salary Slip Format in Excel and Word

Advertisements

What is a salary slip? How to create a salary slip in excel? We will guide you and provide you Salary Slip Format and Templates for free download. Salary Slip Sample in Excel includes all the functions for Companies, Organizations, Institutions, and Factories for their employees. Free Download Salary Slip/wage slip Templates in Excel and Word Format from links at the bottom.

Directions for Use of Salary Slip

Download the attached files of Salary Slip in your desired format in MS Excel or Ms word from the bottom links. If the download link is not showing at the bottom, please copy, and paste the below salary slip in a word or excel sheet. Put the desired values in the amount column. You can change, add, or delete the items as per your requirements for your employees. MS Excel format makes auto calculations, so it needs to add or put your desired values in the relevant columns. After adding values, your salary slip is ready to be printed on plain paper and get signed by the relevant authorities.

Download Salary Slip Format in Word

Company Name                         Pay Advice for January (Date)
Employ#____   Name________                         Department_______Designation________ Salary for __ Days__________
Pay & AllowancesDeductionsOther Details
Basic_______
House Rent_______
Conveyance_______
C.L.A._______
Medical_______
Other All_______
Special_______
Over Time_______
Arrears______
Bonus______
PF-Counter______
Other DED 2______
EOBI-DED______
PF Count Bal______
Gross        _________Total DED    _______Net ________
Salary Credited to Your Account#                            _______________
Bank Name   ___________                             Branch______________

_______     ___________   ____________

Accountant            Finance Manager              Chief Executive

Print/Image views of Salary Slip Format in Excel

Prints/Image views of Salary Slip Format in MS Word

Functions, and Options in the Salary Slip:

Salary Slip format for employees includes all options like Basic Salary, House Rent, Conveyance Allowance, Medical Allowance, Special Allowance, Over Time, Bonus, Arrears, Tax, and Others Section to mention any special amount. These Salary Slip Formats also include a deduction section where you can deduct amounts like PF, Counter, Other DED 2, EOBI, and Security deduction options with tax deduction facilities. You can use our salary slip in MS Excel with a formula for auto calculations and MS Word for manual calculations.

If you need more options with auto calculation just write in the below comment form.

You will also learn how to make the salary slip in excel and word with the latest tax calculations from the above samples.

Purpose of Salary Slip

Salary Slip is a business document issued by companies to the employees and staff with a monthly salary. It is proof that the company has paid the salary, including all the allowances and tax deductions. The employer keeps a copy of the salary slip for the future record, and the employee can keep it as a record and present it for negotiations on new jobs.

This can also be used as a legal document with a company stamp and signature in case of need in lawful requirements and labor courts to settle disputes with employers/employees. Normally, it also includes tax deduction details of tax-paying employees. The employees should keep it in the record for the income tax department and submit tax returns.

Salary Slip Download Links:

  1. Download Salary Slip in Excel Format Free
  2. Download Salary Slip in Word Format Free

How to Use Salary Certificate Format in Mail Merging?

Please download the Ms. Format, put all your data into Excel Sheet, and use the mail merging function of Microsoft Word. We will post more details with the Image tutorial to create salary certificates for employees, company employees, and staff members.

For More Salary Slip Templates Click Here

Suppose you have modified our templates and want to share them on our site. Please send your templates to this email: info@semioffice.com, or if you need any help to modify this template, you can write in the below comments form. We love to hear from you.

41 thoughts on “Salary Slip Format in Excel and Word

  1. thts very helping
    but its take much time to entries
    is it possible that we make a database and on one click print the salary slip of all employee
    thnx

    • Thanks for your query. You can use it with mail merging function of MS Word. In next week we will try to post how this salary slip can be used for mail merging. Best

Please Ask Questions?