How do you calculate TDS from Salary?
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Labor & Employee Relations

How do you calculate TDS from Salary?

lokeshsharma9 Started The Discussion:

Hi, Kindly explain me how do you calculate TDS from Salary? What is TDS ?please tell me to calculate ? Why do you deduct? Lokesh

shreekanth.pr - Member Since: Sep 2007
Dear Lokesh, TDS is deducted @10% if the employee has PAN, If not,it is 20% of the salary.

abbasiti - Member Since: May 2010
Dear Lokesh,

I shall insert an Excel worksheet (but comparitively simple) for Income Tax Calculation on salary for the Financial Year 2010-11 (Assessment Year 2011-12). Prior to that I wish to explain some details to get an idea to enter the inputs.

On gross salary the following deductions are applicable.
1) Professional Tax
2) House Rent in excess of 1/10th of salary subject to ceiling equivalent to HRA
3) Interest on Housing loan subject to ceiling Rs. 1,50,000.
4) Refund on Housing loan, savings, tution fee to 2 children etc. altogether subject to ceiling Rs.100,000.
5) In addition savings on infrastructure bonds upto Rs. 20,000.
6) Other than the above one lakh, 15000 to 20000 towards medi claim premium, 40000 to 60000 towards treatment on specified diseases like Motor Neuron disease, 75000 to 100,000 towards disabilty etc. are also admissible for deduction.

Now taxable income can be calculated as follows.

Gross salary - total deductions = Taxable income

Tax payee can be categorised into 3.
1) Non Seniors - Male
2) Non Seniors - Female
3) Senior Citizens (65 years old & above)

If the taxable income is Rs. 2,40,000, a Senior Citizen is fully exempted from paying tax. Non Senior Female has to pay in excess of Rs.1,90,000 & Non Senior Male in excess of Rs.1,60,000.

Beyond the above income, one has to pay 10% upto Rs.5,00,000, 20% there after upto Rs.8,00,000 and 30% in excess of Rs.8,00,000. In addition, an education cess @ 3% will be charged on Total Tax.

I shall quote on example.

Gross income of a Non Senior Male - Rs. 12,00,000

Deductions (actual) : Professional Tax - 12000, Housing loan interest - 2,00,000, Total savings/deductions - 2,50,000, Savings on Infrastructure bond - 25,000, other deductions over 1,00,000 - 50,000.

Admissible total deductions (subject to ceiling limits) - 12000+150000+100000+20000+50000 = 332000

Taxable income, 1200000 - 332000 = 868000

For Non Senior Male :

Rs. 1,60,000 is exempted.
For next 340000 (500000-160000), 340000x10% = 34000 -(1)
For next 300000 (800000-500000), 300000x20% = 60000 -(2)
For next 68000 (868000-800000), 68000x30%= 20400 -(3)

Tax - (1)+(2)+(3) = 114400

Also For Non Senior Female Tax is, 114400-3000 = 110400
and Senior Citizens Tax is, 114400-8000 = 106400

Education Cess, 114400*3% = 3432.

Total Tax - Rs. 1,17,832

See Excel Sheet. Enter gross salary and deductions/savings applicable in green colour column. Results will be occured in yellow colour. The red colour is used for static datas.

ABBAS.P.S,
Secretary,
ITI Employees' Association ,
ITI Ltd, PALAKKAD - 678 623,
KERALA, INDIA.
Ph. +91 9447 467 667


Attached FilesProvided by community member abbasiti. Join us to learn and grow with your peers.
File Type: xls Income Tax Calculator.xls (17.0 KB, 12133 views)
ajeetroy - Member Since: Mar 2010
Thank you mr.abbas.p.s. To teach us a lot of tds on salary. Thank you very much. Regards ajeet

Meena@gmail - Member Since: Dec 2010
I would wants to know the full form of TDS....Is it Tax Deductible at source...or Total Deductible Salary???? Please help!!!!

sapna.ece@gmail.com - Member Since: Jan 2009
Dear All,

My company is into excavation work and Earth work contractors...there are drivers, helpers, operators, supervisors...who has salary 9000 per month, 11500 per month like that...so will education cess be applicable....

Please guide me about the industry...

nilesh & pallavi - Member Since: Dec 2010
Kindly explain me how do you calculate TDS from Salary? What is TDS ?please tell me to calculate ? Why do you deduct? Lokesh

nilesh & pallavi - Member Since: Dec 2010
Hi, Kindly explain me how do you calculate TDS from Salary? What is TDS ?please tell me to calculate ? Why do you deduct? Lokesh

nilesh & pallavi - Member Since: Dec 2010
Dear Lokesh,

I shall insert an Excel worksheet (but comparitively simple) for Income Tax Calculation on salary for the Financial Year 2010-11 (Assessment Year 2011-12). Prior to that I wish to explain some details to get an idea to enter the inputs.

On gross salary the following deductions are applicable.
1) Professional Tax
2) House Rent in excess of 1/10th of salary subject to ceiling equivalent to HRA
3) Interest on Housing loan subject to ceiling Rs. 1,50,000.
4) Refund on Housing loan, savings, tution fee to 2 children etc. altogether subject to ceiling Rs.100,000.
5) In addition savings on infrastructure bonds upto Rs. 20,000.
6) Other than the above one lakh, 15000 to 20000 towards medi claim premium, 40000 to 60000 towards treatment on specified diseases like Motor Neuron disease, 75000 to 100,000 towards disabilty etc. are also admissible for deduction.

Now taxable income can be calculated as follows.

Gross salary - total deductions = Taxable income

Tax payee can be categorised into 3.
1) Non Seniors - Male
2) Non Seniors - Female
3) Senior Citizens (65 years old & above)

If the taxable income is Rs. 2,40,000, a Senior Citizen is fully exempted from paying tax. Non Senior Female has to pay in excess of Rs.1,90,000 & Non Senior Male in excess of Rs.1,60,000.

Beyond the above income, one has to pay 10% upto Rs.5,00,000, 20% there after upto Rs.8,00,000 and 30% in excess of Rs.8,00,000. In addition, an education cess @ 3% will be charged on Total Tax.

I shall quote on example.

Gross income of a Non Senior Male - Rs. 12,00,000

Deductions (actual) : Professional Tax - 12000, Housing loan interest - 2,00,000, Total savings/deductions - 2,50,000, Savings on Infrastructure bond - 25,000, other deductions over 1,00,000 - 50,000.

Admissible total deductions (subject to ceiling limits) - 12000+150000+100000+20000+50000 = 332000

Taxable income, 1200000 - 332000 = 868000

For Non Senior Male :

Rs. 1,60,000 is exempted.
For next 340000 (500000-160000), 340000x10% = 34000 -(1)
For next 300000 (800000-500000), 300000x20% = 60000 -(2)
For next 68000 (868000-800000), 68000x30%= 20400 -(3)

Tax - (1)+(2)+(3) = 114400

Also For Non Senior Female Tax is, 114400-3000 = 110400
and Senior Citizens Tax is, 114400-8000 = 106400

Education Cess, 114400*3% = 3432.

Total Tax - Rs. 1,17,832

See Excel Sheet. Enter gross salary and deductions/savings applicable in green colour column. Results will be occured in yellow colour. The red colour is used for static datas.


Regards,
Nilesh Karjawkar
(Legal Compliance & Audit
Knight Frank(I) Pvt Ltd

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


17
LIKES

15981
VIEWS

8
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network