How to Allocate Landed Costs in ERP for Imported Inventory

Key Takeaways

• Landed cost shows the cost of imported stock beyond the supplier invoice.
• IAS 2 includes purchase, import duties, non-recoverable taxes, transport, handling, and other directly attributable costs.
• Allocation needs a consistent basis and an audit trail.
• ERP estimates must be reconciled to actual freight, duty, and service invoices.

Why landed cost matters

An imported item can look profitable at purchase price while freight, insurance, customs duty, port handling, and other eligible charges consume the margin. Landed-cost accounting assigns those costs to the relevant receipts or items, giving finance and purchasing a more realistic view of inventory value and gross margin.

IAS 2 says inventory cost includes purchase costs, conversion costs, and other costs incurred in bringing inventory to its present location and condition. It also requires inventory to be measured at the lower of cost and net realisable value. The accounting policy and local tax treatment still need review by the responsible finance professional.

Step 1: define eligible charges

Create a charge catalogue for freight, insurance, customs duties, non-recoverable taxes, inspection, port handling, and inland transport where they are directly attributable to acquiring the goods. Separate recoverable taxes and period expenses according to your accounting policy. Do not bury storage, selling costs, abnormal waste, or unrelated administration in item cost.

Give each charge a source document: bill of lading, customs document, freight invoice, broker invoice, purchase order, or receipt reference. This makes later reconciliation possible and limits manual allocation.

Step 2: choose the allocation basis

Use value when the charge follows the commercial value of goods; quantity when units drive the service; weight or volume when freight capacity is the driver. A shipment may need different bases for different charges. The rule should be documented, consistently applied, and reviewed when product mix or transport arrangements change.

For example, if a freight charge is allocated by weight, the ERP should retain the weight used for each receipt line and the total allocation. Avoid a black-box percentage that finance cannot reproduce.

Step 3: estimate, post, and reconcile

1. Link the purchase order, shipment, receipt, and expected charge.
2. Post an estimate when goods are received if policy and system design require timely valuation.
3. Match later supplier or service invoices to the charge reference.
4. Allocate the actual amount and post the variance through an approved accounting treatment.
5. Review item cost, margin, and open accruals by shipment, supplier, route, and charge.

Oracle’s landed-cost documentation describes capturing charges, allocating them to orders and receipts, and transferring the result to receipt or cost accounting. Microsoft documentation likewise notes that estimates and actual costs can create inventory adjustments or variance postings depending on configuration.

Controls for Egyptian and MENA importers

Use one shipment or trade-operation identifier across purchasing, customs, freight, accounts payable, and inventory. Control exchange-rate assumptions and distinguish recoverable from non-recoverable taxes. Require approval for manual allocations and investigate large differences between estimated and actual charges.

Start with one import lane and a limited set of charge types. Compare the ERP result with a manually reviewed shipment, then expand after finance and supply-chain users agree on the policy and reports.