{"text_format":"5","workbook":"xlsx","n_sheets":13,"sheets":["Help Instruction","b2b","b2cl","b2cs","cdnr","cdnur","exp","at","atadj","exemp","hsn","docs","master"],"props":{"title":"GSTR1 Excel Workbook Template","subject":"For uploading data to offline tool","creator":"Rajesh Kumar;Shashi Bhushan Singh","last_modified_by":"E L I T E","company":"Goods And Services Network (GSTN)"},"not_rendered":{"images":3},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"Help Instruction","index":0,"n_rows":168,"n_cols":5,"rows_kept":168,"merged":[[0,1,0,10],[2,1,2,10],[3,1,3,3],[5,1,5,10],[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[14,1,14,10],[15,4,15,10],[16,1,27,1],[16,2,27,2],[16,3,16,10],[17,4,17,10],[18,4,18,10],[19,4,19,10],[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,1,36,1],[28,2,36,2],[28,3,28,10],[29,4,29,10],[30,4,30,10],[31,4,31,10],[32,4,32,10],[33,4,33,10],[34,4,34,10],[35,4,35,10],[36,4,36,10],[37,1,43,1],[37,2,43,2],[37,3,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,57,1],[44,2,57,2],[44,3,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],[53,4,53,10],[54,4,54,10],[55,4,55,10],[56,4,56,10],[57,4,57,10],[58,1,71,1],[58,2,71,2],[58,3,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],[67,4,67,10],[68,4,68,10],[69,4,69,10],[70,4,70,10],[71,4,71,10],[72,3,72,10],[73,1,82,1],[73,2,82,2],[73,3,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,1,87,1],[83,2,87,2],[83,3,83,10],[84,4,84,10],[85,4,85,10],[86,4,86,10],[87,4,87,10],[88,1,92,1],[88,2,92,2],[88,3,88,10],[89,4,89,10],[90,4,90,10],[91,4,91,10],[92,4,92,10],[93,3,93,10],[94,1,98,1],[94,2,98,2],[94,3,94,10],[95,4,95,10],[96,4,96,10],[97,4,97,10],[98,4,98,10],[99,1,109,1],[99,2,109,2],[99,3,99,10],[100,4,100,10],[101,4,101,10],[102,4,102,10],[103,4,103,10],[104,4,104,10],[105,4,105,10],[106,4,106,10],[107,4,107,10],[108,4,108,10],[109,4,109,10],[110,1,115,1],[110,2,115,2],[110,3,110,10],[111,4,111,10],[112,4,112,10],[113,4,113,10],[114,4,114,10],[115,4,115,10],[118,1,118,10],[119,1,119,10],[120,1,120,10],[121,1,121,10],[122,1,122,10],[123,1,123,10],[124,1,124,10],[125,1,125,10],[127,1,127,10],[128,1,128,10],[129,1,129,10],[130,1,130,10],[131,1,131,10],[132,1,132,10],[133,1,133,10],[134,1,134,10],[135,1,135,10],[136,1,136,10],[137,1,137,10],[138,1,138,10],[139,1,139,10],[140,1,140,10],[141,1,141,10],[142,1,142,10],[143,1,143,10],[144,1,144,10],[145,1,145,10],[147,1,147,10]],"headers":{"header":["","Goods and Services Tax"],"footer":["Version 1.1","© 2016-17 Goods and Services Tax Network"]}}
[null,"Invoice & other  data  upload for creation of GSTR 1"]
[null,"Introduction to Excel based template for data upload in Java offline  tool"]
[null,"s The Offline tool comes bundled with MS Excel Template and a java  tool. This Excel workbook template has 11 data entry worksheets, 1 master sheet and 1 Help Instruction sheet i.e. total 13 worksheets. The 11 data entry worksheets are named: b2b, b2cl, b2cs, cdnr, cdnur exp, at, atadj, exemp, hsn and doc in which day-to-day business transaction required to be reported in GSTR 1 can be recorded or entered by the taxpayers.  At desired interval, the data entered in the MS-Excel worksheet can be uploaded on the GST Portal using the java offline tool which will import the data from excel workbook and convert the same into a Json file which is understood by GST portal. (www.gst.gov.in)   \ns  It  has been designed to enable taxpayers to prepare GSTR 1  in  offline mode (without Internet). It can also be used to carry out bulk upload of invoice/other details to GST portal.   \ns  The appearance and functionalities of the Offline  tool screens are similar to that  of the returns filing  screens on the GST Portal.\ns  Approximately 19,000 line items can be uploaded in one go using the java tool. In case a taxpayer has more invoice data, he can use the tool multiple times to upload the invoice data.\n\nData can be uploaded/entered to the offline tool in four ways:\n\n1.  Importing the entire excel workbook to the java  tool where data in all sections (worksheets) of the excel file will be imported in the tool in one go.\n2.  Line by line  data entry  by return preparer on the java offline tool. \n3.  Copy from the  excel  worksheets from the top row  including the summary and  header  and pasting it in the designated box in the import screen of the  java offline tool.  Precaution: All the columns including headers should be in the same format  and have the same header as of the java offline tool.  \n4. Section by section of a particular return - using a .CSV file as per the format given along with the java tool. Many accounting software packages generate .CSV file in the specified format and the same can be imported in the tool."]
[]
[null,"Understanding the Excel  Workbook Template"]
[null,"a) It is always recommended to download the excel workbook template from the GST portal only."]
[null,"b) The taxpayer can fill the excel workbook template with different worksheet for the applicable sections of the return and then import the excel file to the java tool. Data has to be filled in the sections (worksheets) applicable to him and the others may be left blank. "]
[null,"c) The data in the excel file should be in the format specified below in respective sections."]
[null,"d) In a case where the taxpayer does not have data applicable for all sections, those sections may be left blank and the java tool  will automatically take care of the data to be filled in the applicable sections only."]
[null,"e) For Group import (all worksheets of workbook) taxpayer need to fill all the details into downloaded standard format GSTR1_Excel_Workbook_Template-V1.1.xlsx file"]
[null,"f) User can export  Data from local accounting software loaded in the above format as .CSV file and import it in the java tool to generate the file in  .Json  format  for bulk. Warning: Your accounting software should generate .CSV file in the format specified by GST Systems."]
[null,"g) In all the worksheets except hsn, the central tax, integrated tax, and state tax are not required to be furnished in the excel worksheets but would be computed on the furnished rate and taxable value in the java offline tool. The taxpayer can edit the tax amounts calculated in the java tool if the tax collected values are different.  "]
[null,"h) In the \"doc's worksheet, the net issued column has not been provided, this value will be computed in the java offline tool based on the total number of documents and the number of cancelled  documents furnished in this worksheet."]
[]
[null,"The table below provides the name, full form and detailed description for each  field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory."]
[null,"Worksheet Name","Reference","Field name","Help Instruction"]
[null,"b2b","B2B Supplies","Details of invoices of Taxable supplies made to other registered taxpayers\n\n\n\n\n"]
[{"$nulls":3},"1. GSTIN/UIN of Recipient*","Enter the GSTIN or UIN of the receiver. E.g. 05AEJPP8087R1ZF. Check that the registration is active on the date of the invoice from GST portal"]
[{"$nulls":3},"2. Invoice  number *","Enter the Invoice number of invoices issued to  registered recipients. 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},"3. Invoice Date* ","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"4. Invoice value*","Enter the total value indicated in the invoice  of the supplied  goods or services- with 2 decimal Digits."]
[{"$nulls":3},"5. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"6. Reverse Charge*","Please select Y or N , if the supplies/services are subject to tax as per reverse charge mechanism."]
[{"$nulls":3},"7. Invoice Type*","Select from the dropdown whether the supply is regular, or to a SEZ unit/developer with or without payment of tax or deemed export."]
[{"$nulls":3},"8. E-Commerce GSTIN*","Enter the GSTIN of the e-commerce company if the supplies are made through an e-Commerce operator."]
[{"$nulls":3},"9. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax, as applicable."]
[{"$nulls":3},"10. Taxable Value*","Enter the taxable value of the supplied  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},"11. Cess Amount","Enter the total Cess amount collected/payable."]
[null,"b2cl","B2C Large","Invoices for Taxable outward supplies to consumers where\na)The place of supply is outside the state where the supplier is registered and\nb)The total invoice value is more that Rs 2,50,000"]
[{"$nulls":3},"1. Invoice  number* ","Enter the Invoice number of invoices issued  to Unregistered Recipient of the  other State  with invoice value more than 2.5 lakh. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) with maximum length of 16 characters."]
[{"$nulls":3},"2. Invoice Date ","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"3. Invoice value*","Invoice value should be more than Rs 250,000 and up to two decimal digits."]
[{"$nulls":3},"4. Place of Supply(POS)*","Select the code of the state from drop down list for the applicable place of supply."]
[{"$nulls":3},"5. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate, as applicable."]
[{"$nulls":3},"6. Taxable Value*","Enter the taxable value of the supplied  goods or services for each rate line item -2 decimal digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"7. Cess Amount","Enter the total  Cess amount collected/payable."]
[{"$nulls":3},"8. E-Commerce GSTIN","Enter the GSTIN of the e-commerce company if the supplies are made through an e-Commerce operator."]
[null,"b2cs","B2C Small","Supplies made to consumers and unregistered persons of the following nature\na) Intra-State: any value\nb) Inter-State: Invoice value Rs 2.5 lakh or less"]
[{"$nulls":3},"1. Type*","In the Type column, enter E if the supply is done through E-Commerce or else enter OE (other than E-commerce)."]
[{"$nulls":3},"2. Place of Supply(POS)*","Select the code of the state from drop down list for the applicable place of supply."]
[{"$nulls":3},"3. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate. "]
[{"$nulls":3},"4. Taxable Value*","Enter the taxable value of the supplied  goods or services for each rate line item -2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"5. Cess Amount","Enter the total  Cess amount collected/payable. "]
[{"$nulls":3},"6. E-Commerce GSTIN","Enter the GSTIN of the e-commerce company if the supplies are made through an e-Commerce operator."]
[null,"cdnr","Credit/ Debit Note","Credit/ Debit Notes/Refund vouchers issued to the registered taxpayers during the tax period. Debit or credit note issued against invoice will be reported here against original invoice, hence fill the details of original invoice also which was furnished in B2B,B2CL section of earlier/current period tax period."]
[{"$nulls":3},"1. GSTIN/UIN*","Receiver GSTIN/UIN"]
[{"$nulls":3},"2. Invoice/Advance Receipt Number*","Enter original invoice number Reported  in B2B section of earlier period/current tax period  or pre-GST period against which credit/debit note is issued. Incase of refund voucher please enter the related advance receipt voucher number."]
[{"$nulls":3},"3. Invoice/Advance Receipt date*","Enter the original invoice/advance receipt date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"4. Note/Refund Voucher Number*","Enter the credit/debit note number or the refund voucher number. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) of maximum length of 16 characters. "]
[{"$nulls":3},"5. Note/ Refund Voucher date*","Enter credit/debit note/Refund voucher date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"6. Document Type*","In the document Type column, enter \"D\" if the note is Debit note, enter \"C\" if note is credit note or enter \"R\" for refund voucher."]
[{"$nulls":3},"7. Reason For Issuing document*","Select the applicable reason for issue of the document."]
[{"$nulls":3},"8. Place of Supply*","Declare the place of supply based on the original document."]
[{"$nulls":3},"9. Note/Refund Voucher value*","Amount should be with only up to 2 decimal digits."]
[{"$nulls":3},"10. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax."]
[{"$nulls":3},"11.Taxable value*","Enter the taxable value of the supplied  goods or services for each rate line item -2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"12. Cess Amount","Enter the total  Cess amount."]
[{"$nulls":3},"13. Pre GST","Select whether the credit/debit note is related to pre-GST supplies."]
[null,"cdnur","Credit/ Debit Note for unregistered Persons","Credit/ Debit Notes/Refund vouchers issued to the unregistered persons against interstate invoice value is  more than Rs 2.5 lakh"]
[{"$nulls":3},"1. UR Type*","Select the type of  supply to Unregistered Taxpayers (UR) against which the document has been issued.Select \"EXPWP\" or \"EXPWOP\" for export /\"B2CL\" for supplies to consumers for dropdown based on original invoice.\n\"EXPWP\" represents Export with payment and \"EXPWOP\" represent Export without payment."]
[{"$nulls":3},"2. Note/Refund Voucher Number*","Enter the credit/debit note number or the refund voucher number. Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) of maximum length of 16 characters."]
[{"$nulls":3},"3. Note/ Refund Voucher date*","Enter credit/debit note/Refund voucher date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"4. Document Type*","In the document Type column, enter \"D\" if the note is Debit note, enter \"C\" if note is credit note or enter \"R\" for refund voucher."]
[{"$nulls":3},"5. Invoice/Advance Receipt Number*","Enter original invoice number Reported  in B2B section of earlier period/current tax period or pre-GST Period against which credit/debit note is issued. Incase of refund voucher please enter the related advance receipt voucher number."]
[{"$nulls":3},"6. Invoice/Advance Receipt date*","Enter the original invoice/advance receipt date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"7. Reason For Issuing document*","Select the applicable reason for issue of the document from the dropdown."]
[{"$nulls":3},"8. Place of Supply","Declare the place of supply based on the original document."]
[{"$nulls":3},"9. Note/Refund Voucher value*","Amount should be up to 2 decimal digits."]
[{"$nulls":3},"10. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate. "]
[{"$nulls":3},"11.Taxable value","Enter the taxable value of the supplied  goods or services for each rate line item -up to 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[{"$nulls":3},"12. Cess Amount","Enter the total  Cess amount."]
[{"$nulls":3},"13. Pre GST","Select whether the credit/debit note is related to pre-GST supplies."]
[]
[null,"exp","Export","Exports supplies including supplies to SEZ/SEZ Developer or deemed exports"]
[{"$nulls":3},"1.Export Type*","In the Type column, enter WPAY if the Export  is with payment of tax or else enter WOPAY."]
[{"$nulls":3},"2. Invoice  number* ","Enter the Invoice number issued to the registered receiver.  Ensure that the format is alpha-numeric with  allowed special characters of slash(/) and dash(-) with maximum length of sixteen characters."]
[{"$nulls":3},"3. Invoice Date* ","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[{"$nulls":3},"4. Invoice value*","Enter the invoice  value of the goods or services- up to 2 decimal Digits."]
[{"$nulls":3},"5. Port Code","Enter the six digit code of port through which goods were exported. Please refer to the list of port codes available on the GST common portal. This is not required in case of export of services."]
[{"$nulls":3},"6. Shipping Bill Number","Enter the unique reference number of shipping bill. This information if not available at the timing of submitting the return the same may be left blank and provided later."]
[{"$nulls":3},"7. Shipping Bill Date","Enter the unique reference number of shipping bill. This information if not available at the timing of submitting the return the same may be left blank and provided later. This is not required in case of export of services."]
[{"$nulls":3},"9. Rate","Enter the applicable integrated tax rate."]
[{"$nulls":3},"10. Taxable Value","Enter the taxable value of the supplied  goods or services for each rate line item -up to 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[null,"at","Tax liability on advances","Tax liability arising on account of receipt of consideration  for which  invoices have not been issued in the same tax period."]
[{"$nulls":3},"1. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"2. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[{"$nulls":3},"3. Gross advance received*","Enter the amount of advance received excluding the tax portion."]
[{"$nulls":3},"4. Cess Amount","Enter the total  Cess amount collected/payable."]
[null,"atadj","Advance adjustments","Adjustment of tax liability for tax already paid  on advance receipt of consideration and invoices issued in the current period for the supplies. "]
[{"$nulls":3},"1. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[{"$nulls":3},"2. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[{"$nulls":3},"3. Gross advance adjusted*","Enter the amount of advance on which has tax has already been paid in earlier tax period  and invoices are declared during this tax period. This amount is excluding the tax portion"]
[{"$nulls":3},"4. Cess Amount","Enter the total  Cess amount to be adjusted"]
[]
[null,"exemp","Nil Rated, Exempted and Non GST supplies","Details of Nil Rated, Exempted and Non GST Supplies made during the tax period"]
[{"$nulls":3},"1. Description","Indicates the type of supply. "]
[{"$nulls":3},"2.Nil rated supplies","Declare the value of supplies made under the \"Nil rated\" category for the supply type selected in  1. above. The amount to be declared here should exclude amount already declared in B2B and B2CL table as line items in tax invoice."]
[{"$nulls":3},"3.Exempted\n(Other than Nil rated/non-GST\nsupply)","Declare the value of supplies made under the \"Exempted \"category for the supply type selected in  1. above."]
[{"$nulls":3},"4.Non GST Supplies","Declare the value of supplies made under the \"Non GST\" category for the supply type selected in  1. above. This column is to capture all the supplies made by the taxpayer which are out of the purview of GST"]
[null,"hsn","HSN Summary","HSN wise summary of goods /services supplied during the tax period"]
[{"$nulls":3},"1. HSN*","Enter the HSN Code  for the supplied goods or Services. Minimum digit required to be mentioned in the tax invoice and consequently to be reported is as follows.\n\n1. Up to rupees one crore fifty lakhs annual turnover - Nil digit \n2. more than rupees one crore fifty lakhs and up to rupees five crores annual turnover - 2 digit  \n3. more than rupees five crores annual turnover - 4  digit.\n"]
[{"$nulls":3},"2. Description*","Enter the description of the supplied goods or Services. Description becomes a mandatory field if HSN code is not provided above."]
[{"$nulls":3},"3. UQC*","Select the applicable Unit Quantity Code  from the drop down."]
[{"$nulls":3},"4. Total Quantity*","Enter the total quantity of the supplied goods or Services- up to 2 decimal Digits."]
[{"$nulls":3},"5. Total Value*","Enter the invoice  value of the goods or services-up to 2 decimal Digits."]
[{"$nulls":3},"6. Taxable Value*","Enter the total taxable value of the supplied goods or services- up to 2 decimal Digits."]
[{"$nulls":3},"7. Integrated Tax Amount","Enter the total  Integrated tax amount collected/payable."]
[{"$nulls":3},"8. Central Tax Amount","Enter the total  Central tax amount collected/payable."]
[{"$nulls":3},"9. State/UT Tax Amount","Enter the total State/UT tax amount collected/payable."]
[{"$nulls":3},"10. Cess Amount","Enter the total  Cess amount collected/payable."]
[null,"docs","List of Documents issued","Details of various documents issued by the taxpayer during the tax period"]
[{"$nulls":3},"1. Nature of Document*","Select the applicable document type  from the drop down."]
[{"$nulls":3},"2. Sr. No From*","Enter the invoice/document series start number."]
[{"$nulls":3},"3. Sr. No To*","Enter the invoice/document series end number."]
[{"$nulls":3},"5.Total Number*","Enter the total no of documents in this particular series."]
[{"$nulls":3},"6.Cancelled","No of documents cancelled in the particular series."]
[]
[]
[null,"Common mistakes in filling Excel template"]
[null,"1. GSTIN of supplier/E-commerce  should be a valid one. State code of supplier GSTIN and E-Commerce GSTIN should be the same."]
[null,"2. Duplication of invoices with the same tax rate shouldn’t be there-otherwise System throws error as \"Non duplicated invoices were added & these invoices are duplicated\" at the time of import. "]
[null,"3. Amount should be only up to  2 decimal digits"]
[null,"4  Ensure that filling of excel should be strictly as per sample data to avoid errors. "]
[null,"5. Copy  paste data from the excel template not including the header rows 1 to 4 will throw an error. "]
[null,"6. The work sheet name in the excel file of return data prepared by the return preparer should be the same as mentioned in the sample excel template. "]
[null,"7. Master data sheet provides the inputs allowed in the mentioned data field. Inputs in the master data sheet have been used for the drop down lists in the worksheets."]
[]
[null,"Special Instructions"]
[null,"1) To facilitate the declaration of date in the specified format \"dd-mmm-yyyy\",  ensure the system date format of your computer is \"dd/mm/yyyy or dd-mm-yyyy\"."]
[null,"2) For invoices containing multiple line items invoice level details like GSTIN/UIN, Invoice Number, Invoice Date and Place of Supply should be repeated for all the line items, in the absence of the same system will not accept those items"]
[null,"3) Taxable Value, Rate and cess amount as applicable to the line items may be different in the same invoice."]
[null,"4) On successful import of the data from the excel file to the offline utility tool, the tool takes care of proper placement of the same in the return format"]
[null,"5) In the worksheets on the combined (central tax+state tax) tax  or integrated tax  rate has to be mentioned. The java tool will calculate the  central tax, state tax or integrated tax.  The tax payer can edit these amounts in the java tool if the collected value is different. "]
[null,"6) In this first version worksheets are not being provided for uploading amendment details as these are not expected in the first GST return. Those will be provided in the next version."]
[null,"7) In the top of  each excel worksheet , there is a summary row which gives the count or total of  the key columns to help in reconciliation. "]
[null,"8) The worksheets for furnishing exempt supplies details and issued documents details are being provided in this excel workbook template however the data cannot be imported from the excel to the java tool in this version. The tax payer can enter the few exempt supplies detail  values and details of documents issued directly in the screens available on GST portal . "]
[null,"9) The worksheets have some data as example. Please delete the data from all worksheets before use. "]
[null,"10) The number mentioned in bracket in the top most row in each data entry worksheet refer to the corresponding table number in the notified GSTR 1 format. For example in b2b worksheet \"Summary For B2B(4)\" here \"4\" refers to the table number 4 of GSTR 1 format."]
[null,"11) This excel workbook template works best with Microsoft Excel 2007 and above. "]
[null,"12) Ensure that there are no stray entries in any cell of the sheets other than return related declaration under the indicated column headers."]
[null,"13) It is advisable that separate excel sheets be prepared for each month with the name having month name  as a part of it's name. In case of multiple uploads for a  month, the file name may be classified as Part A, Part B etc  to avoid confusion. "]
[null,"14) In case of JSON files  created by the offline tool , if the taxpayer is frequently importing  invoice data in a tax period, he should name the different created JSON file of a part of a month/tax period by including the name of month and the part number. "]
[null,"15)Before importing the excel file in the offline tool for a particular tax period, it is advisable that the taxpayer should delete if any existing data of that tax period by clicking \"Delete All Data\"  tab in the  Java Offline Tool. If  any data remains in the tool will overwrite the existing data.  "]
[null,"16) If one uploads the JSON file for a tax period with  the same invoice number but differing  details again,  the later invoice details will overwrite the earlier details. "]
[null,"17) In case of other sections where the consolidated details have to be furnished, the details of whole section furnished earlier would be overwritten by the later uploaded details. "]
[null,"18) In case of b2b worksheet, if the invoice has been selected as subject to reverse charge, the top summary row excludes the value of cess amount as it is not collected by the supplier."]
[]
[null," Sample excel sheet with multiple line item in a single invoice is shown below:"]
{"$rows_empty":9}
[null,"Term/ Acronym","Description"]
[null,"GSTIN","Goods and Services Taxpayer Identification Number"]
[null,"GSTN","Goods and Services Tax Network"]
[null,"HSN","Harmonized System of Nomenclature"]
[null,"B2B","Registered Business to Registered Business"]
[null,"B2C","Registered Business to Unregistered Consumer"]
[null,"POS","Place of Supply of Goods or Services – State code to be mentioned"]
[null,"UIN","Unique Identity Number"]
[null,"GSTR1","GST Return 1"]
[null,"GST","Goods and Services Tax"]
[null,"UQC","Unit Quantity Code"]

{"sheet":"b2b","index":1,"n_rows":4,"n_cols":11,"rows_kept":4}
["Summary For B2B(4)",{"$nulls":9},"HELP"]
["No. of Recipients","No. of Invoices",null,"Total Invoice Value",{"$nulls":5},"Total Taxable Value","Total Cess"]
[{"$f":"SUMPRODUCT((A5:A40000<>\"\")/COUNTIF(A5:A40000,A5:A40000&\"\"))","v":0},{"$f":"SUMPRODUCT((B5:B40000<>\"\")/COUNTIF(B5:B40000,B5:B40000&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(B5:B40000,B5:B40000&\"\"),D5:D40000)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"SUM(J5:J39999)","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF($F$5:$F$40000,\"N\",K5:K40000)+SUMIF($F$5:$F$40000,\"\",K5:K40000)","v":{"v":0,"d":"0.00"}}]
["GSTIN/UIN of Recipient","Invoice Number","Invoice date","Invoice Value","Place Of Supply","Reverse Charge","Invoice Type","E-Commerce GSTIN","Rate","Taxable Value","Cess Amount"]

{"sheet":"b2cl","index":2,"n_rows":4,"n_cols":8,"rows_kept":4}
["Summary For B2CL(5)",{"$nulls":6},"HELP"]
["No. of Invoices",null,"Total Inv Value",null,null,"Total Taxable Value","Total Cess"]
[{"$f":"SUMPRODUCT((A5:A40000<>\"\")/COUNTIF(A5:A40000,A5:A40000&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(A5:A40000,A5:A40000&\"\"),C5:C40000)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(F5:F40000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G5:G40000)","v":{"v":0,"d":"0.00"}}]
["Invoice Number","Invoice date","Invoice Value","Place Of Supply","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN"]

{"sheet":"b2cs","index":3,"n_rows":4,"n_cols":6,"rows_kept":4}
["Summary For B2CS(7)",{"$nulls":4},"HELP"]
[{"$nulls":3},"Total Taxable  Value","Total Cess"]
[{"$nulls":3},{"$f":"SUM(D5:D40000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E5:E40000)","v":{"v":0,"d":"0.00"}}]
["Type","Place Of Supply","Rate","Taxable Value","Cess Amount","E-Commerce GSTIN"]

{"sheet":"cdnr","index":4,"n_rows":4,"n_cols":13,"rows_kept":4}
["Summary For CDNR(9B)",{"$nulls":11},"HELP"]
["No. of Recipients","No. of Invoices",null,"No. of Notes/Vouchers",{"$nulls":4},"Total Note/Refund Voucher Value",null,"Total Taxable Value","Total Cess"]
[{"$f":"SUMPRODUCT((A5:A40001<>\"\")/COUNTIF(A5:A40001,A5:A40001&\"\"))","v":0},{"$f":"SUMPRODUCT((B5:B40001<>\"\")/COUNTIF(B5:B40001,B5:B40001&\"\"))","v":0},null,{"$f":"SUMPRODUCT((D5:D40001<>\"\")/COUNTIF(D5:D40001,D5:D40001&\"\"))","v":0},{"$nulls":4},{"$f":"SUMPRODUCT(1/COUNTIF(D5:D10001,D5:D10001&\"\"),I5:I10001)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(K5:K10000)","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(F5:F10000,\"D\",L5:L10000)-(SUMIF(F5:F10000,\"C\",L5:L10000)+SUMIF(F5:F10000,\"R\",L5:L10000))","v":{"v":0,"d":"0.00"}}]
["GSTIN/UIN of Recipient","Invoice/Advance Receipt Number","Invoice/Advance Receipt date","Note/Refund Voucher Number","Note/Refund Voucher date","Document Type","Reason For Issuing document","Place Of Supply","Note/Refund Voucher Value","Rate","Taxable Value","Cess Amount","Pre GST"]

{"sheet":"cdnur","index":5,"n_rows":4,"n_cols":13,"rows_kept":4}
["Summary For CDNUR(9B)",{"$nulls":11},"HELP"]
[null,"No. of Notes/Vouchers",null,null,"No. of Invoices",{"$nulls":3},"Total Note Value",null,"Total Taxable Value","Total Cess"]
[null,{"$f":"SUMPRODUCT((B5:B40001<>\"\")/COUNTIF(B5:B40001,B5:B40001&\"\"))","v":0},null,null,{"$f":"SUMPRODUCT((E5:E40001<>\"\")/COUNTIF(E5:E40001,E5:E40001&\"\"))","v":0},{"$nulls":3},{"$f":"SUMPRODUCT(1/COUNTIF(E5:E10001,E5:E10001&\"\"),I5:I10001)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(K5:K10000)","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(D5:D10000,\"D\",L5:L10000)-(SUMIF(D5:D10000,\"C\",L5:L10000)+SUMIF(D5:D10000,\"R\",L5:L10000))","v":{"v":0,"d":"0.00"}}]
["UR Type","Note/Refund Voucher Number","Note/Refund Voucher date","Document Type","Invoice/Advance Receipt Number","Invoice/Advance Receipt date","Reason For Issuing document","Place Of Supply","Note/Refund Voucher Value","Rate","Taxable Value","Cess Amount","Pre GST"]

{"sheet":"exp","index":6,"n_rows":4,"n_cols":9,"rows_kept":4}
["Summary For EXP(6)",{"$nulls":7},"HELP"]
[null,"No. of Invoices",null,"Total Invoice Value",null,"No. of Shipping Bill",null,null,"Total Taxable Value"]
[null,{"$f":"SUMPRODUCT((B5:B40001<>\"\")/COUNTIF(B5:B40001,B5:B40001&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(B5:B40001,B5:B40001&\"\"),D5:D40001)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUMPRODUCT((F5:F40001<>\"\")/COUNTIF(F5:F40001,F5:F40001&\"\"))","v":0},null,null,{"$f":"SUM(I5:I40000)","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"]

{"sheet":"at","index":7,"n_rows":4,"n_cols":4,"rows_kept":4}
["Summary For Advance Received (11B) ",null,null,"HELP"]
[null,null,"Total Advance Received","Total Cess"]
[null,null,{"$f":"SUM(C5:C40000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D5:D40000)","v":{"v":0,"d":"0.00"}}]
["Place Of Supply","Rate","Gross Advance Received","Cess Amount"]

{"sheet":"atadj","index":8,"n_rows":4,"n_cols":4,"rows_kept":4}
["Summary For Advance Adjusted (11B) ",null,null,"HELP"]
[null,null,"Total Advance Adjusted","Total Cess"]
[null,null,{"$f":"SUM(C5:C40000)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D5:D40000)","v":{"v":0,"d":"0.00"}}]
["Place Of Supply","Rate","Gross Advance Adjusted","Cess Amount"]

{"sheet":"exemp","index":9,"n_rows":8,"n_cols":4,"rows_kept":8}
["Summary For Nil rated, exempted and non GST outward supplies (8)",null,null,"HELP"]
[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"]
["Inter-State supplies to registered persons"]
["Intra-State supplies to registered persons"]
["Inter-State supplies to unregistered persons"]
["Intra-State supplies to unregistered persons"]

{"sheet":"hsn","index":10,"n_rows":4,"n_cols":10,"rows_kept":4}
["Summary For HSN(12)",{"$nulls":8},"HELP"]
["No. of HSN",{"$nulls":3},"Total Value","Total Taxable Value","Total Integrated Tax","Total Central Tax","Total State/UT Tax","Total Cess"]
[{"$f":"SUMPRODUCT((A5:A40001<>\"\")/COUNTIF(A5:A40001,A5:A40001&\"\"))","v":0},{"$nulls":3},{"$f":"SUM(E5:E20000)","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"}]
["HSN","Description","UQC","Total Quantity","Total Value","Taxable Value","Integrated Tax Amount","Central Tax Amount","State/UT Tax Amount","Cess Amount"]

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

{"sheet":"master","index":12,"n_rows":55,"n_cols":11,"rows_kept":55}
["UQC","Export Type","Reverse Charge/Provisional Assessment","Note Type","Type","Tax Rate","POS","Invoice Type","Reason For Issuing Note","Nature  of Document","UR Type"]
["BAG-BAG","WOPAY","N","C","OE",{"v":0,"d":"0.00"},"01-Jammu & Kashmir","Regular","01-Sales Return","Invoice for outward supply","B2CL"]
["BGS-BAGS","WPAY","Y","D","E",0.25,"02-Himachal Pradesh","SEZ supplies with payment","02-Post sale discount","Invoice for inward supply from unregistered person","EXPWP"]
["BKL-BUCKLES",null,null,"R",null,{"v":3,"d":"3.00"},"03-Punjab","SEZ supplies without payment","03-Deficiency in service","Revised Invoice","EXPWOP"]
["BOU-BOU",{"$nulls":4},{"v":5,"d":"5.00"},"04-Chandigarh","Deemed Exp","04-Correction in invoice","Debit Note"]
["BOX-BOX",{"$nulls":4},{"v":12,"d":"12.00"},"05-Uttarakhand",null,"05-Change in POS","Credit Note"]
["BTL-BOTTLES",{"$nulls":4},{"v":18,"d":"18.00"},"06-Haryana",null,"06-Finalization of Provisional assessment","Receipt Voucher"]
["BUN-BUNCHES",{"$nulls":4},{"v":28,"d":"28.00"},"07-Delhi",null,"07-Others","Payment Voucher"]
["CBM-CUBIC METER",{"$nulls":5},"08-Rajasthan",null,null,"Refund Voucher"]
["CCM-CUBIC CENTIMETER",{"$nulls":5},"09-Uttar Pradesh",null,null,"Delivery Challan for job work"]
["CIN-CUBIC INCHES",{"$nulls":5},"10-Bihar",null,null,"Delivery Challan for supply on approval"]
["CMS-CENTIMETER",{"$nulls":5},"11-Sikkim",null,null,"Delivery Challan in case of liquid gas"]
["CQM-CUBIC METERS",{"$nulls":5},"12-Arunachal Pradesh",null,null,"Delivery Challan in case other than by way of supply (excluding at S no. 9 to 11)"]
["CTN-CARTON",{"$nulls":5},"13-Nagaland"]
["DOZ-DOZEN",{"$nulls":5},"14-Manipur"]
["DRM-DRUM",{"$nulls":5},"15-Mizoram"]
["FTS-FEET",{"$nulls":5},"16-Tripura"]
["GGR-GREAT GROSS",{"$nulls":5},"17-Meghalaya"]
["GMS-GRAMS",{"$nulls":5},"18-Assam"]
["GRS-GROSS",{"$nulls":5},"19-West Bengal"]
["GYD-GROSS YARDS",{"$nulls":5},"20-Jharkhand"]
["HKS-HANKS",{"$nulls":5},"21-Odisha"]
["INC-INCHES",{"$nulls":5},"22-Chhattisgarh"]
["KGS-Kilograms",{"$nulls":5},"23-Madhya Pradesh"]
["KLR-KILOLITER",{"$nulls":5},"24-Gujarat"]
["KME-KILOMETERS",{"$nulls":5},"25-Daman & Diu"]
["LBS-POUNDS",{"$nulls":5},"26-Dadra & Nagar Haveli"]
["LOT-LOTS",{"$nulls":5},"27-Maharashtra"]
["LTR-LITERS",{"$nulls":5},"29-Karnataka"]
["MGS-MILLI GRAMS",{"$nulls":5},"30-Goa"]
["MTR-METER",{"$nulls":5},"31-Lakshdweep"]
["MTS-METRIC TON",{"$nulls":5},"32-Kerala"]
["NOS-Numbers",{"$nulls":5},"33-Tamil Nadu"]
["ODD-ODDS",{"$nulls":5},"34-Pondicherry"]
["PAC-PACKS",{"$nulls":5},"35-Andaman & Nicobar Islands"]
["PCS-Pieces",{"$nulls":5},"36-Telengana"]
["PRS-PAIRS",{"$nulls":5},"37-Andhra Pradesh"]
["QTL-QUINTAL",{"$nulls":5},"97-Other Territory"]
["ROL-ROLLS"]
["SDM-DECAMETER SQUARE"]
["SET-SETS"]
["SHT-SHEETS"]
["SQF-SQUARE FEET"]
["SQI-SQUARE INCHES"]
["SQM-SQUARE METER"]
["SQY-SQUARE YARDS"]
["TBS-TABLETS"]
["THD-THOUSANDS"]
["TOL-TOLA"]
["TON-GREAT BRITAIN TON"]
["TUB-TUBES"]
["UGS-US GALLONS"]
["UNT-UNITS"]
["VLS-Vials"]
["YDS-YARDS"]