Allocation method

Allocate landed cost by value

Duty, insurance and agent commission are charged on what the goods are worth. Share them in proportion to each line’s value, so a $6 tray carries more duty than a 95¢ spoon.

The rule in one paragraph

A cost allocated by value is split in proportion to each received line’s value in your store currency (received quantity × unit cost × exchange rate). Lines with nothing received take no share. Each bill is rounded to the cent with the largest remainder method, so the column adds up to the bill.

Why the obvious shortcut is wrong

Dividing duty by the number of units gives every spoon the same duty as every tray. But duty was assessed on the entered value: the tray line is 63% of the invoice, so it owes 63% of the duty. Per-unit duty misprices both — the cheap item looks expensive and the expensive item looks like a bargain.

A worked example

PO-2201: duty 313.50 and insurance 42.00 across three acacia lines

Goods 4,585.00: trays 2,500.00 (54.5%), bowls 1,230.00 (26.8%), spoons 855.00 (18.6%). Each bill follows those shares — the spoons are 56% of the units but carry 18.6% of the duty.

3 lines · 2 cost line(s) · landed cost factor ×1.0775Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueDutyInsuranceAllocatedLanded totalLanded unitUpliftNew cost
EH-TRAY-01Acacia serving tray 40 cm40006.252500.00170.9422.90193.842693.846.737.8%6.73
EH-BOWL-02Acacia salad bowl 25 cm30004.101230.0084.1011.2795.371325.374.427.8%4.42
EH-SPOON-03Serving spoon pair90000.95855.0058.467.8366.29921.291.027.8%1.02
Total · 3 lines160004585.00313.5042.00355.504940.50×1.07757.7%

What we record

  • The exact share and its rounding for every line (hover a cell).
  • The bill’s currency, the converted amount and the Σ check per bill.
  • The basis total (Σ value) so the report can be rebuilt by hand.

If you only remember one thing

Anything the customs broker computed from the invoice value — duty, MPF, insurance premium, an agent’s percentage — is allocated by value.

Try it

Change any number — the stamp stays balanced

Every cost line in this mini allocator is locked to “by value”. The full allocator on the home page lets each bill pick its own method.

01Receipt lines
02Payments & FX
03Costs
04Allocate & export

01Receipt lines

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

02Payments & exchange rate

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 · 2 cost lines · factor ×1.0775Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueDutyInsuranceAllocatedLanded totalLanded unitUpliftNew cost
EH-TRAY-01Acacia serving tray 40 cm40006.252500.00170.9422.90193.842693.846.737.8%6.73
EH-BOWL-02Acacia salad bowl 25 cm30004.101230.0084.1011.2795.371325.374.427.8%4.42
EH-SPOON-03Serving spoon pair90000.95855.0058.467.8366.29921.291.027.8%1.02
Total · 3 lines160004585.00313.5042.00355.504940.50×1.07757.7%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
Entry 7501 — duty · Duty (from customs entry)By value313.50 USD313.50313.50Σ to the cent
Cargo insurance · InsuranceBy value42.00 USD42.0042.00Σ to the cent
Landed total
4940.50 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment