Landed Cost: Calculating the True Cost of Imported Goods in an ERP

Many importers and distributors know the purchase price from their overseas suppliers in great detail, yet do not really know what the goods cost once they are sitting in the warehouse. Between the supplier price and goods ready for sale lie sea or air freight, insurance, import duty, port charges, customs brokerage, inland transport, and exchange rate differences. If these costs are not assigned correctly to each item, the calculated selling price and margin can be far off.

The concept that solves this is called landed cost: the total cost of bringing goods to your location ready to sell or use. This article explains the components of landed cost, how to allocate them to each item, the import tax treatment that is often handled wrongly, the effect of exchange rates, and how an ERP automates the calculation.

Summary

• Landed cost is the purchase price plus all costs needed to bring goods to the warehouse in a condition ready for sale
• Additional costs should be allocated to each item on a sensible basis, such as value, weight, volume, or quantity
• Not every import tax is a cost; some can be credited or are prepayments of income tax
• Costs whose invoices arrive later should be estimated and then adjusted, so cost of goods sold is not updated too late
• An ERP that records landed cost per shipment helps set selling prices, assess suppliers, and compare shipping routes

Components of landed cost

Which components go into landed cost depends on the delivery terms agreed with the supplier, known as incoterms. Under FOB terms, for example, the buyer bears freight and insurance from the port of origin. Under CIF terms, both are already included in the supplier price. So the first step is to confirm which costs the company bears for each purchase.

• The supplier price of the goods, in the transaction currency
• International sea or air freight, if not included in the price
• Shipping insurance
• Import duty and other import levies that are a cost
• Port and terminal charges, such as container handling and storage
• Customs brokerage and documentation services
• Transport from the port to the warehouse, including loading and unloading
• Inspection, certification, or licensing costs specific to certain goods

Costs incurred after goods are in the warehouse, such as routine storage or delivery to customers, are generally not included in landed cost but treated as operating expenses. This boundary should be agreed with finance and the auditors so it is applied consistently.

Import tax treatment

One of the most common mistakes is adding every import levy to the cost of goods. In Indonesia, imports are generally subject to import duty, import VAT, and Article 22 import income tax, with rules that depend on the type of goods and the importer's status. Import duty is essentially part of the cost of goods. Import VAT for VAT registered businesses can generally be credited as input tax, so it does not add to the cost of goods. Article 22 import income tax is generally a prepayment of income tax, not a cost of goods.

Detailed rules can change and differ from case to case, so tax treatment should be confirmed with a tax adviser. What matters on the system side is that the ERP separates levies that are part of the cost of goods from levies recorded as tax receivables or prepaid taxes. A broader discussion of ERP and tax integration is in the article on e-invoicing and tax compliance.

Allocating costs to each item

One container often holds dozens of item types with different values, weights, and sizes. Additional costs such as freight or customs brokerage are usually billed for the whole shipment, so they need to be divided across items. The common allocation bases are as follows.

• By value: suits insurance and costs related to the price of goods, including import duty calculated on customs value
• By weight: suits air freight or heavy goods of small size
• By volume: suits sea freight and goods that are light but take up space
• By unit quantity: simple, but only fair if the items are similar

Each cost type can use a different basis within one shipment. Sea freight is divided by volume, insurance by value, and special inspection costs are charged directly to the items inspected. For weight and volume based calculations to work, item master data must hold accurate weights and dimensions for every code.

A simple example

Suppose one shipment contains two items. Item A is high value but small, while item B is cheap but bulky. If sea freight is divided by value, item A carries most of the freight, even though item B uses more of the container. As a result, item A's cost is too high and item B's cost is too low. Item B's selling price may look profitable when, after freight is allocated correctly, its margin is thin. Using volume as the basis gives a more honest picture of both items' margins.

The effect of exchange rates

Overseas supplier prices are usually in US dollars, yuan, or other currencies, while some other costs are in rupiah. The rupiah value of the goods depends on which rate is used: the rate at order, at receipt, or at payment. The company's accounting policy determines which rate values inventory, while exchange differences at payment are usually recorded separately as foreign exchange gains or losses.

An ERP that supports multiple currencies records transaction values in both the original currency and rupiah, so cost of goods sold and exchange difference reports can be traced. For high volume importers, monitoring the effect of exchange rates on cost per shipment helps decide when selling prices need adjusting.

Costs that arrive later

Goods are often received, and some even sold, before all cost invoices arrive. Customs brokerage or inland transport invoices may come weeks later. If cost of goods sold is only updated when the invoice arrives, sales in between are recorded with a cost that is too low.

The solution is to record estimated costs when goods are received, based on contract rates or the average of previous shipments, then adjust when the actual invoice arrives. The difference between estimate and actual is charged to remaining inventory and to cost of goods sold for items already sold, according to accounting policy. This process also makes cost accruals at the monthly close more accurate, and import cost invoices can be matched through an accounts payable automation flow.

How an ERP manages landed cost

1. 01The purchase order is created in the supplier's currency, with incoterms recorded
2. 02Each shipment is recorded as one document grouping its items, containers, and import documents
3. 03When goods are received, the system adds estimated costs based on a template per route or supplier
4. 04Cost invoices from shipping lines, agents, and other parties are linked to the relevant shipment
5. 05The system allocates each cost to items on the chosen basis, then updates inventory value
6. 06Differences between estimate and actual are adjusted, and a landed cost report per shipment is available for analysis

With this data, the company can answer questions that used to be hard: which supplier is actually cheapest once all costs are counted, which route is more efficient, and what share of the goods price the additional costs represent for each category. This information is very useful when evaluating suppliers and building stock planning and reordering, because transit time and import cost affect the economic order quantity.

Impact on selling price and margin

Accurate landed cost is the basis of healthy pricing. A distributor that sets prices from the supplier price plus a fixed percentage risks losses on bulky, light items, or overpricing small, high value items. With correct cost per item, prices can be set on the desired margin, and margin reports per item and per customer become trustworthy. This principle is explained further in the article on COGS and product cost accounting in the ERP.

Common mistakes

• Recording inventory at the supplier price only, then booking all import costs as general expenses
• Dividing all costs by item value, even though freight is driven more by volume or weight
• Adding creditable or prepaid taxes to the cost of goods
• Waiting for every invoice to arrive before updating cost of goods sold
• Not recording incoterms, so it is unclear which costs the company bears

Frequently asked questions

Does a small business that imports occasionally need to calculate landed cost? Yes, at least with a tidy spreadsheet per shipment. Without it, the selling price of imported goods is only a guess.

Which allocation basis is most correct? No single basis is always correct. Choose the basis that best reflects what drives the cost, use it consistently, and document it in the accounting policy.

What about imported goods for own use, such as machinery? The principle is the same. Costs needed to bring a machine to a ready to use condition generally form part of the asset's acquisition cost, according to the applicable accounting standards.

Does our existing ERP already support landed cost? Many ERPs have this feature, but it is often not configured or supports only one allocation basis. Check its capabilities before deciding to add a module or integration.

Conclusion

Landed cost bridges the supplier price and the true cost of goods ready for sale. By recording every cost component per shipment, separating taxes that are a cost from those that can be credited, allocating costs on a sensible basis, and adjusting estimates when invoices arrive, importers and distributors get a cost of goods sold they can trust. The result is more accurate selling prices, fairer supplier assessment, and margins that are truly visible.