Import Landed Cost Reconciliation
Compare estimated import goods/freight/duty/local costs with actual booked amounts to calculate final landed cost, unit cost and variance after receipt.
Landed-cost planning closes only when actual costs are known.Normalize the estimated and actual rows into one currency, reconcile the customs/broker/freight invoices actually incurred, and use a consistent treatment for recoverable taxes before updating inventory unit cost.
Import cost reconciliation
Close the gap between estimate and actual landed cost.
| Cost | Estimated (USD) | Actual (USD) | Variance | |
|---|---|---|---|---|
| 200 | ||||
| 120 | ||||
| 150 | ||||
| 150 |
A pre-order landed-cost estimate is useful only if the importer later learns what actually happened. Reconciliation turns actual freight, customs and exception charges into a feedback loop for future sourcing and pricing.
Compare like with like
- Use the same cost categories and currency basis for estimate and actual.
- Record actual goods, freight, customs/tax and local/exception costs.
- Use the received usable quantity for the final unit-cost basis where appropriate.
How OpenFileTools processes it
Source-backed inputs, explicit assumptions.
The browser compares estimated and actual category totals, landed unit cost and overall variance and exports a structured reconciliation snapshot.
Questions, answered.
Why reconcile after the shipment is complete?
Because supplier price alone rarely equals the inventory/economic cost. Actual freight, customs, bank, storage, damage and local costs reveal which planning assumptions need improvement.
Related guide
Read the related guide