Trade & Shipping · Inventory costing
Multi-SKU landed cost allocator.
One invoice, one freight bill, one customs entry, many products. Paste your SKUs and choose how freight and fees are split. Duty is charged at each line's own rate. You get the landed cost of every SKU and every unit.
Your shipment
Result
Enter your numbers and press Calculate.
Multi-SKU landed cost allocator: what it does
Landed cost is easy for one product and awkward for six. A single freight invoice covers every carton, the customs broker bills the entry once, and the duty differs by tariff line. This allocator keeps those three apart on purpose. Freight and entry-level fees are shared pools that you split by a basis you choose (value, weight or units). Duty is not a shared pool at all: it is worked out line by line, at each SKU's own rate.
Shopify's Stocky page says the app will no longer be available after August 31st, 2026, and many merchants who tracked landed costs there are now rebuilding the calculation in a spreadsheet. The table below is that spreadsheet, with the rounding done so the pieces add up to the invoices. To load the result into a store, use the Shopify cost per item CSV builder.
Worked example
Three SKUs arrive on one entry: 300 tees at 5.00 (0.20 kg each, 16.5% duty), 200 mugs at 3.00 (0.45 kg, 3.5%) and 100 caps at 4.00 (0.12 kg, 7.5%). The rates are illustrative, not tariff lookups. Goods total 2,500.00. Freight of 900.00 is split by weight (60 kg, 90 kg and 12 kg), entry fees of 180.00 by value and 60.00 of other costs by units. The tees carry 333.33 of freight, 247.50 of duty, 108.00 of fees and 30.00 of other costs, so 1,500.00 of goods become 2,218.83 landed, or 7.3961 a unit. The mugs, which are heavy for their price, take 500.00 of the freight and land at 5.9210 a unit against a 3.00 purchase price. The caps land at 5.3547. All three total 3,938.50.
How it is calculated and sources
Each SKU's landed total = goods (quantity x unit cost) + its share of the freight pool + its share of the entry-fee pool + its share of other costs + duty (goods x its duty rate). A pool is split in proportion to the chosen basis (value, weight or units), working in whole cents with the largest-remainder method so the shares sum to the pool. IAS 2 counts import duties, non-recoverable taxes and transport directly attributable to the acquisition as part of the cost of purchase, but it names no basis for splitting a shared freight bill, so the basis is your accounting policy: pick one and keep using it. Recoverable VAT or GST is left out.
Amounts are in whatever single currency you enter. Sources checked on 2026-10-26 (as of that date):
- IFRS Foundation: IAS 2 Inventories (paragraphs 10, 11, 25 to 27 and 34, read from a copy of the IFRS Foundation text; the standard's own page does not show the paragraphs without a login)
- 19 CFR 152.103 (US transaction value: international freight and insurance are not part of the price actually paid or payable)
- CBP Dec. 25-10, Federal Register, July 23, 2025 (merchandise processing fee: 0.3464 percent with a minimum and a maximum limitation, adjusted each fiscal year)
- Shopify Help Center: Stocky (states the app will no longer be available after August 31st, 2026)
What this does not cover
- Currency conversion: enter every amount in one currency.
- Anti-dumping, additional tariffs and quota charges unless you put them in a duty rate or the other-costs pool.
- The customs processing fee amounts: they are adjusted each fiscal year, so take the figure from your entry summary. The MPF and HMF calculator covers the US fees.
- Tax advice. Which costs you may capitalise depends on your jurisdiction and accountant.
Common mix-ups
-
Often assumedCustoms duty is charged on my whole invoice, including the ocean freight and insurance I paid on the shipment.
What the source saysIn the worked example in 19 CFR 152.103, a $2,000 payment that includes $150 of ocean freight and insurance has a transaction value that leaves those charges out, because the transaction value excludes C.I.F. charges. Other countries can value imports differently. [1]
Checked against these sources on .
Frequently asked questions
How do you allocate landed cost to multiple products?
Add each product's goods cost, then add a share of every shared charge (freight, broker fees, insurance) using a basis you choose, and add duty at each product's own rate. Divide the product total by its units for the landed cost per unit.
Should freight be split by weight, value or quantity?
There is no single right answer. Weight tracks what the carrier charges for bulky, heavy goods; value is simple and follows the invoice; quantity suits near-identical items. IAS 2 does not prescribe a basis, so choose one, document it and use it consistently.
Is duty allocated or calculated per SKU?
Calculated. Duty is a rate on each tariff line's value, so a SKU's duty is its goods value times its own rate. Only charges billed once for the whole entry, such as broker fees, need to be allocated.
Does landed cost include import VAT or GST?
Only if you cannot recover it. IAS 2 includes import duties and other taxes except those later recoverable from the tax authority in the cost of purchase. If you reclaim the tax, leave it out.
Why do the per-unit costs not add to the invoice exactly?
Per-unit costs are shown to four decimals. Totals per SKU are exact to the cent and add up to what you paid; rounding each unit to cents can drift by a fraction of a cent per unit.
Disclaimer
TNAADO is not affiliated with Shopify, CBP or the IFRS Foundation. This is a planning calculation from the numbers you enter, not accounting, customs or tax advice; confirm treatment with your accountant or customs broker. Everything runs in your browser and nothing you enter is sent or stored.