Will our inventory and assemblies survive a new QuickBooks file?

What is actually happening

Inventory in QuickBooks Desktop is not a list of balances. It is the result of every transaction, in date order. Average cost is a running figure: each receipt and each build moves it, and each sale takes cost out at whatever the average is that day. Enter the same transactions in a different order, or miss one, and every cost after that point changes.

Assemblies add a second layer. A build draws its components from the bill of materials, and a component can itself be an assembly with its own bill. A build can also be pending: QuickBooks records it but moves no stock, because components were short on its date. QuickBooks flips that flag on its own as stock comes and goes, so two files can hold the same build and disagree about whether it happened.

Sites add a third. With Advanced Inventory, quantity is held per site, but the general ledger, the trial balance and the standard valuation report all add the sites together. Stock on the wrong shelf ties perfectly.

Then there are inactive items: making one inactive does not zero its quantity. It does remove the item from the inventory valuation reports, at every past date as well as today, so real stock can sit in the file where no standard report shows it.

What people try first, and what it costs them

Condense is the usual first suggestion. It is error-prone, and on an old inventory file it fails or stalls again and again. When it finishes, earlier detail is replaced with monthly summary entries, item reports for that period go blank, and the file is rarely much smaller, because anything open or tied to inventory stays. The only way back is the archive copy it makes, which is the old file again.

Verify and Rebuild Data repair the file's internal structure. They do not make it smaller, and they do not put stock back on the right site or correct a build that is pending when it should not be.

Starting over, or paying for a summary conversion, gives you opening quantities and little else: one cost per item, with no receipts, builds or transfers behind it. The item reports your purchasing and production people rely on start blank on the start date, and pending builds need separate handling, if they come over at all.

Switching platforms means setting up every item, bill of materials and site again elsewhere, and the QuickBooks history still stays behind.

What a line-by-line rebuild does instead

The rebuild starts with your item list: every item, every assembly with every component line at every level, every site, and every inactive item that still holds stock. At the cutover date each item opens with its quantity at each site and its average cost from your file.

Then every receipt, bill, build, transfer, adjustment and sale from the cutover forward is entered in date order, at the site it used in your file. Average cost runs the way it ran in the original, so cost of goods sold lands the same way. A build that is pending in your file is pending in the new one, and a posted build is posted, consuming the parts it consumed at the time, even where the bill of materials has changed since.

Then the two files are compared: quantity, value and average cost, item by item and item by site, at the cutover and at every month-end after it, including the inactive items the standard reports hide. Every pending build is checked in both files. On the scorecard you see the inventory tier at $0.00, or each remaining difference named.

If your file already carries a gap between the inventory account and the valuation report, or negative stock, it is carried exactly as it stands, with a written breakdown for your CPA. It is never plugged.