Odoo Stock Landed Costs - Import Cost Allocation
Calculate and allocate import costs to product costs accurately
The Stock Landed Costs module helps businesses calculate and allocate costs incurred during import (shipping, insurance, import duties, customs fees) to product costs accurately.
With flexible allocation by multiple criteria and deep accounting integration, Landed Costs ensures accurate cost of goods calculation, helping businesses price correctly and analyze profits accurately.
Import Cost Terminology
Landed Costs Terms
| Fields/Button | Description |
|---|---|
| Chi phí nhập khẩu / Landed Cost | Total cost to get goods to warehouse |
| Chi phí vận chuyển / Freight Cost | Shipping cost for goods |
| Bảo hiểm / Insurance | Insurance fee for goods |
| Thuế nhập khẩu / Import Duty | Tax payable on imports |
| Phí hải quan / Customs Fee | Customs clearance fee |
| Phân bổ / Split | Distribute costs to products |
| Phương pháp phân bổ / Split Method | Method for cost allocation |
| Giá CIF / CIF Price | Cost, Insurance, Freight |
| Giá FOB / FOB Price | Free On Board |
| Điều chỉnh giá thành / Cost Adjustment | Product cost adjustment |
Allocation Methods
Split Methods
| Description / Method | Use Case |
|---|---|
| Allocate by quantity / By Quantity | Homogeneous goods, similar value |
| Allocate by weight / By Weight | Shipping costs based on weight |
| Allocate by volume / By Volume | Shipping costs based on volume |
| Allocate by value / By Current Cost | Proportional to goods value |
| Equal allocation / Equal Split | Split equally among all products |
Import Cost Types
Common costs when importing goods:
Steps
1. Freight: International shipping (sea, air)
2. Insurance: Goods insurance during transport
3. Import Duty: Import tax per regulations
4. Customs Clearance: Customs procedure fees
5. Port Charges: Seaport/airport fees
6. Inland Transportation: Domestic transport from port to warehouse
Cost Allocation Process
Landed costs calculation workflow:
Steps
1. Receive goods into warehouse and validate receipt
2. Create Landed Cost record and select receipt to allocate
3. Add cost types incurred (freight, insurance, duty)
4. Choose allocation method for each cost type
5. System automatically calculates allocation per product
6. Review and validate - system creates cost adjustment entry
7. Product costs are updated automatically
Key Features
Key points
• Flexible cost allocation by multiple methods
• Support multiple cost types in one import
• Automatic allocation calculation per product
• Accounting integration - auto-create adjustment entries
• Automatic product cost updates
• Detailed import cost reports
• Multi-currency support for international costs
• Complete audit trail for all adjustments
Landed Costs Configuration
Cost Setup
| Configuration | Description |
|---|---|
| Product (Service) | Create service product for each cost type |
| Split Method | Choose default allocation method |
| Expense Account | Temporary expense account |
| Valuation Account | Inventory value adjustment account |
| Journal | Journal for landed costs entries |
Integration with Other Modules
Landed Costs integrates with modules:
Key points
• Stock: Get receipt info and update product costs
• Accounting: Auto-create cost adjustment entries
• Purchase: Link with import purchase orders
• Product: Update product cost price
Real-world Scenario
Example of import cost allocation:
Steps
1. Import 100 Product A (FOB $10) and 50 Product B (FOB $20)
2. Shipping cost: $500 (allocate by value)
3. Insurance: $100 (allocate by value)
4. Import duty: $300 (allocate by value)
5. Total FOB value: 100×$10 + 50×$20 = $2,000
6. Total landed cost: $900 (45% of FOB)
7. Product A: $10 + $10×45% = $14.5/unit
8. Product B: $20 + $20×45% = $29/unit
Best Practices
Steps
1. Create separate service products for each cost type
2. Choose appropriate allocation method for each cost
3. Record landed costs immediately after receipt
4. Review calculations carefully before validation
5. Reconcile with actual vendor invoices
6. Use By Current Cost for fairest allocation
7. Backup data before validating large landed costs
System Requirements
To use the Stock Landed Costs module:
Steps
1. Install stock_landed_costs module
2. Configure accounting accounts for landed costs
3. Create service products for cost types
4. Set up default allocation methods
5. Configure staff access rights
6. Train on import cost allocation process