Bytes - Your weekly dose of
investments, taxes, finance & more.

IT Portal 2.0

IT Portal 2.0

Check out the latest videos explaining the various features of the new portal
previous arrow
next arrow

e-Way Bill Portal : Create Masters In Bulk

author portrait

Maharshi Shah

Client Master
e-Way Bill Portal
EWB Bulk Masters
EWB Masters
Product Master
Supplier Master
Transporter Master
Last updated on April 23rd, 2021

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

  1. Visit the EWB portal

    Visit the e-Way Bill Portal. Navigate to the dashboard and select Help > Tools > Bulk Generation Toolse-Way Bill Portal - Dashboard

  2. JSON preparation tools

    Hence, scroll down to the “JSON Preparation Tools” section and download the “Master JSON Preparation” tool.e-Way Bill Portal - JSON Preparation Tools

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:

  1. Product Name
  2. Measuring Unit
  3. Description
  4. HSN Code
  5. CGST Rate
  6. SGST Rate
  7. IGST Rate
  8. Cess
  9. Cess Advol
e-Way Bill Portal - Bulk Product Master

In Case of Master Clients/Suppliers

If the individual is a registered GST user, the details required are as such:

  1. GST Registered (Enter Registered in the respective field)
  2. GSTIN
  3. Approximate Distance
e-Way Bill Portal - Bulk Client Master
New GST Registration
CA Assisted Goods & Service Tax (GST) registration for startups, individuals, partnership firms and companies.
[Rated 4.8 stars by customers like you]
New GST Registration
CA Assisted Goods & Service Tax (GST) registration for startups, individuals, partnership firms and companies.
[Rated 4.8 stars by customers like you]

If the individual is not a GST registered user, the details required are as such:

  1. Unregistered GST (Enter Unregistered in the respective field)
  2. Legal Name
  3. Address
  4. Place
  5. PIN Code
  6. Mobile Number
  7. e-Mail ID
  8. State
  9. Approximate Distance
e-Way Bill Portal - Bulk Supplier Master

In Case of Master Transporter

In the case of the master transporter, the details required are as such:

  1. Transporter ID
  2. Transporter Name
  3. Mobile Number
  4. e-Mail ID
  5. Address
  6. Place
  7. PIN Code
  8. State
e-Way Bill Portal - Bulk Transporter Master

Once the details are filled in the respective sheets, click on the validate option to complete the validation process.

e-Way Bill Portal - Validate

Therefore, once the validation process is complete, click on the “Prepare JSON” option located in the sheet.

e-Way Bill Portal - Prepare JSON

Hence, upload the JSON tool on the EWB portal to bulk create the master data for the respective sections.


Can I upload the masters available in my system?

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.

What masters have to be entered?

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.

What are the benefits of API Interface in e-Way bill ?

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.

Got Questions? Ask Away!

  1. 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!

  2. 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.