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.
Part of the month-end close guide.
| Most common cause | A sale or transfer recorded before its corresponding receipt |
|---|---|
| Why it matters at close | Standard costing and valuation both assume non-negative on-hand quantity |
| Where to check | The Review Negative Inventory step on the period close checklist |
| Fix | Enter 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.
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
Sources
Related
Topic
Month-End Close
Month-end close is the set of accounting tasks a company runs after a calendar month ends to turn raw transactions into a finished, trustworthy set of financial statements: reconciling subledgers, boo…
Read moreDefinition
What is month-end close?
Month-end close is the set of accounting tasks run after a calendar month ends to turn raw transactions into finished, trustworthy financial statements: reconciling subledgers, booking accruals, eliminating intercompany activity, reviewing the result, and locking the period so nothing more can post without an explicit reopen.
Read moreHow-to
What should be on a month-end close checklist?
A complete close checklist covers subledger lockout, bank and balance-sheet reconciliations, accrual entries, intercompany revaluation and elimination if applicable, inventory review if applicable, consolidated review, and period lock. Each task should have a clear owner and a place in the dependency order, not just a due date.
Read more