NetSuiteFree calculatorPDF, Excel, Word exportNetSuiteAll NetSuite tools

NetSuite Average Cost Calculation: Per-Location Average Cost Calculator

This calculator simulates how NetSuite's average costing updates an item's cost at one location when a receipt arrives, including landed cost, and what the next issue will cost. Use it to explain a cost change on an item or to predict the effect of a receipt before it posts.

Your numbers

On hand at the location before receipt

units

Current average cost

Receipt quantity

units

Receipt unit cost (PO rate)

Landed cost per unit allocated

Quantity issued after the receipt

units

Your results

New average cost at the location

$13

Cost of the issue

$3,975

Receipt value incl. landed cost

$8,250

New on-hand quantity

1,000

Remaining inventory value

$9,275

Average cost change

Simplified moving-average model for one item at one location with positive on-hand. NetSuite recalculates costs in transaction date order, so backdated transactions, negative inventory and later landed cost changes can change results.

Save results:

New average cost vs receipt unit cost

Sweeps Receipt unit cost (PO rate) from 8 to 20, holding your other inputs fixed.

Explain an item's cost history

Send the item's transaction history at one location and we will rebuild the running average and point to the entries that moved it.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

How NetSuite average costing works

With the Average costing method, each receipt blends into the existing on-hand value: new average = (on-hand quantity x current average + receipt quantity x receipt cost) / new quantity. With Multi-Location Inventory enabled, NetSuite keeps the average per item per location, so the same item can carry different costs at two warehouses and a transfer order moves cost between them. Issues such as fulfillments, work order issues and adjustments out leave the average unchanged and are costed at the average current at their transaction date. Landed cost allocated on the item receipt is added to the receipt cost, so freight and duty flow into the average.

receipt value = qty x (unit cost + landed cost per unit)
COGS on issue = issued qty x new average

Worked example

400 units at 12.50 are worth 5,000. A receipt of 600 at 13.40 plus 0.35 landed cost is 600 x 13.75 = 8,250. The new quantity is 1,000 and the new average 13,250 / 1,000 = 13.25, up 6%. Shipping 300 units afterwards costs 3,975 and leaves 700 units worth 9,275. If the landed cost had been entered a week later on the same receipt, NetSuite would revalue the receipt and recost the later shipment, so the first COGS posting would change.

Backdating, Cost Accounting Status and negative inventory

NetSuite costs inventory in transaction date order. Entering or editing a transaction dated before others for the same item and location queues a recalculation of every later transaction, and costs and GL impact change after the fact. The Cost Accounting Status on inventory-affecting transactions shows whether costing for that line is complete or still pending, and month-end close should wait until pending items clear. Negative on-hand, where shipping is allowed before receipt, makes issues post at the last known cost and get corrected when the receipt arrives, which is a common source of unexplained variance. Keep receipts posted before shipments where possible.

How to check the result in NetSuite

Open the item record, Inventory subtab, Locations, to see average cost per location, and use the Inventory Valuation or Inventory Valuation Detail report filtered to the item and location to see each transaction's quantity, cost and running value. A saved search on transactions with the item, location, quantity and amount columns, sorted by date, rebuilds the running average for comparison with this calculator.

Frequently Asked Questions

How does NetSuite calculate average cost?

Each receipt is blended into existing stock: the new average equals existing on-hand value plus receipt value, divided by the new on-hand quantity. Receipt value includes landed cost allocated to the receipt. Issues are costed at the current average and do not change it. With Multi-Location Inventory the average is kept per location.

What costing methods does NetSuite support?

Item costing methods are Average, FIFO, LIFO, Standard, Lot Numbered and Serialized (specific cost per lot or serial), and Group Average across locations where that feature is enabled. The method is set per item, and changing it on an item with history is restricted, so choose before go-live.

What does Cost Accounting Status mean in NetSuite?

It shows whether NetSuite has finished costing an inventory transaction line. After backdated transactions or cost changes, later transactions are queued for recalculation and their cost and GL impact may update. Check that no transactions are still pending before closing a period or reconciling inventory to the GL.

Why do two locations show different costs for the same item?

With Multi-Location Inventory and Average costing, each location keeps its own average based on the receipts, transfers and adjustments at that location. Receipts at different prices or freight allocations at one site move only that site's average. Transfers carry the shipping location's cost to the receiving location.

If cost accountants want to ask NetSuite why an item's average cost moved and which receipt or backdated entry caused it, in plain English on your own infrastructure, we can set that up.

Talk to an Expert Explore More Free Tools