E-Way Bill Bulk Generation from Excel

Last updated: 27 June 2026 · Threshold ₹50,000; validity 1 day per 200 km.

To generate e-way bills in bulk from Excel, fill the e-way bill portal's bulk-generation template with one row per consignment, convert it to JSON using the EWB JSON preparation tool, and upload it on ewaybillgst.gov.in to get all your EWB numbers at once. An e-way bill is required when consignment value exceeds ₹50,000 for inter-state movement (intra-state limits follow each state's notification).

Key takeaways

E-way bill is needed above ₹50,000 consignment value for inter-state goods movement; intra-state thresholds vary by state.
Bulk generation uses Excel → the EWB JSON preparation tool → upload on the portal, returning many EWBs in one go.
Validity is distance-based: 1 day per 200 km for normal cargo (1 day per 20 km for over-dimensional cargo).
Part-A holds the invoice/consignment details; Part-B holds the transport (vehicle) details.
Part-B is exempt for movement up to 50 km within the state between consignor and transporter (or transporter and consignee).
2026 limits: no EWB against a document older than 180 days; validity can't be extended beyond 360 days.

Fact box. An e-way bill is mandatory for the movement of goods of consignment value exceeding ₹50,000 (inter-state). Its validity is one day per 200 km for standard cargo, calculated from the time Part-B is first entered. Intra-state thresholds are set by each state's own notification and vary — check the NIC EWB portal or your state GST office for the current limit in your state. (Source: CBIC e-way bill rules; NIC EWB portal.)

When is an e-way bill required?

Whenever you move goods worth more than ₹50,000 between states. For movement within a state, the threshold follows that state's notification — many use ₹50,000, some set it higher (e.g. ₹1 lakh). It's needed for supply, returns, branch transfers, and inward supplies from unregistered persons, among others.

The bill has two parts:

Part-A — GSTINs, place of dispatch and delivery, invoice number and date, value, HSN, reason for transport.
Part-B — transporter ID or vehicle number.

How does bulk generation from Excel work?

The EWB portal provides a bulk-generation facility: instead of keying each consignment on screen, you prepare many at once from a spreadsheet.

Download the bulk EWB template (Excel/JSON tool) from ewaybillgst.gov.in.
Enter one consignment per row with all Part-A (and Part-B if known) fields.
Run the JSON preparation tool to validate and convert the rows to a JSON file.
Upload the JSON on the portal under bulk generation.
The portal returns the EWB numbers for all valid rows, and an error file for any that failed.

Keep the master data in Excel so you can regenerate, correct rejected rows, and reconcile EWBs against invoices.

What columns does the bulk template need?

Match the portal's bulk template exactly — the order and field names matter for the JSON tool:

Field	Example
Supply type (Outward/Inward)	Outward
Document type & number	Tax Invoice, INV-0421
Document date	06-06-2026
From GSTIN, From state	27ABCDE1234F1Z5, MH
To GSTIN, To state	29PQRST5678G2Z1, KA
HSN, product, quantity, unit	8471, …
Taxable value, tax rate, total	60,000 …
Transport mode, distance (km)	Road, 430
Vehicle no. / transporter ID	MH12AB1234

Fact box. The e-way bill bulk generation tool lets a taxpayer upload a single JSON (prepared from an Excel template) to create multiple e-way bills at once, returning EWB numbers in batch — useful for businesses dispatching many consignments a day. (Source: NIC e-way bill portal user guide.)

How is e-way bill validity calculated?

Validity runs from when Part-B is first entered and depends on distance:

Cargo type	Validity
Normal cargo	1 day per 200 km (or part)
Over-dimensional cargo (ODC)	1 day per 20 km (or part)

So 430 km of normal goods gives 3 days. In Excel, you can estimate validity with =ROUNDUP(Distance/200, 0) days for normal cargo. New limits cap things at both ends: you can't generate an EWB against a document older than 180 days, and total validity can't be extended beyond 360 days. These limits were introduced in 2026; confirm the current position against the latest NIC notification on ewaybillgst.gov.in before relying on them for compliance decisions.

How Ankeshan helps: Ankeshan fills the EWB bulk template from your invoice data, computes distance-based validity, and prepares the JSON ready to upload — then writes each returned EWB number back beside its invoice. It's launching soon; join the waitlist.

Frequently asked questions

What is the e-way bill limit? ₹50,000 consignment value for inter-state movement. Intra-state thresholds follow each state's own notification and can differ.

Can I generate e-way bills in bulk? Yes. Use the portal's bulk-generation tool: prepare an Excel template, convert it to JSON, and upload to create many e-way bills at once.

How long is an e-way bill valid? One day per 200 km for normal cargo (one day per 20 km for over-dimensional cargo), counted from when Part-B is entered.

When is Part-B not required? For movement up to 50 km within the same state between consignor and transporter, or transporter and consignee — Part-A is still needed if value exceeds the threshold.

Can I generate an e-way bill on an old invoice? Under the 2026 rules, not if the document is older than 180 days, and validity cannot be extended beyond 360 days from generation.

Sources

CBIC e-way bill rules; consignment-value and validity provisions — cbic-gst.gov.in.
NIC: e-way bill bulk generation tool and user guide — ewaybillgst.gov.in.

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.