Free template

Salary Sheet Excel Template

A salary sheet lists every employee's earnings and deductions for a month. This template pro-rates earnings by paid days and calculates PF (12% up to the ₹15,000 ceiling), ESI (0.75% if gross ≤ ₹21,000), professional tax and net pay with formulas you can audit.

Download Excel (.xlsx)Automate it in Payroll & HR ERP

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Columns marked “auto” are formulas.

Preview

Emp code	Name	Days in month	Paid days	Basic	HRA	Other allowance	Gross earned	PF (12%)	ESI (0.75%)	Professional tax	TDS	Net pay
E001	Aman Kumar	30	30	15,000	6,000	4,000	auto	auto	auto	auto	auto	auto
E002	Priya Sharma	30	28	22,000	8,800	6,000	auto	auto	auto	auto	auto	auto
E003	Rahul Verma	30	30	12,000	4,800	2,500	auto	auto	auto	auto	auto	auto

How to use this template

Paid days = days present + paid leave + weekly offs + holidays.
Professional tax varies by state — replace ₹200 with your state's slab.
Enter TDS from the employee's projected annual tax ÷ 12 (see the TDS calculator).

Related tools and templates

Free tool

Salary Calculator

Free in-hand salary calculator for India: convert annual CTC to monthly take-home after PF, ESI, professional tax and income tax (new regime FY 2025-26).

Use calculator → Free tool

PF Calculator

Free PF calculator: compute employee 12% PF, employer EPF 3.67%, EPS 8.33% (₹15,000 ceiling), EDLI and admin charges per month and per year.

Use calculator → Free tool

ESI Calculator

Free ESI calculator: check ESI applicability (₹21,000 limit) and compute employee 0.75% and employer 3.25% ESIC contribution per month.

Use calculator → Template

Monthly Payroll Processing Checklist

Free monthly payroll checklist (Excel): attendance cut-off, joiners and exits, arrears, statutory deductions, approvals, bank file, PF/ESI/PT/TDS deposit due dates.

Download → Template

Employee Joining Checklist

Free employee onboarding checklist for Indian companies: documents, PAN, Aadhaar, UAN, ESI, bank details, offer letter, policies, assets and payroll setup.

Download →