HI,
If you want the detailed TDS calculator I can mail it to you. In short it works like this
Total Gross Salary
Less Exemptions
HRA,
Medical
& others
Less Deductions
Less other taxes Paid
Add Other Income earned
Net Taxable Income
Tax on Taxable Income
EC
HEC
Total Tax payable
Hi Check the sheet you have to enter data only in exemption data and payroll image rest all others are automatic, alternatively you can also look at first sheet and manually derive the deductions / exemptions and get to know how the tax is calculated. This sheet is configured for FY 12-13, i am preparing new one for 13-14 .enable all macros if any issue mail to [Login to view]
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute