Salary Sheet with PF ESIC Calculation

Justin Aug 25, 2026

A comprehensive salary sheet, complete with PF and ESI calculations, is a crucial component of any HR or accounting department's workload. It serves as a clear, organized record of employees' earnings, deductions, and net pay, contributing to the smooth functioning of the organization's payroll process.

the excelslay sheet is displayed in green and white
the excelslay sheet is displayed in green and white

The salary sheet is not just a static document; it is a dynamic reflection of an employee's work, performance, and remuneration. Additionally, it complies with the provisions of the Employees' Provident Funds and Miscellaneous Provisions Act, 1952 (PF), and the Employees' State Insurance Act, 1948 (ESI), which mandate deductions from employees' salaries for their respective welfare funds.

PF & ESI Calculation Checklist for Beginners | Payroll & Salary Guide
PF & ESI Calculation Checklist for Beginners | Payroll & Salary Guide

Understanding PF and ESI Deductions in Salary Sheets

Employees' Provident Fund (PF) and Employee State Insurance (ESI) are two significant social security initiatives in India. These schemes aim to provide financial and medical aid to employees and their families in the event of untoward incidents, retirement, or incapacitation.

Ready-To-Use Employee Salary Sheet Excel Template - India - MSOfficeGeek
Ready-To-Use Employee Salary Sheet Excel Template - India - MSOfficeGeek

PF and ESI are deducted as a percentage of the employee's basic salary. The current rates, as per the latest notifications, are 12% of the employee's basic salary for PF, and 0.75% of the employee's salary (which includes basic salary and dearness allowance) for ESI, subject to a wage ceiling.

Calculating PF Deductions

Professional Salary Sheet Excel Template
Professional Salary Sheet Excel Template

PF deductions are calculated on the employee's basic salary. For example, if an employee's basic salary is Rs. 20,000, then the PF deduction is 12% of Rs. 20,000, which amounts to Rs. 2,400.

PF deductions are usually reflected in the salary sheet as a separate line item under 'Deductions'. Here's an example:

< table style="width:100%" border="1"> < tr>< th>Employee Name< th>Basic Salary< th>PF Deduction < tr>< td>John DoeRs. 20,000Rs. 2,400

Calculating ESI Deductions

How to Make a Payroll Spreadsheet - Free Sample, Example & Format Templates
How to Make a Payroll Spreadsheet - Free Sample, Example & Format Templates

ESI deductions are calculated on the sum of the employee's basic salary and dearness allowance, subject to a wage ceiling. For instance, if an employee's basic salary is Rs. 20,000 and dearness allowance is Rs. 5,000, then the ESI deduction is 0.75% of Rs. 25,000, which is Rs. 187.50.

ESI deductions are also reflected in the salary sheet under 'Deductions'. Here's how it appears:

< table style="width:100%" border="1"> < tr>< th>Employee Name< th>Basic Salary< th>Dearness Allowance< th>ESI Deduction < tr>< td>John DoeRs. 20,000Rs. 5,000Rs. 187.50

Creating an Efficient PF and ESI Calculation System

how to record salary payment with ppe and esl deductions info
how to record salary payment with ppe and esl deductions info

To streamline the PF and ESI calculation process, many organizations use automated payroll software or services. These tools can accurately calculate deductions, reducing the likelihood of errors and ensuring compliance with the relevant legislations.

However, the digital system should be supplemented with robust training and periodic checks to maintain accuracy and efficiency. It's crucial to keep the software updated to reflect any changes in PF or ESI contribution rates or wage ceilings.

salary sheet in excel with formula | salary sheet sample
salary sheet in excel with formula | salary sheet sample
Ready-To-Use Simple Salary Sheet Excel Template - MSOfficeGeek
Ready-To-Use Simple Salary Sheet Excel Template - MSOfficeGeek
Salary sheet in excel
Salary sheet in excel
an invoice form with the name and date on it, which is used to describe
an invoice form with the name and date on it, which is used to describe
a calculator sheet with the number and type of calculations in excel, word or excel
a calculator sheet with the number and type of calculations in excel, word or excel
PAYROLL WORKING
PAYROLL WORKING
an employee pay sheet for employees
an employee pay sheet for employees

Tips for Creating Accurate Salary Sheets

To ensure accuracy in salary sheet preparation, adhere to the following best practices:

  • Cross-verify data with the employee's records and timesheets.
  • Double-check all calculations and deductions.
  • Consistently apply any bonus, incentive, or ad-hoc payments.
  • Maintain a user-friendly format for easy comprehension.

In conclusion, a well-structured salary sheet, complete with PF and ESI calculations, is a testament to an organization's commitment to employee welfare and financial compliance. It's not just a record, but a reflection of the organization's values and priorities. Regular audits and updates ensure the salary sheet's integrity, contributing to the smooth functioning of the organization's HR and finance departments.