{"text_format":"5","workbook":"xls","n_sheets":5,"sheets":["Help Instructions ","Import_Export_file","Mfg_to_JW","JW_to_Mfg","Master_table"],"props":{"creator":"Divya Prakash","last_modified_by":"Aibs"},"defined_names":["action_import","exportToJSON","flag","flag_map","fp","gflow_map","good_type","goods_flow","goods_ty_map","gst_rate","gt","igst_rate","inv_typ","inv_typ_map","jw_st_cd_map","mainModule.importFromJSON","ntty","ntty_map","pos","pos_map","quarter","quarter_map","rchrg","rchrg_map","retq","retq_map","rsn","rsn_map","rt","sply_ty","sply_ty_map","st_code_import","state_map","states","t","Tax_Rate","Tax_Rate14","test","test2","uqc","UQC_Code","uqc_import","uqc_map","uqc_temp","uqc_test","validatejw2mSheet","validatem2jwSheet"],"not_rendered":{"images":6,"macros":1,"external_links":1,"defined_names":50,"comments":6},"notes":{"written":6,"chars":374},"read":"whole","wrapped":"gz","date_system":"1900","formulas":"cached_only"}

{"sheet":"Help Instructions ","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,1,2,10],[4,1,4,10],[5,1,5,10],[6,1,6,3],[7,1,7,10],[8,1,9,10]],"flags":["formulas_cached_only"]}
[null,"      Goods and Services Tax - GST ITC-04 Offline Tool (v1.0)"]
[]
[]
[]
[null,"When should a Manufacturer  fill GST ITC-04 form?"]
[null,"Manufacturer need to declare the details in ITC-04 in either or all the situations:\na) If the manufacturer is sending any goods(capital or input type) to a Job Worker (JW)\nb) JW sends back the goods to the manufacturer\nc) JW sends goods to another JW\nd) JW sends goods out from his business premises to end customer.\n\nThis offline tool helps manufacturer to:\n• Prepare ITC-04 when offline (i.e. without Internet). \n• Upload bulk invoices/other details to GST portal. \n• Edit the generated file using import \n"]
[]
[null,"Understanding the Excel Workbook Template"]
[null,"There is a simple 3-step process:\n1. Enter data in (sheet 3&4) or import and edit existing JSON file (in Sheet 1) \n2. Generate output in .JSON file format (Sheet 2)\n3. Upload this output file (.JSON file format) into the GST portal (www.gst.gov.in)\n\nThis Excel workbook template has 4 worksheets\nWorksheet 1. Help Instructions - Contains introduction and help instructions\nWorksheet 2. Import_Export_file - Import and edit existing JSON file or Generate JSON file from the data entered in Sheet 3 & 4\nWorksheet 3. Mfg_to_JW - Enter details of inputs/capital goods sent for job-work\nWorksheet 4. JW_to_Mfg - Enter details of inputs/capital goods received back from job worker or enter details of inputs/capital goods sent out from job workers premises\n\nImportant: Do not tamper with the excel template. This might generate erroneous JSON file and create problems while filing GST\n\nPoint to note while filling the Excel Sheet:\n1) While Opening the Excel sheet, if you see error message box like: \"Compilation error in module due to incompatiblity with the verion, platform or architecture\" (figure 1 below) 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.\n2) Please start writing data from ROW 7 and DO NOT SKIP any row. JSON creation won't read any data after any row skiped. So please fill your challan detail in continues manner. \n3) The row is valid only if there is any challan number. File generation will not read the details after the row where, there is no challan number in that row.  \n4) Please note, uploading the file generated from this tool will replace the data from previous upload of same quarter. For any modification in already uploaded file, please modify the desired invoices in the excel and upload the entire excel data again. \n5) While Exporting or validating any sheet, if it says \"There is an error in sheet\" in first time validation, try validating again. If the error persists, then there must be some error in the sheet.\n6) Error message box shown in figure 2 below can also be ignored.\n7) Please make sure to Empty the sheets before importing any file. \n"]

{"sheet":"Import_Export_file","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[0,1,2,8],[4,1,4,2],[4,8,6,8],[5,1,5,2],[6,1,6,2],[8,2,8,4],[8,5,8,8],[9,1,10,1],[9,2,10,4],[9,5,10,8],[11,1,12,1],[11,2,12,4],[11,5,12,8],[14,1,14,8],[15,1,16,8],[17,1,17,8]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GST ITC-04 Offline Tool (v1.0)"]
[]
[]
[]
[null,"GSTIN ",null,"Return Year","Return Filing Quarter"]
[null,"gstin",null,"retq","rety"]
[{"$nulls":4},"Jul-Sep"]
[]
[null,"Steps","Action",null,null,"Description"]
[null,1,{"$nulls":3},"Click on this button to import the data file or the error file, 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 basis the data entry sections in this file"]
[]
[null,2,{"$nulls":3},"Click on this button to create the data file (in .Json format) of details and modifications in offline tool. The said file will be uploaded in the online GST portal for further processing of your GST ITC 04 Form"]

{"sheet":"Mfg_to_JW","index":2,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,2,14],[3,1,3,14]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GST ITC-04 Offline Tool (v1.0)"]
[]
[]
[null,"                  Details of inputs/capital goods sent for job-work"]
[null,"GSTIN of Job Worker (JW)*","State (in case of unregistered JW) *",{"v":"Challan Number *","$note":[{"by":"Divya Prakash","t":"Only 16 character alphanumeric value with '-' or '/' is allowed\n\n"}]},"Challan Date\n(dd-mm-yyyy) *","Description of Goods *","Unique Quantity Code (UQC) *","Quantity *","Taxable Value *","Types of Goods*","Integrated Tax Rate\nin (%) *","Central Tax Rate\n in (%)*","State/UT Tax Rate in (%)*","Cess","Errors"]
[null,"ctin","jw_stcd","chnum","chdt","desc","uqc","qty","val","goods_ty","tx_i","tx_c","tx_s","tx_cs","Error flag"]

{"sheet":"JW_to_Mfg","index":3,"n_rows":6,"n_cols":17,"rows_kept":6,"merged":[[0,1,1,16],[2,1,2,15],[3,6,3,9],[3,10,3,11]],"flags":["formulas_cached_only"]}
[null,"       Goods and Services Tax - GST ITC-04 Offline Tool (v1.0)"]
[]
[null,"                     Details of inputs/capital goods received back from job worker or sent out from business place of job-work"]
[{"$nulls":6},"Challan detail if goods sent to another Job Worker",{"$nulls":3},"Invoice detail in case supplied from\npremises of Job Worker"]
[null,"GSTIN of Job Worker(JW) *","State (in case of unregistered JW) *","Nature of Transaction *",{"v":"Original Challan Number *","$note":[{"by":"Divya Prakash","t":"Only 16 character alphanumeric value with '-' or '/' is allowed\n"}]},"Original Challan Date\n(dd-mm-yyyy) *",{"v":"No.","$note":[{"by":"Divya Prakash","t":"Only 16 character alphanumeric value with '-' or '/' is allowed"}]},"Date \n(dd-mm-yyyy) ",{"v":"GSTIN ","$note":[{"by":"Divya Prakash","t":"GSTIN of Job Worker \n"}]},{"v":"State (in case of unregistered JW) ","$note":[{"by":"Divya Prakash","t":"State of Job Worker\n"}]},{"v":"No.","$note":[{"by":"Divya Prakash","t":"Only 16 character alphanumeric value with '-' or '/' is allowed"}]},"Date\n(dd-mm-yyyy)","Description of Goods  *","Unique Quantity Code (UQC) *","Quantity  *","Taxable Value *","Errors"]
[null,"ctin","jw_stcd","action","o_chnum","o_chdt","jw_chnum","jw_chdt","jw_ctin","jw2_st_cd","inum","idt","desc","uqc","qty","val","Error Flag"]

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