Hi Friends,
Will you please give me the detailed structure of salary calculation in an excel sheet depicting the basis on which basic, pf esi, insurance and the professional tax is deducted( ex :the percentages for pf in the basic salary)
Sapan

From India, Ahmadabad
Hi Sapan,
Please find the attachment for calculating the salaries. I am forwarding you some details which I have for this. Just go through it and see if it would be of any use to you. If not, please let me know in detail exactly what is your requirement so that based on that I would try to help you if possible.
Regards,
Sudha

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: doc salarydesigning_168.doc (49.0 KB, 648 views)

Thanks. I was undr the impression thatthe PF is calculated on Basic + DA. Can you clarify. I was told that the Basic + DA should amount to 60% of the total salary. How does one define a yealy increase on the Basic and DA.
This is for asmall diagnostic set up.


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.