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.
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 2
Salary Slip Format 3
Salary Slip Format 4
| 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
Other Salary Slip Formats
SALARY SLIP IN EXCEL (FORMAT 1)
SALARY SLIP IN EXCEL (FORMAT 2)
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
You can get your salary by asking your employer, it is the right of every employee to get a salary slip whenever they want.
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.
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.
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)
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.
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.
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)
It is not a good idea, why because once you are selected then they will ask you to submit your previous job pay slips.
You can show your bank statement, or form 16, your job offer letter or appointment letter.
Also Read
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!
