Landed cost: how do you calculate it and get it into stock value?

What is landed cost, and which charges belong in it?

Landed cost is what an item really cost by the time it is on your shelf and ready to sell. It starts with the supplier price and adds every charge you paid to get the goods there: international freight, cargo insurance, customs duty, customs fees, the broker who cleared them and the haulier who delivered them from the port. Without those charges, stock value and gross margin are both wrong, and they are wrong by different amounts for different items.

The accounting rule behind it is the same idea. Under IAS 2 Inventories, the cost of purchased stock includes the purchase price, import duties and other taxes that cannot be recovered, and transport, handling and other costs directly attributable to buying the goods, less trade discounts and rebates. Taxes you can reclaim, such as import VAT for a VAT-registered UK business, stay out. Your accountant should confirm the policy for your reporting framework. The table shows how the common charges usually fall.

How do you calculate landed cost? A worked example

The formula is simple: landed cost per unit equals the supplier price per unit plus that unit’s share of each import charge. The hard part is the share. The illustrative shipment below is one 40-foot container shipped by sea to a US port for a plumbing distributor. All prices, fees and duty rates are invented for the example except the two US customs fee rates, which are linked to their sources. Check your own duty rates in the Harmonized Tariff Schedule or, for the UK, the UK Trade Tariff.

Now split the charges two ways. The first spreads every charge by goods value, which is the default in many ERPs. The second uses the basis that actually caused each charge: duty as calculated per line, value-based fees and insurance by value, and freight and delivery by volume, because a container is usually full by space before it is full by weight.

Both methods add up to the same $5,856.42, so the stock value of the whole shipment is the same. What changes is which item carries it. Spread by value, the bulky hose reels look $4.16 a unit cheaper than they are, and the dense fittings look more expensive. Sales then discounts the wrong product. The total is right and the decisions are wrong, which is why a landed-cost check should compare item margins, not just the shipment total.

Should you allocate landed costs by value, weight, volume or quantity?

Use the basis that caused the charge. If the charge would double when this item’s weight doubled, allocate by weight; if it would double when the value doubled, allocate by value. Most ERPs let you choose a basis per charge on the landed-cost document. If yours allows only one basis per document, split the charges into two documents rather than forcing everything onto value.

Volume and weight allocation only work when the item master holds carton dimensions and weights. Many distributors discover during a landed-cost project that half their items have no dimensions or have dimensions for the single unit rather than the shipping carton. Fix that data first, for the items that travel in containers.

How does the duty base differ between the US and the UK?

Duty is a percentage of a customs value, and the two markets define that value differently. In the US, duty is normally charged on the transaction value, the price paid for goods sold for export to the US. International freight and insurance are excluded from it when they are included in the price and supported by evidence such as a rated bill of lading, under 19 CFR 152.103. In the UK, HMRC’s guidance on delivery costs to include in the customs value adds transport, insurance, loading and handling up to the place where the goods enter the UK.

For the ERP, the practical consequence is that duty cannot be estimated with one formula for both markets. A business importing into both should hold the duty basis on the import route or the supplier’s country, and estimate on that basis until the broker’s actual figures arrive. Duty rates and additional tariffs change, so estimates should read the rate from a maintained table, not from a number typed into a spreadsheet last year. This article explains costing, not customs advice: your broker owns the classification and the declaration.

What happens when the freight invoice arrives after the stock is sold?

Goods usually arrive before all the bills do. The broker’s duty invoice may take a week; a freight forwarder’s final invoice can take a month or more. Meanwhile the warehouse has received the goods and sales is shipping them. If the ERP waits for every invoice before costing the receipt, stock sits at supplier price only and every early sale shows an inflated margin.

The usual answer is to cost the receipt with estimated charges, then true up when the invoices arrive. Continuing the example: the receipt was costed with an estimated freight charge of $3,000. The forwarder’s final invoice, five weeks later, is $3,600. By then 300 of the 400 hose reels and 1,200 of the 2,000 fittings have been sold.

ERPs differ in how they post this. Some split the difference between sold and unsold stock as above. Some add it all to the remaining units, which overstates their cost. Others post it to a purchase price variance account. Decide which treatment you want with your accountant, then test that the ERP does it, because the default is not always the one you expect. Set three rules at the same time:

• Estimates. Estimate each charge from a rate table per route and supplier, and record it as an accrual so the liability is visible before the invoice arrives.
• Tolerance. Agree a variance, for example 5% or a fixed amount per shipment, below which the difference is posted without review and above which someone checks the invoice before it is applied.
• Cut-off. Decide what happens to invoices that arrive after a month-end close, so a late freight bill does not reopen a closed period.

Which records move between the forwarder, broker, accounts payable and the ERP?

Landed cost touches more parties than any other purchasing process. The supplier, the forwarder, the customs broker, the haulier and accounts payable each hold one piece, and the ERP needs all of them tied to the same shipment. The map below follows the example container. Each step names who decides and what passes on.

The shipment reference is the integration point. If the forwarder and broker put it on their invoices, or send their data electronically against it, accounts payable can match each bill to the right receipt without a spreadsheet. If they do not, landed cost becomes a monthly reconciliation exercise and the estimates are never corrected. The invoice matching itself is part of the purchase-to-pay control; the stock side of the receipt is covered in the inventory replenishment guide.

How do you set up landed cost in the ERP and prove it works?

Before relying on the result, run these checks with copies of real shipments:

Landed cost is also a test of the ERP itself; the distribution ERP software guide lists it among the checks to run in a demonstration. The accounting and reporting service describes how Harmatiq connects purchasing, customs and finance records so that stock value and margins reflect what goods really cost.