Cost To Company or CTC Salary Format in Excel
Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel.
company’s Logo | ANNEXURE-I | Notes:- | |||||||
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 | |||||||||
EARNINGS | DEDUCTIONS | Exgratia | |||||||
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 | |||||||
Personal Pay | 15,361 | ||||||||
Additional Allowance | 7,500 | ||||||||
SALARY (GROSS) / PM | 53,851 | ||||||||
Pension Employer(8.33% of Minimum (basic or 6500)) | 541 | ||||||||
PF Employer( PF employee-pension Employer) | 899 | ||||||||
ESI Employer | – | ||||||||
Gratuity | 500 | ||||||||
Superannuation | |||||||||
Company Component (CC) | 2,541 | ||||||||
Medical (Reimb) | – | ||||||||
Conv (Reimb) | – | ||||||||
Telephone (Reimb) | – | ||||||||
Others (Reimb) | – | ||||||||
SALARY (CTC) / PM | 58,332 | TOTAL DEDUCTION | 4,666 | ||||||
Cash in Hand (PM) | 49,185 | ||||||||
SALARY (CTC) / PA | 699,984 | ||||||||
Notes: | |||||||||
1. TDS / FBT Deduction – as applicable | |||||||||
Prepared by | Checked by | Authorised by | |||||||
Sample Formats attached to be used for Recruitment
Please find atached files of Application Form, INTERVIEW ASSESSMENT FORM, Manpower Requisition, CTC with PF, ESIC .
Click Here To Download Application Form
Categories: HR Tags: Application Form, Assessment, CTC, Form, Interview, Manpower Requisition, Recruitment
Sample formats attached to be used for Recruitment
Please find attached files of Application Form, Leave Policy, INTERVIEW ASSESSMENT FORM, Manpower Requisition CTC with PF ESIC.
Click Here To Download Application Form
Categories: Recruitment Format Tags: Application Form, CTC, INTERVIEW ASSESSMENT FORM, Manpower Requisition, Recruitment
New CTC Scale (Legal)
This is New CTC Scale for Industries Related.
Format of CTC and Salary Slips
Please find attached the format of the CTC sheet and Salary Slip.
Categories: HR, Salary Format Tags: CTC, Salary Slip