Posts tagged "CTC"

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

Search Sample Formats:

4 comments - What do you think?
Posted by Hrformats - June 14, 2012 at 5:02 AM

Categories: HR   Tags: , ,

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

Click Here To Download CTC

Click Here To Download INTERVIEW ASSESSMENT FORM

Click Here To Download Manpower Requisition

Be the first to comment - What do you think?
Posted by Hrformats - August 26, 2011 at 7:12 AM

Categories: HR   Tags: , , , , , ,

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

Click Here To Download CTC

Click Here To Download INTERVIEW ASSESSMENT FORM

Click Here To Download Manpower Requisition

Be the first to comment - What do you think?
Posted by Hrformats - May 26, 2011 at 9:15 AM

Categories: Recruitment Format   Tags: , , , ,

New CTC Scale (Legal)

This is New CTC Scale for Industries Related.

Click Here To Download New CTC Scale

Be the first to comment - What do you think?
Posted by Hrformats - May 23, 2011 at 9:59 AM

Categories: HR   Tags: ,

Format of CTC and Salary Slips

Please find attached the format of the CTC sheet and Salary Slip.

Click Here To Download Format CTC

Click Here To Download Format Salary Slip

Search Sample Formats:

4 comments - What do you think?
Posted by Hrformats - May 18, 2011 at 9:05 AM

Categories: HR, Salary Format   Tags: ,