Export Cost Sheet Excel Template
Professional Version
Line-item export cost sheet with material, labor, packaging, and margin columns.
Download
Download Professional TemplateProfessional Version — ready for direct business use. Replace with your company data and verify against contract and regulations.
Trade31Global Trade Toolkit
Excel Templates
EXPORT COST SHEET EXCEL TEMPLATE
Export Cost Sheet Excel Template
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.
- DOC-2026-0042
- Date
- 2026-06-30
- Incoterms® 2020
- FOB Shanghai, Incoterms® 2020
- Payment Terms
- 30% T/T deposit, 70% before shipment
- Currency
- USD
- Contract / PO No.
- PO-ATL-2026-118
- Port of Loading
- Shanghai, China
- Port of Discharge
- Los Angeles, USA
Product Table
| Item | Description | HS Code | Qty | Unit Price | Amount |
|---|---|---|---|---|---|
| 1 | Bluetooth Speaker Model BT-200, black, retail box | 85183000 | 500 PCS | USD 12.50 | USD 6250.00 |
| 2 | Bluetooth Speaker Model BT-200, white, retail box | 85183000 | 300 PCS | USD 12.50 | USD 3750.00 |
| 3 | Gift packaging carton (inner pack) | 44219990 | 800 PCS | USD 0.85 | USD 680.00 |
| Total | USD 10,680.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
Replace example fields with your transaction data. Keep invoice, packing list, B/L, and customs declarations consistent.
Authorized Signature
Company Chop / Date
How to Use
How to Fill
- Download the template and replace seller, buyer, and letterhead first.
- Enter Document Number and Date; cross-reference PI and contract.
- Fill the product table — quantity × unit price must equal amount.
- Verify Incoterms® 2020, payment terms, and port names.
- Complete bank details for T/T; match the sales contract.
- Print, sign, chop, then send to buyer, bank, or customs broker.
Common Errors
- Incoterms written as "FOB" only — missing port and "Incoterms® 2020"
- Invoice amount conflicts with packing list or B/L
- HS code does not match customs declaration
- Document Number not consistent across documents
Tips
- Pair with Trade31 Commercial Invoice and Packing List templates.
- Review Related Knowledge for document requirements before shipment.
- Practical guidance only — not legal or customs advice.
FAQ
- Is the Export Cost Sheet Excel Template free to use?
- Trade31 provides this template free for export practice. Verify against your contract and local regulations before use.
- Is the current download the final template?
- Professional Version — ready for direct business use. Replace example data and verify against your contract.
- Can I edit the template fields?
- Yes. Download and edit in Excel, Word, or PDF software. Keep your letterhead and signature blocks.
- What file format is the download?
- This resource is EXCEL.
- How does this work with related documents?
- Keep descriptions, quantities, and values consistent across invoice, packing list, and B/L. See Related sections.