Dear all, Good evening
Can any one provide me the Excel working sheet for Calculate TDS on Salary
Thanks in advance
Raj Kumar
CA Narendra Gupta
(CA )
(256 Points)
Replied 09 August 2010
hi raj ,
for eg,
Male - not a senior citzen
Salary - rs 5lac
80c - 1lac
80d - 15000
so tax comes to rs.31930
which is to be distributed in 12 months,
i.e., rs 2661 is your tds for a month.
Its just simple if you know current slab rate.
Current slab rate is,
Till 160000 no tax
160000-300000 - 10
300000-800000 - 20
800000& above - 30
CA. BIJENDER KR. BANSAL
(ACA, B.COM)
(8148 Points)
Replied 09 August 2010
GO TO FILE SECTION AND DOWNLOAD THE FILE AND PUT THE DATA IN SHEET . THERE IS THREE SHEET ONE FOR MALE, SECOND FOR FEMALE AND THIRDONE FOR SENIOR CITIZEN.
FILL UP THE DATA ACCORDING TO YOU IN WHICH THE EMPLOYEE FALLS.
/share_files/income-tax-caculator-for-salaried-person-fy-2010-11-27578.asp