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.

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

Preview

Emp codeNameDays in monthPaid daysBasicHRAOther allowanceGross earnedPF (12%)ESI (0.75%)Professional taxTDSNet pay
E001Aman Kumar303015,0006,0004,000autoautoautoautoautoauto
E002Priya Sharma302822,0008,8006,000autoautoautoautoautoauto
E003Rahul Verma303012,0004,8002,500autoautoautoautoautoauto

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