Home › Guides

How to reconcile inventory, manufacturing and landed costs

Start with ownership, quantities and approved cost components. Then trace receipts, invoices, production and sales through the ledger. A warehouse quantity report, a supplier invoice and a customs declaration can all be correct while measuring different things.

This guide follows one purchased component into finished goods and shows how late freight affects both stock and goods already sold. The calculations are synthetic. They illustrate a reconciliation method rather than prescribing a country's inventory or customs valuation rules.

Use the inventory and landed-cost worksheet to preserve assumptions, quantities, cost versions and the final bridge.

Define the valuation before selecting software options

Identify the reporting basis, inventory owner, location, cost formula and cost level. Determine which receipts belong to the period and which costs are recoverable taxes, inventory costs or period expenses. Physical receipt and legal ownership need not occur together.

IAS 2 addresses inventory cost, expense recognition and write-downs to net realisable value. An ERP's supported methods are not a list of methods permitted under every reporting framework. IFRS Foundation, IAS 2 overview.

Document the costing policy for material, labour and overhead. Have finance approve the treatment of abnormal waste, idle capacity, non-recoverable charges and supplier rebates. Keep tax recovery and customs valuation decisions with their own evidence rather than inferring them from a stock-cost field.

IFS Cloud 25R2 documents valuation methods and cost levels, including manufacturing cost effects when a shop order closes. The product label and cost level both matter to the resulting calculation. IFS Cloud 25R2, valuation methods and cost levels.

Fix the example's transaction population

Assume the company purchases 100 identical components at 20 currency units each. Freight is 200 and non-recoverable duty is 100. Finance approves including both in inventory. A separate import VAT amount of 460 is fully recoverable under the example's approved tax assumptions and is excluded from inventory cost.

There are no opening stocks, exchange differences, scrap, impairment or tax on the eventual sales in this exercise. All components belong to the company. Production uses 60 components to make 30 identical finished units, with direct labour of 600 and allocated normal production overhead of 300.

The company sells ten finished units for 100 each. Later, before final close, a further freight bill of 100 is identified as attributable to the original component shipment. The example uses actual allocated cost, not an assumption that every ERP automatically recalculates all prior postings.

Write the quantities and cost amounts into the worksheet before entering expected journals. The same dataset should drive purchasing, production and finance checks; separate spreadsheets with independently typed quantities make unexplained differences harder to investigate.

Reconcile the purchased components

The initial component cost is 2,000 purchase price plus 200 freight plus 100 duty, or 2,300. Each component costs 23. The recoverable import VAT of 460 is a separate tax asset, not another 4.60 added to each item.

If all purchase-related liabilities are unpaid, the example's initial accounting effects are inventory of 2,300 and recoverable tax of 460 against liabilities of 2,760. Individual supplier and broker documents can divide those liabilities differently while preserving the same total.

Retain the allocation denominator. A freight allocation based on 100 units is not reproducible if the receipt later shows only 90 accepted units and nobody explains the other ten. Record rejected, damaged, consigned or separately owned goods explicitly.

SAP Business One's Landed Costs documentation describes allocating additional import costs to items and the use of estimates before final supporting documents arrive. Verify the chosen Business One version and inventory setup before relying on a particular posting sequence. SAP Business One, calculating landed costs.

Move cost through production and sale

Production consumes 60 components at 23, or 1,380. Add labour of 600 and overhead of 300. The completed batch costs 2,280, equivalent to 76 for each of its 30 units.

The remaining 40 raw components are worth 920. Finished goods initially total 2,280. Combined inventory before sales is therefore 3,200, matching component cost of 2,300 plus added production cost of 900.

Selling ten finished units releases 760 to cost of sales and leaves 20 finished units worth 1,520. Closing inventory before the late bill is 920 raw materials plus 1,520 finished goods, or 2,440.

The full cost bridge is 3,200 available cost equals 760 cost of sales plus 2,440 inventory. Sales revenue is 1,000, so the initial gross margin is 240. This bridge deliberately excludes other business expenses and does not present a complete company's accounts.

Keep production quantities separate from valuation quantities where the actual system uses scrap, by-products or partial completions. Those cases need their own approved allocation and cannot be repaired by changing the denominator after the fact.

Allocate the late freight to sold and unsold items

The extra 100 belongs to all 100 original components, increasing their cost by one each. The 40 unused components therefore gain 40 of inventory value.

The 60 consumed components add 60 to the finished batch. Dividing that amount across 30 finished units adds two per unit, increasing finished-unit cost from 76 to 78.

Ten units have already been sold, so their additional cost is 20. The 20 remaining finished units gain 40. The extra freight is fully accounted for: 40 in raw inventory, 40 in finished inventory and 20 in cost of sales.

Final raw materials are 40 times 24, or 960. Finished goods are 20 times 78, or 1,560. Closing inventory is 2,520 and cumulative cost of sales is 780. Together they equal the final 3,300 available cost. Gross margin becomes 1,000 minus 780, or 220.

Ask the implementation team to demonstrate how the chosen product achieves these approved economic results. The workflow may use invoice consideration, cost updates, variances or controlled journals. A correct design must explain the treatment of sold stock as well as stock still on hand.

Recover when the late bill hits inventory only

Suppose an operator adds all 100 to remaining inventory. The ledger then shows 2,540 instead of 2,520, while cost of sales remains 760 instead of 780. Total cost still reconciles to 3,300, concealing a 20 overstatement of inventory and gross margin.

Investigate the shipment-to-production-to-sale chain. The cost accountant identifies the ten sold units, approves the 20 expense correction and documents the remaining 80 inventory increase. Rerun stock valuation and cost-of-sales reports from the same cut-off.

If the original period is closed, the controller decides the appropriate correction period under the applicable reporting rules. Do not reopen a period or backdate a cost solely because a technical option permits it. Preserve both the original cost version and the corrected result.

Apply a separate recoverability check if market conditions suggest inventory cannot recover its carrying value. A complete landed-cost allocation does not establish that no write-down is required.

Assign ownership and accept the close

Purchasing owns supplier and freight evidence. Warehouse operations confirms quantities and movements. Production confirms completion and cost inputs. The cost accountant owns allocation and valuation; tax approves recovery classifications; the controller accepts the final reporting result.

Before completion, confirm:

Retain receipt and invoice links, production records, allocations, cost versions and reconciliations. For accounting-basis differences, use parallel books. For an Odoo-specific upgrade rehearsal, use Odoo 19 inventory accounting.

Source verification date: 17 October 2026. IFS references are explicitly 25R2; SAP documentation supports the described function but this guide provides no tested SAP menu procedure or universal customs calculation.

Worksheet: Inventory and manufacturing cost reconciliation worksheet

Copy this worksheet for each case. It records decisions and evidence; it does not determine the tax or legal treatment.

Show the worksheet

Use with the inventory guide. Complete one copy per costing population and period.

Approved basis

Cost flow

Record opening quantities and costs, receipts, manufacturing transfers, sales, scrap and closing quantities. Reconcile available cost to closing raw materials, finished goods, work in progress and cost of goods sold. Keep physical count differences separate from valuation differences.

Rehearsal: original available cost 3,200 equals stock2,440 plus COGS760. Late freight100 raises available cost to3,300. Allocate40 to remaining raw materials,40 to remaining finished goods and20 to sold goods. Final stock2,520 plus COGS780 equals3,300.

Late-cost exception

Prove that putting all100 into remaining inventory fails the sold-goods check. Inventory accounting and procurement owners both sign the final allocation.

Vendor documentation is cited only as an example of the level of evidence to ask for; it is not a recommendation or a ranking. This guide is general information, not tax or legal advice. Checked 2026-10-17.

Related: Glossary – abbreviations and terms used in these guides (SAF-T, Peppol, CTC, EN 16931, IFRS and more).

Page last updated: · Markdown version

Newsletter – monthly digest of mandate and ERP support changes. Subscribe on the home page.