Odoo ERP for Import-Export Business: Manage Trade, Compliance & Multi-Currency Easily

An import-export trading company manages shipments across 12 countries. Purchase orders are raised in USD, EUR, and AED. Sales are invoiced in the buyer’s local currency. The landed cost calculation — freight, insurance, customs duty, and port handling — is done in a spreadsheet after each shipment clears customs. Customs documents are prepared by a logistics coordinator who copies product descriptions and HS codes from emails. Three suppliers consistently invoice with discrepancies against the purchase order. The finance team runs separate reports for foreign currency gains and losses at month end. The compliance team tracks export licenses and letter of credit expiry dates in a shared Excel file.

When a single shipment involves four currencies, three freight legs, two intermediaries, and a compliance document with an expiry date, the spreadsheet-based operation fails in predictable ways. Documents are late. Landed costs are wrong. Exposure to currency movements is untracked.

Odoo for import export business operations consolidates trade finance, landed cost accounting, customs documentation, and multi-currency management in a single platform. This guide covers which Odoo modules matter for import-export businesses, how landed cost and multi-currency management work in Odoo, and what to verify before engaging an implementation partner.

Landed cost calculations done in spreadsheets after shipment clearance — inventory costs always wrong at first entry. When freight, insurance, customs duty, and port charges are entered into accounting after the goods arrive in stock, the initial inventory valuation is wrong. Products are received at PO price and later adjusted. The adjustment is manual, often delayed, and sometimes missed entirely. Cost of goods sold is understated until the adjustment is made. For businesses with multiple shipments per week, the inventory cost is always in flux because the landed cost allocation is always late.

Multi-currency purchase and sale tracking maintained outside the accounting system. Import-export businesses buy in one currency and sell in another. The foreign exchange gain or loss on each transaction — the difference between the rate at invoice date and the rate at payment date — should be captured automatically. When the accounting system does not handle multi-currency natively, this calculation is done manually at month end. It is always an approximation, it is time-consuming, and it is the most common source of unexplained P&L variance in trading businesses.

Trade compliance documents and letter of credit expiry managed in spreadsheets — deadlines missed. Letters of credit, export licenses, import permits, and shipping document deadlines have hard cut-off dates. A missed LC presentation deadline can result in non-payment. A missed export license renewal creates a compliance breach. When these deadlines are tracked in a shared spreadsheet, they are missed when the person who maintains the spreadsheet is absent, when the spreadsheet is not updated after a change, or when the volume of shipments exceeds the capacity of manual tracking.

Odoo handles the full import-export trade cycle — purchase order in foreign currency, goods receipt, landed cost allocation, sales order and invoice in buyer currency, foreign currency revaluation, and trade document management — within a single platform. The purchase module manages supplier orders and receipts. Inventory handles goods receipt and valuation. Accounting handles multi-currency transactions, landed costs, and forex revaluation. Contacts manage supplier and customer records with trade terms. Documents link to shipment records throughout the workflow.

Multi-Currency Management

Odoo Accounting is built for multi-currency operation. Each transaction is recorded in both the transaction currency and the company’s base currency. Exchange rates are updated automatically from configurable rate sources — daily, weekly, or manually. At the time of payment, Odoo calculates the forex gain or loss automatically from the difference between the invoice rate and the payment rate, and posts the forex entry to the designated exchange gain/loss account. Month-end forex revaluation — recalculating open payables and receivables at the current rate — runs as an Odoo Accounting batch operation, not a manual spreadsheet calculation.

For import-export businesses with transactions in USD, EUR, GBP, AED, and other currencies simultaneously, Odoo manages each currency independently against the base currency throughout the transaction lifecycle.

Landed Cost Management

Landed costs in Odoo are allocated to specific goods receipts after the shipment clears. The landed cost record — freight, insurance, customs duty, port handling — is entered against the receipt. Odoo allocates the cost across the received products using the configured allocation method: by quantity, by weight, by volume, or by product value. The inventory valuation of each product is updated automatically from the landed cost allocation. Cost of goods sold reflects the true landed cost from the point the allocation is entered — not from a later spreadsheet adjustment.

For shipments where the final landed cost is not known at receipt — customs duty calculated after clearance, freight invoiced weeks after delivery — Odoo supports a provisional cost entry at receipt and a cost adjustment when the actual invoices arrive.

1. Purchase — Supplier Orders in Foreign Currency

Odoo Purchase manages the procurement side of the import-export trade cycle.

Purchase orders in supplier currency. Each purchase order in Odoo is issued in the supplier’s currency — USD, EUR, CNY, or other configured currencies. The PO price is recorded in the transaction currency and the base currency equivalent at the rate on the PO date. When the supplier invoice arrives, Odoo matches it to the PO in the supplier currency. Any difference between the PO rate and the invoice rate is flagged as a price variance or recorded as a forex adjustment, depending on the configuration.

Landed cost integration from purchase receipts. Purchase receipts in Odoo are the anchor for landed cost allocation. When goods are received against a PO, the receipt generates the inventory valuation entry at PO cost. The landed cost record is then attached to the same receipt — linking the freight, duty, and handling costs directly to the goods received and the inventory valuation.

Supplier lead time and shipment tracking. Supplier records in Odoo carry lead times by product and by origin country. Scheduled receipt dates on purchase orders are calculated from the PO confirmation date and the configured lead time. Shipments in transit are visible as open receipts in Odoo Inventory — the goods are not in stock yet, but the expected arrival date and the incoming quantity are visible from the purchasing dashboard.

2. Inventory — Goods Receipt, Costing, and Customs Documentation

Odoo Inventory handles the physical side of import-export operations.

Goods receipt with serial and lot tracking. Goods received from international suppliers are received into Odoo Inventory against the purchase order. Serial number and lot tracking at receipt is standard for import-export businesses managing goods with batch certificates or country-of-origin requirements. The received lot is linked to the supplier, the origin country, and the shipment record in Odoo.

Average cost and FIFO valuation with landed costs. Odoo Inventory supports average cost (AVCO) and first-in-first-out (FIFO) inventory valuation. Landed cost allocations update the inventory valuation in real time — a goods receipt followed immediately by a landed cost entry gives an accurate cost basis for the received goods without delay. FIFO valuation for import-export businesses with multiple shipments of the same product at different landed costs gives an accurate cost basis per shipment.

Product and HS code management. Import-export products in Odoo carry HS (Harmonized System) codes, country of origin, and customs tariff information on the product record. These details are referenced when generating customs declarations and shipping documents — the data is entered once on the product record and reused across all shipments involving that product.

3. Accounting — Multi-Currency, Landed Costs, and Trade Finance

Odoo Accounting is the financial backbone of an odoo for import export business implementation.

Automatic forex gain/loss posting. When a supplier invoice in foreign currency is paid at a different rate than the invoice date rate, Odoo calculates and posts the forex gain or loss automatically to the configured exchange difference account. The payment entry, the forex entry, and the invoice clearing are all generated from a single payment action in Odoo. The accountant does not manually calculate the forex impact of each payment.

Multi-currency bank reconciliation. Foreign currency bank accounts are managed in Odoo Accounting with their own currency. Bank statement lines in foreign currency are reconciled against the corresponding invoices or payments — also in foreign currency. The reconciliation difference (forex movement between statement date and transaction date) is posted automatically. For import-export businesses with bank accounts in USD, EUR, and GBP alongside the base currency account, Odoo manages all accounts in a single reconciliation interface.

Trade finance document management. Letters of credit, bank guarantees, and documentary collections are tracked in Odoo as attachments to the relevant purchase or sales order. Expiry dates and presentation deadlines are recorded as activities on the order record. The finance team works from a system-driven task list for upcoming LC presentations rather than a shared spreadsheet. Expiry alerts are generated automatically before the deadline.

Landed cost posting and inventory revaluation. Landed cost records in Odoo Accounting update both the inventory asset account (increasing the carrying value of the goods) and allocate the cost to the corresponding landed cost expense account (freight payable, duty payable). The journal entries are generated automatically from the landed cost record — no manual journal required.

4. Sales — Export Invoicing and Customer Trade Terms

Odoo Sales manages the export side of the import-export trade cycle.

Sales orders and invoices in buyer currency. Export sales orders are issued in the buyer’s currency — with the base currency equivalent calculated at the rate on the order date. When the invoice is issued and paid, Odoo tracks the forex movement from order to invoice to payment and posts the exchange difference automatically.

Incoterm and trade term management. Each sales order and purchase order in Odoo carries an Incoterm field — FOB, CIF, DDP, EXW, and others. Incoterms drive the cost responsibility boundary between buyer and seller and are referenced in customs documentation. Incoterms are configured as a selection field on the order record — they are visible to the finance, logistics, and compliance teams from the same record.

Customer-specific trade terms and credit management. Export customers often have specific payment terms — letter of credit, documents against payment, open account with 60-day net. These are configured on the customer record in Odoo and applied automatically to sales orders for that customer. The AR aging report shows export receivables by customer, by currency, and by due date — giving the finance team a consolidated view of outstanding export receivables without manual aggregation.

5. Purchase — Import Compliance and Supplier Document Management

Import license and compliance document tracking. Import permits, phytosanitary certificates, and product compliance documents are tracked in Odoo against the relevant purchase orders and product records. Expiry dates generate alerts to the compliance team before the document lapses. A purchase order for a regulated product cannot be confirmed without the required import permit being on file — the compliance check is a system control, not a procedural reminder.

Country-of-origin and certificate management. For products requiring certificates of origin — either for customs preference purposes or for the buyer’s compliance requirements — Odoo tracks the certificate against the shipment record. The certificate is generated or uploaded in Odoo and linked to the goods receipt and the sales order for traceability across the full supply chain.

Odoo for Different Import-Export Business Types

Odoo import-export management implementation scope varies by trade model.

Import trading companies buying finished goods from international suppliers and selling domestically use odoo for import export business operations with Purchase for foreign currency supplier orders, Inventory for landed cost allocation, and Accounting for multi-currency reconciliation and forex management. Odoo import export workflows for trading companies center on the purchase-to-stock cycle with accurate landed cost allocation at each shipment.

Export manufacturers selling finished goods to international buyers use Sales for multi-currency export invoicing, Accounting for export AR management and forex gain/loss tracking, and Inventory for export lot tracking and certificate of origin management.

Freight forwarders and customs brokers handling third-party shipment documentation use Purchase and Inventory for shipment record management and Accounting for multi-currency billing to clients. HS code and customs tariff management on the product record drives customs documentation generation.

Multi-country trading businesses managing both import sourcing and export distribution use the full Odoo import export trade cycle — Purchase, Inventory, Sales, and Accounting — with multi-company configuration for entities in different jurisdictions. Intercompany transactions between import and export entities are managed in Odoo with matching records on both sides.

Odoo resolution: Landed costs are entered in Odoo against the purchase receipt. Odoo allocates the freight, duty, and handling costs across the received products automatically using the configured method. Inventory valuation is updated at the time of landed cost entry — no separate spreadsheet, no delayed adjustment.

Problem: Forex gain/loss calculated manually at month end — always an approximation.

Odoo resolution: Odoo calculates forex gain or loss automatically at each payment event — the difference between the invoice rate and the payment rate is posted to the exchange difference account without manual calculation. Month-end forex revaluation of open payables and receivables runs as a batch operation in Odoo Accounting.

Problem: LC and trade document deadlines missed — spreadsheet not updated or person absent.

Odoo resolution: Trade finance documents are tracked in Odoo with expiry dates as system activities. Alerts are generated automatically before deadlines. The compliance team works from a system-driven task list — document expiry is not dependent on a single person’s spreadsheet discipline.

Problem: Customs document preparation requires copying HS codes and product descriptions from emails.

Odoo resolution: HS codes, country of origin, and product descriptions are stored on the product record in Odoo and referenced automatically when customs-related documents are generated. The data is entered once and reused across all shipments for that product.

Document the trade structure — import countries, export destinations, transaction currencies, and base currency. Configure exchange rate sources and update frequency in Odoo Accounting. Define the inventory valuation method (AVCO or FIFO) before any goods are received. Configure the chart of accounts with the required landed cost expense accounts, forex gain/loss accounts, and foreign currency bank accounts.

Step 2: Product and HS Code Setup

Build the product catalogue in Odoo with HS codes, country of origin, and customs tariff information on each product record. For import-export businesses with large product ranges, this is typically a bulk import from the existing product master. Verify HS code accuracy — errors in HS codes cause customs clearance delays and duty calculation errors at every subsequent shipment.

Step 3: Supplier and Customer Record Configuration

Set up supplier records with their transaction currency, payment terms, and country. Set up customer records with their trade terms, Incoterm defaults, and payment terms. Configure letter of credit and documentary collection templates for the payment terms that require them.

Step 4: Landed Cost and Purchase Workflow Testing

Test the full import purchase cycle: PO in foreign currency → goods receipt → landed cost entry (freight, duty, handling) → inventory valuation verification → supplier invoice matching → payment with forex calculation. Verify that the inventory cost after landed cost allocation matches the expected manual calculation.

Step 5: Export Sales and Multi-Currency Testing

Test the full export sales cycle: sales order in buyer currency → invoice generation → payment receipt → forex gain/loss posting → AR reconciliation. Verify the forex entries against a manually calculated expected figure for a test transaction at a known rate difference.

Step 6: Go-Live and Opening Balance Migration

Migrate opening inventory balances at the correct landed cost — not at PO cost without freight and duty. Migrate open purchase orders with their foreign currency amounts and expected receipt dates. Migrate open letters of credit and compliance document expiry dates into Odoo activities. Run a parallel period of two to four weeks before switching off the legacy system — the parallel period surfaces any currency or cost configuration errors before they affect live financial reporting.

Landed cost configuration with AVCO and FIFO. Ask the partner how they configure landed cost allocation for a business using FIFO valuation — show the cost update on the specific stock lot received. Confirm they have delivered landed cost configuration for businesses with multiple shipments of the same product at different import costs.

Trade finance document management. Ask how they set up letter of credit tracking and expiry alerts in Odoo. The correct answer uses Odoo activities on the purchase or sales order record — with configurable lead time alerts before the deadline. Partners who propose a separate document management system alongside Odoo have not configured this in Odoo before.

Opening balance migration accuracy. Ask how they handle opening inventory balances for an import-export business — specifically whether the opening values include the landed cost component or only the PO cost. Correct opening balances including landed cost are the foundation of accurate COGS from day one. Partners who propose PO-cost-only opening balances will create a systematic COGS understatement that persists until a manual adjustment is made.

Related Reading on BiztechCS

• Odoo ERP Implementation Services
• Odoo Accounting Module
• Odoo Inventory Module
• Odoo ERP for Trading Company
• Hire Odoo Developers — BiztechCS