Allocation method

Allocate landed cost by weight

Air and courier freight is billed per kilogram. Give each line the share of the bill its kilograms caused — and refuse to run when a weight is missing.

The rule in one paragraph

A cost allocated by weight is split in proportion to each received line’s total weight (received quantity × weight per unit). If any received line has no weight, the run stops and names the SKUs: a blank weight is not zero kilograms, it is a missing number.

Why the obvious shortcut is wrong

Freight by value makes a 55 g strap that happens to be pricey pay for the heavy steel stakes. Freight by quantity charges the strap the same as a 960 g stake set. The forwarder weighed the cartons; use the weights. And never let a missing weight silently take 0% — that pushes the whole bill onto the other lines and nobody notices.

A worked example

PO-2214: 1,860.00 of air freight across lanterns, straps and stakes

Total weight 456.5 kg. The stakes are 300 × 960 g = 288 kg, so they carry 63% of the freight although they are only 19% of the units.

3 lines · 1 cost line(s) · landed cost factor ×1.5472Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueFreightAllocatedLanded totalLanded unitUpliftNew cost
OD-LAMP-01Camping lantern25007.801950.00417.63417.632367.639.4721.4%9.47
OD-STRAP-02Webbing strap 2 m120000.62744.00268.92268.921012.920.8436.1%0.84
OD-STAKE-03Steel tent stake (set of 8)30002.35705.001173.451173.451878.456.26166.4%6.26
Total · 3 lines175003399.001860.001860.005259.00×1.547254.7%

Same shipment with one weight missing

Remove the strap’s weight and the allocator refuses to run. Some calculators would allocate 0.00 to the strap and 1,860.00 to the other two lines — a quiet overstatement of the lantern and stake cost. Try it in the mini allocator below: clear the strap weight and press Allocate.

1 SKU has no weight: OD-STRAP-02. Add weights or switch Air freight SZX → LAX to quantity. Nothing is allocated to a blank — a blank would silently take 0 and overload the other lines.

What we record

  • Weight per unit (grams) and the basis total in kg.
  • The SKUs that blocked a run, and the switch you made (to quantity) if you made one.
  • Rejected units: they weigh something, but they take no share because you did not receive them.

If you only remember one thing

What the carrier billed by the kilo, you allocate by the kilo. A missing weight stops the run instead of hiding in a zero.

Try it

Change any number — the stamp stays balanced

Every cost line in this mini allocator is locked to “by weight”. 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 · 1 cost lines · factor ×1.5472Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueFreightAllocatedLanded totalLanded unitUpliftNew cost
OD-LAMP-01Camping lantern25007.801950.00417.63417.632367.639.4721.4%9.47
OD-STRAP-02Webbing strap 2 m120000.62744.00268.92268.921012.920.8436.1%0.84
OD-STAKE-03Steel tent stake (set of 8)30002.35705.001173.451173.451878.456.26166.4%6.26
Total · 3 lines175003399.001860.001860.005259.00×1.547254.7%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
Air freight SZX → LAX · International freightBy weight1860.00 USD1860.001860.00Σ to the cent
Landed total
5259.00 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment