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. If 10% of basic salary is lower than Rs 2000, then HRA will 10% of Basic Salary Formula =IF (D2.10%2000,2000,D2.10%) write formula in E2 cell & drag formula to E21 cell, Dearness Allownace (DA) = DA is 25% on Basic Salary.
Download Salary Slip in Excel format (How to create a Salary Slip / Pay Slip in excel) Manoj September 11, 2017 Excel, 5 Comments Click here to download the Excel Sheet Format of Salary Slip/Pay Slip Excel format में वेतन Slip डाउनलोड करें - Prepare Employee Sala. The salary slip format in excel with formula made it easier for private limited organizations and small and medium organizations. In this format of excel, the salaries for each employee in front of their names must be added. Doing this will automatically calculate the whole salaried expenses for the Pvt Ltd company. Pay Slip or Salary Slip template in excel is the receipt given by the employer to their employees every month upon payment of salary to the employee for the services rendered in the month. Pay Slip consists of all kinds of earnings and deductions under various heads as per the norms are given by the government in the respective financial year.
Here are 18 Free Salary Slip Templates that can very helpful for a big and small organization to create a salary slip for an employee.
A Salary Slip is an employment document. It is sort of proof for both the employer and employee that the employer has paid a full payment to the employee. It’s made on a monthly basis. It provides all the information about the employee’s name, his designation, his net salary amount, leaves he took, and the deductions. It’s also very important to have solid proof of what the employer has given and what the employee has got. This little effort can eliminate a whole lot of trouble regarding any tax payment or dispute between owners and workers. You can also check out our collection of Pay Slip Templates.
A Salary Slip template varies in different countries even in various organizations in the same country. The most important part of a salary slip is the payment an employee is getting. The salary of an employee generally consist of two parts
- Fixed salary
- Variable component
Typically the variable part of the salary includes a variety of allowances, bonuses, trip benefits, and other compensations. The variable amount also depends upon the performance of employee, his attendance and the number of decisions he makes for the benefit of the organization.
Usually, a salary slip contains:
- Organization’s name and logo
- Employer’s name and designation along with his address
- Employee’s name and his designation
- Form of payment (I.e. cash, check)
- Basic salary
- Stock purchased
- Medical and other allowances
- Tax calculation
- Deductions details
With a difference of few details, almost every organization uses the payslip. For example, some companies don’t give medical allowance to their employees or some firms only pay in the form of a check so there is no need to mention a form of payment on salary slip.
Here we are introducing some professional salary slip templates. You can make easily your own company salary slips by using these particular slips.
Download link for this Salary slip template 01 in MS Excel format is bellow,
Here is download link for this Salary slip template 02 in MS Excel format,
Download link for this Salary slip template 03 in MS Excel format,
Here is download link for this Salary slip template 04 in MS Excel format,
Download link for this Salary slip template 05 is bellow.
Here is download link for this Salary slip template 06 in MS Excel format,
Salary Slip Format In Excel With Formula In India 2018
Please click on the download button bellow to start downloading this Salary slip template 07 in MS Excel format,
Download link for this Salary slip template 08 in MS Excel format,
Here I am going to introduce a salary slip template. Mostly these templates used by the companies. These are issued to the employees. This template is created by using MS word. This includes employee’s information, amount, etc. Download it free from the link. This is free and printable.
This template has been created by using MS word. It is another sample of salary slip template for a small organization. Here you can mention the name of the company, employee name, month, net salary, etc. You can use it in printed or soft form. This is also editable. Here we prepared a link to download it.
Free Salary Slip Format In Excel With Formula
These particular salary slips are designed in MS Excel with the formula that can help out to make a professional simple salary slip.
It is another design of a salary slip template. It has been established in MS word. A salary slip template varies in different countries even in various organizations in the same country. It is very easy to use this template. You can also download it free from the link. It is also printable, so that it may be issued on paper or mailed to the employee.
A salary slip template is an instrument issued by an employer to an employee. It includes a detailed description of the employee’s salary components like HRA, LTA, Bonus paid, etc and deductions for a specified time period, usually a month. It is created in MS word document. Download it free from the download option provided below.
Introducing a free and printable salary slip template which is designed using the MS word. This includes company name, employee name, department, salary, allowances, etc. A salary is a payment to an employee from a company or an employer. A link has been provided to download it free.
While using this template you can mention here company name, address, payslip, phone, date, the employee ID, etc. It is designed in MS excel format. An ideal salary slip format holds almost all the essential columns. You can use it in soft or as well as in hard form. From the link we prepared you can download it. If you want to edit it, it’s very easy. Only click and type.
Company name, address, employee name, month, year earning, deduction, etc can be mention here. Download this template from the link. Use it in printed or in soft form. These salary slip templates are very essential for companies. A Salary Slip is a financial document. It’s also very important to have solid proof of what the employer is given.
A monthly salary slip template created by using MS excel. This template includes monthly salary, category, annual Tex calculation, less rebate, etc. We provided a download option to download it free. When you are given your monthly salary, you are often given a salary slip along with it. It also uses as proof, what you are given to the employee.
Many templates created by using PDF, MS Excel, MS word, etc. This one is created by using MS word. Here you can mention the name of an employee, salary, description, status, amount, etc. You can use it in soft form or in hard form. By using the link you can download it free. This is a very important document used by companies.
Here is another more official MS word document which is free of cost and easy to use. Salary slip template is a document signed by an employee after receiving the salary. Salary slip contains information about an employee such as his name, his salary payment for the month, his designation and total payment and the account number. Download it from the link.
What Is The Big Deal With a Salary Slip?
In order to keep track of your employee’s performance in an easy way, you can just see his monthly bonuses. There are many other factors that force you to prepare a salary slip like:
- A salary slip is like evidence of income and incentives paid to staff
- It makes it possible for the individual to know his payable taxes while filing.
- It is essential if you are going to apply for a loan for your new house or car.
- The salary slip is also very important when you are applying for a new job. It sort of gives a record of your previous job performance by seeing your performance bonuses.
These days, even smaller organizations don’t think twice about giving a salary slip. You can’t imagine any payment is made in a company without an authenticated documentation. Because of law, a labor inspector can certainly request to show the payslips along with other documents while checking.
It’s very important for you to ask for a salary slip if your employer is not providing any. There is no need to hesitate or feel shy because a little effort of getting solid documented proof will save you from a lot of problems in the future.
Related Posts:
If you are looking for a simple and easy to use excel format to calculate your monthly PF & ESI contributions, then the below format of the excel sheet will be helpful to you. Download the below Excel sheet and enter your monthly basic wage + DA to calculate your PF contributions and enter your gross wage to calculate your ESIC contributions.
(Just enter your basic wage or gross salary to automatically calculate your monthly PF & ESIC contributions.)
The above excel format is updated as per the latest EPF and ESIC calculation formulas. Not only employees even employers can also use the above format to calculate the monthly contributions of employees towards PF and ESI.
PF Calculation Formula Percentages 2021
So total employee will contribute 12% of basic wage + DA for PF and employer will pay 13% towards employee PF and pension accounts together.
Note: If there is no DA then only basic wage is considered to calculate the EPF monthly contributions.
ESI Calculation Formula Percentages 2021
So overall 4% of employee gross salary will be paid towards ESIC account in every month.
EPF Eligibility
Salary Slip Format In Excel With Formula Xls
Every employee whose monthly basic wage + Dearness Allowances (DA) is below 15000 Rs will become eligible for the EPF scheme. If the employee salary is above 15000 Rs, still the employee and employer can contribute to the EPF scheme based on their mutual interest.
For employers, they must have minimum 10 or above employees to register their establishment under EPFO scheme 1952.
ESIC Eligibility
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.
Excel Number Format In Formula
Salary Slip Format In Excel With Formula
Also read