← All prompts

💬 DDP Quote Line-Item Breakdown

Turns a messy DDP or landed-cost quote into a clean line-item table so you can compare freight, duty assumptions and hidden fees before you accept it.

E-commerceIntermediate · Edit variables or configuration before use.FreePublished Oct 31, 2026
Tested on✓ Gemini✓ DeepSeekSee test log

The prompt

You help a small importer read a DDP or landed-cost quote. Use only numbers and terms that appear in the quote text. Do not invent duty rates, HS codes or fees.

Quote text:
{{quote_text}}

Product (optional context): {{product}}
Destination: {{destination}}
Currency I want the table in: {{currency}}

1. Restate every cost line you can find (product, freight, insurance, duty/tax if stated, brokerage, other). If a line is missing, write "not stated" — do not fill it in.
2. Build a markdown table: Line | Amount | Stated as | Notes.
3. List assumptions the seller seems to be making (Incoterm, who files entry, whether VAT/GST is included).
4. Give 5 clarifying questions I should send before I accept the quote.
5. End with a one-paragraph warning that duty and tax depend on classification and official rates, and that I must confirm with my broker or forwarder.

Do not calculate a "true" duty amount unless the quote already states the duty figure. Do not give legal or customs-compliance advice.

Variables

Replace each {{name}} before you send the prompt.

VariableWhat to put inExample
{{quote_text}}Paste the supplier or forwarder quote exactly.DDP Los Angeles, 500 cartons ceramic mugs. Unit FOB Ningbo USD 1.20. Ocean+truck all-in USD 2,800. Duty/tax included in DDP price of USD 0.55/pc. Valid 10 days.
{{product}}Short product description for context only.Ceramic mug, 12 oz, retail gift box
{{destination}}Destination city/country for the shipment.Los Angeles, United States
{{currency}}Currency for the output table.USD

Example

INPUT
quote_text: DDP Los Angeles, 500 cartons ceramic mugs. Unit FOB Ningbo USD 1.20. Ocean+truck all-in USD 2,800. Duty/tax included in DDP price of USD 0.55/pc. Valid 10 days.
product: Ceramic mug, 12 oz, retail gift box
destination: Los Angeles, United States
currency: USD
OUTPUT
### 1. Cost Lines Restated

* **Product:** USD 1.20 (stated as "Unit FOB Ningbo USD 1.20")
* **Freight:** USD 2,800 (stated as "Ocean+truck all-in USD 2,800")
* **Insurance:** Not stated
* **Duty/Tax:** USD 0.55/pc (stated as "Duty/tax included in DDP price of USD 0.55/pc")
* **Brokerage:** Not stated
* **Other:** Not stated

---

### 2. Cost Breakdown Table

| Line | Amount | Stated as | Notes |
| :--- | :--- | :--- | :--- |
| **Product** | USD 1.20 | Unit FOB Ningbo USD 1.20 | Quoted per unit FOB Ningbo. |
| **Freight** | USD 2,800 | Ocean+truck all-in USD 2,800 | Covers combined ocean and truck transport to Los Angeles. |
| **Duty / Tax** | USD 0.55 | Duty/tax included in DDP price of USD 0.55/pc | Quoted on a per-piece basis. |
| **Insurance** | Not stated | Not stated | No cargo insurance line is provided in the quote. |
| **Brokerage** | Not stated | Not stated | No separate customs brokerage entry fee is itemized. |
| **Other Charges** | Not stated | Not stated | Destination terminal, port, or accessorial fees are not itemized separately. |

---

### 3. Seller Assumptions

* **Incoterm:** The seller assumes the transaction is governed by **DDP Los Angeles** (Delivered Duty Paid), with a validity period of 10 days.
* **Who files entry:** Under standard DDP, the seller arranges customs clearance; however, the quote does not state whether the seller or the buyer will act as the Importer of Record (IOR) or who physically files the entry with U.S. Customs.
* **Taxes & Fees:** The seller assumes that all applicable duties and taxes are fully covered by a flat allowance of **USD 0.55/pc**, but does not specify whether this includes merchandise processing fees (MPF), harbor maintenance fees (HMF), or local taxes.
* **Total Quantity:** The seller states a volume of "500…

Real, unedited output from a test run on Oct 31, 2026 · Gemini · model gemini-flash-latest.

Full output · Gemini (gemini-flash-latest)
### 1. Cost Lines Restated

* **Product:** USD 1.20 (stated as "Unit FOB Ningbo USD 1.20")
* **Freight:** USD 2,800 (stated as "Ocean+truck all-in USD 2,800")
* **Insurance:** Not stated
* **Duty/Tax:** USD 0.55/pc (stated as "Duty/tax included in DDP price of USD 0.55/pc")
* **Brokerage:** Not stated
* **Other:** Not stated

---

### 2. Cost Breakdown Table

| Line | Amount | Stated as | Notes |
| :--- | :--- | :--- | :--- |
| **Product** | USD 1.20 | Unit FOB Ningbo USD 1.20 | Quoted per unit FOB Ningbo. |
| **Freight** | USD 2,800 | Ocean+truck all-in USD 2,800 | Covers combined ocean and truck transport to Los Angeles. |
| **Duty / Tax** | USD 0.55 | Duty/tax included in DDP price of USD 0.55/pc | Quoted on a per-piece basis. |
| **Insurance** | Not stated | Not stated | No cargo insurance line is provided in the quote. |
| **Brokerage** | Not stated | Not stated | No separate customs brokerage entry fee is itemized. |
| **Other Charges** | Not stated | Not stated | Destination terminal, port, or accessorial fees are not itemized separately. |

---

### 3. Seller Assumptions

* **Incoterm:** The seller assumes the transaction is governed by **DDP Los Angeles** (Delivered Duty Paid), with a validity period of 10 days.
* **Who files entry:** Under standard DDP, the seller arranges customs clearance; however, the quote does not state whether the seller or the buyer will act as the Importer of Record (IOR) or who physically files the entry with U.S. Customs.
* **Taxes & Fees:** The seller assumes that all applicable duties and taxes are fully covered by a flat allowance of **USD 0.55/pc**, but does not specify whether this includes merchandise processing fees (MPF), harbor maintenance fees (HMF), or local taxes.
* **Total Quantity:** The seller states a volume of "500 cartons," assuming the buyer understands the exact piece-per-carton count, as the duty/tax component is calculated per piece rather than per carton.

---

### 4. Clarifying Questions to Send Before Accepting

1. How many individual mugs/pieces are packed in each of the 500 cartons, and what is the total piece count for this shipment?
2. Does the "USD 0.55/pc" figure cover all official import duties, Merchandise Processing Fees (MPF), and Harbor Maintenance Fees (HMF), and will you (the seller) act as the Importer of Record?
3. Does the "Ocean+truck all-in USD 2,800" cover full door delivery to our specific Los Angeles address, or does it end at the Los Angeles port/terminal?
4. Are transit/marine cargo insurance and destination unloading (e.g., liftgate, residential delivery, or detention) included in this price?
5. How does the total per-piece cost calculate overall—is the total price per piece USD 1.75 (USD 1.20 FOB + USD 0.55 duty/tax) plus a prorated share of the USD 2,800 freight, or is freight billed completely separately?

---

### 5. Notice Regarding Duty and Taxes

Please note that actual import duties, taxes, and government clearance fees depend entirely on the official tariff classification (HS/HTS code), country of origin, and the valuation rules applied by U.S. Customs and Border Protection at the time of entry. A flat or seller-quoted duty rate may not match the actual legal assessment upon arrival. You must verify the applicable classification, duty rates, and required import fees directly with a licensed customs broker or freight forwarder before finalizing this agreement.
Full output · DeepSeek (deepseek-flash)
Based only on the quote text:

### 1. Restated cost lines found in the quote

- **Product:** Unit FOB Ningbo USD 1.20.
- **Freight:** Ocean+truck all-in USD 2,800.
- **Insurance:** not stated.
- **Duty/tax:** included in DDP price of USD 0.55/pc; no separate duty/tax amount is stated.
- **Brokerage:** not stated.
- **Other cost lines:** not stated.  
  The quote also states **DDP Los Angeles**, **500 cartons ceramic mugs**, and **valid 10 days**, but those are not separate cost lines.

### 2. Cost table

| Line | Amount | Stated as | Notes |
|---|---:|---|---|
| Product / FOB | USD 1.20/unit | Unit FOB Ningbo USD 1.20 | Quote says “Unit”; pieces per carton are not stated. |
| Ocean+truck freight | USD 2,800 all-in | Ocean+truck all-in USD 2,800 | What “all-in” covers is not detailed in the quote. |
| Insurance | not stated | not stated | No insurance line appears in the quote. |
| Duty/tax | Included in DDP price of USD 0.55/pc | Duty/tax included in DDP price of USD 0.55/pc | No separate duty/tax amount is stated. |
| DDP price | USD 0.55/pc | DDP price of USD 0.55/pc | The wording should be confirmed: whether USD 0.55/pc is the full DDP unit price or a duty/tax component. |
| Brokerage | not stated | not stated | No brokerage line appears in the quote. |
| Other cost lines | not stated | not stated | Quote states DDP Los Angeles, 500 cartons ceramic mugs, valid 10 days; no other cost line is stated. |

### 3. Assumptions the seller appears to be making

- The Incoterm appears to be **DDP Los Angeles**.
- The seller appears to treat **duty/tax as included in the DDP price of USD 0.55/pc**, but the quote does not separately state a duty/tax amount or tax type.
- The quote does **not** name VAT/GST; it only says “Duty/tax included.”
- The quantity is stated as **500 cartons**, but pieces per carton or total pieces are not stated.
- The quote gives **Unit FOB Ningbo USD 1.20** and a **DDP price of USD 0.55/pc**, but it does not reconcile these figures.
- The quote does **not** state who files entry or who is importer of record under DDP.
- The quote says **Ocean+truck all-in USD 2,800**, but it does not state whether insurance, brokerage, or other charges are included.
- The quote is stated as **valid 10 days**.

### 4. Five clarifying questions to send before accepting

1. Please confirm whether **USD 0.55/pc** is the full DDP unit price, or whether it is a duty/tax component within a different DDP price.
2. How many pieces are in each of the **500 cartons**, and what is the total piece count?
3. Does **Ocean+truck all-in USD 2,800** include all freight and destination charges to Los Angeles, and are insurance and brokerage included or extra?
4. Under **DDP Los Angeles**, who files entry / is importer of record, and are all duties, taxes, and brokerage included in the quoted DDP price?
5. Please confirm the exact validity end date for the **10-day** validity and whether any other charges apply beyond the lines stated.

### 5. Warning

Duty and tax depend on classification and official rates. This quote states that duty/tax are included in the DDP price of USD 0.55/pc, but it does not separately state a duty/tax amount, HS code, or rate. I must confirm classification, official rates, and exactly what the DDP price includes with my broker or forwarder before accepting the quote.

How to use it

Works in ChatGPT, Claude, Gemini and DeepSeek. Paste the prompt, fill the variables, and keep the original quote beside the answer so you can spot anything the model skipped.

Use this when a supplier or forwarder sends a DDP number that mixes product, freight and “duty included” into one line. It will not replace your customs broker.

Test log

Date (UTC)ToolModelRunResultChecksTokens in / out
Oct 31, 2026Geminigemini-flash-latestTestPassed
3/3
  • ✓ non-empty output (3414 chars)
  • ✓ length usable (200–4000 words) (570 words)
  • ✓ no obvious api key leak
311 / 909
Oct 31, 2026DeepSeekdeepseek-flashTestPassed
3/3
  • ✓ non-empty output (3336 chars)
  • ✓ length usable (200–4000 words) (594 words)
  • ✓ no obvious api key leak
326 / 5,982

Each row is a real run recorded by our test runner. For each tool, the latest test run decides whether it appears under “Tested on”. Baseline runs do the same task with no skill installed and never count.