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
| Cost | Typical source | Suggested control |
|---|---|---|
| Freight | Carrier or forwarder bill | Match shipment and receipt |
| Duty or tariff | Broker statement or customs entry | Retain classification and rate source |
| Brokerage | Customs broker invoice | Separate service fees from duty |
| Insurance | Insurer or forwarder bill | Apply only to covered shipments |
| Handling | Port, warehouse, or agent bill | Exclude 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.
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.
-
01Create the Order
Set the expected freight, duty, and other costs.
-
02Track the Shipment
Update estimates as shipment facts change.
-
03Receive Inventory
Allocate landed cost to the received items.
-
04Capture Actual Bills
Record carrier, broker, duty, and tariff costs.
-
05Reconcile 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
- U.S. Department of Commerce: Determine Total Export Price.
- Oracle NetSuite: Landed Cost Categories.
- Oracle NetSuite: Landed Cost Allocation per Line.
- Oracle NetSuite: Receiving with Actual or Estimated Landed Cost.
- Oracle NetSuite: Estimated Landed Cost on Vendor Bills.
- Oracle NetSuite: Landed Cost Billed Separately With Advanced Receiving.
- Oracle NetSuite: Inventory Details on an Inbound Shipment.
- USITC: Harmonized Tariff Schedule.
- U.S. Customs and Border Protection: Commercial Invoice Value.
- U.S. Customs and Border Protection: Importing into the United States.