Cite Contribution
Community Manager
Sr. Hr Executive @ Polymerupdate
+4 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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.
Please consider the discussion and the inputs shared in this link;
(Cite Contribution)

thanxqu so much and it is very useful could have put some formula for the mobile allowance so even that shall also show the effect in the sheet...
But any ways it was really very useful excel sheet

I am new to HR dept. If somebody earn Rs. 500000/- per annum, how to calculate the basic salary, what will be the deductions.
Dear Lilakar, Please download the attached file in excel for CTC & Net Salary calculation. Hope it will be helpful to you.

Attached Files
File Type: xls CTC.xls (29.5 KB, 536 views)

Sheet does not cover too many issues;like Bonus @ 8.33%,Leave salary calculation,Gratuity liability etc.
You plz try to develop such a sheet covering all those so that we may really benefit.
Albeit,ur effort is highly welcome.

In you CTC calc excel, your take home column do not specify TDS deduction. Are we not suppose to take tax into consideration?
Ofcourse the figures you quoted was in the allowable limits, but for anyone who draws salary above 200,000 p.a.
Also I wanted to know, if someone joins the company in the month of Oct and is given 18K pm which is revised to 20k pm january onwards, the total drawn salary for tht FY would be 1,14,000 and so it is under the tax exemption limit. So should we be deducting TDS in such case?

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™