{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["See Interest on TDS here","Months calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"See Interest on TDS here","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,5],[20,1,20,4],[0,8,1,10],[4,8,5,10]]}
["Developed by :- Rahul Fageria         (Jhunjhunu - Raj.)",null,null,null,null,null,null,null,"For any query - Call or WhatsApp- 07827920818"]
[]
["TDS Amount","TDS Deducted Date","Due Date","Challan Date","Delay         (Months)","Interest On Late Deposit of TDS (1.5% p.m.)",null,null,"rahulfageria@gmail.com"]
[2500,"2017-01-02",{"$f":"+IF(B4=\"\",\" \",IF(MONTH(B4)=3,EOMONTH(B4,0)+30,EOMONTH(B4,0)+7))","v":"2017-02-07"},"2017-02-06",{"$f":"IF(H4<=1,\"\",H4)","v":""},{"$f":"IF(E4=\"\",\"\",+ROUNDUP(A4*E4*1.5%,0))","v":""},0,{"$f":"IF(B4=\"\",\"\",IF((D4-C4)<=0,0,(YEAR(D4)-YEAR(B4))*12+MONTH(D4)-MONTH(B4))+1)","v":1}]
[3000,"2017-02-02","2017-03-07","2017-03-08",{"$f":"IF(H5<=1,\"\",H5)","v":2},{"$f":"IF(E5=\"\",\"\",+ROUNDUP(A5*E5*1.5%,0))","v":90},null,{"$f":"IF(B5=\"\",\"\",IF((D5-C5)<=0,0,(YEAR(D5)-YEAR(B5))*12+MONTH(D5)-MONTH(B5))+1)","v":2},"Fill tds amount, deducted date and payment date"]
[3500,"2016-10-02","2016-11-07","2017-02-25",5,263,null,5]
[4000,"2016-11-02","2016-12-07","2017-02-25",4,240,null,4]
[5000,"2016-12-02","2017-01-07","2017-02-25",3,225,null,3]
[1000,"2017-01-02","2017-02-07","2017-02-25",2,30,null,2]
[20,"2017-02-02",{"$f":"+IF(B10=\"\",\" \",IF(MONTH(B10)=3,EOMONTH(B10,0)+30,EOMONTH(B10,0)+7))","v":"2017-03-07"},"2017-03-08",2,1,null,2]
[1000,"2017-02-12","2017-03-07","2017-03-08",2,30,null,2]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[null,null," ",null,"","",null,""]
[{"$f":"SUM(A4:A20)","v":20020},"Total Interest",null,null,null,{"$f":"SUM(F4:F20)","v":879}]
[null,null,null,null,null,"Download Source- http://taxguru.in/"]

{"sheet":"Months calculation","index":1,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Sometimes Deductor deposit TDS after the due date without Interest, hence when return processed, demand notice raised by TRACES and penalize heavy interest on late payment. But some Deductor does not know how to calculate Interest on delay TDS Payment. "]
["The interest is to be calculated as per illustrations below: "]
["Case 1:"]
["Q-1, Tax Deducted on 25th June, TDS deposited on 10th July (due date was 7th July)"]
["The period of 26th June to 30th June will be calculated as one month (being part of a month) & from 1st July to 9th July will also be treated as one month. As such in this case, the interest payable is for two months. Total interest would be 3%. Sounds odd, but it is true -  for a delay of 3 days, one has to pay interest for two months. "]
["Case 2:"]
["Q-4, Tax Deducted on 20th March, TDS deposited on 5th May  (due date was 30th April)"]
["The period of 20th March to 31st March will be calculated as one month, 1st April to 30th April will be another month & from 1st May to 5th May will be treated as another one month. As such in this case, the interest payable is for three months. Total interest would be 4.5%. For a 5 day delay, the interest payable is for 3 months. "]
["Logic behind this calculation is that, if dues are not paid on time, the interest for each month (or part thereof) is to be paid right from the date of deduction till date of deposit of the TDS. Each month is treated based on the ‘Calendar Month’ instead of counting the number of days."]