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.
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.
|Bulk e way bill generation tool 1.0.0219
|You can use this excel tool to prepare JSON file, ready to upload on e way bill portal to generate e way bill .
|Bulk e way bill generation tool 1.0.1118
|Bulk e way bill generation tool 1.0.0918
|Consolidated E way bill JSON preparation
|Use this tool to generate JSON file for making consolidated e way bill.
|Vehicle No. updation JSON preparation file
|you can use this excel tool to create JSON file to update vehicle no. in e way bill.
|Transporter updation JSON preparation tool
|This tool can be used to Update Trans. ID. for Common enrolled transporter.
|Transporter updation JSON preparation tool
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(126.96.36.199) 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.
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.
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.
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.
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.
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.
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
- Go to F11 > F3 > GST Details, from the Gateway of tally.
- Make the following settings:
- Choose your amount limit for transactions to which you can generate e-Way Bills.
- Applicable date from which you want to generate e way bill.
- 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
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
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
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:
- If you have multiple items with same HSN code but with different description then you can add them now.
- 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.