Choosing Which Inactive Items to Remove During a QuickBooks Supercondense

A Supercondense shrinks bloated company files, but deciding which inactive items, classes, and names to strip out requires careful advance preparation to protect the lists you still use.

When a QuickBooks Desktop company file grows large enough to slow down daily work, a Supercondense is one of the most effective ways to reclaim performance and reduce file size. Unlike the built-in condense utility, a Supercondense can remove years of historical transactions and slim down list entries that are no longer needed. The outcome depends heavily on preparation: deciding in advance which inactive items to remove and which lists to preserve. Our engineers approach this as a staged process that protects active data while maximizing reduction.

Understanding What a Supercondense Removes

A Supercondense targets two categories of data. First, it removes transactions dated before a cutoff you choose. Second, it can optionally strip out inactive list entries — part items, assembly items, group items, and other records that have no remaining activity after the cutoff. List items such as accounts, customers, and vendors are not removed automatically. The decision to remove inactive items is yours, and it is the single biggest lever for additional file-size reduction beyond transaction removal.

Establishing Your Current File Size

Before planning any removal, record a baseline. Open the company file in QuickBooks Desktop and press F2 to open the Product Information window. Note the file size shown there. Run this check again after the Supercondense to quantify the reduction. This number also helps our engineers determine whether repair work should be performed alongside the Supercondense to resolve any underlying data-damage issues first.

Auditing Inactive Items Before Removal

The goal is to identify items that are genuinely obsolete — parts, assemblies, and groups that are no longer sold, purchased, or built — while keeping anything that still appears on open transactions, reports, or recurring templates.

Start by generating an Item List report filtered to show only inactive items. In QuickBooks Desktop, go to Lists > Item List, check the "Include Inactive" box at the bottom, and review the full list. For each inactive item, consider whether it still appears on any undeposited funds, open purchase orders, pending builds, or recurring transactions. Items tied to even one open or recurring transaction should be preserved.

Producing the Inventory Valuation Summary

Before removing any inventory-related items, generate the Inventory Valuation Summary report set to All Dates. This report provides a complete record of every inventory part, assembly, and group with quantities and values. It serves as your audit trail. If anything is ever questioned after the Supercondense, this report documents what existed and its valuation before any data was removed. Save a copy outside of QuickBooks — as a PDF or exported spreadsheet — before proceeding.

Deciding on Classes and Other Names Lists

Lists such as Classes and Other Names are left untouched during a Supercondense unless you specifically request their removal. Many businesses continue to rely on class tracking for reporting even when individual class entries are no longer assigned to new transactions. Before requesting removal of any class entries, review your class list for entries that have zero activity after the cutoff date. The same applies to the Other Names list, which can accumulate entries from outdated payroll setups, old fixed-asset tracking, or legacy vendor records.

If you are uncertain whether a list is still in use, the safest approach is to leave it intact. The file-size impact of list entries is modest compared to the impact of removing historical transactions, so preserving a list you might need carries little cost.

Documenting Your Removal Decisions

Compile a clear set of instructions before the Supercondense begins. Specify the transaction cutoff date, the categories of inactive items to remove, and any lists to preserve or strip. If you want certain inactive items kept — for example, discontinued parts that still appear on warranty claims — list those explicitly. Clear instructions prevent ambiguity and ensure the process matches your expectations.

Preparing Access and Backups

The Supercondense requires the admin password for the company file, since the process must open and modify the file at a structural level. Create a verified backup or portable copy of the file before any work begins. Store it in a location separate from the working file. This backup is your rollback point if you ever need to reference original data.

Coordinating Repair and Supercondense

If the file shows signs of damage — Verify or Rebuild errors, broken links, or unreadable transactions — our engineers recommend addressing those issues in the same service window. Running a Supercondense on a file with unresolved structural problems risks carrying those problems into the reduced file. Coordinating both services together ensures data consistency and avoids a second round of downtime.

By auditing your item lists, preserving the classes and names you still depend on, and documenting your decisions clearly, you can achieve meaningful file-size reduction while keeping every record your business still needs.