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, 198 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, 161 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
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.

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, 103 views)

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.

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

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

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server