Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Landed cost, costing sheet & margin: how it works

Every cost of a trade order or shipment — freight, insurance, duty, excise, clearing, port, inland transport, bank and LC charges — in its own currency and rate, spread over the lines by value, weight, volume or quantity, giving the unit landed cost in base currency, the gross margin and the FX gain or loss per order and per shipment.

Lesson 5 of 8 · How it works

  • about 3 min
  • Trade documents & LCs → Costing & margin

How it works

  1. «Add cost» on the costing sheet: kind, description, supplier, amount, currency and its rate, how to spread it, and whether it belongs to one shipment (spread over that shipment's part of the goods) or the whole order.

  2. Landed cost The cost of goods delivered to your door: purchase price + freight, insurance, duty, clearing, port, inland and bank costs, spread to each product. More words in the glossary per line = goods at the order rate + the shares of the costs; the unit landed cost divides by the quantity. A weight or volume split with no weights entered falls back to value and says so.

  3. Margin: Export Export downloads a list as a file: CSV or XLSX for Excel, or JSON for other software. Import loads records from a file into a list. More words in the glossary = sale value − cost of goods (enter it per line) − costs; import = resale value (per line) − purchase value − costs. Margin % and the margin per shipment are shown.

  4. FX: enter the settlement rate (order or per shipment); the foreign amount at the settlement rate against the order rate is the gain or loss.

  5. «Book as bill» puts a cost into Money → Expenses as the supplier's bill.

  6. Import orders: «Send to landed cost» creates a draft purchasing landed cost on the linked purchase order with this allocation; posting it raises the cost of the received stock and books Inventory against the payables or re-classes the booked bills — no parallel ledger.

  7. «Print costing sheet» prints the sheet through the branded documents in the document languages.

Where to find it

Checklist

Before you move on, check that you can:

  • Open Trade documents & LCs → Costing & margin
  • Add cost on the costing sheet: kind, description, supplier, amount, currency and its rate, how to spread it,…
  • Landed cost per line = goods at the order rate + the shares of the costs; the unit landed cost divides by…
  • Margin: export = sale value − cost of goods (enter it per line) − costs; import = resale value (per line) −…
  • FX: enter the settlement rate (order or per shipment); the foreign amount at the settlement rate against the…

Tips and common mistakes

  • Import VAT is never part of the landed cost: it is recoverable input tax.
  • Receive the goods on the purchase order before sending costs to the landed cost — posting spreads over what was received.
  • Every line that carries a cost must be a product; free-text lines cannot hold a stock cost.