QuickBooks Negative Inventory and COGS Cleanup: How to Fix It

Short answer: Negative inventory happens when QuickBooks records a sale of an item before it records the purchase. With no cost on hand, QuickBooks estimates the cost of goods sold, and then silently rewrites it when the bill finally arrives. The result is a gross margin that changes after the fact and an inventory asset balance that does not tie to anything. Fix it by finding the negative quantities, backdating the missing purchases, and then closing the door with a receiving process that runs ahead of invoicing.

Last updated July 2026.

This is one of the few bookkeeping problems in QuickBooks that gets worse the longer you leave it, because every subsequent transaction on the affected item is built on a cost that was a guess. A client whose margins look fine one month and terrible the next, with no change in pricing, very often has negative inventory somewhere in the item list.

What negative inventory actually does to your books

QuickBooks values inventory using average cost. When you sell an item you do not have, there is no average cost to draw on, so QuickBooks uses the last known cost, or if there is none, it uses zero. It posts that number to cost of goods sold and moves on.

Later, when the purchase is finally entered, QuickBooks goes back and adjusts. It rewrites the cost of goods sold on that earlier sale to reflect what you actually paid. That is well intentioned and it is exactly why your prior period reports will not match the printouts you filed. A profit and loss you ran in April can be different when you run it again in June, for the same date range, without anyone touching a transaction.

The inventory asset account takes the same damage. A negative quantity with a value attached produces a credit sitting in an asset account, which is not a thing that should exist on a balance sheet.

Find every item that has gone negative

QuickBooks Desktop has a report for exactly this: Reports, Inventory, Inventory Valuation Detail. Set the date range wide, back to the start of the year at minimum, and read down the On Hand column. Any row where it drops below zero is your problem, and the date it first went negative is where the cleanup starts. Desktop also has a Negative Item Listing report in the Advanced Inventory reports, which is faster if you have it.

In QuickBooks Online, run the Inventory Valuation Detail report and look for the same thing: a running quantity that dips under zero. QuickBooks Online will warn you at the point of sale that you do not have enough on hand, but it lets you save anyway, which is how the negatives get there in the first place.

Write down the item, the date it went negative, and the quantity. You are about to fix them in date order, and skipping around is how people end up double counting.

The five things that cause it

Invoicing before receiving. The warehouse ships, sales invoices the same day, and the vendor bill shows up eleven days later. QuickBooks sees the sale first. This is the cause in most companies, and it is a process problem rather than an accounting one.

Receiving without a bill, then never converting it. In Desktop, an item receipt is supposed to become a bill. When it sits as an open item receipt forever, or gets deleted because someone thought it was a duplicate of the bill, the quantity vanishes.

Purchase orders mistaken for receipts. A purchase order changes nothing in your books. Nothing enters inventory until you receive against it. People see a PO in the system and assume the stock is recorded.

Backdated sales. Someone enters a January invoice in March, after the item's stock was already consumed by February sales. The quantity was fine at the time; the backdated transaction makes it retroactively negative.

Items that should never have been inventory. Services, assembled kits, and anything you buy to order do not belong as inventory parts. Every sale of them goes negative by definition, because you never stock them.

The cleanup, in the order that works

Start with the purchases that genuinely exist but were never entered. Get the vendor bills or receipts, enter them with their true dates, and let QuickBooks recalculate. This alone resolves most negatives, and it is the only fix that leaves your books accurate rather than merely tidy. Check the bills against the bank register or the card statement so you are not entering a purchase that was already recorded another way, and if the bills only exist as PDFs in an inbox, pull the line items out of them automatically rather than typing forty of them.

Then deal with open item receipts. In Desktop, run the Unbilled Items report and convert anything that has an actual bill behind it. Do not delete an item receipt to make a duplicate go away without checking which of the two is carrying the quantity.

Next, fix the items that were misclassified. Changing an item type in QuickBooks is restricted once it has transaction history, so in practice you inactivate the wrong item, create a non inventory or service item in its place, and stop using the old one. Do not try to rewrite history on it.

Only then use an inventory quantity adjustment, and only for the remainder: genuine shrinkage, breakage, samples given away, or an opening balance that was wrong from the start. Adjust with a date, an offsetting account (shrinkage or COGS, not an equity dumping ground), and a memo explaining what it was. An adjustment used as a first resort just hides the real cause.

Finish by rerunning the Inventory Valuation Detail from the earliest negative date forward, confirming that On Hand never dips below zero, and checking that the inventory asset total on the balance sheet matches the valuation summary. If those two disagree, something was posted to the inventory asset account directly by a journal entry, which is a separate problem and worth hunting down.

Keeping it from coming back

The durable fix is sequencing, not software. Receiving has to be entered before the invoice goes out, which usually means the person who ships is also the person who marks it received, or that purchasing enters item receipts on the day goods arrive rather than when the bill lands. In Desktop, turn on the warning for insufficient quantity and treat it as a stop sign rather than a suggestion. Review the valuation report monthly, not annually, and negatives stay a two item cleanup instead of a two hundred item one.

Also close your periods. A closing date with a password stops the backdated invoice that silently pushes a prior month negative, and it is the cheapest control in the product.

Where this fits in a wider cleanup

Negative inventory rarely travels alone. The same file usually has uncategorized expenses, a bloated chart of accounts and a bank feed that has been quietly dropping transactions for months. If you are doing a full cleanup, the register comes first, because everything else is built on it: see the QuickBooks cleanup checklist and, if the transactions themselves are missing, the CSV to QBO workflow accountants use to rebuild a year of bank history from statement exports.