I am facing issue with the IT2 execl tool available at the IT site. The STCG which is taxable at 15% (sp. rate) is being calculated correctly and also reflecting in SPI-SI. But there are couple of issues (i) Its showing total as 0 in SPI-SI sheet (ii) the Special Tax is not being carried to PART B-TTI sheet (Row 1b). Wanted to know if this is a bug and possible solution around it.
21 July 2010
IN CGOS YOU SHOULD FILL SALES CONSIDERATION , COST OF ACQUISITION .THEN IN COLUMN 5 ENTER CAPITAL GAIN U/S 111A. aFTER VALIDATION SYSTEM WILL AUTOMATICALLY TRANSFER THE VALUE IN SP SI AND PARTB TTI SHEET
Thanks. I am doing that. Infact numbers are correctly appearing in SPI - SI row#2 (1A). 2 problems that I see (i) Total Tax i.e. row 11 is not being calculated. (ii) This number is not reflecting in PART B-TTI sheet (Row 1b). even after clicking "Calculate Tax" button. All other calculations are absolutely fine.
I downloaded latest version yesterday. If you have a different/correct version of excel.. can you please mail me at nareshi@hotmail.com