New vs Old Salary Breakup Comparison Calculator (Excel)
India’s New Labour Codes have changed how Basic, PF, ESI, Bonus, Gratuity, Take-Home & CTC are calculated.
Yet most HR teams and employers are still:
Guessing salary impact
Manually recalculating in Excel
Explaining confused take-home reductions to employees
Lacking a clear Old vs New comparison
This ready-to-use Excel tool helps you:
✔ Compare Old Rule vs New Labour Code salary structure
✔ Instantly see increase / decrease in:
Employee PF & ESI
Employer PF, ESI, Bonus & Gratuity
Take-Home Salary
Monthly & Annual CTC
✔ Identify salary restructuring impact before implementation
✔ Explain changes clearly to management & employees
✔ Avoid compliance mistakes under New Labour Codes
Auto-calculated Old vs New salary breakup
Clear difference column (Increase / Reduced)
Covers:
Basic + DA impact
PF (Employee & Employer)
ESI (Employee & Employer)
Bonus
Gratuity
Net Pay
Monthly & Annual CTC
Works for any salary level
No formulas to edit — just enter salary details
You only update highlighted input cells. Everything else auto-calculates.
This calculator is perfect for:
✔ HR Professionals
✔ Payroll Executives
✔ Employers & Business Owners
✔ Startups & MSMEs
✔ Consultants & Practicing HRs
✔ Anyone implementing New Labour Code salary restructuring
If you are answering questions like:
“Why is my take-home reduced?”
“How much will PF increase?”
“What is the actual CTC impact?”
This Excel gives you clear answers instantly.
New Labour Codes mandate higher Basic wages
PF, Bonus & Gratuity costs increase silently
Employees see lower take-home without understanding why
No standard Excel available online for clean comparison
This tool removes confusion, guesswork & manual errors.
✔ Saves hours of manual calculation
✔ Helps in salary restructuring decisions
✔ Improves employee communication & trust
✔ Ensures labour code alignment
✔ One-time download — use forever
No subscription
No login
Instant download after payment
Lifetime usability
Less than the cost of one HR mistake.
1️⃣ Make payment
2️⃣ Download Excel instantly
3️⃣ Enter salary details
4️⃣ Get Old vs New comparison in seconds