Download Salary Slip Formats in Excel | Word | PDF

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.

If you are an employer then it is always better to issue a simple salary slip format to your employees, so that they can easily understand their gross wage, gross deductions, and net salary details.

Along with salary components, it is better to include other details like employee id, bank account number, UAN, ESI number, etc.

Here you can find some simple salary slip formats in India 2021 for PVT Ltd Companies. which you can download in Excel (with & without formulas), Word, and PDF formats.

Note

  1. For automatic calculation of your salary details, update fields filled with Yellow Colour, and remember professional tax slab rates different for each state
  2. If your actual gross salary is above 21,000 Rs then you are not eligible for ESIC, in that case, you can add a health insurance premium amount (500-1000 Rs) or you can leave this field.

Salary Slip Format 1

simple salary slip format in excel free download
Download the above salary slip format in Excel with formulasDownload
Excel Without FormulasDownload
Word FormatDownload
PDF FormatDownload

Salary Slip Format 2

salary slip in India word format free download
Download the above salary slip Excel format with formulasDownload
Excel without formulasDownload
Word FormatDownload
PDF FormatDownload

Salary Slip Format 3

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

Important Components on Salary Slip

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

Useful Salary Slip Formulas

1Net salaryTotal Earnings – Total Deductions
2Gross WageBasic wage + HRA + Coveyance + Medical + Special allowances
3EPF12% of the basic wage of the employee.
4ESI0.75% of employee gross wage. ( ESI applicable if gross is above 21,000₹)
5CTCGross 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 salary slip whenever they want.

2. What is the use of salary slip

Salary slip/pay slip acts as an income proof, which is required for various loans and especially when you are trying to join in new with 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 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 to do you do if you don’t have a payslip

If you don’t have any pay slip then you can download above pay slip formats and update your salary details. (make sure the salary you mentioned in 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 last 3 months)

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

It is not a good idea, why because once you 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

Leave a Comment