Build a Payroll Register with PF, ESI and TDS in Excel

<p>Deepa Raghavan is the accounts executive at Kovai Precision Packaging, a box maker in Coimbatore with eighteen employees. The consultant who ran their payroll for eleven years has retired, and the company's CA wants to review the first in-house register before anyone is paid. Across five lessons you build that register from zero in your own personal workbook: fixed salary looked up from the master, loss-of-pay days from a messy attendance export, earned pay over the month's calendar days, PF at 12% with the ₹15,000 wage ceiling, ESI for salaries up to ₹21,000, TDS from a simplified slab table, net pay and the employer's cost. Along the way you learn to make a register prove itself: edge cases tested, deductions capped, totals that reconcile to the rupee. Every lesson then hands the same job to your AI (Copilot, ChatGPT, Claude or Gemini) and shows you how to catch its mistakes. In the capstone your agent builds November, with a 30-day month and three salary revisions, and you prove it right. The rates and rules are simplified and illustrative, for learning; always confirm the current statutory rates before running a real payroll.</p>

Tools: XLOOKUP, TRIM, ROUND and ROUNDUP, MIN and IF, VLOOKUP Approximate Match, SUM and COUNTIF, Conditional Formatting, AI Assistants for Excel