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.
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).
Template FAQ
Is the Salary Sheet Excel Template free to download?
Yes. The .xlsx file is free with no sign-up. It opens in Excel, Google Sheets and LibreOffice.
What columns does the Salary Sheet Excel Template include?
Emp code, Name, Days in month, Paid days, Basic, HRA, Other allowance, Gross earned, PF (12%), ESI (0.75%), Professional tax, TDS, Net pay.
Which columns are calculated automatically?
Gross earned, PF (12%), ESI (0.75%), Professional tax, TDS, Net pay are filled by formulas, so you only enter the other columns. Formulas stay visible so you can audit or change them.
When should I move from this spreadsheet to Payroll & HR ERP?
Use the spreadsheet while one person maintains it. Move to payroll software when several people need to update it, you need approvals and history, or the numbers must post to GST accounting and reports automatically.
Related tools and templates
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 toolPF 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 toolESI 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 → TemplateMonthly 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 → TemplateEmployee Joining Checklist
Free employee onboarding checklist for Indian companies: documents, PAN, Aadhaar, UAN, ESI, bank details, offer letter, policies, assets and payroll setup.
Download →