excel sheet with farmula giving wrong tax rates

[sharif lakhani]

Has any one experienced problem with tax rates applied by IT2 sheet. on the income of 1100000/ it applied rate of 9.95 instead of 10 percent.
second it calculates surcharge on avg basis for 3.5 months. which is not realistic in many cases, any comments.
SL

[olympia]

true..... i experiance the same error... in my case it calculate tax rate as 15.59% instead of 16%...... i called PRAL & tell them the issue but all in vain.

[sharif lakhani]

thanks olympia brother, yet there is another issue of surcharge that formula sheet calculates at 3.5 months average of year. Now in many cases salaries vary through out year in this case surcharge deducted by company on actual period IE march 15 to June 30 2011 is different from what is given by the formula. and tax payable is generated. Now on the fbr website they have given a guidance about how the surcharge will be deducted on salaried persons. and it says employer will deduct surcharge on actual salary for the period march 15-june30 2011. Kindly share your experience.
SL

[sharif lakhani]

is the difference in tax rate due to marginal relief??

[Information Consultant]

FBR should rectify the flaws in return and allow user to enter manually the figure of surcharge. I have no source of income from Mar to june still return calculate surcharge .

[AbdulSamad]

Sir, Actually FBR are calculating of below formula regarding surcharge

Payment Amount/12 x 3.5 months x 15%

PLease note 3.5 shows after 15.03.2010 to 30.06.2011 surcharge duration period.

Therefore those person / Companies whose payments had been paid before 15.03.2011, they are also paying now and FBR not rectifying there system.