Salary Slip Format in Excel and Word

What is a salary slip? How to create a salary slip in excel? We will guide you and provide you with a free download of Salary Slip Format and Templates. 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 the links at the bottom.


Directions for the 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 into a Word or excel sheet. Put the desired values in the amount column. You can change, add, or delete the items per your company’s requirements. 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.

Salary Slip Format or Template

A salary slip is a document that shows an employee’s salary details for a specific period, usually a month. Here is an example of a salary slip format:

[Company Logo]

Salary Slip for the month of [Month/Year]

Employee InformationEarningsDeductions
Employee NameBasic Salary[amount]Tax[amount]
Employee IDOvertime[amount]Health Insurance[amount]
DepartmentBonus[amount]Provident Fund[amount]
Date of PaymentAllowances[amount]Other Deductions[amount]
Total Earnings[amount]Total Deductions[amount]
Net Salary[amount]

In this example, the salary slip is divided into four sections. The first section contains the employee’s basic information, such as their name, employee ID, department, and the date of payment.

The second section lists the earnings that the employee is entitled to receive for the month. This may include their basic salary, any overtime pay, bonuses, and allowances.

The third section lists the various deductions that are subtracted from the employee’s gross pay. These may include taxes, health insurance contributions, provident fund contributions, and any other deductions that the employee has authorized.

The final section lists the total earnings, total deductions, and the net salary amount that the employee will receive for the month.

It’s important to note that the information included in a salary slip may vary depending on the country or region and the company’s policies.

Print/Image views of Salary Slip Format in Excel

salary slip format for companies and employees available in excel for free download

Prints/Image views of Salary Slip Format in MS Word

Salary slip format for companies and employees available in ms word for free download

Functions and Options in the Salary Slip:

The 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 Other sections 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

A salary Slip is a business document issued by companies to 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 future records, 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 modifying this template, you can write in the below comments form. We love to hear from you.

Author: David Beckham

I am a content creator and entrepreneur. I am a university graduate with a business degree, and I started writing content for students first and later for working professionals. Now we are adding a lot more content for businesses. We provide free content for our visitors, and your support is a smile for us.

42 thoughts on “Salary Slip Format in Excel and Word”

  1. Can you please send me the Salary Slip, Payslip, bank payment voucher Format in Excel and Acknowledgement Receipt in word

  2. 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

    1. 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

Leave a Reply to ratikantCancel reply