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
Hello Aditya, Here I have attached the file again . And looking for your feedback so that I can improve my work.. Thanks
From India, New Delhi
From 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 Aditya
Thank you for your reply.
I got your point. Please also mention whether I have designed the Salary structure correctly or not ??????
Also please mention the improvement area ????????
How to calculate TDS and PT ???????
Regards
Priyanka
From India, New Delhi
Thank you for your reply.
I got your point. Please also mention whether I have designed the Salary structure correctly or not ??????
Also please mention the improvement area ????????
How to calculate TDS and PT ???????
Regards
Priyanka
From India, New Delhi
Hi,
You have designed salary strucher correctly.
PT is on total earnings of particular month
If your working in Maharashtra then PT slab
5000 - Nil
5001 to 10000 - 175
10001 and above - 200 and for Feb Month 300
From India, Mumbai
You have designed salary strucher correctly.
PT is on total earnings of particular month
If your working in Maharashtra then PT slab
5000 - Nil
5001 to 10000 - 175
10001 and above - 200 and for Feb Month 300
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
Hi Priyanka, Enclosing herewith the CTC Calculator which shall help you a lot to understand it. Regards, Pushkar
From India, Delhi
From India, Delhi
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