Free template · Excel · Worked example

E-Way Bill Format: Free Excel Template with a Filled Example

Form GST EWB-01 has two parts: Part A for shipment details and Part B for vehicle or transport details. Download the free Excel with a blank format and filled examples. No sign-up.

Download the Excel template

An e-way bill follows the format of Form GST EWB-01. It has two parts. Part A holds the shipment details: supplier and recipient GSTIN, dispatch and delivery PIN codes, and the invoice or challan number and date. It also has the value of goods, HSN code and reason for transport. Part B holds the transport details, mainly the vehicle number or the transporter's document number. You need one before moving goods worth more than ₹50,000. It is generated only on the GST e-way bill portal or through software connected to it.

What is an e-way bill?

It is an electronic document for moving goods under GST. The value limit includes GST. Some states set a higher limit inside the state.

The registered person causing the movement generates it: the supplier, the recipient or a transporter. It gets a 12-digit number. E-invoice users can reuse the invoice data; see our e-invoice format.

Are PDF and Excel formats of the e-way bill mandatory?

No. The only valid format is Form GST EWB-01, filled on the portal. A PDF is a printout of a generated bill. This Excel just collects the details before you log in.

E-way bill format: what each field means

Each field comes from the invoice, the challan or the transporter's receipt.

Part A: shipment details

FieldWhat to enterSource documentExample
Supply typeOutward or inwardYour roleOutward
Reason for transportSupply, job work, return, own useWhy goods moveSupply
Document type, number, dateInvoice, bill of supply or challanInvoice or challanINV/26-27/0412, 10 Nov 2026
Supplier GSTIN, dispatch PINYour GSTIN, address and PINInvoice header27ABCDE1234F1Z5, 411019
Recipient GSTIN, delivery PINBuyer's GSTIN (URP if unregistered), address, PINInvoice ship-to33PQRST5678K1Z2, 600058
Items and HSNName, HSN, quantity, unitInvoice linesSteel trolley, 8716, 50 Nos
Value and taxTaxable value plus GST and cessInvoice totals₹2,40,000 + ₹12,000 IGST
Transporter IDOnly if a transporter fills Part BTransporterBlank
DistanceRoad km; the portal suggests it from PINsPIN codes1,180 km

Part B: transport details (and the 50 km cases where you can skip it)

FieldWhat to enterSource documentExample
ModeRoad, rail, air or shipDispatch planRoad
Vehicle numberTruck registrationDriver or transporterMH12AB1234
Transport documentLR, railway receipt, airway bill or bill of ladingTransporterLR 5521, 10 Nov 2026

You can skip Part B for moves up to 50 km within the state in two cases. One is from your premises to the transporter's. The other is the last leg, from the transporter's place to the recipient's. The transporter fills Part B before the long leg.

Who fills Part A and who fills Part B?

The supplier or recipient causing the movement fills Part A, or a transporter for them. Whoever moves the goods fills Part B.

How to fill the e-way bill, step by step

  1. Make the invoice or challan. See our bill format.
  2. Check the need: the value limit, or interstate job work.
  3. Note GSTINs, PINs, HSN, values, vehicle and distance in the Excel.
  4. Log in to ewaybillgst.gov.in and choose a new e-way bill.
  5. Fill Part A, then Part B.
  6. Submit. Give the 12-digit number to the driver.

[[IMAGE {"type":"compare","title":"Excel and portal vs TranZact","columns":["Excel + portal","TranZact"],"rows":[["Invoice details","Typed again on the portal","Taken from the GST invoice"],["E-invoice (IRN)","A separate step","Same flow as the e-way bill"],["Where it happens","Portal, invoice by invoice","Inside the sales flow"]]}]]

Keying each invoice into the portal is where a digit goes wrong. TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow. It is on all plans.

Book a demo →

Worked example 1: interstate sale of 50 steel trolleys, Pune to Chennai

A Pune firm sells 50 steel trolleys to a Chennai buyer. Goods cross states, so IGST applies. All numbers are illustrative.

Table A: Part A

FieldEntry
Supply type, reasonOutward, Supply
DocumentINV/26-27/0412, 10 Nov 2026
From27ABCDE1234F1Z5, Pune 411019
To33PQRST5678K1Z2, Chennai 600058
Value₹2,52,000
Distance1,180 km

Table B: item lines and tax

ItemQty × rateTaxable valueIGST at 5%
Steel trolley50 × ₹4,800₹2,40,000₹12,000

Total: ₹2,40,000 + ₹12,000 = ₹2,52,000. Use the HSN and rate on your own invoice.

Table C: Part B and validity

FieldEntry
VehicleRoad, MH12AB1234
Transport documentLR 5521, 10 Nov 2026
Part B filled10 Nov 2026, 11:00 am
Validity1,180 ÷ 200 = 5.9, so 6 days
Valid till11:59 pm, 16 Nov 2026

Day one ends at midnight of 11 Nov, the day after Part B is filled.

Worked example 2: parts sent to a job worker in another state on a delivery challan

The firm sends 400 machined brackets to a plating job worker in Vapi, Gujarat, on a ₹38,000 challan. The parts list often comes from your bill of materials.

Is an e-way bill needed for goods below ₹50,000? Usually not. But interstate job work needs one at any value. The principal generates it, or the job worker if registered.

FieldEntry
Supply type, reasonOutward, Job work
DocumentDC/26-27/0088, 12 Nov 2026
To24LMNOP4321Q1Z8, Vapi 396195
ItemMachined bracket, HSN 7326, 400 Nos
Value₹38,000, no GST
Part BRoad, MH14EF9012
Validity330 km ÷ 200, so 2 days, till 11:59 pm, 14 Nov 2026

Match the challan number and date to your delivery challan format.

How long is an e-way bill valid?

  • Normal cargo: one day per 200 km, or part of it.
  • Over-dimensional cargo: one day per 20 km.
  • Each day ends at midnight. Day one ends at midnight of the day after Part B is filled.
  • Extend it from 8 hours before to 8 hours after expiry.
  • No extensions after 360 days from generation.
  • Always round up: 210 km is 2 days, not 1.

Common e-way bill mistakes

  • Entering the value without GST.
  • A wrong PIN code, which skews distance and validity.
  • An invoice number or date that does not match the paper copy.
  • No e-way bill for interstate job work under ₹50,000.
  • Part B not updated after a vehicle change.
  • Documents over 180 days old, blocked since 1 Jan 2025.
  • Missing the 8-hour extension window.
  • Sending the Excel instead of a 12-digit e-way bill.

Cancel, change or extend an e-way bill

  • Cancel: within 24 hours, unless verified in transit.
  • Change: Part A cannot be edited. Cancel and generate again.
  • New vehicle: update Part B.
  • Recipient: can reject within 72 hours. Silence counts as accepted.
  • Extend: in the 8-hour window, with reason, place and distance left.

Where TranZact fills it for you

In TranZact, the e-way bill comes from the GST invoice, so its details are not typed again. Dispatch sits in the sales flow: enquiry, quotation, order timeline, dispatch, e-invoicing and payment.

Accounts stay in Tally, with one-way sync and no double entry. For job-work challans, use the portal steps above.

FactDetailAs of
E-way billFrom the GST invoice, IRN in the same flow, all plans6 Oct 2026
AccountingTally one-way sync; Zoho Books sync7 Oct 2026
PlansFrom ₹8,333/month billed yearly; see pricing22 Oct 2026
Go-liveLive in 2–3 weeksNov 2026
Used by10,000+ manufacturersNov 2026

Don't be the bottleneck. Become the AI-Run Factory.

See a GST invoice become an e-way bill and IRN in one flow. Bring a recent invoice and we will walk through it with you.

Book a demo →

Frequently asked questions

Can I make an e-way bill in Excel and send it with the truck?

No. Excel only helps you prepare the details. The e-way bill is valid only once generated on the GST e-way bill portal or through connected software, with its 12-digit number.

Do I need an e-way bill if I already make e-invoices?

Yes, when the goods movement is over the limit. The e-way bill can be created from the same invoice data. In TranZact, it is generated from the GST invoice in the same flow as the IRN.

Who generates the e-way bill when the buyer sends their own truck?

The registered person causing the movement generates it. That can be the supplier or the recipient. The buyer's vehicle number goes in Part B.

Do I need an e-way bill to send material to a job worker in my own city?

Only if the consignment value is over ₹50,000. Out-of-state job work needs one whatever the value.

Can I generate an e-way bill without a vehicle number?

Yes. Fill Part A now and add the vehicle in Part B later. Goods cannot move until Part B is filled. The exceptions are moves up to 50 km within the state to the transporter's premises, or from there to the recipient.

Can I use this template if my accounts are in Tally?

Yes, the Excel works with any software. If you run operations in TranZact, accounts stay in Tally with one-way sync and no double entry.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.