How to calculate interest u/s 234b, 234c

This query is : Resolved

ankit (Querist)
Follow

25 August 2011 Dear,
I had a query. I am filing ITR 4 online in prescribed excel sheet. But there is difference b/w my excel sheet and automatic interest calculated by that sheet. I had download some sheets from caclub india but there calculation of interest is same as of mine. So please help me how to gap that difference. urgent

Pragnesh

Pragnesh (Expert)
Follow

25 August 2011 IF you are sure that your working is correct than u can modify ITR 4 interest cell and put correct amount. Recheck your TDS, advance tax and self assessment date.

CA PARAS BAFNA

CA PARAS BAFNA (Expert)
Follow

25 August 2011 234B:
1. Check whether TDS & Advance Tax have been deducted from the tax liability.
Balance Tax Payable is say 33298.
Check Whether it has been taken by you
as 33,300 or 33,200. 33,200 will be correct.
33200*5*.01
.
234C

While taking 30% 60% 100% each time you have to take the following formula to get
Integral value at 100.
Suppose in -F45 cell 24985 is the figure.

Use the formula
@Int(F45/100)*100*......

Message likes : 1 times

Upgrade to CAclubindia Pro. Subscribe Now!