Inventory to Non-Inventory Item Conversion

Open an inventory item in QuickBooks, look at the Type dropdown, and you’ll find it greyed out. There’s no preference to change, no utility to run, and no import that gets around it. QuickBooks lets an item become an Inventory Part, and after that the type is fixed for as long as the item exists. Plenty of people assume this is a permissions problem or a symptom of file damage. It isn’t. It’s how the product is built, because an Inventory Part carries structures no other item type has: a running quantity on hand, an average cost that recalculates on every transaction touching the item, and a chain of postings into Inventory Asset and cost of goods sold.

That design is fine right up until your business changes. Maybe you moved stock control to a dedicated inventory system or an ERP, and QuickBooks now only needs to hold the financials. Maybe you stopped holding stock at all — everything is drop-shipped, made to order, or bought against a specific job. Maybe the inventory numbers went wrong years ago and nobody has trusted the valuation report since. Or maybe you’re preparing the file for an edition downgrade or a move to QuickBooks Online, where inventory is the part most likely to cause trouble. In every one of those cases the item type is describing a business you no longer run, and QuickBooks gives you no way to say so.

The advice you’ll find in forums is to make the old item inactive and build a new non-inventory item beside it. That doesn’t solve the problem, it splits it. Your history now lives across two items, your item reports break at the changeover date, and the old inventory asset balance is still sitting on your balance sheet. Adjusting the quantity to zero is no better — it clears the count, but the item is still an Inventory Part, it still shows up in valuation reports, and the very next purchase order posts straight back to Inventory Asset. Starting a fresh company file works, in the sense that amputation works.

We change the item type on the company file itself. The items become Non-Inventory Parts, and every transaction line that referenced them is re-pointed away from Inventory Asset and cost of goods sold onto the expense or cost account you nominate. The quantity-on-hand and average-cost history QuickBooks was maintaining for those items is retired. Your file comes back in the same QuickBooks version and edition you sent — no upgrade, no re-keying, no data entry on your end. We’ve been working QuickBooks files at this level for over 26 years, and this is ordinary work for us.

There is one decision we won’t make for you. The converted items carry a balance in Inventory Asset, and that balance can either be written off to an expense or cost of goods sold account as of a date you pick, or left in place for your accountant to adjust after delivery. Both are legitimate; which is right depends on your books, your reporting period, and your auditor. So we ask, we write your answer into the quote, and we do exactly that. Every converted file comes back with a before-and-after report of the item list, the account movements, and the affected balances, so your accountant can review the effect before you put the file into production.

Send us the file and tell us which items are in scope. The evaluation is free, the quote that follows is fixed, and if what your file actually needs is a negative inventory repair rather than a conversion, we’ll tell you that instead.