Hi,
If anyone can share CTC structure format based on IF conditions, that would be a great help. Basically, I am looking for a format where, based on the gross salary, it will determine whether PF and ESIC are applicable or not. Subsequently, it will execute the deductions and calculate the amounts under different heads.
Thanks, Manish
From India, Ahmedabad
Acknowledge(0)
Amend(0)
49If anyone can share CTC structure format based on IF conditions, that would be a great help. Basically, I am looking for a format where, based on the gross salary, it will determine whether PF and ESIC are applicable or not. Subsequently, it will execute the deductions and calculate the amounts under different heads.
Thanks, Manish
From India, Ahmedabad
Acknowledge(0)Amend(0)
Hello Manish,
Sure, I can help you with structuring your CTC (Cost to Company) based on IF conditions. This involves determining whether the Provident Fund (PF) and Employee State Insurance Corporation (ESIC) apply based on the gross salary. Here's a basic structure you can follow:
🎈 Gross Salary: This is the total salary before any deductions.
🎡 PF Deduction: If the gross salary is equal to or less than Rs. 15,000, then PF is applicable. The PF amount equals 12% of the gross salary.
🎡 ESIC Deduction: If the gross salary is equal to or less than Rs. 21,000, then ESIC is applicable. The ESIC amount equals 0.75% of the gross salary.
🈴 CTC Calculation: The CTC is the Gross Salary minus the PF and ESIC deductions.
Here's a step-by-step guide on how to do this:
Step 1: First, determine the gross salary of the employee.
Step 2: Check the gross salary against the thresholds for PF and ESIC.
➡️ If the gross salary is equal to or less than Rs. 15,000, calculate the PF. The formula to calculate PF is: Gross Salary * 0.12.
➡️ If the gross salary is equal to or less than Rs. 21,000, calculate the ESIC. The formula to calculate ESIC is: Gross Salary * 0.0075.
Step 3: Subtract the PF and ESIC amounts (if applicable) from the gross salary to get the CTC.
I hope this helps; let me know if you have any other questions.
Please note that this information is based on applicable labor laws in India, specifically the Employees' Provident Funds and Miscellaneous Provisions Act, 1952, and the Employees' State Insurance Act, 1948. I suggest referring to these acts for more detailed information.
Remember, the above structure is just a basic guide. Depending on the company's policy and the employee's designation, other components like HRA, LTA, bonus, and special allowances may also be part of the CTC.
From India, Gurugram
Acknowledge(0)Amend(0)
Sure, I can help you with structuring your CTC (Cost to Company) based on IF conditions. This involves determining whether the Provident Fund (PF) and Employee State Insurance Corporation (ESIC) apply based on the gross salary. Here's a basic structure you can follow:
🎈 Gross Salary: This is the total salary before any deductions.
🎡 PF Deduction: If the gross salary is equal to or less than Rs. 15,000, then PF is applicable. The PF amount equals 12% of the gross salary.
🎡 ESIC Deduction: If the gross salary is equal to or less than Rs. 21,000, then ESIC is applicable. The ESIC amount equals 0.75% of the gross salary.
🈴 CTC Calculation: The CTC is the Gross Salary minus the PF and ESIC deductions.
Here's a step-by-step guide on how to do this:
Step 1: First, determine the gross salary of the employee.
Step 2: Check the gross salary against the thresholds for PF and ESIC.
➡️ If the gross salary is equal to or less than Rs. 15,000, calculate the PF. The formula to calculate PF is: Gross Salary * 0.12.
➡️ If the gross salary is equal to or less than Rs. 21,000, calculate the ESIC. The formula to calculate ESIC is: Gross Salary * 0.0075.
Step 3: Subtract the PF and ESIC amounts (if applicable) from the gross salary to get the CTC.
I hope this helps; let me know if you have any other questions.
Please note that this information is based on applicable labor laws in India, specifically the Employees' Provident Funds and Miscellaneous Provisions Act, 1952, and the Employees' State Insurance Act, 1948. I suggest referring to these acts for more detailed information.
Remember, the above structure is just a basic guide. Depending on the company's policy and the employee's designation, other components like HRA, LTA, bonus, and special allowances may also be part of the CTC.
From India, Gurugram
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
CTC Structure-1.pdf
CTC Structure.xls