The e-Way Bill Portal (EWB) provides its users the option to bulk upload the master data on to their system. This can be done for either of the four cases that are – Product Master, Registered Supplier/Client Master, Unregistered Supplier/Client Master or Transporter Master. In order to upload the master’s in the bulk format, the user must first download the JSON tool from the EWB Portal. Therefore, the users can prepare the JSON file with the required details and upload them on the EWB portal.
Steps to Download Master JSON Tool to Create Master data
- Visit the EWB portal
Visit the e-Way Bill Portal. Navigate to the dashboard and select Help > Tools > Bulk Generation Tools
- JSON preparation tools
Hence, scroll down to the “JSON Preparation Tools” section and download the “Master JSON Preparation” tool.
The four different masters require different types of details in the excel sheet. Therefore, after opening the excel sheet, toggle to the other sheets that are named Products, Clients, Suppliers, and Transporters and enter the required details.
In Case of Creating Master Products
The details required are as follows:
In Case of Master Clients/Suppliers
If the individual is a registered GST user, the details required are as such:
- GST Registered (Enter Registered in the respective field)
- GSTIN
- Approximate Distance
If the individual is not a GST registered user, the details required are as such:
- Unregistered GST (Enter Unregistered in the respective field)
- Legal Name
- Address
- Place
- PIN Code
- Mobile Number
- e-Mail ID
- State
- Approximate Distance
In Case of Master Transporter
In the case of the master transporter, the details required are as such:
- Transporter ID
- Transporter Name
- Mobile Number
- e-Mail ID
- Address
- Place
- PIN Code
- State
Once the details are filled in the respective sheets, click on the validate option to complete the validation process.
Therefore, once the validation process is complete, click on the “Prepare JSON” option located in the sheet.
Hence, upload the JSON tool on the EWB portal to bulk create the master data for the respective sections.
FAQs
Yes, you can upload your customers, suppliers, and product details into the e-Way bill system by preparing the data as per the format provided in the tools option in the portal and upload in the master option after logging in.
e-Way bill system has an option to enter the masters of user – client master, supplier master, transporter master, and product master. If the user creates these masters, it will simplify the generation of e-Way bill for them. That is, the system auto-populates the details like trade/legal name, GSTIN, address on typing a few characters of client or supplier, HSN Code, tax rates, etc.
Presently taxpayer generates invoices from his IT system and logs into e-Way bill system and enters e-Way bill requests and generates e-Way bills. Here, the taxpayer has to make double entries – one for Invoice generation in his system and second for e-way bill generation. If he integrates an API interface with his system to e-Way bill system, he can avoid this. That is, he can avoid duplicate entry of invoice details for e-way bill generation. He can save the manpower cost of the operator for this purpose. Secondly API interface will eliminate data entry mistakes/errors being made by the operator. It also saves time. Thirdly e-way bill number can be stored by the taxpayer system in his database with the corresponding invoice.
Hey @ViraajAhuja47
Yes. All the registered persons under GST must register on the portal of e-way bill using their GSTIN. Once GSTIN is entered, the system sends an OTP to the registered mobile number, registered with GST Portal and after authenticating the same, the system enables you to generate your username and password for the e-way bill system.
After the generation of the username and password of your choice, you may proceed to make entries to generate an e-way bill.
Hope this helps!
Hey @TeamQuicko
How is the validity of the e-way bill calculated?
Hey @HarshitShah
The validity period of the e-Way Bill is calculated on the basis of ‘approx. distance’ entered while generating the e-Way Bill. For every 100 KM, one day is a validity period for the e-Way Bill as per rule and for part of 100 KM, one more day is added. For example, If approx. distance is 410KMs then the validity period is 4+1 days.