Total Landed Cost: How to Split One Shipment’s Freight and Duty Across Many SKUs
By the LandedCostSKU team · updated 2026-11-15 · 7 min read
"Total landed cost" is the shipment number — goods plus everything it took to get them to your door. It is also the easy number: add up the bills. The hard part is turning one total into a cost per SKU that is fair to each line, because a shipment is never one product. This is how the split works, and where it goes wrong.
Four bases, one rule
A bill is shared in proportion to a basis. Pick the basis that caused the bill:
| Basis | Share of line i | Use for | |---|---|---| | Value | line value ÷ Σ value | Duty, MPF, insurance, agent commission — anything assessed on what the goods are worth | | Quantity | units ÷ Σ units | Brokerage, entry filing, inspection — flat fees that do not care what a unit is | | Weight | kg ÷ Σ kg | Air and courier freight, trucking — billed per kilogram | | Volume | m³ ÷ Σ m³ | LCL sea freight — billed per cubic metre |
The rule is the same for all four: share = bill × basis_i ÷ Σ basis. What changes is what counts.
The same shipment, four ways
Two lines: 100 watches at 80.00 (0.1 kg, 0.001 m³ each) and 900 storage bins at 5.00 (0.5 kg, 0.004 m³). A 3,000 freight bill:
| Basis | Watches' share | Bins' share | Watch landed unit | |---|---|---|---| | Value (8,000 : 4,500) | 1,920.00 | 1,080.00 | 99.20 | | Quantity (100 : 900) | 300.00 | 2,700.00 | 83.00 | | Weight (10 kg : 450 kg) | 65.22 | 2,934.78 | 80.65 | | Volume (0.1 m³ : 3.6 m³) | 81.08 | 2,918.92 | 80.81 |
Same bill, a 19-dollar swing in what a watch "costs". If that freight was LCL priced per cubic metre, only the last row is right — and the bins, which take up the container, carry 97% of it. Allocating by value would have made the watches subsidise the bins' shipping.
Mixing methods on one receipt
Real shipments carry several bills, and they rarely share a basis. Duty on the same shipment is by value: the watches' 8,000 of 12,500 → 64% of the duty, however light they are. So a receipt needs a method per bill, not per shipment. A single global switch — the way most free calculators work — forces you to choose which bill to get wrong.
Free allocator
Split your freight, duty and agent fee across the units you received — and download the Shopify CSV.
Allocate my shipmentRounding that closes
Shares are computed exactly and then rounded. If you round each cell on its own, a 100.00 fee over three equal lines shows 33.33 three times under a total that still reads 100.00 — a cent that exists in the total and nowhere in the lines. Largest remainder fixes it: floor every share to the cent, then hand the remaining cents to the lines with the biggest fractional parts (33.34 + 33.33 + 33.33). Every bill's column adds up to the bill. Over a year of receipts that is the difference between a ledger that reconciles and one that does not.
Two cases that break naive calculators
A missing weight. If one line has no weight and you allocate by weight, a blank is not zero kilograms — it is an unknown. Calculators that treat it as 0 silently push the whole bill onto the other lines. The right behaviour is to stop, name the SKU, and offer to switch that bill to quantity.
A partial receipt. When 600 of 900 tees arrive this week, this week's courier bill belongs to the 600, not the 900. Allocating across the full PO parks cost on goods still at sea — and when they arrive with their own bill, they get charged twice. Costs follow the units that physically came with them; see partial receiving.
From shipment total to cost per item
Landed unit for a line is (line value + Σ its shares) ÷ units received. The shipment's landed cost factor is Σ landed ÷ Σ goods — 1.24 means every dollar of goods cost $1.24 landed, a useful sanity check against last quarter. And the number that goes into Shopify is either that landed unit or, if you already hold stock, the moving average of the old cost and the new.
Each method has its own page with a worked example and a mini allocator locked to that basis: by value, by weight, by quantity, by volume.