Free template · Export documents

Commercial Invoice Format: Free Excel with Worked Example

A commercial invoice is the bill an exporter sends with the goods. The buyer pays against it and customs uses it to set the value of the shipment. Free Excel: blank format + filled example, no sign-up.

Download the Excel template

A commercial invoice is the bill an exporter sends with the goods. The buyer pays against it and customs uses it to set the value of the shipment. India has no fixed government layout. But the invoice must show the exporter's IEC and GSTIN, the buyer and consignee, and the countries of origin and destination. It must also show the 8-digit HS code, quantity, unit price, currency, Incoterm and the GST export endorsement.

What is a commercial invoice?

The exporter issues the commercial invoice when the goods are packed and ready to ship. It travels with the shipping documents to the buyer. Three parties read it closely.

  • The buyer pays against it and clears the goods with it.
  • Indian customs checks it against the shipping bill for value and HS code.
  • Your bank uses it to match the export payment.

It is often confused with three other documents.

DocumentWhen you make itWhat it does
Proforma invoiceBefore the order is finalA quote in invoice form, to approve the deal or arrange payment.
Commercial invoiceWhen the goods shipThe final bill. Payment and the customs value are based on it.
Packing listWhen the goods shipWhat is in each package, with weights. No prices.
GST tax invoiceWhen the goods are suppliedThe bill GST law asks for. For exports, one invoice can do both jobs.

Need the earlier document? Use our free proforma invoice format.

What each field in the commercial invoice format means

Header fields

FieldWhat to writeWho checks it
Exporter name and addressLegal name, as on your IEC and GST registrationCustoms, buyer, bank
IECYour 10-character Importer-Exporter CodeCustoms
GSTINGSTIN of the unit the goods ship fromCustoms, GST
AD codeYour bank's Authorised Dealer code, registered at the portCustoms, bank
Invoice number and dateYour running number for the financial yearCustoms, GST, buyer
Buyer's PO number and dateFrom the buyer's purchase orderBuyer, bank
Buyer and consigneeWho pays, and who receives the goods if different, with full addressesCustoms, buyer, bank
Countries of origin and destinationWhere the goods were made (India) and where they finally goCustoms, GST
Ports of loading and dischargeSuch as Nhava Sheva to HamburgCustoms, shipping line
IncotermTerm and place, such as FOB Nhava ShevaCustoms, buyer
Currency and payment termsInvoice currency and when payment is dueBuyer, bank
Rule 46 endorsement and LUT ARNGST export wording, plus LUT ARN if you ship under LUTGST
Total in words and signatureTotal in words, then an authorised signatureBank, buyer

Line-item columns

ColumnWhat to writeWho checks it
Sr. No.1, 2, 3 for each lineEveryone
Marks and Nos.Marks on the packages, such as MG/HAM/1-10Customs, buyer
Description of goodsMaterial, type, size and grade. Not just "parts".Customs, buyer
ITC(HS) codeThe 8-digit code for each itemCustoms, GST
Quantity and unitHow many, and the unit: pcs, kg, setsCustoms, buyer
Unit pricePer unit, in the invoice currencyCustoms, buyer, bank
AmountQuantity × unit priceCustoms, bank
Net weight (kg)Goods weight without packingCustoms, shipping line

Is the HS code mandatory? In practice, yes. The shipping bill needs the 8-digit ITC(HS) code, so the invoice should match.

[[IMAGE {"type":"checklist","title":"Six checks before you sign the invoice","items":["Exporter IEC, GSTIN and AD code","8-digit ITC(HS) code on every line","Incoterm with its named place","Total in words matches the figures","Rule 46 endorsement and LUT ARN","Quantities and weights match packing list"]}]]

How to fill a commercial invoice, step by step

  1. Start from the buyer's PO. Copy the PO number, items, rates and delivery terms exactly.
  2. Set the Incoterm and currency. Write the term with its place, such as FOB Nhava Sheva.
  3. List each item with its 8-digit HS code. Describe material, size and grade so customs can match the code.
  4. Add quantity, unit price and line totals. Check every line: quantity × unit price = amount.
  5. Write the total in figures and in words. Both must show the same amount and currency.
  6. Add the Rule 46 endorsement and LUT ARN. Use the LUT wording or the IGST-paid wording, whichever applies.
  7. Sign and cross-check with the packing list. Quantities, packages and weights must match before you file.

Where TranZact fills it for you

The patchwork makes your team type the same order twice, in Excel and in Tally. Retyping is where rates and quantities slip.

In TranZact the invoice comes from the sales order you already have, in the buyer's currency, so items, quantities and rates are not typed again. The sales flow runs enquiry → quotation → order timeline → dispatch → e-invoicing → payment.

TranZact is manufacturing AI software used by 10,000+ manufacturers, and it goes live in 2–3 weeks.

Your export team still owns the HS code, Incoterm and LUT details. Check them on every invoice before you sign.

What you needTranZact (per /pricing, checked 22 Oct 2026)
Invoice in the buyer's currencyMulti-currency & e-invoicing: Grow plan and above
E-way bill and e-invoice (IRN)From the GST invoice, in one flow: all plans
Your own invoice layoutCustom document formats: Dominate plan
Accounts in TallyOne-way sync, no double entry. Busy and Zoho Books too.

See every plan on the pricing page.

Book a demo →

Worked example: stainless steel flanges shipped to Germany

A flange maker in Pune ships 900 stainless steel flanges to a buyer in Hamburg. Every name, number and code below is illustrative. The flanges themselves are planned from a bill of materials.

Table 1 (Example): header block

FieldExample value
ExporterABC Flanges Pvt Ltd, Pune, Maharashtra
IEC / GSTINABCDE1234F / 27ABCDE1234F1Z5
Invoice no. and dateEXP/26-27/014, 12 Nov 2026
Buyer's POPO 4500123, 20 Oct 2026
Buyer and consigneeMuster GmbH, Hamburg, Germany (same for both)
Origin / destinationIndia / Germany
PortsNhava Sheva to Hamburg
Incoterm and currencyFOB Nhava Sheva (Incoterms 2020), EUR
Payment terms30 days from bill of lading date
GST endorsementExport under LUT, ARN AD270000000000X

Table 2 (Example): line items and totals

Item (ITC(HS) 73072100)Qty × unit priceAmount (EUR)Net weight
SS 316 weld neck flange DN50 PN16400 pcs × 9.503,800.00600 kg
SS 316 weld neck flange DN80 PN16300 pcs × 14.004,200.00750 kg
SS 316 slip-on flange DN100 PN16200 pcs × 16.503,300.00600 kg
Total, FOB Nhava Sheva900 pcs11,300.001,950 kg

Total in words: Euro Eleven Thousand Three Hundred only.

Table 3 (Example): invoice vs packing list check

CheckInvoicePacking listMatch?
Total quantity900 pcs900 pcsYes
Package marksMG/HAM/1-10MG/HAM/1-10 (10 wooden cases)Yes
Net weight1,950 kg1,950 kgYes

Commercial invoice vs tax invoice for exports

For goods exports, you don't need two separate bills. One commercial invoice can also serve as your GST tax invoice. It must carry your GSTIN, the HS codes and the export endorsement under Rule 46 of the CGST Rules.

"Export invoice" usually means the same bill. See our export invoice format, and our GST invoice format for the domestic side.

Under LUT, without paying IGST, write this endorsement and add your LUT ARN:

SUPPLY MEANT FOR EXPORT/SUPPLY TO SEZ UNIT OR SEZ DEVELOPER FOR AUTHORISED OPERATIONS UNDER BOND OR LETTER OF UNDERTAKING WITHOUT PAYMENT OF INTEGRATED TAX

If you paid IGST, use the "ON PAYMENT OF INTEGRATED TAX" wording instead.

Common commercial invoice mistakes

  1. A 6-digit HS code. It won't match the 8-digit ITC(HS) code on the shipping bill.
  2. Missing GST endorsement or LUT ARN. This can slow your GST export refund.
  3. Invoice and packing list don't match. Customs often flags the gap and can hold the shipment.
  4. Incoterm missing or not matching the value. A CIF invoice without freight and insurance confuses the customs value.
  5. Total in words differs from the figures. The bank can raise a discrepancy and hold the payment papers.
  6. Vague descriptions. "Steel parts" tells customs nothing, so the HS code can't be checked.

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

Bring one of your own export orders to the demo. We'll show the invoice made from that order, in your buyer's currency.

Book a demo →

Frequently asked questions

Is this commercial invoice format free to download?

Yes. The Excel file is free with no sign-up. It has a blank format and a filled example.

Which HS code should I use, 6 or 8 digits?

For exports from India, use the 8-digit ITC(HS) code. The first six digits are international and the last two are India's own tariff line. Check the live code on the DGFT portal.

What wording goes on the invoice if I export under LUT?

Use the Rule 46 export wording below, then add your LUT ARN. SUPPLY MEANT FOR EXPORT/SUPPLY TO SEZ UNIT OR SEZ DEVELOPER FOR AUTHORISED OPERATIONS UNDER BOND OR LETTER OF UNDERTAKING WITHOUT PAYMENT OF INTEGRATED TAX. If you paid IGST, use the 'ON PAYMENT OF INTEGRATED TAX' wording.

Can the commercial invoice and packing list be one document?

Two separate documents are the safe norm. Customs and the bank expect to check one against the other. The invoice shows prices and values. The packing list shows what is in each package and its weight. Quantities, packages and weights must match across both.

What happens if my invoice and packing list don't match?

Customs often flags it and the shipment can be held. Match quantities, values and weights across the invoice, packing list and shipping bill before you file.

Can my factory software make the commercial invoice for me?

Yes. In TranZact the invoice comes from the sales order you already have, in the buyer's currency. So items, quantities and rates are not typed twice. Multi-currency is in the Grow plan and above. Book a demo to see it with your own export order.

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

Book a demo

Born in India. Building for the world.