Landed Cost in Odoo 19: Setup Guide and How We Designed It for a GCC Chemical Trader

Landed cost and profit margin infographic

Key takeaways

  • Landed cost is the supplier price plus every cost to get the goods into your warehouse and ready to sell: freight, duty, clearance, handling, storage and repacking.
  • A trader needs landed cost at two moments: when quoting, using estimates, and after the real bills arrive, when stock is valued. Standard Odoo handles the second. The first needs a costing sheet.
  • In Odoo 19, a landed cost is a service product on a vendor bill. You link it to a validated receipt, compute the split and validate. The products must be in a category using AVCO or FIFO.
  • The split method changes the cost per unit. Split freight by weight and duty by value. Equal is rarely right when a receipt holds different products.
  • For TAM Trading, we specified one costing sheet per deal, restricted cost visibility for Sales, CEO approval for low-margin or large deals, and a fixed 0.4% loss for bulk-to-bag repacking.

What is landed cost?

Landed cost is the total cost of getting a product to the point where you can sell it. The formula is simple:

Landed cost = supplier price + freight + insurance + duty and clearance + handling + storage + repacking and losses

The hard part is that these costs arrive at different times, from different suppliers, and are recorded by different teams. The supplier invoice comes first. The freight invoice comes after shipment. Duty is known at clearance. Storage is billed monthly.

Here is an illustrative example for one import shipment:

Cost componentAmount
Supplier cost$10,000
Ocean freight$1,200
Customs duty$800
Port and clearance fees$300
Inland transport$250
Warehouse handling$150
Landed cost$12,700

In this example, the landed cost is 27% above the supplier price. A price list built on the supplier cost alone would look profitable on every quote and still disappoint when the month closes.

Why traders often price on the wrong cost

Each team sees part of the cost, and nobody sees all of it at the moment the price is set.

TeamWhat it seesWhat it usually does not see
ProcurementSupplier price and payment termsFinal freight, duty and handling
LogisticsFreight bookings and shipment statusCustoms invoices, final supplier cost
WarehouseReceipts, storage, repackingHow cost affects the price
FinanceDuties, vendor bills, exchange ratesPhysical losses, freight at quote time
SalesQuotation and customer termsTotal landed cost when quoting
Supplier cost compared with true product cost, by department

Incomplete cost leads to one of two mistakes:

MistakeCauseResult
UnderpricingSales quotes from the supplier priceRevenue grows while margin falls
OverpricingSales adds large buffers to cover uncertaintyLost deals

The costs that make up landed cost for a bulk trader

For a bulk chemical trader like TAM Trading, which sells soda ash, sodium bicarbonate and specialty chemicals across the UAE, KSA, Oman, Qatar and Bahrain, the cost lines look like this:

CostWhere it comes fromWhen the real figure is known
Supplier priceSupplier quote and proformaAt purchase
FreightEstimated per purchase order, then the forwarder’s invoiceAfter shipment
Customs duty and clearance feesClearing agent, recorded at each customs milestoneAfter arrival
Storage and handling3PL warehouseMonthly or per movement
PackagingJumbo bags, 25 kg bags, linersAt repacking
Bagging labour and lossRepacking job, with a fixed 0.4% lossAt repacking
Lower-leg costsLocal transport after arrivalAfter delivery

When we documented TAM’s requirements, freight, duty and handling were being worked out by hand and were sometimes missed, so products could be sold below their real cost. Material lost during bagging was not planned for either. Freight and customs figures arrive with the shipment paperwork, which we cover in trade documents for each shipment.

Two different jobs: estimating and valuing

It helps to separate landed cost into two jobs, because Odoo handles them differently.

At quote timeAfter the goods arrive
PurposeSet a price that protects the marginValue stock and cost of goods sold correctly
Figures usedEstimates for freight, duty and handlingActual bills from forwarders, agents and warehouses
Who uses itSales, procurement, managementFinance, warehouse
Standard OdooNot covered by the Landed Costs featureCovered by the Landed Costs feature

Most problems come from treating these as one job. If the price is set on the supplier cost and landed costs are only added after receipt, the stock value becomes correct, but the margin was already lost on the quote.

How to set up landed costs in Odoo 19

These steps follow the Odoo 19 documentation [1]. The screenshots are from the same documentation [3].

Step 1: Turn on landed costs

Go to Inventory › Configuration › Settings. In the Valuation section, tick Landed Costs and save. A Default Journal field appears. Choose the journal where landed cost entries will be posted.

Landed Costs setting and Default Journal field in Odoo 19 Inventory settings
The Landed Costs setting in Odoo 19 [3].

Step 2: Check the product category costing method

The products you buy must be in a product category whose Costing Method is AVCO (average cost) or FIFO. Landed costs cannot be applied to products using Standard Price [1]. Check this before the first receipt, because changing the costing method later revalues existing stock.

Step 3: Create a landed cost product for each type of charge

Go to Inventory › Products › Products and create a product for each charge you add regularly, for example “Ocean Freight”, “Customs Duty” or “Port Handling”.

  • Set Product Type to Service.
  • On the Purchase tab, tick Is a Landed Cost.
  • Choose a Default Split Method. You can change it on each landed cost record.
Is a Landed Cost checkbox and Default Split Method on an Odoo 19 service product
A landed cost product with its default split method [3].

Step 4: Receive the goods

Confirm the purchase order and validate the receipt when the goods arrive. Only validated transfers can receive landed costs [1].

Step 5: Add the charge to the vendor bill

When the forwarder’s or clearing agent’s bill arrives, create the vendor bill and add the landed cost product as a line. In the Landed Costs column, that line is ticked and the goods line is not. A Create Landed Costs button appears at the top of the bill.

Landed Costs column on an Odoo 19 vendor bill, ticked only for the landed cost line
Only the landed cost line is ticked in the Landed Costs column [3].

Step 6: Link the receipt, compute and validate

Click Create Landed Costs. Odoo opens a landed cost record with the charge already on the Additional Costs tab.

  1. In Transfers, select the receipt or receipts the charge belongs to.
  2. Click Compute.
  3. Check the Valuation Adjustments tab. It shows the original value, the added landed cost and the new value for each line.
  4. Click Validate. Odoo posts the journal entry that increases the stock value.

You can also create a landed cost record directly from Inventory › Operations › Landed Costs [1]. The form lets you apply it to transfers or, if you use Manufacturing, to manufacturing orders.

Odoo 19 landed cost record applied to a receipt transfer
A landed cost record applied to a receipt [3].

How to choose a split method

Odoo 19 offers five split methods [1]:

Split methodHow it divides the costGood fit for
EqualThe same amount to every line on the receiptA single product, or charges that do not depend on size or value
By QuantityIn proportion to the number of unitsProducts counted in the same unit of measure
By Current CostIn proportion to each line’s valueDuty, insurance and other charges based on value
By WeightIn proportion to product weightOcean and road freight for bulk goods
By VolumeIn proportion to product volumeFreight charged by space, such as part-container loads

The method changes the cost per unit, so it changes the margin you report. Here is a worked example with one $1,500 freight bill split across one receipt:

  • Product A: 20 tonnes, valued at $6,000 ($300 per tonne)
  • Product B: 10 tonnes, valued at $9,000 ($900 per tonne)
Split methodFreight to AFreight to BA cost per tonneB cost per tonne
Equal$750$750$337.50$975
By Weight$1,000$500$350$950
By Current Cost$600$900$330$990

The freight was charged for moving 30 tonnes, so splitting it by weight puts $50 on every tonne. Splitting it equally overstates the cost of B by $25 per tonne and understates A by $12.50. Splitting it by value moves even more cost to the expensive product. If you price from these figures, the wrong method makes one product look less profitable than it is and the other more profitable.

Two practical points:

  • By Weight and By Volume need data. If the weight or volume fields on the product are empty, Odoo has nothing to split by. Fill them in before go-live.
  • By Quantity counts units. If one product is stocked in bags and another in tonnes, a split by quantity will not reflect the real effort of moving them.
Comparison of quantity, weight, volume and value-based landed cost allocation

At quote time: one costing sheet per deal

The standard Landed Costs feature works on received stock. It cannot tell a salesperson what a deal will cost before it is ordered. For that, TAM needed a costing sheet. The costing sheet sits on the same record as the enquiry and quotation, as described in our article on one deal record from enquiry to order.

In TAM’s design, every deal gets a costing sheet. It adds landed cost, freight, duty, storage and packaging, then applies the target margin to produce a suggested price. The sheet is locked once the proforma invoice is approved, so the price the customer sees always matches the cost logic behind it.

Two rules make the sheet useful in practice:

  • Restricted visibility. Only Procurement and Finance see supplier prices and the detailed cost lines. Sales sees the base price it is allowed to offer.
  • Margin approvals. If the margin falls below the minimum, the quantity is over 500 MT, or the deal is marked urgent or high-risk, the proforma goes to the CEO for approval.
Costing sheet for one deal: supplier price, freight, duty, storage, bagging loss, landed cost, target margin and base price, with who sees each line
How the costing sheet builds the price, and who sees each line.

Here is the kind of case the approval rule is for. A salesperson wants to sell 600 MT of soda ash at a margin below TAM’s minimum. The quantity is over 500 MT and the margin is under the threshold, so the proforma is blocked until management approves the exception.

Estimated and actual landed cost

Estimates are only half the job. In TAM’s design, each purchase order carries an estimated freight cost, and the actual freight invoice later updates the landed cost. Customs milestones record duties and clearance fees, which also go into landed cost. Lower-leg costs are allocated to inventory and cost of goods sold.

Comparing estimate with actual on every shipment is how the estimates improve. An illustrative example:

CostEstimatedActualVariance
Freight$2,000$2,450+$450
Customs$1,200$1,350+$150
Handling$300$325+$25
Total$3,500$4,125+$625

If freight is underestimated on most shipments, the freight estimate on the costing sheet should go up. Without this comparison, the same error repeats on every quote.

The 0.4% bagging loss

When TAM buys in bulk and repacks into bags, some material is always lost. The design applies a fixed 0.4% loss factor to bulk-to-bag conversions, together with the cost of jumbo bags and bagging labour. At delivery, the weighbridge net weight is recorded and the stock is adjusted, including the 0.4% deduction for bagged goods. Actual weights are confirmed at the weighbridge before invoicing; see weighbridge records and invoicing what was delivered.

The effect on unit cost is easy to miss. With an illustrative bulk cost of $300 per tonne, 1,000 tonnes in becomes 996 tonnes out. The cost per bagged tonne rises to about $301.20 before bags and labour are added. On a 10,000-tonne contract, the loss is 40 tonnes that cannot be invoiced.

A fixed, agreed rate means every salesperson prices the loss the same way. It also gives finance a clear benchmark to compare against the weighbridge figures.

The Odoo 19 timing issue

Odoo 19 changed inventory valuation. We covered the main changes in our article on periodic and perpetual inventory valuation in Odoo 19.

One effect matters for traders. Reports on the Odoo forum show that with AVCO and perpetual valuation, a landed cost validated after part of the stock has been sold is applied only to the quantity still on hand. The share for units already sold stays in the expense account [2]. On a shipment that is partly delivered before the freight bill arrives, gross profit can look better than it is.

Ways to handle it:

  • Post landed costs before the goods are sold, where timing allows.
  • Post landed cost bills to a clearing account and reclassify what could not be allocated at month end.
  • Build an adjustment that posts the sold share to cost of goods sold.

Common landed cost mistakes in Odoo

  • Products on Standard Price. Landed costs need AVCO or FIFO, so a charge cannot be added to these products.
  • The charge product is not a Service. Landed cost products must be services with Is a Landed Cost ticked [1].
  • Freight booked as a general expense. If the forwarder’s bill is posted without a landed cost line, the cost never reaches the stock value or the product margin.
  • Equal split by default. Equal is the default on a new product. Check it for every charge type.
  • Empty weight and volume fields. Splits by weight or volume then give no useful result.
  • Partial receipts. If a purchase order is received in two parts, each part is a separate transfer. Select every receipt the bill covers.
  • Bills that arrive after the goods are sold. See the timing issue above.

If your landed costs are not reaching your product margins today, we can review your setup.

A decision TAM still had to make

How to estimate lower-leg costs, update them mid-shipment and allocate them to inventory or cost of goods sold was recorded as an open decision in TAM’s finance requirements. So was the rule for factoring costs into profitability for direct versus warehouse shipments. We recorded them as open rather than guessing, because the answer changes how margin is reported. If you are planning landed cost in Odoo, settle these two questions before configuration starts.

Checklist before you set up landed cost in Odoo

  • List every cost component, and mark which are estimates at quote time and which arrive on bills later.
  • Decide who maintains freight and duty estimates.
  • Check that every stocked product category uses AVCO or FIFO.
  • Create one landed cost product per charge type and choose its split method.
  • Fill in product weights and volumes if you split by them.
  • Agree the loss factor for repacking, and how weighbridge figures confirm it.
  • Decide how landed costs that arrive after a sale are handled.
  • Agree who can see supplier prices and cost lines.

A useful test before any project: take your last 10 completed shipments and compare the margin you expected at quote time with the margin finance reported afterwards. If the gap is large and always in the same direction, the problem is cost visibility, not sales.

FAQ

What is the formula for landed cost?

Supplier price plus freight, insurance, duty and clearance, handling, storage and any repacking cost or loss.

Which costing method do I need for landed costs in Odoo?

The products must be in a product category using AVCO or FIFO [1].

Can Odoo calculate landed cost on a quotation?

Standard Landed Costs work on received stock, after the vendor bill [1]. A costing sheet at quote time needs extra configuration or development, which is why we specified one for TAM. A packaging manufacturer has the same quote-time problem, covered in costing a flexible packaging quote.

Which split method should I use for freight?

For bulk goods, By Weight usually matches how freight is charged. Use By Current Cost for charges based on value, such as duty and insurance.

Can one bill be split across several receipts?

Yes. Select all the receipts in the Transfers field of the landed cost record before you compute.

How should I treat material lost during bagging?

Agree a fixed loss rate for costing (TAM uses 0.4%) and confirm actual weights at delivery, for example with a weighbridge.

What if goods were sold before the freight bill arrived?

In Odoo 19, the landed cost may only revalue stock still on hand [2]. Plan a month-end clearing step or post landed costs earlier.

Get your cost logic right before go-live

If your team still builds deal costs in spreadsheets, start by listing your cost components and when each becomes known. We can review your costing and show how it would work in Odoo 19. See how we approach Odoo for trading and distribution projects.

References

[1] Odoo, Landed costs, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/inventory_valuation/landed_costs.html

[2] Odoo Community Forum, Landed Cost Impact on COGS (Odoo v19 observation). https://www.odoo.com/forum/help-1/landed-cost-impact-on-cogs-odoo-v19-observation-297080

[3] Screenshots: Odoo S.A., Odoo 19.0 documentation, licensed under CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/). https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/inventory_valuation/landed_costs.html

  • Kawser Ahmed is the Founder & CEO of Softeko, a global IT consultancy with offices in Dhaka and Dubai. A tech entrepreneur, investor, and AI enthusiast, he has led numerous software and web projects, including the successful ExcelDemy.com. Kawser holds an Odoo 18 Functional Certification and has deep expertise in business process management, finance, SEO, and software development. He's also a Technical Analysis trainer at Dhaka Stock Exchange Ltd., with popular online courses on AmarStock.com and Udemy. A lifelong learner, Kawser explores how business, technology, and global markets work.

    View all posts

Want to write an article for our blog? Read our requirements and guidelines to become a contributor.

Leave a comment

Your email address will not be published. Required fields are marked *

Get Free Consultancy
Odoo Consultant
Get Free Consultancy
Book a meeting with an expert → Shafiuddin Haider, Odoo ERP Consultant
☰
Table of Contents