Allocation method

Allocate landed cost by volume

LCL sea freight is priced on cubic metres. A light, bulky seagrass basket costs more to ship than a dense cushion cover — share the bill by packed volume.

The rule in one paragraph

A cost allocated by volume is split in proportion to each received line’s total packed volume (received × length × width × height). Volumes fill in from the Packed product size in your Shopify export (cm or in) or are typed per unit in cm³. A missing volume blocks the run, like a missing weight.

Why the obvious shortcut is wrong

Allocating LCL freight by weight makes the dense cushion covers pay for the baskets’ air. Allocating it by value makes the expensive throw pay. The forwarder charged per cubic metre; the only share that follows the bill is the volume share.

A worked example

PO-2242: 1,140.00 of LCL freight over cushions, throws and baskets

Total packed volume 8.04 m³. The 120 baskets are 5.04 m³ — 63% of the freight for 11% of the units.

3 lines · 1 cost line(s) · landed cost factor ×1.2610Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueFreightAllocatedLanded totalLanded unitUpliftNew cost
DW-CUSH-50Cushion cover 50×5080002.101680.00170.15170.151850.152.3110.1%2.31
DW-THROW-01Woven throw 130×17020009.601920.00255.22255.222175.2210.8813.3%10.88
DW-BASKET-LSeagrass basket — large12006.40768.00714.63714.631482.6312.3693.0%12.36
Total · 3 lines112004368.001140.001140.005508.00×1.261026.1%

What we record

  • Packed volume per unit (cm³) and the shipment total in m³.
  • Where the dimensions came from (Shopify Packed product size or typed).
  • The Σ check for the freight line.

If you only remember one thing

If the quote said “per CBM”, allocate per CBM.

Try it

Change any number — the stamp stays balanced

Every cost line in this mini allocator is locked to “by volume”. 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.2610Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueFreightAllocatedLanded totalLanded unitUpliftNew cost
DW-CUSH-50Cushion cover 50×5080002.101680.00170.15170.151850.152.3110.1%2.31
DW-THROW-01Woven throw 130×17020009.601920.00255.22255.222175.2210.8813.3%10.88
DW-BASKET-LSeagrass basket — large12006.40768.00714.63714.631482.6312.3693.0%12.36
Total · 3 lines112004368.001140.001140.005508.00×1.261026.1%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
LCL Shenzhen → Rotterdam · International freightBy volume1140.00 USD1140.001140.00Σ to the cent
Landed total
5508.00 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment