Triplicate

Free export price list template

A price list for overseas buyers shows, for each item, the price under which Incoterms rule and where, in which currency, and until when. This Excel template has the columns importers look for, including the packing data they need to estimate freight and duty.

Download .xlsxAll free templates →

Export price list – Example filled in with the free generator (sample data)

What the template covers

  • Your company, price list number, date and validity
  • Currency and payment terms
  • Item number, description and HS code
  • Minimum order quantity and lead time
  • Pieces per carton, carton size, gross weight per carton, and CBM per carton calculated from the size
  • Unit prices under up to four Incoterms 2020 rules, each with its named place or port
  • Quantity price breaks, if you offer them
  • Notes: prices apply after order confirmation, and what each price includes

Guides on this topic

Name the rule, the place and the edition

A price such as "USD 3.20 FOB" is incomplete. Write the Incoterms rule with a precise place and the edition, for example "FOB Busan Incoterms 2020" or "FCA Ho Chi Minh City warehouse Incoterms 2020". FOB and CIF are for sea and inland waterway transport only; FCA works for any mode, including containers and air freight. Quote one currency per list.

Packing data saves a round of questions

Importers compare offers on landed cost, so give pieces per carton, carton size, gross weight and CBM per carton for each item. With these and the HS code, the buyer can estimate freight and import duty without writing back. Triplicate's CBM and landed cost calculators use the same figures.

Validity, MOQ and price breaks

Put an end date on the list and say that prices apply only after order confirmation, so an old list is not used months later. Show the minimum order quantity and lead time for each item, and quantity price breaks if you offer them. To work out FCA, FOB or CIF prices from your own cost, use the export price calculator and copy the results into the list.

Common questions

What should an export price list include?

For each item: description, HS code, MOQ, packing data and the unit price under a named Incoterms rule and place. For the whole list: currency, date, validity, payment terms and lead time.

Should I quote EXW, FOB or CIF?

Quote the terms your buyers ask for and can compare. Buyers who book their own freight often ask for FCA or FOB at your warehouse or port; others want CIF or CIP to their port. You can show several price columns, each with its own named place.

How do I calculate the FOB price from my cost?

Add what it costs to deliver the goods on board at the named port and cleared for export, such as inland transport, export clearance and origin charges, plus your margin. Triplicate's export price calculator does this from your unit cost and markup and also gives prices for the other Incoterms rules.

How long should the prices be valid?

Long enough for the buyer to decide, and short enough to protect you against cost and exchange rate changes. Write the end date on the list and confirm the price on each order.

Should I send the price list as Excel or PDF?

Buyers like Excel because they can sort and compare, but the file is easy to edit and forward. Many exporters send a PDF as well, with the list number and date on every page.

More free tools

Share with a colleagueWhatsAppLinkedInX

Triplicate is free and keeps getting better. Found it useful? Support Triplicate ♥