How to use Bulk Generation facility on the E way Bill portal?

Large-sized business houses or logistic operators having many consignments across the country on a single day to handle would prefer a simple and time-saving system where they generate all the required e-way bills or Update vehicle details by a single file upload.

This can be made possible by using the facility of Bulk generation of e-way bills on the e-way bills portal.

A bulk e-way bill option is used when a user needs to generate multiple e-Way Bills/ consolidated e-way bills/update multiple e-way bills in one shot by a single upload.

1.The prerequisites for bulk generation

Prerequisites to bulk generate e-Way Bills/consolidated e-Way Bills are:

1. Registration on the e-Way Bill portal
2. You should have the Invoice/ Bill/ Challan related to the consignment of goods.
3. Transporter ID or the Vehicle number (for transport by road).
4. Transporter ID, Transporter document number, and date on the document (for transport by rail, air, or ship).
5. You need the EWB JSON template or EWB bulk converter or the excel template , to be updated for the particulars at points laid down between 2 to 4.
6. If you are generating consolidated e-way bills then you  must have all the individual e-Way Bill numbers of the consignments, to be transported

2. How to prepare data for upload using templates?

Templates are available for following:

1. To bulk-generate Eway bills

2. To bulk-update vehicle details

1. To bulk-generate Eway bills

You can use either of the below two methods of preparing the data file for uploading on the portal to generate Bulk EWB :

Method 1:

Method 2:

Step-1: Download the excel template-“E-Way Bill JSON Format.xlsx” or “ Consolidated E-Way Bill JSON Format.xlsx”

Step-2: Download the converter tool-“ E-Way Bill converter tool.xlsm” or “Consolidated E-Way Bill converter tool.xlsm”

The tool helps convert the multiple e-Way Bills/Consolidated EWBs excel file into a single JSON file.

Step-3: Update the .xlsx file (excel template) with the requisite details.

Step-4: Use the .xlsm converter tool to convert the excel file into a JSON file.

The resulting file in JSON is ready for upload.

Which method to choose?

The second method i.e. using bulk converter tool to convert excel into JSON template is preferable over the first i.e. updating JSON template directly and using it. The reason being there is a validation that takes place when you convert the updated excel template into the JSON template, where any errors shall be reported to you for your corrections even before uploading the JSON file.

2. To bulk-update vehicle details

Download the ‘Vehicle No Updation JSON Preparation’ template from ‘Bulk Generation Tools’ available under ‘How to use’ from home page tabs.

Once the template is downloaded, fill up the details and validate the file by clicking on ‘Validate’ button in the excel file. After validating for any errors, Click on ‘Prepare JSON’. The JSON file is ready for use!

3.Steps to upload the filled-in template on the E-way Bill portal

1. For Bulk-generation

Once the updated JSON File is ready for upload, Following steps can be followed for generating single EWB or consolidated EWB:

Step 1: Login using the username, password and entering the captcha code.

Step 2: Select ‘ Generate bulk’ under ‘E-waybill ’ option or ‘ Consolidated EWB’ option as per your choice, appearing on the left-hand side of the dashboard.

OR

Step 3: Choose the saved JSON file from your system and click ‘Upload and Generate’

After processing the JSON file, the system generates EWBs in a list as depicted below:

You can copy the resulting listed E-Way bills numbers and date of generation and paste the same in a document saved on your system for further action.

Errors if any appear against each EWB entry. Make corrections accordingly and process it again.

2. For bulk-updation of vehicle details

Once the updated JSON File is ready for upload, Following steps can be followed for updating vehicle details:

Step-1: Select ‘Update Vehicle-Bulk’ under e-Waybill option on the dashboard

Step-2: Click on’ Choose File’ and Select the JSON file you want to upload.

Step-3: Click on ‘Generate’ to update the vehicle details for the Eway bills inputted through the JSON file.

Steps to download the EWB excel file/EWB JSON template/EWB bulk converter tool/Vehicle no Updation JSON Preparation:

Go to ‘How to use’ on login home page-> Select ‘Tools’     -> Click ‘Bulk generation Tools’

The Following screen appears:

Click on the desired file/format to Download.

For Further Reading and Understanding on the e-Way Bills:

• How to generate e-way bill on Website?
• Using SMS facility to generate/modify/cancel e-way bills
• Generation of consolidated e-Way Bills on the Website