{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Due date Dashboard","."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Due date Dashboard","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,36,3],[11,1,11,3],[20,1,20,3],[6,1,6,2],[7,1,7,2],[10,1,10,2],[19,1,19,3]]}
[]
[null,"Punit Prajapati & Co.",null,"www.punitprajapati.com"]
[null,"Chartered Accountants"]
[null,"Celebrating 15 years, 2005-2020"]
[]
[null,null,"GST Due Date, Interest and Late Fee"]
[null,"Select Year",null,2019]
[null,"Select Month",null,"May"]
[null,null,"Expected date of Filling return(dd-mm-yyyy)","2021-08-26"]
[null,null,"GST Payable",100000]
[null,{"$f":"IF(D7=2020,\"Select Category\",\"\")","v":""},null,"Less than than 5 Cr"]
[]
[null,"GSTR - 3B ","GSTR - 1","GSTR - 1 Quarterly"]
[null,{"$f":"IF(D7=2020,'.'!C11,'.'!AR5)","v":"2019-06-20"},{"$f":"IF(D7=2020,'.'!C12,'.'!AR6)","v":"2019-06-11"},{"$f":"IF(D7=2020,'.'!C13,'.'!AR7)","v":"2019-07-31"}]
[]
[null,{"$f":"'.'!AQ28","v":"Total Delay (In Day)"},{"$f":"'.'!AQ30&\" for 3B\"","v":"Late Fees for 3B"},{"$f":"'.'!AQ31","v":"Interest"}]
[null,{"$f":"IF(D7=2020,'.'!C38,'.'!AR28)","v":798},{"$f":"IF(D7=2020,'.'!C40,'.'!AR30)","v":10000},{"$f":"IF(D7=2020,'.'!C41,'.'!AR31)","v":39353.424657534248}]
[]
[]
[null,"Notes :"]
[null,"This sheet is for the State of Gujarat only. It is merely for facility and Punit  Prajapati & Co.,  does not accept anyliablity. User descrition is advised. "]
[null,{"$f":"IF(D7=2020,'.'!B55,IF('.'!AQ35&'.'!AQ38=\"\",\"No notes for the selected Tax Period.\",'.'!AQ35&\"\n\n\"&'.'!AQ38))&\"\n\n\"&IF('.'!D3=\"NO\",Con_For,\"\")","v":"\n\nFurther, if GSTR - 3B return is filed during 1-7-2020 to 30-9-2020 period, Maximum Late Fees will be Rs. 500 Per Return. Also No late fees for Nil Return.\n\n"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"version 1.1 JL20 "]
[null,"All Rights Reservaed: Punit Prajapati & Co., Designed by CA Viral Patel & CA Prakash Prajapati "]

{"sheet":".","index":1,"n_rows":55,"n_cols":82,"rows_kept":55,"cut":false,"hidden":true,"merged":[[1,55,1,56],[1,57,1,58],[0,8,0,20],[0,7,3,7],[28,8,29,10],[28,11,28,15],[29,12,29,13],[29,14,29,15],[1,8,2,10],[2,12,2,13],[2,14,2,15],[1,11,1,15],[1,16,1,20],[2,17,2,18],[2,19,2,20],[27,48,27,58],[28,48,28,50],[28,51,28,52],[28,55,28,56],[28,57,28,58],[28,53,28,54],[1,79,1,80],[0,70,0,80],[1,70,1,72],[1,73,1,74],[1,75,1,76],[1,77,1,78],[14,31,21,31],[2,26,2,27],[2,28,3,28],[0,59,0,69],[1,59,1,61],[1,62,1,63],[1,64,1,65],[1,66,1,67],[1,68,1,69],[0,46,2,46],[0,45,2,45],[1,53,1,54],[0,47,2,47],[0,48,0,58],[1,48,1,50],[1,51,1,52],[10,23,11,23],[2,34,2,35],[2,36,2,37],[2,38,2,39],[5,31,12,31]]}
[null,null,null,{"$f":"+AR1","v":"2019-06-01"},null,null,null,"Month in Numerical",2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than 5 Cr",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(AR3,VLOOKUP($AR$4,$AT$4:$CD$15,3,FALSE),VLOOKUP($AR$4,$AT$4:$CD$15,37,FALSE))+1","v":"2019-06-01"},"2023-03-31","Month","Qtrs","Month in Numerical",2019,null,null,null,null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,"GSTR - 1",null,null,"More Than 5 Cr",null,null,null,null,"Less Than 5 Cr",null,null,null,null,null,null,2020,"GSTR - 1",null,null,null,null,null,"Less than than 5 Cr",2020,"GSTR - 3B",null,null,null,null,null,null,null,null,null,"Return Period",null,null,null,null,null,"GSTR - 1",null,null,null,null,"Monthly Extension",null,"No Late Fees if Filed During",null,"No Late Fees of Rs 500 or 0",null,"GSTR - 1",null,null,"GSTR - 3B",null,"Monthly Extension",null,"No Late Fees if Filed During",null,"No Late Fees of Rs 500 or 0",null,"GSTR - 1",null,null,"GSTR - 3B",null,"Monthly Extension",null,"No Late Fees if Filed During",null,"No Late Fees of Rs 500 or 0"]
[null,null,null,{"$f":"+IF(T29&T30&T31=\"YESYESYES\",\"YES\",IF(N34=\"NO\",\"YES\",\"NO\"))","v":"YES"},null,null,null,null,null,null,null,null,"No Late fees",null,"Interest @ 9%",null,null,"No Late fees",null,"Interest @ 9%",null,null,null,"Periodicity","Period","Due Date","Late Fee@ Nil",null,"Last Date of Any Benefits",null,null,"Turnover ","Period","Due Date","Interest @ Nil",null,"Interest @ 9%",null,"No Late fees",null,"Last Date of Any Benefits",null,"Year",{"$f":"+'Due date Dashboard'!D7","v":2019},null,null,null,null,"Month/Qtr","Due Date","Remarks","Due Date","Remarks","From","Up to","From","Up to","From","Up to","Month/Qtr","Due Date","Remarks","Due Date","Remarks","From","Up to","From","Up to","From","Up to","Month/Qtr","Due Date","Remarks","Due Date","Remarks","From","Up to","From","Up to","From","Up to"]
[null,null,null,null,null,null,null,null,"Month/Qtr","Due Date","Remarks","Due Date","From ","To","From ","To","Due Date","From ","To","From ","To",null,null,null,null,null,"From ","To",null,null,null,"(in Previous Year)",null,null,"From ","To","From ","To","From ","To",null,null,"Month",{"$f":"+'Due date Dashboard'!D8","v":"May"},null,"January","1st",1,"2019-01-01","2019-02-11","No. 44/2018 ","2019-02-22","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2018-01-01","2018-10-31","No. 44/2018 ","2018-02-20","No. 56/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-01-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",31]
[null,null,null,null,null,{"$f":"+$H5&$Q$2","v":"1Less Than 5 Cr"},{"$f":"+$H5&$L$2","v":"1More Than 5 Cr"},1,"2020-01-01","2020-02-11","No. 46/2019 ","2020-02-20",null,null,null,null,"2020-02-20",null,null,null,null,null,{"$f":"+MONTH(Y5)&YEAR(Y5)","v":"12020"},"Monthly","2020-01-01","2020-02-10","N.A.","N.A.","N.A.",null,{"$f":"+MONTH(AG5)&YEAR(AG5)&$AE$1","v":"12020More than 5 Cr"},null,"2020-01-01","2020-02-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"GSTR - 3B",{"$f":"JKL","v":"2019-06-20"},null,"February",{"$f":"+AU4","v":"1st"},2,"2019-02-01","2019-03-11","No. 44/2018 ","2019-03-20","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2018-02-01","2018-10-31","No. 44/2018 ","2018-03-20","No. 56/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-02-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",28]
[null,"Select Year",{"$f":"+'Due date Dashboard'!D7","v":2019},null,null,"2Less Than 5 Cr","2More Than 5 Cr",2,"2020-02-01","2020-03-11","No. 46/2019 ","2020-03-20","2020-03-21","2020-06-24","2020-04-05","2020-06-24","2020-03-20","2020-03-21","2020-06-30","2020-07-01","2020-09-30",null,"22020",null,"2020-02-01","2020-03-10","N.A.","N.A.","N.A.",null,"22020More than 5 Cr",{"$f":"+AE1","v":"More than 5 Cr"},"2020-02-01","2020-03-20","2020-03-21","2020-04-04","2020-04-05","2020-06-24","2020-03-21","2020-06-24","2020-06-24",null,"GSTR - 1",{"$f":"PQR","v":"2019-06-11"},null,"March","1st",3,"2019-03-01","2019-04-13","Notification No. 17/2019","2019-04-23","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2018-03-01","2018-10-31","No. 44/2018 ","2018-04-20","No. 56/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-03-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",31]
[null,"Select Month",{"$f":"+'Due date Dashboard'!D8","v":"May"},{"$f":"+VLOOKUP($C$7,$AT$4:$AV$15,3,FALSE)&C6","v":"52019"},null,"3Less Than 5 Cr","3More Than 5 Cr",3,"2020-03-01","2020-04-11","No. 46/2019 ","2020-04-20","2020-04-21","2020-06-24","2020-05-06","2020-06-24","2020-04-20","2020-04-21","2020-07-03","2020-07-04","2020-09-30",null,"32020",null,"2020-03-01","2020-04-10","2020-04-11","2020-07-10","2020-07-10",null,"32020More than 5 Cr",null,"2020-03-01","2020-04-20","2020-04-21","2020-05-05","2020-05-06","2020-06-24","2020-04-21","2020-06-24","2020-06-24",null,"GSTR - 1 Qtrly",{"$f":"MNO","v":"2019-07-31"},null,"April","2nd",4,"2019-04-01","2019-05-11","Notification No. 12/2019 ","2019-05-20","No. 13/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-04-01","2018-10-31","No. 44/2018 ","2018-05-22","No. 16/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-04-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",30]
[null,null,null,null,null,"4Less Than 5 Cr","4More Than 5 Cr",4,"2020-04-01","2020-05-11","No. 28/2020","2020-05-20","2020-05-21","2020-06-24","2020-06-05","2020-06-24","2020-05-22","2020-05-23","2020-07-06","2020-07-07","2020-09-30",null,"42020",null,"2020-04-01","2020-05-11","2020-05-12","2020-07-24","2020-07-24",null,"42020More than 5 Cr",null,"2020-04-01","2020-05-20","2020-05-21","2020-06-04","2020-06-05","2020-06-24","2020-05-21","2020-06-24","2020-06-24",null,null,null,null,"May",{"$f":"+AU7","v":"2nd"},5,"2019-05-01","2019-06-11","Notification No. 12/2019 ","2019-06-20","No. 13/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-05-01","2018-10-31","No. 44/2018 ","2018-06-20","No. 16/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-05-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",31]
[null,"Turnover in Last Year",{"$f":"+'Due date Dashboard'!D11","v":"Less than than 5 Cr"},null,null,"5Less Than 5 Cr","5More Than 5 Cr",5,"2020-05-01","2020-06-11","No. 28/2020","2020-06-27",null,null,null,null,"2020-07-12","2020-07-13","2020-09-12","2020-09-13","2020-09-30",null,"52020",null,"2020-05-01","2020-06-11","2020-06-12","2020-07-28","2020-07-28",null,"52020More than 5 Cr",null,"2020-05-01","2020-06-27","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,null,null,null,"June","2nd",6,"2019-06-01","2019-07-11","Notification No. 12/2019 ","2019-07-20","No. 13/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-06-01","2018-10-31","No. 44/2018 ","2018-07-20","No. 16/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-06-01","No GST Returns","No Remarks","No GST Returns","No Remarks",null,null,null,null,"2020-07-01","2020-09-30",30]
[null,null,null,null,null,"6Less Than 5 Cr","6More Than 5 Cr",6,"2020-06-01","2020-07-11","No. 28/2020","2020-07-20",null,null,null,null,"2020-07-22","2020-07-23","2020-09-23","2020-09-24","2020-09-30",null,"62020",null,"2020-06-01","2020-06-11","2020-06-12","2020-08-05","2020-08-05",null,"62020More than 5 Cr",null,"2020-06-01","2020-07-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"Late Fees Extension (If Any)",null,null,"July","3rd",7,"2019-07-01","2019-08-11","Notification No. 28/2019","2019-08-22","No. 29/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-07-01","2018-10-31","No. 44/2018 ","2018-08-24","No. 34/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-07-01","2018-10-31","No. 44/2018 ","2017-08-25","No. 23/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",31]
[null,"GSTR - 3B",{"$f":"ABCD","v":""},null,null,"7Less Than 5 Cr","7More Than 5 Cr",7,"2020-07-01","2020-08-11","No. 28/2020","2020-08-20",null,null,null,null,"2020-08-22","2020-08-23","2020-09-27","2020-09-28","2020-09-30",null,{"$f":"+Y11&\"2020\"","v":"1st2020"},"Quarterly","1st","2020-04-30","2020-05-01","2020-07-17","2020-07-17",null,"72020More than 5 Cr",null,"2020-07-01","2020-08-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,null,null,null,"August",{"$f":"+AU10","v":"3rd"},8,"2019-08-01","2019-09-11","Notification No. 28/2019","2019-09-20","No. 29/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-08-01","2018-10-31","No. 44/2018 ","2018-09-20","No. 34/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-08-01","2018-10-31","No. 44/2018 ","2017-09-20","No. 21/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",31]
[null,"GSTR - 1",{"$f":"DEF","v":""},null,null,"8Less Than 5 Cr","8More Than 5 Cr",8,"2020-08-01","2020-09-11","No. 28/2020","2020-09-20",null,null,null,null,"2020-10-01",null,null,null,null,null,{"$f":"+Y12&\"2020\"","v":"2nd2020"},null,"2nd","2020-07-31","2020-08-01","2020-08-03","2020-08-03",null,"82020More than 5 Cr",null,"2020-08-01","2020-09-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"Extension - 1 \"No Late Fees\"",null,null,"September","3rd",9,"2019-09-01","2019-10-11","Notification No. 28/2019","2019-10-20","No. 29/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-09-01","2018-10-31","No. 44/2018 ","2018-10-25","No. 34/2018",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30","2017-09-01","2018-10-31","No. 44/2018 ","2017-10-20","No. 35/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",30]
[null,"GSTR - 1 Qtrly",{"$f":"IF(D3=\"YES\",J33,J33+RANDBETWEEN(10,60))","v":""},null,null,"9Less Than 5 Cr","9More Than 5 Cr",9,"2020-09-01","2020-10-11","No. 28/2020","2020-10-20",null,null,null,null,"2020-10-22",null,null,null,null,null,null,null,null,null,null,null,null,null,"92020More than 5 Cr",null,"2020-09-01","2020-10-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"From ",{"$f":"IF(BB31=0,\"No Extension\",BB31)","v":"No Extension"},{"$f":"+IF($AR$24>=AR13,\"Yes\",\"No\")","v":"No"},"October","4th",10,"2019-10-01","2019-11-11","No. 46/2019 ","2019-11-20","No. 44/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-10-01","2018-11-11","No. 44/2018 ","2018-11-20","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2017-10-01","2018-10-31","No. 44/2018 ","2017-11-20","No. 35/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",31]
[null,null,null,null,null,"10Less Than 5 Cr","10More Than 5 Cr",10,"2020-10-01","2020-11-11","No Remarks","Not Notified",null,null,null,null,"Not Notified",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+MONTH(AG14)&YEAR(AG14)&$AE$2","v":"12020Less than than 5 Cr"},null,"2020-01-01","2020-02-20","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"up to",{"$f":"IF(BC31=0,\"No Extension\",BC31)","v":"No Extension"},{"$f":"+IF($AR$24<=AR14,\"Yes\",\"No\")","v":"Yes"},"November",{"$f":"+AU13","v":"4th"},11,"2019-11-01","2019-12-11","No. 46/2019 ","2019-12-23","No. 44/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-11-01","2018-12-11","No. 44/2018 ","2018-12-20","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2017-11-01","2018-10-31","No. 44/2018 ","2017-12-20","No. 35/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",30]
[null,null,null,null,null,"11Less Than 5 Cr","11More Than 5 Cr",11,"2020-11-01","2020-12-11","No Remarks","Not Notified",null,null,null,null,"Not Notified",null,null,null,null,null,null,null,null,null,null,null,null,null,"22020Less than than 5 Cr",{"$f":"+AE2","v":"Less than than 5 Cr"},"2020-02-01","2020-03-20","2020-03-21","2020-06-30","2020-07-01","2020-09-30","2020-03-21","2020-06-30","2020-06-30",null,null,null,null,"December","4th",12,"2019-12-01","2020-01-11","No. 46/2019 ","2020-01-20","No. 44/2019",null,null,null,null,"2020-07-01","2020-09-30","2018-12-01","2019-01-11","No. 44/2018 ","2019-01-20","No. 34/2018",null,null,null,null,"2020-07-01","2020-09-30","2017-12-01","2018-10-31","No. 44/2018 ","2018-01-22","No. 35/2017",null,null,"2018-12-22","2019-03-31","2020-07-01","2020-09-30",31]
[null,"Late Fees Extension (If Any)",null,null,null,"12Less Than 5 Cr","12More Than 5 Cr",12,"2020-12-01","2021-01-11","No Remarks","Not Notified",null,null,null,null,"Not Notified",null,null,null,null,null,null,null,null,null,null,null,null,null,"32020Less than than 5 Cr",null,"2020-03-01","2020-04-20","2020-04-21","2020-07-03","2020-07-04","2020-09-30","2020-04-21","2020-07-03","2020-07-03",null,"Extension - 1 \"No Late Fees\" (Refer Note - 1)",null,null,2017,null,"1st","1st","2019-04-30","No. 43/2018",null,null,null,null,null,null,null,null,"1st","2018-10-31","No. 43/2018",null,null,null,null,null,null,null,null,"1st","No GST Returns","No Remarks"]
[null,null,null,null,null,null,null,"1st","1st","2020-04-30","No. 45/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42020Less than than 5 Cr",null,"2020-04-01","2020-05-22","2020-05-23","2020-07-06","2020-07-07","2020-09-30","2020-05-23","2020-07-06","2020-07-06",null,"From ",{"$f":"IF(BD31=0,\"No Extension\",BD31)","v":"No Extension"},{"$f":"+IF($AR$24>=AR17,\"Yes\",\"No\")","v":"No"},2018,null,"2nd","2nd","2019-07-31","No. 11/2019",null,null,null,null,null,null,null,null,"2nd","2018-10-31","No. 43/2018",null,null,null,null,null,null,null,null,"2nd","2018-10-31","No. 43/2018"]
[null,"Extension - 1 \"No Late Fees\" (Refer Note - 1)",null,null,null,null,null,"2nd","2nd","2020-07-31","No. 27/2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52020Less than than 5 Cr",null,"2020-05-01","2020-07-12","2020-07-13","2020-09-12","2020-09-13","2020-09-30","2020-07-13","2020-09-12","2020-09-12",null,"up to",{"$f":"IF(BE31=0,\"No Extension\",BE31)","v":"No Extension"},{"$f":"+IF($AR$24<=AR18,\"Yes\",\"No\")","v":"Yes"},2019,null,"3rd","3rd","2019-10-31","No. 27/2019",null,null,null,null,null,null,null,null,"3rd","2018-10-31","No. 43/2018",null,null,null,null,null,null,null,null,"3rd","2018-10-31","No. 43/2018"]
[null,"From ",null,{"$f":"+IF($C$34>=C19,\"Yes\",\"No\")","v":"Yes"},null,null,null,"3rd","3rd","2020-10-31","No Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"62020Less than than 5 Cr",null,"2020-06-01","2020-07-22","2020-07-23","2020-09-23","2020-09-24","2020-09-30","2020-07-23","2020-09-23","2020-09-23",null,null,null,null,2020,null,"4th","4th","2020-01-31","No. 45/2019",null,null,null,null,null,null,null,null,"4th","2019-01-31","No. 43/2018",null,null,null,null,null,null,null,null,"4th","2018-10-31","No. 43/2018"]
[null,"up to",null,{"$f":"+IF($C$34<=C20,\"Yes\",\"No\")","v":"No"},null,null,null,"4th","4th","2021-01-31","No Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"72020Less than than 5 Cr",null,"2020-07-01","2020-08-22","2020-08-23","2020-09-27","2020-09-28","2020-09-30","2020-08-23","2020-09-27","2020-09-27",null,"Extension - 2 \"Late Fees of Max 500 per return or Nil\"  (Refer Note - 2)"]
[null,null,{"$f":"IF(D19&D20=\"YESYES\",\"YES\",\"NO\")","v":"NO"},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,"82020Less than than 5 Cr",null,"2020-08-01","2020-10-01","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"From ",{"$f":"IF(BF31=0,\"No Extension\",BF31)","v":"2020-07-01"},{"$f":"+IF($AR$24>=AR21,\"Yes\",\"No\")","v":"Yes"}]
[null,"Extension - 1 \"Late Fees Max 500\" (Refer Note - 1)",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,"92020Less than than 5 Cr",null,"2020-09-01","2020-10-22","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.","N.A.",null,"up to",{"$f":"IF(BG31=0,\"No Extension\",BG31)","v":"2020-09-30"},{"$f":"+IF($AR$24<=AR22,\"Yes\",\"No\")","v":"No"},null,null,{"$f":"+VLOOKUP($AR$4,$AT$4:$AV$15,3,FALSE)","v":5},null,{"$f":"+VLOOKUP($AV$22,$AV$4:$CC$19,AX$24,FALSE)","v":"2019-06-11"},"Notification No. 12/2019 ","2019-06-20","No. 13/2019","00:00:00","00:00:00","00:00:00","00:00:00","2020-07-01","2020-09-30",null,{"$f":"+VLOOKUP($AV$22,$AV$4:$CC$19,BI$24,FALSE)","v":"2018-10-31"},"No. 44/2018 ","2018-06-20","No. 16/2018","00:00:00","00:00:00","2018-12-22","2019-03-31","2020-07-01","2020-09-30",null,{"$f":"+VLOOKUP($AV$22,$AV$4:$CC$19,BT$24,FALSE)","v":"No GST Returns"},"No Remarks","No GST Returns","No Remarks","00:00:00","00:00:00","00:00:00","00:00:00","2020-07-01","2020-09-30"]
["2020-07-01","From ",{"$f":"+IF(D1>A24,\"\",A23)","v":"2020-07-01"},{"$f":"+IF($C$34>=C23,\"Yes\",\"No\")","v":"Yes"},null,null,null,{"$f":"+VLOOKUP($C$7,$AT$4:$AV$15,3,FALSE)","v":5},null,{"$f":"+VLOOKUP($H23,$H$5:$U$20,J$25,FALSE)","v":"2020-06-11"},"No. 28/2020","2020-06-27","00:00:00","00:00:00","00:00:00","00:00:00","2020-07-12","2020-07-13","2020-09-12","2020-09-13","2020-09-30",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":"+VLOOKUP($AR$4,$AT$4:$AU$15,2,FALSE)","v":"2nd"},null,{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,AX$24,FALSE)","v":"2019-07-31"},{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,AY$24,FALSE)","v":"No. 11/2019"},null,null,null,null,null,null,null,null,null,{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,BI$24,FALSE)","v":"2018-10-31"},{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,BJ$24,FALSE)","v":"No. 43/2018"},null,null,null,null,null,null,null,null,null,{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,BT$24,FALSE)","v":"2018-10-31"},{"$f":"+VLOOKUP($AV$23,$AV$4:$CC$19,BU$24,FALSE)","v":"No. 43/2018"}]
["2020-09-30","up to",{"$f":"+IF(D1>A24,\"\",A24)","v":"2020-09-30"},{"$f":"+IF($C$34<=C24,\"Yes\",\"No\")","v":"No"},null,null,null,{"$f":"+VLOOKUP($C$7,$AT$4:$AU$15,2,FALSE)","v":"2nd"},null,"2020-07-31","No. 27/2020",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,"Expected date of Filling return",{"$f":"+'Due date Dashboard'!D9","v":"2021-08-26"},{"$f":"IF(AR5>=AR24,\"YES\",\"NO\")","v":"NO"},null,null,"CIN",2,{"$f":"+AW24+1","v":3},4,{"$f":"+AY24+1","v":5},6,7,8,9,10,11,12,null,{"$f":"+BG24+2","v":14},{"$f":"+BI24+1","v":15},{"$f":"+BJ24+1","v":16},17,18,19,20,21,22,23,null,{"$f":"+BR24+2","v":25},{"$f":"+BT24+1","v":26},{"$f":"+BU24+1","v":27},28,29,30,31,32,33,34]
[null,null,{"$f":"IF(D23&D24=\"YESYES\",\"YES\",\"NO\")","v":"NO"},null,null,null,null,"CIN",2,{"$f":"+I25+1","v":3},{"$f":"+J25+1","v":4},5,6,7,8,9,10,11,12,13,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GST Payable",{"$f":"'Due date Dashboard'!$D$10","v":100000},null,null,null,"Result - 1",null,{"$f":"+IF($AR$3=$AW$1,AX22,\"\")","v":"2019-06-11"},{"$f":"+IF($AR$3=$AW$1,AY22,\"\")","v":"Notification No. 12/2019 "},"2019-06-20","No. 13/2019",{"$f":"+IF($AR$3=$AW$1,BB22,\"\")","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","2020-07-01","2020-09-30",null,{"$f":"+IF($AR$3=$BH$1,BI22,\"\")","v":""},"","","","","","","","","",null,{"$f":"+IF($AR$3=$BS$1,BT22,\"\")","v":""},"","","","","","","","",""]
[null,"Extension - 1 \"Interest @ Nil\" (Refer Note - 1)",null,null,null,null,null,"Result - 1",null,{"$f":"+IF($C$6=$I$1,J23,\"\")","v":""},"","","","","","","","","","","",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,"Result - 2",null,{"$f":"+IF($AR$3=$AW$1,AX23,\"\")","v":"2019-07-31"},{"$f":"+IF($AR$3=$AW$1,AY23,\"\")","v":"No. 11/2019"},null,null,null,null,null,null,null,null,null,{"$f":"+IF($AR$3=$BH$1,BI23,\"\")","v":""},{"$f":"+IF($AR$3=$BH$1,BJ23,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+IF($AR$3=$BS$1,BT23,\"\")","v":""},{"$f":"+IF($AR$3=$BS$1,BU23,\"\")","v":""}]
[null,"From ",{"$f":"IF(O32=\"\",\"\",C11+1)","v":""},{"$f":"+IF($C$34>=C27,\"Yes\",\"No\")","v":"No"},null,null,null,"Result - 2",null,{"$f":"+IF($C$6=$I$1,J24,\"\")","v":""},""]
[null,"up to",{"$f":"IF(O32=\"\",\"\",O32-1)","v":""},{"$f":"+IF($C$34<=C28,\"Yes\",\"No\")","v":"Yes"},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,null,null,"Total Delay (In Day)",{"$f":"IF(AS24=\"YES\",0,AR24-AR5)","v":798},null,null,null,null,{"$f":"+AR3","v":2019}]
[null,null,{"$f":"IF(D27&D28=\"YESYES\",\"YES\",\"NO\")","v":"NO"},null,null,null,null,null,"GSTR - 1",null,null,"GSTR - 3B",null,null,null,null,null,{"$f":"+'Due date Dashboard'!B2","v":"Punit Prajapati & Co."},"Punit Prajapati & Co.",{"$f":"IF(R29=S29,\"YES\",\"NO\")","v":"YES"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Fees per Day",{"$f":"+IF(AR25=0,20,50)","v":50},null,null,null,null,"GSTR - 1",null,null,null,null,"Monthly Extension",null,"No Late Fees if Filed During",null,"No Late Fees of Rs 500 or 0"]
[null,"Extension - 2 \"Interest at 9%\"  (Refer Note - 2)",null,null,null,null,null,null,null,null,null,null,"No Late fees",null,"Interest @ 9%",null,null,{"$f":"+'Due date Dashboard'!D2","v":"www.punitprajapati.com"},"www.punitprajapati.com",{"$f":"IF(R30=S30,\"YES\",\"NO\")","v":"YES"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Fees",{"$f":"+IF(AS13&AS14=\"YESYES\",0,IF(AS17&AS18=\"YESYES\",0,IF(AS21&AS22=\"YesYES\",MIN(AR28*AR29,500),MIN((AR28)*AR29,10000))))","v":10000},null,null,null,null,"Month/Qtr","Due Date","Remarks","Due Date","Remarks","From","Up to","From","Up to","From","Up to"]
[null,"From ",{"$f":"IF(O32=0,\"No Extension\",O32)","v":""},{"$f":"+IF($C$34>=C31,\"Yes\",\"No\")","v":"No"},null,null,null,null,"Month/Qtr","Due Date","Remarks","Due Date","From ","To","From ","To",null,{"$f":"+'Due date Dashboard'!B4","v":"Celebrating 15 years, 2005-2020"},"Celebrating 15 years, 2005-2020",{"$f":"IF(R31=S31,\"YES\",\"NO\")","v":"YES"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",{"$f":"+AR25*0.18*AR28/365","v":39353.424657534248},null,null,null,"Monthly",{"$f":"+AR4","v":"May"},{"$f":"+IF(AX25=\"\",IF(BI25=\"\",BT25,BI25),AX25)","v":"2019-06-11"},"Notification No. 12/2019 ","2019-06-20","No. 13/2019","00:00:00","00:00:00","00:00:00","00:00:00","2020-07-01","2020-09-30"]
[null,"up to",{"$f":"IF(P32=0,\"No Extension\",P32)","v":""},{"$f":"+IF($C$34<=C32,\"Yes\",\"No\")","v":"Yes"},null,null,null,null,{"$f":"+H23","v":5},{"$f":"+J26","v":""},"",{"$f":"IF(IF($C$9=$L$2,L26,Q26)=0,\"\",IF($C$9=$L$2,L26,Q26))","v":""},{"$f":"IF(IF($C$9=$L$2,M26,R26)=0,\"\",IF($C$9=$L$2,M26,R26))","v":""},{"$f":"IF(IF($C$9=$L$2,N26,S26)=0,\"\",IF($C$9=$L$2,N26,S26))","v":""},{"$f":"IF(IF($C$9=$L$2,O26,T26)=0,\"\",IF($C$9=$L$2,O26,T26))","v":""},{"$f":"IF(IF($C$9=$L$2,P26,U26)=0,\"\",IF($C$9=$L$2,P26,U26))","v":""},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,"Notification No",{"$f":"+BA31","v":"No. 13/2019"},null,null,null,"Quarterly",{"$f":"+AW31","v":"May"},{"$f":"+IF(AX26=\"\",IF(BI26=\"\",BT26,BI26),AX26)","v":"2019-07-31"},{"$f":"+IF(AY26=\"\",IF(BJ26=\"\",BU26,BJ26),AY26)","v":"No. 11/2019"}]
[null,null,{"$f":"IF(D31&D32=\"YESYES\",\"YES\",\"NO\")","v":"NO"},null,null,null,null,null,{"$f":"+H24","v":"2nd"},"","",null,{"$f":"TODAY()","v":"2020-07-30"},"2020-08-07"]
[null,"Expected date of Filling return",{"$f":"+'Due date Dashboard'!D9","v":"2021-08-26"},{"$f":"+IF($C$34>=C31,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,null,{"$f":"IF(M33>N33,\"YES\",\"NO\")","v":"NO"},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,"Note - 1:"]
[null,"GST Payable",{"$f":"+'Due date Dashboard'!D10","v":100000},{"$f":"+IF($C$34<=C32,\"Yes\",\"No\")","v":"Yes"},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,null,null,{"$f":"IFERROR(\"If GSTR - 3B return is filed during \"&DAY(AR17)&\"-\"&MONTH(AR17)&\"-\"&YEAR(AR17)&\" to \"&DAY(AR18)&\"-\"&MONTH(AR18)&\"-\"&YEAR(AR18)&\", no late fees will be applicable.\",\"\")","v":""}]
[]
[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,null,null,null,null,null,null,"Note - 2:"]
[null,"Total Delay (In Day)",{"$f":"IF(D39=\"YES\",0,C34-C11)","v":0},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,null,null,null,{"$f":"IFERROR(\"Further, if GSTR - 3B return is filed during \"&DAY(AR21)&\"-\"&MONTH(AR21)&\"-\"&YEAR(AR21)&\" to \"&DAY(AR22)&\"-\"&MONTH(AR22)&\"-\"&YEAR(AR22)&\" period, Maximum Late Fees will be Rs. 500 Per Return. Also No late fees for Nil Return.\",\"\")","v":"Further, if GSTR - 3B return is filed during 1-7-2020 to 30-9-2020 period, Maximum Late Fees will be Rs. 500 Per Return. Also No late fees for Nil Return."}]
[null,"Late Fees per Day",{"$f":"+IF(C35=0,IF(C25=\"YES\",0,20),50)","v":50},{"$f":"+IF(C34<C11,\"YES\",\"No\")","v":"YES"}]
[null,"Late Fees",{"$f":"MIN(IF(C21=\"YES\",0,IF(C25=\"YES\",MIN(C38*C39,500),C38*C39)),10000)","v":0}]
[null,"Interest",{"$f":"+IF(C29=\"YES\",0,IF(C33=\"YES\",C35*C38*0.09/365,C38*C35*0.18/365))","v":0}]
[]
[null,"Note - 1:"]
[]
[null,{"$f":"IF(C19=\"\",\"\",IFERROR(\"If GSTR - 3B return is filed during \"&DAY(C19)&\"-\"&MONTH(C19)&\"-\"&YEAR(C19)&\" to \"&DAY(C20)&\"-\"&MONTH(C20)&\"-\"&YEAR(C20)&\", no late fees will be applicable.\",\"\"))","v":""}]
[null,{"$f":"IF(C25=\"NO\",\"\",\"If GSTR - 3B return is filed during 1-7-2020 to 30-9-2020 period, Maximum Late Fees will be Rs. 500 Per Return. Also No late fees for Nil Return.\")","v":""}]
[null,{"$f":"IF(C25=\"NO\",\"\",IFERROR(IF(C11=\"\",\"\",\"However, If return is filed after 30-09-2020 then late fees will be calculated from due date (i.e. \"&DAY(C11)&\"-\"&MONTH(C11)&\"-\"&YEAR(C11)&\").\"),\"\"))","v":""}]
[]
[null,"Note - 2:"]
[]
[null,{"$f":"IF(C28=\"\",\"\",\"If return is filed before \"&DAY(C28)&\"-\"&MONTH(C28)&\"-\"&YEAR(C28)&\" then no interest will be payable.\")","v":""}]
[null,{"$f":"IF(C31=\"\",\"\",\"However, If return is filed during \"&DAY(C31)&\"-\"&MONTH(C31)&\"-\"&YEAR(C31)&\" to \"&DAY(C32)&\"-\"&MONTH(C32)&\"-\"&YEAR(C32)&\", Interest will be payable at 9% for that period. However, if return is filed after \"&DAY(C32)&\"-\"&MONTH(C32)&\"-\"&YEAR(C32)&\" Interest will be calculated at rate of 18% from Due Date i.e. ( \"&DAY(C11)&\"-\"&MONTH(C11)&\"-\"&YEAR(C11)&\")\")","v":""}]
[]
[]
[null,{"$f":"+B45&\" \"&B46&\" \"&B47&\" \n\n\"&B51&\" \"&B52","v":"   \n\n "}]