Use a Vendor Bill to add Landed Cost to Inventory in NetSuite

NetSuite offers a few different ways to add landed costs into the value of an item upon receipt. Each method has certain benefits & drawbacks. The method discussed in this article is basic but also somewhat ridged. It involves directly linking a Vendor Bill transaction to an Item Receipt transaction.

...
Jack Ring
Share:

Landed Cost Overview

The total cost of obtaining stock includes the material charge for an item. It also includes any charges associated with getting items into the warehouse and available for sale. These additional expenses contribute to the total cost of goods sold and affect inventory valuation.

Use the Landed Costs feature to track the expenses you incur when you purchase your inventory. Landed costs let you increase the asset value of inventory by including additional expenses associated with procuring stock, such as freight and duty fees.

Expenses that contribute to landed costs can include the following:

  • shipping charges
  • freight fees
  • origin and destination charges
  • import fees
  • duty fees (excise and customs)
  • taxes
  • insurance
  • handling charges


Any landed cost associated with an item is added to the asset value of an inventory item, letting you calculate profitability accurately.

Source Landed Costs From A Vendor Bill

This is an article which discusses a method to leverage NetSuite’s Landed Cost feature. Companies sometimes want to recognize expenses related to the purchase process for an item into the value of an item. This allows those related costs to be held on the balance sheet and expensed progressively with the sale of each unit to end customers.

The method discussed in this article is basic but also somewhat ridged. It involves directly tying a Vendor Bill transaction to an Item Receipt transaction.

Method #1. (Also see method #2)
At the time when the Vendor Bill is added to NetSuite, go find the related Item Receipt. Under the Landed Cost subtab, source the landed cost amounts from "Other Transaction" and link the newly-created Vendor Bill.

Drawback #1.
The period may be closed by the time you receive the vendor bill.

Drawback #2.
You may receive two vendor bills for the same line or cost category for the Purchase Order.

Ending State GL Impact

...

Clearing account chosen is 2006 Accrued Purchases.

Purchase Order Set Up

...

Add the Item units to the “ITEM SUB LIST” on the Purchase Order. Add a special Non-Inventory for Purchase Landed Cost Item and set the Cost Category as expected and agreed with Vendor.

Item Receipt Set Up (Initial)

...

Receive the stock units on the “ITEM SUB LIST” on the Item Receipt.

Vendor Bill Set Up

...

When the Vendor Bill is received, record it in NetSuite by clicking the "Bill" button from the associated Purchase Order.

Item Receipt – Phase II (After VB is Booked & Before Period is Closed)

...

Come back to the Item Receipt transaction which is related to the origin Purchase Order. Under the Landed Cost sub tab set the “Source” dropdown to “Other Transaction” and set the “Transaction” to the previously Booked Vendor Bill. Repeat per category. ** This only works if there is (1) Vendor Bill for the PO per Cost Category.

Don't hesitate to contact us for assistance in setting up this process in your NetSuite instance. We're here to help you make the most of your NetSuite experience. contact us.



Schedule a Conversation

Let's talk. • (724) 816-1000 • info@leftledger.com


Latest Stories

Here's what we've been up to recently.





Join our mailing list

From us to your inbox.



Schedule a Conversation

Let's talk. • (724) 816-1000 • info@leftledger.com