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.

Updated October 26, 2026Runs in your browser

Advertisement

Your shipment

Quantity and unit cost are required. Weight and duty rate are optional unless you pick that basis. Comma, tab or semicolon separated; a header row is ignored.
Take the amounts from your broker invoice and entry summary.

Result

Enter your numbers and press Calculate.

Advertisement

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):

What this does not cover

Advertisement

Common mix-ups

  1. 19 CFR 152.103: Transaction value of imported merchandise

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.