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
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Karthik Nayudu
Regional Manager - Hr
+1 Other

Use factoHR and automate your HR processes

Mobile-first hire to retire HR and Payroll software that automates all HR operations and works as a catalysts for your organisational growth.



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, 203 views)
File Type: docx New Microsoft Office Word Document.docx (11.1 KB, 110 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, 162 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, 103 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

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.







About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

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