Sr. Executive - Hr
Hr Executive
Chief Executive Officer
+11 Others

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, 20547 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
Its depends upon the company policy.Either it could be 50% or 40% on Gross Salary. Regards Vikas
Hi Vikas_hr My 40% HRA, Coveyance Rs. 800, Per month Medical Allowance Rs. 1250/- per month how much Exemption in Saral (Income Tax) per year plse send some sample files thanks & regards manu
I need help on biometric system. I recently joined company where lot of people is salesforce. If they report in the morning, they dont report in evening, they sign off field after telling their Manager. How will I handle this. Also people in office going for long lunches though company policy says clearly one hour. How i will handle? Pls help.
Basic salary can be calculate i.e total gross salary in a month divide by 2.54 or 2.47.then shown basic salary.It is my funda cheap & best. Satish Kumar Vishwakarma 9580136707
Dear Sir, % of Basic,HRA,Conveyance,Medical is calculated as per law or depend upon company policy.If this are decided by law then pl.guide the related act for this. Regards, Himanshu Trivedi.
Dear All,
Anyone can tell me that, what the State Govt. have decided the min wage that should be inhand salary or basic?
Exp...if Delhi Govt Min Wage is-10686 then what we have keep the basic, same or could be anything?
Lalit Mathpal
Hi HHH123,
This is nisha, I was going through the thread discussion, Even i did not understand how is the below calculation done. I have gone through the excel sheet.
Could you please explain me below formula?
Hi, Could you please clarify that conveyance allowance is standardised as per the policy? Or is it the company can standardised its own conveyance allowance percentage? please help
Hi, kindly help me with the salary structure for Rs. 22000, Rs.15000 and Rs. 10000 as final in hand salary that we get. need HRA and DA allowance structured for this. no PF is deducted
I have gone through the xl sheet
This Company has probably has followed the following
1. Assume 100 is equal to Basic
2. 100 Basic
40 HRA
15 CON
12 PF
4.75 ESI
4 Gratuity
8.33 Bonus
3 Uniform
192.08 Total
192 Round off

3. They probably would have reached 192 using the above methodology And if 192 is CTC then 100 would be Basic They must have some reason to minus Rs 500 which is Uniform allowance It is purely an internal calculation But more or less they have followed the above methodology
This is also one of the easiest way of arriving at Structure. This will bring Basic closer to 52% of CTC
This will work out well at lower salary brackets
my cts is 20000 pm , please calculate TDS for this
Iam unable to unhide the figures from sheet 1 , pls share the password.
Pls clarify why the amount of 1750 is deducted in asst manager calculation sheet
Please help to out to calculate employee annual CTC....
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™