{"text_format":"5","workbook":"xlsx","n_sheets":3,"sheets":["Help Instructions ","GSTR-3B","Master"],"props":{"creator":"Gajanan U Khanande","last_modified_by":"Aibs"},"defined_names":["ExemptNilRatedRange","InterestRange","InterStateSuppliesValuesRange","ITCRange","OutwardInwardSuppliesRange","StatesAndUT","StatesAndUT","StateUTRange"],"not_rendered":{"images":2,"macros":1,"external_links":1,"defined_names":8},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"Help Instructions ","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"Goods and Services Tax - GSTR-3B Offline Utility \n"]
[]
[null,"Introduction to Excel Based GSTR-3B Offline Utility "]
[null,"1. The Excel based GSTR-3B Offline Utility is designed to help taxpayer to prepare his GSTR-3B return offline\n2. Details for following sections of GSTR-3B return can be added by taxpayer using the offline Utility  \n       3.1 Details of Outward Supplies and inward supplies liable to reverse charge\n       3.2 Of the supplies shown in 3.1 (a) above, details of inter-State supplies made to unregistered persons, composition taxable persons and UIN holders\n       4. Eligible ITC\n       5. Values of exempt, nil-rated and non-GST inward supplies\n       5.1 Interest & late fee payable\n3. The Offline tool has following features to help taxpayer in Return Preparation \n     1. 'Clear All'  : To clear all data entered in the Offline Utility and reset it. This enables to use same the template for multiple tax periods and taxpayers.  \n     2. 'Validate' : To validate the data entered in various Tables of GSTR-3B in the Offline Utility For the cells that fail validation  a comment field would be enabled with help text on validation failure\n     3. 'Sheet Status' :  Reflects the Validation status of data entered in the GSTR-3B worksheet of this offline Utility Status can be as follows \n             3.1 Validation Successful : All entered details have been validated successfully \n             3.2 Validation Failed: One or More cells have failed validation across the worksheet \n      4. 'Generate File' : To generate JSON file for upload of GSTR-3B return details prepared offline on GST portal. JSON would be generated only if the worksheet has been successfully validated     \n4. The high level process flow for GSTR-3B return preparation is as follows \n       1. Enter details in the GSTR-3B worksheet of this Excel offline Utility \n       2. Validate the details entered using 'validate' button\n       3. Generate Json using 'Generate File' option\n       4. Upload the generated JSON on GST Portal. Preview the details uploaded , submit , offset liability and File return on the GST portal                                                                                                                                                                                                                                                  \n\n"]
[]
[null,"Preparing GSTR-3B Return Using Offline Utility "]
[null,"1. Please ensure you download the latest version of  GSTR-3B Offline Tool from the GST portal. https://www.gst.gov.in/download/returns\n2. Launch the GSTR-3B Excel based Offline Utility and navigate to worksheet 'GSTR-3B'\n3. Use 'Clear All' option to clear any data present in the sheet and to reset the Worksheet \n4. Enter the GSTIN . Entered GSTIN would be validated for correct structure \n5. Select the  applicable Financial Year from the drop-down. It is a mandatory field \n6. Enter the Legal name of registered person. This field is optional and would not lead to validation failure\n7. Select the applicable month form the drop-down. It is a mandatory field\n8. Enter details as applicable in Table 3.1  'Details of Outward Supplies and inward supplies liable to reverse charge'.\n9. Please note that only CGST amount need to entered for applicable sections; SGST amount would be populated based on CGST amount. \n10. Enter details as applicable in Table 3.2 'Of the supplies shown in 3.1 (a) above, details of inter-State supplies made to unregistered persons, composition taxable persons and UIN holders'.\n11. Please note the amount entered in Table 3.2 can not be more than amount entered in Table 3.1 (a)\n12. Table 3.2 is present as the last table in the GSTR-3B worksheet\n13. Enter details as applicable in Table  4 'Eligible ITC'\n14. Enter details as applicable in Table  5 'Values of exempt, nil-rated and non-GST inward supplies'\n15. Enter details as applicable in Table 5.1 'Interest & late fee payable'. Taxpayer need to enter only interest amount.\n16. Click on 'Validate' to validate the GSTR-3B worksheet. Check the status of validation. In case of validation failure; please check for cells that have failed validation and correct errors as per help text\n17. Upon successful validation; click 'Generate File' to generate JSON for upload on GST portal \n"]
[]
[null," GSTR-3B JSON Upload on GST Portal  "]
[null,"1. Login to GST Portal and select 'Returns Dashboard'\n2. Select applicable Financial Year and Tax-period. Select GSTR-3B Prepare Offline \n3. Upload the JSON prepared using offline Utility using upload option in the return dashboard.\n4. The uploaded JSON file would be validated and processed. Upon success validation and processing the details entered would be populated in respective Tables\n5. In case of validation failure upon processing ; errors if any would be shown on portal \n6. Post successful upload of data on GST portal ; Taxpayer to Preview the form , Submit, Offset liability and file GSTR-3B\n7. Please Note it is possible to upload Json multiple times on GST portal till submission. However earlier uploaded data would be overwritten. Tables and Preview would reflect only the last data uploaded."]

{"sheet":"GSTR-3B","index":1,"n_rows":116,"n_cols":11,"rows_kept":116,"merged":[[1,1,2,11],[4,2,4,3],[4,4,4,5],[4,7,5,7],[4,8,5,9],[5,2,5,3],[5,4,5,5],[6,7,6,12],[7,1,7,6],[11,4,11,5],[12,3,12,6],[14,3,14,6],[17,1,17,5],[21,3,22,4],[35,1,35,4],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[42,1,42,10],[43,1,44,1],[43,2,44,2],[43,3,43,6],[43,7,44,7],[43,8,44,8],[43,9,44,9],[43,10,44,10],[46,7,49,7],[49,3,49,5],[52,1,52,5],[59,1,59,10],[60,1,61,1],[60,2,61,2],[60,3,60,6],[60,7,61,7],[60,8,61,8],[60,9,61,9],[60,10,61,10],[63,1,63,10],[64,6,66,6],[64,7,67,7],[67,3,67,5],[68,1,68,10],[69,3,72,7],[69,9,72,10],[74,1,74,7],[75,1,76,1],[75,2,75,3],[75,4,75,5],[75,6,75,7]]}
[]
[null,"GSTR-3B\n[See rule 61(5)]"]
[]
[]
[null,"GSTIN",null,null,"Year",null,null,"Sheet Status:"]
[null,"Legal name of the registered person",null,null,"Month"]
[]
[null,"3.1 Details of Outward Supplies and inward supplies liable to reverse charge"]
[null,"Nature of Supplies","Total Taxable value","Integrated Tax","Central Tax","State/UT Tax","Cess"]
[null,1,2,3,4,5,6]
[null,"(a) Outward Taxable  supplies  (other than zero rated, nil rated and exempted)",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"$f":"E11","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"}]
[null,"(b) Outward Taxable  supplies  (zero rated )",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},null,null,{"v":0,"d":"₹ 0.00"}]
[null,"(c) Other Outward Taxable  supplies (Nil rated, exempted)",{"v":0,"d":"₹ 0.00"}]
[null,"(d) Inward supplies (liable to reverse charge) ",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"$f":"E14","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"}]
[null,"(e) Non-GST Outward supplies",{"v":0,"d":"₹ 0.00"}]
[null,"Total",{"$f":"SUM(C11:C15)","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(D11:D12) + D14","v":{"v":0,"d":"₹ 0.00"}},{"$f":"E11 + E14","v":{"v":0,"d":"₹ 0.00"}},{"$f":"F11 + F14","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(G11:G12) + G14","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"4. Eligible ITC"]
[null,"Details","Integrated Tax","Central Tax","State/UT Tax","Cess"]
[null,1,2,3,4,5]
[null,"(A) ITC Available (Whether in full or part)"]
[null,"(1)   Import of goods ",{"v":0,"d":"₹ 0.00"},null,null,{"v":0,"d":"₹ 0.00"}]
[null,"(2)   Import of services",{"v":0,"d":"₹ 0.00"},null,null,{"v":0,"d":"₹ 0.00"}]
[null,"(3)   Inward supplies liable to reverse charge\n        (other than 1 &2 above)",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"$f":"D24","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"}]
[null,"(4)   Inward supplies from ISD",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"$f":"D25","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"}]
[null,"(5)   All other ITC",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"$f":"D26","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"}]
[null," (B) ITC Reversed"]
[null,"(1)   As per Rule 42 & 43 of SGST/CGST rules ",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null,"(2)   Others",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null," (C) Net ITC Available (A)-(B)",{"$f":"SUM(ROUND(C22,2),ROUND(C23,2),ROUND(C24,2),ROUND(C25,2),ROUND(C26,2))-SUM(ROUND(C28,2),ROUND(C29,2))","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(ROUND(D22,2),ROUND(D23,2),ROUND(D24,2),ROUND(D25,2),ROUND(D26,2))-SUM(ROUND(D28,2),ROUND(D29,2))","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(ROUND(E22,2),ROUND(E23,2),ROUND(E24,2),ROUND(E25,2),ROUND(E26,2))-SUM(ROUND(E28,2),ROUND(E29,2))","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(ROUND(F22,2),ROUND(F23,2),ROUND(F24,2),ROUND(F25,2),ROUND(F26,2))-SUM(ROUND(F28,2),ROUND(F29,2))","v":{"v":0,"d":"₹ 0.00"}}]
[null," (D) Ineligible ITC"]
[null,"(1)   As per section 17(5) of CGST//SGST Act",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null,"(2)   Others",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[]
[]
[null,"5. Values of exempt, Nil-rated and non-GST inward supplies"]
[null,"Nature of supplies",null,"Inter-State supplies","Intra-state supplies"]
[null,1,null,2,3]
[null,"From a supplier under composition scheme, Exempt  and Nil rated supply",null,{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null,"Non GST supply",null,{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null,"Total",null,{"$f":"SUM(D39:D40)","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(E39:E40)","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"Payment of tax"]
[null,"Description","Tax payable ","Paid through ITC",{"$nulls":3},"Tax paid  TDS./TCS","Tax/Cess paid in cash","Interest","Late Fee"]
[{"$nulls":3},"Integrated Tax","Central Tax","State/UT Tax","Cess"]
[null,1,2,4,5,6,7,null,8,9,10]
[null,"Integrated Tax"]
[null,"Central Tax"]
[null,"State/UT Tax"]
[null,"Cess"]
[]
[]
[null,"5.1 Interest & late fee payable"]
[null,"Description","Integrated Tax","Central Tax","State/UT Tax","Cess"]
[null,1,2,3,4,5]
[null,"Interest",{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]
[null,"Late fee"]
[]
[]
[null,"6. Payment of Tax"]
[null,"Description","Tax payable ","Paid through ITC",{"$nulls":3},"Tax paid  TDS/TCS","Tax/Cess paid in cash","Interest*","Late Fee"]
[{"$nulls":3},"Integrated Tax","Central Tax","State/UT Tax","Cess"]
[null,1,2,3,4,5,6,7,8,9,10]
[null,"Non reverse charge"]
[null,"Integrated Tax",{"$f":"D11+D12","v":0},20,0,0,null,null,0,1]
[null,"Central Tax",{"$f":"E11","v":0},null,10,{"$nulls":4},1,1900]
[null,"State/UT Tax",{"$f":"F11","v":0},null,null,10,{"$nulls":3},1,1900]
[null,"Cess",{"$f":"G11+G12","v":0},{"$nulls":3},10,null,10,1]
[null,"Reverse charge"]
[null,"Integrated Tax",{"$f":"D14","v":0},{"$nulls":5},10]
[null,"Central Tax",{"$f":"E14","v":0},{"$nulls":5},10]
[null,"State/UT Tax",{"$f":"F14","v":0},{"$nulls":5},10]
[null,"Cess",{"$f":"G14","v":0},{"$nulls":5},10]
[]
[null,"3.2  Of the supplies shown in 3.1 (a), details of inter-state supplies made to unregistered persons, composition taxable person and UIN holders"]
[null,"Place of Supply(State/UT)","Supplies made to Unregistered Persons",null,"Supplies made to Composition Taxable Persons",null,"Supplies made to UIN holders"]
[null,null,"Total Taxable value","Amount of Integrated Tax","Total Taxable value","Amount of Integrated Tax","Total Taxable value","Amount of Integrated Tax"]
[null,1,2,3,4,5,6,7]
{"$rows_empty":37}
[null,"Total",{"$f":"SUM(C79:C115)","v":{"v":0,"d":"₹ 0.00"}},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"},{"v":0,"d":"₹ 0.00"}]

{"sheet":"Master","index":2,"n_rows":38,"n_cols":21,"rows_kept":38,"hidden":true}
["POS"]
["01-Jammu & Kashmir",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(A2:A38)-ROW(A2)+1>COUNT(B2:B38),\"\", INDEX(A:A,SMALL(B2:B38,ROW(INDIRECT(\"1:\"&ROWS(A2:A38))))))","v":"01-Jammu & Kashmir"}]
["02-Himachal Pradesh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A3)>=1,\"\",ROW())","v":3},"02-Himachal Pradesh",{"$nulls":17},{"$f":"SUM('GSTR-3B'!D79:D115)+SUM('GSTR-3B'!F79:F115)+SUM('GSTR-3B'!H79:H115)","v":0}]
["03-Punjab",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A4)>=1,\"\",ROW())","v":4},"03-Punjab",{"$nulls":17},{"$f":"IF('GSTR-3B'!C56 = 'GSTR-3B'!J65,)","v":false}]
["04-Chandigarh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A5)>=1,\"\",ROW())","v":5},"04-Chandigarh",{"$nulls":17},{"$f":"IF('GSTR-3B'!D56 = 'GSTR-3B'!J66,)","v":false}]
["05-Uttarakhand",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A6)>=1,\"\",ROW())","v":6},"05-Uttarakhand",{"$nulls":17},{"$f":"IF('GSTR-3B'!E56 = 'GSTR-3B'!J67,)","v":false}]
["06-Haryana",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A7)>=1,\"\",ROW())","v":7},"06-Haryana",{"$nulls":17},{"$f":"IF('GSTR-3B'!F56 = 'GSTR-3B'!J68,)","v":false}]
["07-Delhi",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A8)>=1,\"\",ROW())","v":8},"07-Delhi"]
["08-Rajasthan",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A9)>=1,\"\",ROW())","v":9},"08-Rajasthan"]
["09-Uttar Pradesh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A10)>=1,\"\",ROW())","v":10},"09-Uttar Pradesh"]
["10-Bihar",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A11)>=1,\"\",ROW())","v":11},"10-Bihar"]
["11-Sikkim",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A12)>=1,\"\",ROW())","v":12},"11-Sikkim"]
["12-Arunachal Pradesh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A13)>=1,\"\",ROW())","v":13},"12-Arunachal Pradesh"]
["13-Nagaland",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A14)>=1,\"\",ROW())","v":14},"13-Nagaland"]
["14-Manipur",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A15)>=1,\"\",ROW())","v":15},"14-Manipur"]
["15-Mizoram",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A16)>=1,\"\",ROW())","v":16},"15-Mizoram"]
["16-Tripura",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A17)>=1,\"\",ROW())","v":17},"16-Tripura"]
["17-Meghalaya",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A18)>=1,\"\",ROW())","v":18},"17-Meghalaya"]
["18-Assam",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A19)>=1,\"\",ROW())","v":19},"18-Assam"]
["19-West Bengal",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A20)>=1,\"\",ROW())","v":20},"19-West Bengal"]
["20-Jharkhand",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A21)>=1,\"\",ROW())","v":21},"20-Jharkhand"]
["21-Odisha",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A22)>=1,\"\",ROW())","v":22},"21-Odisha"]
["22-Chhattisgarh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A23)>=1,\"\",ROW())","v":23},"22-Chhattisgarh"]
["23-Madhya Pradesh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A24)>=1,\"\",ROW())","v":24},"23-Madhya Pradesh"]
["24-Gujarat",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A25)>=1,\"\",ROW())","v":25},"24-Gujarat"]
["25-Daman & Diu",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A26)>=1,\"\",ROW())","v":26},"25-Daman & Diu"]
["26-Dadra & Nagar Haveli",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A27)>=1,\"\",ROW())","v":27},"26-Dadra & Nagar Haveli"]
["27-Maharashtra",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A28)>=1,\"\",ROW())","v":28},"27-Maharashtra"]
["29-Karnataka",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A29)>=1,\"\",ROW())","v":29},"29-Karnataka"]
["30-Goa",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A30)>=1,\"\",ROW())","v":30},"30-Goa"]
["31-Lakshdweep",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A31)>=1,\"\",ROW())","v":31},"31-Lakshdweep"]
["32-Kerala",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A32)>=1,\"\",ROW())","v":32},"32-Kerala"]
["33-Tamil Nadu",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A33)>=1,\"\",ROW())","v":33},"33-Tamil Nadu"]
["34-Puducherry",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A34)>=1,\"\",ROW())","v":34},"34-Puducherry"]
["35-Andaman & Nicobar Islands",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A35)>=1,\"\",ROW())","v":35},"35-Andaman & Nicobar Islands"]
["36-Telengana",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A36)>=1,\"\",ROW())","v":36},"36-Telengana"]
["37-Andhra Pradesh",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A37)>=1,\"\",ROW())","v":37},"37-Andhra Pradesh"]
["97-Other Territory",{"$f":"IF(COUNTIF('GSTR-3B'!$B$79:$B$115,A38)>=1,\"\",ROW())","v":38},"97-Other Territory"]