Advising a Client Who Wants to Stop Tracking Inventory in QuickBooks Desktop
The client says they no longer need quantity on hand. QuickBooks says the item type cannot be changed. Here is how to scope that conversation on an unsupported Desktop version -- what the item type actually controls, which decision belongs to the accountant, and what to settle before anything is touched.
Sooner or later a client on a discontinued Desktop version says some version of this: we don't count stock any more, can you just switch those items off inventory? It sounds like a five-minute job. It is not, and the reason has nothing to do with the version being unsupported -- it is a rule QuickBooks has enforced in every release. This is a scoping guide for the advisor in the room: what the item type actually controls, which parts of the decision are yours and which belong to the client's accountant, and what to settle before anyone touches the file.
Why the Type Field Is Locked
Open an Inventory Part item and the Type dropdown is greyed out. The change is permitted in one direction only: a Service, Non-inventory Part, or Other Charge item can be promoted to an Inventory Part, and after that the type is fixed for the life of the item. There is no preference that unlocks it, and the import interface rejects the change for the same reason -- the restriction lives on the item record, not on the screen.
The reason is structural. An Inventory Part carries three things 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. Letting the type change would mean unwinding all three, and the product offers no mechanism for that.
Worth saying plainly to the client early: this is not a symptom of running an old version, and upgrading will not lift it.
What the Client Is Actually Asking For
"Stop tracking inventory" turns out to mean at least three different things, and they lead to different work:
- Stop tracking quantity going forward, history can stay as it is. The lightest ask. Retiring the items and creating non-inventory replacements gets there, with the costs listed below.
- Make the file behave as though those items were never inventory. This means the transaction history has to move off the inventory accounts too. Retiring items does not do this.
- The inventory numbers are wrong and I want them gone. Check whether they actually want a repair. If the purchase and sale history is intact and they still need stock control, repairing the item history is the cheaper and better answer.
Ask which one before quoting anything. The three look identical in the client's phrasing and diverge sharply in cost.
The Cost of the Obvious Workaround
The standard advice -- make the item inactive, create a non-inventory twin -- works, with three consequences the client will find later if you do not name them now:
- History splits across two item records. Every item-based report breaks at the changeover date. Sales by item, purchases by item, profitability by item: all of them now need two lines added together, forever.
- The Inventory Asset balance stays. Making an item inactive does not move a cent off the balance sheet. Someone still has to adjust it.
- Open documents keep the old item. Recurring transactions, memorised transactions, estimates, and open purchase orders all still point at the retired item and will need updating.
Adjusting the quantity to zero is not an alternative. It clears the count and changes nothing structural -- the item is still an Inventory Part, still appears in valuation reports, and the next item receipt posts straight back into Inventory Asset.
The Decision That Is Not Yours
The converted or retired items carry a balance in Inventory Asset, and 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 chosen date. Clean going forward; the cost lands visibly in that period.
- Leave it and adjust it with journal entries afterward. Slower, but it stays inside the accountant's normal process and under their control.
Which is right depends on the fiscal year end, whether the books are audited, and whether the amount is material -- so it is the accountant's call, not the bookkeeper's and not the technician's. Get it in writing before work starts. It is a decision when made in advance and an argument when discovered afterward.
Check for Assemblies First
Before any of the above, run the Item Listing filtered to Inventory Assembly. If any of the candidate items appear as components, converting them changes what the assembly is made of, and the assembly needs its own decision. On Enterprise, also confirm whether Advanced Inventory or units of measure are switched on (F2 shows the edition). Each adds moving parts, and each is far cheaper to discover now than mid-job.
What to Snapshot Before Anything Is Touched
Because these reports cannot be regenerated afterward as they were:
- Balance Sheet, current and prior fiscal year.
- Profit & Loss, current and prior fiscal year.
- Inventory Valuation Summary and Inventory Valuation Detail.
- Item Listing, including the assembly filter above.
- A separate dated backup that is not the working copy.
Save them as dated PDFs. This is the before picture the accountant will ask for when they review the effect.
When to Hand It Off
If the client accepts the retire-and-replace consequences, this is bookkeeping work and you can do it in the file. If they need the history itself moved off the inventory accounts -- the second version of the ask above -- that is a file-level conversion, done below the QuickBooks interface, and it is specialist work quoted per file after the file is reviewed. The two service write-ups linked at the bottom of this page cover what that involves and what it preserves.
Either way, the sequence is the same: establish which of the three asks it is, check for assemblies, get the accountant's decision on the asset balance in writing, snapshot the reports, then act.