No Tags Found!


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 professional tax are deducted (e.g., the percentages for PF in the basic salary)?

Sapan
sapanshere@gmail.com

From India, Ahmadabad
Acknowledge(0)
Amend(0)

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 your requirement is so that based on that I can 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)

Acknowledge(0)
Amend(0)

Thanks. I was under the impression that the 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 yearly increase on the Basic and DA.

This is for a small diagnostic set up.


Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.