NetSuite · Inventory

How to Fix NetSuite Inventory Valuation Error

Inventory value on the balance sheet does not agree with the Inventory Valuation report, cost of goods sold looks wrong, or an item shows a negative value it should not have.

At QuickFix Bookkeeping, the usual culprit is negative inventory. If NetSuite lets you ship an item you do not have on hand, it has to guess at a cost. When the receipt finally lands at the real cost, the difference has to go somewhere, and it lands in your COGS as a variance you did not expect.

What Causes This

Negative inventory

Items shipped before they were received. NetSuite estimates a cost, then corrects it later, producing variances.

Costing method mismatch

Average, FIFO, LIFO, and Standard behave very differently. The item costing method may not match how you actually operate.

Transactions out of order

A fulfilment dated before its receipt forces NetSuite to value the issue at an estimated cost.

Missing landed costs

Freight and duty not applied to the receipt, so item cost is understated and margin looks better than it is.

How to Fix It

METHOD 1Find Your Negative InventoryStart here, always
1

Run the Inventory Valuation report and sort by quantity ascending. Anything with a negative on-hand quantity is your problem.

2

For each one, find the transaction that took it negative. Usually an item fulfilment was posted before the corresponding item receipt.

3

Correct the dates so the receipt precedes the fulfilment, or post the missing receipt. Once quantities are non-negative, re-run the valuation and most of the variance resolves itself.

METHOD 2Reconcile the Report to the General LedgerBalance sheet does not match
1

Run the Inventory Valuation report and the Balance Sheet for the same date, and compare the inventory asset figure.

2

A gap almost always means a journal was posted directly to the inventory asset account, bypassing an inventory transaction. Search the account for journal entries and you will usually find it.

3

Never fix an inventory discrepancy with a manual journal to the asset account. It papers over the variance and guarantees the two reports never agree again.

METHOD 3Check the Costing Method on the ItemNumbers are consistently odd
1

Open the item record and check Costing Method. Average recalculates a weighted cost on every receipt. FIFO and LIFO track cost layers. Standard uses a fixed cost and books the difference as a variance.

2

The costing method cannot be changed once an item has transactions against it. If it is genuinely wrong, you must create a new item with the correct method and transition to it.

METHOD 4Apply Landed Costs ProperlyMargins look too good
1

If freight, duty, and handling are booked as expenses rather than applied to the item receipt, your inventory is undervalued and your margins look better than they are. Use the Landed Cost feature on the item receipt so those costs are capitalised into inventory value where they belong.

Prevent Negative Inventory

You can stop this at source. Turn off the preference that allows items to go negative, and NetSuite will block a fulfilment when there is no stock to fulfil it from. This is a difficult conversation with a warehouse team that is used to shipping first and reconciling later, but it is the only real cure. Everything else is cleanup.

Related Guides

Inventory Value That Will Not Reconcile?

Let QuickFix Bookkeeping Fix Your NetSuite Inventory.

Negative inventory and misapplied landed costs distort COGS and margin in ways that compound every month. We trace the variances to source and rebuild your valuation so the reports agree.

Book a Free 30-Minute Consultation

No obligation. Same-day response.