Labour Code HR & Payroll Pack — CTC Restructuring, Gratuity, Full & Final + 5 HR Letters

Get your salary structures, settlements and HR letters ready for the new Labour Codes.

Excel calculators

• CTC Restructure: checks the Code on Wages 50% rule for 50 employees and shows the add-back, the PF wages and the Basic + DA needed to comply
• Gratuity under the Code on Social Security, 2020: the 5-year rule, fixed-term pro rata and the ceiling
• Full & Final Settlement: salary, leave encashment, notice recovery, gratuity, bonus and deductions, plus the 2-working-day pay-by date
• Bonus: eligibility, calculation ceiling and 8.33%–20% for 50 employees

Word templates

• Offer letter with salary annexure
• Appointment letter
• Relieving letter
• Experience certificate
• Full & final settlement letter

Rates live on one Settings sheet, so you can update them when notifications change.

What you need: Microsoft Excel 2010 or later, or a free Google account for Google Sheets. Word or Google Docs for the letters. No macros, no add-ins, no subscription.

Support: if the file doesn't work as described, email me within 7 days and I'll fix it or refund you in full.

Calculation tools and templates, not legal advice. Check them against current notifications and your state rules.