Karthik Nayudu
Regional Manager - Hr
+1 Other

Dear all, Can anyone help me how to calculate this structure with formulas BASIC HRA CONVEYANCE SPL ALL. LTA MED ALL EX-GRATIA GRATUITY thanks, Dhana
From India, Chennai
Dear, Dhana,
plz. kindly calculate on following formula :
Basic : 50% of CTC
HRA : 20% of Basic
Conve. Allowance : 2%
Edu. Allowance : 2%
PFP : 20% Of CTC
Medica l & others : as per ur co.'s conveniency :

From India, Ahmadabad
Hi Please find the attached working which may help you.... Regards Karthik
From India, Vijayawada

Attached Files
File Type: docx New Microsoft Office Word Document (2).docx (14.0 KB, 195 views)
File Type: docx New Microsoft Office Word Document.docx (11.1 KB, 109 views)

Hi Please find the attached. Regards Karthik
From India, Vijayawada

Attached Files
File Type: xls payslip.xls (20.0 KB, 160 views)

Hi, Dhana,
Surely , i'll Explain u.....Just read folllowing example :
Suppose a person have monthly income of 10,000,
then we can calculate his net salary as follows :
Basic : 5000 (50% of CTC)
HRA : 1000 (20% of Basic)
Con. Allowance : 100 (2% of Basic)
Edu. Allo. : 100 (2% of Basic)
PFP : 1927 (20% of CTC- Flexibal)
Medical : 200
Other : 500
so Employee's in hand amount will be :
Rs. 8827
other deductions are as follows :
PF - 12% of Basic
ESI - 1.75% OF GROSS
Bonus - 8.33 % of Basic......

From India, Ahmadabad
Karthik,
Thanks for payslip attachment.
In that how you calculated special and other allowance
and for medi claim how you derived rs.200.
For gratuity will we have to take 4.87% of basic.
For employer contribution , is it PF is 12% but it is calculated on13.61 on basic.
Please clear my doubt.
thanks,
dhana

From India, Chennai
Medi Claim is Avg 200/Month if it is Individual policy with 100000/- Insurance Coverage.
Gratuity sorry it was error.
Minus from proposed gross to get exat gross because Convayance 800 & Medical reim 1250 are completely non taxable so we have to put these components.
For Tax calculation s the HRA will be considered 40% on Basic.
Please find the attached......

From India, Vijayawada

Attached Files
File Type: xls Cite.xls (31.0 KB, 101 views)

Karthik,
In this attachment there is no pf calculations for employee.
Another thing is for employer contribution the pf amount is 12% only but you calculated as 13.61 on basic.
Please clear my doubt.
thanks,
dhana

From India, Chennai
It varies from employer to employer most of the companies are exempting PF for above 6500 Basic salaried employees.
Employee Contribution 12% + Employer Contribution 12% +1.10% Administration Charges + 0.50% EDLI(Employee Deposit Linked Insurance) + 0.01% Administration Charges on EDLI.
Total : 12+12+1.10+0.5+0.01=25.61 Hence the employer contribution will be 13.61%.

From India, Vijayawada
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™