The Real Cost of Ignoring Landed Costs (And How to Track Them Properly)

Most distributors track only the invoice price. The freight, customs, insurance, and duties disappear into "overhead." Then margins mysteriously vanish.

You price products at 30% margin. You win quotes. You ship on time. And yet profit on paper never matches what you expected. The gap is often not sales performance — it is cost visibility. When true acquisition cost per unit is wrong, every downstream decision is wrong: pricing, promotions, reorder quantities, and supplier negotiations.

Landed cost is the fix. It is also one of the most commonly skipped disciplines in small and mid-size distribution.

What is landed cost?

Landed cost is the full cost to put one unit of inventory into your warehouse and ready to sell. It is not the supplier invoice alone.

A complete landed cost calculation typically includes:

• Product cost — the unit price on the purchase order
• Freight — ocean, air, or road transport to your facility
• Customs and duties — import tariffs and border fees
• Insurance — cargo coverage during transit
• Handling — port fees, unloading, inspection, and internal put-away labor tied to the receipt

The goal is to express all of these as a per-unit cost on each goods receipt line. That number becomes the basis for margin analysis, FIFO layers, and weighted average cost (WAC).

If you only book $40 per unit when the true all-in cost is $52, you are making pricing decisions on fiction.

The hidden margin killer

Consider a parts distributor importing 100 units at $40 each. The invoice total is $4,000. Management assumes a healthy margin at resale.

Then the shipment lands:

• Freight: $800
• Import duty: $250
• Insurance and handling: $150

Total additional cost: $1,200. True landed total: $5,200, or $52 per unit — not $40.

| Metric | At invoice cost ($40) | At landed cost ($52) | | --- | --- | --- | | Revenue per unit (example) | $58 | $58 | | Gross profit per unit | $18 | $6 | | Gross margin | 31% | 10% |

A business that believed it had ~30% margin actually has ~10% on that batch. Multiply that across fast-moving SKUs and the P&L damage is severe. Worse, slow-moving items may show profit on paper while fast movers subsidize hidden losses.

This is why landed cost must be captured at receipt, not buried in a monthly overhead journal entry months later.

How to allocate cost pools correctly

When one shipment contains multiple SKUs, you need a fair way to split shared costs (freight, duty, insurance) across lines. Three common methods:

By value

Allocate proportional to line extended cost. Higher-value lines absorb more freight. This works well when weight and volume are similar across items — for example, mixed electronic components in similar packaging.

Example: Freight $500 on a $5,000 PO → each line receives (line value / $5,000) × $500.

By weight

Allocate proportional to total weight per line. Best for dense, heavy goods where transport is priced primarily by kilogram — steel fittings, batteries, liquids.

Example: Line A is 200 kg of a 1,000 kg shipment with $2,000 freight → Line A receives $400 freight.

By volume

Allocate proportional to cubic volume. Critical for light but bulky products — foam, packaging materials, empty containers — where freight quotes are based on CBM, not weight.

Example: Two SKUs share a container; SKU occupying 60% of volume receives 60% of ocean freight.

Professional systems let you choose the allocation basis per cost pool (freight by weight, duty by value, etc.). Rigid one-size-fits-all spreadsheets usually pick value for everything and silently misallocate half your catalog.

FIFO vs WAC when landed cost varies per shipment

The same SKU rarely lands at the same cost every time. Currency moves, fuel surcharges change, and duty classifications get updated.

FIFO (first in, first out) tracks each receipt as a separate cost layer. When you sell, you consume the oldest layer first. Landed cost per layer can differ — Batch A at $52, Batch B at $49. Margin per sale reflects the actual layer consumed. FIFO is precise and audit-friendly; it is the right choice when lot traceability and cost accuracy matter.

WAC (weighted average cost) blends all on-hand units into one average unit cost after each receipt. Simpler mentally, but a single expensive shipment immediately shifts average cost for the entire pool — which can mask which batch caused the spike.

Neither method works if landed cost was never recorded on receipt. Both depend on clean inbound data.

Why manual Excel tracking breaks at scale

Spreadsheets can model landed cost for a handful of POs. They fail when:

• Multiple receipts arrive weekly with shared freight invoices
• Cost pools must be split across dozens of lines with different allocation rules
• FIFO layers must be preserved per batch for traceability
• Finance needs receipt-level audit history, not a single "adjusted cost" column
• Team members update files at different times, breaking version control

At scale, Excel becomes a reconciliation project instead of an operational tool. By the time someone rebuilds the model, the damage is already in sold goods and customer quotes.

Close the gap at goods receipt

A modern inventory system should calculate landed cost automatically on each goods receipt line: capture cost pools, apply the right allocation method, and post per-unit landed cost into your stock layers without a separate spreadsheet project.

That is how distributors protect margin before the sale — not after the year-end surprise.

Inveta's landed cost engine allocates freight, customs, and duties across your batches automatically. Try it free.