{"text_format":"5","workbook":"xls","n_sheets":11,"sheets":["ReadMe","Home","4B(B2B)","4C(B2BUR)","4D(IMPS)","5B(CDNR)","5B(CDNUR)","6(TXOS)","8A(AT)","8B(ATADJ)","master"],"props":{"creator":"Kaushik Rajbongshi","last_modified_by":"Aibs"},"defined_names":["comp_rt","exportToJSON","flag","flag_map","getSummary","importErrorReport","importFromJSON","inv_typ","inv_typ","inv_typ_map","inv_typ_map","invoice_typ","ntty","ntty","ntty_map","ntty_map","p_gst","p_gst_map","pos","pos","pos_map","pos_map","rchrg","rchrg","rchrg_map","rchrg_map","retq","retq","retq_map","retq_map","retq_map_2","rsn","rsn","rsn_map","rsn_map","rsn_map_rev","rt","rt","sply_ty","sply_ty","sply_ty_map","sply_ty_map","validateATADJSheet","validateATSheet","validateB2BSheet","validateB2BURSheet","validateCDNRSheet","validateCDNURSheet","validateIMPSSheet","Year"],"not_rendered":{"images":10,"macros":1,"external_links":3,"defined_names":58},"read":"whole","wrapped":"gz","date_system":"1900","formulas":"cached_only"}

{"sheet":"ReadMe","index":0,"n_rows":105,"n_cols":5,"rows_kept":105,"merged":[[0,1,2,10],[4,1,4,10],[5,1,5,10],[6,1,6,10],[7,1,7,10],[8,1,8,3],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,1,14,10],[15,1,15,10],[16,1,16,10],[18,1,18,10],[19,4,19,10],[20,1,32,1],[20,2,32,2],[20,4,20,10],[21,4,21,10],[22,4,22,10],[23,4,23,10],[24,4,24,10],[25,4,25,10],[26,4,26,10],[27,4,27,10],[28,4,28,10],[29,4,29,10],[30,4,30,10],[31,4,31,10],[32,4,32,10],[33,1,43,1],[33,2,43,2],[33,4,33,10],[34,4,34,10],[35,4,35,10],[36,4,36,10],[37,4,37,10],[38,4,38,10],[39,4,39,10],[40,4,40,10],[41,4,41,10],[42,4,42,10],[43,4,43,10],[44,1,51,1],[44,2,51,2],[44,4,44,10],[45,4,45,10],[46,4,46,10],[47,4,47,10],[48,4,48,10],[49,4,49,10],[50,4,50,10],[51,4,51,10],[52,1,68,1],[52,2,68,2],[52,4,52,10],[53,4,53,10],[54,4,54,10],[55,4,55,10],[56,4,56,10],[57,4,57,10],[58,4,58,10],[59,4,59,10],[60,4,60,10],[61,4,61,10],[62,4,62,10],[63,4,63,10],[64,4,64,10],[65,4,65,10],[66,4,66,10],[67,4,67,10],[68,4,68,10],[69,1,84,1],[69,2,84,2],[69,4,69,10],[70,4,70,10],[71,4,71,10],[72,4,72,10],[73,4,73,10],[74,4,74,10],[75,4,75,10],[76,4,76,10],[77,4,77,10],[78,4,78,10],[79,4,79,10],[80,4,80,10],[81,4,81,10],[82,4,82,10],[83,4,83,10],[84,4,84,10],[85,1,88,1],[85,2,88,2],[85,4,85,10],[86,4,86,10],[87,4,87,10],[88,4,88,10],[89,1,96,1],[89,2,96,2],[89,4,89,10],[90,4,90,10],[91,4,91,10],[92,4,92,10],[93,4,93,10],[94,4,94,10],[95,4,95,10],[96,4,96,10],[97,1,104,1],[97,2,104,2],[97,4,97,10],[98,4,98,10],[99,4,99,10],[100,4,100,10],[101,4,101,10],[102,4,102,10],[103,4,103,10],[104,4,104,10]],"flags":["formulas_cached_only"]}
[null,"      Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[]
[null,"Introduction to Excel Based GSTR-4 Offline Tool "]
[null,"\n1) The Excel based GSTR-4 Offline Tool is designed to help taxpayer to prepare his GSTR-4 return offline.\n\n2) Details for following Tables of GSTR-4 return can be added by taxpayer using the offline Tool: \n   4A. Inward supplies received from a registered supplier (other than supplies attracting reverse charge): Not applicable for Q2 and Q3 Return Period of FY 2017-18. \n   4B. Inward supplies received from a registered supplier (attracting reverse charge): 4B (B2B).\n   4C. Inward supplies received from unregistered supplier: 4C (B2BUR).\n   4D. Import of service: 4D (IMPS).\n   5A. Supplies [Information furnished in Table 4 of earlier returns]-If details furnished earlier were incorrect: To be made available from Q3 Return Period of FY 2017-18.\n   5B. Debit Notes/Credit Note (Registered): 5B (CDNR) \n   5B. Debit Notes/Credit Note (Unregistered): 5B (CDNUR) \n   5C. Debit Notes/ Credit Notes [amendment of debit notes/credit notes furnished in earlier tax periods]: To be made available from Q3 Return Period of FY 2017-18.\n   6.    Tax on outward supplies made (Net of advance and goods returned): 6 (TXOS).\n   7. Amendments to Outward Supply details furnished in returns for earlier tax periods in Table No. 6: To be made available from Q3 Return Period of FY 2017-18.\n   8(I) \n        8A. Advance amount paid for reverse charge supplies in the tax period: 8A (AT).  \n        8B. Advance amount on which tax was paid in earlier period but invoice has been received in current period: 8B (ATADJ).\n   8 (II). Amendments of information furnished in Table No. 8 (I) for an earlier quarter: To be made available from Q3 Return Period of FY 2017-18.\n   9. TDS Credit received: Not applicable till notified. \n\n    Please Note: Table 5B. Debit Notes/Credit Notes [original)] has been divided in two sub-sections Debit Notes / Credit Notes from Registered and Unregistered person for ease of data entry.\n                    \n"]
[null,"3) The Offline tool has following features to help taxpayer in Return Preparation: \n      1. 'Open Downloaded GSTR-4 JSON File' : To open GSTR-4 Return Details file - downloaded from online GST portal in to the Offline Tool. Upon successful import of file the details would be populated to respective \n          Table wise worksheets.\n      2. 'Generate JSON File to Upload': To generate JSON file for upload of GSTR-4 return details prepared offline on GST portal.\n      3. 'Open downloaded Error JSON Files': To open file downloaded from GST portal from the ‘Processed with error’ link. The downloaded zipped folder consists of two JSON files. Unzip the file and use this button to \n          open both the JSON files together in a single click by selecting both the files. Upon successful import of both the files both the details processed with errors and successfully would be populated to respective \n          Table wise worksheets. Please refer ‘Handling Error’ section for details.  \n      4. 'Validate Sheet’: To validate the data entered in respective worksheet of this offline Tool. Successful validation is notified to taxpayer via pop-up while upon failure of validation the cells that fail validation would be \n          marked in Red.\n      5. 'GSTR-4 Section wise Summary’: Summary of data entered in various worksheets is available on portal. \n\n"]
[null,"4) The process flow for GSTR-4 return preparation without any auto-drafted counterparty details is as follows:\n       1. Enter details in the GSTR-4 Table wise worksheets of the Excel offline Tool.\n       2. Validate the details entered in each sheet using 'validate' button.\n       3. Generate Json using ' Generate JSON File to Upload' option.\n       4. Upload the generated JSON on GST Portal. Preview the details uploaded (facility to pdf download),  Initiate filing, offset liability and File return on the GST portal.\n\n    Please Note: The above flow holds good for Q2 and Q3 Return Period as no counterparty auto-drafted details are available for action. This flow is detailed in subsequent sections. \n\n    The process flow for GSTR-4 return preparation with auto-drafted counterparty details is as follows:\n       1. Download the GSTR-4 return details file (with auto-drafted details) from GST Portal\n       2. Take action on auto drafted details and enter other details in the GSTR-4 Table wise worksheets of the Excel offline Tool\n       3. Validate the details entered in each sheet using 'validate' button\n       3. Generate Json using ' Generate JSON File to Upload’ option\n       4. Upload the generated JSON on GST Portal. Preview the details uploaded, offset liability and File return on 'Home' worksheet (Same as above)\n\n"]
[]
[null,"Preparing GSTR-4 Return Using Offline Tool "]
[null,"1. Please ensure you download the latest version of GSTR-4 Offline Tool from the GST portal. https://www.gst.gov.in/download/returns.\n2. Launch the GSTR-4 Excel based Offline Tool and navigate to worksheet named 'Home'. \n3. Enter your GSTIN . Entered GSTIN would be validated for correct structure. \n4. Select the applicable Financial Year from the drop-down. It is a mandatory field. \n5. Select the applicable Return Period form the drop-down. It is a mandatory field.\n6. Enter details as applicable in various worksheets. It is not mandatory to fill data in all worksheet. The worksheet with no applicable details may be left blank.\n7. Click on 'Validate' to validate each worksheet post all details are captured for the sheet. Check the status of validation. In case of validation failure; please check for cells that have failed validation and correct errors   \n    as per help text in the column ‘Sheet Validation Errors’.\n8. Click on 'Generate summary' to update the summary post details. Ensure that details have been successfully validated for each worksheet. \n9. Click on ' Generate JSON File to Upload ' to generate JSON file for upload of GSTR-4 return details prepared offline on GST portal \n\nNotes \n1. The tax amounts are auto-calculated based on the supply type, rate and taxable amount and are non-editable.\n2. The summary in Offline tool can be used as reference to validate return data successfully uploaded on GST portal by comparing it with 'Preview' available online\n"]
[]
[null," GSTR-4 JSON Upload on GST Portal  "]
[null,"1. Login to GST Portal and select 'Returns Dashboard'\n2. Select applicable Financial Year and Return Period and click on 'Search'. Select GSTR-4 'Prepare Offline' \n3. Upload the JSON prepared using offline Tool using upload option.\n4. The uploaded JSON file would be validated and processed. The validation and Processing may take sometime based on number of records \n5. The details that are successfully validated and processed would be added to your GSTR-4 return for the selected Tax period. \n6. In case of validation failure of one or more details upon processing; a file would be generated with status of Uploaded JSON file as 'Processed with Error'. Error handling is detailed in next section.\n7. Upon successful validation of all details required to be declared for the Return Period. Click on ‘Initiate Filing’ and then select 'Preview' to see Table wise summary of all records processed successfully on GST Portal. \n8. Post successful validation of 'Preview' you may Submit, Offset liability and file GSTR-4.\n\nNotes: \n1. Multiple upload of JSON file is allowed on GST Portal, however, on upload on a new JSON file, all earlier uploaded details are overwritten. Only the details available in last JSON would be available in Online 'Preview' and considered for selected Return Period. Please ensure all applicable details are present in last JSON uploaded on GST portal and all details of the uploaded JSON have been successfully processed to ensure completeness of return data.\n2. Online 'Preview' for validation of summary details is critical to ensure all details required to be declared for selected Return period have been successfully processed on GST portal.  Check the 'Preview' and submit only once assured for completeness of summary available in 'Preview'. In case of any deviation from expected summary details; please upload a new JSON on GST Portal. \n3. You may download the records successfully processed on GST portal anytime by navigating to 'Returns Dashboard>Financial Year>Return Period>GSTR-4 Prepare Offline> Download'. On click of download a JSON file would be available for download in about 20 Mins. The downloaded JSON file may be opened in Offline Tool using ‘Open Downloaded GSTR-4 JSON File' to view/ edit/update details. Post update of details create JSON to upload on GST portal.  \n"]
[]
[null," Error File Handling"]
[null,"1. In case of validation failure of one or more details upon processing of uploaded JSON file; the upload status would be updated as 'Processed with Error'.\n2. A link would be available to download a Zipped Error file beside the ‘Processed with Error’ status \n3.  Download the Zipped Error File and save on your system \n4. Unzip the downloaded file. The Unzipped folder contains two JSON files \n             a.  (returns_<Date>_R4_<GSTIN>_offline.json) with records processed successfully on GST Portal\n             b.  ( returns_<Date>_R4_<GSTIN>errorReport.json ) with records processed with error  on GST Portal\n5. Now click on the button \"Open Downloaded Error JSON files\" to open a file dialog box.\n6. Select both the files from the unzipped folder and click on \"Open\".\n7. A message saying \"Error Files successfully Opened\" upon successful opening of files in Offline tool. A pop-up message with work sheets name with error would be shown \n8. Please navigate to each worksheets and ensure all records from both the files have been successfully opened in Tool\n9. Correct errors in records with error text in column ‘GST Portal Validation Errors’ in each worksheet. \n10. Validate the sheets again post making corrections \n11. Click on 'Generate summary' to update the summary post details have been successfully validated for each worksheet. \n12. Click on 'Generate JSON File to upload' to generate JSON file for upload of GSTR-4 return details prepared offline on GST portal.\n13. Follow steps mentioned in GSTR-4 JSON upload on GST Portal section to file GSTR-4\n\n"]
[]
[null,"  GSTR-4 Data Entry Instructions  "]
[null,"Worksheet Name","GSTR-4 Table Reference","Field name","Help Instruction"]
[null,"4B(B2B) ","4B. Inward Supplies received from a registered supplier (attracting reverse charge)","GSTIN of Supplier *","Enter the GSTIN of the supplier . E.g. 05AEJPP8087R1ZF. Please check that the registration is active on the date of the invoice from GST portal"]
[{"$nulls":3},"Invoice Number *","Enter the Invoice number of invoices issued by registered supplier. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) .The total number of characters should not be more than 16."]
[{"$nulls":3},"Invoice date\n(dd-mm-yyyy) *","Enter date of invoice in DD-MM-YYYY. E.g. 24-07-2017. The date should not be earlier than 01-07-2017 or registration as composition dealer and later than last date of selected Tax period or the Opting-out of composition whichever is earlier "]
[{"$nulls":3},"Invoice Value *","Enter the total value indicated in the invoice  of the received goods or services- with 2 decimal Digits."]
[{"$nulls":3},"Place Of Supply *","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"Reverse Charge *","Select Yes as supplies declared here are subject to tax as per reverse charge mechanism."]
[{"$nulls":3},"Invoice Type *","Select invoice type as Regular"]
[{"$nulls":3},"Rate *","Select the combined (State tax + Central tax) or the integrated tax, as applicable."]
[{"$nulls":3},"Taxable Value *","Enter the taxable value of the received goods or services for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Place of Supply  , Rate and Taxable value "]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Place of Supply  , Rate and Taxable value "]
[{"$nulls":3},"State/UT Tax  *","It is auto calculated based on the Place of Supply  , Rate and Taxable value "]
[{"$nulls":3},"Cess  ","Enter the total Cess amount paid."]
[null,"4C(B2BUR)","4C. Inward Supplies received from an unregistered supplier","Invoice Number *","Enter the Invoice number of invoices issued  to Unregistered Supplier for supplies received. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) with maximum length of 16 characters."]
[{"$nulls":3},"Invoice date\n(dd-mm-yyyy) *","Enter date of invoice in DD-MM-YYYY. E.g. 24-07-2017. The date should not be earlier than 01-07-2017 or registration as composition dealer and later than last date of selected Tax period or the Opting-out of composition whichever is earlier "]
[{"$nulls":3},"Invoice Value *","Enter the total value indicated in the invoice  of the received  goods or services- with 2 decimal Digits."]
[{"$nulls":3},"Place Of Supply *","Select the code of the state from drop down list for the applicable place of supply."]
[{"$nulls":3},"Supply Type *","Select from drop down to declare the supply type as inter state or intra state"]
[{"$nulls":3},"Rate *","Select the combined (State tax + Central tax) or the integrated tax, as applicable."]
[{"$nulls":3},"Taxable Value *","Enter the taxable value of the received goods or services for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Supply type  , Rate and Taxable value "]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Supply type  , Rate and Taxable value "]
[{"$nulls":3},"State/UT Tax  *","It is auto calculated based on the Supply type  , Rate and Taxable value "]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]
[null,"4D(IMPS)","4D. Import of Services ","Invoice Number *","Enter the Invoice number of invoices for import of services. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) .The total number of characters should not be more than 16."]
[{"$nulls":3},"Invoice date\n(dd-mm-yyyy) *","Enter date of invoice in DD-MM-YYYY. E.g. 24-07-2017. The date should not be earlier than 01-07-2017 or registration as composition dealer and later than last date of selected Tax period or the Opting-out of composition whichever is earlier "]
[{"$nulls":3},"Invoice Value *","Enter the total value indicated in the invoice  of the received services- with 2 decimal Digits."]
[{"$nulls":3},"Place Of Supply *","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"Rate *","Select the integrated tax rate , as applicable."]
[{"$nulls":3},"Taxable Value *","Enter the taxable value of the received  services for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on Rate and Taxable value "]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]
[null,"5B(CDNR)"," 5B. Debit Notes/Credit Notes (for registered)","GSTIN of Supplier *","Enter the GSTIN of the supplier . E.g. 05AEJPP8087R1ZF. "]
[{"$nulls":3},"Note / Refund Voucher Number *","Enter the credit or debit note number. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) of maximum length of 16 characters.  "]
[{"$nulls":3},"Note / Refund Voucher date \n(dd-mm-yyyy) *","Enter credit/debit note date in  DD-MM-YYY. The Note date should not be earlier than 01-07-2017  and later than last date of selected Tax period "]
[{"$nulls":3},"Invoice /  Payment Voucher Number *","Enter original invoice number reported  in B2B section of earlier period/current tax period for GST period or pre-GST period against which credit/debit note is issued. "]
[{"$nulls":3},"Invoice /  Payment Voucher date \n(dd-mm-yyyy) *","Enter the original invoice/advance voucher date in  DD-MM-YYYY. E.g. 24-07-2017. The date should not be earlier than 01-07-2017 or registration as composition dealer and later than last date of selected Tax period or the Opting-out of composition whichever is earlier for GST notes; for Pre-GST Notes the date can be earlier than 1-07-2017"]
[{"$nulls":3},"Pre GST *","Select whether the credit/debit note is related to pre-GST supplies."]
[{"$nulls":3},"Document Type *","In the document Type column, Select  Debit note, credit note"]
[{"$nulls":3},"Reason For Issuing document *","Select the applicable reason for issue of the document."]
[{"$nulls":3},"Supply Type *","Declare the type of supply as inter or intra state"]
[{"$nulls":3},"Reverse Charge *","Select Yes as notes added here are linked with invoices subject to tax as per reverse charge mechanism (4B(B2B))"]
[{"$nulls":3},"Note / Refund Voucher Value *","Amount should be up to 2 decimal digits."]
[{"$nulls":3},"Rate *","Select the combined (State tax + Central tax) or the integrated tax, as applicable."]
[{"$nulls":3},"Taxable Value *","Enter the taxable value of the received goods or services for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Supply Type, Rate and Taxable value "]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Supply Type, Rate and Taxable value "]
[{"$nulls":3},"State / UT Tax  *","It is auto calculated based on the Supply Type, Rate and Taxable value "]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]
[null,"5B(CDNUR)","      5B. Debit Notes/Credit Notes (for unregistered)","Note / Refund Voucher Number *","Enter the credit or debit note number. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) of maximum length of 16 characters.  "]
[{"$nulls":3},"Note / Refund Voucher date \n(dd-mm-yyyy) *","Enter credit/debit note date in  DD-MM-YYY. The Note date should not be earlier than 01-07-2017  and later than last date of selected Tax period "]
[{"$nulls":3},"Invoice / Advance Payment Voucher Number *","Enter original invoice number Reported  in B2BUR/IMPS section of earlier/current tax period for GST period or pre-GST period against which credit/debit note is issued. "]
[{"$nulls":3},"Invoice / Advance Payment Voucher date \n(dd-mm-yyyy) *","Enter the original invoice/advance voucher date in  DD-MM-YYYY. E.g. 24-07-2017. The date should not be earlier than 01-07-2017 or registration as composition dealer and later than last date of selected Tax period or the Opting-out of composition whichever is earlier for GST notes; for Pre-GST Notes the date can be earlier than 1-07-2017"]
[{"$nulls":3},"Pre GST *","Select whether the credit/debit note is related to pre-GST supplies."]
[{"$nulls":3},"Document Type *","In the document Type column, Select  Debit note or credit note"]
[{"$nulls":3},"Reason For Issuing document *","Select the applicable reason for issue of the document."]
[{"$nulls":3},"Supply Type *","Declare the type of supply as inter or intra state"]
[{"$nulls":3},"Inward Supply Type *","Select if the inward supply type is Inward supplies received from an unregistered supplier (B2BUR) or Import of service (IMPS)"]
[{"$nulls":3},"Note / Refund Voucher Value *","Amount should be up to 2 decimal digits."]
[{"$nulls":3},"Rate *","Select the combined (State tax + Central tax) or the integrated tax, as applicable."]
[{"$nulls":3},"Taxable Value *","Enter the taxable value of the received goods or services for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Supply Type  , Rate and Taxable value "]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Supply Type  , Rate and Taxable value "]
[{"$nulls":3},"State / UT Tax  *","It is auto calculated based on the Supply Type  , Rate and Taxable value "]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]
[null,"6(TXOS)","6. Tax on outward supplies made\n(Net of advance and goods returned)","Rate of Tax *","Select the Rate of Tax as per the Business Type "]
[{"$nulls":3},"Turnover  *","Declare the total amount of outward supplies made(Net of advance and goods returned) till 2 decimal places"]
[{"$nulls":3},"Central Tax *","It is auto calculated based on the Rate of Tax and Turnover"]
[{"$nulls":3},"State/UT Tax  *","It is auto calculated based on the Rate of Tax and Turnover"]
[null,"8A(AT)","       8A. Advance amount paid for reverse charge supplies in the tax period","Place of supply *","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"Supply Type *","Declare the type of supply as inter or intra state"]
[{"$nulls":3},"Rate *","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[{"$nulls":3},"Gross Advance Paid *","Enter the amount of advance received excluding the tax portion."]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"State/ UT Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]
[null,"8B(ATADJ)","8B. Advance amount on which tax was paid in earlier period \nbut invoice has been received in the current period","Place of supply *","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"Supply Type *","Declare the type of supply as inter or intra state"]
[{"$nulls":3},"Rate *","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[{"$nulls":3},"Gross Advance Paid *","Enter the amount of advance received excluding the tax portion."]
[{"$nulls":3},"Integrated Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"Central Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"State/ UT Tax  *","It is auto calculated based on the Supply Type, Rate and Gross Advance Paid"]
[{"$nulls":3},"Cess ","Enter the total Cess amount paid."]

{"sheet":"Home","index":1,"n_rows":43,"n_cols":234,"rows_kept":43,"merged":[[0,1,2,9],[4,1,4,2],[4,5,6,9],[5,1,5,2],[6,1,6,2],[8,1,10,9],[11,1,11,9],[12,1,14,9],[16,1,16,9],[17,1,18,9],[20,1,20,9],[22,1,22,9],[24,1,24,9],[26,1,26,9],[27,1,30,1],[27,2,27,9],[29,2,29,9],[31,1,31,9],[32,1,35,1],[32,2,32,9],[34,2,34,9],[36,1,36,9],[38,1,38,9],[40,1,40,9],[42,1,42,3]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0",{"$nulls":229},2,3,65556548.86]
[]
[]
[]
[null,"GSTIN *",null,"Financial Year \n(yyyy) *","Tax Period *","      Please Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"gstin",null,"rety","retq"]
[]
[]
[]
[]
[]
[null,"Error File Handling"]
[null,"In case of error(s) in the GSTR-4 data uploaded, GST Portal will generate an error file (in .Zip format)\n\nSteps to correct errors and upload Revised GSTR-4 return data on GST Portal\n     1) Download the Zipped Error and save on your system \n     2) Unzip the downloaded file. The Unzipped folder contains two JSON files \n             a.  ( returns_<Date>_R4_<GSTIN>_offline.json ) with records processed successfully on GST Portal\n             b.  ( returns_<Date>_R4_<GSTIN>_errorReport.json ) with records processed with error on GST Portal\n     3) Now click on the button \"Open Downloaded Error JSON files\" on the right. It will open a file dialog box.\n     4) Select both the files from the unzipped folder and click on \"Open\".\n     5) A message \"Error Files successfully Opened\" would be displayed successful opening of files in Offline tool\n     7) Please navigate to each worksheets and ensure all records from both the files have been successfully opened in Tool \n     8) Correct errors in records with error text in column ‘GST Portal Validation Errors’ in each worksheet\n     9) Validate each sheet and generate JSON to upload your revised data on GST-portal\n"]
[]
[]
[]
[null,"GSTR-4-Sectionwise Summary"]
[null,"Note: All data in below section is calculated based on input in other worksheets.Click on \"Get Summary\" button to the right."]
[]
[null,"No. of Suppliers","No. of Notes / Vouchers","No. of Invoices","Total Notes /  Vouchers / Invoice Value","Total Taxable Value","Total Integrated Tax","Total Central Tax","Total State / UT Tax","Total Cess"]
[null,"Summary of 4B(B2B)"]
[null,0,"NA",0,0,0,0,0,0,0]
[null,"Summary of 4C(B2BUR)"]
[null,"NA","NA",0,0,0,0,0,0,0]
[null,"Summary of 4D(IMPS)"]
[null,"NA","NA",0,0,0,0,"NA","NA",0]
[null,"Summary of 5B(CDNR)"]
[null,0,"Credit Note "]
[null,null,0,0,0,0,0,0,0,0]
[null,null,"Debit Note Summary"]
[null,null,0,0,0,0,0,0,0,0]
[null,"Summary of 5B(CDNUR)"]
[null,"NA","Credit Note "]
[null,null,0,0,0,0,0,0,0,0]
[null,null,"Debit Note Summary"]
[null,null,0,0,0,0,0,0,0,0]
[null,"Summary of 6(TXOS)"]
[null,"NA","NA","NA","NA",0,"NA",0,0,"NA"]
[null,"Summary of 8A(AT)"]
[null,"NA","NA","NA","NA",0,0,0,0,0]
[null,"Summary of 8B(ATADJ)"]
[null,"NA","NA","NA","NA",0,0,0,0,0]
[null,"Grand Total",null,null,0,0,0,0,0,0]

{"sheet":"4B(B2B)","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"merged":[[0,1,2,14],[3,1,3,15]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"                                                                                          4B. Inward Supplies received from a registered supplier (attracting reverse charge)\n\n                                                                                                     Please Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"GSTIN of Supplier *","Invoice Number *","Invoice date\n(dd-mm-yyyy) *","Invoice Value *","Place Of Supply *","Reverse Charge *","Invoice Type *","Rate *","Taxable Value *","Integrated Tax  *","Central Tax  *","State/UT Tax  *","Cess  ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"ctin","inum","idt","val","pos","rchrg","inv_typ","rt","txval","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"4C(B2BUR)","index":3,"n_rows":6,"n_cols":14,"rows_kept":6,"merged":[[0,1,2,12],[3,1,3,12]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"4C. Inward Supplies received from an unregistered supplier\n\nPlease Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Invoice Number *","Invoice date\n(dd-mm-yyyy) *","Invoice Value *","Place Of Supply *","Supply Type *","Rate *","Taxable Value *","Integrated Tax  *","Central Tax  *","State/UT Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"inum","idt","val","pos","sply_ty","rt","txval","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"4D(IMPS)","index":4,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,1,2,9],[3,1,3,10]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"4D. Import of Service\n\nPlease Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Invoice Number *","Invoice date\n(dd-mm-yyyy) *","Invoice Value *","Place Of Supply *","Rate *","Taxable Value *","Integrated Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"inum","idt","val","pos","rt","txval","iamt","csamt","error_msg","error_msg"]

{"sheet":"5B(CDNR)","index":5,"n_rows":6,"n_cols":20,"rows_kept":6,"merged":[[0,1,2,18],[3,1,3,18]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"                                                                                                                       5B. Debit Notes/Credit Notes (for registered)\n\n                                                                                                 Please Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"GSTIN of Supplier *","Note / Refund Voucher Number *","Note / Refund Voucher date \n(dd-mm-yyyy) *","Invoice /  Payment Voucher Number *","Invoice /  Payment Voucher date \n(dd-mm-yyyy) *","Pre GST *","Document Type *","Reason For Issuing document *","Supply Type *","Reverse Charge *","Note / Refund Voucher Value *","Rate *","Taxable Value *","Integrated Tax  *","Central Tax  *","State / UT Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"ctin","nt_num","nt_dt","inum","idt","p_gst","ntty","rsn","sply_ty","rchrg","val","rt","txval","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"5B(CDNUR)","index":6,"n_rows":6,"n_cols":19,"rows_kept":6,"merged":[[0,1,2,17],[3,1,3,17]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"                                                                                                                    5B. Debit Notes/Credit Notes (for unregistered)\n\n                                                                                                  Please Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Note / Refund Voucher Number *","Note / Refund Voucher date \n(dd-mm-yyyy) *","Invoice / Advance Payment Voucher Number *","Invoice / Advance Payment Voucher date \n(dd-mm-yyyy) *","Pre GST *","Document Type *","Reason For Issuing document *","Supply Type *","Inward Supply Type *","Note / Refund Voucher Value *","Rate *","Taxable Value *","Integrated Tax  *","Central Tax  *","State / UT Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"nt_num","nt_dt","inum","idt","p_gst","ntty","rsn","sply_ty","typ","val","rt","txval","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"6(TXOS)","index":7,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[0,1,2,5],[3,1,3,5]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"6. Tax on outward supplies made\n(Net of advance and goods returned)\nPlease Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Rate of Tax *","Turnover  *","Central Tax *","State/UT Tax  *"," GST Portal Validation Errors"]
[null,"rt","trnovr","camt","samt","error_msg"]
[null,{"v":1,"d":"1.00"}]
[null,{"v":2,"d":"2.00"}]
[null,{"v":5,"d":"5.00"}]

{"sheet":"8A(AT)","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,1,2,9],[3,1,3,9]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"                                                                             8A. Advance amount paid for reverse charge supplies in the tax period\n\n                                                                             Please Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Place of supply *","Supply Type *","Rate *","Gross Advance Paid *","Integrated Tax  *","Central Tax  *","State/ UT Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"pos","sply_ty","rt","ad_amt","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"8B(ATADJ)","index":9,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,1,2,9],[3,1,3,9]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GSTR4 Offline Tool  v1.0"]
[]
[]
[null,"8B. Advance amount on which tax was paid in earlier period \nbut invoice has been received in the current period\nPlease Note : Fields marked with * (red asterisk) are mandatory fields and need to be filled up"]
[null,"Place of supply *","Supply Type *","Rate *","Gross Advance Paid *","Integrated Tax  *","Central Tax  *","State/ UT Tax  *","Cess ","Sheet Validation Errors"," GST Portal Validation Errors"]
[null,"pos","sply_ty","rt","ad_amt","iamt","camt","samt","csamt","error_msg","error_msg"]

{"sheet":"master","index":10,"n_rows":38,"n_cols":32,"rows_kept":38,"hidden":true,"flags":["formulas_cached_only"]}
[null,"Reverse Charge/Pre GST Code","Reverse Charge/Pre GST",null,"Note Type","Note Type",null,"Tax Rate",null,"POS code","POS",null,"Invoice Type Code","Invoice Type",null,"Reason For Issuing Note Code","Reason For Issuing Note",null,"Supply Type Code ","Supply Type ",null,"Action ","Action ",null,"Composition Tax rate",null,"Quarter","Quarter Code",null,"Year",null,"Invoice Type"]
[null,"N","No",null,"C","Credit Note",null,"0",null,"01C","01-Jammu & Kashmir",null,"R","Regular",null,"05","Change in POS",null,"INTER","Inter State",null,"A","Accept",null,{"v":1,"d":"1.00"},null,"Apr-June","13Q",null,2017,null,"B2BUR"]
[null,"Y","Yes",null,"D","Debit Note",null,0.25,null,"02C","02-Himachal Pradesh",{"$nulls":4},"04","Correction in Invoice",null,"INTRA","Intra State",null,"D","Delete",null,{"v":2,"d":"2.00"},null,"July-Sep","14Q",null,2018,null,"IMPS"]
[{"$nulls":4},"R","Refund Voucher",null,"3",null,"03C","03-Punjab",{"$nulls":4},"03","Deficiency in services",{"$nulls":4},"M","Modify",null,{"v":5,"d":"5.00"},null,"Oct-Dec","15Q",null,2019]
[{"$nulls":7},"5",null,"04C","04-Chandigarh",{"$nulls":4},"06","Finalization of Provisional assessment",{"$nulls":4},"P","Pending",{"$nulls":3},"Jan-Mar","16Q",null,2020]
[{"$nulls":7},"12",null,"05C","05-Uttarakhand",{"$nulls":4},"07","Others",{"$nulls":4},"R","Reject",{"$nulls":6},2021]
[{"$nulls":7},"18",null,"06C","06-Haryana",{"$nulls":4},"02","Post Sale Discount",{"$nulls":12},2022]
[{"$nulls":7},"28",null,"07C","07-Delhi",{"$nulls":4},"01","Sales Return",{"$nulls":9},"Quarter Code","Quarter ",null,2023]
[{"$nulls":9},"08C","08-Rajasthan",{"$nulls":15},"13Q","Apr-June",null,2024]
[{"$nulls":9},"09C","09-Uttar Pradesh",{"$nulls":15},"14Q","July-Sep",null,2025]
[{"$nulls":9},"10C","10-Bihar",{"$nulls":15},"15Q","Oct-Dec",null,2026]
[{"$nulls":9},"11C","11-Sikkim",{"$nulls":15},"16Q","Jan-Mar",null,2027]
[{"$nulls":9},"12C","12-Arunachal Pradesh",{"$nulls":18},2028]
[{"$nulls":9},"13C","13-Nagaland",{"$nulls":18},2029]
[{"$nulls":9},"14C","14-Manipur",{"$nulls":18},2030]
[{"$nulls":9},"15C","15-Mizoram",{"$nulls":18},2031]
[{"$nulls":9},"16C","16-Tripura",{"$nulls":18},2032]
[{"$nulls":9},"17C","17-Meghalaya"]
[{"$nulls":9},"18C","18-Assam"]
[{"$nulls":9},"19C","19-West Bengal"]
[{"$nulls":9},"20C","20-Jharkhand"]
[{"$nulls":9},"21C","21-Odisha"]
[{"$nulls":9},"22C","22-Chhattisgarh"]
[{"$nulls":9},"23C","23-Madhya Pradesh"]
[{"$nulls":9},"24C","24-Gujarat"]
[{"$nulls":9},"25C","25-Daman & Diu"]
[{"$nulls":9},"26C","26-Dadra & Nagar Haveli"]
[{"$nulls":9},"27C","27-Maharashtra"]
[{"$nulls":9},"29C","29-Karnataka"]
[{"$nulls":9},"30C","30-Goa"]
[{"$nulls":9},"31C","31-Lakshdweep"]
[{"$nulls":9},"32C","32-Kerala"]
[{"$nulls":9},"33C","33-Tamil Nadu"]
[{"$nulls":9},"34C","34-Puducherry"]
[{"$nulls":9},"35C","35-Andaman & Nicobar Islands"]
[{"$nulls":9},"36C","36-Telangana"]
[{"$nulls":9},"37C","37-Andhra Pradesh"]
[{"$nulls":9},"97C","97-Other Territory"]