A salary sheet Excel template calculates each employee’s gross pay, deductions, and net pay for the month in a simple, readable format. This free salary sheet for Indian businesses keeps the columns light, Basic, HRA, allowances, PF, PT, TDS, and net pay, with live formulas so totals recalculate as you edit. It is the quick monthly format. For full PF, ESI, and employer-cost detail, use the payroll register instead.

Free Salary Sheet Excel Template for Indian Businesses

A salary sheet Excel template calculates each employee’s gross pay, deductions, and net pay for the month in a simple, readable format. This free salary sheet for Indian businesses keeps the columns light, Basic, HRA, allowances, PF, PT, TDS, and net pay, with live formulas so totals recalculate as you edit. It is the quick monthly format. For full PF, ESI, and employer-cost detail, use the payroll register instead.

What a Salary Sheet Excel Template must include

  • Employee ID, name, and days payable
  • Earnings: Basic, HRA, and other allowances
  • Gross = sum of earnings, as a formula
  • Deductions: PF (12% of Basic), professional tax, TDS
  • Total deductions and net pay, calculated live
  • A row per employee for the month

Drafting tips

  • This is the light format. When you start filing PF ECR and ESI returns, switch to the full payroll register.
  • Keep a separate salary-master tab so the monthly sheet only changes days payable, not the whole structure.
  • Round consistently. Mixing ROUND and no-round across rows is the most common reason totals look off by a rupee.

Salary Sheet Excel Template format

MONTHLY SALARY SHEET for [Month YYYY]

A light salary format for quick monthly processing. Fill in earnings and the deduction
inputs; Gross, PF, total deductions, and Net Pay calculate themselves.

KEY FORMULAS (row 2 example)
Gross             = Basic + HRA + Allowances        (D2 + E2 + F2)
PF (employee)     = ROUND(Basic * 12%, 0)           (ROUND(D2*0.12,0))
Total Deductions  = PF + PT + TDS                    (H2 + I2 + J2)
Net Pay           = Gross - Total Deductions         (G2 - K2)

For full PF, ESI, employer cost, and gratuity provision, use the Payroll Excel Template.

FAQs

What is a salary sheet?

A salary sheet is a monthly statement that lists each employee’s earnings, deductions, and net pay. It is the basis for paying salaries and for payslips.

How do I make a salary sheet in Excel?

Add columns for Basic, HRA, and allowances, sum them for Gross, compute PF as 12% of Basic, subtract PF, PT, and TDS for Net Pay. This template has all of it built in.

What is the difference between a salary sheet and a payroll register?

A salary sheet is the light monthly format. The payroll register adds ESI, employer PF and ESI, gratuity provision, and statutory columns for filings. Use the register once you file PF and ESI returns.

How is net salary calculated?

Net Pay = Gross Earnings minus total deductions (PF, professional tax, TDS, and any loan recovery). The Net Pay column here does it for every employee.

Is a salary sheet the same as a payslip?

No. A salary sheet covers all employees in one grid for processing. A payslip is the single-employee document you give each person. You generate payslips from the salary sheet.

When should I automate salary processing?

When PF, ESI, and TDS filings start eating time, or when one formula change risks every row. Indian HRM runs payroll, files returns, and emails payslips automatically.