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.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Freight | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DW-CUSH-50 | Cushion cover 50×50 | 800 | 0 | 2.10 | 1680.00 | 170.15 | 170.15 | 1850.15 | 2.31 | 10.1% | 2.31 |
| DW-THROW-01 | Woven throw 130×170 | 200 | 0 | 9.60 | 1920.00 | 255.22 | 255.22 | 2175.22 | 10.88 | 13.3% | 10.88 |
| DW-BASKET-L | Seagrass basket — large | 120 | 0 | 6.40 | 768.00 | 714.63 | 714.63 | 1482.63 | 12.36 | 93.0% | 12.36 |
| Total · 3 lines | 1120 | 0 | 4368.00 | 1140.00 | 1140.00 | 5508.00 | ×1.2610 | 26.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 & 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
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Freight | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DW-CUSH-50 | Cushion cover 50×50 | 800 | 0 | 2.10 | 1680.00 | 170.15 | 170.15 | 1850.15 | 2.31 | 10.1% | 2.31 |
| DW-THROW-01 | Woven throw 130×170 | 200 | 0 | 9.60 | 1920.00 | 255.22 | 255.22 | 2175.22 | 10.88 | 13.3% | 10.88 |
| DW-BASKET-L | Seagrass basket — large | 120 | 0 | 6.40 | 768.00 | 714.63 | 714.63 | 1482.63 | 12.36 | 93.0% | 12.36 |
| Total · 3 lines | 1120 | 0 | 4368.00 | 1140.00 | 1140.00 | 5508.00 | ×1.2610 | 26.1% | |||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| LCL Shenzhen → Rotterdam · International freight | By volume | 1140.00 USD | 1140.00 | 1140.00 | Σ to the cent |