Dear All,
Please note I have worked on the subject considering all statutory labour and IT guidelines / rules.
The CTC salary heads include Basic Pay, HRA, Conveyance Allowance, Medical Allowance,
Other Allowance, Special Allowance, Sodexo Coupons, Leave Travel Allowance, Ex-Gratia Pay, Statutory Bonus, ESIC - Employer Contribution, PF - Employer Contribution, Gratuity Pay, ESIC - Employee Contribution, PF - Employee Contribution, Profession Tax, etc. Overseas Deputation Allowance, Performance Bonus and Retention Bonus is over and above the Fixed CTC Amount. The Monthly Gross and Monthly Net Salary are calculated and the CTC fitment is very clear.
The input cells are C19 & E4 for Grade and CTC. Upon feeding the two data input cells, the adjustment cell "J12" is calculated. Cell "J12" is to be copied and the value only is to be pasted in cell "H2" (using Paste Special). The CTC fitment is computed with "ZERO" error.
The CTC fitment is protected with all required cells hidden / locked.
In case of any queries / doubts, please revert to the undersigned.
Thanks & Regards,
Lancy Menezes
Manager - HR & Administration
Mumbai
Mobile # +91 88795 08614.