How Do I Calculate Landed Cost for Imported Ecommerce Inventory?

Where should the landed-cost boundary end?

Define the boundary before collecting numbers. For an importer, a practical accounting boundary is the point at which sellable inventory is received at the warehouse or 3PL in its present location and condition. IAS 2 says inventory cost includes purchase, conversion, and other costs incurred to bring inventory to that location and condition. It is measured at the lower of cost and net realizable value.

That principle is narrower than some commercial “door-to-customer” calculators. Outbound fulfillment, last-mile delivery to the buyer, payment processing, marketplace commission, advertising, and customer service normally occur after inventory is ready for sale. They are essential to contribution margin, but combining them with accounting inventory cost can capitalize selling costs and obscure period expenses.

The exact accounting and tax treatment depends on the entity, jurisdiction, reporting framework, and facts. US taxpayers should also apply the inventory and capitalization rules relevant to their tax method; IRS Publication 334 confirms that freight-in on merchandise purchased for sale is part of cost of goods sold but is not a complete rulebook for every entity.

What data do I need before calculating anything?

Build a shipment cost packet linked to purchase order, commercial invoice, customs entry, bill of lading or airway bill, freight-forwarder invoice, broker statement, duty receipt, insurance, port/terminal invoices, and warehouse receipt. For every SKU, capture units ordered, sellable units received, unit purchase price, declared customs value, duty classification and rate, gross weight, volume, carton count, and direct charges.

Also preserve currency and exchange-rate policy. The supplier invoice, duty entry, and freight bills may use different currencies and dates. A landed-cost worksheet with unlabeled converted amounts cannot be reproduced. Store source currency, rate, rate date, converted amount, and policy.

Which allocation driver should each shared cost use?

This allocation matrix is the first original value component. Choose causality, not convenience:

When no perfect driver exists, choose the most faithful available proxy, apply it consistently to similar shipments, and disclose the limitation. Material judgment should be reviewed; immaterial costs can use a simpler documented basis.

How do I calculate a mixed-SKU shipment?

The second original component is a two-stage model: calculate the shipment total, then allocate each cost pool independently. Do not calculate one blended “freight percentage” and apply it to every future purchase.

Hypothetical example—assumptions. A retailer imports 600 units of lightweight Product A at $12 and 200 units of heavier Product B at $28. A weighs 0.5 kg per unit; B weighs 2 kg. The shipment has $2,400 freight, $128 insurance, $896 duty already calculated by the customs line, $576 broker/port cost, and $400 inland delivery. All numbers are hypothetical USD amounts; there is no recoverable import tax in the example, and every unit received is sellable.

Calculation check: purchase is $12,800 and shared/import costs are $4,400, so shipment landed cost is $17,200. Product allocations also total $9,336 + $7,864 = $17,200. The allocation is balanced before unit costs are posted.

Interpretation. A's supplier price rises from $12.00 to $15.56 per sellable unit; B rises from $28.00 to $39.32. Equal allocation of $4,400 over 800 units would add $5.50 to both SKUs and substantially understate the heavier B product.

Limits. Actual duty must come from correct classification, origin, customs value, and current law. If units are damaged, missing, or unsellable, the allocation and loss treatment need review rather than quietly dividing all cost across fewer units. Abnormal costs may be expensed instead of capitalized.

How should estimates be reconciled to actual costs?

Use a purchase-decision estimate before placing the order and an actual landed-cost close after the final invoices arrive. The estimate helps price and approve cash; the actual number values inventory and explains margin. Mixing the two without a true-up leaves standard costs drifting away from reality.

1. At purchase approval, estimate product, freight, insurance, duty, broker/port, and inland costs with source and expiry date.
2. Record goods in transit and provisional landed-cost accruals under the accounting policy.
3. At receipt, confirm sellable quantities, warehouse date, and shipment identity.
4. Replace each estimate with invoice/customs actuals and rerun the same allocation drivers.
5. Calculate variance by cost pool, SKU, and reason: rate, quantity, FX, classification, delay, damage, or missing invoice.
6. Post the true-up to inventory on hand and cost of goods sold as appropriate for units already sold.
7. Update purchasing assumptions only for repeatable changes, not one-off abnormal costs.

Definition of done: source invoices and customs totals equal the shipment cost pools; allocations balance to the shipment; unit costs tie to the inventory ledger; sold and unsold portions receive the approved true-up; and every estimate variance has a reason.

Which anomalies should I investigate first?

1. Customs mismatch: duty or customs value does not tie to the entry—review classification, origin, assists, valuation, and invoice mapping before allocation.
2. Quantity mismatch: received or sellable units differ from the purchase order—separate loss/damage and claim status.
3. Freight outlier: freight per kg or cubic meter changes materially—check mode, chargeable weight, split shipment, surcharge, and duplicate invoice.
4. Unassigned invoice: broker or forwarder cost lacks shipment/PO identity—do not spread it across the month as a plug.
5. Recoverable tax included: import VAT/GST that should be a receivable is capitalized—confirm recoverability and documentation.
6. Post-boundary cost included: outbound fulfillment or ads enter inventory—move them to the commercial margin layer.

What should I check before using the unit cost?

• The warehouse-ready boundary is written.
• Every cost has a source document and currency.
• Recoverable and nonrecoverable taxes are separated.
• Duty is mapped by customs line/SKU.
• Shared costs use causal allocation drivers.
• Allocations balance exactly to shipment totals.
• Sellable quantity and losses are reviewed.
• Estimate-to-actual variances have reasons.
• Inventory and sold-unit true-ups are posted.
• Channel selling costs remain visible outside inventory.

When does this method require professional review?

Seek customs and accounting advice for uncertain tariff classification, related-party valuation, antidumping or special tariffs, buyer-supplied assists, complex Incoterms, recoverable-tax ambiguity, abnormal demurrage, material damage, intercompany transfers, or a change in costing method. US Customs and Border Protection states that formal and informal entries can carry processing fees, while ocean shipments may also have harbor-maintenance fees; current fee rates and bases must be checked for the actual entry.

Caigeek can help when the inputs are purchase orders, customs entries, freight/broker invoices, receiving data, and the inventory ledger. Useful outputs are a shipment cost packet, allocation workpaper, SKU unit-cost upload, estimate-to-actual variance report, and reconciliation—not a single unsupported percentage added to every SKU.

Frequently asked questions