Skip to main content

How do I reconcile negative inventory before closing a period?

Negative inventory usually means a sale or transfer was recorded before the corresponding receipt was entered into the system, so the item's on-hand quantity temporarily went below zero. Find and correct the sequencing — enter the missing receipt, or adjust the transaction dates — before running standard costing or valuation, since both assume a non-negative quantity on hand.

Zuny FesterBy Zuny Fester, Head of Operations and Marketing
Reviewed by Zuny Fester
Published Last reviewed Editorial policy

Part of the month-end close guide.

Most common causeA sale or transfer recorded before its corresponding receipt
Why it matters at closeStandard costing and valuation both assume non-negative on-hand quantity
Where to checkThe Review Negative Inventory step on the period close checklist
FixEnter the missing receipt or correct transaction date sequencing

Why inventory can go negative at all

Inventory systems generally allow a sale or transfer to post even if it would take the on-hand quantity below zero, because in practice the physical goods were often received but the receipt transaction just hasn't been entered yet — the system, not the warehouse, is out of sequence. This is common with backdated entries, batch data imports, or a receiving process that lags behind the sales process.

Why it has to be resolved before close

Standard costing calculations and inventory valuation both depend on a non-negative quantity on hand at any point they're calculated — a negative balance produces a cost calculation that doesn't reflect reality, which then flows into cost of goods sold and gross margin. Resolving the underlying sequencing issue (entering the missing receipt, or correcting a transaction date) fixes the calculation at its source, rather than adjusting the resulting financial numbers after the fact.

Next step

Map the finance workflow with the most exposure and prove the automation path.

Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.

Book a workflow review

Checklist

Resolving negative inventory before close

  • Run the Review Negative Inventory report from the period close checklist
  • For each negative item, check for a missing or late receipt transaction
  • Enter the missing receipt, or correct the transaction date sequencing
  • Re-run costing or valuation only after quantities are non-negative

Frequently Asked Questions

Almost always a sequencing issue between when goods were physically received and when that receipt was entered — genuine inventory shrinkage or theft is a separate issue found through a physical count, not through this reconciliation step.

It can technically be forced, but the resulting cost and valuation figures for that item will be unreliable — resolving it before close is strongly preferable to correcting it retroactively.

It affects any costing method that depends on quantity on hand, though the specific way the error manifests can vary by costing method.

Sources

Related