E way bill Format in pdf and Excel Download

You can download the e way bill format in pdf and excel file from here. The pdf format can be used for offline purposes only. Hence, one can not use it for the movement of goods from one place to another. Whereas an excel e way bill format can be used to fillup vehicle and goods details. The excel tool is also known as the bulk e way bill generation tool. Learn below the difference between these formats.

Read: How to print e way bill in pdf format?

What is Excel E way bill generation tool?

The excel e way bill generation tool is an offline road permit utility under GST.  A taxpayer can use this utility to add supply information in an excel file and generate e waybill.

Download the excel waybill template and start doing e way bill excel upload in a single shot. This e way bill offline tool will generate a JSON file of all entries in an excel template. It consists of the excel way bill generation tool 1.0.0219 version. Type in the search box as excel e-way bill generation tool download or e way bill JSON file download.

Also, you may type e way bill json format download, e way bill offline tool, e waybill converter tool, e waybill excel format, e-way bill json preparation tool and e-way bill system (offline tool).

Therefore use this utility to convert excel data into JSON file only. JSON file has to be uploaded on the eway bill portal. Also, this utility is useful if you have a large number of invoices to generate eway bill.

Who can use the excel e way bill generation tool?

E way bill is an important tool for those, who want to prepare e way bill generation data in offline mode.   Therefore, this excel utility will help you to prepare json file from your excel file.   Once you upload this JSON file on e way bill portal you can generate e way bill within minutes.  There is no need for internet connectivity to prepare this excel file ready.  However, you need an internet connection to upload the generated json file.

Advantages of e way bill offline tool

  • You can enter multiple invoices data in this excel tool to generate e way bill
  • No need for ERP or any SAP software to generate e way bills for your business.
  • This offline tool works on any desktop pc and laptop.
  • No need of installing any third-party software to work in this tool
  • e way bill bulk upload will save time on entering data one by one on e way bill portal
  • This tool works in Microsoft Excel
  • You can use this e-way bill json preparation tool to generate multiple e way bills in one shot.

What activities excel e way bill generation tool can do?

The excel way bill generation tool can perform below activities:

  • It can generate number of e way bills in one shot.  Hence, one need not have to be online and enter details of for each e way bill.
  • One can update part B of  e way bill by using this offline excel tool for e way bill.
  • you can generate consolidated e way bill by using this excel to json tool.

This tool enables taxpayers to prepare bulk requests in two ways:

1]Taxpayer can do cut and paste activity to copy the records from his system records and past in this excel file.

2]Taxpayer may also add the records in this file one by one and make the excel file ready to generate JSON file later and upload on eway bill portal.  You may also see “Welcome” sheet” for more details about this utility.  Bulk e way bill generation tool download from below link.  The latest version updated on 02nd May 2019.

TypeDetails
Download Version
Bulk e way bill generation tool 1.0.0219You can use this excel tool to prepare JSON file, ready to upload on e way bill portal to generate e way bill .1.0.0219 (Latest)
Bulk e way bill generation tool 1.0.1118Previous version
1.0.1118
Bulk e way bill generation tool 1.0.0918 Previous version

1.0.0918
Consolidated E way bill JSON preparationUse this tool to generate JSON file for making consolidated e way bill.
1.0.0618
Vehicle No. updation JSON preparation file you can use this excel tool to create JSON file to update vehicle no. in e way bill.1.0.0123
Transporter updation JSON preparation toolThis tool can be used to Update Trans. ID. for Common enrolled transporter.1.0.0219
Transporter updation JSON preparation tool Previous version
1.0.0123

Bulk E-waybill generation tool(1.0.0219)

Download latest version of e way bill bulk upload tool to generate e way bill.   The above e way bill offline tool is the new version(1.0.0.219) released by e way bill system.   You should have latest version to generate e way bill so that system generate error free e-way bill.   The previous version of e way bill tools are 1.0.0618, and 1.0.1118.

How to prepare JSON file – Step by Step Guide?

1.Open the downloaded excel tool.

2.Click on “ewaybill” Sheet.

3.Enter all the mandatory fields as shown in the image step by step.

Download Bulk E way Bill Generation Tool pic

4. 5th step is to Prepare Json. Once your JSON file is ready,  Follow below steps to upload JSON file and generate e Way bill.

How to generate bulk e way bill by using Json File? – Step by step guide

1 . Visit to www.ewaybillgst.gov.in to open e way bill portal

2. Click on Login button on the left-hand side.

generate excel e way bill by using Json File steps

2. Fill In your user name, password, and captcha code. Click login to enter into e way bill portal.

3. you will see the e way bill portal dashboard. After successful validation of login credentials

4. Hover your mouse to the left-hand side of the screen to see the e way bill menu

5. Click on E way bill. click to select Generate Bulk option from the drop-down list.

How to prepare JSON file click to select Generate Bulk option

6. You will get to see below screen to upload JSON file, which you did generate by using Excel to json tool.

7. Click the browse button to select Json file.

How to generate bulk e way bill pic

8. Click “Upload”, “Generate” to generate e way bill

9. You will get to see below screen if your e way bill is successfully generated. Also if your JSON file contains errors or not generated due to an issue, the error will flash on the below screen.

Excel to Json converter JSON file contains errors window 734 x 221

10. Copy or note down the E way bill number and exit the above screen.

11. Go to the left-hand menu again. Under e way bill option select to print e way bill.

12. Provide e way bill number and hit enter to print the e way bill.

Bulk E way bill Generation Video

You can see the below video to create JSON file to generate e way bill on GST portal.

How to generate e way bill from tally?

One can generate e way bill from tally by generating JSON file first and then uploading it on E way bill portal to get e way bill print.

image how to make e way bill from tally

In other words, one has to generate JSON file which carries the sales invoice/purchase entry data to make e way bill. After tally generates json file, one has to upload it on E way bill portal to print e way bill. Thus, you can not generate e way bill ready to carry with vehicle in tally itself.

Therefore, here is how to make json file in tally first, and then upload it to on e way bill portal to generate and print e way bill. The advantage of generating json file in tally is that, one need not have to enter invoice details again on e way bill portal to make e way bill. Here is the step by guide to make e way bill by using tally software.

Setup in Tally to activate E way bill Option

  1. Go to F11 > F3 > GST Details, from the Gateway of tally.
  2. Make the following settings:
    1. Choose your amount limit for transactions to which you can generate e-Way Bills.
    2. Applicable date from which you want to generate e way bill.
    3. Select Inter/ intra-state movements to generate e way bill.

E way bill Data in Sales/Purchase Invoice

1. Enter necessary invoice details like qty, rate, GST etc.

2. Select to choose “yes” under provide GST/e way bill details: option

image for e way bill in tally erp

3. Enter all mandatory details(*) in the window you see on the screen.

4. Save the Transaction.

5. Select “Export” transaction option

6. Choose “Format” JSON

image tally e way bill json export

7. Upload the generated JSON file on the E way bill portal. Follow our above steps “How to generate bulk e way bill by using Json File – Step by step guide” to generate e way bill by using json file. This is all about how to make e way bill in tally erp.

Latest Updates on Bulk E way bill Generation Tool

Above tool is always updated one and you need not have to search anywhere else for this tool.  We update it as soon it gets upload on e way bill portal.  Above latest tool includes following updates:

  1. If you have multiple items with same HSN code but with different description then you can add them now.
  2. A new column of Total Value in bulk e way bill generation tool is added. Therefore this column includes assessable amount, taxes and also other charges as mentioned in the invoice.

Kindly leave a comment, if you face any issue with this utility to generate bulk e way bill.

E way bill format in pdf

Below is the screenshot of the e way bill format as per the CGST rules 2017. You can download the complete format by clicking on the download button. This e way bill format shall be used only for reference purposes only. The hard document can not be used for the physical movement of goods. One has to generate e waybill on the e way bill portal only.

e way bill format image

How to save e way bill in pdf format?

Learn More:

4 thoughts on “E way bill Format in pdf and Excel Download

    1. Hello Inderlal
      We know many taxpayers are facing difficulties as they cannot print multiple e way bills at one shot. As per my understanding E way bill system has kept “one eway bill one print option” at one time, in order to reduce load/processing on server. i expect they will manage to give this option in nearby future.

Leave a Reply

Your email address will not be published. Required fields are marked *