Skip to Content
Senedoo Get in touch

Import logistics costs

Logistics costs: what an imported material really costs, and its average cost in Odoo.

Vendor price, freight and insurance, customs duties and taxes, forwarder, port, truck: the cost that enters stock is the landed cost at the plant. Odoo splits it over the receipt and recomputes the item's average cost (AVCO).

The cost chain

From a 400 F vendor price to a landed cost of 508.88 F per kilo.

Example: 20 tonnes of soybean meal bought at 400 F per kilo, by sea to Dakar, then by truck to the plant. Customs duty taken at 5% for the example.

Vendor
Vendor price: 8,000,000 FFreight and insurance: 800,000 FCustoms duties and taxes: 677,600 FForwarder, port, truck: 700,000 F

Import VAT (18%) is not part of the cost. Computed on the CIF value plus duties and taxes, 1,705,968 F here, it is recoverable for a VAT-registered company: it goes to deductible VAT, not into the stock value.

Vendor price20,000 kg × 400 F8,000,000 F
Sea freight750,000 F
Insurance50,000 F
CIF valuecost, insurance, freight8,800,000 F
Customs duty (DD)5% of the CIF value440,000 F
Statistical fee (RS)1%88,000 F
ECOWAS levy (PC)0.5%44,000 F
WAEMU levy (PCS)0.8%70,400 F
COSEC0.4%, sea freight35,200 F
Forwarder and port chargesfees, handling, storage450,000 F
Transport to the plant250,000 F
Landed cost at the plant508.88 F per kilo, +27.2%10,177,600 F
Duties and taxes

What customs levies on imports into Senegal.

Usual rates; always check those on your customs assessment, which depend on the tariff line and the origin of the goods.

Customs duty (DD)

0, 5, 10, 20 or 35% of the CIF value, depending on the ECOWAS common external tariff category.

Statistical fee (RS)

1% of the CIF value.

ECOWAS levy (PC)

0.5% of the CIF value.

WAEMU levy (PCS)

0.8% of the CIF value.

COSEC

0.4%, only for imports by sea.

Import VAT

18% of the CIF value plus duties and taxes; recoverable, not a stock cost.

Depending on the product, excise duties and a cyclical import tax on some food products may be added. Source of the rates: DGDDI, “10 questions export Sénégal” sheet.

Forwarder and port

The bills that arrive after the goods.

Forwarder fees

Clearance, declaration, file handling: often a separate bill.

Port charges

Handling, storage: they rise with every day spent at the port.

Transport

From the port to the plant, by truck: a carrier bill.

Timing

These bills arrive days, sometimes weeks after the receipt.

In Odoo

Landed costs.

The setting

Inventory › Settings › Valuation: enable Landed Costs, with a default journal.

One product per cost type

Service product, “Is a Landed Cost” box, default split method: freight, insurance, customs, forwarder, transport.

From the bill

On the forwarder's or carrier's bill, the cost line creates the landed cost record (Create Landed Costs).

On the receipt

Pick the validated receipts concerned: only validated transfers can be selected.

The split

Equal, by quantity, by current cost, by weight or by volume (Split Method): see the split methods below.

The calculation

Compute: original value + cost = new value, line by line (Valuation Adjustments); then Validate.

The condition

Items received must be in a category using average cost (AVCO) or FIFO.

Correcting

A validated record cannot be cancelled: correct it with negative landed costs.

Valuation adjustments of a landed cost record in Odoo
After Compute, the Valuation Adjustments tab: original value, new value and share of each cost.
Split methods

One container, several items: who pays which share of the freight?

A landed cost covers the whole receipt. Odoo shares it between the items received according to a split method, chosen line by line on the landed cost record. There are five methods; they give very different costs.

Equal

The amount divided by the number of lines received, whatever the quantity of each line: 1 bag or 300 bags, same share.

By Quantity

In proportion to the quantities received, each in its item's stock unit.

By Current Cost

In proportion to the value of each line at receipt: quantity × purchase price.

By Weight

In proportion to the weight received: the Weight field of the product form × the quantity.

By Volume

In proportion to the volume received: the Volume field of the product form × the quantity.

Lines of a landed cost record with their split method
One cost per line, with its split method and amount. Here a single item is received: every method gives the same result; the method only matters when the receipt carries several items.
Try it

900,000 F of freight, three items, five results.

Example. The 2,000 empty bags weigh only 200 kg: by weight they carry 8,911 F of freight; by quantity, 720,000 F, 80% of the container. The premix, light and expensive, pays 222,772 F by weight and 475,352 F by value.

The cost to split

Item 1

Item 2

Item 3

Weight and volume: the Weight and Volume fields of the product form in Odoo, for one stock unit. Enter 0 to see what Odoo does when they are missing.

Split: Sea freight
MethodSoybean meal, 50 kg bagPremix, 25 kg pailEmpty woven bags
EqualEqual300,000 F1,000 F per unit300,000 F1,500 F per unit300,000 F150 F per unit
By quantityBy Quantity108,000 F360 F per unit72,000 F360 F per unit720,000 F360 F per unit
By current costBy Current Cost380,282 F1,268 F per unit475,352 F2,377 F per unit44,366 F22.18 F per unit
By weightBy Weight668,317 F2,228 F per unit222,772 F1,114 F per unit8,911 F4.46 F per unit
By volumeBy Volume635,294 F2,118 F per unit158,824 F794 F per unit105,882 F52.94 F per unit

In Odoo: the default method is set on the landed cost product (Default Split Method) and can be changed on each line of the landed cost record (Split Method). Compute shows the share of each item received (Valuation Adjustments).
Which method for which cost

The rule we apply with our clients.

Our recommendation, to adapt to how each provider bills. The principle: split a cost the way it was calculated.

CostMethodWhy
Sea freight, full containerBy weight or by volumeBy weight if the container fills up by weight (heavy bulk), by volume if it fills up by space (light, bulky goods).
Groupage freightBy volumeThe carrier bills per cubic metre or per tonne: the method follows the space taken.
InsuranceBy current costThe premium is a percentage of the insured value.
Customs duties and taxesBy current costThey are computed on the value, provided all items have the same customs duty rate.
Handling, truckBy weightYou pay per tonne handled or carried.
Forwarder feesBy current cost or equalBy value if the fee follows the declared value, equal for a flat fee per file.
Test, certificate per itemEqualThe same amount per line received, whatever the quantity.
Identical items, same unitBy quantityThe only case where counting units makes sense.
The traps

What Odoo does, checked in its code.

Read in the Landed Costs module (stock_landed_costs) of Odoo 19: the calculation flags none of these cases.

Weight or volume never entered

If no item received has a weight, the by-weight method splits equally, without warning. Same for volume.

A single item without weight

If the others have one, it gets nothing by weight: its cost is understated, the others inflated.

Different units

“By quantity” adds up kilos, bags and pieces as if they were the same thing.

Different customs rates

“By current cost” applies the same rate to all. With different rates, measure the gap; it is corrected with one landed cost record per receipt when the items arrive on separate receipts.

The default method

It is set on the landed cost product (Default Split Method); without it, a new line starts as equal.

Average cost (AVCO)

How Odoo recomputes the item's cost.

Formula

Average cost = (quantity in stock × current average cost + quantity received × purchase cost) ÷ total quantity. The purchase cost includes landed costs. A stock issue does not change the average cost.

Before the receipt30,000 kg × 480.00 F14,400,000 F
Receipt, landed cost20,000 kg × 508.88 F10,177,600 F
After the receipt50,000 kg24,577,600 F
New average cost24,577,600 F ÷ 50,000 kg491.55 F
Without landed costs, the average cost would be 448.00 F: (14,400,000 + 8,000,000) ÷ 50,000. The 43.55 F per kilo gap flows into the cost price of every bag of feed.
Getting it right

The settings that matter.

Enter costs early

At receipt, on the forwarder's estimate, before the material goes to the shop floor: the next manufacturing orders take it into account.

The right method

By weight or by volume for freight, by current cost for insurance and customs, and weights and volumes filled in on every product form.

VAT apart

Import VAT is not a landed cost: it stays in deductible VAT.

Currencies

Freight billed in euros or dollars: converted at the day's rate like any foreign-currency purchase.

Cost prices that count everything.

We create your landed cost products, their accounts and split methods, and take over your latest imports.

Book an assessment