{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["TDS-use tab button","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":"TDS-use tab button","index":0,"n_rows":171,"n_cols":14,"rows_kept":171,"cut":false,"hidden":false,"merged":[[103,0,103,3],[1,0,1,8],[0,4,0,5],[0,6,0,8],[0,1,0,3]]}
["Developed by :- Rahul Fageria -       Jhunujhunu (Rajasthan)","rahulfageria@gmail.com",null,null,"07827920818",null,"Make Payment in Challan no. 281"]
["Note:- If There is No PAN than TDS Rate will be 20% in all cases so fill PAN or 10 Digits (only type this 1234567891) for correct Rate of TDS But if you will fill PAN than Category of PAN holder Will show."]
["Nature of Payment","Section","Limit","TDS Rate","PAN","Category","Amount Of Bill/Payment","TDS Amount","Net Payable to Party"]
["193- Interest on securities (On Debentures)",{"$f":"IFERROR(VLOOKUP(A4,$A$137:$D$171,2,0),\"N.A.\")","v":193},{"$f":"IFERROR(VLOOKUP(A4,$A$137:$D$171,3,0),0)","v":5000},{"$f":"IF(E4=\"\",\"20%\",IFERROR(VLOOKUP(A4,$A$137:$D$171,4,0),\"--\"))","v":0.1},"ACPPF2232C",{"$f":"IF(D4=\"20%\",\"--\",IF(N4=\"4\",\"--\",IF(N4=\"P\",\"Non Comp.\",\"Comp.\")))","v":"Non Comp."},21000,{"$f":"ROUNDUP(IF(G4>C4,G4*D4),0)","v":2100},{"$f":"+G4-H4","v":18900},null,null,null,{"$f":"+LEFT(E4,4)","v":"ACPP"},{"$f":"+RIGHT(M4,1)","v":"P"}]
["193- Interest on securities (On Debentures)",193,5000,0.1,"ACPCF2232C","Comp.",50001,5001,45000,null,null,null,"ACPC",{"$f":"+RIGHT(M5,1)","v":"C"}]
["194D-  Insurance Commission","194D",15000,0.05,"ACPCF2232C","Comp.",30000,1500,28500,null,null,null,"ACPC","C"]
["194I- Rent - on Plant & Machinery, Equipment and Furniture & Fittings","194I",180000,0.02,1234567891,"--",0,0,0,null,null,null,"1234","4"]
["194I- Rent - Land & Building","194I",180000,0.1,1234567891,"--",0,0,0,null,null,null,"1234","4"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,1234567891,"--",0,0,0,null,null,null,"1234","4"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",0,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",0,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",0,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",0,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",0,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc",{"$f":"+RIGHT(M24,1)","v":"c"}]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1,"ACPcF2232C","Comp.",null,{"$f":"ROUNDUP(IF(G30>C30,G30*D30),0)","v":0},{"$f":"+G30-H30","v":0},null,null,null,"ACPc",{"$f":"+RIGHT(M30,1)","v":"c"}]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,{"$f":"IFERROR(VLOOKUP(A36,$A$137:$D$171,2,0),\"N.A.\")","v":"N.A."},{"$f":"IFERROR(VLOOKUP(A36,$A$137:$D$171,3,0),0)","v":0},{"$f":"IF(E36=\"\",\"20%\",IFERROR(VLOOKUP(A36,$A$137:$D$171,4,0),\"--\"))","v":"--"},"ACPcF2232C",{"$f":"IF(D36=\"20%\",\"--\",IF(N36=\"4\",\"--\",IF(N36=\"P\",\"Non Comp.\",\"Comp.\")))","v":"Comp."},null,0,0,null,null,null,{"$f":"+LEFT(E36,4)","v":"ACPc"},"c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194- Deemed Dividend u/s 2 (22) (e) other than listed company",194,5000,0.1,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194B- Winning from Lotteries/Crossword/Puzzle","194B",10000,0.3,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["194BB- Winning from Horse Race","194BB",10000,0.3,"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,{"$f":"IFERROR(VLOOKUP(A68,$A$137:$D$171,2,0),\"N.A.\")","v":"N.A."},{"$f":"IFERROR(VLOOKUP(A68,$A$137:$D$171,3,0),0)","v":0},{"$f":"IF(E68=\"\",\"20%\",IFERROR(VLOOKUP(A68,$A$137:$D$171,4,0),\"--\"))","v":"--"},"ACPcF2232C",{"$f":"IF(D68=\"20%\",\"--\",IF(N68=\"4\",\"--\",IF(N68=\"P\",\"Non Comp.\",\"Comp.\")))","v":"Comp."},null,0,0,null,null,null,{"$f":"+LEFT(E68,4)","v":"ACPc"},"c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,{"$f":"ROUNDUP(IF(G94>C94,G94*D94),0)","v":0},{"$f":"+G94-H94","v":0},null,null,null,"ACPc",{"$f":"+RIGHT(M94,1)","v":"c"}]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,{"$f":"IFERROR(VLOOKUP(A100,$A$137:$D$171,2,0),\"N.A.\")","v":"N.A."},0,{"$f":"IF(E100=\"\",\"20%\",IFERROR(VLOOKUP(A100,$A$137:$D$171,4,0),\"--\"))","v":"--"},"ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
[null,"N.A.",0,"--","ACPcF2232C","Comp.",null,0,0,null,null,null,"ACPc","c"]
["Total Bill/Payment Amount, TDS Amount, Net Payable",null,null,null,null,null,{"$f":"SUM(G4:G103)","v":101001},{"$f":"SUM(H4:H103)","v":8601},{"$f":"SUM(I4:I103)","v":92400}]
[]
[]
[null,null,null,null,null,null,null,"Download Source- http://taxguru.in/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select expenses here from your P&L A/c","Select Section","Limit"]
["192- Payment of Salary",192,"Avg. Basis",0]
["192A- Payment of accumulated balance of provident fund which is taxable in the hands of an employee (with effect from 01.06.2015).","192A",50000,0.1]
["193- Interest on securities (On Debentures)",193,5000,0.1]
["193- Interest on securities (Other Than Debentures)",193,10000,0.1]
["194- Deemed Dividend u/s 2 (22) (e) other than listed company",194,5000,0.1]
["194A- Interest other than Interest on Securities (By Banks, Co-op. Society or Post Office)","194A ",10000,0.1]
["194A- Interest other than Interest on Securities (By Others)","194A ",5000,0.1]
["194A- Interest on compensation awarded by payment of Motor Accident Claims Tribunal W.e.f. 01/06/2015","194A ",50000,0.1]
["194B- Winning from Lotteries/Crossword/Puzzle","194B",10000,0.3]
["194BB- Winning from Horse Race","194BB",10000,0.3]
["194C- Payment to Contract/Advt/Sub Contract (Sigle Contract) to Ind./HUF","194C",30000,0.01]
["194C- Payment to Contract/Advt/Sub Contract (Sigle Contract) to other than Ind./HUF","194C",30000,0.02]
["194C- Payment to Contract/Advt/Sub Contract (Aggregate of Contracts) to Ind./HUF","194C",100000,0.01]
["194C- Payment to Contract/Advt/Sub Contract (Aggregate of Contracts) to other than Ind./HUF","194C",100000,0.02]
["194D-  Insurance Commission","194D",15000,0.05]
["194DA- Payment in respect of life insurance policy","194DA",100000,0.01]
["194E- Payment to non- resident sports person or sports association","194E",0,0.2]
["194EE- Payment in respect of deposit under National Savings scheme","194EE",2500,0.1]
["194F- Repurchase of units by MF/UTI","194F",0,0.2]
["194G- Commission on sale of lottery�tickets","194G",15000,0.05]
["194H- Commission/Brokerage other than Insurance Com. Or Com. On Lottery Tickets","194H",15000,0.05]
["194I- Rent - on Plant & Machinery, Equipment and Furniture & Fittings","194I",180000,0.02]
["194I- Rent - Land & Building","194I",180000,0.1]
["194IA- Payment on transfer of immovable property other than agricultural land","194IA",5000000,0.01]
["194J- Professional Fee/Technical charges/Royalty & Non-compete fees","194J",30000,0.1]
["194J(1)(ba)- Any remuneration or commission paid to director of the company","194J(1)(ba)",0,0.1]
["194LA- Compensation on acquisition of immovable property","194LA",200000,0.1]
["194LB- Income by way of interest from infrastructure debt fund (non-resident or foreig comp.) ","194LB",0,0.05]
["194LC- Income by way of interest by an Indian specified company to a non-resident / foreign company on foreign currency approved loan / long-term infrastructure bonds from outside India","194LC",0,0.05]
["195- Any Interest or other sum chargable under I.T. Act payable to Non Resident or Foreign Company",195,"Diff. Rates",0]
["196A- Income in respect of units of non resident","196A","Exempt",0]
["196B- LTCG from units referred to in Sec. 115AB","196B",0,0.1]
["196C- Income from foreign currency bonds or GDR (including long-term capital gains on transfer of such bonds) (not being dividend)","196C",0,0.1]
["196D- Income of foreign institutional investers from securities","196D",0,0.2]

{"sheet":"See Interest on TDS here","index":1,"n_rows":106,"n_cols":8,"rows_kept":106,"cut":false,"hidden":false,"merged":[[103,1,103,3],[0,0,1,5]]}
["Developed by :- Rahul Fageria"]
[]
["TDS Amount","TDS Deducted Date","Due Date","Challan Date","Delay         (Months)","Interest On Late Deposit of TDS (1.5% p.m.)"]
[{"$f":"+'TDS-use tab button'!H4","v":2100},"2016-01-02",{"$f":"+IF(B4=\"\",\" \",IF(MONTH(B4)=3,EOMONTH(B4,0)+30,EOMONTH(B4,0)+7))","v":"2016-02-07"},"2016-02-10",{"$f":"IF(H4<=1,\"\",H4)","v":2},{"$f":"IF(E4=\"\",\"\",+ROUNDUP(A4*E4*1.5%,0))","v":63},0,{"$f":"IF(B4=\"\",\"\",IF((D4-C4)<=0,0,(YEAR(D4)-YEAR(B4))*12+MONTH(D4)-MONTH(B4))+1)","v":2}]
[{"$f":"+'TDS-use tab button'!H5","v":5001},"2016-01-02","2016-02-07","2016-04-24",{"$f":"IF(H5<=1,\"\",H5)","v":4},{"$f":"IF(E5=\"\",\"\",+ROUNDUP(A5*E5*1.5%,0))","v":301},null,{"$f":"IF(B5=\"\",\"\",IF((D5-C5)<=0,0,(YEAR(D5)-YEAR(B5))*12+MONTH(D5)-MONTH(B5))+1)","v":4}]
[{"$f":"+'TDS-use tab button'!H6","v":1500},"2016-02-02","2016-03-07","2016-04-24",3,68,null,3]
[{"$f":"+'TDS-use tab button'!H7","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H8","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H9","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H10","v":0},null,{"$f":"+IF(B10=\"\",\" \",IF(MONTH(B10)=3,EOMONTH(B10,0)+30,EOMONTH(B10,0)+7))","v":" "},null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H11","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H12","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H13","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H14","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H15","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H16","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H17","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H18","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H19","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H20","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H21","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H22","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H23","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H24","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H25","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H26","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H27","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H28","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H29","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H30","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H31","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H32","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H33","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H34","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H35","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H36","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H37","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H38","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H39","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H40","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H41","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H42","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H43","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H44","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H45","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H46","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H47","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H48","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H49","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H50","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H51","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H52","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H53","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H54","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H55","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H56","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H57","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H58","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H59","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H60","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H61","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H62","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H63","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H64","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H65","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H66","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H67","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H68","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H69","v":0},null," ",null,{"$f":"IF(H69<=1,\"\",H69)","v":""},{"$f":"IF(E69=\"\",\"\",+ROUNDUP(A69*E69*1.5%,0))","v":""},null,{"$f":"IF(B69=\"\",\"\",IF((D69-C69)<=0,0,(YEAR(D69)-YEAR(B69))*12+MONTH(D69)-MONTH(B69))+1)","v":""}]
[{"$f":"+'TDS-use tab button'!H70","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H71","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H72","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H73","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H74","v":0},null,{"$f":"+IF(B74=\"\",\" \",IF(MONTH(B74)=3,EOMONTH(B74,0)+30,EOMONTH(B74,0)+7))","v":" "},null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H75","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H76","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H77","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H78","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H79","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H80","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H81","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H82","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H83","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H84","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H85","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H86","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H87","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H88","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H89","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H90","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H91","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H92","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H93","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H94","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H95","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H96","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H97","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H98","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H99","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H100","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H101","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H102","v":0},null," ",null,"","",null,""]
[{"$f":"+'TDS-use tab button'!H103","v":0},null," ",null,"","",null,""]
[{"$f":"SUM(A4:A103)","v":8601},"Total Interest",null,null,null,{"$f":"SUM(F4:F103)","v":432}]
[]
[null,null,"Download Source- http://taxguru.in/"]

{"sheet":"Months calculation","index":2,"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."]