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