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.

In this article, we cover the step-by-step process to be followed for Bulk Generation of e-way bills /consolidated e-way bills on the e-way bill portal.

Latest Updates

29th August 2021
From 1st May 2021 to 18th August 2021, the taxpayers will not face blocking of e-way bills for non-filing of GSTR-1 or GSTR-3B (two months or more for monthly filer and one quarter or more for QRMP taxpayers) for March 2021 to May 2021.

4th August 2021
Blocking of e-way bills due to non-filing of GSTR-3B resumes from 15th August 2021.

1st June 2021
1. The e-way bill portal, in its release notes, has clarified that a suspended GSTIN cannot generate an e-way bill. However, a suspended GSTIN as a recipient or as a transporter can get a generated e-way bill.
2. the mode of transport ‘Ship’ has now been updated to ‘Ship/Road cum Ship’ so that the user can enter a vehicle number where goods are initially moved by road and a bill of lading number and date for movement by ship. This will help in availing the ODC benefits for movement using ships and facilitate the updating of vehicle details as and when moved on road.

18th May 2021
The CBIC in Notification 15/2021-Central Tax has notified that the blocking of GSTINs for e-Way Bill generation is now considered only for the defaulting supplier’s GSTIN and not for the defaulting recipient or the transporter’s GSTIN.

The prerequisites for bulk generation

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

• Registration on the e-Way Bill portal
• You should have the Invoice/ Bill/ Challan related to the consignment of goods.
• Transporter ID or the Vehicle number (for transport by road).
• Transporter ID, Transporter document number, and date on the document (for transport by rail, air, or ship).
• 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.
• 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

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:

Step-1: Download the JSON template- “E-Way Bill JSON Format” / “Consolidated E-Way Bill JSON Format” file

Step-2: Update the downloaded file with the requisite details. The file in JSON is ready for upload.

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!

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.

Related Articles

• 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