📅 Updated: May 2026⏱️ 9 min read🏷️ Inventory · COGS · Items

You sold 47 widgets yesterday. QuickBooks® says you have 12 left in stock. Your warehouse says 3. That 9-unit gap means you just oversold to a customer, promised inventory you do not have, and your Cost of Goods Sold is probably wrong too. When QuickBooks® inventory is not tracking correctly, every sales order, purchase order, and financial report becomes unreliable. This guide covers why inventory tracking fails, how to fix it without losing historical data, and how to prevent it from destroying your margins. For immediate inventory rescue, call +1-888-550-4779. Fees apply.

What Does "Inventory Not Tracking Correctly" Mean?

In QuickBooks®, inventory tracking refers to the automatic calculation of quantity on hand, average cost, and Cost of Goods Sold (COGS) every time you buy, sell, or adjust stock. When tracking breaks, you see symptoms like: negative quantity on hand for items that physically exist; COGS amounts that spike or drop unpredictably; inventory valuation summaries that do not match your physical count; sales invoices allowing you to sell items you do not have in stock; or purchase receipts that fail to increase quantity on hand. These errors cascade into incorrect Balance Sheets, overstated or understated net income, and tax filing problems.

Why Is QuickBooks® Inventory Not Tracking Correctly?

Symptoms: Negative QOH · COGS spikes · Valuation mismatch · Overselling · Receipts not updating stock

⚠️ Warning: Negative inventory corrupts your average cost calculation permanently. Even one negative sale can throw off COGS for hundreds of future transactions.

Step-by-Step Fix Guide

1 Run the Inventory Valuation Summary Report

This report is your diagnostic baseline — it shows every item's quantity, value, and average cost at a glance.

  1. Go to Reports → Inventory → Inventory Valuation Summary (Desktop) or Reports → Standard → Inventory Valuation Summary (Online).
  2. Set the date range to All to see every item's lifetime quantity and value.
  3. Look for items showing negative Qty On Hand or $0.00 Avg Cost with positive quantities — both indicate tracking corruption.
  4. Export the report to Excel and sort by Qty On Hand ascending to surface all negative items first.
  5. Print or save this baseline report — you will compare against it after fixes.

2 Disable Negative Inventory (Desktop)

Preventing future negative sales is the single most important step to protect your average cost integrity.

  1. In QuickBooks® Desktop, go to Edit → Preferences → Items & Inventory → Company Preferences.
  2. Check the box labeled "Don't allow negative inventory quantities" to prevent future negative sales.
  3. Click OK. QuickBooks® will now block invoices and sales receipts that would drive any item negative.
  4. Note: This does not fix existing negatives — it only prevents new ones. You must fix current negatives separately.
  5. If you need to allow occasional negatives (e.g., drop-shipping), leave unchecked but monitor closely.

3 Fix Negative Quantity Items

Each negative item needs individual attention — there is no bulk fix that preserves data integrity.

  1. For each negative item, open the item record: Lists → Item List → double-click the item.
  2. Click Reports → QuickReport on the item to see all transactions affecting quantity.
  3. Identify the first transaction that drove quantity negative — usually a sales invoice dated before a purchase receipt.
  4. Option A: Change the sales invoice date to after the purchase receipt date (if the sale truly happened later).
  5. Option B: Enter a prior-period inventory adjustment: Inventory Activities → Adjust Quantity/Value on Hand. Set the adjustment date to the day before the negative sale, increase quantity to cover the shortfall, and use the Inventory Adjustment expense account.

4 Rebuild Average Cost for Corrupted Items

When average cost is obviously wrong (e.g., $0.02 for a $45 part), you must force a recalculation from a clean baseline.

  1. For items with obviously wrong average costs, run File → Utilities → Rebuild Data first to repair file corruption.
  2. After rebuild, run Verify Data to confirm no errors remain.
  3. If average cost is still wrong, perform a zero-out adjustment: set quantity to 0 and value to $0 on the adjustment date, then immediately adjust back to the correct physical count and total value.
  4. This forces QuickBooks® to recalculate average cost from the correct baseline. Document the reason in the memo field.
  5. Print the Inventory Valuation Detail report before and after for your records.

5 Merge Duplicate Item Records

Duplicate items split your quantity and hide true stock levels — consolidation is essential for accurate tracking.

  1. Go to Lists → Item List and scan for similar names (e.g., "Widget-Red" and "Widget Red" and "Red Widget").
  2. Determine which name to keep — usually the one with the most transaction history.
  3. Edit the duplicate item you want to eliminate. Change its Item Name to exactly match the name you are keeping.
  4. QuickBooks® will prompt: "This name is already being used. Would you like to merge them?" Click Yes.
  5. All transactions from the duplicate item now flow into the retained item, consolidating quantity and cost history. This cannot be undone — back up first.

6 Correct Item Types and Clean Up Journal Entries

Journal entries that bypass the item system and wrong item types are silent killers of inventory accuracy.

  1. Review your Item List for items that should be inventory but are set to Non-Inventory Part or Service.
  2. If the item has no transaction history, simply edit the type to Inventory Part and set up the asset, COGS, and income accounts.
  3. If the item has transaction history, you cannot change the type. Create a new Inventory Part item, use it going forward, and inactivate the old item.
  4. Search for journal entries affecting inventory accounts: Reports → Custom Reports → Transaction Detail, filter by account = Inventory Asset.
  5. For each manual journal entry found, determine if it should have been an inventory adjustment instead. If so, delete the journal entry and post a proper inventory adjustment with the correct item name.

Prevention Checklist

Protect Your Inventory Accuracy

Related Articles

Condense Data Problems — When Inventory History Blocks File Performance Error 80070057 — File Access Issues That Corrupt Item Lists Migration to New Computer — Preserve Inventory Records Multi-User Mode Not Working — Inventory Conflicts in Shared Files

Frequently Asked Questions

COGS in QuickBooks® is driven by average cost, not just quantity. If average cost was corrupted during a negative inventory event or a manual journal entry, every subsequent sale uses the wrong cost basis. You must rebuild average cost via the zero-out method described in Step 4. Our team can do this safely — call +1-888-550-4779. Fees apply.
QuickBooks® Desktop uses weighted average cost only — you cannot switch to FIFO or LIFO within the software. QuickBooks® Online Advanced offers FIFO for some inventory types. If you need FIFO for tax or operational reasons, you may need an inventory add-on or a different ERP system. We can evaluate your needs at +1-888-550-4779. Fees apply.
Merging is permanent and cannot be undone. All transaction history from the deleted item transfers to the retained item. If you merged the wrong items, restore from a backup taken before the merge. Always back up before merging. If you lack a backup, our data recovery team may help — call +1-888-550-4779. Fees apply.
Best practice is a full physical count monthly for high-value or fast-moving items, and quarterly for everything else. Cycle counting (counting a subset daily) is even better for large warehouses. Compare counts to the Inventory Valuation Summary immediately and investigate every variance before accepting it as "shrinkage."

Need Expert Help with QuickBooks®?

Our independent technicians fix QuickBooks® issues remotely. Free diagnosis on every call.

📞 Call +1-888-550-4779 — Free Diagnosis
Independent service · Not affiliated with Intuit® · Fees apply for fix services only

⚠️ Disclaimer: InstantDesk Support is an independent, third-party technical support provider. We are not affiliated with Intuit Inc. or QuickBooks®. For free official support, visit quickbooks.intuit.com.