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.

3 lines · 6 cost line(s) · landed cost factor ×1.5750Σbalanced6/6
SKUProduct / variantRecvRejUnit CNYUnit USDLine valueAgentDomesticQCFreightDutyMPFAllocatedLanded totalLanded unitUpliftNew cost
BW-SP-01Silicone spatula set (3 pc)120009.801.37631651.5783.0734.5168.97315.58227.2911.57740.992392.561.9944.9%1.99
BW-WH-02Stainless whisk 30 cm5881214.502.03641197.3960.2211.2833.79673.52164.788.39951.982149.373.6679.5%3.66
BW-BD-03Bamboo cutting board — Large300038.005.33671601.0180.5345.5417.24490.90220.3311.21865.752466.768.2254.1%8.22
Total · 3 lines2088124449.97223.8291.33120.001480.00612.4031.172558.727008.69×1.575057.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 & FX
03Costs
04Allocate & export

01Receipt lines

SKU
Product / variant
Received
Rejected
Unit cost (CNY)
Weight / unit (g)
Volume / unit (cm³)
Costs are shared only between lines with a received quantity. Rejected units take no share.

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.

ECB reference rate via Frankfurter, 2026-09-18

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

3 lines · 6 cost lines · factor ×1.5750Σbalanced6/6
SKUProduct / variantRecvRejUnit CNYUnit USDLine valueAgentDomesticQCFreightDutyMPFAllocatedLanded totalLanded unitUpliftNew cost
BW-SP-01Silicone spatula set (3 pc)120009.801.37631651.5783.0734.5168.97315.58227.2911.57740.992392.561.9944.9%1.99
BW-WH-02Stainless whisk 30 cm5881214.502.03641197.3960.2211.2833.79673.52164.788.39951.982149.373.6679.5%3.66
BW-BD-03Bamboo cutting board — Large300038.005.33671601.0180.5345.5417.24490.90220.3311.21865.752466.768.2254.1%8.22
Total · 3 lines2088124449.97223.8291.33120.001480.00612.4031.172558.727008.69×1.575057.5%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
5% sourcing agent · Agent commissionBy value1593.00 CNY223.82223.82Σ to the cent
Factory → Ningbo CFS · Domestic freight (China)By weight650.00 CNY91.3391.33Σ to the cent
Pre-shipment inspection · Sample / QC inspectionBy quantity120.00 USD120.00120.00Σ to the cent
LCL Ningbo → Los Angeles · International freightBy volume1480.00 USD1480.001480.00Σ to the cent
Entry 7501 — duty · Duty (from customs entry)By value612.40 USD612.40612.40Σ to the cent
MPF / processing fee · MPF / processing feeBy value31.17 USD31.1731.17Σ to the cent
Landed total
7008.69 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment