Payroll Excel Sheet — PF, ESI, PT & TDS Auto-Calculated + Payslip Generator

Description

Still calculating salary on a calculator every month — and worrying whether PF, ESI and PT are right? This payroll sheet does it for you. Type paid days; it calculates earned salary, deductions, net pay, employer cost, payslips and challan totals. Made by an Accounts Manager who runs payroll every month.

What you get

• Payroll workbook — Demo + Blank (Excel, works in Google Sheets) for up to 50 employees
• Automatic PF on the new ₹25,000 wage ceiling (from 17 Sep 2026), split into EPS, EPF, EDLI and admin
• ESI (0.75% + 3.25% up to ₹21,000 gross) and Maharashtra professional tax slabs for men and women, including ₹300 in February. Manual PT option for other states.
• Payslip generator — choose Emp ID and print or save as PDF
• Summary & challans — PF ECR (A/c 1, 2, 10, 21), ESI, PT and TDS totals with due dates, plus a bank transfer list
• TDS calculator — new tax regime, Tax Year 2026-27 (₹75,000 standard deduction, no tax up to ₹12 lakh)
• Labour Code check — flags employees whose basic is below 50% of pay
• 14-page user guide (PDF) — set-up, monthly steps, worked example, due dates and accounting entries

Who is it for

Shops, small businesses and startups with 2–50 employees, CA firms running client payroll, and accounts/HR staff who want a clean, checkable salary sheet without buying payroll software.

Good to know

• Digital product — ZIP download link right after payment
• Needs Excel 2016 or later, Excel 365 or Google Sheets (free)
• All rates and ceilings are on a Settings sheet, so you can update them when rules change
• Help on email (digiproductstudio26@gmail.com) or WhatsApp (+91 98190 89790)
• For the buyer’s own business or clients; reselling or sharing the file is not allowed

Rules as understood in October 2026. The TDS calculator covers the new regime only (no surcharge or old regime). This is a calculation tool, not legal or tax advice; confirm current rates with official portals or your consultant.