Costing Methods

The inventory costing method you choose defines how NetSuite calculates item costs. For example, it shows how NetSuite handles inventory costing calculations when you buy the same item at different purchase prices over a certain period.

NetSuite provides the following inventory costing methods:

In NetSuite, average costing is the default inventory costing method. If inventory levels are negative, NetSuite uses the last purchase price as the inventory costing method.

Important:

You can't change the costing method after you save it on the item record.

The item cost for each costing method varies as shown in the following example.

On Monday, you buy 20 calculators at $10 each and place them to inventory.

On Tuesday, you buy 20 more at $15 each.

On Wednesday, you sell 5 calculators to a customer.

Here's how NetSuite calculates the recorded cost of the calculators based on different costing methods:

FIFO

The 5 calculators post a cost of $10 each because that's the cost of the first calculators added to inventory.

LIFO

The 5 calculators post a cost of $15 each because that's the cost of the last calculators added to inventory.

AVERAGE

The 5 calculators post a cost of $12.50 because that's the average cost of all calculators in inventory.

This is calculated as [(20 x $10) +(20 x $15)] /40 =12.5.

STANDARD

Using standard costing, the receipt cost is fixed.

  • Monday, you buy 20 calculators at $10 each and the standard cost is $11. The item received has a unit cost of $11 and purchase price variance is generated for -$1 for each item being received.

  • Tuesday, you buy 20 calculators at $15 each and the standard cost is $11. The item received has a unit cost of $11 and the purchase price variance is generated for $4 for each item being received.

  • Wednesday, you sell 5 calculators to a customer. The recorded cost is $11.

Group Average

See Group Average Costing Use Cases.

Lot Numbered

See Lot Numbered Items.

When Item Cost Is Calculated

Using any costing method, NetSuite calculates the cost for items based on the cost shown on the transaction that brings the item into inventory.

For example, you use Advanced Receiving and the workflow Purchase Order > Item Receipt > Vendor Bill. The item cost NetSuite uses is the cost shown on the item receipt.

If you change the cost used for an item, the costing timing also changes. For example, you enter an item receipt showing one cost. Later, the bill from the vendor shows another cost. If you change the cost on the vendor bill, NetSuite doesn't update item costing. Instead, it uses the receipt that brought the items into inventory. Therefore, you need to update the cost that appears on the item receipt to update the item costing.

Any variance between the receipt and the bill shows up in the Accrued Purchases account. If there are closed periods between the original receipt with the incorrect rate and the current date, you need to create an inventory adjustment. Use an inventory adjustment worksheet in the current period, and post to the adjustment account Accrued Purchases. If you reopen old periods and edit the receipt to match the bill, it'll affect your past financial records. This may cause a recalculation of inventory costs from that point forward.

Related Topics

General Notices