文外贸报价单 Quotation（可直接复制使用）
版本：通用外贸模板，FOB/CFR/CIF 都适用，填 [] 里内容即可
QUOTATION Quotation No.: [QT20261014‑001] Date: [Oct 14, 2026] Valid Until: [Nov 13, 2026] //报价有效期30天 To: [Buyer Company Name] [Buyer Contact Person] [Buyer Email / WhatsApp] From: [Your Company Name] [Your Contact] [Your Email / WhatsApp] Subject: Quotation for [Product Name] | Item | Description | Spec | Qty | Unit Price | Amount | |---|---|---|---|---|---| | 1 | [Product Name] | [Size,Material,Color] | [pcs] | [USDXX.XX] FOB SHANGHAI | [USDXXXX.XX] | Total Amount: USD [XXXX.XX] Terms & Conditions: 1. Trade Term: FOB Shanghai / CFR XXX / CIF XXX 2. Payment Term: 30% T/T deposit, 70% balance against copy of B/L 3. Lead time: [15‑25] working days upon receiving deposit 4. MOQ: [XXX pcs] 5. Packing: Neutral export carton / as customer’s requirement 6. Insurance: For CIF term, covering 110% of invoice value against all risks 7. Remark: Price subject to raw material & exchange rate fluctuation. Best regards, [Your Full Name] [Your Company] [Tel / WhatsApp] [Website]
配套 Excel 文本版（复制粘贴进 Excel，自带计算逻辑）
把下面整段复制，粘贴到 Excel A1 单元格，会自动分列，第 8 行开始是计算逻辑
项目 符号 数值 含税采购单价(元) Cost_Tax 113 增值税率 VAT 13% 退税率 Drawback 10% 国内单件总费用(元) Local_Fee 5 销售利润率 Profit_Rate 10% 结算汇率 Exchange 7.2 单件海运费(元) Ocean_Fee 12 保险费率 Insurance_Rate 0.1% 不含税采购价 =B2/(1+B3) 退税额 =B9*B4 扣退税后产品成本 =B2‑B10 总成本(产品+国内费用) =B11+B5 FOB人民币单价 =B12/(1‑B6) FOB美元单价 =B13/B7 CFR人民币单价 =B13+B8 CFR美元单价 =B15/B7 CIF美元单价 =B16/(1‑1.1*B14)
使用说明
只修改 B 列的黄色参数（采购价、税率、费用、利润率、汇率、运费、保险费率）
下面全部自动算出 FOB / CFR / CIF 美元单价
补充 2 套高频变体
变体 1：L/C 信用证版本付款条款
Payment Term: Irrevocable Sight L/C at sight
提示：用 L/C 报价，建议总成本额外 + 0.4% 银行操作费
变体 2：DDP 简易备注
Trade Term: DDP [Destination City] Note: Price includes product cost, freight, insurance, import duty & local delivery to your address. Exclude any local extra tax.
