Calculate Basic Salary From Ctc - Xls Download

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?
Regard
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?
=round(sum(c3-500)*100/192,0))

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

Nisha
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
5 CEA
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
Sivasankaran