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)
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)
1872Please 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)
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)
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
Acknowledge(0)Amend(0)
From India, Delhi
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(1)Amend(0)
From India, Haora
Acknowledge(1)Amend(0)
Dear Lilakar,
Please download the attached file in Excel for CTC & Net Salary calculation. I hope it will be helpful to you.
TDS Deduction in CTC Calculation
In your CTC calculation Excel sheet, your take-home column does not specify TDS deduction. Are we not supposed to take tax into consideration? Of course, the figures you quoted were within the allowable limits, but for anyone who draws a salary above 200,000 p.a.
Salary Revision and TDS Implications
Also, I wanted to know if someone joins the company in the month of October and is given 18K per month, which is revised to 20K per month starting in January, the total drawn salary for that fiscal year would be 114,000 and therefore falls under the tax exemption limit. Should we be deducting TDS in such a case?
Regards.
From India, Mumbai
Acknowledge(0)Amend(0)
Please download the attached file in Excel for CTC & Net Salary calculation. I hope it will be helpful to you.
TDS Deduction in CTC Calculation
In your CTC calculation Excel sheet, your take-home column does not specify TDS deduction. Are we not supposed to take tax into consideration? Of course, the figures you quoted were within the allowable limits, but for anyone who draws a salary above 200,000 p.a.
Salary Revision and TDS Implications
Also, I wanted to know if someone joins the company in the month of October and is given 18K per month, which is revised to 20K per month starting in January, the total drawn salary for that fiscal year would be 114,000 and therefore falls under the tax exemption limit. Should we be deducting TDS in such a case?
Regards.
From India, Mumbai
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.
SALARY SHEET CALCULATION.xls