WBXPress

Simple Income Tax Calculator 2013

Home Forums Excel Utility Simple Income Tax Calculator 2013

  • This topic is empty.
Viewing 10 posts - 1 through 10 (of 28 total)
  • Author
    Posts
  • #67716
    Anonymous
    Inactive

    Hi,
    I hope my efforts to create this utility will be helpful to all. Though this utility has been created for the Financial Year 2012-2013, It may be used in future too. I have not made changes of the Form-16, as the same will also be generated through COSA and also can be collected form the Incometax website.
    This utility has many more features than the previous one and necessary changes has been made as per the changes made in Income tax act. NPA, Taxable and exempted allowances, income from other sources like pension, savings account and many more has been included. Exemption of House Rent Allowance U/s 10(13A) has also been included and a separate sheet has been added for that calculation. Please read the whole thoroughly before using this utility. If you have any doubt or suggestion, feel free to post the same. Your feedback is exigent.

    #73326
    Anonymous
    Inactive

    Thanx for including NPA, but where I include Grade Pay. Is there any seperate column necessory or not? please include it if required. Letter size and column width may be little small. Secondly can you take into account bank interest in other income source where upto 10,000/anum is not taxable. Thirdly,suppose a man is transferred from one place to another place in the middle of financial year, then can COSA calculate form 16? and how? will you plz tell?

    #73328
    Anonymous
    Inactive

    Grade pay has been included in Basic pay. No need to include other column. Are you having any difficulty to view the table? I have no problem.
    Secondly savings bank interest upto 10,000 will be exempted u/s 80TTA and that has already been included.
    Thirdly ,suppose a man is transferred from one place to another place in the middle of financial year, then form 16 will be issued separately by both the D.D.O. for the respective period and that should be created by COSA. Anyway this form 16 may also be used instead of COSA. We used this last year too.

    #73329
    Anonymous
    Inactive

    Its ok. I am grateful to you. i have no problem to see it. i am not in a position to suggest you. Can the first column name changed to (BP+GP), instead of Basic?

    #73330
    Anonymous
    Inactive

    You are welcome. I think you can change that though B.P.+ G.P. = Basic as per new Ropa.

    #73333
    Anonymous
    Inactive

    i fail to understand HRA exeption under 10(13A) particularly this part-
    c)Rent paid over 10 % of Salary (Rs.70,000 – 10% of Rs.6,06,871)
    why this part is fixed?
    although no problem with calculation.
    regards.

    #73335
    Anonymous
    Inactive

    Column ‘I’ of Form 16 may be widened a little.

    #73336
    Anonymous
    Inactive

    i fail to understand HRA exeption under 10(13A) particularly this part-c)Rent paid over 10 % of Salary (Rs.70,000 – 10% of Rs.6,06,871)why this part is fixed?although no problem with calculation.regards.

    Thanks for the observation, problem solved.

    Column ‘I’ of Form 16 may be widened a little.

    Done

    #73360
    Anonymous
    Inactive

    Dear Som,
    S I T C 2013 its a very nice. but i think u add one more colum in deduction colum for GFP refundable Adv.
    All the best
    Arindam

    #73361
    Anonymous
    Inactive

    Thanks for your feedback. One of our friend requested me to add exemption u/s 57, I shall make all the necessary changes having more feedback.

Viewing 10 posts - 1 through 10 (of 28 total)
  • You must be logged in to reply to this topic.