PF ESi Salary Sheet: Excel Format Guide & Template

Justin Aug 25, 2026

salary sheet, it's a crucial document used by organizations to manage and track employee compensation. With Excel being one of the most popular spreadsheet software, many professionals search for "PF ESI salary sheet excel format" to create efficient and accurate salary sheets that incorporate Provident Fund (PF) and Employees' State Insurance (ESI) deductions.

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

PF and ESI are mandatory contributions that are automatically deducted from an employee's salary, with the employer also contributing an equal amount. These deductions are crucial for an employee's future financial security and medical benefits, respectively. Therefore, it's vital to have the correct PF ESI salary sheet format in Excel to ensure these contributions are accurately calculated and deducted.

Ready-To-Use Simple Salary Sheet Excel Template - MSOfficeGeek
Ready-To-Use Simple Salary Sheet Excel Template - MSOfficeGeek

Understanding the PF ESI Salary Sheet Excel Format

The PF ESI salary sheet Excel format should include columns for basic salary, dearness allowance, gross salary, and PF and ESI deductions. It should also accommodate multiple rows to accommodate employees with varying salaries and deductions.

Professional Salary Sheet Excel Template
Professional Salary Sheet Excel Template

Here's a simple example of what the PF ESI salary sheet Excel format might look like:

Employee Name Basic Salary DA Gross Salary PF Deduction ESI Deduction
John Doe 5000 2500 7500 1250 500
Jane Smith 6000 3000 9000 1500 600
how to make salary sheet in excel | simple salary sheet in excel
how to make salary sheet in excel | simple salary sheet in excel

Calculating PF Deduction in Excel

PF is deducted at 12% of the basic salary. To calculate this in Excel, you can use the formula "=*12/100". For example, if the basic salary is in cell A2, the formula would be "=A2*12/100".

For John Doe in the above example, the PF deduction would be calculated as:=5000*12/100, which equals 600 (i.e., 6000/100).

How To Use Excel For Payroll - Free Sample, Example & Format Templates
How To Use Excel For Payroll - Free Sample, Example & Format Templates

Calculating ESI Deduction in Excel

ESI is deducted at 0.75% of the basic salary. The formula to calculate this in Excel is similar to that of PF, i.e., "*0.75". For instance, if the basic salary is in cell A2, the formula would be "=A2*75/100".

So, for Jane Smith in the above example, the ESI deduction would be calculated as:=6000*75/100, which equals 450 (i.e., 4500/100).

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

Formatting and Efficiency Tips

Using the best practices of Excel can make your PF ESI salary sheet more efficient and easier to manage. Here are some tips:

Ready-To-Use Salary Certificate Format Excel Template - MSOfficeGeek
Ready-To-Use Salary Certificate Format Excel Template - MSOfficeGeek
Professional Salary Sheet Excel Template | Payroll Data Entry
Professional Salary Sheet Excel Template | Payroll Data Entry
an employee job sheet in excel with the image of a man sitting at his desk
an employee job sheet in excel with the image of a man sitting at his desk
HOW TO CREATE PAYROLL|SALARY SHEET| PAYSLIP IN EXCEL(Hindi)
HOW TO CREATE PAYROLL|SALARY SHEET| PAYSLIP IN EXCEL(Hindi)
How to Create a Salary Sheet in Excel | Easy Formulas & Step-by-Step Guide for Beginners (part-29)
How to Create a Salary Sheet in Excel | Easy Formulas & Step-by-Step Guide for Beginners (part-29)
an employee pay sheet for employees
an employee pay sheet for employees
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

Auto-Fill and Formula Functions

Instead of manually entering the PF and ESI deduction calculations for each employee, you can use Excel's auto-fill function. After entering the formula once, you can click and drag the small square in the bottom right corner of the cell down to apply the formula to all relevant cells.

Similarly, Excel's formula functions, like SUM(), can be used to automatically total the PF and ESI deductions at the end of your sheet.

Conditional Formatting

Excel's conditional formatting feature can color-code your cells based on certain conditions, making it easy to identify errors or specific data patterns at a glance.

For example, you could set cells containing PF or ESI deductions to turn red if they exceed a certain threshold, indicating a potential calculation error.

Frozen Panes and named Ranges

If your PF ESI salary sheet has a large number of employees, you can use frozen panes to keep your header row static while you scroll through the rest of the data. Similarly, using named ranges can make your formulas and functions more understandable and easier to maintain.

Remember, the key to an effective PF ESI salary sheet Excel format is to keep it simple, clear, and mistake-proof. Regularly updating and reviewing the sheet will ensure your employees' PF and ESI deductions are accurate and up-to-date, protecting both them and your organization.