Dear All, Can you please help me with steps of Salary Calculation. Any format available to CTC & Net Salary calculation. Please make it as smiple as possible for me to understand.
From India, Thana
Acknowledge(0)
Amend(0)

Greetings,

Please consider the discussion and the inputs shared in this link: https://www.citehr.com/110240-salary...ion-excel.html

Regards, (Cite Contribution)

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

Thank you so much for the very useful information. It would have been even better if you could have included some formulas for the mobile allowance to show its effect in the sheet. Anyway, it was a really helpful Excel sheet.
From India, Hyderabad
Acknowledge(0)
Amend(0)

I am new to HR dept. If somebody earn Rs. 500000/- per annum, how to calculate the basic salary, what will be the deductions.
From India, Mumbai
Acknowledge(0)
Amend(0)

Dear Lilakar, Please download the attached file in excel for CTC & Net Salary calculation. Hope it will be helpful to you.
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls CTC.xls (29.5 KB, 605 views)

Acknowledge(0)
Amend(0)

Sheet does not cover too many issues, like Bonus at 8.33%, Leave salary calculation, Gratuity liability, etc. Please try to develop a sheet covering all those so that we may really benefit. Your effort is highly welcome.
From India, Haora
Acknowledge(0)
Amend(0)


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

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.