Landed Cost Calculator for Goods Imported from China: Deposit, Balance, Freight and Duty, Line by Line
By the LandedCostSKU team · updated 2026-11-15 · 9 min read
A landed cost calculator earns its name when it can take a real Chinese purchase order — paid in two instalments, shipped LCL, cleared by a broker, with an agent on commission — and hand back one number per SKU that your Shopify profit reports can use. Most calculators stop at "add freight and duty, divide by value". This article walks the whole way, with our own sample numbers, so you can follow each step by hand or in the free allocator.
The shipment
PO-1042 from a kitchenware factory in Ningbo, invoiced in CNY:
| SKU | Product | Ordered | Received | Rejected | Unit price (CNY) | Weight / unit | Packed volume / unit | |---|---|---|---|---|---|---|---| | BW-SP-01 | Silicone spatula set (3 pc) | 1,200 | 1,200 | 0 | 9.80 | 180 g | 360 cm³ | | BW-WH-02 | Stainless whisk 30 cm | 600 | 588 | 12 | 14.50 | 120 g | 1,568 cm³ | | BW-BD-03 | Bamboo cutting board, large | 300 | 300 | 0 | 38.00 | 950 g | 2,240 cm³ |
Twelve whisks arrived bent and were rejected. They are listed, and they take no share of anything.
Goods received: 1,200 × 9.80 + 588 × 14.50 + 300 × 38.00 = CNY 31,686.00.
Step 1 — two payments, two exchange rates
You paid a 30% deposit of CNY 9,558 on 18 September when the ECB reference rate was 0.1403 USD per CNY, and the balance when the goods landed on 10 November at 0.1405.
The deposit is a prepayment: it is fixed at the rate of the day you paid it and never retranslated. Only the balance takes the receipt-day rate. The effective rate for the goods is
(9,558 × 0.1403 + (31,686 − 9,558) × 0.1405) ÷ 31,686 = 0.140440
Goods in USD: 4,449.97. (If you later pay the balance at a different rate than 0.1405, that difference is an FX gain or loss of the period — it does not change inventory cost.)
Step 2 — the six bills and how each is split
| Bill | Amount | Currency | Split by | Why | |---|---|---|---|---| | LCL Ningbo → Los Angeles | 1,480.00 | USD | volume | The forwarder charged per cubic metre | | Duty (customs entry line total) | 612.40 | USD | value | Assessed on entered value | | MPF | 31.17 | USD | value | 0.3464% ad valorem | | Customs broker | 185.00 | USD | quantity | A flat fee per entry | | Sourcing agent 5% | 1,593.00 | CNY | value | Charged on the invoice value | | Factory → Ningbo CFS truck | 650.00 | CNY | weight | A truck is paid by weight | | Pre-shipment inspection | 120.00 | USD | quantity | One visit, counted per unit |
CNY bills convert at the receipt-day rate 0.1405: agent 223.82, truck 91.33.
One basis for the whole shipment would be wrong for most of these. The cutting boards are 36% of value but 62% of weight and 66% of volume; the spatulas are 42% of the units but 10% of volume. Each bill follows the thing that caused it.
Step 3 — shares that close
Each line's share of a bill is bill × its basis ÷ total basis, rounded to the cent by the largest remainder method so the column adds up to the bill. For the duty line:
Spatulas 612.40 × 1,651.11 ÷ 4,449.97 = 227.21
Whisks 612.40 × 1,197.37 ÷ 4,449.97 = 164.78
Boards 612.40 × 1,601.49 ÷ 4,449.97 = 220.41
Σ = 612.40
Try that with per-cell rounding on a 100.00 bill over three equal lines and you get 33.33 × 3 = 99.99 — the one-cent leak that makes reconciliations fail. The allocator stamps the receipt Σ BALANCED 7/7 only when every bill's shares equal the bill.
Step 4 — landed unit cost
For the spatulas: line value 1,651.11 + freight 150.50 + duty 227.21 + MPF 11.56 + broker 106.32 + agent 83.05 + truck 29.02 + inspection 68.97 = 2,327.74 over 1,200 units → 1.9398 per set, an uplift of 41.0% on the 1.3759 supplier price. (Figures from the sample report; the exact cents depend on the volume and weight totals shown there.)
The whole shipment: goods 4,449.97, bills 2,893.72, landed 7,343.69 — a landed cost factor of 1.6503. Every dollar of goods cost $1.65 landed. That number alone changes how you read your margins.
Step 5 — into Shopify
Shopify's Cost per item is one current value per variant, snapshotted onto each order when it is created. If you attach your Shopify product export in the allocator, the CSV it writes keeps every variant row of each touched product and changes only Cost per item — so the import (with "Overwrite products with matching handles") cannot create or delete variants. Holding stock already? Tick "Blend with stock on hand" and the new cost is the moving average of what you hold and what just landed.
Free allocator
Split your freight, duty and agent fee across the units you received — and download the Shopify CSV.
Allocate my shipmentWhat this calculation deliberately does not do
- It does not estimate duty. The 612.40 came off the customs entry; classification and rates are your broker's work.
- It does not allocate to units you rejected or have not received. When the 12 whisks are replaced, that is a second receipt with its own bills.
- It does not treat recoverable import VAT as a cost. A UK or EU importer adds it as "Import tax (recoverable)" and watches it stay excluded.
Those are the lines where other tools quietly guess. Here they are inputs, and the report says where each came from.