Allocation method

Allocate landed cost by quantity

Brokerage, ISF filing, inspection visits and other flat fees cost the same for a $1.80 collar as for a $3.40 leash. Spread them per unit received.

The rule in one paragraph

A cost allocated by quantity is split in proportion to received units. Every unit that arrived carries the same share of the bill, whatever it cost or weighed. Rejected units take nothing.

Why the obvious shortcut is wrong

Allocating a flat $165 broker fee by value gives the leash line almost 40% of it although it is 20% of the units — the broker did not work harder on a leash. Allocating it by weight, when weights are not even on the invoice, is guesswork. Per unit is honest for a fee that is per shipment.

A worked example

PO-2230: broker 165.00 and inspection 100.00 over 1,500 units

265.00 ÷ 1,500 = 17.67¢ per unit before rounding. The collar lines (600 units each) take 106.00 of the 265.00 each; the leash line (300 units) takes 53.00.

3 lines · 2 cost line(s) · landed cost factor ×1.0810Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueBrokerageQCAllocatedLanded totalLanded unitUpliftNew cost
PS-COLLAR-SCollar — small60001.801080.0066.0040.00106.001186.001.989.8%1.98
PS-COLLAR-MCollar — medium60001.951170.0066.0040.00106.001276.002.139.1%2.13
PS-LEASH-01Leash 1.5 m30003.401020.0033.0020.0053.001073.003.585.2%3.58
Total · 3 lines150003270.00165.00100.00265.003535.00×1.08108.1%

What we record

  • Received and rejected units per line.
  • The per-unit amount of each flat fee.
  • Which fees were flat (quantity) and which were ad valorem (value) on this receipt.

If you only remember one thing

Fees that do not change with the value or weight of the goods are allocated per unit received.

Try it

Change any number — the stamp stays balanced

Every cost line in this mini allocator is locked to “by quantity”. 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.0810Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueBrokerageQCAllocatedLanded totalLanded unitUpliftNew cost
PS-COLLAR-SCollar — small60001.801080.0066.0040.00106.001186.001.989.8%1.98
PS-COLLAR-MCollar — medium60001.951170.0066.0040.00106.001276.002.139.1%2.13
PS-LEASH-01Leash 1.5 m30003.401020.0033.0020.0053.001073.003.585.2%3.58
Total · 3 lines150003270.00165.00100.00265.003535.00×1.08108.1%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
Customs broker — entry + ISF · Brokerage / clearanceBy quantity165.00 USD165.00165.00Σ to the cent
Pre-shipment inspection · Sample / QC inspectionBy quantity100.00 USD100.00100.00Σ to the cent
Landed total
3535.00 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment