Converting Inventory Items to Non-Inventory: What Happens to Your Books
QuickBooks locks the item type once an item is an Inventory Part. This guide covers what a conversion to Non-Inventory actually does to your accounts, what to snapshot before you start, and what to check afterward.
The Type Field Is Greyed Out on Purpose
Open an Inventory Part item in QuickBooks Desktop and try to change its Type. The dropdown is disabled. There is no preference that unlocks it, no utility that works around it, and no import that gets past it -- QuickBooks rejects a type change on an existing Inventory Part through the import interface too, because the restriction lives on the item, not on the screen you are using.
The rule is one-way. A Service, Non-inventory Part, or Other Charge item can be promoted to an Inventory Part. Nothing can be demoted back out. QuickBooks enforces this because an Inventory Part carries structures no other item type has: a running quantity on hand, an average cost recalculated on every transaction that touches the item, and a chain of postings into Inventory Asset and cost of goods sold.
So the question is not "how do I flip the type." The question is what you actually want to happen to those three structures, and what your books look like afterward. That is what this guide covers.
The Three Structures You Are Really Changing
Most people think of an item type as a label. It is not. Here is what changes when an Inventory Part becomes a Non-Inventory Part.
| Structure | Inventory Part | Non-Inventory Part |
|---|---|---|
| Quantity on hand | Tracked, recalculated on every transaction | Not tracked |
| Average cost | Maintained per item across all receipts and sales | Retired |
| Purchases post to | Inventory Asset | An expense or cost account you choose |
| Sales post to | Income, with a matching COGS entry from average cost | Income only, no cost layer |
| Inventory Valuation Summary | Includes the item | Excludes the item |
| Physical Inventory Worksheet | Includes the item | Excludes the item |
| Assemblies | Can be a component with a cost and quantity | Cannot be an assembly component |
The last row catches people out. If any of your inventory items are components inside inventory assemblies, converting them is not a standalone change -- it changes what the assembly is made of. Check your assembly list before you decide anything.
Why the Common Workarounds Do Not Work
Make the item inactive and create a non-inventory twin. This is the most-repeated advice and the most misleading. It stops future inventory postings for new transactions, and that is all it does. Your history is now split across two item records, so every item-based report breaks at the changeover date, and the original item's Inventory Asset balance is still on your balance sheet. You have not removed the problem, you have dated it.
Adjust the quantity to zero. This clears the count and changes nothing structural. The item is still an Inventory Part. It still appears in valuation reports at zero, and the next item receipt or bill against it posts straight back into Inventory Asset. The behaviour returns on the next purchase.
Export the item list, change the type in the spreadsheet, re-import. QuickBooks rejects it for the same reason the dropdown is disabled.
Start a new company file. This does work, in the way that starting over always works. You trade the item-type problem for the loss of your transaction history, or for the cost of rebuilding it.
The only approach that changes the item type and keeps the history together is doing it on the company file itself, below the interface. That is specialist work -- see qbrepair.net for the flat-fee route or quickbooksusers.com for the service description.
What to Do Before You Convert Anything
Whether you do this yourself through a rebuild-from-scratch or send the file out, do this first. It is the difference between a conversion your accountant signs off and one that starts an argument.
- Snapshot your reports. Run and save as PDF, dated: Balance Sheet, Profit & Loss for the current and prior fiscal year, Inventory Valuation Summary, Inventory Valuation Detail, and the Item Listing. These are your before picture, and after the conversion they cannot be regenerated.
- Reconcile what you can. If Inventory Asset on the Balance Sheet does not agree with the Inventory Valuation Summary total, find out why now. That discrepancy will not disappear in the conversion, and afterward you will not be able to investigate it.
- Check for assemblies. Run the Item Listing filtered to Inventory Assembly. If any of your conversion candidates appear as components, decide what happens to the assembly before you decide anything about the item.
- Check for Advanced Inventory and units of measure. Both add moving parts. Press F2 to confirm your edition and which features are on.
- Decide the scope. All inventory items, or a named list? Partial conversions are the common case, and a specific list is far easier to verify afterward than "everything."
- Agree the accounting treatment with your accountant. This is the one below.
- Take a backup you do not touch. Not the working copy. A separate, dated backup you keep.
The Decision Your Accountant Has to Make
The converted items carry a balance in Inventory Asset. That balance does not evaporate. There are two defensible treatments:
- Write it off to an expense or cost of goods sold account as of a date you choose. This clears the asset, and it lands the cost in the period containing that date. Clean going forward, visible in that period's results.
- Leave it in place and let your accountant adjust it with journal entries after delivery. Slower, but it keeps the adjustment under their control and inside their normal process.
Neither is a technical question and there is no default that is right for everyone. It depends on your reporting period, your fiscal year end, whether the books are audited, and whether the amount is material. Settle it before the conversion -- it is a decision, not a discovery, and it is far cheaper to make in advance than to unwind afterward.
What to Check After the Conversion
- Open the file in the same version you sent. It should be the same edition and year, with no upgrade prompt.
- Item Listing. Every item you nominated shows as Non-Inventory Part; nothing you did not nominate has changed type.
- Balance Sheet against your before snapshot. Inventory Asset should move by exactly the amount you agreed, and nothing else should have moved unexpectedly.
- Profit & Loss for the affected periods. Costs that used to sit in Inventory Asset now appear in the expense or COGS account you nominated. This is the intended effect, not an error, but your accountant should see it.
- Open a sample of transactions. Pick a few invoices, bills, and item receipts across different years. Dates, numbers, names, and amounts should be untouched; only the account on the item line changes.
- Inventory Valuation Summary. The converted items should be gone from it.
- Run Verify Data. A clean verify on the returned file before it goes into production.
When Conversion Is the Wrong Answer
If your quantities went negative and average cost drifted, but your purchase and sale history is intact and you still need stock control, you want an inventory repair, not a conversion. Repair puts the numbers back to truth; conversion stops carrying them. Those are opposite goals, and picking the wrong one is expensive in both directions.
The honest test: do you still need to know how many you have? If yes, repair. If no -- because stock lives in another system now, or you stopped holding stock, or the history is beyond reconstruction -- conversion is what you are looking for.