Mistake in itr1 excel template

ITR 2350 views 9 replies

bhumika

Professional

51 Points Joined December 2010

I am trying to fill ITR 1 and generating XML with my appropriate data. But one error is coming "Income under salary cannot be less than as shown in sch TDS1".

Actually in ITR1 form worksheet "Income Details" cell AM41 we will file our actual income coming as per final exemptions available and in worksheet "TDS" cell E4 we will write form 16 data (Income chargeable under head salary). Now this data will be higher or equal to cell AM41. But if you put higher data than it is showing error as "Income under salary cannot be less than as shown in sch TDS1" though the value E4 is higher than AM41 but if you put lower value than AM41 than it will accept and XML will be generated which is wrong. Actually the person who has created this spreadsheet has used ">" instead of "<" and this spreadsheet is not at all verified by incometax department.

I want to file return but not able to generate XML. Trying to call no 08025186960 given on income tax website but always busy whenever tried (Tried for 2 hrs). Why in India even small minister has 4-5 phone lines but for crores of taxpayer only 1 line which is always busy.

Please can any one tell me what to do or send any other file?

Thanks,

Bhumika

Attached File : 477730 999819 itr1 2012 13 r1.zip downloaded: 275 times

Replies (9)

@CS Siddharth Bumb.

B.Com CA Final CS

5270 Points Joined September 2009

Dear Bhumika,

in tDS take amount which is taken under salary, dont take as per form 16.

The amount which you took in income from salary should enter in TDS .....

amount should not less than or greater than amount which is provided under income from salaries...

Rectify me if i am wrong...

Regards,

Siddharth Bumb

Email - sidbumbhelp @ gmail.com

WWW.SIDDHARTHBUMB.BLOGSPOT.COM

bhumika

Professional

51 Points Joined December 2010

Dear Siddharth,

I am sorry but I am not agree with this. In TDS sheet I have to enter form 16 data only and in first sheet I will calculate actual one. So it is obvious that many times you will not get same value. and it is mostly smaller than TDS sheet.

How to rectify error? or who will do another revision in this sheet? or who will convey this to income tax department so that they can rectify and put another verified sheet on income tax website.

Thanks

@CS Siddharth Bumb.

B.Com CA Final CS

5270 Points Joined September 2009

in TDS sheet you have to enter amount of Income from salaries which you enter in ITR and not as per form 16... read it again... u got it???

bhumika

Professional

51 Points Joined December 2010

but it should be as per form 16.. it is clearly written.

@CS Siddharth Bumb.

B.Com CA Final CS

5270 Points Joined September 2009

are... u will fill in salary column as per form 16.... and such amount will come in TDS sheet, it means automatically u will fill as per form 16 in sheet TDS.... in TDS sheet you have to fill after exemption and all that..

bhumika

Professional

51 Points Joined December 2010

In the form it is clearly written that in E4 cell "Details of tax deducted at sourse from salary - As per form 16 issued by employer" Income chargeable under head of salary. which means whatever issued by employer I have to write. But if I want to some deduction which is not shown in form 16 then i wil calculate that income and put in cell AM41 of "Income details".

Prasad

Sr. Manager

617 Points Joined April 2011

Bhumika

you mean you have a mistake in the form 16? if yes it is better to correct FORM 16

Please fill in the amount chargable to tax in TDS 1 and also under the head income from Salary. The total amount of income from Salary should match.

Khokon2006

Student

23 Points Joined June 2012

Did Anyone notice the following bug in AY 12-13 ITR-1Excel Tool:-

I was trying to prepare a AY 12-13 IT return using the 2012_ITR1_PR12.xls downloaded from IT Department web site.

I found that the utility is making a serious and consistent mistake while calculating the tax.

I checked by putting various figures for the taxable income, found it is always adding Rs 7000 to the correct tax figure.

For example, it will calculate 92000 instead of 85000 for Senior Citizen with net taxable income of 8 lakhs. If the net taxable income is changed, it will again calculate a tax which is 7000 more than what the tax should be.

After finding the bug, I tried to manually insert the correct tax figure, however the utility would not permit xml file generation without using the auto tax calculation [ which is giving wrong tax figure].

*******

email sent to intimations @ cpc.gov.in requesting them to correct the bug and repost the excel utility for preparing the return. No reply received yet.