How to calculate landed cost, and why spreadsheets fail
What landed cost includes, how to allocate freight, duty, and fees to the unit, and why a trade ERP tracks it in real time where a spreadsheet cannot.
Key takeaways
- Landed cost is the full cost of a product delivered to your door: unit price plus freight, insurance, duty, and fees.
- The hard part is allocation: spreading shared costs like a container's freight and duty across the units inside it, fairly and consistently.
- Spreadsheets fail because the inputs arrive at different times and the allocation has to be redone by hand every time a number changes.
- A trade ERP allocates costs to the unit as they arrive, so landed cost and margin are known at receipt rather than at month end.
- Getting landed cost right is what makes pricing, margin, and inventory valuation trustworthy.
Ask an importer what a product costs and the honest answer is often "the supplier price, plus some other stuff we true up later." The "other stuff" is freight, duty, insurance, and fees, and it is frequently a large share of the real cost. Until it is allocated to the unit, pricing is a guess and margin is unknown. This is what landed cost is for, and it is also why so many importers run it on a spreadsheet that is always a month behind.
What landed cost includes
Landed cost is the full cost of a product delivered and ready to sell. It starts with the unit price and adds every charge tied to getting the goods there: international freight, domestic freight, insurance, customs duty, broker and port fees, and any handling or storage along the way. Leave any of these out and you understate the cost, overstate the margin, and misvalue the inventory sitting in your warehouse.
The real work is allocation
The direct cost, what you paid the supplier for a unit, is easy. The difficulty is the shared costs. A single container's freight covers everything inside it, and the duty applies across many lines. To get a cost per unit, you have to spread those shared charges across the units, using a consistent basis. Common choices are each product's share of total value, total weight, or total volume, and the right one depends on what is actually driving the cost. Freight often tracks volume or weight, while duty tracks value. Pick a basis, apply it consistently, and document it.
Why spreadsheets fail here
A spreadsheet can do the allocation once. The problem is that the inputs do not arrive at once. The supplier invoice is first. The freight invoice shows up weeks later. Duty is set at clearance. A fee gets adjusted after that. Every time a number lands, the allocation has to be redone across all the affected units, and with dozens of shipments and hundreds of products in flight, that manual rework falls behind and drifts out of accuracy. The spreadsheet is not wrong in principle; it just cannot keep up with the timing.
What a trade ERP does differently
A trade ERP built for import treats landed cost as something that accrues. As each cost arrives, the supplier invoice, the freight bill, the duty, the fees, the system allocates it to the units on that shipment using the basis you set. Landed cost and margin update as the picture fills in, so by the time goods are received you know what they cost rather than waiting for a close. Inventory is then valued at true landed cost automatically, which is also what your accounting needs.
Why it matters beyond accounting
Landed cost is not just a finance number. It decides whether a product is worth selling at the price the market will bear, which supplier is actually cheapest once freight and duty are included, and whether a sourcing decision made sense after the fact. Teams that only see supplier price make these calls half-blind. Teams that see landed cost per unit make them on the real number.
If landed cost is a monthly spreadsheet exercise in your operation, moving it into the system that already captures your purchase orders and shipments is usually the fastest accuracy win available. Tell us how you source and import, or see how we build trade ERP.
Frequently asked questions
What is landed cost?
Landed cost is the total cost of getting a product to your door, not just what you paid the supplier. It includes the unit price plus international and domestic freight, insurance, customs duty, broker and port fees, and any other charges tied to the shipment. Knowing landed cost per unit is what lets an importer price products correctly, measure true margin, and value inventory accurately. The purchase price alone almost always understates what a product really costs.
How do you calculate landed cost per unit?
Add up all the costs tied to a shipment, then allocate the shared ones across the units in it. The unit price is direct. Freight, duty, insurance, and fees are usually shared across many units, so you spread them using a consistent basis such as value, weight, or volume. For example, a container's freight might be allocated by each product's share of total value or total volume. The result is a fully loaded cost per unit rather than just the supplier's price.
Why is landed cost hard to track in spreadsheets?
Because the inputs arrive at different times and the math has to be redone every time one changes. The supplier invoice comes first, the freight invoice weeks later, the duty after clearance, and a fee adjustment later still. Each new number means re-allocating across the units by hand, and with many shipments and products that becomes error-prone and always out of date. A system that allocates automatically as costs arrive keeps landed cost current without the manual rework.