{"text_format":"5","workbook":"xlsx","n_sheets":20,"sheets":["Help Instruction","b2b,sez,de","b2ba","b2cl","b2cla","b2cs","b2csa","cdnr","cdnra","cdnur","cdnura","exp","expa","at","ata","atadj","atadja","exemp","hsn","docs"],"props":{"last_modified_by":"Aibs"},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"Help Instruction","index":0,"n_rows":1,"n_cols":1,"rows_kept":1}
["Help Instructions"]

{"sheet":"b2b,sez,de","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
["Summary For B2B,SEZ,DE(4A,4B,6B,6C)"]
["No. of Recipients",null,"No. of Invoices",null,"Total Invoice Value",{"$nulls":6},"Total Taxable Value","Total Cess"]
[{"$nulls":11},{"$f":"SUM(L5:L1000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M5:M1000)","v":{"v":0,"d":"0.00"}}]
["GSTIN/UIN of Recipient","Receiver Name","Invoice Number","Invoice date","Invoice Value","Place Of Supply","Reverse Charge","Applicable % of Tax Rate","Invoice Type","E-Commerce GSTIN","Rate","Taxable Value","Cess Amount"]

{"sheet":"b2ba","index":2,"n_rows":4,"n_cols":15,"rows_kept":4,"merged":[[0,1,0,3],[0,4,0,14]]}
["Summary For B2BA","Original Details",null,null,"Revised details"]
["No. of Recipients",null,"No. of Invoices",{"$nulls":3},"Total Invoice Value",{"$nulls":6},"Total Taxable Value","Total Cess"]
[]
["GSTIN/UIN of Recipient","Receiver Name","Original Invoice Number","Original Invoice date","Revised Invoice Number","Revised Invoice date","Invoice Value","Place Of Supply","Reverse Charge","Applicable % of Tax Rate","Invoice Type","E-Commerce GSTIN","Rate","Taxable Value","Cess Amount"]

{"sheet":"b2cl","index":3,"n_rows":4,"n_cols":10,"rows_kept":4}
["Summary For B2CL(5)"]
["No. of Invoices",null,"Total Invoice Value",{"$nulls":3},"Total Taxable Value","Total Cess"]
[{"$nulls":6},{"$f":"SUM(G5:G1000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:H1000)","v":{"v":0,"d":"0.00"}}]
["Invoice Number","Invoice date","Invoice Value","Place Of Supply","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN","Sale from Bonded WH"]

{"sheet":"b2cla","index":4,"n_rows":4,"n_cols":12,"rows_kept":4,"merged":[[0,1,0,2],[0,3,0,11]]}
["Summary For B2CLA","Original Details",null,"Revised details"]
["No. of Invoices",{"$nulls":4},"Total Invoice Value",null,null,"Total Taxable Value","Total Cess"]
[]
["Original Invoice Number","Original Invoice date","Original Place Of Supply","Revised Invoice Number","Revised Invoice date","Invoice Value","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN","Sale from Bonded WH"]

{"sheet":"b2cs","index":5,"n_rows":4,"n_cols":7,"rows_kept":4}
["Summary For B2CS(7)"]
[{"$nulls":4},"Total Taxable Value","Total Cess"]
[{"$nulls":4},{"$f":"SUM(E5:E1000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F5:F1000)","v":{"v":0,"d":"0.00"}}]
["Type","Place Of Supply","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN"]

{"sheet":"b2csa","index":6,"n_rows":4,"n_cols":9,"rows_kept":4,"merged":[[0,1,0,1],[0,2,0,8]]}
["Summary For B2CSA","Original Details","Revised details"]
[{"$nulls":6},"Total Taxable Value","Total Cess"]
[]
["Financial Year","Original Month","Place Of Supply","Type","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN"]

{"sheet":"cdnr","index":7,"n_rows":4,"n_cols":13,"rows_kept":4}
["Summary For CDNR(9B)"]
["No. of Recipient",null,"No. of Notes",{"$nulls":5},"Total Note Value",null,null,"Total Taxable Value","Total Cess"]
[{"$nulls":11},{"$f":"SUM(L5:L1000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M5:M1000)","v":{"v":0,"d":"0.00"}}]
["GSTIN/UIN of Recipient","Receiver Name","Note Number","Note Date","Note Type","Place Of Supply","Reverse Charge","Note Supply Type","Note Value","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount"]

{"sheet":"cdnra","index":8,"n_rows":4,"n_cols":15,"rows_kept":4,"merged":[[0,1,0,5],[0,6,0,14]]}
["Summary For CDNRA","Original Details",{"$nulls":4},"Revised details"]
["No. of Recipient",null,"No. of Notes/Vouchers",{"$nulls":7},"Total Note Value",null,null,"Total Taxable Value","Total Cess"]
[]
["GSTIN/UIN of Recipient","Receiver Name","Original Note Number","Original Note Date","Revised Note Number","Revised Note Date","Note Type","Place Of Supply","Reverse Charge","Note Supply Type","Note Value","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount"]

{"sheet":"cdnur","index":9,"n_rows":4,"n_cols":10,"rows_kept":4}
["Summary For CDNUR(9B)"]
[null,"No. of Notes/Vouchers",{"$nulls":3},"Total Note Value",null,null,"Total Taxable Value","Total Cess"]
[{"$nulls":8},{"$f":"SUM(I5:I1000)","v":{"v":0,"d":"0.00"}}]
["UR Type","Note Number","Note Date","Note Type","Place Of Supply","Note Value","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount"]

{"sheet":"cdnura","index":10,"n_rows":4,"n_cols":12,"rows_kept":4,"merged":[[0,1,0,4],[0,5,0,11]]}
["Summary For CDNURA","Original Details",{"$nulls":3},"Revised details"]
[null,"No. of Notes/Vouchers",{"$nulls":5},"Total Note Value",null,null,"Total Taxable Value","Total Cess"]
[]
["UR Type","Original Note Number","Original Note Date","Revised Note Number","Revised Note Date","Note Type","Place Of Supply","Note Value","Applicable % of Tax Rate","Rate","Taxable Value","Cess Amount"]

{"sheet":"exp","index":11,"n_rows":4,"n_cols":10,"rows_kept":4}
["Summary For EXP(6)"]
[null,"No. of Invoices",null,"Total Invoice Value",null,"No. of Shipping Bill",null,null,"Total Taxable Value","Total Cess"]
[{"$nulls":8},{"$f":"SUM(I5:I1000)","v":{"v":0,"d":"0.00"}}]
["Export Type","Invoice Number","Invoice date","Invoice Value","Port Code","Shipping Bill Number","Shipping Bill Date","Rate","Taxable Value","Cess Amount"]

{"sheet":"expa","index":12,"n_rows":4,"n_cols":12,"rows_kept":4,"merged":[[0,1,0,2],[0,3,0,11]]}
["Summary For EXPA","Original Details",null,"Revised details"]
[null,"No. of Invoices",{"$nulls":3},"Total Invoice Value",null,"No. of Shipping Bill",null,null,"Total Taxable Value","Total Cess"]
[]
["Export Type","Original Invoice Number","Original Invoice date","Revised Invoice Number","Revised Invoice date","Invoice Value","Port Code","Shipping Bill Number","Shipping Bill Date","Rate","Taxable Value","Cess Amount"]

{"sheet":"at","index":13,"n_rows":4,"n_cols":5,"rows_kept":4}
["Summary For Advance Received (11B)"]
[{"$nulls":3},"Total Advanced Received","Total Cess"]
[]
["Place Of Supply","Applicable % of Tax Rate","Rate","Gross Advance Received","Cess Amount"]

{"sheet":"ata","index":14,"n_rows":4,"n_cols":7,"rows_kept":4,"merged":[[0,1,0,2],[0,3,0,6]]}
["Summary For Amended Tax Liability(Advance Received)","Original Details",null,"Revised details"]
[{"$nulls":5},"Total Advanced Received","Total Cess"]
[]
["Financial Year","Original Month","Original Place Of Supply","Applicable % of Tax Rate","Rate","Gross Advance Received","Cess Amount"]

{"sheet":"atadj","index":15,"n_rows":4,"n_cols":5,"rows_kept":4}
["Summary For Advance Adjusted (11B)"]
[{"$nulls":3},"Total Advanced Adjusted","Total Cess"]
[]
["Place Of Supply","Applicable % of Tax Rate","Rate","Gross Advance Adjusted","Cess Amount"]

{"sheet":"atadja","index":16,"n_rows":4,"n_cols":7,"rows_kept":4,"merged":[[0,1,0,2],[0,3,0,6]]}
["Summary For Amendement Of Adjustment Advances","Original Details",null,"Revised details"]
[{"$nulls":5},"Total Advanced Adjusted","Total Cess"]
[]
["Financial Year","Original Month","Original Place Of Supply","Applicable % of Tax Rate","Rate","Gross Advance Adjusted","Cess Amount"]

{"sheet":"exemp","index":17,"n_rows":4,"n_cols":4,"rows_kept":4}
["Summary For Nil rated, exempted and non GST outward supplies (8)"]
[null,"Total Nil Rated Supplies","Total Exempted Supplies","Total Non-GST Supplies"]
[null,{"$f":"SUM(B5:B8)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C5:C8)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D5:D8)","v":{"v":0,"d":"0.00"}}]
["Description","Nil Rated Supplies","Exempted(other than nil rated/non GST supply)","Non-GST supplies"]

{"sheet":"hsn","index":18,"n_rows":4,"n_cols":11,"rows_kept":4}
["Summary For HSN(12)"]
["No. of HSN",{"$nulls":3},"Total Value",null,"Total Taxable Value","Total Integrated Tax","Total Central Tax","Total State/UT Tax","Total Cess"]
[{"$f":"COUNT(A5:A1000)","v":0},{"$nulls":3},{"$f":"SUM(E5:E1000)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(G5:G1005)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:H1005)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:I1005)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J1005)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K1005)","v":{"v":0,"d":"0.00"}}]
["HSN","Description","UQC","Total Quantity","Total Value","Rate","Taxable Value","Integrated Tax Amount","Central Tax Amount","State/UT Tax Amount","Cess Amount"]

{"sheet":"docs","index":19,"n_rows":4,"n_cols":5,"rows_kept":4}
["Summary of documents issued during the tax period(13)"]
[{"$nulls":3},"Total Number","Total Cancelled"]
[{"$nulls":3},{"$f":"SUM(D5:D5)","v":0},{"$f":"SUM(E5:E5)","v":0}]
["Nature of Document","Sr. No. From","Sr. No. To","Total Number","Cancelled"]