Calculting Salary - Xls Download

rohini_mca
hi friends,
Can u explain me detailly about,for calculating a salary for an employee
Amitmhrm
Hi Rohini,
The contents of the salary break up may be as below, you can prepare it at the suitability of your own. HRA would be 50 or 60% of basic.
Basic
HRA
CCA - 825/- is exempted from tax
Other Allowance
Mobile Reimbursement
Medical Reimbursement of 1250/month is exempted from tax
Gross Per Month = Sum of all the above.
Gross Per Annum= 12*Gross/Month
PF Contribution= 12% of Basic/Annum
ESI Contribution = 4.75% of Gross/Annum
Medical = The mediclaim facility provided to an employee who are not covered under ESI as the maximum ceiling for ESI is 10000/Month.
Getting more than this will be covered under Mediclaim or it depends on company policy
EX-Gratia/Bonus = A fixed amount as Bonus
Annual Fixed Gross Cost= Gross/Annum+ Ex-gratia
Annual Total Cost = AFGC + PF+ESIC
Annual total cost is also called as CTC.
Apart from this Food coupons, Holiday package and Furnishing items are included in their CTC.
Hope it must help you to clear your queries up to some extent.
Regards,
Amit Seth.
rgs_mys
Dear Amit,
Very well explained.Absolute clarity.
Thanks for that.I am sure this information will help many to understand
salary calculations.
Regards,
RGS.
bahalpragati
Hi Guys,
Please find the sheet attached for calculating the salary
let me know if you guys find any difficulty
Regards
Pragati
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute