Freight, customs duty, and tariff costs managed through NetSuite landed cost
NetSuite3 min read

How to Manage Landed Costs and Tariffs in NetSuite

Introduction

Landed cost is the full cost of bringing a product to its destination. The U.S. Commerce Department includes purchase price, insurance, freight, tariffs, taxes, and other fees in its general landed-cost description.[1]

We conducted this review by tracing one import shipment from purchase order through receipt, allocation, vendor billing, and reconciliation. NetSuite records the accounting result. It does not determine the legally correct tariff code, customs value, or duty rate.

Landed-Cost Components

CostTypical sourceSuggested control
FreightCarrier or forwarder billMatch shipment and receipt
Duty or tariffBroker statement or customs entryRetain classification and rate source
BrokerageCustoms broker invoiceSeparate service fees from duty
InsuranceInsurer or forwarder billApply only to covered shipments
HandlingPort, warehouse, or agent billExclude unrelated operating expense

1. Create Clear Cost Categories

Oracle lists shipping, freight, import fees, customs and duty, taxes, insurance, and handling as typical categories. Each category uses an expense account intended as a holding account.[2]

  • Use separate categories for freight, tariff, brokerage, and insurance.
  • Map each category to a controlled clearing account.
  • Use names that match broker and carrier documents.
  • Assign an owner for clearing-account reconciliation.

2. Choose the Allocation Method

NetSuite supports landed cost at the transaction or individual-line level. Per-line allocation can track several categories and distribute costs using attributes such as weight or value.[3]

Choose a driver that reflects how the charge arose. Freight may follow weight or volume. Ad valorem duty often follows customs value. Unit-based fees may follow quantity. Document exceptions.

3. Decide When to Use Estimates

NetSuite WMS can capture actual landed cost or a landed-cost template during receiving when the relevant rules and per-line setup are enabled.[4] Vendor bills can also move from estimated to actual cost per line.[5]

Use estimates when inventory must be valued before invoices arrive. Track estimate-to-actual differences and update rates from recent shipments.

Landed cost and tariff reconciliation reporting in NetSuite

4. Match Separate Bills to Receipts

Under Advanced Receiving, a separate landed-cost bill can be sourced to an item receipt. Oracle notes that the sourced bill can apply to only one receipt and cannot be partly applied through that source flow.[6] Test consolidated freight and broker invoices before launch.

5. Manage Inbound Shipments

Inbound shipment data includes landed-cost amount, category, currency, effective date, exchange rate, associated item, and allocation method.[7] Use a stable shipment ID across purchase, logistics, broker, receipt, and bill records.

Landed-Cost Process Flow

The controls above come together in one receipt-to-reconciliation workflow.

From Purchase Order to Reconciled Landed Cost A five-step receipt and cost-control process
  1. 01
    Create the Order

    Set the expected freight, duty, and other costs.

  2. 02
    Track the Shipment

    Update estimates as shipment facts change.

  3. 03
    Receive Inventory

    Allocate landed cost to the received items.

  4. 04
    Capture Actual Bills

    Record carrier, broker, duty, and tariff costs.

  5. 05
    Reconcile Differences

    Clear estimate gaps and confirm inventory value.

6. Treat Tariff Data as Controlled Input

The USITC publishes the current Harmonized Tariff Schedule and states that it contains U.S. tariff rates and statistical categories.[8] Rates can change. Store the effective date and evidence used.

CBP says commercial-invoice value is generally the price paid for the goods and identifies additions such as selling commissions, assists, royalties, production costs, packing, and proceeds.[9] CBP also places reasonable-care responsibility on importers for classification and valuation.[10]

7. Reconcile Before Close

In this study we ran a receipt-level tie-out. We compared allocated estimates with carrier, broker, duty, and insurance bills. We then cleared each difference or assigned an owner. This is our control method, not an Oracle requirement.

  • Review receipts missing landed cost.
  • Find clearing-account items without a linked shipment.
  • Compare estimated and actual rates.
  • Check tariff rate and customs-value evidence.
  • Confirm allocation drivers for mixed shipments.
  • Reconcile inventory valuation before close.

Conclusion

Good landed-cost accounting connects logistics evidence with inventory value. Clear categories, sensible drivers, controlled estimates, current tariff inputs, and receipt-level reconciliation make the result easier to trust.

References

  1. U.S. Department of Commerce: Determine Total Export Price.
  2. Oracle NetSuite: Landed Cost Categories.
  3. Oracle NetSuite: Landed Cost Allocation per Line.
  4. Oracle NetSuite: Receiving with Actual or Estimated Landed Cost.
  5. Oracle NetSuite: Estimated Landed Cost on Vendor Bills.
  6. Oracle NetSuite: Landed Cost Billed Separately With Advanced Receiving.
  7. Oracle NetSuite: Inventory Details on an Inbound Shipment.
  8. USITC: Harmonized Tariff Schedule.
  9. U.S. Customs and Border Protection: Commercial Invoice Value.
  10. U.S. Customs and Border Protection: Importing into the United States.

Turn Freight and Tariffs into Reliable Inventory Cost

SixLakes Consulting can design landed-cost categories, allocation rules, estimate controls, and receipt-level reconciliation.

Frequently Asked Questions

Key questions about landed-cost allocation, tariffs, estimates, receipts, and reconciliation in NetSuite.

What is landed cost in NetSuite?

Landed cost is the additional cost needed to bring inventory to its destination, such as freight, duty, tariffs, insurance, taxes, and handling. NetSuite can allocate these costs into inventory value.

Which landed cost categories should be created?

Create categories that match material cost types and clearing accounts, such as freight, customs duty, tariffs, brokerage, insurance, and handling.

How can NetSuite allocate landed costs?

NetSuite can distribute landed costs with supported allocation methods and can track one or more cost categories at the individual transaction-line level.

Should estimated or actual landed costs be used?

Use actual costs when available at receipt. Use controlled estimates when inventory must be valued before final bills arrive, then reconcile estimates with actual costs.

Can a separate freight bill be linked to an item receipt?

Yes, in supported Advanced Receiving flows. Oracle notes that a sourced landed-cost vendor bill can be applied to only one item receipt.

How should tariffs be recorded in NetSuite?

Use a distinct landed-cost category and clearing account. Retain the classification, rate source, customs entry, and broker evidence required by your policy.

Who determines the correct tariff rate?

The importer and qualified customs advisers determine classification and value using current official rules. NetSuite records the resulting cost but does not replace customs review.

How should landed costs be reconciled?

Compare allocations with freight, broker, duty, tariff, and insurance bills; reconcile clearing accounts; investigate differences; and confirm inventory valuation before close.