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.
Please find attached the format of the CTC sheet and Salary Slip.