{"text_format":"5","workbook":"xlsx","n_sheets":13,"sheets":["instruction","b2b","b2bur","imps","impg","cdnr","cdnur","at","atadj","exemp","itcr","hsnsum","master"],"props":{"last_modified_by":"E L I T E"},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"instruction","index":0,"n_rows":189,"n_cols":4,"rows_kept":189,"merged":[[0,0,0,9],[2,0,2,9],[3,0,3,2],[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[13,0,13,9],[14,3,14,9],[15,0,33,0],[15,1,33,1],[15,2,15,9],[16,3,16,9],[17,3,17,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[21,3,21,9],[22,3,22,9],[23,3,23,9],[24,3,24,9],[25,3,25,9],[26,3,26,9],[27,3,27,9],[28,3,28,9],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[33,3,33,9],[34,0,51,0],[34,1,51,1],[34,2,34,9],[35,3,35,9],[36,3,36,9],[37,3,37,9],[38,3,38,9],[39,3,39,9],[40,3,40,9],[41,3,41,9],[42,3,42,9],[43,3,43,9],[44,3,44,9],[45,3,45,9],[46,3,46,9],[47,3,47,9],[48,3,48,9],[49,3,49,9],[50,3,50,9],[51,3,51,9],[52,0,63,0],[52,1,63,1],[52,2,52,9],[53,3,53,9],[54,3,54,9],[55,3,55,9],[56,3,56,9],[57,3,57,9],[58,3,58,9],[59,3,59,9],[60,3,60,9],[61,3,61,9],[62,3,62,9],[63,3,63,9],[64,0,77,0],[64,1,77,1],[64,2,64,9],[65,3,65,9],[66,3,66,9],[67,3,67,9],[68,3,68,9],[69,3,69,9],[70,3,70,9],[71,3,71,9],[72,3,72,9],[73,3,73,9],[74,3,74,9],[75,3,75,9],[76,3,76,9],[77,3,77,9],[78,0,99,0],[78,1,99,1],[78,2,78,9],[79,3,79,9],[80,3,80,9],[81,3,81,9],[82,3,82,9],[83,3,83,9],[84,3,84,9],[85,3,85,9],[86,3,86,9],[87,3,87,9],[88,3,88,9],[89,3,89,9],[90,3,90,9],[91,3,91,9],[92,3,92,9],[93,3,93,9],[94,3,94,9],[95,3,95,9],[96,3,96,9],[97,3,97,9],[98,3,98,9],[99,3,99,9],[100,0,120,0],[100,1,120,1],[100,2,100,9],[101,3,101,9],[102,3,102,9],[103,3,103,9],[104,3,104,9],[105,3,105,9],[106,3,106,9],[107,3,107,9],[108,3,108,9],[109,3,109,9],[110,3,110,9],[111,3,111,9],[112,3,112,9],[113,3,113,9],[114,3,114,9],[115,3,115,9],[116,3,116,9],[117,3,117,9],[118,3,118,9],[119,3,119,9],[120,3,120,9],[121,0,125,0],[121,1,125,1],[121,2,121,9],[122,3,122,9],[123,3,123,9],[124,3,124,9],[125,3,125,9],[126,0,130,0],[126,1,130,1],[126,2,126,9],[127,3,127,9],[128,3,128,9],[129,3,129,9],[130,3,130,9],[131,0,136,0],[131,1,136,1],[131,2,131,9],[132,3,132,9],[133,3,133,9],[134,3,134,9],[135,3,135,9],[136,3,136,9],[137,0,140,0],[137,1,140,1],[137,3,137,9],[138,3,138,9],[139,3,139,9],[140,3,140,9],[141,0,151,0],[141,1,151,1],[141,2,141,9],[142,3,142,9],[143,3,143,9],[144,3,144,9],[145,3,145,9],[146,3,146,9],[147,3,147,9],[148,3,148,9],[149,3,149,9],[150,3,150,9],[151,3,151,9],[153,0,153,9],[154,0,154,9],[155,0,155,9],[156,0,156,9],[157,0,157,9],[158,0,158,9],[159,0,159,9],[161,0,161,9],[162,0,162,9],[163,0,163,9],[164,0,164,9],[165,0,165,9],[166,0,166,9],[167,0,167,9],[168,0,168,9],[169,0,169,9],[170,0,170,9],[171,0,171,9],[172,0,172,9],[173,0,173,9],[174,0,174,9],[175,0,175,9]]}
["Invoice & other  data  upload for creation of GSTR 2"]
["Introduction to Excel based template for data upload in Java offline  tool"]
["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, b2bur, imps, impg, cdnr, cdnur, at, atadj, exemp,itcr and hsnsum  in which day-to-day business transaction required to be reported in GSTR 2 can be recorded or entered by the taxpayers.  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 after the due date of filing of GSTR 1.. (www.gst.gov.in)   \ns  It  has been designed to enable taxpayers to prepare the details of missing invoices in  sections related to supplies from registered taxpayers and other sections of GSTR 2  in  offline mode (without Internet). It can also be used to carry out bulk upload of missing invoice/other details to GST portal.   \n* The autopopulated invoice details downloaded after the due date from the registered suppliers who have filed their GSTR 1 have to be opened in the java offline tool  with the enabled buttons of accept/reject. The details can also be modified. One can also choose not to take any action.  \ns  The appearance and functionalities of the Offline  tool screens are similar to that  of the returns filing  screens on the GST Portal.\ns  The number of invoice line items that can be uploaded  after taking action and declaring the credit eligibilities has to be such that the file size of file to be uploaded is not more than 5 MB.  \n\nData of missing invoices and other self declared dat of GSTR 2 can be uploaded/entered to the offline tool in four ways:\n\n1.  Importing the entire excel workbook to the java offline 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."]
[]
["Understanding the Excel  Workbook Template"]
["a) It is always recommended to download the excel workbook template from the GST portal only."]
["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. "]
["c) The data in the excel file should be in the format specified below in respective sections."]
["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."]
["e) For Group import (all worksheets of workbook) taxpayer need to fill all the details into downloaded standard format GSTR2_Excel_Workbook_Template-V1.0.xlsx file"]
["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."]
["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.  "]
[]
["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."]
["Worksheet Name","Reference","Field name","Help Instruction"]
["b2b","B2B Supplies","Details of invoices of Taxable supplies received  from other registered taxpayers\n\n\n\n\n"]
[null,null,"1. GSTIN of Supplier*","Enter the GSTIN of the supplier . E.g. 05AEJPP8087R1ZF. Check that the registration is active on the date of the invoice from GST portal"]
[null,null,"2. 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."]
[null,null,"3. Invoice Date* ","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"4. Invoice value*","Enter the total value indicated in the invoice  of the received goods or services- with 2 decimal Digits."]
[null,null,"5. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[null,null,"6. Reverse Charge*","Please select Y or N , if the supplies/services are subject to tax as per reverse charge mechanism."]
[null,null,"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."]
[null,null,"8. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax, as applicable."]
[null,null,"9. 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. "]
[null,null,"10. Integrated Tax Paid","Enter Integrated Tax Paid "]
[null,null,"11. Central Tax Paid","Enter Central Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"12. State/UT Tax","Enter State/UT Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"13. Cess Paid","Enter the total Cess amount paid."]
[null,null,"14. Eligibility For ITC*","Select from the dropdown input, input services, capital goods or ineligible to  declare the supplies type for ITC eligible goods or services "]
[null,null,"15. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"16. Availed ITC Central Tax","Enter the Amount of ITC available for Central Tax paid"]
[null,null,"17. Availed ITC State/UT Tax","Enter the Amount of ITC available for State/UT Tax paid"]
[null,null,"18. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["b2bur","B2BUR\n Inward supplies from unregistered Supplier","Inward supplies received from an unregistered supplier "]
[null,null,"1. Supplier Name*","Enter the name of supplier from whom supplies have been received "]
[null,null,"2. 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."]
[null,null,"3. Invoice Date*","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"4. Invoice value*","Enter the total value indicated in the invoice  of the received  goods or services- with 2 decimal Digits."]
[null,null,"5. Place of Supply(POS)*","Select the code of the state from drop down list for the applicable place of supply."]
[null,null,"6. Supply Type*","Select from drop down to declare the supply type as inter state or intra state"]
[null,null,"7. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate, as applicable."]
[null,null,"8. Taxable Value*","Enter the taxable value of the received  goods or services for each rate line item -2 decimal digits, The taxable value has to be computed as per GST valuation provisions. "]
[null,null,"9. Integrated Tax Paid","Enter Integrated Tax Paid "]
[null,null,"10. Central Tax Paid","Enter Central Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"11. State/UT Tax","Enter State/UT Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"12. Cess Paid","Enter the total  Cess amount payable"]
[null,null,"13. Eligibility For ITC*","Select from the dropdown input, input services, capital goods or ineligible to  declare the supplies type for ITC eligible goods or services "]
[null,null,"14. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"15. Availed ITC Central Tax","Enter the Amount of ITC available for Central Tax paid"]
[null,null,"16. Availed ITC State/UT Tax","Enter the Amount of ITC available for State/UT Tax paid"]
[null,null,"17. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["imps","IMPS \nImport of Services ","Import of Service "]
[null,null,"1. 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."]
[null,null,"2. Invoice Date* ","Enter date of invoice in DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"3. Invoice value*","Enter the total value indicated in the invoice  of the received services- with 2 decimal Digits."]
[null,null,"4. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[null,null,"5. Rate*","Enter the integrated tax rate , as applicable."]
[null,null,"6. 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. "]
[null,null,"7. Integrated Tax Paid*","Enter Integrated Tax Paid "]
[null,null,"8. Cess Paid","Enter the total Cess amount paid."]
[null,null,"9. Eligibility For ITC*","Select from the dropdown input services to  declare the supplies as ITC eligible"]
[null,null,"10. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"11. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["impg","IMPG\nImport of Goods ","Import of Inputs/Capital goods from Overseas/SEZ "]
[null,null,"1. Port Code*","Enter the six digit code of port through which goods were imported. Please refer to the list of port codes available on the GST common portal."]
[null,null,"2. Bill Of Entry Number*","Enter the 7 digit Bill of entry"]
[null,null,"3. Bill Of Entry Date*","Enter Bill of Entry date in DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"4. Bill Of Entry Value*","Enter the total value of Bill of Entry "]
[null,null,"5. Document type*","Select from the drop down to declare supplies as imports or SEZ supplies  "]
[null,null,"6. GSTIN Of Supplier*","Enter the GSTIN of the supplier . E.g. 05AEJPP8087R1ZF in case the supplies are received from SEZ. Check that the registration is active on the date of the invoice from GST portal"]
[null,null,"7. Rate*","Enter the integrated tax rate, as applicable."]
[null,null,"8. Taxable Value*","Enter the taxable value of the received  inputs/capital good  for each rate line item - with 2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[null,null,"9. Integrated Tax Paid*","Enter Integrated Tax Paid "]
[null,null,"10. Cess Paid","Enter the total Cess amount paid."]
[null,null,"11. Eligibility For ITC*","Select from the dropdown input/capital goods to  declare the supplies as ITC eligible"]
[null,null,"12. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"13. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["cdnr","Credit/ Debit Note","Enter Credit/ Debit Notes/Refund vouchers issued by the registered supplier during the tax period but not added by him in his GSTR-1. 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  earlier/current period tax period."]
[null,null,"1. GSTIN of Supplier*","Enter the GSTIN of the supplier . E.g. 05AEJPP8087R1ZF. "]
[null,null,"2. Invoice/Advance Payment 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. "]
[null,null,"3. Invoice/Advance Payment date*","Enter credit/debit note/Refund voucher date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"4. Invoice/Advance Payment Voucher 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. "]
[null,null,"5. Invoice/Advance Payment Voucher date","Enter the original invoice/advance voucher date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"6. Pre GST","Select whether the credit/debit note is related to pre-GST supplies."]
[null,null,"7. 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."]
[null,null,"8. Reason For Issuing document*","Select the applicable reason for issue of the document."]
[null,null,"9. Supply Type","Declare the type of supply as inter or intra. This would be validated with original invoice upon upload to portal."]
[null,null,"10. Note/Refund Voucher value*","Amount should be with only up to 2 decimal digits."]
[null,null,"11. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax."]
[null,null,"12.Taxable value*","Enter the taxable value of the received  goods or services for each rate line item -2 decimal Digits, The taxable value has to be computed as per GST valuation provisions. "]
[null,null,"13. Integrated Tax Paid","Enter Integrated Tax Paid "]
[null,null,"14. Central Tax Paid","Enter Central Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"15. State/UT Tax","Enter State/UT Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"16. Cess Paid","Enter the total  Cess amount."]
[null,null,"17. Eligibility For ITC*","Select from the dropdown input, input services, capital goods or ineligible to  declare the supplies type for ITC eligible goods or services "]
[null,null,"18. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"19. Availed ITC Central Tax","Enter the Amount of ITC available for Central Tax paid"]
[null,null,"20. Availed ITC State/UT Tax","Enter the Amount of ITC available for State/UT Tax paid"]
[null,null,"21. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["cdnur","Credit/ Debit Note for unregistered Persons","Credit/ Debit Notes/Refund vouchers issued to the unregistered supplier "]
[null,null,"1. Note/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."]
[null,null,"2. Note/ Voucher date*","Enter credit/debit note/Refund voucher date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"3. Invoice/Advance Payment Voucher 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."]
[null,null,"4. Invoice/Advance Payment Voucher date*","Enter the original invoice/advance receipt date in  DD-MMM-YYYY. E.g. 24-May-2017."]
[null,null,"5. Pre GST","Select whether the credit/debit note is related to pre-GST supplies."]
[null,null,"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."]
[null,null,"7. Reason For Issuing document*","Select the applicable reason for issue of the document from the dropdown."]
[null,null,"8. Supply Type","Declare the type of supply as inter or intra. This would be validated with original invoice upon upload to portal."]
[null,null,"9. Note/Refund Voucher value*","Amount should be up to 2 decimal digits."]
[null,null,"10. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate. "]
[null,null,"11.Taxable value","Enter the taxable value of the received  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,null,"12. Integrated Tax Paid","Enter Integrated Tax Paid "]
[null,null,"13. Central Tax Paid","Enter Central Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"14. State/UT Tax","Enter State/UT Tax Paid ; not applicable if Integrated Tax is paid "]
[null,null,"15. Cess Paid","Enter the total  Cess amount."]
[null,null,"16. Eligibility For ITC*","Select from the dropdown input, input services, capital goods or ineligible to  declare the supplies type for ITC eligible goods or services "]
[null,null,"17. Availed ITC Integrated Tax","Enter the Amount of ITC available for Integrated Tax paid"]
[null,null,"18. Availed ITC Central Tax","Enter the Amount of ITC available for Central Tax paid"]
[null,null,"19. Availed ITC State/UT Tax","Enter the Amount of ITC available for State/UT Tax paid"]
[null,null,"20. Availed ITC Cess","Enter the Amount of ITC available for Cess paid"]
["at","Tax liability on advances","Advance amount Paid for reverse charge supplies in the tax period "]
[null,null,"1. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[null,null,"2. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[null,null,"3. Gross advance received*","Enter the amount of advance received excluding the tax portion."]
[null,null,"4. Cess Amount","Enter the total  Cess amount collected/payable."]
["atadj","Advance adjustments","Adjustment of tax already paid  on advance receipt of consideration and invoices issued in the current period for the supplies attracting reverse charge"]
[null,null,"1. Place of Supply(POS)*","Select the code of the state from drop down list for the place of supply."]
[null,null,"2. Rate*","Enter the combined  (State tax + Central tax) or the integrated tax rate."]
[null,null,"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"]
[null,null,"4. Cess Amount","Enter the total  Cess amount to be adjusted"]
["exempt","Supplies from Composition taxable person, Nil Rated, Exempted and Non GST supplies received ","Details of supplies received from composition taxable person and other Nil Rated, Exempted and Non GST Supplies received"]
[null,null,"1. Description","Indicates the type of supply. "]
[null,null,"1. Composition Taxable person","Declare the value of supplies received from composition taxable person. Supplies from composition taxable person can be only intrastate"]
[null,null,"2.Nil rated supplies","Declare the value of supplies received under the \"Nil rated\" category for the tax period"]
[null,null,"3.Exempted\n(Other than Nil rated/non-GST\nsupply)","Declare the value of supplies received  under the \"Exempted \"category for the tax period"]
[null,null,"4.Non GST Supplies","Declare the value of supplies received under the \"Non GST\" category for the tax period"]
["itcr","Input tax Credit Reversal/Reclaim","ITC Integrated Tax Amount","Enter the amount of ITC Integrated Tax amount as per applicable category"]
[null,null,"ITC Central Tax Amount","Enter the amount of ITC Central Tax amount as per applicable category"]
[null,null,"ITC State/UT Tax Amount","Enter the amount of ITC State/UT Tax amount as per applicable category"]
[null,null,"ITC Cess Amount","Enter the amount of ITC Cess amount as per applicable category"]
["hsnsum","HSN Summary","HSN wise summary of goods /services received during the tax period"]
[null,null,"1. HSN*","Enter the HSN Code  for the received 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"]
[null,null,"2. Description*","Enter the description of the received goods or Services. Description becomes a mandatory field if HSN code is not provided above."]
[null,null,"3. UQC*","Select the applicable Unit Quantity Code  from the drop down."]
[null,null,"4. Total Quantity*","Enter the total quantity of the received goods or Services- up to 2 decimal Digits."]
[null,null,"5. Total Value*","Enter the invoice  value of the goods or services-up to 2 decimal Digits."]
[null,null,"6. Taxable Value*","Enter the total taxable value of the received goods or services- up to 2 decimal Digits."]
[null,null,"7. Integrated Tax Amount","Enter the total  Integrated tax amount payable."]
[null,null,"8. Central Tax Amount","Enter the total  Central tax amount payable"]
[null,null,"9. State/UT Tax Amount","Enter the total State/UT tax amount payable"]
[null,null,"10. Cess Amount","Enter the total  Cess amount payable"]
[]
["Common mistakes in filling Excel template"]
["1. 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. "]
["2. Amount should be only up to  2 decimal digits"]
["3  Ensure that filling of excel should be strictly as per sample data to avoid errors. "]
["4. Copy  paste data from the excel template not including the header rows 1 to 4 will throw an error. "]
["5. 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. "]
["6. 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."]
[]
["Special Instructions"]
["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\"."]
["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"]
["3) Taxable Value, Rate and cess amount as applicable to the line items may be different in the same invoice."]
["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"]
["5) 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."]
["6 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. "]
["7) The worksheets have some data as example. Please delete the data from all worksheets before use. "]
["8) 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 2 format. For example in b2b worksheet \"Summary For B2B(3)\" here \"3\" refers to the table number 4 of GSTR 1 format."]
["10) This excel workbook template works best with Microsoft Excel 2007 and above. "]
["11) Ensure that there are no stray entries in any cell of the sheets other than return related declaration under the indicated column headers."]
["12) 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. "]
["13)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.  "]
["14) 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. "]
["15) 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. "]
[]
[]
["Term/ Acronym","Description"]
["GSTIN","Goods and Services Taxpayer Identification Number"]
["GSTN","Goods and Services Tax Network"]
["HSN","Harmonized System of Nomenclature"]
["B2B","Registered Business to Registered Business"]
["B2C","Registered Business to Unregistered Consumer"]
["POS","Place of Supply of Goods or Services – State code to be mentioned"]
["UIN","Unique Identity Number"]
["GSTR2","GST Return 2"]
["GST","Goods and Services Tax"]
["UQC","Unit Quantity Code"]

{"sheet":"b2b","index":1,"n_rows":4,"n_cols":18,"rows_kept":4,"merged":[[0,0,0,1],[0,2,0,16]]}
["Summary Of Supplies From Registered Suppliers B2B(3)",null,"3,4A- Inward Supplies receieved from Registerd person including reverse charge supplies",{"$nulls":14},"HELP"]
["NO. OF SUPPLIERS","NO. OF INVOICES",null,"TOTAL INVOICE VALUE",{"$nulls":4},"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CENTRAL TAX PAID","TOTAL TSTATE/UT TAX PAID","TOTAL CESS",null,"TOTAL AVAILED ITC INTEGRATED TAX  ","TOTAL AVAILED ITC CENTRAL TAX","TOTAL AVAILED ITC STATE/UT TAX ","TOTAL AVAILED ITC CESS"]
[{"$f":"SUMPRODUCT((A5:A19988<>\"\")/COUNTIF(A5:A19988,A5:A19988&\"\"))","v":0},{"$f":"SUMPRODUCT((B5:B19988<>\"\")/COUNTIF(B5:B19988,B5:B19988&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(B5:B19988,B5:B19988&\"\"),D5:D19988)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"SUM(I5:I19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J5:J19993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K19993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L19993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M5:M19988)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O5:O19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(P5:P19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Q5:Q19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(R5:R19988)","v":{"v":0,"d":"0.00"}}]
["GSTIN OF SUPPLIER","INVOICE NUMBER","INVOICE DATE","INVOICE VALUE","PLACE OF SUPPLY","REVERSE CHARGE","INVOICE TYPE","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CENTRAL TAX PAID","STATE OR UT TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CENTRAL TAX","AVAILED ITC STATE/UT TAX","CESS ITC AMOUNT"]

{"sheet":"b2bur","index":2,"n_rows":4,"n_cols":17,"rows_kept":4,"merged":[[0,0,0,2],[0,3,0,15]]}
["Summary Of Supplies From Unregistered Suppliers B2BUR(4B)",null,null,"4B- Inward Supplies receieved from Unregisterd supplies",{"$nulls":12},"HELP"]
[null,"NO. OF INVOICES (OF REG RECIPIENT)",null,"TOTAL INVOICE VALUE",{"$nulls":3},"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CENTRAL TAX PAID","TOTAL TSTATE/UT TAX PAID","TOTAL CESS PAID",null,"TOTAL AVAILED ITC INTEGRATED TAX  ","TOTAL AVAILED ITC CENTRAL TAX","TOTAL AVAILED ITC STATE/UT TAX ","TOTAL AVAILED ITC CESS"]
[null,0,null,{"$f":"SUMPRODUCT(1/COUNTIF(B5:B19988,B5:B19988&\"\"),D5:D19988)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"SUMPRODUCT(1/COUNTIF(F5:F19988,F5:F19988&\"\"),H5:H19988)","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"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["SUPPLIER NAME","INVOICE NUMBER","INVOICE DATE","INVOICE VALUE","PLACE OF SUPPLY","SUPPLY TYPE","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CENTRAL TAX PAID","STATE OR UT TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CENTRAL TAX","AVAILED ITC STATE/UT TAX","AVAILED ITC CESS"]

{"sheet":"imps","index":3,"n_rows":4,"n_cols":11,"rows_kept":4,"merged":[[0,0,0,2],[0,3,0,9]]}
["Summary For IMPS (4C)",null,null,"4C- Import of Service",{"$nulls":6},"HELP"]
["NO. OF INVOICES (OF REG RECIPIENT)",null,"TOTAL INVOICE VALUE",null,null,"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CESS PAID",null,"TOTAL AVAILED ITC INTEGRATED TAX  ","TOTAL AVAILED ITC CESS"]
[{"$f":"SUMPRODUCT((A5:A19988<>\"\")/COUNTIF(A5:A19988,A5:A19988&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(A5:A19988,A5:A19988&\"\"),C5:C19988)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUMPRODUCT(1/COUNTIF(D5:D19988,D5:D19988&\"\"),F5:F19988)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["INVOICE NUMBER OF REG RECIPIENT","INVOICE DATE","INVOICE VALUE","PLACE OF SUPPLY","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CESS TAX"]

{"sheet":"impg","index":4,"n_rows":4,"n_cols":13,"rows_kept":4,"merged":[[0,0,0,2],[0,3,0,11]]}
["Summary For IMPG (5)",null,null,"5- Import of Inputs/Capital goods and Supplies received from SEZ",{"$nulls":8},"HELP"]
[null,"NO. OF  BILL OF ENTRY",null,"TOTAL BILL OF ENTRY VALUE",{"$nulls":3},"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CESS PAID",null,"TOTAL AVAILED ITC INTEGRATED TAX  ","TOTAL AVAILED ITC CESS"]
[null,{"$f":"SUMPRODUCT((B5:B19988<>\"\")/COUNTIF(B5:B19988,B5:B19988&\"\"))","v":0},null,{"$f":"SUMPRODUCT(1/COUNTIF(B5:B19988,B5:B19988&\"\"),D5:D19988)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"SUMPRODUCT(1/COUNTIF(F5:F19988,F5:F19988&\"\"),H5:H19988)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["PORT CODE","BILL OF ENTRY NUMBER","BILL OF ENTRY DATE","BILL OF ENTRY VALUE","DOCUMENT TYPE","GSTIN OF SEZ SUPPLIER","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CESS TAX"]

{"sheet":"cdnr","index":5,"n_rows":4,"n_cols":21,"rows_kept":4,"merged":[[0,0,0,1],[0,2,0,19]]}
["Summary For CDNR(6C)",null,"6C- Debit/Credit Notes for supplies from Registered Person ",{"$nulls":17},"HELP"]
["NO. OF SUPPLIER","NO. OF NOTES/VOUCHERS",null,"NO. OF INVOICES",{"$nulls":5},"TOTAL NOTE/VOUCHER VALUE",null,"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CENTRAL TAX PAID","TOTAL TSTATE/UT TAX PAID","TOTAL CESS",null,"TOTAL AVAILED ITC INTEGRATED TAX  ","TOTAL AVAILED ITC CENTRAL TAX","TOTAL AVAILED ITC STATE/UT TAX ","TOTAL AVAILED ITC CESS"]
[{"$f":"SUMPRODUCT((A5:A9991<>\"\")/COUNTIF(A5:A9991,A5:A9991&\"\"))","v":0},{"$f":"SUMPRODUCT((B5:B19988<>\"\")/COUNTIF(B5:B19988,B5:B19988&\"\"))","v":0},null,{"$f":"SUMPRODUCT((D5:D19988<>\"\")/COUNTIF(D5:D19988,D5:D19988&\"\"))","v":0},{"$nulls":5},{"$f":"SUMPRODUCT(1/COUNTIF(H5:H19988,H5:H19988&\"\"),J5:J19988)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L5:L9991)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(N5:N9991)","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"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["GSTIN OF SUPPLIER","NOTE/REFUND VOUCHER NUMBER","NOTE/REFUND VOUCHER DATE","INVOICE/ADVANCE PAYMENT VOUCHER NUMBER","INVOICE/ADVANCE PAYMENT VOUCHER DATE","PRE GST","DOCUMENT TYPE","REASON FOR ISSUING DOCUMENT","SUPPLY TYPE","NOTE/REFUND VOUCHER VALUE","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CENTRAL TAX PAID","STATE OR UT TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CENTRAL TAX","AVAILED ITC STATE/UT TAX","AVAILED ITC CESS"]

{"sheet":"cdnur","index":6,"n_rows":4,"n_cols":20,"rows_kept":4,"merged":[[0,0,0,3],[0,4,0,19]]}
["Summary For CDNUR(6C)",{"$nulls":3},"6C- Debit/Credit Notes for supplies for Unregistered Person "]
["NO OF NOTES/VOUCHERS",null,"NO. OF INVOICES",{"$nulls":5},"TOTAL NOTE/REFUND VOUCHER VALUE",null,"TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX PAID","TOTAL CENTRAL TAX PAID","TOTAL STATE/UT TAX PAID","TOTAL CESS PAID",null,"TOTAL ITC INTEGRATED TAX AMOUNT  ","TOTAL CENTRAL TAX AMOUNT","TOTAL ITC STATE/UT TAX AMOUNT","TOTAL ITC CESS AMOUNT"]
[{"$f":"SUMPRODUCT((A5:A9993<>\"\")/COUNTIF(A5:A9993,A5:A9993&\"\"))","v":0},null,{"$f":"SUMPRODUCT((C5:C9993<>\"\")/COUNTIF(C5:C9993,C5:C9993&\"\"))","v":0},{"$nulls":5},{"$f":"SUMPRODUCT(1/COUNTIF(G5:G19988,G5:G19988&\"\"),I5:I19988)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUMPRODUCT(1/COUNTIF(I5:I19988,I5:I19988&\"\"),K5:K19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L5:L9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M5:M9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(N5:N9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(O5:O9993)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(Q5:Q9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(R5:R9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(S5:S9993)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(T5:T9993)","v":{"v":0,"d":"0.00"}}]
["NOTE/VOUCHER NUMBER","NOTE/VOUCHER DATE","INVOICE/ADVANCE PAYMENT VOUCHER NUMBER","INVOICE/ADVANCE PAYMENT VOUCHER DATE","PRE GST","DOCUMENT TYPE","REASON FOR ISSUING DOCUMENT","SUPPLY TYPE","NOTE/VOUCHER VALUE","TAX RATE (%)","TAXABLE VALUE","INTEGRATED TAX PAID","CENTRAL TAX PAID","STATE OR UT TAX PAID","CESS PAID","ELIGIBILITY FOR ITC","AVAILED ITC INTEGRATED TAX","AVAILED ITC CENTRAL TAX","STATE OR UT ITC AMOUNT","CESS ITC AMOUNT"]

{"sheet":"at","index":7,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[0,0,0,3]]}
["Summary For  Tax Liability on Advance Paid  under reverse charge(10 A 10A- Advance amount paid for reverse charge supplies )"]
[null,null,"TOTAL ADVANCE PAID","TOTAL CESS AMOUNT"]
[null,null,{"$f":"SUMPRODUCT(1/COUNTIF(A5:A19988,A5:A19988&\"\"),C5:C19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(1/COUNTIF(B5:B19988,B5:B19988&\"\"),D5:D19988)","v":{"v":0,"d":"0.00"}}]
["PLACE OF SUPPLY","TAX RATE (%)","GROSS ADVANCE PAID","CESS AMOUNT"]

{"sheet":"atadj","index":8,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[0,0,0,3]]}
["Summary For  Tax Adjustment of Advance Paid  earlier for reverse charge supplies (10B- Adjustment of advance amount paid earlier for reverse charge supplies)"]
[null,null,"TOTAL ADVANCE ADJUSTED","TOTAL CESS ADJUSTED"]
[null,null,{"$f":"SUMPRODUCT(1/COUNTIF(A5:A19988,A5:A19988&\"\"),C5:C19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(1/COUNTIF(B5:B19988,B5:B19988&\"\"),D5:D19988)","v":{"v":0,"d":"0.00"}}]
["PLACE OF SUPPLY","TAX RATE (%)","GROSS ADVANCE PAID TO BE ADJUSTED","CESS TO BE ADJUSTED"]

{"sheet":"exemp","index":9,"n_rows":6,"n_cols":5,"rows_kept":6,"merged":[[0,0,0,4]]}
["Summary For Composition, Nil rated, exempted and non GST inward supplies (7)"]
[null,"TOTAL COMPOSITION TAXABLE PERSON","TOTAL NIL RATED SUPPLIES","TOTAL EXEMPTED SUPPLIES","TOTAL NON-GST SUPPLIES"]
[null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["SUPPLY TYPE","COMPOSITION TAXABLE PERSON","NIL RATED SUPPLIES","EXEMPTED (OTHER THAN NIL RATED/NON GST SUPPLY )","NON-GST SUPPLIES"]
["Inter-State supplies"]
["Inter-State supplies"]

{"sheet":"itcr","index":10,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,5]]}
["Summary ","Input Tax credit Reversal/Reclaim (11)"]
[null,null,"TOTAL ITC INTEGRATED TAX AMOUNT","TOTAL CENTRAL TAX AMOUNT","TOTAL ITC STATE/UT TAX AMOUNT","TOTAL ITC CESS AMOUNT"]
[null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["DESCRIPTION FOR REVERSAL OF ITC (RULE)","TO BE ADDED OR REDUCED FROM OUTPUT LIABILITY","ITC INTEGRATED TAX AMOUNT","ITC CENTRAL TAX AMOUNT","ITC STATE/UT TAX AMOUNT","ITC CESS AMOUNT"]
["(a) Amount in terms of rule 37 (2)"]
["(b) Amount in terms of rule 42 (1) (m)"]
["(c) Amount in terms of rule 43(1) (h)"]
["(d) Amount in terms of rule 42 (2)(a)"]
["(e) Amount in terms of rule 42(2)(b)"]
["(f) On account of amount paid subsequent to reversal of ITC"]
["(g) Any other liability (Specify)"]

{"sheet":"hsnsum","index":11,"n_rows":4,"n_cols":10,"rows_kept":4,"merged":[[0,0,0,2],[0,3,0,9]]}
["Summary For HSN/SAC(13)",null,null,"13- HSN summery of Inward Supplies"]
["NO. OF HSN",{"$nulls":3},"TOTAL VALUE","TOTAL TAXABLE VALUE","TOTAL INTEGRATED TAX","TOTAL CENTRAL TAX","TOTAL STATE/UT TAX","TOTAL CESS"]
[0,{"$nulls":3},{"$f":"SUMPRODUCT(1/COUNTIF(C5:C19988,C5:C19988&\"\"),E5:E19988)","v":{"v":0,"d":"0.00"}},{"$f":"SUMPRODUCT(1/COUNTIF(D5:D19988,D5:D19988&\"\"),F5:F19988)","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"}]
["HSN","DESCRIPTION","UQC","TOTAL QUANTITY","TOTAL VALUE","TAXABLE VALUE","INTEGRATED TAX AMOUNT","CENTRAL TAX AMOUNT","STATE/UT TAX AMOUNT","CESS AMOUNT"]

{"sheet":"master","index":12,"n_rows":38,"n_cols":6,"rows_kept":38}
["POS","Invoice Type","Reason For Issuing Note","ITC Eligibility","Document Type Inputs received from Overseas or from SEZ","Supply Type "]
["01-Jammu & Kashmir","Regular","01-Sales Return","Inputs","Imports","Inter State"]
["02-Himachal Pradesh","SEZ supplies with payment","02-Post Sale Discount","Capital goods","Received from SEZ","Intra State"]
["03-Punjab","SEZ supplies without payment","03-Deficiency in services","Input services"]
["04-Chandigarh","Deemed Exp","04-Correction in Invoice","Ineligible"]
["05-Uttarakhand",null,"05-Change in POS"]
["06-Haryana",null,"06-Finalization of Provisional assessment"]
["07-Delhi",null,"07-Others"]
["08-Rajasthan",null,null,"Input services"]
["09-Uttar Pradesh",null,null,"Ineligible"]
["10-Bihar"]
["11-Sikkim",null,null,"Inputs"]
["12-Arunachal Pradesh",null,null,"Capital goods"]
["13-Nagaland",null,null,"Ineligible"]
["14-Manipur"]
["15-Mizoram"]
["16-Tripura"]
["17-Meghalaya"]
["18-Assam"]
["19-West Bengal"]
["20-Jharkhand"]
["21-Odisha"]
["22-Chhattisgarh"]
["23-Madhya Pradesh"]
["24-Gujarat"]
["25-Daman & Diu"]
["26-Dadra & Nagar Haveli"]
["27-Maharashtra"]
["29-Karnataka"]
["30-Goa"]
["31-Lakshdweep"]
["32-Kerala"]
["33-Tamil Nadu"]
["34-Pondicherry"]
["35-Andaman & Nicobar Islands"]
["36-Telangana"]
["37-Andhra Pradesh"]
["97-Other Territory"]