Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel.
|SALARY BREAK-UP||value||PF deposited in PF department|
|NAME||ANNUAL BENEFITS:-||ESIC deposited with ESIC dept|
|DESIGNATION||Individual Component (IC)||Prof tax paid to PT department|
|DEPARTMENT||Bonus||Lumpsum LTA payable in August in some company|
|DATE OF JOINING||Bonus paid at the time of Diwali|
|Gratuity will be paid after 5 yrs services|
|SALARY HEAD||AMOUNT (Rs.)||SALARY HEAD||AMOUNT (Rs.)||canteen subsidy|
|Basic||12,000||PF Employee||1,440||Company Component (CC)|
|H R A||4,800||ESI Employee||–||Coverage towards Group Mediclaim Policy (GMP)|
|Conv. All||800||Profession Tax(PT)||Coverage towards Health insurance scheme (HIS)|
|Leave Travel Allowance(LTA)||840||Income Tax||2,946||Coverage towards Group Saving Linked Insurance (GSLI)|
|Child Education Allowance(CEA)||600||HIS||Coverage towards personal accident|
|Site Allowance||4,750||GSLI||280||Employee deposit Linked insurance (EDLI)|
|Special Pay||5,950||Coverage towards Group Term Life (GTL)|
|Medical Allowance||1,250||Term Insurance|
|SALARY (GROSS) / PM||53,851|
|Pension Employer(8.33% of Minimum (basic or 6500))||541|
|PF Employer( PF employee-pension Employer)||899|
|Company Component (CC)||2,541|
|SALARY (CTC) / PM||58,332||TOTAL DEDUCTION||4,666|
|Cash in Hand (PM)||49,185|
|SALARY (CTC) / PA||699,984|
|1. TDS / FBT Deduction – as applicable|
|Prepared by||Checked by||Authorised by|
Search Sample Formats:
Please find atached files of Application Form, INTERVIEW ASSESSMENT FORM, Manpower Requisition, CTC with PF, ESIC .
Please find attached files of Application Form, Leave Policy, INTERVIEW ASSESSMENT FORM, Manpower Requisition CTC with PF ESIC.
This is New CTC Scale for Industries Related.