{"text_format":"5","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","eWayBill","Master Codes","Sample eWayBill","FAQ's","Validation"],"props":{"title":"29AAACG0569P1Z3","creator":"owner","last_modified_by":"Acer"},"defined_names":["Clients","codes","Doc_No","Exhibition_or_Fairs","Export","For_Own_Use","I","Import","Inward","Job_Work","Job_work_Returns","Lines_Sales","look_dis","look_dtyp","look_st","look_subtyp","look_trmd","look_type","O","OtherPartyNm","Others","Outward","PreNmClient","PreNmSup","ProdName","Product","Product_Desc","Products","Recipient_Not_Known","Sales_Return","SKD_CKD","State_Name","States","Supplier","Supply","Transporter","TranType","Type","units","veh_Type","vehTyp_list"],"not_rendered":{"images":19,"macros":1,"defined_names":41},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":75,"n_cols":8,"rows_kept":75}
{"$rows_empty":28}
["                                                                            E-waybill  Specification and Validation."]
[]
[null,"Column Name","Type","Description","Column Value","Mandatory Column",null,"Validations on Columns"]
[null,"Supply Type","Text (7)","Supply whether it is outward/inward","Refer Master codes","Yes",null,"Either  Inward or Outward is allowed."]
[null,"Sub Type","Text(20)","Sub types of Supply","Refer Master codes","Yes",null,"Selection based on Inward or Outward transaction."]
[null,"Doc Type","Text(16)","Document Type","Refer Master codes","Yes",null,"Only Document Type with the corresponding Sub-Type is allowed.Refer Table 2 in the Validation sheet."]
[null,"Doc No","Text(16)","Document Number",78656,"Yes",null,"Only alpha numeric keys and  - (hyphen),   / (slash) and .(dot) are allowed."]
[null,"Doc Date","Text(10)","Document Date","02/02/2018","Yes",null,"Document Date should be in DD/MM/YYYY format."]
[null,"Transaction Type","Text(30)","Type of Transaction","Refer Master codes","Yes",null,"Only valid Transaction Types are allowed."]
[null,"From_OtherPartyName","Text(100)","LegalName of consignor","Ambuja Private Ltd","No",null,"Only alpha numeric keys and  - (hyphen)  / (slash) and .(dot) are allowed."]
[null,"From_GSTIN","Text(15)","GSTIN of the Consignor","29AAACG0569P1Z3","Yes",null,"Only valid GSTIN is allowed."]
[null,"From_Address1","Text(120)","Address of consignor - Line 1","BEML ROAD","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"From_Address2","Text(120)","Address of consignor - Line 2","KG ROAD","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"From_Place","Text(50)","Place of consignor","BANGALORE","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"Dispatch_Pin Code","Number(6)","Pincode of consignor",560090,"Yes",null,"Only 6 digits number is allowed, Dispatch_Pin Code should belongs  to  Dispatch From_State."]
[null,"Bill From_State","Text(50)","State of consignor","Refer Master codes","Yes",null,"Only valid states are allowed."]
[null,"Dispatch From_State","Text(50)","State from where it is being dispatched","Refer Master codes","Yes",null,"Only valid states are allowed."]
[null,"To_OtherPartyName","Text(100)","LegalName of consignee","HUKKERI PVT LTD","No",null,"Only alpha numeric keys and  - (hyphen)  / (slash) and .(dot) are allowed."]
[null,"To_GSTIN","Text(15)","GSTIN of consignee","URP","Yes",null,"Only valid GSTIN is allowed."]
[null,"To_Address1","Text(120)","Address of consignee - Line 1","VIDYARANYAPUR ROAD","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"To_Address2","Text(120)","Address of consignee- Line 2","MG ROAD","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"To_Place","Text(50)","Place of consignee","BANGALORE","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"Ship To_Pin Code","Number(6)","Pincode of the consignee",560090,"Yes",null,"Only 6 digits number is allowed, Ship To_Pin Code should belongs  to  Ship To_State."]
[null,"Bill To_State","Text(50)","State of the consignee","Refer Master codes","Yes",null,"Only valid states are allowed."]
[null,"Ship To_State","Text(50)","State to where it is being shipped","Refer Master codes","Yes",null,"Only valid states are allowed."]
[null,"Product","Text(100)","Name of the Product","IRON","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"Description","Text(100)","Description of the Product","IRON PYRITES","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"HSN","Number(8)","HSN Code of the Product",1005,"Yes",null,"Valid 4 digits or 8 digits HSN code is allowed."]
[null,"Unit","Text(20)","Unit of the Product","Refer Master codes","No",null,"Valid Unit is allowed."]
[null,"Qty","Number(12)","Quantity of Product",12,"No",null,"Only numbers are allowed."]
[null,"Assessable Value","Number(18)","Assessable Value",31,"Yes",null,"Only numbers are allowed."]
[null,"Tax Rate (S+C+I+Cess+Cess Non Advol)","Text(20)","Tax Rate (S+C+I+Cess+Cess Non Advol)","5+5+0+1+1","No",null,"Only Standard Tax Rates are allowed(Refer Table 1 in the Validation sheet)."]
[null,"CGST Amount","Number(18)","CGST Amount",7,"No",null,"Only numbers are allowed."]
[null,"SGST Amount","Number(18)","SGST Amount",8,"No",null,"Only numbers are allowed."]
[null,"IGST Amount","Number(18)","IGST Amount",9,"No",null,"Only numbers are allowed."]
[null,"CESS Amount","Number(18)","CESS Amount",1,"No",null,"Only numbers are allowed."]
[null,"CESS Non Advol Amount","Number(18)","CESS Non Advol Amount",1,"No",null,"Only numbers are allowed."]
[null,"Others","Number(18)","Other chareges",1,"No",null,"Negative and Non negative numbers are allowed."]
[null,"Total Invoice Value","Number(18)","Sum of assessable value , tax value and other charges",65,"Yes",null,"Sum of Assessable value, CGST Amount, SGST Amount, IGST Amount, CESS Amount, CESS Non Advol Amount and Others  should be lesser than or equal to  the Total Invoice Value.(Only 2 Rupee difference is allowed)."]
[null,"Trans Mode","Text(10)","Mode of transportation","Refer Master codes","No",null,"Only valid Trans Mode is allowed."]
[null,"Distance (Km)","Number(4)","Distance of transportation",80,"Yes",null,"Only numbers are allowed. Distance should be lesser than or equal to 4000 KM."]
[null,"Trans Name","Text(100)","Transporter Name","TAKRE PVT LTD","No",null,"Only alpha numeric keys and  @,  # , -,  /,, &, . are allowed."]
[null,"Trans ID","Text(15)","Transporter Id","28ASDRF0767H1V4","Conditional","To generate only Part A slip, Transporter ID is mandatory","Only valid GSTIN is allowed."]
[null,"Trans DocNo","Text(15)","Transporter Document Number",4567,"Conditional","Mandatory if Trans mode is Rail/Air/Ship","Only alpha numeric keys and  - (hyphen),   / (slash) and .(dot) are allowed."]
[null,"Trans Date","Text(10)","Transporter Doc Date","02/03/2018","Conditional","Mandatory if Trans mode is Rail/Air/Ship","Trans Date should be in DD/MM/YYYY format."]
[null,"Vehicle No","Text(15)","Vehicle Number","KA12KA1234          OR\nKA12K1234             OR   \nKA123456                OR\nKAR1234                  OR              KA123K1234           OR \nKA12KAR1234        OR   DFXXXXXX               OR         TRXXXXXX               OR           BPXXXXXX               OR  NPXXXXXX","Conditional","Mandatory if Mode of transportation is Road and Trans DocNo is not entered ","Only valid vehicle numbers are allowed."]
[null,"Vehicle Type","Text(10)","Vehicle Type","Regular                                     ODC","Conditional","Mandatory If Trans Mode is Road","Either  Regular or ODC (Over Dimentional Cargo) are allowed."]

{"sheet":"eWayBill","index":1,"n_rows":3,"n_cols":45,"rows_kept":3,"merged":[[1,36,1,43]]}
["Are you a *",{"$nulls":3},"E - WAY BILL  SYSTEM",{"$nulls":5},"Please check for the errors in the last column of the XL Sheet ( if any )  "]
["GSTIN/Trans-porter ID: *",{"$nulls":3},"Legal Name :",{"$nulls":3},"Address :",null,null,"* Indicates Mandatory columns",null,"Place :",null,"State: *",null,null,"Pin Code : *",{"$nulls":17},"PART - B"]
["Supply Type *","Sub Type *","Doc Type *","Doc No *","Doc Date *","Transaction Type *","From_OtherPartyName","From_GSTIN *","From_Address1","From_Address2","From_Place","Dispatch_Pin Code *","Bill From_State *","Dispatch From_State *","To_OtherPartyName","To_GSTIN *","To_Address1","To_Address2","To_Place","Ship To_Pin Code *","Bill To_State *","Ship To_State *","Product","Description","HSN *","Unit","Qty","Assessable Value *","Tax Rate (S+C+I+Cess+Cess Non Advol)","CGST Amount","SGST Amount","IGST Amount","CESS Amount","CESS Non Advol Amount","Others","Total Invoice Value *","Trans Mode","Distance (Km) *","Trans Name","Trans ID","Trans DocNo","Trans Date","Vehicle No","Vehicle Type","Errors List"]

{"sheet":"Master Codes","index":2,"n_rows":125,"n_cols":19,"rows_kept":125}
["Column Name","Column Value"]
["Supply Type","Inward"]
[null,"Outward"]
[]
["Sub  Type","Supply",{"$nulls":9},"Inward",{"$nulls":5},"BAGS","BAG"]
[null,"Import",{"$nulls":9},"Outward",null,"ST_NAME","STATE_NO",null,null,"BALE","BAL"]
[null,"Export",{"$nulls":11},"ANDAMAN AND NICOBAR",35,null,null,"BUNDLES","BDL"]
[null,"Job Work",{"$nulls":7},"Supply",null,"Supply",null,"ANDHRA PRADESH",37,null,null,"BUCKLES","BKL"]
[null,"For Own Use",{"$nulls":7},"Import",null,"Export",null,"ARUNACHAL PRADESH",12,null,null,"BILLION OF UNITS","BOU"]
[null,"Job work Returns",{"$nulls":7},"SKD/CKD/Lots",null,"Job Work",null,"ASSAM",18,null,null,"BOX","BOX"]
[null,"Sales Return",{"$nulls":7},"Job work Returns",null,"SKD/CKD/Lots",null,"BIHAR",10,null,null,"BOTTLES","BTL"]
[null,"Others",{"$nulls":7},"Sales Return",null,"Recipient Not Known",null,"CHANDIGARH",4,null,null,"BUNCHES","BUN"]
[null,"SKD/CKD/Lots",{"$nulls":7},"Exhibition or Fairs",null,"For Own Use",null,"CHHATTISGARH",22,null,null,"CANS","CAN"]
[null,"Line Sales",{"$nulls":7},"For Own Use",null,"Exhibition or Fairs",null,"DADRA AND NAGAR HAVELI",26,null,null,"CUBIC METERS","CBM"]
[null,"Recipient  Not Known",{"$nulls":7},"Others",null,"Lines Sales",null,"DELHI",7,null,null,"CUBIC CENTIMETERS","CCM"]
[null,"Exhibition or Fairs",{"$nulls":9},"Others",null,"GOA",30,null,null,"CENTI METERS","CMS"]
[{"$nulls":9},"Supply",{"$nulls":3},"GUJARAT",24,null,null,"CARTONS","CTN"]
["Doc Type","Tax Invoice",{"$nulls":7},"Import",{"$nulls":3},"HARYANA",6,null,null,"DOZENS","DOZ"]
[null,"Bill of Supply",{"$nulls":7},"SKD/CKD/Lots",{"$nulls":3},"HIMACHAL PRADESH",2,null,null,"DRUMS","DRM"]
[null,"Bill of Entry",{"$nulls":7},"Job work Returns",{"$nulls":3},"JAMMU AND KASHMIR",1,null,null,"GREAT GROSS","GGK"]
[null,"Delivery Challan",{"$nulls":7},"Sales Return",{"$nulls":3},"JHARKHAND",20,null,null,"GRAMMES","GMS"]
[null,"Others",{"$nulls":7},"Exhibition or Fairs",{"$nulls":3},"KARNATAKA",29,null,null,"GROSS","GRS"]
[{"$nulls":9},"For Own Use",{"$nulls":3},"KERALA",32,null,null,"GROSS YARDS","GYD"]
[{"$nulls":9},"Others",null,"Road",null,"LAKSHADWEEP",31,null,null,"KILOGRAMS","KGS"]
["Trans Mode","Road",{"$nulls":9},"Air",null,"LADAKH",38,null,null,"KILOLITRE","KLR"]
[null,"Rail",{"$nulls":7},"Supply",null,"Rail",null,"MADHYA PRADESH",23,null,null,"KILOMETRE","KME"]
[null,"Air",{"$nulls":7},"Export",null,"Ship",null,"MAHARASHTRA",27,null,null,"LITRES","LTR"]
[null,"Ship",{"$nulls":7},"Job Work",{"$nulls":3},"MANIPUR",14,null,null,"MILILITRE","MLT"]
[{"$nulls":9},"SKD/CKD/Lots",null,"< 10",null,"MEGHALAYA",17,null,null,"METERS","MTR"]
[{"$nulls":9},"Recipient Not Known",null,"10 - 100",null,"MIZORAM",15,null,null,"METRIC TON","MTS"]
["Unit","BAGS                     ",{"$nulls":7},"For Own Use",null,"100 - 300",null,"NAGALAND",13,null,null,"NUMBERS","NOS"]
[null,"BALE",{"$nulls":7},"Exhibition or Fairs",null,"300 - 500",null,"ORISSA",21,null,null,"OTHERS","OTH"]
[null,"BUNDLES                  ",{"$nulls":7},"Lines Sales",null,"500 - 1000",null,"PONDICHERRY",34,null,null,"PACKS","PAC"]
[null,"BUCKLES",{"$nulls":7},"Others",null,"> 1000",null,"PUNJAB",3,null,null,"PIECES","PCS"]
[null,"BILLION OF UNITS",{"$nulls":11},"RAJASTHAN",8,null,null,"PAIRS","PRS"]
[null,"BOX",{"$nulls":11},"SIKKIM",11,null,null,"QUINTAL","QTL"]
[null,"BOTTLES",{"$nulls":11},"TAMIL NADU",33,null,null,"ROLLS","ROL"]
[null,"BUNCHES",{"$nulls":11},"TELANGANA",36,null,null,"SETS","SET"]
[null,"CANS",{"$nulls":11},"TRIPURA",16,null,null,"SQUARE FEET","SQF"]
[null,"CUBIC METERS",{"$nulls":11},"UTTAR PRADESH",9,null,null,"SQUARE METERS","SQM"]
[null,"CUBIC CENTIMETERS",{"$nulls":11},"UTTARAKHAND",5,null,null,"SQUARE YARDS","SQY"]
[null,"CENTI METERS             ",{"$nulls":11},"WEST BENGAL",19,null,null,"TABLETS","TBS"]
[null,"CARTONS",{"$nulls":11},"OTHER TERRITORY",97,null,null,"TEN GROSS","TGM"]
[null,"DOZENS                   ",{"$nulls":11},"OTHER COUNTRIES",99,null,null,"THOUSANDS","THD"]
[null,"DRUMS",{"$nulls":15},"TONNES","TON"]
[null,"GREAT GROSS",{"$nulls":15},"TUBES","TUB"]
[null,"GRAMMES",{"$nulls":15},"US GALLONS","UGS"]
[null,"GROSS",{"$nulls":15},"UNITS","UNT"]
[null,"GROSS YARDS",{"$nulls":10},"Reg",{"$nulls":4},"YARDS","YDS"]
[null,"KILOGRAMS",{"$nulls":10},"UnReg"]
[null,"KILOLITRE",{"$nulls":11},"Tax Invoice","INV"]
[null,"KILOMETRE",{"$nulls":10},"Intra","Bill of Supply","BIL"]
[null,"LITRES",{"$nulls":10},"Inter","Bill of Entry","BOE"]
[null,"MILILITRE",{"$nulls":11},"Delivery Challan","CHL"]
[null,"METERS                   ",{"$nulls":11},"Others","OTH"]
[null,"METRIC TON"]
[null,"NUMBERS",{"$nulls":9},"Inward","I"]
[null,"OTHERS",{"$nulls":9},"Outward","O"]
[null,"PACKS"]
[null,"PIECES"]
[null,"PAIRS                    "]
[null,"QUINTAL",{"$nulls":9},"Supply",1]
[null,"ROLLS",{"$nulls":9},"Import",2]
[null,"SETS",{"$nulls":9},"Export",3]
[null,"SQUARE FEET",{"$nulls":9},"Job Work",4]
[null,"SQUARE METERS",{"$nulls":9},"For Own Use",5,"Tax Invoice"]
[null,"SQUARE YARDS",{"$nulls":9},"Job work Returns",6,"Bill of Supply",null,"Regular","R"]
[null,"TABLETS",{"$nulls":9},"Sales Return",7,"Bill of Entry",null,"ODC","O"]
[null,"TEN GROSS",{"$nulls":9},"Others",8,"Delivery Challan"]
[null,"THOUSANDS",{"$nulls":9},"SKD/CKD/Lots",9,"Others"]
[null,"TONNES                   ",{"$nulls":9},"Lines Sales",10]
[null,"TUBES",{"$nulls":9},"Recipient Not Known",11]
[null,"US GALLONS",{"$nulls":9},"Exhibition or Fairs",12]
[null,"UNITS"]
[null,"YARDS",{"$nulls":12},"Road",1]
[{"$nulls":14},"Air",3]
[{"$nulls":14},"Rail",2]
["State","ANDAMAN AND NICOBAR",{"$nulls":12},"Ship",4]
[null,"ANDHRA PRADESH"]
[null,"ARUNACHAL PRADESH"]
[null,"ASSAM"]
[null,"BIHAR",{"$nulls":11},"Bill of Supply"]
[null,"CHANDIGARH",{"$nulls":11},"Tax Invoice"]
[null,"CHHATTISGARH",{"$nulls":8},"Regular",1]
[null,"DADRA  AND NAGAR HAVELI",{"$nulls":8},"Bill To-Ship To",2,null,"Bill of Supply"]
[null,"DELHI",{"$nulls":8},"Bill From-Dispatch From",3,null,"Tax Invoice"]
[null,"GOA",{"$nulls":8},"Combination of 2 and 3",4]
[null,"GUJARAT",{"$nulls":11},"Delivery Challan"]
[null,"HARYANA"]
[null,"HIMACHAL PRADESH",{"$nulls":11},"Bill of Entry"]
[null,"JAMMU AND KASHMIR",{"$nulls":11},"Bill of Supply"]
[null,"JHARKHAND",{"$nulls":11},"Delivery Challan"]
[null,"KARNATAKA",{"$nulls":11},"Tax Invoice"]
[null,"KERALA",{"$nulls":11},"Delivery Challan"]
[null,"LAKSHADWEEP",{"$nulls":11},"Others"]
[null,"LADAKH"]
[null,"MADHYA PRADESH",{"$nulls":11},"Delivery Challan"]
[null,"MAHARASHTRA"]
[null,"MANIPUR",{"$nulls":11},"Delivery Challan"]
[null,"MEGHALAYA"]
[null,"MIZORAM",{"$nulls":11},"Delivery Challan"]
[null,"NAGALAND"]
[null,"ORISSA",{"$nulls":11},"Delivery Challan"]
[null,"PONDICHERRY",{"$nulls":11},"Others"]
[null,"PUNJAB"]
[null,"RAJASTHAN",{"$nulls":11},"Bill of Entry"]
[null,"SIKKIM"]
[null,"TAMIL NADU",{"$nulls":11},"Delivery Challan"]
[null,"TELANGANA"]
[null,"TRIPURA",{"$nulls":11},"Delivery Challan"]
[null,"UTTAR PRADESH"]
[null,"UTTARAKHAND"]
[null,"WEST BENGAL"]
[null,"OTHER TERRITORY"]
[null,"OTHER COUNTRIES"]
[]
[]
["Vehicle Type","Regular"]
[null,"ODC"]
[]
[]
["Transaction Type","Regular"]
[null,"Bill To-Ship To"]
[null,"Bill From-Dispatch From"]
[null,"Combination of 2 and 3"]

{"sheet":"Sample eWayBill","index":3,"n_rows":31,"n_cols":45,"rows_kept":31,"merged":[[0,1,1,3],[0,4,0,9],[0,15,1,16],[0,18,1,19],[1,5,1,7],[1,36,1,43],[12,2,12,4]]}
["Are you a",{"$nulls":3},"E - WAY BILL  SYSTEM"]
["GSTIN/Trans-porter ID:",{"$nulls":3},"Legal Name :",{"$nulls":3},"Address :",{"$nulls":3},"Place :",null,"State:",null,null,"Pin Code :",{"$nulls":18},"PART - B"]
["Supply Type *","Sub Type *","Doc Type *","Doc No *","Doc Date *","Transaction Type *","From_OtherPartyName","From_GSTIN *","From_Address1","From_Address2","From_Place","Dispatch_Pin Code *","Bill From_State *","Dispatch From_State *","To_OtherPartyName","To_GSTIN *","To_Address1","To_Address2","To_Place","Ship To_Pin Code *","Bill To_State *","Ship To_State *","Product","Description","HSN *","Unit","Qty","Assessable Value *","Tax Rate (S+C+I+Cess+Cess Non Advol)","CGST Amount","SGST Amount","IGST Amount","CESS Amount","CESS Non Advol Amount","Others","Total Invoice Value *","Trans Mode","Distance (Km) *","Trans Name","Trans ID","Trans DocNo","Trans Date","Vehicle No","Vehicle Type","Errors List"]
["Outward","Supply","Tax Invoice","1234","04/03/2017","Regular","AMBUJA CEMENTS LIMITED","29AAACG0569P1Z3","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","KARNATAKA","AMBUJA PVT LTD","37BZNPM9430M1KL","MG ROAD","MG ROAD","BANGALORE",522101,"ANDHRA PRADESH","ANDHRA PRADESH","STEEL","STEEL",26180000,"KILOGRAMS",{"v":56,"d":"56.00"},{"v":678,"d":"678.00"},"0+0+0.1+0+400",{"v":6102,"d":"6102.00"},{"v":6102,"d":"6102.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":12884,"d":"12884.00"},"Road",567,{"$nulls":3},"12/08/2018","KA12KA1234","Regular"]
["Inward","SKD/CKD/Lots","Bill of Supply","6789","04/03/2017","Regular","AMBUJA PVT LTD","URP","MG ROAD","MG ROAD","BANGALORE",560090,"KARNATAKA","KARNATAKA","AMBUJA CEMENTS LIMITED","29AAACG0569P1Z3","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","KARNATAKA","STEEL","STEEL",26180000,"KILOGRAMS",{"v":56,"d":"56.00"},{"v":678,"d":"678.00"},"0.125+0.125+0+1+2076",{"v":6102,"d":"6102.00"},{"v":6102,"d":"6102.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":12884,"d":"12884.00"},"Road",567,{"$nulls":3},"12/08/2018","KA12KA1234","ODC"]
["Outward","Job Work","Delivery Challan","560099","03/03/2017","Regular","AMBUJA CEMENTS LIMITED","29AAACG0569P1Z3","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","KARNATAKA","SRI SAI SUPER MARKET","29ACEFS6707L1ZL","BY ROAD","BY ROAD","BANTWAL",560090,"KARNATAKA","KARNATAKA","IRON","IRON",26011112,"KILOGRAMS",{"v":67,"d":"67.00"},{"v":345,"d":"345.00"},"0.05+0.05+0+12.5+400",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":6210,"d":"6210.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"v":13116,"d":"13116.00"},"Rail",456,"BKP LTD",null,4567898,"15/11/2017"]
["Outward","Job Work","Delivery Challan","560099","03/03/2017","Regular","AMBUJA CEMENTS LIMITED","29AAACG0569P1Z3","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","KARNATAKA","SRI SAI SUPER MARKET","29ACEFS6707L1ZL","BY ROAD","BY ROAD","BANTWAL",560090,"KARNATAKA","KARNATAKA","IRON PYRITES","IRON PYRITES",26011290,"KILOGRAMS",{"v":67,"d":"67.00"},{"v":345,"d":"345.00"},"0.05+0.05+0+12.5+400",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":6210,"d":"6210.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"v":13116,"d":"13116.00"},"Rail",456,"BKP LTD",null,4567898,"15/11/2017"]
["Inward","Import","Bill of Entry","34565","01/05/2018","Bill From-Dispatch From","LAKSHMI PVT LTD","URP","KG ROAD","KG ROAD","BANGALORE",560090,"OTHER COUNTRIES","KARNATAKA","AMBUJA CEMENTS LIMITED","29AAACG0569P1Z3","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","KARNATAKA","IRON PYRITES","IRON PYRITES",1001,"KILOGRAMS",{"v":30,"d":"30.00"},{"v":250,"d":"250.00"},"0+0+12+12.5+4006",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":6210,"d":"6210.00"},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":6465,"d":"6465.00"},null,100,null,"29AAACG0569P1Z3"]
[]
[]
[]
[]
[null,null,"Explaination for above Entries."]
[1,"This has sample e-way bill requests. It has 5 records, but 4 e-way bill requests"]
[]
[2,"Row 6 and 7  belong to one e-way bill request. This request has 2 products under one invoice. "]
[null,"You can see that all columns repeat except the product related columns"]
[]
[3,"Row 8 belong to one e-way bill request being requested with Part A slip."]
[]
[4,"To simplify the data entry, 5 values of tax rates are taken in one column"]
[null,"Tax rate (S+C+I+Cess+Cess Non Advol) indicates SGST + CGST + IGST + CESS + CESS Non Advol"]
[]
[5,"First 2 requests do not have 'Trans Name' related details. It indicates that consignor is only "]
[null,"moving the goods"]
[]
[6,"When the tax payer is pulling the data from his automated system, he should see the format"]
[null,"and field specification given in Welcome sheet and prepare the data in that fashion."]
[]
[7,"The tax payer should also use the master data given in Master Codes sheet while"]
[null,"preparing the data to avoid the error while validating"]

{"sheet":"FAQ's","index":4,"n_rows":66,"n_cols":11,"rows_kept":66}
[null,"Frequently Asked Questions "]
[]
["1)","What are the different transaction types ?"]
["Solution:","There are four types of ‘Bill To – Ship To’ transactions. These types depend upon the number of parties involved in the billing and movement of the goods. The following paras explain the same."]
[null,"Regular: This is a regular or normal transaction, where Billing and goods movement are happening between two parties - consignor and consignee. That is, the Bill and goods movement from consignor to consignee takes place directly."]
[null,"Bill To – Ship To: In this type of transaction, three parties are involved. Billing takes place between consignor and consignee, but the goods move from consignor to the third party place as per the request of the consignee."]
[null,"Bill From – Dispatch From: In this type of transaction also, three parties are involved. Billing takes places between consignor and consignee, but the goods are moved by the consignor from the third party place to the consignee."]
[null,"Combination of both: This is the combination of above two transactions and involves four parties. Billing takes places between consignor and consignee, but the goods are moved by the consignor from the third party place to the fourth party place, as per the consignee’s request."]
[]
["2)","How to enter the cess non advol rate?"]
["Solution:","Cess non advol rate is in rupees and needs to be calculated for the total quantity and entered in Cess Non advol column."]
[]
["3)","What if i have transportation charges?"]
["Solution:","Transportation charges has to be enterd in other charges."]
[]
["4)","What types of outward supplies are treated at EXPORTS?"]
["Solution:","The following types of outward Supplies are considered as EXPORTS"]
[null,"EXPORT and "]
[null,"CKD/SKD/LOTS, where billing to ‘SEZ unit’ or ‘URP’ with state code as ‘Other Country’"]
[]
["5)","What types of inward supplies are treated at IMPORTS?"]
["Solution:","The following types of inward Supplies are considered as IMPORTS"]
[null,"IMPORT and "]
[null,"CKD/SKD/LOTS, where billing from ‘SEZ unit’ or ‘URP’ with state code as ‘Other Country’"]
[]
["6)","Can I generate a part A slip?"]
["Solution:","Yes, you can generate Part A slip with out Part B details,  but Transporter ID is mandatory."]
[]
["7)","What happens if the Pincode is not matcing with the state code?"]
["Solution:","System will throw an error saying Invalid Pincode for the state code, hence pass valid pincode with respective state code in the JSON."]
[]
["8)","What should I do if the discount has been given in the invoice?"]
["Solution:","Enter the discount value in Other charges with a negative sign."]
[]
["9)","What happens if I pass the wrong Tax Rates?"]
["Solution:","System will throw an error message saying Invalid Tax Rates, for valid Tax Rates please refer the Table 1 in the Validation sheet."]
[]
["10)","Are negative value  allowed in the Other charges?"]
["Solution:","Yes, Negative values are allowed in the Other charges."]
[]
["11)","I get Invalid document type for the given supply type error, How to resolve this issue?"]
["Solution:","Refer  Table 2 in the Validation sheet and pass  the corresponding document type with the sub type."]
[]
["12)","I get Type mismatch -Runtime error 13 while generating JSON file, how should I proceed ? "]
["Solution:","This error may occur if the Supply Type or Sub Type or Doc Type or From_State  or To_State  or  Unit  or Trans Mode from the dropdowns  is not selected as provided in the corresponding columns. So, select from the drop down or enter the values as mentioned in the master."]
[]
["13)","I get Validation failed for vehicle number even though I have entered the correct vehicle number, how to resolve this ?",{"$nulls":8},"KA 12 KA 1234"]
["Solution:","Please enter the vehicle number in the format specified without any spaces."]
[]
["14)","I get Invalid Doc Date?"]
["Solution:","Please enter the Document Date in the format of  dd/mm/yyyy"]
[]
["15)","What to do if I get Invalid TaxRate error ?"]
["Solution:","Please enter TaxRate in the format of  SGST+CGST+IGST+Cess+Cess Non Advol for example (1+1+0+1+1)"]
[]
["16)","If the dealer is Unregistered , then which GSTIN should we enter?"]
["Solution:","If the dealer is Unregistered ,then Please enter the value as   URP."]
[]
["17)","If we are Transporting the goods to some other country or receiving the goods from some other country , then which state and PINCode should we mention?"]
["Solution:","If you are Transporting the goods to other country or receiving from other country , then mention  'Other Countries' as state  and 999999  as PinCode."]
[]
["18)","I get the error 'Invalid To_GSTIN', how to proceed ?"]
["Solution:","When you are the tax payer, then you will be one of the parties in the e-way bill system. This error occurs if your GSTIN is not entered correctly in To_GSTIN for Inward type of transaction OR for Outward type of transaction, the GSTIN is not valid."]
[]
["19)","I get the error 'Invalid  From_GSTIN', how to proceed ?"]
["Solution:","When you are the tax payer, then you will be one of the parties in the e-way bill system. This error occurs if your GSTIN is not entered correctly in From_GSTIN for Outward type of transaction OR for Inward type of transaction, the GSTIN is not valid."]

{"sheet":"Validation","index":5,"n_rows":48,"n_cols":10,"rows_kept":48,"merged":[[0,3,0,7],[1,3,1,7],[4,7,11,7],[16,3,16,7],[18,1,18,3],[18,4,18,6],[18,7,18,8],[18,9,18,11],[19,0,33,0],[19,1,20,3],[19,4,19,6],[19,7,19,8],[19,9,19,11],[20,4,20,6],[20,7,20,8],[20,9,20,11],[21,1,22,3],[21,4,21,6],[21,7,21,8],[21,9,21,11],[22,4,22,6],[22,7,22,8],[22,9,22,11],[23,1,23,3],[23,4,23,6],[23,7,23,8],[23,9,23,11],[24,1,26,3],[24,4,24,6],[24,7,24,8],[24,9,24,11],[25,4,25,6],[25,7,25,8],[25,9,25,11],[26,4,26,6],[26,7,26,8],[26,9,26,11],[27,1,28,3],[27,4,27,6],[27,7,27,8],[27,9,27,11],[28,4,28,6],[28,7,28,8],[28,9,28,11],[29,1,29,3],[29,4,29,6],[29,7,29,8],[29,9,29,11],[30,1,30,3],[30,4,30,6],[30,7,30,8],[30,9,30,11],[31,1,31,3],[31,4,31,6],[31,7,31,8],[31,9,31,11],[32,1,33,3],[32,4,32,6],[32,7,32,8],[32,9,32,11],[33,4,33,6],[33,7,33,8],[33,9,33,11],[35,0,47,0],[35,1,36,3],[35,4,35,6],[35,7,35,8],[35,9,35,11],[36,4,36,6],[36,7,36,8],[36,9,36,11],[37,1,37,3],[37,4,37,6],[37,7,37,8],[37,9,37,11],[38,1,41,3],[38,4,38,6],[38,7,38,8],[38,9,38,11],[39,4,39,6],[39,7,39,8],[39,9,39,11],[40,4,40,6],[40,7,40,8],[40,9,40,11],[41,4,41,6],[41,7,41,8],[41,9,41,11],[42,1,42,3],[42,4,42,6],[42,7,42,8],[42,9,42,11],[43,1,43,3],[43,4,43,6],[43,7,43,8],[43,9,43,11],[44,1,44,3],[44,4,44,6],[44,7,44,8],[44,9,44,11],[45,1,45,3],[45,4,45,6],[45,7,45,8],[45,9,45,11],[46,1,47,3],[46,4,46,6],[46,7,46,8],[46,9,46,11],[47,4,47,6],[47,7,47,8],[47,9,47,11]]}
[{"$nulls":3},"Table 1:  Validation of tax rates while generating the e-way bill."]
[{"$nulls":3},"Following Tax Rates are applicable as on 1st October."]
[]
[{"$nulls":3},"CGST\n(%)","SGST (%)"," IGST (%) ","CESS – Advol (%) ","CESS - NonAdvol. (Rs.)"]
[{"$nulls":3},0,0,0,"0 or 1 or 3 or 5 or","0  or \n400  or\n2076  or\n2747  or\n3668  or\n4006  or\n4170 \n"]
[{"$nulls":3},0.05,0.05,0.1," 11 or 12 or  12.5 or"]
[{"$nulls":3},0.125,0.125,0.25," 15 or 17 or 20 or 21"]
[{"$nulls":3},1.5,1.5,3," or 22 or 36 or 49 or"]
[{"$nulls":3},2.5,2.5,5," 60 or 61 or 65 or 71"]
[{"$nulls":3},6,6,12," or 72 or 89 or 96 or"]
[{"$nulls":3},9,9,18," 142 or 160 or 204 or"]
[{"$nulls":3},14,14,28,290]
[{"$nulls":3},0.25,0.25,0.5]
[]
[]
[{"$nulls":4},"Table 2:  Validating the Supply Type with Document Type."]
[{"$nulls":3},"Following Supply-Document Types are applicable as on 1st October."]
[]
["Supply Type","Sub Supply Type",null,null,"Document Type",null,null,"From GSTIN (Supplier)",null,"To GSTIN (Buyer)"]
["Outward","Supply",null,null,"Tax Invoice",null,null,"Self",null,"Other GSTIN /URP"]
[{"$nulls":4},"Bill of Supply",null,null,"Self",null,"Other GSTIN /URP"]
[null,"Export",null,null,"Tax Invoice",null,null,"Self",null,"URP"]
[{"$nulls":4},"Bill of Supply",null,null,"Self",null,"URP"]
[null,"Job Work",null,null,"Delivery Challan",null,null,"Self",null,"Other GSTIN/URP"]
[null,"SKD/CKD",null,null,"Tax Invoice",null,null,"Self",null,"Other GSTIN /URP"]
[{"$nulls":4},"Bill of Supply",null,null,"Self",null,"Other GSTIN /URP"]
[{"$nulls":4},"Delivery Challan",null,null,"Self",null,"Other GSTIN /URP"]
[null,"Recipient not known",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[{"$nulls":4},"Others",null,null,"Self",null,"Self"]
[null,"For own Use",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[null,"Exhibition or fairs",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[null,"Line Sales",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[null,"Others",null,null,"Delivery Challan",null,null,"Self",null,"Self/Other"]
[{"$nulls":4},"Others",null,null,"Self",null,"Self/Other"]
[]
["Inward","Supply",null,null,"Tax Invoice",null,null,"Other GSTIN /URP",null,"Self"]
[{"$nulls":4},"Bill of Supply",null,null,"Other GSTIN /URP",null,"Self"]
[null,"Import",null,null,"Bill of Entry",null,null,"URP",null,"Self"]
[null,"SKD/CKD",null,null,"Bill of Entry",null,null,"URP",null,"Self"]
[{"$nulls":4},"Tax Invoice",null,null,"Other GSTIN /URP",null,"Self"]
[{"$nulls":4},"Bill of Supply",null,null,"Other GSTIN /URP",null,"Self"]
[{"$nulls":4},"Delivery Challan",null,null,"Other GSTIN /URP",null,"Self"]
[null,"Job Work Returns",null,null,"Delivery Challan",null,null,"Other GSTIN /URP",null,"Self"]
[null,"Sales Return",null,null,"Delivery Challan",null,null,"Other GSTIN /URP",null,"Self"]
[null,"Exhibition or fairs",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[null,"For Own Use",null,null,"Delivery Challan",null,null,"Self",null,"Self"]
[null,"Others",null,null,"Delivery Challan",null,null,"Self/Other",null,"Self"]
[{"$nulls":4},"Others",null,null,"Self/Other",null,"Self"]