Salary Payslip Format in Excel with Examples & Formulas 2020 in India

Download Salary Payslip Format in Excel with Examples & Formulas 2020 in India.  Salary slip is a document that shows all the details of salary of an employee he/she earns in a specific time period. A salary slip is also known as a payslip. Employees can calculate their own salaries based on the formulas. Through this article, we are going to provide Salary Slip Templates, Formulas,Formats and Examples. Continue reading the article, to download the Salary Slip Templates.

Salary Pay Slip Format in Excel with Examples & Formulas in India

Salary Payslip Format

CategorySalary Payslip Format
Letter SamplesAvailable Now
Useful toEmployees/Regarding Job
Download FormatExcel 

What is Salary Payslip?

Salary is a payment given to an employee from a company. Salary Slip is a paper of document that shows all the details of the salary that is earned in a specific time period. A Pay Slip contains gross salary, income tax, insurance and other contributions and payments. Salary Slip Formats varies with companies. Every company has its own payslip format and own salary formulas. HR of the company maintains the financial records of the employees like salaries, wages, bonuses, deductions, holidays, leaves, sick leave, etc. in Payroll.

Salary Slip Format in India

A salary slip format includes the following:

  • Company name, logo and address
  • Salary slip month and year, Employee Code
  • Employee PAN Card/Aadhar Card, Bank account details
  • EPF Account Number, Universal Account Number (UAN)
  • Total work days, effective workdays, number of leaves taken
  • List of payments and deductions
  • Gross pay and Net pay in numbers and words

Formula to Calculate Salary

An Employee Salary will be structured based on the following :

  • Basic Salary
  • House Rent Allowance
  • Transport Allowance
  • FBP Allowance
  • Statutory Bonus
  • Provident Fund
  • Income Tax
  • Insurance

Salary can be calculated as follows :

Salary = Basic + HRA + Transport Allowance + FBP Allowance + Bonus – Provident Fund – Income Tax – Insurance

Download Salary Slip Template

The three major components of salary are :

  • Basic Pay
  • Allowances
  • Deductions

Hr and Payroll staff needs to micro-manage payroll data of employees, which include basic salary, HRA, TA, Conveyance, Leave details, provident fund deductions, etc. Download some of the Salary Slip Template given below :

Salary Payslip Format Download Link 
DOCDownload 
DOCDownload 
ExcelDownload 
ExcelDownload 

Examples of Salary Formula

Mr. X. has a salary the following salary components. Calculate the Gross Salary and Net Salary of Mr. X.

AB
4Basic Salary18,775
5House Rent Allowance9,387
6Transport Allowance1,600
7FBP Allowance26,184
8Statutory Bonus1,883
9Income Tax2,100
10Provident Fund2,300
11

Gross Salary and Net Salary are calculated as follows :

AB
4Basic Salary18,775
5House Rent Allowance9,387
6Transport Allowance1,600
7FBP Allowance26,184
8Statutory Bonus1,883
9Income Tax2,100
10Provident Fund2,300
11
12
13
14Formula=SUM(B4:B8)
15Gross Salary57,829
16NetSalary
17Formula=B14-SUM(B9:B10)
18Net Salary53,429

 

  • Net Salary = 57,829 – (2,100 + 2,300)
  • Net Salary = 57,829 – 4,400
  • Net Salary = 53,429

Hope this article, is useful to the employees who have been searching for Salary Payslip Format, Samples 2020. Through our post, you can get the Download in Excel,/DOC, Salary Formula, Formats,etc. Share this article with your friends. Subscribe, to get the latest notifications as soon as updated.

Leave A Reply

Your email address will not be published.