Allow me to chime in and provide information, @victoriah1956.
Yes, you can use the Condense Data as an alternative in cleaning up and correcting errors in the data.
The Condense Data feature is a tool that simplifies your company's data file and enhances its performance. Please note before condensing, ensure to make a backup file.
Here's how to condense data by removing selected transactions:
- Go to the top navigation bar and select File.
- Click on Utilities and choose Condense Data.
- Select Remove the transactions you select from your company file. Select Next.
- Select the transactions you’d like to remove, then select Next.
- Select how transactions would be summarized, then select Next.
- Select how inventory should be condensed, then select Next.
- Select the recommended transactions you’d like to remove, then select Next.
- Select List entries you’d like to remove, then select Next.
- Select Begin Condense, then wait for the process to complete, and then, Select Close.
For more detailed steps on how to condense information, you can refer to this article. It contains useful information that can help you with the process: Use the Condense Data utility.
I will also include a helpful article that guides you through the process of exporting your lists and transactions from QuickBooks Desktop (QBDT): Export, import, and edit IIF files.
Please let us know if you have further concerns about condensing data in QBDT. We're always here to help you out.
