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

 

Click Here To Download CTC Format Attached