Blogdp438

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.

1. Salary Slip Format In Excel With Formula Worksheet
2. Salary Slip Format In Excel With Formula In India
3. Download Salary Slip Format

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.

The right section of the salary slip format contains deduction details like PF, PT, and TDS. You may also download our ready salary slip templates in excel formats with formulas. Enter the basic details and you’ll have a ready to print salary slip in no time. These salary slip format in excel are ideal for small size organizations. Payslip template excel is provided to the member of staff after a month when the boss paid the worker salary. This slip is utilized for writing the information of the salary like title name of employer & employee, date of payment, day & total sum of payment allowances & other vital information regarding the employee salary.

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 which you can download in Excel, Word, and PDF formats.

• The format of Payslip consists of all earnings (fixed and variable) and deductions (fixed and variable) along with the mandatory tax deductions like TDS and FBT. Here we prepared few Salary Slip Excel Formats with predefined formulas. It can help to calculate the Gross earnings and deductions. Important Salary Slip Excel Format.
• Every employee whose monthly gross salary is below 21000 Rs will be eligible for ESIC scheme. For employers they must have 10 or above 10 employees to register their establishment under ESIC scheme 1948. Download EPF ECR File Format in Excel. PF calculation for employees with above 15000 basic wage. How to download ESIC E Pehchan Card.

Salary Slip Format 1

Salary Slip Format 2

Salary Slip Format 3

Important Components on Salary Slip

Useful Salary Slip Formulas

FAQs

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

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.

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.

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.

Salary Slip Format In Excel With Formula Worksheet

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.

Salary Slip Format In Excel With Formula In India

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)

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

Download Salary Slip Format

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

Also Read