The supplier invoice has arrived, but the freight bill covers several products and the duty invoice is still missing. Landed cost brings the approved costs of acquiring those goods together at the item level. Calculate the shipment total first, allocate shared charges using a documented basis, then divide each item’s assigned cost by its received units.
Treat an estimate and a finalized amount as separate versions. A unit cost that excludes a pending bill can still be useful when it is labeled, but it should not look final. Finance decides which charges belong in inventory and which treatment applies; the calculation follows that approved policy.
Define the receipt and the costs that belong to it
Start with the receipt, supplier invoice, shipment identifier, items, and quantities accepted. Identify whether the calculation covers one shipment, a partial receipt, or several receipts billed together. A freight bill attached to an entire container should not be assigned in full to each purchase order inside it.
Oracle’s NetSuite landed cost overview describes additional procurement expenses such as freight and duty being included in inventory value. Use your finance-approved cost categories and exclusions. A list of possible shipment charges is not an accounting policy for every company or transaction.
Keep the purchase order and invoice distinction visible in the evidence. A purchase order authorizes the purchase, a receipt records what arrived, and a bill records an amount owed. Matching their references helps explain the cost without pretending their quantities or dates must always be identical.
Choose an allocation basis for each shared charge
Allocate a shared charge using a basis that the responsible owner approves for that category. Weight can distribute a weight-driven freight charge, while value may suit an insurance charge. Oracle’s transaction instructions describe quantity, weight, and value allocation methods and give freight and insurance examples.
The calculation is shared charge multiplied by an item’s allocation base divided by the shipment’s total eligible base. Retain both bases and their units (including any weight conversion applied). A weight entered in pounds for one item and kilograms for another creates a false allocation even when the invoice total reconciles to the cent.
Do not choose the method because it produces the preferred margin. Document the rule before applying it, including what happens to a charge that relates to only one item. Direct assignment and shared allocation answer different questions; a product-specific inspection fee need not be spread across unrelated goods.
Calculate a shipment with two different item weights
Assume a hypothetical shipment contains 100 units of Item A at $10 each and 50 units of Item B at $20 each. Both items therefore have $1,000 of purchase cost. The shipment has $300 of freight, and finance has approved allocation by weight. Each A unit weighs one kilogram and each B unit weighs four kilograms.
A contributes 100 kilograms and B contributes 200, for 300 kilograms total. A receives $300 × 100 ÷ 300 = $100 of freight; B receives $200. Assuming no other eligible costs, A’s landed amount is $1,100 and B’s is $1,200. The shipment reconciles to $2,300.
| Hypothetical item | Purchase cost | Allocated freight | Received units | Landed cost per unit |
|---|---|---|---|---|
| A | $1,000 | $100 | 100 | $11 |
| B | $1,000 | $200 | 50 | $24 |
| Shipment | $2,000 | $300 | 150 | Do not average unlike units |
Dividing the freight equally by unit count would assign $200 to A and $100 to B. The shipment total would still be $2,300, but the item costs would change. That is why a reconciled grand total does not prove the allocation method represents the approved rule.
This example excludes taxes, currency conversion, rejected goods, and any other cost category. Those are explicit assumptions rather than claims that such amounts never apply. Use the same structure to add eligible categories after their treatment and allocation basis have been approved.
Handle partial receipts and late invoices without losing history
For a partial receipt, record which quantities are eligible for each charge and when the rest are expected. Do not divide by the original ordered quantity merely because it is easiest to retrieve. Ask whether the bill relates to the received portion, the full shipment, or an amount that requires a further allocation.
When a freight estimate is replaced by an actual bill, retain the estimate, its date, the final document, and the approved adjustment. Show which receipts and item-cost versions changed. A later invoice should not erase the explanation for a margin report already reviewed using the earlier estimate.
A purchasing analyst can maintain a pending-cost register containing charge category, expected document, responsible owner, and affected receipt. Mark finality at that grain. One completed supplier bill does not make the whole shipment final when another eligible charge remains unresolved.
Reconcile charges before using the result in margin reporting
Reconcile allocated charges to their source bills and confirm each eligible line is assigned once. Include a residual for rounding and document how it is resolved. If the allocation base is zero or missing, stop that category and show an exception instead of substituting equal shares without approval.
Compare quantities and currency separately from the allocation. Retain the source currency, approved conversion rate, and conversion date rather than mixing converted and original amounts. Recoverable taxes, write-downs, and recognition timing belong with finance; an operating report should show the approved treatment it used.
The purchase price variance calculation measures a different relationship between actual and standard prices. Keep its cost scope aligned before comparing it with landed cost. Adding inbound charges to one measure and excluding them from the other can create a difference that looks like a supplier price change.
Use the finalized cost version in downstream analysis only after the designated reviewer accepts it. The SKU margin workflow explains the broader join with revenue and channel fees. A cost record needs an effective period so a corrected receipt can be traced into affected margin calculations.
Where Permute fits in a repeatable landed-cost view
Permute sells connected business data, custom applications, and governed analysis. We can scope a calculation from permitted NetSuite or QuickBooks records and approved shipment spreadsheets. Your finance team supplies the eligible categories, allocation bases, and version rules; we preserve source references as those rules are applied.
We can reuse that calculation in a shipment exception report and an item-cost review view. A purchasing analyst can inspect the charge, allocation base, and receipt behind an amount under current permissions. Missing bills and unmatched references remain visible rather than being replaced by assumed costs.
Try a shipment allocation with its evidence
Use permitted receipt lines and one shared charge whose allocation policy is already approved.
Keep accounting treatment and customs decisions with specialists
We do not choose capitalization policy, recoverable-tax treatment, customs classification, or an exchange-rate convention. This reporting workflow reads source records and applies declared rules; it does not promise to post inventory adjustments or revise supplier bills. Confirm supported access and refresh intervals for the proposed sources.
A missing duty invoice is an unknown input, not zero duty. Preserve the pending amount and any approved estimate as such. If the result will be used for financial reporting, have the responsible finance reviewer approve its scope and treatment before treating the operational calculation as a booked balance.
Use an explained unit cost
Landed cost starts with the approved acquisition costs and the receipts they belong to. Allocate each shared category on its declared basis, reconcile the total, and retain the item-level result. Distinguish estimates from final costs when documents arrive late. The unit cost is then usable because its scope and calculation can be reproduced.
Review a landed-cost reporting gap
Bring a shipment where the bill total reconciles but the item costs are still disputed.
Questions about allocating inbound costs
Does landed cost include selling price?
Selling price is revenue rather than an acquisition charge in the calculation described here. Compare it with the approved cost scope when evaluating margin. Keep customer delivery and selling expenses separate unless the report explicitly defines a broader contribution measure.
Can cases and individual units share an allocation?
They can after conversion to the approved basis. Retain the original quantities and pack definitions so the denominator can be checked. A case count is not comparable to an individual-unit count without that conversion.
What happens when received goods are returned?
Retain the original receipt and link the return and any supplier or carrier credits. Finance should approve how the costs are reversed or retained. Do not remove the original evidence just because the current stock quantity has fallen.