How do we clean up 20 years of items, customers and vendors?

What is actually happening

Lists in QuickBooks only grow. Every item, customer, vendor, site and account ever created stays for as long as the file exists, and each one is loaded, sorted and searched whenever someone opens a drop-down, types into a field or runs a report. On Pro and Premier the lists also run into hard limits; on Enterprise they simply get longer.

The clutter costs more than time. A vendor entered twice splits its purchase history across two records, so neither shows what you really spend with them. An old item one character away from a current one gets picked by mistake. A site named TEMP or Do Not Use still accepts stock, and stock received into it is hard to find again.

Most of it cannot be deleted. QuickBooks refuses to delete a list entry that any transaction uses, an item that is a component in an assembly, or an account with activity. On a file with years of history, that covers most of every list.

So people make records inactive instead. That takes them out of the drop-downs, which helps. It does not take them out of the file, and it does not zero an item's quantity. An inactive item that still holds stock drops out of the inventory valuation reports, at past dates as well as today, while the stock stays on the books.

What people try first, and what it costs them

Deleting one record at a time stops almost at once: QuickBooks refuses on nearly every record with history.

Merging duplicates, by renaming one record to match another, works for true duplicates. It is also permanent. Every transaction of one record moves onto the other, and a wrong merge cannot be undone except by restoring a backup.

Making everything inactive by date, say every item with no sale in five years, is quick and blunt. It catches items still used as components in an assembly, items sitting on an open purchase order, and items that hold stock. That stock does not go away; it disappears from the valuation report, which is how differences go unnoticed.

Condense can remove list entries that no transaction uses. It is error-prone, though, and on an old file it fails or stalls again and again. When it finishes, the earlier detail is summarized into monthly entries and item reports for that period go blank.

Starting over in a new file with only the active names gives you short lists. It also leaves all of your history behind.

What a line-by-line rebuild does instead

In a rebuild, the cleanup is a list of decisions, not a purge. Every record in every list is dated by its last activity: the last sale, purchase, build or posting. Your team receives a keep-or-retire list, one per list, with the reason beside each name, and approves it. Nothing is retired on our say-so. Near-duplicates, such as the same vendor under two spellings or two sites one character apart, are flagged for your team to decide.

Some records are kept however old they look. Anything on an open sales order or purchase order. Any item used in an active assembly, at any level of its bill of materials. Anything tied to the history that comes over from the cutover date forward.

Retired means made inactive, not deleted. Your team can bring any record back in seconds, in QuickBooks itself, and every record still exists in the retired file.

The cleanup runs last, after every tier has reconciled, so it never changes the scorecard. The inventory comparisons are run again afterward, because making an item inactive changes what the valuation reports can see.

Our bias is stated up front: keep a few records you no longer need before retiring one you still use. The cleanup is $2,000 on any plan.