China imports
China import costs: deposit & balance rates, agent fee, domestic leg, inspection
A typical order from a Chinese factory has six bills in two currencies, paid on three dates. Here is how each one lands in cost per item — on the real PO-1042 sample.
The rule in one paragraph
Supplier lines are in CNY; the 30% deposit paid on 18 September keeps that day’s rate, the 70% balance takes the receipt-day rate, and the blended rate is applied to every line (IAS 21 practice, as Landara documents it). The agent’s 5% is a cost of the goods — by value. The factory-to-port truck is freight — by weight. The inspection is a flat visit — by quantity. Ocean LCL is per cubic metre — by volume. Duty and MPF from the customs entry — by value. Six bills, four methods, one Σ BALANCED stamp.
Why the obvious shortcut is wrong
Converting everything at today’s rate ignores the money you actually sent in September. Lumping agent fee, truck and inspection into “other” and spreading it by value makes the cutting boards pay for an inspector who counted spatulas. And a US importer has no recoverable import tax, so nothing here is excluded — whereas a UK or EU importer would add import VAT as recoverable and watch it stay out of cost.
A worked example
PO-1042: three kitchen SKUs from Ningbo, six bills, CNY and USD
Goods CNY 31,686 (after 12 rejected whisks). Deposit CNY 9,558 at 0.1403, balance at 0.1405. The ledger shows every bill’s column; hover any cell for its arithmetic.
| SKU | Product / variant | Recv | Rej | Unit CNY | Unit USD | Line value | Agent | Domestic | QC | Freight | Duty | MPF | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BW-SP-01 | Silicone spatula set (3 pc) | 1200 | 0 | 9.80 | 1.3763 | 1651.57 | 83.07 | 34.51 | 68.97 | 315.58 | 227.29 | 11.57 | 740.99 | 2392.56 | 1.99 | 44.9% | 1.99 |
| BW-WH-02 | Stainless whisk 30 cm | 588 | 12 | 14.50 | 2.0364 | 1197.39 | 60.22 | 11.28 | 33.79 | 673.52 | 164.78 | 8.39 | 951.98 | 2149.37 | 3.66 | 79.5% | 3.66 |
| BW-BD-03 | Bamboo cutting board — Large | 300 | 0 | 38.00 | 5.3367 | 1601.01 | 80.53 | 45.54 | 17.24 | 490.90 | 220.33 | 11.21 | 865.75 | 2466.76 | 8.22 | 54.1% | 8.22 |
| Total · 3 lines | 2088 | 12 | 4449.97 | 223.82 | 91.33 | 120.00 | 1480.00 | 612.40 | 31.17 | 2558.72 | 7008.69 | ×1.5750 | 57.5% | ||||
What we record
- Both exchange rates with their dates and sources (ECB via Frankfurter, or your bank slip).
- Each bill’s currency, converted amount and method.
- Rejected units (the 12 whisks) listed and excluded from every share.
If you only remember one thing
Six bills, each with its own currency and its own method — and the deposit keeps the rate you actually paid.
Try it
Change any number — the stamp stays balanced
The same engine as the home page allocator, preloaded with the example.
01Receipt lines
02Payments & exchange rate
Rate: ECB reference rate via Frankfurter, 2026-11-10. Edit it to use your bank’s rate; the source is recorded on the report.
03Costs to allocate
Each bill picks its own method. Defaults follow what moves the cost: freight by weight, duty by value, brokerage per unit.Duty: use the amount on your customs entry (CBP 7501 line totals); this tool does not classify HS codes. MPF: use the amount printed on the entry — the prefill is the 0.3464% ad valorem part before the yearly minimum and maximum.
04Landed cost by SKU
| SKU | Product / variant | Recv | Rej | Unit CNY | Unit USD | Line value | Agent | Domestic | QC | Freight | Duty | MPF | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BW-SP-01 | Silicone spatula set (3 pc) | 1200 | 0 | 9.80 | 1.3763 | 1651.57 | 83.07 | 34.51 | 68.97 | 315.58 | 227.29 | 11.57 | 740.99 | 2392.56 | 1.99 | 44.9% | 1.99 |
| BW-WH-02 | Stainless whisk 30 cm | 588 | 12 | 14.50 | 2.0364 | 1197.39 | 60.22 | 11.28 | 33.79 | 673.52 | 164.78 | 8.39 | 951.98 | 2149.37 | 3.66 | 79.5% | 3.66 |
| BW-BD-03 | Bamboo cutting board — Large | 300 | 0 | 38.00 | 5.3367 | 1601.01 | 80.53 | 45.54 | 17.24 | 490.90 | 220.33 | 11.21 | 865.75 | 2466.76 | 8.22 | 54.1% | 8.22 |
| Total · 3 lines | 2088 | 12 | 4449.97 | 223.82 | 91.33 | 120.00 | 1480.00 | 612.40 | 31.17 | 2558.72 | 7008.69 | ×1.5750 | 57.5% | ||||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| 5% sourcing agent · Agent commission | By value | 1593.00 CNY | 223.82 | 223.82 | Σ to the cent |
| Factory → Ningbo CFS · Domestic freight (China) | By weight | 650.00 CNY | 91.33 | 91.33 | Σ to the cent |
| Pre-shipment inspection · Sample / QC inspection | By quantity | 120.00 USD | 120.00 | 120.00 | Σ to the cent |
| LCL Ningbo → Los Angeles · International freight | By volume | 1480.00 USD | 1480.00 | 1480.00 | Σ to the cent |
| Entry 7501 — duty · Duty (from customs entry) | By value | 612.40 USD | 612.40 | 612.40 | Σ to the cent |
| MPF / processing fee · MPF / processing fee | By value | 31.17 USD | 31.17 | 31.17 | Σ to the cent |