Calculate Basic Salary From Ctc - Xls Download

Could anybody tell me how to calculate the basic salary from CTC with a formula? Please help me.

Could you tell me why this formula is used for basic salary?

=ROUND(SUM(C3-500)*100/192,0)

Hi there,

Let's assume your CTC per annum is 200,000. If you divide this by 12, you will get your Monthly CTC, which means 200,000/12 = 16,666 per month.

Next, you can consider either 40% or 50% of this CTC as your Basic salary. For example, if you take 50% of 16,666, the calculation would be 16,666 * 50/100 = 8,333 as your monthly Basic salary.

I hope this clarifies the calculation process for you. Let me know if you need further assistance or information.

Recently, I am also working as an HR with one company, but my specialization is not finance. I need human resource policy and the criteria of payroll, how to calculate when we have to provide only basic salary. Please, can anyone provide me with the format of leave policy for any organization?

Reasonably good formula to adapt will be as under:

1. 35% of CTC as Basic.
2. 30% of CTC as Monthly allowances like HRA, Conveyance, etc.
3. 5% of CTC as annual benefits like LTA, etc.
4. 20% of CTC as Bonus or Performance payment. This will be a variable pay.
5. 10% of CTC towards PF, Gratuity, and other social security measures.

This formula generally works well. Few modifications in percentages can be made to suit your requirements.

- T. Sivasankaran

Basic salary depends on the grade/level of the employee and may vary from company to company. Each company may have different salary slabs for various grades/levels of employees, with lower grades receiving lower basic salaries. The basic salary typically ranges from 30% to 50% of the gross/CTC.

Regards

Dear Pintu,

The exact calculation of the Basic Salary from CTC cannot be done until all the components of the salary are identified. Taking "Basic Salary" as a reference point, CTC is derived, and not the other way around.

Regards

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

Regards,

Dear Sir,

CTC includes Basic + Other allowances + Annual benefits + Fringe benefits (Total 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.

D. Gurumurthy
LL, HR & IR Consultant
Hyderabad.

Hi all,

Hope you are doing great! I have a small doubt regarding HRA, Conveyance, and Medical allowance. How much exemption is available in income tax for the F.Y. 2011-12? Please advise me and provide some sample files.

Thanks in advance.

Manu

It depends on the company policy. Either, it could be 50% or 40% of Gross Salary.

Regards,
Vikas

Hi Vikas_hr,

My 40% HRA, Conveyance Rs. 800 per month. Medical Allowance Rs. 1250 per month. How much exemption in Saral (Income Tax) per year? Please send some sample files.

Thanks & regards,
Manu

I need help on the biometric system. I recently joined a company where a lot of people are in Salesforce. If they report in the morning, they don't report in the evening; they sign off the field after telling their manager. How will I handle this? Also, people in the office are going for long lunches, even though the company policy clearly states one hour. How will I handle this? Please help.

Basic salary can be calculated by dividing the total gross salary in a month by 2.54 or 2.47. Then the basic salary is shown. It is my fundamental principle for being cost-effective and efficient.

Satish Kumar Vishwakarma
9580136707

Dear Sir,

The percentage of Basic, HRA, Conveyance, and Medical is calculated as per the law or depends on company policy. If these are decided by law, then please guide me on the related act for this.

Regards,
Himanshu Trivedi.

Dear All,

Can anyone tell me what the state government has decided regarding the minimum wage that should constitute the in-hand salary or basic pay?

For example, if the Delhi government's minimum wage is 10686, then what should we keep as the basic pay - the same amount or could it be anything else?

Regards,
Lalit Mathpal

Hi HHH123,

This is Nisha. I was going through the thread discussion, and I did not understand how the calculation below is done. I have reviewed the Excel sheet.

Could you please explain the formula below?
=ROUND(SUM(C3-500)*100/192,0))

Thank you.

Hi,

Could you please clarify if the conveyance allowance is standardized as per the policy, or if the company can standardize its own conveyance allowance percentage? Please help.

Hi, kindly help me with the salary structure for Rs. 22,000, Rs. 15,000, and Rs. 10,000 as the final in-hand salary that we receive. I need the HRA and DA allowances structured for this. No PF is deducted.

Nisha,

I have gone through the XL sheet. This Company has probably followed the following:

1. Assume 100 is equal to Basic
2. 100 Basic
40 HRA
15 CON
5 CEA
12 PF
4.75 ESI
4 Gratuity
8.33 Bonus
3 Uniform
192.08 Total
192 Round off

They probably would have reached 192 using the above methodology. 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 ways of arriving at the structure. This will bring Basic closer to 52% of CTC. This will work out well at lower salary brackets.

Sivasankaran

My CTC is 20,000 per month. Please calculate TDS for this.

I am unable to unhide the figures from sheet 1. Please share the password.

Please clarify why the amount of 1750 is deducted in the assistant manager calculation sheet.

Hi,

Please help me calculate the employee's annual CTC.