{"text_format":"5","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","eWayBill","Master Codes","Sample eWayBill","FAQ's"],"props":{"title":"29AAACG0569P1Z3","creator":"owner","last_modified_by":"Aibs"},"defined_names":["Clients","codes","Doc_No","I","Inward","look_dis","look_dtyp","look_st","look_subtyp","look_trmd","look_type","O","OtherPartyNm","Outward","PreNmClient","PreNmSup","ProdName","Product","Product_Desc","Products","State_Name","States","Supplier","Transporter","Type","units"],"not_rendered":{"images":19,"macros":1,"defined_names":26},"read":"whole","wrapped":"gz","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":64,"n_cols":7,"rows_kept":64}
{"$rows_empty":24}
[{"$nulls":3},"Ewaybill  Specification"]
[]
[null,"Column Name","Type","Description","Column Value","Mandatory Column"]
[null,"Supply Type","Text (7)","Supply whether it is outward/inward","Refer Master codes","Yes"]
[null,"Sub Type","Text(10)","Sub types of Supply","Refer Master codes","Yes"]
[null,"Doc Type","Text(10)","Document Type","Refer Master codes","Yes"]
[null,"Doc No","Text(20)","Document Number",78656,"Yes"]
[null,"Doc Date","Text(10)","Document Date","2017-10-12","Yes"]
[null,"From_OtherPartyName","Text(50)","LegalName of consignor","Ambuja Private Ltd","No"]
[null,"From_GSTIN","Text(15)","GSTIN of the Consignor","29AAACG0569P1Z3","Yes"]
[null,"From_Address1","Text(100)","Address of consignor - Line 1","BEML ROAD","No"]
[null,"From_Address2","Text(100)","Address of consignor - Line 2","KG ROAD","No"]
[null,"From_Place","Text(100)","Place of consignor","BANGALORE","No"]
[null,"From_Pin Code","Number(6)","Pincode of consignor",560090,"Yes"]
[null,"From_State","Text(50)","State of consignor","Refer Master codes","Yes"]
[null,"To_OtherPartyName","Text(50)","LegalName of consignee","HUKKERI PVT LTD","No"]
[null,"To_GSTIN","Text(15)","GSTIN of consignee","URP","Yes"]
[null,"To_Address1","Text(100)","Address of consignee - Line 1","VIDYARANYAPUR ROAD","No"]
[null,"To_Address2","Text(100)","Address of consignee- Line 2","MG ROAD","No"]
[null,"To_Place","Text(50)","Place of consignee","BANGALORE","No"]
[null,"To_Pin Code","Text(50)","Pincode of the consignee",560090,"Yes"]
[null,"To_State","Text(50)","State of the consignee","Refer Master codes","Yes"]
[null,"Product","Text(50)","Name of the Product","IRON","No"]
[null,"Description","Text(50)","Description of the Product","IRON PYRITES","No"]
[null,"HSN","Number(8)","HSN Code of the Product",1005,"Yes"]
[null,"Unit","Text(50)","Unit of the Product","Refer Master codes","No"]
[null,"Qty","Number(20)","Quantity of Product",12,"No"]
[null,"Assessable Value","Number(5)","Assessable Value",31,"Yes"]
[null,"Tax Rate (S+C+I+Cess)","Text(10)","Tax Rate(SGST+CGST+IGST+CESS)","5+5+0+6","No"]
[null,"CGST Amount","Number(5)","CGST Amount",7,"No"]
[null,"SGST Amount","Number(5)","SGST Amount",8,"No"]
[null,"IGST Amount","Number(5)","IGST Amount",9,"No"]
[null,"CESS Amount","Number(5)","CESS Amount",10,"No"]
[null,"Trans Mode","Text(10)","Mode of transportation","Refer Master codes","Yes"]
[null,"Distance (Km)","Number(5)","Distance of transportation",80,"Yes"]
[null,"Trans Name","Text(25)","Transporter Name","TAKRE PVT LTD","No"]
[null,"Trans ID","Text(15)","Transporter Id","28ASDRF0767H1V4","Conditional","Mandatory if Trans mode is Road and Vehicle number is not entered"]
[null,"Trans DocNo","Text(20)","Transporter Document Number",4567,"Conditional","Mandatory if Trans mode is Rail/Air/Ship"]
[null,"Trans Date","Text(10)","Transporter Doc Date","2018-01-01","Yes"]
[null,"Vehicle No","Text(10)","Vehicle Number","KA12KA1234          OR\nKA12K1234             OR   \nKA123456                OR\nKAR1234                  OR              KA123K1234           OR \nKA12KAR1234        OR   DFXXXXXX               OR         TRXXXXXX            ","Condiional","Mandatory if Mode of transportation is Road and TransId is not entered "]

{"sheet":"eWayBill","index":1,"n_rows":3,"n_cols":38,"rows_kept":3,"merged":[[0,1,1,3],[0,4,0,9],[0,15,1,16],[0,18,1,19],[0,20,1,36],[1,5,1,7],[2,38,2,16383],[3,38,1048575,16383]]}
["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,"* Indicates Mandatory columns",null,"Place :",null,"State: *",null,null,"Pin Code : *"]
["Supply Type *","Sub Type *","Doc Type *","Doc No *","Doc Date *","From_OtherPartyName","From_GSTIN *","From_Address1","From_Address2","From_Place","From_Pin Code *","From_State *","To_OtherPartyName","To_GSTIN *","To_Address1","To_Address2","To_Place","To_Pin Code *","To_State *","Product","Description","HSN *","Unit","Qty","Assessable Value *","Tax Rate (S+C+I+Cess)","CGST Amount","SGST Amount","IGST Amount","CESS Amount","Trans Mode *","Distance (Km) *","Trans Name","Trans ID","Trans DocNo","Trans Date *","Vehicle No","Errors List"]

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

{"sheet":"Sample eWayBill","index":3,"n_rows":29,"n_cols":38,"rows_kept":29,"merged":[[0,1,1,3],[0,4,0,9],[0,15,1,16],[0,18,1,19],[0,20,1,36],[0,38,1048575,16383],[1,5,1,7],[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 :"]
["Supply Type","Sub Type","Doc Type","Doc No","Doc Date","From_OtherPartyName","From_GSTIN","From_Address1","From_Address2","From_Place","From_Pin Code","From_State","To_OtherPartyName","To_GSTIN","To_Address1","To_Address2","To_Place","To_Pin Code","To_State","Product","Description","HSN","Unit","Qty","Assessable Value","Tax Rate (S+C+I+Cess)","CGST Amount","SGST Amount","IGST Amount","CESS Amount","Trans Mode","Distance level (Km)","Trans Name","Trans ID","Trans DocNo","Trans Date","Vehicle No","Errors List"]
["Outward","Supply","Tax Invoice ","1234","2017-03-04","HUKKERI PVT LTD","29BQSPA3829E124","OLD AIRPORT ROAD","OLD AIRPORT ROAD","BANGALORE",560090,"KARNATAKA","AMBUJA PVT LTD","29AAACG0569P1Z3","MG ROAD","MG ROAD","BANGALORE",560090,"KARNATAKA","STEEL","STEEL",26180000,"KILO GRAMS",{"v":56,"d":"56.000"},{"v":678,"d":"678.000"},"9+9+0+0",{"v":6102,"d":"6102.000"},{"v":6102,"d":"6102.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},"Road",567,{"$nulls":4},"KA12KA1234"]
["Inward","SKD/CKD","Bill of Supply","6789","2017-03-04","AMBUJA PVT LTD","29AAACG0569P1Z3","MG ROAD","MG ROAD","BANGALORE",560090,"KARNATAKA","HUKKERI PVT LTD","29BQSPA3829E124","OLD AIRPORT ROAD",null,"BANGALORE",560090,"KARNATAKA","STEEL","STEEL",26180000,"KILO GRAMS",{"v":56,"d":"56.000"},{"v":678,"d":"678.000"},"9+9+0+0",{"v":6102,"d":"6102.000"},{"v":6102,"d":"6102.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},"Road",567,{"$nulls":4},"KA12KA1234"]
["Outward","Job Work","Challan","560099","2017-03-03","HUKKERI PVT LTD","29BQSPA3829E124","OLD AIRPORT ROAD","OLD AIRPORT ROAD","BANGALORE",560090,"KARNATAKA","SRI SAI SUPER MARKET","29ACEFS6707L1ZL","BY ROAD","BY ROAD","BANTWAL",456765,"KERALA","IRON","IRON",26011112,"KILO GRAMS",{"v":67,"d":"67.000"},{"v":345,"d":"345.000"},"0+0+18+0",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":6210,"d":"6210.000"},{"v":0,"d":"0.000"},"Road",456,"BKP LTD","29AAACG8723H1ZG",4567898,"2017-11-15","KA123456"]
["Outward","Job Work","Challan","560099","2017-03-03","HUKKERI PVT LTD","29BQSPA3829E124","OLD AIRPORT ROAD","OLD AIRPORT ROAD","BANGALORE",560090,"KARNATAKA","SRI SAI SUPER MARKET","29ACEFS6707L1ZL","BY ROAD","BY ROAD","BANTWAL",456765,"KERALA","IRON PYRITES","IRON PYRITES",26011290,"KILO GRAMS",{"v":67,"d":"67.000"},{"v":345,"d":"345.000"},"0+0+18+0",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":6210,"d":"6210.000"},{"v":0,"d":"0.000"},"Road",456,"BKP LTD","29AAACG8723H1ZG",4567898,"2017-11-15","KA123456"]
[]
[]
[]
[]
[]
[null,null,"Explaination for above Entries."]
[1,"This has sample e-way bill requests. It has 4 records, but 3 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,"To simplify the data entry, 4 values of tax rates are taken in one column"]
[null,"Tax rate (S+C+I+Cess) indicates SGST + CGST + IGST + CESS"]
[]
[4,"First 2 requests do not have 'Trans Name' related details. It indicates that consignor is only "]
[null,"moving the goods"]
[]
[5,"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."]
[]
[6,"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":24,"n_cols":11,"rows_kept":24}
[null,"Frequently Asked Questions "]
["1)","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"]
[]
["2)","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"]
[]
["3)","I get Invalid Doc Date?"]
["Solution:","Please enter the Document Date in the format of  dd/mm/yyyy"]
[]
["4)","What to do if I get Invalid TaxRate error ?"]
["Solution:","Please enter TaxRate in the format of  SGST+CGST+IGST+Cess for example (1+1+2+0)"]
[]
["5)","If the dealer is Unregistered , then which GSTIN should we enter?"]
["Solution:","If the dealer is Unregistered ,then Please enter the value as   URP"]
[]
["6)","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"]
[]
["7)","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"]
[]
["8)","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"]