Rebuilding Inventory After a QuickBooks Desktop to Online Conversion
Inventory data does not survive every move from QuickBooks Desktop to Online, and users must rebuild it by hand with a valuation report in hand.
A quiet failure shows up after many moves from QuickBooks Desktop to QuickBooks Online: the item list arrives, but quantities, costs, and valuation stay behind. Users often discover it days later, when the first sale posts against an empty stock count. The accepted solution on the community thread is a full manual rebuild, and it comes with hard edges. We walked it end to end and pulled out the parts that trip people up.
Which conversions lose inventory?
Three situations mean extra work. If the Desktop file comes from QuickBooks Desktop for Windows 2015 or earlier, the conversion drops inventory data outright. The remedy is to install a trial copy of QuickBooks Desktop for Windows 2016 or later, open the company file there, and convert from that version instead. If the file comes from QuickBooks Desktop for Mac, inventory will not import at all; the only route is a from-scratch setup in Online. And the whole procedure assumes Online Plus or Advanced, the tiers that carry inventory features.
There is a carve-out for app users. If a third-party tool manages your stock under a costing method other than first-in, first-out or moving average cost, this rebuild does not apply. Follow that app’s own migration route instead. Note too that Online values inventory on a first-in, first-out basis once the items are live.
Print the Desktop numbers before you switch
Everything below depends on paper. In Desktop, open Reports, run the Inventory Valuation Summary, set the report period to All Dates, and print it. Print or save the Balance Sheet as well. Those two documents hold the quantities, unit costs, and total asset value you will retype by hand. Mac users lose the import path, not the reports, so the same printing step applies before the Desktop file is retired. This covers the one-time setup only; selling and tracking stock in Online afterward is a separate subject.
Turn on tracking, then rebuild item by item
In Online, open Settings, then Account and settings, then Sales. Edit the Products and Services section and check every box, including Track inventory quantity on hand, then save. Next, open Settings, then Products and services, and edit each stock item. If it did not import as an inventory type, choose Change type and select Inventory.
Type the initial quantity on hand exactly as the printed valuation report shows. Enter the matching unit cost from the same report, and set the as-of date on which that quantity is effective. Save the item.
The as-of date locks the past
This is the constraint that surprises people. Once an item carries an initial quantity and an as-of date, Online refuses to create any transaction dated earlier than that day. So pick the date deliberately. The conversion date itself, or the first day of the month you converted in, keeps normal dating open for later sales and bills. If historical transactions still need entering, get them in first, or choose an as-of date old enough to sit ahead of them. The limit takes effect the moment you save.
Does the rebuilt total match the Desktop report?
Check before calling it done. Run the Inventory Valuation Summary in Online across the same all-dates window and compare it line by line against the Desktop printout. Quantities and unit costs should agree item for item. The total should equal the inventory figure on the printed Balance Sheet. A mismatch usually means a mistyped cost or an item still sitting in the wrong type.
Retire the old inventory balance
The conversion carries the old inventory asset across as a lump figure on the balance sheet. Left alone, it double-counts everything you just rebuilt. The fix clears it in two moves. Make the edited item inactive from the Action column of the Products and services list.
Next, create a journal entry: credit the old inventory account for its full balance, and debit Opening Balance Equity for the same amount. The legacy account zeroes out, and the rebuilt items carry the value from there. Run the Balance Sheet once more to confirm the old lump is gone.
The pattern holds in every variant of this fix: upgrade an aging Desktop file before converting, print the valuation reports while Desktop still opens, rebuild each item with its exact quantity and cost, choose the as-of date with the lock in mind, and clear the carried-over balance so nothing counts twice. Mac converts get no shortcut. They start at the first item and keep typing.