lilakar.pallavi
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
Cite Contribution
1859

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
ramakrishnaakula
1

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
nair_rk007
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
as1978
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, 604 views)

Achetan Sen
1

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
Ankita1001
737

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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.