Calculate Basic Salary From Ctc - Xls Download - CiteHR
Sr. Executive - Hr
Hr Executive
Chief Executive Officer
+10 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
could anybody tell me how to calculate the basic salary from ctc with formula....plz help me
could you tell why this fourmula is used for basic salary??? =round(sum(c3-500)*100/192,0))

Attached Files
Membership is required for download. Create An Account First
File Type: xls general staff.xls (28.5 KB, 20614 views)

Let assume your CTC PA is 200000
then divided by 12 then u get Monthly CTC means 200000/12=16,666Pm
then you can considered aither 40 or 50 % of that CTC as Basic I.e., 16,666*50/100=8333 is your monthly Basic

Recently im also working as a H.R with one company bt my specilisation is not finance.. need human resource policy and the criteria of payroll how to calculate when we have to provide only basic salary..plz anyone can provide me the format of leave policy 4 any organisation.
Reasonably good formula to adapt will be as under
1. 35% of CTC as Basic
2. 30% of CTc as Monthly allowances like HRA Conveyanc etc
3. 5% of CTC as annual benefits like LTA etc
4.20% of CTC as Bonus or Performance payment This will be a varaiable pay
5.10 of CTC towards PF Gratuity and other social securtiy measures
This formula generally works well Few modifications in percentages can be made to suit your requirements
T Sivasankaran

Basic salary depends upon Grade/level of employee. It will differ from company to company. Every company has/may have a different slabs for various grades/levels of employees. Lower the grade lower is the basic salary. Basic salary may be 30% - 50% of gross/CTC.

Dear Pintu,
Exact calculation of Basic Salary from CTC cannot be done untill and unless all the components of the salary be identified.
Taking a reference point of "Basic Salary", CTC is derived and not the other way round.

The components of CTC differ from company to company.There is no such specific compulsory %age to be deemed as Basic from the Gross or CTC. In case of Minimum wages we take Basic Approx. 80-95% of Gross, while in other case i.e. higher slab it may deemed approx. 40-50% of Gross.

Dear Sir,
CTC includes Basic + Other allowances + Annual benefits + Fringe benefits. (Tota salary + Other emoluments) per annum.
CTC Differs from one concern to another concern as per their policy. Normally Basic Pay will be 30 to 50% of CTC % 12 = Per month emoluments as per Co.Policy.
LL,HR & IR Consultant

Hi to all,
Hope you are doing great!
I have a small doubt, actually HRA, Conveyance, Medical allowance how much exemption in income tax for the F.Y 2011-12, Plse Advice to me & give some sample files
thanks in advance

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™