Hello.
I have to deduct Final Tds of my staff for march salary. For which i have to calculate final Tds liability of employees.
can any one give me a excel format in which i can feed data and can get results of amt which i hve to deduct.
From India, New Delhi
I have to deduct Final Tds of my staff for march salary. For which i have to calculate final Tds liability of employees.
can any one give me a excel format in which i can feed data and can get results of amt which i hve to deduct.
From India, New Delhi
Excel formats will and can provide wrong results. Also if you deduct less then the entire salary will be disallowed in the Scrutiny done by income tax under section 143(3) + 192(B) + 37 read along with section 201(1) of income tax act. So firstly get a form 12BB from employee. In form 12BB employee will provide details you will need to do tds calculation. Get this format http://www.incometaxindia.gov.in/For...TRFORM12BB.pdf
Now calculate tax according to income tax act and rules. Then see how much you have deducted till date. Recover the rest in march. You can also call for expert help in calculating the same from website in footnote.
From India, Kolkata
180Now calculate tax according to income tax act and rules. Then see how much you have deducted till date. Recover the rest in march. You can also call for expert help in calculating the same from website in footnote.
From India, Kolkata
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
TDS circular.pdf
Format--new TDS rates.xls
BASICS OF TDS ON SALARY-1.doc