dhana.M
4

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
Ankit Ramani
1

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
karthik nayudu
80

Hi Please find the attached working which may help you.... Regards Karthik
From India, Vijayawada
Attached Files (Download Requires Membership)
File Type: docx New Microsoft Office Word Document (2).docx (14.0 KB, 207 views)
File Type: docx New Microsoft Office Word Document.docx (11.1 KB, 114 views)

karthik nayudu
80

Hi Please find the attached. Regards Karthik
From India, Vijayawada
Attached Files (Download Requires Membership)
File Type: xls payslip.xls (20.0 KB, 163 views)

Ankit Ramani
1

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
dhana.M
4

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
karthik nayudu
80

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 (Download Requires Membership)
File Type: xls Cite.xls (31.0 KB, 104 views)

dhana.M
4

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
karthik nayudu
80

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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.