{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instruction Sheet","Home","Table 4","Table 5A","Table 5B","Table 5C","master"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruction Sheet","index":0,"n_rows":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":false,"merged":[[85,4,85,10],[86,4,86,10],[71,4,71,10],[73,1,87,1],[73,2,87,2],[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],[87,4,87,10],[81,4,81,10],[82,4,82,10],[83,4,83,10],[84,4,84,10],[58,1,72,1],[58,2,72,2],[58,4,58,10],[59,4,59,10],[60,4,60,10],[72,4,72,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,4,69,10],[70,4,70,10],[39,4,39,10],[40,4,40,10],[41,4,41,10],[42,4,42,10],[47,4,47,10],[43,1,57,1],[43,2,57,2],[43,4,43,10],[44,4,44,10],[45,4,45,10],[46,4,46,10],[52,4,52,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],[38,4,38,10],[25,1,25,10],[26,4,26,10],[27,1,42,1],[27,2,42,2],[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,4,33,10],[34,4,34,10],[35,4,35,10],[36,4,36,10],[37,4,37,10],[23,1,23,10],[0,1,2,10],[4,1,4,10],[5,1,7,10],[9,1,9,10],[10,1,10,10],[12,1,12,10],[13,1,13,10],[15,1,15,10],[16,1,16,10],[18,1,18,10],[19,1,22,10]]}
[null,"                Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[]
[]
[]
[null,"When should a Taxpayer  fill GST ITC-04 form?"]
[null,"1.The Excel based ITC-04 Offline Tool is designed to help taxpayer to prepare his ITC-04 declaration offline.\n2. Details for following Tables of ITC-04 declaration can be added by taxpayer using the offline Tool:\n    Table 4 - It is applicable for taxpayer sending inputs/capital goods to Job worker.\n    Table 5A - It is applicable for taxpayer when inputs/capital goods received back from Job worker.\n    Table 5B - It is applicable for taxpayer when inputs/capital goods sent out to another Job worker.\n    Table 5C - It is applicable for taxpayer when inputs/capital goods sold from Job worker premises.\n\n3.The Offline tool has following features to help taxpayer in Return Preparation: \n      1. 'Open downloaded file or Error file into excel' : To open ITC-04 details file downloaded from GST portal in to the Offline Tool. Upon successful import of file the details would be populated to respective Table wise    worksheets.\n      2. 'Generate JSON File to Upload': To generate JSON file for upload of ITC-04 details prepared offline \n      3. '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 marked in Red.\n4. This Offline tool has 6 excel worksheets :\n    Worksheet 1: Instruction_sheet - Contains introduction and help instructions.\n    Worksheet 2: Home - Import and edit existing JSON file or Generate JSON file from the data entered in Sheet.\n    Worksheet 3: Table 4 - To fill the details of inputs/capital goods which have sent to another job worker.\n    Worksheet 4: Table 5A - To fill the details of inputs/capital goods which have been received back.\n    Worksheet 5: Table 5B - To fill the details of inputs/capital goods sent out to another job worker.\n    Worksheet 6: Table 5C - To fill the details of inputs/capital goods sold from Job worker premises."]
[]
[]
[]
[null,"Preparing ITC-04 Return Using Offline Tool "]
[null,"1. Please ensure you download the latest version of ITC-04 Offline Tool from download drop down on GST portal https://www.gst.gov.in/.\n2. Launch the ITC-04 Excel based Offline Tool and navigate to worksheet named 'Home' .\n3. Enter your GSTIN and mention whether you have registered yourself as SEZ (Special Economic Zone) Unit/Developer or not. Entered GSTIN would be validated for correct structure.\n4. Select the Financial year and Financial period from drop-down.\n6. Enter details as in sheets applicable. In each row challan number should be there and no rows should be left blank in between.\n7. Click on 'Validate sheet' 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 as per help text in the column ‘Sheet Validation Errors’.\n8. Click on ' Generate JSON File to Upload ' to generate JSON file for upload of ITC-04 declaration details prepared offline on GST portal\n9.Please make sure to Empty the sheet(s) before importing any file into tool.\n10.To make change to an invoice uploaded earlier, please create JSON with all new invoice item and upload again. \n\nNote: In case different types of good are sent for Job-work on multiple challan for Job-work and are returned back to Manufacturer as one composite entity; the manufacturer may report receipt of the composite good in Table 5A (Details of goods received back) against the challan number with primary good while other challans can be declared with description, UQC and taxable value as reported earlier in Table 4 with quantity as Zero."]
[]
[null," ITC-04 JSON Upload on GST Portal  "]
[null,"1. Login to GST Portal and select in home page \"Returns\".\n2. Select ITC Forms and Select ITC-04 '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 ITC-04 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; select 'Preview' to see Table wise summary of all records processed successfully on GST Portal. \n8. Post successful validation of 'Preview' you may Submit and file ITC-04."]
[]
[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 the Error file beside the ‘Processed with Error’ status.\n3. Download the Error File and save on your system. \n4. Open the records with errors in offline tool using 'Open Downloaded ITC-04 JSON/Error File' from 'Home' worksheet.\n5. Correct the errors and validate the sheets again post making corrections.  \n6. Click on 'Generate JSON File to upload' to generate JSON file for upload of ITC-04 return details prepared offline on GST portal.\n7. Follow steps mentioned in ITC-04 JSON upload on GST Portal section to file ITC-04."]
[]
[null,"Important points to be noted "]
[null,"While filling the Excel Sheet:\n1) The row is valid only if there is any challan number. File generation will not read the details after the row where challan number is not given.  \n2) Please start writing data from ROW 7 and DO NOT SKIP any row. JSON creation won't read any data after any row skipped. So please fill your invoice details in continues manner. \n3) Please make sure to Empty the sheet(s) before importing any file. \n4) While Opening the Excel sheet, if you see error message box like: \"Compilation error in module due to incompatibility with the version, platform or architecture\" please ignore this message and see if it works or not. In case it does not work, you need latest MS Office for successful export of your data.\n5) Maximum allowed entries are 14000, including data from both the sheets. User can upload JSON multiple times if has more than 14000 invoice items. \n6) This tool takes time in validation and creation of JSON of large data entries. Please close other applications if it stocks and give it sometime to process."]
[]
[]
[]
[null,"Important: \nDo not tamper with the excel template. This might generate erroneous JSON file and create problems while filing GST\nPlease note, all invoice items from one invoice should be uploaded together in single JSON. "]
[]
[null,"ITC-04 Data Entry Instructions  "]
[null,"Worksheet Name","ITC-04 Table Reference","Field name","Help Instruction"]
[null,"Table 4","Registered person enters into Composition/taxable supplied become exempt","GSTIN of Job Worker (JW) ","Enter the GSTIN of Job worker as applicable."]
[null,null,null,"State (in case of unregistered JW) ","Enter the State code for unregistered Job worker."]
[null,null,null,"Job Worker's Type","Where the Job worker belong to SEZ or Non SEZ dropdown is available:-\nSEZ\nNon SEZ "]
[null,null,null,"Challan Number *","Enter the Challan number issued to Job worker. 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,null,"Challan Date\n(dd-mm-yyyy) *","Enter the Challan date. Challan date should not be prior to 01-Jul-2017."]
[null,null,null,"Goods Type*","Select from drop down\n(1)Inputs\n(2)Capital goods"]
[null,null,null,"Description of goods*","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"UQC*","Dropdown available as per master data."]
[null,null,null,"Quantity*","Restricted to 13 number and 2 decimal places."]
[null,null,null,"Taxable Value*","Enter the total value mentioned in the challan  of the received goods or services- with 13 number and 2 decimal places."]
[null,null,null,"Supplier's Type*","Mention whether supplier belongs to SEZ (Special Economic Zone). By default it is Non-SEZ which means, if left blank, it will be treated as Non-SEZ. "]
[null,null,null,"Tax Rate%*","Depends on place of supply  if it is Intra state CGST & SGST will come into picture and if it is Inter state IGST will come into picture.\nNote:-1)CGST and SGST rate should be same\n           2)For SEZ Job worker/SEZ Manufacturer only IGST needs to be mentioned."]
[null,null,null,"Cess","Enter the total Cess amount with 13 number and 2 decimal places"]
[null,null,null,"Action","Value from this column determines whether user wants to add or delete that challan detail in database. If value from this cell is \"Add\", system will treat challan from that row as new data and will add in database. By default, even if left blank, system will assume it is new challan and will send the challan with \"Add\" value, so user can leave this column empty for large number of data. If value from this cell is \"Delete\", challan from that row will be deleted from database after upload. "]
[null,null,null,"Sheet validation Error(s)","If any row has some error after validation, the erroneous cell from that row becomes red and this field will show error message \"There is some error in this row\". Please check the cell with red color in corresponding row. User can use filter, given at the column header to get all the rows which has error(s). \nIf validation is successful, this field will have message, \"This row is validated\"."]
[null,null,null,"GST Portal validation error(s)","After downloading and importing the error report from GST portal, cell from this column will shows error message and corresponding to that row detail. User can use filter, to filter error(s). After correction, user can re-upload the updated details ."]
[null,"Table 5A","Details of inputs/ capital goods received back from job worker to whom such goods were sent for job work; and losses and wastes","GSTIN of Job Worker (JW) ","Enter the GSTIN of Job worker as applicable."]
[null,null,null,"State (in case of unregistered JW) ","Enter the State code for unregistered Job worker ."]
[null,null,null,"Original Challan Number issued by Principal ","Enter the Challan number issued to Job worker. 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,null,"Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Enter the Challan date. Challan date should not be prior to 01-Jul-2017."]
[null,null,null,"Challan Number issued by Job worker","Enter the challan number issued by job work. 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,null,"Challan Date issued by worker \n(dd-mm-yyyy) ","Enter challan date issued by job worker."]
[null,null,null,"Nature of Job Work done*","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"Description of Goods  *","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"UQC*","Dropdown available as per master data."]
[null,null,null,"Quantity*","Restricted to 13 number and 2 decimal places."]
[null,null,null,"UQC (Losses and wastes)","Dropdown available as per master data."]
[null,null,null,"Quantity (Losses and wastes)","Restricted to 13 number and 2 decimal places."]
[null,null,null,"Action","Value from this column determines whether user wants to add or delete that challan detail in database. If value from this cell is \"Add\", system will treat challan from that row as new data and will add in database. By default, even if left blank, system will assume it is new challan and will send the challan with \"Add\" value, so user can leave this column empty for large number of data. If value from this cell is \"Delete\", challan from that row will be deleted from database after upload. "]
[null,null,null,"Sheet validation Error(s)","If any row has some error after validation, the erroneous cell from that row becomes red and this field will show error message \"There is some error in this row\". Please check the cell with red color in corresponding row. User can use filter, given at the column header to get all the rows which has error(s). \nIf validation is successful, this field will have message, \"This row is validated\"."]
[null,null,null,"GST Portal validation error(s)","After downloading and importing the error report from GST portal, cell from this column will shows error message and corresponding to that row detail. User can use filter, to filter error(s). After correction, user can re-upload the updated details ."]
[null,"Table 5B","Details of inputs / capital goods received back from job worker other than the job worker to whom such goods were originally sent for job work; and losses and wastes","GSTIN of Job Worker (JW) ","Enter the GSTIN of Job worker as applicable."]
[null,null,null,"State (in case of unregistered JW) ","Enter the State code for unregistered Job worker ."]
[null,null,null,"Original Challan Number issued by Principal ","Enter the Challan number issued to Job worker. 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,null,"Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Enter the Challan date. Challan date should not be prior to 01-Jul-2017."]
[null,null,null,"Challan Number issued by Job worker","Enter the challan number issued by job work. 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,null,"Challan Date issued by worker \n(dd-mm-yyyy) ","Enter challan date issued by job worker."]
[null,null,null,"Nature of Job Work done*","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"Description of Goods  *","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"UQC*","Dropdown available as per master data."]
[null,null,null,"Quantity*","Restricted to 13 number and 2 decimal places."]
[null,null,null,"UQC (Losses and wastes)","Dropdown available as per master data."]
[null,null,null,"Quantity (Losses and wastes)","Restricted to 13 number and 2 decimal places."]
[null,null,null,"Action","Value from this column determines whether user wants to add or delete that challan detail in database. If value from this cell is \"Add\", system will treat challan from that row as new data and will add in database. By default, even if left blank, system will assume it is new challan and will send the challan with \"Add\" value, so user can leave this column empty for large number of data. If value from this cell is \"Delete\", challan from that row will be deleted from database after upload. "]
[null,null,null,"Sheet validation Error(s)","If any row has some error after validation, the erroneous cell from that row becomes red and this field will show error message \"There is some error in this row\". Please check the cell with red color in corresponding row. User can use filter, given at the column header to get all the rows which has error(s). \nIf validation is successful, this field will have message, \"This row is validated\"."]
[null,null,null,"GST Portal validation error(s)","After downloading and importing the error report from GST portal, cell from this column will shows error message and corresponding to that row detail. User can use filter, to filter error(s). After correction, user can re-upload the updated details ."]
[null,"Table 5C","5(C) Details of inputs/ Capital goods sent to job worker and subsequently supplied from premises of job worker; and losses and wastes","GSTIN of Job Worker (JW) ","Enter the GSTIN of Job worker as applicable."]
[null,null,null,"State (in case of unregistered JW) ","Enter the State code for unregistered Job worker ."]
[null,null,null,"Original Challan Number issued by Principal ","Enter the Challan number issued to Job worker. 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,null,"Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Enter the Challan date. Challan date should not be prior to 01-Jul-2017."]
[null,null,null,"Invoice  Number issued by Principal *","Enter the challan number issued by job work. 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,null,"Invoice Date issued by Principal*\n(dd-mm-yyyy)","Enter challan date issued by job worker."]
[null,null,null,"Nature of Job Work done*","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"Description of Goods  *","Alphanumeric characters, with allowed special characters of slash(/) , dash(-) and whitespace and restricted to maximum length 70."]
[null,null,null,"UQC*","Dropdown available as per master data."]
[null,null,null,"Quantity*","Restricted to 13 number and 2 decimal places."]
[null,null,null,"UQC (Losses and wastes)","Dropdown available as per master data."]
[null,null,null,"Quantity (Losses and wastes)","Restricted to 13 number and 2 decimal places."]
[null,null,null,"Action","Value from this column determines whether user wants to add or delete that challan detail in database. If value from this cell is \"Add\", system will treat challan from that row as new data and will add in database. By default, even if left blank, system will assume it is new challan and will send the challan with \"Add\" value, so user can leave this column empty for large number of data. If value from this cell is \"Delete\", challan from that row will be deleted from database after upload. "]
[null,null,null,"Sheet validation Error(s)","If any row has some error after validation, the erroneous cell from that row becomes red and this field will show error message \"There is some error in this row\". Please check the cell with red color in corresponding row. User can use filter, given at the column header to get all the rows which has error(s). \nIf validation is successful, this field will have message, \"This row is validated\"."]
[null,null,null,"GST Portal validation error(s)","After downloading and importing the error report from GST portal, cell from this column will shows error message and corresponding to that row detail. User can use filter, to filter error(s). After correction, user can re-upload the updated details ."]

{"sheet":"Home","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,14],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,10,3,12],[8,1,8,7],[8,8,8,14],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[6,1,6,14],[7,1,7,7],[7,8,7,14]]}
[null," Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[]
[]
[null,"GSTIN of Manufacturer *",null,"SEZ Unit/Developer *",null,"Financial Year *",null,"Tax Period *",null,null,"* indicates mandatory field"]
[]
[]
[]
[null,1,null,null,null,null,null,null,"Click on this button to import the data file or the error file,\n downloaded from the online portal (in .json format) and open it in offline tool for modification. This will auto populate the details in  the offline tool."]
[null,2,null,null,null,null,null,null,"Click on this button to create the data file (in .Json format) of details and modifications in offline tool. \n The said file will be uploaded in the online GST portal for further processing of your GST ITC 04 Form."]

{"sheet":"Table 4","index":2,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,17],[1,1,2,17],[3,1,3,2]]}
[null,"                            Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[null,"                                                                                                      Details of inputs/capital goods sent for job-work \n                                                                                                                             * indicates mandatory field                                                                                                                                      \n"]
[]
[null,"Only one is mandatory *"]
[null,"GSTIN of Job Worker (JW) ","State (in case of unregistered JW) ","Job Worker's Type","Challan Number *","Challan Date\n(dd-mm-yyyy) *","Types of Goods *","Description of Goods *","Unique Quantity Code (UQC) *","Quantity *","Taxable Value *\n(in Rupees)","Integrated Tax Rate\nin (%) *","Central Tax Rate\n in (%) *","State/UT Tax Rate in (%) *","Cess","Action","Sheet Validation Error(s)","GST Portal Validation Error(s)"]
[null,"ctin","jw_stcd","sez","chnum","chdt","goods_ty","desc","uqc","qty","txval","tx_i","tx_c","tx_s","tx_cs","flag","error_flag","error"]

{"sheet":"Table 5A","index":3,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,15],[1,1,2,15],[3,1,3,2],[3,3,3,6],[3,7,3,10],[3,11,3,12],[3,13,3,15]]}
[null,"                           Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[null,"                                                             5 (A) Details of inputs/ capital goods received back from job worker to whom such goods \n                                                                                                 were sent for job work; and losses and wastes\n                                                                                                                         * indicates mandatory field"]
[]
[null,"Either of one is mandatory *",null,"Either one of Challan detail is mandatory*",null,null,null,null,null,null,null,"Losses and wastes  "]
[null,"GSTIN of Job Worker(JW) ","State (in case of unregistered JW) ","Original Challan Number issued by Prinicpal ","Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Challan Number issued by Job worker","Challan Date issued by worker \n(dd-mm-yyyy) ","Nature of Job Work done *","Description of Goods  *","Unique Quantity Code (UQC) *","Quantity  *","Unique Quantity Code (UQC) ","Quantity  ","Action","Sheet Validation Error(s)","GST Portal Validation Error(s)"]
[null,"ctin","jw_stcd","o_chnum","o_chdt","jw2_chnum","jw2_chdt","nat_jw","desc","uqc","qty","lwuqc","lwqty","flag","errorFlag2","error2"]

{"sheet":"Table 5B","index":4,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,15],[1,1,2,15],[3,1,3,2],[3,3,3,6],[3,7,3,10],[3,11,3,12],[3,13,3,15]]}
[null,"                            Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[null,"                                                   5(B) Details of inputs / capital goods received back from job worker other than the job worker to whom \n                                                                                such goods were originally sent for job work; and losses and wastes:\n                                                                                                                         * indicates mandatory field"]
[]
[null,"Either of one is mandatory *",null,"Either one of Challan detail is mandatory*",null,null,null,null,null,null,null,"Losses and wastes  "]
[null,"GSTIN of Job Worker(JW) ","State (in case of unregistered JW) ","Original Challan Number issued by Prinicpal ","Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Challan Number issued by Job worker","Challan Date issued by worker \n(dd-mm-yyyy) ","Nature of Job Work done *","Description of Goods  *","Unique Quantity Code (UQC) *","Quantity  *","Unique Quantity Code (UQC) ","Quantity  ","Action","Sheet Validation Error(s)","GST Portal Validation Error(s)"]
[null,"ctin","jw_stcd","o_chnum","o_chdt","jw2_chnum","jw2_chdt","nat_jw","desc","uqc","qty","lwuqc","lwqty","flag","errorFlag2","error2"]

{"sheet":"Table 5C","index":5,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,15],[1,1,2,15],[3,1,3,2],[3,3,3,6],[3,7,3,10],[3,11,3,12],[3,13,3,15]]}
[null,"                         Goods and Services Tax - GST ITC-04 Offline Tool (v2.9)"]
[null,"                                                              5(C) Details of inputs/ Capital goods sent to job worker and subsequently supplied \n                                                                                           from premises of job worker; and losses and wastes:\n                                                                                                                  * indicates mandatory field"]
[]
[null,"Either of one is mandatory *",null,"Invoice No. is mandatory *",null,null,null,null,null,null,null,"Losses and wastes  "]
[null,"GSTIN of Job Worker(JW) ","State (in case of unregistered JW) ","Original Challan Number issued by Prinicpal ","Original Challan Date issued by Principal\n(dd-mm-yyyy) ","Invoice  Number issued by Principal *","Invoice Date issued by Principal*\n(dd-mm-yyyy) ","Nature of Job Work done *","Description of Goods  *","Unique Quantity Code (UQC) *","Quantity  *","Unique Quantity Code (UQC) ","Quantity  ","Action","Sheet Validation Error(s)","GST Portal Validation Error(s)"]
[null,"ctin","jw_stcd","o_chnum","o_chdt","inum","idt","nat_jw","desc","uqc","qty","lwuqc","lwqty","flag","errorFlag2","error2"]

{"sheet":"master","index":6,"n_rows":60,"n_cols":26,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["UQC Type","UQC Code","UQC Type","JWS code","JWS","JWS code",null,"Quarter Code","Quarter","Quarter Code",null,"Flag","Action","Flag",null,"IGST tax Rate",null,"GST tax Rate",null,"goods flow code","Type of good's flow","goods flow code",null,"Type of goods code","Type of Goods","Type of goods code"]
["BAG","BAG","BAG","01C","01-Jammu & Kashmir","01C",null,"13Q","Apr-Jun","13Q",null,"N","ADD","N",null,0,null,0,null,"RB","Goods Received back from JW","RB",null,"7b","Capital Goods","7b"]
["BALE","BAL","BALE","02C","02-Himachal Pradesh","02C",null,"14Q","Jul-Sep","14Q",null,"D","DELETE","D",null,0.1,null,0.05,null,"SA","Goods Sent out to another JW","SA",null,"8b","Inputs","8b"]
["BUNDLES","BDL","BUNDLES","03C","03-Punjab","03C",null,"15Q","Oct-Dec","15Q",null,null,null,null,null,0.25,null,0.125,null,"SF","Goods Supplied from JW","SF"]
["BUCKLES","BKL","BUCKLES","04C","04-Chandigarh","04C",null,"16Q","Jan-Mar","16Q",null,null,null,null,null,1,null,0.5]
["BILLIONS OF UNITS","BOU","BILLIONS OF UNITS","05C","05-Uttarakhand","05C",null,"FY","Financial Year","Fy",null,"Quarter Half year","Quarter and H2"," Code",null,1.5,null,0.75]
["BOX","BOX","BOX","06C","06-Haryana","06C",null,2017,"2017-2018",2017,null,"13Q","Apr-Jun","13Q",null,3,null,1.5]
["BOTTLES","BTL","BOTTLES","07C","07-Delhi","07C",null,2018,"2018-2019",2018,null,"14Q","Jul-Sep","14Q",null,5,null,2.5]
["BUNCHES","BUN","BUNCHES","08C","08-Rajasthan","08C",null,2019,"2019-2020",2019,null,"18H2","Oct-Mar","18H2",null,7.5,null,3.75]
["CANS","CAN","CANS","09C","09-Uttar Pradesh","09C",null,2020,"2020-2021",2020,null,null,null,null,null,12,null,6]
["CUBIC METER","CBM","CUBIC METER","10C","10-Bihar","10C",null,2021,"2021-2022",2021,null,null,null,null,null,18,null,9]
["CUBIC CENTIMETER","CCM","CUBIC CENTIMETER","11C","11-Sikkim","11C",null,2022,"2022-2023",2022,null,"Annual Half year","Annual and H2 H1"," Code",null,28,null,14]
["CENTIMETER","CMS","CENTIMETER","12C","12-Arunachal Pradesh","12C",null,null,"SEZ manufacturer",null,null,"17H1","Apr-Sep","17H1"]
["CARTONS","CTN","CARTONS","13C","13-Nagaland","13C",null,"Y","Yes","Y",null,"18H2","Oct-Mar","18H2"]
["DOZEN","DOZ","DOZEN","14C","14-Manipur","14C",null,"N","No","N",null,"19A","Apr-Mar","19A"]
["DRUM","DRM","DRUM","15C","15-Mizoram","15C"]
["GREAT GROSS","GGR","GREAT GROSS","16C","16-Tripura","16C"]
["GRAMS","GMS","GRAMS","17C","17-Meghalaya","17C",null,null,"SEZ supplier"]
["GROSS","GRS","GROSS","18C","18-Assam","18C",null,"Y","SEZ","Y"]
["GROSS YARDS","GYD","GROSS YARDS","19C","19-West Bengal","19C",null,"N","Non SEZ","N"]
["KILOGRAMS","KGS","KILOGRAMS","20C","20-Jharkhand","20C"]
["KILOLITER","KLR","KILOLITER","21C","21-Odisha","21C"]
["KILOMETRE","KME","KILOMETRE","22C","22-Chhattisgarh","22C"]
["MILLILITRE","MLT","MILLILITRE","23C","23-Madhya Pradesh","23C"]
["METERS","MTR","METERS","24C","24-Gujarat","24C"]
["NUMBERS","NOS","NUMBERS","25C","25-Daman & Diu","25C"]
["PACKS","PAC","PACKS","26C","26-Dadra & Nagar Haveli & Daman & Diu","26C"]
["PIECES","PCS","PIECES","27C","27-Maharashtra","27C"]
["PAIRS","PRS","PAIRS","29C","29-Karnataka","29C"]
["QUINTAL","QTL","QUINTAL","30C","30-Goa","30C"]
["ROLLS","ROL","ROLLS","31C","31-Lakshdweep","31C"]
["SETS","SET","SETS","32C","32-Kerala","32C"]
["SQUARE FEET","SQF","SQUARE FEET","33C","33-Tamil Nadu","33C"]
["SQUARE METERS","SQM","SQUARE METERS","34C","34-Puducherry","34C"]
["SQUARE YARDS","SQY","SQUARE YARDS","35C","35-Andaman & Nicobar Islands","35C"]
["TABLETS","TBS","TABLETS","36C","36-Telangana","36C"]
["TEN GROSS","TGM","TEN GROSS","37C","37-Andhra Pradesh","37C"]
["THOUSANDS","THD","THOUSANDS","38C","38-Ladakh","38C"]
["TONNES","TON","TONNES","97C","97-Other Territory","97C"]
["TUBES","TUB","TUBES"]
["US GALLONS","UGS","US GALLONS"]
["UNITS","UNT","UNITS"]
["YARDS","YDS","YARDS"]
["OTHERS","OTH","OTHERS"]
[]
["FY",null,null,null,"2018-2019",null,"2019-2020",null,"2021-2022",null,"2017-2018",null,"2020-2021",null,"2022-2023"]
["FY2017_18",null,null,null,"Apr-Jun",null,"Apr-Jun",null,"Apr-Jun",null,"Apr-Jun",null,"Apr-Jun",null,"Apr-Sep"]
["FY2018_19",null,null,null,"Jul-Sep",null,"Jul-Sep",null,"Jul-Sep",null,"Jul-Sep",null,"Jul-Sep",null,"Oct-Mar"]
["FY2019_20",null,null,null,"Oct-Dec",null,"Oct-Dec",null,"Oct-Mar",null,"Oct-Dec",null,"Oct-Dec",null,"Apr-Mar"]
["FY2020_21",null,null,null,"Jan-Mar",null,"Jan-Mar",null,null,null,"Jan-Mar",null,"Jan-Mar"]
["FY2021_22"]
["FY2022_23"]
[null,null,null,null,null,null,null,"Quarter Code","Quarter","Quarter Code"]
[null,null,null,null,null,null,null,"13Q","Apr-Jun","13Q"]
[null,null,null,null,null,null,null,"14Q","Jul-Sep","14Q"]
[null,null,null,null,null,null,null,"15Q","Oct-Dec","15Q"]
[null,null,null,null,null,null,null,"16Q","Jan-Mar","16Q"]
[null,null,null,null,null,null,null,"17Q","Apr-Sep","17Q"]
[null,null,null,null,null,null,null,"18Q","Oct-Mar","18Q"]
[null,null,null,null,null,null,null,"19Q","Apr-Mar","19Q"]