• Feb
  • 01
  • 2012

Auto TDS and TDS interest calculator

Article ID 47237 | Posted In Income Tax | , | 18 Comments » Print Friendly and PDF

This calculator calculates TDS amount deductible under section 194C, 194D, 194A, 194H, 194I and 194J. The calculator calculates TDS automatically on the basis of status of the Assessee and if PAN No. is not provided it will show the rate f TDS as 20%.  The calculator also calculates interest on TDS amount deducted but not paid. The calculator is useful to compute TDS liability in respect of expenses or payment related to period on or after 01.04.2011.

Download Auto TDS Calculator




  • naresh

    if TDS on 194C against 12000/- payable for the month of June 2015.
    then amount paid on 10-07-2015 insted of 07-07-2015( due date).but i have not paid interest part i paid only basic amount in 3 days delay.

    in that case how much interest applicable for me ( is only 1 month or till date) please clarify it


    TOTAL AMT.86735 TDS @2% under sec. 94C ( Exhibition stall rent exp.) DATE OF BILL 5.8.2015……….WHAT WILL BE THE INTEREST AMT. FOR THIS IF PAYMENT IS MADE ON 07.01.2016


    If i deducted the tds of 1400/- in 31.07.2015 but i making the tds payment on 30.11.2015 how to calculate the interest please tell me


    Dear Sir

    Kindly help me for Tds Mater like if I deduct Tds Amount for Rs. 10000 on dated 01/09/2014 then how much interest amount will be till date 13/01/2015

    Thanks With Regards

  • Punit Joshi

    thank you
    Very Helpful sheet

    please update with new changes

    Thank you once again



  • prawayesh bisht

    Dear Sir,

    How can i calculate interest on TDS late payment.



    Your Sheet2 is protected but i want to work for FY 2012-2013,Please help to solve it

    98947 92715

  • Hrishikesh

    Dear sir,
    From when,due date of tds deposit for the provisions made on 31st march became 7th april? Its 30th of april.Please correct the sheet.It is misleading the people.

  • susant

    it is very nice workout,
    but  how change cell wide & height

  • deepak

    IT dept has issued notivce under sec.200A to pay interest calculated @ 1.5% while we havwe recovered and deposited int. @ 1 %

  • vaishali swami

    Super Application Thanx A Lot

  • Rishikesh

    Very nice application.

  • Sheetal Jadhav

    It is very nice work out ….
    useful for us

  • Jayanti Bhanushali

    There is problem when entering date of credit or date of dedcution error in due date
    how to correction?

  • Jayesh

    It is very nice worked out…

    But there is a problem anybody wants to add in rows then how to do???

  • Pradeep

    USeful excel sheet