Information For Payroll Breakup - Xls Download

panchmatia
Dear All,
please let me know what is the breakup for the salary structure like HRA,BASIC,PF,ESIC,BONUS.
Preeti
Amitmhrm
Hi Preeti,
The contents of the salary break up is as below, you can prepare it at the suitability of your own. HRA would be 50 or 60% of basic.
Basic
HRA
TA
Other Allowance
MobileReimbursement / Month
Gross Per Month = Sum of all the above.
GrossPer Annum= 12*Gross/Month
PF Contribution= 12% of Basic/Annum
ESIContribution = 4.75% of Gross/Annum
Medical = The mediclaim facility provided to an employee who are not covered under ESI as the maximumceiling 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 asBonus
Annual Fixed GrossCost= Gross/Annum+ Ex-gratia
Annual Total Cost = AFGC + PF+ESIC
Annual total cost is also called as CTC.
Hope now it will be very much clear to you,
if you have any query feel free to ask.
Regards,
Amit Seth.
gayathri.suraparaju
Hey
I am attaching a Template . Check the excel . It should give you a clear picture . lemme know how did it work !
Cheers,
Gayathri
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