How to generate e-way bills in bulk

Do you need to do this?

Ask first, because a large share of the people who land here do not, and the honest answer saves an afternoon.

An e-way bill covers the movement of goods above a value threshold. Whether one is needed depends on the consignment value, whether the movement is within a state or between states, and your state’s own rules — which differ, and which change.

Here is the part that matters for most readers: if you sell on Meesho, Flipkart or Amazon and ship through the marketplace’s courier, the e-way bill is generally handled in that flow instead of by you. You are handing single parcels to a logistics partner, not moving a consignment yourself.

Bulk generation is for a different business — a wholesaler dispatching many consignments, someone moving stock between their own locations, or a seller shipping direct in volume. If that is not you, you can stop reading and get on with something else.

And if it is one or two consignments a week, use the portal form. The utility only earns its learning curve somewhere north of a few dozen at a time.

How the official route works

3 files, moving in one direction, and no third-party tool anywhere in it.

The Excel template — downloaded from the e-way bill portal, one row per consignment. The offline utility — also from the portal, which validates the sheet and converts it into a JSON file in the exact format the portal expects. The JSON — which you upload.

The single most important rule follows from that structure: never open or edit the JSON. It is generated output. Every “JSON not in prescribed format” error traces back to someone opening it in a text editor to fix one field. Change the Excel and regenerate instead.

Get both files from the portal itself, each time. A template someone emailed you or a copy from a blog will be a version behind, and the schema changes without announcement.

The Excel template, column by column

This is the part nobody explains, and it is where the time goes.

Transaction and document details

Supply type, sub-type, document type and number, and the document date. The document number must match your invoice exactly — this is what links the e-way bill to the invoice in any later check.

Parties

GSTIN, legal name, address, place, pincode and state code for both the consignor and the consignee. The pincode must be consistent with the state, and a mismatch between them is a common rejection that reads as a vague validation error.

Check the GSTINs before you build the file rather than after — a cancelled or mistyped number fails the whole row, and the bulk GSTIN checker clears a list in seconds.

Item details

Product name and description, HSN code, quantity, unit, taxable value and the tax rates. Fashion HSN codes are usually 6 or 8 digits; take them from your own invoices instead of guessing.

Transport details

Transport mode, distance, transporter details, and the vehicle number where the mode requires it. Two formatting traps live here: vehicle numbers go in unbroken, with no spaces or dashes, and distance has to be plausible for the two pincodes or validation rejects it.

The trap that catches everyone: dates

Excel reformats date columns on its own, silently, and the file it produces then fails with an unhelpful error. Format the date column as text before you type anything into it. This single step prevents more failed uploads than any other on this page.

Converting and uploading

Once the sheet is filled, the rest is mechanical.

Run the validation inside the template first. It flags malformed rows before you generate anything, and fixing them there costs seconds rather than a round trip through the portal.

Then generate the JSON. The utility writes the file; you do not touch it.

Log in to the e-way bill portal and find the bulk generation option under e-way bill actions. Upload the JSON. The portal processes the rows and reports which succeeded and which failed, with a reason per row.

Finally, collect the generated numbers and store them against each consignment. A generated e-way bill that nobody printed or recorded is no use at a check post.

Two operational habits worth having. Generate close to dispatch instead of days ahead, because validity runs from generation. And keep the Excel — regenerating from a saved sheet is trivial, rebuilding one from memory is not.

Errors, and what each one means

The portal’s messages are terse. These are the ones that occur.

Notice the pattern: most of these are formatting problems in Excel rather than anything to do with e-way bills. Getting the column formats right before you type is most of the battle.

If you would rather not touch the utility

Entirely reasonable, and there are three real alternatives.

Your billing software. Most Indian GST billing packages generate e-way bills directly from the invoice you already raised, which removes the double entry that makes the utility tedious. If you are already invoicing in software, check whether this is switched on before learning anything else here.

A GSP. GST Suvidha Providers offer API access and bulk handling as a paid service. Worth it at genuine volume, overkill below that.

Let the courier do it. For marketplace orders this is usually what already happens, and it is why most Meesho and Flipkart sellers never encounter an e-way bill at all.

The utility is the right answer in one specific case: you dispatch many consignments yourself, you do not have billing software that handles it, and you do not have the volume to justify a GSP. That is a real business — it is just a narrower one than the search volume suggests.