I have attached a document in which I have prepared Attendance sheet for ten employees and also designed CTC for 2 employees. And some Queries are also put into the sheet please help me in this..... Please check the sheet once and as I am doing it for first time so please let me know if I have done it correctly or not ( or please mention if I am wrong anywhere ).
From India, New Delhi
5From India, New Delhi
Hi Maya,
I have seen your attachment
1. when you dont know the gross that time take CTC and devide by 12
2. take employer contributions
3. and use this formula
Gross = Monthly CTC-Employer Contribution
2.ESI ceiling limit is 15000
3. Same formula for sepaerating Employer Contribution from CTC
Gross= CTC-Employer contribution
4.Yes Graduity is only employer contribution and contribuion rate is 4.81% of basic
From India, Mumbai
I have seen your attachment
1. when you dont know the gross that time take CTC and devide by 12
2. take employer contributions
3. and use this formula
Gross = Monthly CTC-Employer Contribution
2.ESI ceiling limit is 15000
3. Same formula for sepaerating Employer Contribution from CTC
Gross= CTC-Employer contribution
4.Yes Graduity is only employer contribution and contribuion rate is 4.81% of basic
From India, Mumbai
Hi,
professional Tax (PT) varies between each states (of India) and, in a state, between the local governance systems (like Municipal Corporation, Panchayat etc). As per your state norms check for PT slab.
For TDS, download the tax calculator as link provided below. Explanation also available in the tax calculator
Nithya's Tax Calculator
regs
Narayan
From India, Hyderabad
professional Tax (PT) varies between each states (of India) and, in a state, between the local governance systems (like Municipal Corporation, Panchayat etc). As per your state norms check for PT slab.
For TDS, download the tax calculator as link provided below. Explanation also available in the tax calculator
Nithya's Tax Calculator
regs
Narayan
From India, Hyderabad
ECN aaaa
FINAL GRADE 5
PAYROLL LOCATION OTHERS
VEHICLE N
DEPENDENT (IF CHILD) Y
ANNUAL CTC 600000
MONTHLY CTC 50000
BASIC 25000
HRA 13056
TRANSPORT ALLOWANCE 800
CHILD EDUCATION ALLOWANCE 200
CITY ALLOWANCE (IF ANY) 0
SPECIAL ALLOWANCE 0
MONTHLY GROSS 39056
HELPER ALLOWANCE 0
BUSINESS ATTIRE 5000
MEDICAL 1042
BONUS 700
EMPLOYER'S PF 3000
MONTHLY GRATUITY 1202
ANNUAL CTC 600000
MONTHLY CTC 50000
From India, Gurgaon
FINAL GRADE 5
PAYROLL LOCATION OTHERS
VEHICLE N
DEPENDENT (IF CHILD) Y
ANNUAL CTC 600000
MONTHLY CTC 50000
BASIC 25000
HRA 13056
TRANSPORT ALLOWANCE 800
CHILD EDUCATION ALLOWANCE 200
CITY ALLOWANCE (IF ANY) 0
SPECIAL ALLOWANCE 0
MONTHLY GROSS 39056
HELPER ALLOWANCE 0
BUSINESS ATTIRE 5000
MEDICAL 1042
BONUS 700
EMPLOYER'S PF 3000
MONTHLY GRATUITY 1202
ANNUAL CTC 600000
MONTHLY CTC 50000
From India, Gurgaon
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
CTC Calculator.xls