Skip to content

How to allocate inbound freight to inventory in an ERP

Read this article in ไทย 中文

How to allocate inbound freight to inventory in an ERP

One freight bill does not always mean equal cost increases

When several products arrive in one shipment, should freight be divided by quantity or purchase value? The answer depends on what drives the charge and the approved costing policy. An ERP can calculate an allocation, but it does not automatically know whether freight was charged by weight, volume or another basis. The total can match the bill exactly while individual product costs and margins are distorted.

First have accounting identify which charges qualify as inventory cost and which must be excluded. Do not send every invoice line into landed cost merely because it appears on the same bill. Recoverable taxes and costs that do not qualify require assessment under the facts and accounting policy. This article concerns data setup and system testing after that decision, not a substitute tax determination.

Choose a defensible driver and maintain its source data

Odoo documentation lists equal, quantity, current-cost, weight and volume allocation methods. That is a reason to evaluate the choice, not automatically accept a default. Weight-related freight requires valid weights per unit and units of measure; volume may be more appropriate when cargo space drives the charge. A value-based allocation needs a genuine connection to value rather than simply being the easiest data to obtain.

Different charge types in the same shipment may use different drivers if the system and policy support them, such as separating a weight-based charge from a fixed service charge. Record the rationale and approver. Do not switch methods each month to improve selected product margins or alter product weights to obtain a desired answer. Correct factual data through a traceable recalculation process.

The same total can produce different unit costs

Hypothetical example: product A has 10 units weighing 100 kg in total; product B has 10 units weighing 20 kg. Approved freight for allocation is THB 1,200. Quantity allocation assigns THB 600 to each group, or THB 60 per unit. Weight allocation assigns THB 1,000 to A, or THB 100 per unit, and THB 200 to B, or THB 20 per unit. Both totals equal THB 1,200.

If the freight quote is weight-based, the second result may better reflect the charge, but minimum weights, fixed fees and other terms still need checking. Weight is not universally best. This example excludes taxes, discounts, rounding and sales occurring during processing to isolate the allocation driver; it is not a ready-made accounting entry.

Test the chain from receipt to inventory value

The test pack should include the purchase order, validated receipt, freight invoice, product codes, units, weight or volume data and costing policy. Use a simulation or test copy that does not affect live operations. Select only relevant receipts and check that the allocation denominator uses actual received quantities rather than the full ordered quantity when delivery is incomplete.

For Odoo, the documentation identifies AVCO or FIFO costing as a condition and describes computing valuation adjustments for selected receipts. Check product-category costing first instead of assuming every costing method behaves identically. Other ERPs or versions may differ. Common checkpoints are original value, added cost per product, the document total and the actual resulting accounting entries.

Late bills and sold stock need follow-through

When freight is billed after some goods have been sold, successful invoice entry is not enough. Accounting should check how the adjustment affects remaining inventory or cost of sales under the configuration and open period. For a closed period, follow an approved adjustment process rather than backdating or rewriting original records to make a screen reconcile. Retain invoice and receipt references to prevent duplicate allocation.

If the result is unexpected, check unit conversions, zero weights, receipts from the wrong shipment and previously allocated amounts before changing the formula. The further-reading article below on buying by carton and selling by piece helps verify units that may distort the denominator. Chawinnix offers accounting-system and ERP services; anonymized transactions with expected and actual results provide a concrete basis for discussing configuration and testing.

Cartons of different sizes, a scale and paths leading to inventory shelves in navy tones

Sources

Back to all articles

Start the conversation

Tell us briefly what concerns you and our team will get back to you. What you send stays confidential.