Simple Salary Slip Formats in Excel | Word | PDF Download

Introduction

A salary slip is an important document that records the salary details of an employee. It is a document that is issued by the employer to the employee at the end of each month. It contains details such as the employee’s name, salary amount, deductions, allowances, and other relevant information. A salary slip is an important document that is used for tax filing, loan applications, and other financial transactions.

Simple salary slip formats in Excel, Word, and PDF are available for download. These formats are easy to use and can be customized to suit the needs of the employer. They are also available in various languages, making them suitable for use in different countries. With these formats, employers can easily generate salary slips for their employees in a matter of minutes. They are also useful for tracking employee salaries and other financial information.

Simple Salary Slip Formats in Excel | Word | PDF Download

Salary slip formats are used to record the salary details of employees. They are used to track the salary payments made to employees and to ensure that the correct amount is paid to each employee. Salary slip formats can be used in both paper and electronic formats.

In Excel:

Excel is a popular spreadsheet program that can be used to create salary slip formats. Excel allows users to easily enter data into cells and create formulas to calculate the total salary amount. Excel also provides a range of formatting options to make the salary slip look professional.

In Word:

Word is a popular word processing program that can be used to create salary slip formats. Word allows users to easily enter data into tables and create formulas to calculate the total salary amount. Word also provides a range of formatting options to make the salary slip look professional.

In PDF:

PDF is a popular file format that can be used to create salary slip formats. PDF allows users to easily enter data into fields and create formulas to calculate the total salary amount. PDF also provides a range of formatting options to make the salary slip look professional.
[ad_1]

Salary slip is also called Payslips. Salary slips consist of the salary details of the employees, which include earnings like basic wage, HRA, Conveyance allowances, medical allowances, special allowances, and deductions like EPF, professional tax, TDS, loan recovery details.

Here are some simple salary slip formats for private companies which you can download in Excel, Word, and PDF formats.

Simple Salary Slip Format 1

Salary slip format in excel download free

Salary Slip Format 2

Salary slip format in excel download

Salary Slip Format 3

salary slip in India word format free download

Salary Slip Format 4

Simple salary slip format in india PDF formats free download
Download above payslip format in Excel with formulas Download
Download Excel format without formulas Download
Download Word format Download
Download PDF format Download

Salary Slip Format India without PF and ESI in Excel

Salary slip without PF and ESI in Excel

Other Salary Slip Formats

SALARY SLIP IN EXCEL (FORMAT 1)

Salary slip format in excel with formulas download

SALARY SLIP IN EXCEL (FORMAT 2)

Salary slip format in excel auto generate

How to Create a Salary Slip in Excel

Step 1: To create a salary slip/pay slip open a new Excel sheet and write your company name, address, and payslip month & year in the first three rows of the Excel file.

Step 2: Now enter employee general details like name, designation, department, date of joining, gross salary, bank details, and any other required information as per your choice.

Step 3: Now enter the number of days in the month, and LOPs (Loss of Paydays) of the employee. To calculate total paid days subtract LOPs from total days in the month.

Step 4: Now in one column add all the earnings of the employees such as basic wage, house rent allowances, conveyance allowances, medical allowances & special allowances. Calculate them based on total paid days. The sum of all the earnings will be called the actual gross salary of the employee.

Salary calculation formula for the total paid days = (Original gross salary/Total days in the month) X Paid days in that month.

Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, and salary advances, etc…

Important Components on Salary Slip

S no Earnings Deductions
1 Basic Wage (40-50% of Gross Wage) EPF (12% of basic wage)
2 HRA (40% of the basic wage for nonmetro cities) Professional Tax
3 Conveyance Allowances ( 1600 Rs in urban areas) TDS
4 Medical Allowances (1250 Rs) Health Insurance / TDS
5 Other(Special) Allowances (Balance allowances)

Step 6: Now subtract all the deductions from the earned gross salary of the employee in that particular month, the balance amount will be the net salary of the employee.

Step 7: Now take out the printout of the salary slip and sign it and distribute to employees.

Useful Salary Slip Formulas

1 Net salary Total Earnings – Total Deductions
2 Gross Wage Basic wage + HRA + Conveyance + Medical + Special allowances
3 EPF 12% of the basic wage of the employee.
4 ESI 0.75% of employee gross wage. ( ESI applicable if gross is above 21,000₹)
5 CTC Gross wage + Employer PF Contributions + Other Benefits Given by Employer

FAQs

1. How can I get my salary slip

You can get your salary by asking your employer, it is the right of every employee to get a salary slip whenever they want.

2. What is the use of salary slip

Salary slip/pay slip acts as income proof, which is required for various loans and especially when you are trying to join in new with a better salary package.

3. How to verify my salary slip

If you know some basic formulas of salary calculations, then you can easily verify your salary slip yourself. Otherwise, take the help of anyone who knows about it.

4. Can HR verify salary details

Yes, HRs will definitely verify your salary details. It is their duty to verify the salary details of the existing employee and new joiners ( during background verification)

5. Can I edit my salary slip

You can edit your salary slip in excel or PDF formats. But don’t manipulate your salary details on your payslips, it may cause problems.

6. What do you do if you don’t have a payslip

If you don’t have any payslip then you can download the above payslip formats and update your salary details. (make sure the salary you mentioned in the payslip should match with the salary credited in your bank account).
Or Take help from your company HR or Account department.

7. Can new employer see my old salary

Yes, they will see your old salary. For that, they will ask you to submit your previous company payslips. (At least for the last 3 months)

8. It is Ok to lie about my current salary in the interview

It is not a good idea, why because once you are selected then they will ask you to submit your previous job pay slips.

9. How can I prove my income without salary slip

You can show your bank statement, or form 16, your job offer letter or appointment letter.

Also Read

[ad_2]

Simple Salary Slip Formats in Excel | Word | PDF Download

Are you looking for a simple salary slip format to use for your business? If so, you’ve come to the right place. We’ve compiled a list of the best salary slip formats in Excel, Word, and PDF formats for you to download and use.

A salary slip is an important document that records the salary details of an employee. It is used to track the salary payments made to an employee and to ensure that the employee is paid the correct amount. It also serves as proof of payment for the employee.

Using a salary slip format is a great way to ensure that your salary payments are accurate and up-to-date. It also helps to keep track of the deductions and allowances that are made to the employee’s salary.

We’ve compiled a list of the best salary slip formats in Excel, Word, and PDF formats for you to download and use. All of these formats are easy to use and can be customized to fit your business’s needs.

Excel Salary Slip Format

The Excel salary slip format is a great way to keep track of your employee’s salary payments. It is easy to use and can be customized to fit your business’s needs. The Excel format allows you to enter the employee’s name, salary, deductions, and allowances. It also allows you to enter the date of payment and the total amount paid.

Word Salary Slip Format

The Word salary slip format is a great way to keep track of your employee’s salary payments. It is easy to use and can be customized to fit your business’s needs. The Word format allows you to enter the employee’s name, salary, deductions, and allowances. It also allows you to enter the date of payment and the total amount paid.

PDF Salary Slip Format

The PDF salary slip format is a great way to keep track of your employee’s salary payments. It is easy to use and can be customized to fit your business’s needs. The PDF format allows you to enter the employee’s name, salary, deductions, and allowances. It also allows you to enter the date of payment and the total amount paid.

We hope that this list of the best salary slip formats in Excel, Word, and PDF formats has been helpful. Download the format that best suits your business’s needs and start tracking your employee’s salary payments today!

Jaspreet Singh Ghuman

Jaspreet Singh Ghuman

Jassweb.com/

Passionate Professional Blogger, Freelancer, WordPress Enthusiast, Digital Marketer, Web Developer, Server Operator, Networking Expert. Empowering online presence with diverse skills.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.

GSTIN is 03EGRPS4248R1ZD.

Contact
Jassweb, Rai Chak, Punjab, India. 143518
Item added to cart.
0 items - 0.00