Procurement sees the supplier price, logistics sees freight and finance sees additional charges. A manager assesses margin using a figure that does not yet include every approved cost. The financial owner needs a calculation with visible components, versions and completeness limits. We propose separating a management estimate from an approved accounting result and defining their relationship. The example demonstrates allocation mechanics; it does not determine tax, duty or accounting entries for a specific country.
Define the batch and the type of result
Hypothetical batch L-40 contains item A: one hundred units at EUR 10, totalling EUR 1000, and item B: fifty units at EUR 30, totalling EUR 1500. A weighs 100 kg and B 400 kg. The teaching calculation adds EUR 500 freight and EUR 100 insurance. Taxes, duties and other fees are not modelled, so the result is a subtotal of specified components rather than complete import landed cost.
The financial process owner first identifies the required result: an estimate for a commercial decision, a checked total supported by received documents or an accounting value. Retain the legal entity, calculation currency, included lines and cutoff. One shipment may contain several accounting batches, and one freight invoice may cover several shipments. Make those relationships explicit before allocation.
The IFRS Foundation’s IAS 2 overview, checked on 14 October 2026, describes inventory costs through purchase, conversion and bringing inventory to its present location and condition. This is context for entities applying that reporting basis, not permission to capitalise every payment. A competent accountant confirms each cost classification and applicable local rules.
Sources: [1]
Create a component register with provenance and state
Each component needs its type, service supplier, document and line, currency, amount, period, allocation objects and state. Distinguish expected, confirmed and approved amounts. A missing invoice does not mean zero cost. Mark an unknown component as open and assign an owner to resolve it; commercial users should see this limit of the estimate.
Match purchase prices to the current procurement version and actual batch contents. Link freight to the specific service and shipment, and insurance to its approved coverage basis. Where duties, fees or taxes apply to a real transaction, use verified documents and rules approved by responsible specialists. The system should not infer them from a country name or generic template.
For multiple currencies, retain original amounts, conversion rate, date, rate source and rounding rule. These are approved policy parameters for the relevant calculation. Our example uses only EUR to isolate allocation from currency remeasurement. Bank charges, exchange differences and service prices need separate classification even when associated with one payment.
Test the allocation basis against different goods
For L-40, the proposed freight allocation uses mass: A represents 100 of 500 kg, or 20%, while B represents 80%. Allocate EUR 100 to A and EUR 400 to B. Insurance uses purchase value in this teaching example: 40% and 60%, or EUR 40 and EUR 60. These are agreed test assumptions, not universal methods for every transport or insurance contract.
The management subtotal is EUR 1140 for A and EUR 1960 for B, totalling EUR 3100. Per-unit figures are EUR 11.40 and EUR 39.20. Reconcile allocated totals against the source amount and expose rounding residues. If the required mass of any included object is unknown, or total eligible mass is zero, stop automatic allocation. The financial owner must resolve the missing data or approve another supported basis.
Microsoft documents quantity, volume, weight and amount as allocation options in its Landed cost module. That demonstrates a configurable choice in one system, rather than a unique natural method. Your choice should follow the meaning of the cost. The table shows the initial example; another allocation basis changes item margins even when total batch cost remains unchanged.
↔ Scroll the table horizontally
| Component | Item A | Item B |
|---|---|---|
| Purchase | 1000 | 1500 |
| Freight by mass | 100 | 400 |
| Insurance by value | 40 | 60 |
| Subtotal of specified components | 1140 | 1960 |
| Subtotal per unit | 11.40 | 39.20 |
Sources: [2]
Treat the actual invoice as a controlled correction
An approved actual freight invoice later arrives for EUR 550 instead of the EUR 500 estimate. Link it to the same component and replace the estimate rather than adding a second freight service. The EUR 50 difference allocates EUR 10 to A and EUR 40 to B using unchanged mass. Revised subtotals are EUR 1150 and EUR 2000, totalling EUR 3150; unit values become EUR 11.50 and EUR 40.
Retain both versions, the reason, supporting document and approver. Commercial ownership should see which decisions used the earlier estimate. If goods have been sold or the financial period closed, responsible specialists determine accounting treatment under policy and applicable rules. The management model shows the change without inventing a universal posting.
A repeated invoice import should locate the existing component through a reliable document-and-line key. An amount change under the same key creates a version or exception according to the agreed rule. After an exchange failure, finance reconciles source totals with allocated totals while technical support checks transmission. Keep unallocated amounts visible instead of distributing them arbitrarily to force a zero residual.
Accept the result and its completeness limits
The acceptance set includes L-40, initial estimates, the actual invoice and repeated receipt of it. An analyst manually reproduces EUR 3100 and EUR 3150 and checks item allocations. Add unknown mass, a missing document and an invoice partly covering two batches. Expect an owned exception or approved allocation rather than an unexplained number.
Show calculation version, date, included components, open costs and approval state. Missing information determines whether a result is ready for a particular decision. Managers may use an estimate with visible assumptions within their authority; a responsible finance role approves the accounting result. Avoid presenting these different uses under one unqualified cost label.
Begin with a batch whose late invoice changed expected margin. Reconstruct the original estimate, allocation bases and actual adjustments. If the team cannot explain the difference through documents and lines, first repair identification or allocation policy. Only then accept automated calculations as the basis for recurring commercial or financial decisions.
Action checklist
- Define result type, legal entity, currency and batch boundaries.
- Retain each component’s source, state, basis and allocation objects.
- Distinguish unknown cost from zero and estimates from actual invoices.
- Test totals, rounding, repeated imports and late adjustments across two items.
Questions and answers
Can every cost use the same allocation basis?
Only where the policy owner has justified that basis for the relevant categories. Otherwise a uniform formula may shift cost between items and distort their management margins.
When is a calculation final?
When agreed completeness and review criteria are met for the particular result type. Retain a correction procedure even then, because further verified documents may arrive.