Salary Statment - Xls Download

Dear seniors,
Please help me how to prepare salary statment,how to calculate Basic.DA.HRA,Conveniance allowence,my salary 9000 Rs plz calculate this and plz send me attachment of salary statment.

Dear Member,
9000
Basic 3600 PF 432
HRA 1800 PT 80
Conv 800 7650 512
Medical 1250
Children Allow 200
City Compansation Allow 618
Gross Salary 8268 Take Home 7756

PF 432
Bonus 300
CTC 9000

Hi Please go to search for salary calculation and sample sheet else can go to right at the page to get the related material as there are lot more material available that can fulfill your requirement or assist you in learning

Dear Ms. Susheela,
Please find attached the exact salary statement with different salary levels. Same thing you can download and continue for the future. Please note the following;
1. Basic and DA should be as per the Minimum Wages notification.
2. If salary is more, then the formula can be as it is in the sheet.
3. You should update the salary details in Master Sheet.
4. For OT calculation If your company is paying single then remove *2 part.
5. Do not delete any formulas.
For any further clarifications you may contact me on 9481847810 - Bangalore.
Regards,
RK

Hello Seniors!
I am doing MBA, H.R. Option but i am not ble to undestand the way that computed all things regarding salary statment from his salary of 9000, specially basic, medical, conv, city comp allow and gross salary.
thanking you for your details !
9000
Basic 3600 PF 432
HRA 1800 PT 80
Conv 800 7650 512
Medical 1250
Children Allow 200
City Compansation Allow 618
Gross Salary 8268 Take Home 7756

PF 432
Bonus 300
CTC 9000[/QUOTE]

Hai,
There is hardly any connection between OT double payment and PF deduction.. Both are seperate statutes and there is no any interlink.
RK

Dear Harji
The provident fund contribution is not applicable upon over time wages and the same will not be deducted from the salary of the employees whether it is being paid single or double.
Regards
R B Yadav
Advocate

Dear Sir,
I have doubt in this, how much percentage you have been taken ctc salary, kindly help me regards this,
With Regards
Shyamala

Hai,
Please find below the following calculations for CTC;
1. 13.61% PF Contribution on Basic and DA
2. 8.33% of Basic and DA as Bonus
3. 4.81% of Basic and DA as Gratuity
4. 4.75% of Gross as ESI (if fixed gross salary is below 15K)
5. Performance incentives, Target incentives if any.
Clubbing above all together with Gross Salary is considered as CTC.
Regards,
RK

Dear Shyamala,
Basic 50% total salary
HRA 35% on basic
Childern allow 200 per child 100 maximum 2child
Conv 800
Medical allow 1250
CCA 35%
Food Allow 10%
Bonus: 8.33% on basic
PF 12% on basic
ESI 1.75% on basic
Graduity 4.81%
Uniform Allow 15%
mobile allow
etc.....