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
From India, Thana
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
1856Please 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
thanxqu so much and it is very useful information...you 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
From India, Hyderabad
But any ways it was really very useful excel sheet
From India, Hyderabad
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
From India, Mumbai
Dear Lilakar, Please download the attached file in excel for CTC & Net Salary calculation. Hope it will be helpful to you.
From India, Delhi
From India, Delhi
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.
From India, Haora
You plz try to develop such a sheet covering all those so that we may really benefit.
Albeit,ur effort is highly welcome.
From India, Haora
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?
From India, Mumbai
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?
From India, Mumbai
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
SALARY SHEET CALCULATION.xls
Salary calculation.doc