Trade31The AI Operating System for Global Trade
AIKnowledgeIntelligenceSuppliersProductsToolsPricing
Log inSign upStart Free
⌘K
Ask AIGenerateRewriteTranslate
Home/Trade Resources/Excel Templates/Commercial Invoice Excel Template (Professional)

Commercial Invoice Excel Template (Professional)

Enterprise-ready commercial invoice workbook with Invoice, Packing List, and Instruction sheets. Includes Seller/Buyer, Incoterms® 2020, HS codes, bank detai…

Professional Version · Excel Templates

Format
EXCEL
Updated
2026-07-01
Version
v3.0.0

Download

Download Professional Template

Professional Version — ready for direct business use. Replace with your company data and verify against contract and regulations.

T31
Trade31Global Trade Toolkit
Professional Versionv3.0.0 · Updated 2026-07-01

Excel Templates

COMMERCIAL INVOICE

商业发票

Seller / Exporter

Shanghai Ocean Export Co., Ltd.

No. 888 Pudong Avenue, Shanghai 200120, China

+86-21-5555-0101 / export@oceanexport.example

Tax ID: 91310000MA1XXXXXX

Buyer / Consignee

Atlantic Import LLC

1200 Harbor Blvd, Los Angeles, CA 90001, USA

+1-310-555-0199 / ap@atlanticimport.example

Tax ID: US-EIN 12-3456789

Trade Information

Document No.
COMMER-2026-0042
Date
2026-07-01
Incoterms® 2020
Per contract — state Incoterms® 2020 + named place
Payment Terms
Per contract or proforma terms
Currency
USD
Contract / PO No.
PO-ATL-2026-118
Port of Loading
Shanghai, China
Port of Discharge
Los Angeles, USA

Product Table

ItemDescriptionHS CodeQtyUnit PriceAmount
1Bluetooth Speaker Model BT-200, black, retail box85183000500 PCSUSD 12.50USD 6250.00
2Bluetooth Speaker Model BT-200, white, retail box85183000300 PCSUSD 12.50USD 3750.00
TotalUSD 10,000.00

Payment / Bank Information

  • Beneficiary: Shanghai Ocean Export Co., Ltd.
  • Bank: Bank of China, Shanghai Branch
  • SWIFT: BKCHCNBJ300
  • Account: 4567890123456789
  • 200 Yincheng Road, Shanghai, China

Notes

Commercial Invoice template — not a substitute for legal advice or official customs filing. Align fields with ICC Incoterms® 2020 and your sales contract.

Authorized Signature

Company Chop / Date

Trade31Global Trade ToolkitGenerated Templatev3.0.0 · Updated 2026-07-01

How to Use

How to Fill

  1. Replace example parties and line items with actual shipment data.
  2. Ensure values match packing list, B/L, and customs declaration.
  3. State Incoterms® 2020 with named place/port in full.
  4. Add bank details only if required for T/T instructions on invoice.
  5. Print/sign/chop per buyer or L/C requirements.

Common Errors

  • Using the wrong document type for bank presentation (e.g. PO instead of invoice)
  • Party names or addresses inconsistent across the document set
  • Missing Incoterms® 2020 named place or delivery window

Tips

  • Cross-check with commercial invoice and packing list before shipment.
  • Archive signed PDF with contract file.

FAQ

Is this Commercial Invoice the same as a commercial invoice?
No — Commercial Invoice serves customs and bank value declaration; invoice is for customs/bank value declaration.
Can I present this to the bank under L/C?
Usually not alone — follow L/C Article 46 for required document types.
How to edit after download?
Open in Excel/Word/PDF editor locally — Trade31 does not store your data.
Who signs?
Authorized buyer/seller signatories per your company policy and contract.
How to align with Trade31 tools?
Use quotation/landed-cost tools for figures, then transfer to template.
Sample vs Professional?
Professional includes full fields; Sample shows structure only.

Related Resources

Packing List Excel Template

Carton-level packing list with weights, dimensions, and marks for export documentation. — enterprise trade guide with workflow, examples, FAQ, and related tools

Proforma Invoice Excel Template

Proforma invoice for quotations, L/C applications, and customs valuation. — enterprise trade guide with workflow, examples, FAQ, and related tools.

International Sales Contract

Full export sales agreement with delivery, inspection, and governing law sections. — enterprise trade guide with workflow, examples, FAQ, and related tools.

Related Knowledge

Commercial Invoice — Complete Guide for Exporters & Importers

Commercial invoice for customs clearance — mandatory fields, HS codes, Incoterms® 2020, examples, and country rules for CN, US, EU, JP, VN, MY, SG.

Packing List — Complete Guide for Export Shipments

Packing list requirements — fields, marks, weights, country differences, and alignment with commercial invoice and bill of lading.

What is FOB? Free on Board Decisions for Ocean Exports

What is FOB? Free on Board Decisions for Ocean Exports — Trade31 practical guide for importers and exporters.

Related Tools

FileText

Commercial Invoice Generator

Generate commercial invoice documents for export shipments. — enterprise trade guide with workflow, examples, FAQ, and related tools.

Calculator

FOB Calculator

Calculate FOB price from product cost, packaging, inland freight, and export charges. Runs locally in your browser. — enterprise trade guide with workflow, exam

FileText

Packing List Generator

Generate export packing list documents from your shipment details. — enterprise trade guide with workflow, examples, FAQ, and related tools.

Next: complete your trade workflow

Recommended next step

  1. Use with calculators
  2. Read filling guides
  3. Start RFQ

Suggested actions

Use with calculatorsRead filling guides

Recommended tools

  • Commercial Invoice Generator
  • FOB Calculator
  • Packing List Generator

Recommended templates

  • Packing List Excel Template
  • Proforma Invoice Excel Template
  • International Sales Contract

Related countries

  • Germany
  • United States
  • China

Trade Intelligence

  • Intelligence hub

Knowledge & Tools

  • Trade Knowledge
  • Trade Tools

Templates & Resources

  • Commercial Invoice
  • All templates

Suppliers & Products

  • Suppliers
  • Products
  • RFQ

Continue your trade workflow

  1. Trade Intelligence→
  2. Knowledge→
  3. Trade Tools→
  4. Templates→
  5. Suppliers

Trade31

The AI Operating System for Global Trade.

Platform

AIKnowledgeIntelligenceSuppliersProductsTools

Resources

BlogHelpAPIContact

Company

AboutPrivacyTerms / ContactPricing

© 2026 Trade31