Need Income Tax Calculation Sheet - 2012-2013 - XLS Download

Dear Hr,
I am new to Compensation and benefit.
I have been given a task to calculate and finalize per month TDS and income tax sheet.
I dont know how to calculate it or what formulae to put.
can some body share this sheet with me, where some formulae is there as per the current income tax slab - 2012-2013.
I will try to leran it and have some explanation on the calculation.
26th April 2012 From India, Gwalior

Please check out this link for FAQs on Income Tax deductions.
You can go through this wiki for various other aspects related to compensation and benefits like PF, ESI, etc.
27th April 2012 From India, Bangalore

Hi, I have calculated the income tax but not sure if it is correct. can any one tell me if it is correct...specially the formulae for tax calculation?
27th April 2012 From India, Gwalior

Attached Files (Download Requires Membership)

Income Tax Working.xls (48.5 KB, 2624 views)