Salary Formate Xls Download

Hi
In the attached sheet every thing is formulated, if you go the shell you will find the percentage.
Convayance : Rs.800 is fixed, even if you pay more under convayance component IT will calculated only for Rs.800*12Months.
Medical : Rs.1250/- is fixed, even if you pay more under Medical reimbursement IT will be calculated only for Rs.1250*12Months.
Chill
Karthik Nayudu
[Login to view]

Dear Mr Karthik,
It is very useful calculations.
I've a small doubt. U shown 10% only is applicable TAx for Advisor. That 10% is upto how much? and what limit.
Pl.clarify.
Regards,
Murali

Hi Murali
Tax is applicable on gross salary,there will not be any statutory deductions except PT. Hene Advisor's Gross will be Rs.200/- more than net and CTC will also be the same as gross as there are no employer contributiuons.
Cheers
Karthik

Hi murali....
these are the tax slabs for this current financial year i.e April 2011- march 2012
upto 1,80,000---- no tax
1,80,001-5,00,000-- 10 percent
5,00,001-8,00,000-- 20 percent
above 8,00,000 -- 30 perent.

Hi ,
I am Sunita HR Executive working at Volkswagen Whitefeild for an Automobile dealership.
Kindly let me know what are statutory document that needs to be maintained at our dealership and also what are the abstract that needs to mentioned in notice board of our service centre.
Regards,
Sunita

Hi Karthik,
Kindly suggest how to calculate all the components if in hand salary is 30k without pf deduction
Thanks