Salary Slips

A salary slip, also known as a payslip or paystub, is an official document issued by an employer, finance or payroll officials, to an employee for providing details of salary breakdown. It contains complete information on the employee’s earnings and deductions for a particular month. The employer is obliged to issue a payslip to all of the employees, either in a printed or online form. A salary slip not only verifies the employee’s employment but also documents the earning of the employee, thus helping in record-keeping for the employee’s personal file.

A salary slip could be helpful in many ways. Below are mentioned few points which refer to the importance of a salary slip:

  • Proof of Employment – while applying for an International scholarship program, or international travel, the visa agencies require a bank statement of the applicant to track the account balance. Thus, during the visa application process, a salary slip provides an account of the income source of the applicant, by serving as a proof of employment
  • Validation for Financial Institution – when an applicant applies for a loan, credit card or opening of a bank account, the banks require the applicant to provide a source of income which could serve as a proof of the borrower’s ability to return the debt
  • Calculation of Income Tax – a salary slip provides complete details of earning and deductions (which could include provident fund, federal tax, or any other deductions). Thus, it helps in calculating the income tax  to be paid by the employee or to be claimed by means of income tax refund
  • Reference document for Existing/Potential Employer – while processing for an application process of a potential employer, the employer may require the applicant to submit a copy of the existing or previous contract, or a salary slip. The salary slip helps in negotiating for the salary offer. Also, the salary slip helps an employee to ask for a salary raise from the existing employer, based on performance and market competitive salary

Thus, for an employee, it is important to have a salary slip as it can help him/her for any of the above-mentioned reasons. The employee should maintain a record of all of the provided salary slips, to use them later when the need arises. It is a right of an employee to be provided with a salary slip, and the employers are, in many countries, are legally bound by the law for issuing a salary slip to all of the employees, as evident from the Fair Work Act 2009, Section 536, which states an obligation on employers to issue payslips to the workers or employees.

A similar law exists in the United Kingdom as Payment of Wages Act 1991, which grants a right of attaining or receiving payslips to all of the employees and workers, likewise the right to payslip in India is addressed under Minimum Wages Rules.

The format and components of a salary slip can vary for different countries. But the basic important components of the slip remain the same, which include:

Advertisement
  • Company’s Name
  • Header: which includes the title (salary slip), and month (for which the salary slip is being issued)
  • Employee Name
  • Employee Designation
  • Address
  • Income
    • Basic Pay – the income which an employee without the addition of any allowance
    • House Rent – it is added to an employee’s earnings if he /she lives in a rented home
    • Medical Allowance – it as an allowance given to an employee, to make up for the medical expenses
    • Bonus – added to income, in case of exceptional performance
  • Deductions
    • Provident Fund – it serves as a serving, and the amount which is deducted from employee’s income is returned as twice by the employer when the employee’s contract ends
    • Employee Old-age Benefit Insurance – deducted from the employee’s income, which can be later claimed by the employee from a relevant institute which manages employees pensions
    • Taxes – income tax, professional taxes, or  any other tax may get deducted from the employee’s income as per the country’s or state’s law
  • Net Pay – the total payment which an employee receives after deductions have been made

(Any other allowance or deductions may become part of salary slip as per the requirement or rules of the company or state)

The salary slip may also contain Employee’s ID, No. of working hours/days, and details of Bank’s branch and account. Below is given an overview of different formats of salary slip for different countries:

India/Pakistan

India-Pakistan Salary Format
India-Pakistan Salary Format

Canada

Canada salary slip format
Canada salary slip format

United States

United states salary slip Format
United states salary slip Format

There are different tools that can be used to generate a salary slip of an employee other than MS Word. Thought multiple online software is available to ease the process, but Microsoft Excel is readily available and is convenient to use. However, one requires practice for the effective utilization of MS Excel. Below are formats which can be used for Excel payslips, and can be customized as per requirements:

Excel Salary Slip Format
Excel Salary Slip Format
Excel Salary Slip Format

The pay slip at MS Excel can be generated or created by two means:

  • Using Existing Template

MS Excel provides the user with an inventory of templates that can be used by the finance department to create salary slips of the employee. Below are mentioned few steps which are used to create template on MS Excel:

  1. Download MS Excel if you do not have one, already
  2. Open the file of MS Excel
  3. Click the File tab, and you would see an option of New
  4. After clicking New, a box would appear displaying available templates It also consists of Office Templates. While you explore those templates, you would see a folder for Payroll
  5. Open the Payroll folder. It would now display various templates that could be used. Select as per your requirement and download
  6. Once you have downloaded the template, it would open on its own and you can edit the data as per the requirement
  7. These templates are preferred over manual ones because they are embedded with formulas and the user does not need to apply the formula for calculation. You just have to enter employee’s code, name, and change numerical figures as per the employee’s earnings and deductions, and the Excel would apply the formula on its own, thus calculating the employee’s net income for a particular month
  8. The sheet can then be saved and printed later when required
  • Creating Template Manually

In order to create a template manually, one needs to have MS Excel. Once the file is there, open the excel sheet and then follow below-mentioned steps to create the simplest template:

  1. Click the File tab, and you would see an option of New
  2. After clicking New, a box would appear displaying available templates. Click on Blank Workbook
  3. Each block of the workbook, is known as a cell. Cells can be merged horizontally, and vertically. The font, color, text alignment, and borders of a cell can be changed too from the portion displayed below the file option. That portion is called ribbon
  4. First enter the top post part which should include Company Name, Salary Slip Month and Employee’s Details and others as per requirement
  5. It should then be followed by a middle part, which includes earnings and deductions. Text and numerical figures should not be merged, they should be entered in separate columns. It would help later during calculations
  6. Once the earning and deductions have been added, the sum can be calculated for each using formula, which is, =SUM (Number 1, Number 2). In Excel, whenever an equal (=) sign is added, it gives a command that a formula is being applied, SUM means addition. It is followed by parenthesis “(“, which represents the range which has to be calculated. Number 1 represents the first number which is to be added and all respective cells which are to be added can be selected. One the complete range of cells have been selected, use parenthesis close “)”, and enter to apply formula. This way, calculate earnings and deductions
  7. For Net pay, minus deductions from earnings, by using the above method but different formula. This time formula for subtraction would be used, which is =MINUS(Number 1, Number 2)

Sample Templates


File: Word (.docx) & Excel (.xlsx) 2007+ and iPad
Size 28 Kb

Download

Advertisement