Free template · Excel

Export Invoice Format: Free Excel Template + Example

A GST-correct export invoice layout for Indian manufacturers. Download the blank Excel format and a filled example, with every field, the LUT and IGST endorsements and the e-invoice codes explained.

Download the Excel template

What is an export invoice?

An export invoice is the GST tax invoice an Indian exporter issues for goods shipped out of India. Besides the usual invoice details, it must show the buyer's name and address, the delivery address and the country of destination. It must also carry one of two endorsements, printed word for word. Under LUT: 'Supply meant for export under bond or letter of undertaking without payment of integrated tax'. With IGST paid: 'Supply meant for export on payment of integrated tax'. Most exporters add their IEC, port of loading, Incoterm, foreign-currency value and the rupee value at the exchange rate used.

It is issued under Rule 46 of the CGST Rules and must match the shipping bill. For production paperwork, see our free bill of materials format.

What each field in the export invoice format means

Header fields: exporter, buyer, consignee, shipment, terms

FieldWhat to writeRequired by
Exporter name, address, GSTINAs on your GST registrationRule 46
Invoice no. and dateUnique in the year, max 16 charactersRule 46
Buyer, delivery address, destination countryForeign buyer's full detailsExport proviso
Place of supplyOutside India (96)Rule 46
IEC, ports, Incoterme.g. FOB Nhava ShevaTrade practice
Currency and exchange rateCBIC rate for the date of supplyRule 34(1)

Line-item columns

ColumnWhat to writeRequired by
Description, HSN code, quantity, unitHSN as on the shipping billRule 46
Rate, amount, taxable value (₹)Foreign rate × quantity, then × exchange rateRule 34(1)
IGST rate and amountItem's rate, or zero under LUTRule 46

Is the HSN code mandatory on an export invoice? Yes, Rule 46 asks for it. Many exporters print the 8-digit code from the shipping bill.

In which currency should an export invoice be made? You can use the buyer's currency, such as USD or AED. Also show the rupee value at the CBIC rate.

Totals, declaration and signature

FieldWhat to writeRequired by
Total value and taxable value (₹)Rupee totals of the invoiceRule 46
Foreign-currency total, amount in wordse.g. USD total, written in wordsTrade practice
EndorsementOne of the two texts, word for wordExport proviso
Reverse charge, signature'No'; exporter's signatureRule 46
Declaration, bank, shipping bill no.Bill no. added after filingTrade practice

LUT or IGST paid: which endorsement to print

Is GST charged on an export invoice? Exports are zero-rated. You pick one of two routes, and the invoice must say which.

  • Under LUT: IGST is zero. Print the 'without payment of integrated tax' endorsement.
  • IGST paid: charge the item's rate, then claim a refund. Print the 'on payment of integrated tax' endorsement.

What is an LUT and how does it change the export invoice? An LUT (Letter of Undertaking) is filed in Form GST RFD-11 for one financial year. Print its ARN and date beside the endorsement.

Worked example: brass valves shipped to the UAE

A Jamnagar brass-parts maker ships three valve sizes to Dubai, FOB Nhava Sheva, at an illustrative ₹84.00 per USD. All names, codes and numbers are illustrative.

Table 1 (Example): header block

FieldExample value
Exporter and GSTINExample Brass Works, Jamnagar; GSTIN 24AAAAA0000A1Z5
IECAAAAA0000A
Invoice no. and dateEXP/26-27/001, 10 Nov 2026
BuyerExample Valve Trading LLC, Dubai
Delivery addressWarehouse 12, Jebel Ali Free Zone, Dubai
Country of destinationUnited Arab Emirates
PortsLoading: Nhava Sheva; discharge: Jebel Ali
IncotermFOB Nhava Sheva
Currency and exchange rateUSD; ₹84.00 per USD
LUT ARN and dateAD240326000000X, 1 Apr 2026

Table 2 (Example): line items, USD to INR

Item (HSN)Qty × rate (USD)Amount (USD)Amount (₹ at 84.00)
Brass ball valve, 1/2 inch (848180)2,000 Pcs × 2.505,000.004,20,000.00
Brass ball valve, 1 inch (848180)1,000 Pcs × 4.804,800.004,03,200.00
Brass gate valve, 2 inch (848180)300 Pcs × 12.003,600.003,02,400.00
Total3,300 Pcs13,400.0011,25,600.00

Table 3 (Example): same invoice under LUT vs IGST paid

LineUnder LUTIGST paid (18%, illustrative)
Taxable value (₹)11,25,600.0011,25,600.00
IGST (₹)0.002,02,608.00
Invoice total (₹)11,25,600.0013,28,208.00
Buyer pays (USD)13,400.0013,400.00

The buyer pays USD 13,400 either way. On the IGST route, you claim the ₹2,02,608 back as a refund.

How to fill the export invoice, step by step

Fill it in this order:

[[IMAGE {"type":"steps","title":"Fill an export invoice in five steps","items":["Copy buyer details from the order","Add items, HSN codes and foreign rates","Convert at the CBIC exchange rate","Pick LUT or IGST, print the endorsement","Add the shipping bill number after filing"]}]]

Export invoice fields for e-invoicing (IRN)

Is e-invoicing mandatory for export invoices? Yes, if your business is covered by e-invoicing. The legal invoice is the one with the IRN QR code (Rule 46(r)).

E-invoice fieldWhat to enter
Supply typeExport with or without payment of IGST
Buyer GSTINURP
State code and place of supply96
Buyer PIN code999999

See our e-invoice format and e-way bill format pages. In TranZact, the e-way bill is generated from the GST invoice, with the e-invoice (IRN) in the same flow, on all plans.

Book a demo →

Common export invoice mistakes

  1. Wrong endorsement: 'on payment' printed on an LUT shipment.
  2. Tax vs route mismatch: IGST under LUT, or no valid LUT.
  3. Wrong rate: RBI or bank rate instead of the CBIC rate.
  4. Shipping bill mismatch: value, quantity, HSN or rate differ.
  5. Missing details: no destination country or delivery address.
  6. Wrong e-invoice codes: not URP, 96 and 999999.
  7. Broken numbering: gaps, repeats or over 16 characters.

Export invoice vs commercial invoice vs proforma invoice

Only the export invoice is a GST tax invoice.

DocumentWhat it isWhen it's made
Export invoiceGST tax invoice under Rule 46, with the endorsementWhen goods are removed for export
Commercial invoiceTrade document: price and terms of saleWith the shipment
Proforma invoiceA quote; not a tax invoiceBefore the order is confirmed

Free templates: proforma invoice format. For domestic sales: tax invoice vs bill of supply.

Where TranZact fills it for you

Excel works for a few shipments a month. The trouble starts when buyer, items and rates are retyped in the order, invoice and Tally.

FactDetailSource
Sales flowEnquiry, quotation, order timeline, dispatch, e-invoicing, paymentSales solution page
Multi-currencyGrow plan and above (₹8,333/month billed yearly)/pricing, 22 Oct 2026
AccountingStays in Tally: one-way sync, no double entryletstranzact.ai
Go-liveLive in 2–3 weeksletstranzact.ai

One honest limit: to print your own layout, you need custom document formats (Dominate plan, pricing). Bring your export invoice to the demo and we'll check its fields against TranZact's formats.

Bring your next export order to a demo. Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Frequently asked questions

Can I use this Excel format if I'm covered by e-invoicing?

Yes, to prepare the data. The legal invoice is the one reported to the IRP, with the IRN QR code.

Do I need a separate invoice series for exports?

Not by law. A series like EXP/26-27/001 just makes matching with shipping bills easier.

Which exchange rate goes on an export invoice for goods?

The CBIC-notified customs rate for the date of supply (Rule 34(1)).

Should the LUT number be printed on the invoice?

It's recommended. It shows why no tax was charged.

What does the free download contain?

One Excel file: a blank format, the filled example with formulas and a how-to-fill sheet.

Can software fill the export invoice for me?

TranZact's sales flow includes quotation, order timeline, dispatch and e-invoicing, with multi-currency on Grow and above. Bring your format to a demo.

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

Book a demo

Born in India. Building for the world.