QuickBooks HelpQuickBooksHelpIntuit

Use the Clean Up Company Data utility

SOLVEDby QuickBooks9Updated October 16, 2023

Learn more about repairing your transactions using the Clean Up Company Data utility in QuickBooks Desktop Point of Sale.

The Clean Up Company Data utility repairs transaction and list damage in your company file. You may need to run the utility to resolve the following issues:

  • Data is missing after an update is applied.
  • Verify Data ends with a data damage message.
  • The program list takes longer to open than usual.
  • Forms or reports display incorrectly.

The Clean Up Company Data utility can:

  • Compress your data and makes the file size smaller.
  • Help the QuickBooks data file to run smoothly.
  • Repair various list damages in POS.
  • Remove older and non-history documents to allow QuickBooks to run efficiently even with larger data files.

Important: This process may take some time depending on your company data file size. Your computer and QuickBooks Desktop Point of Sale may look unresponsive but if your mouse pointer still moves, the cleanup still runs. Strictly follow these guidelines before running the cleanup company data utility:

  • Create a backup copy of your data file: Although Clean up data creates a backup, it is recommended that you create a separate backup to protect you against permanent loss of data.
  • Choose the compress database option. This option often repairs any damaged lists on the file.
  • NEVER cancel the cleanup data utility. To avoid data damage beyond repair, do not close or stop the qbpos.exe process.

Run the Clean Up Company Data utility

  1. Go to File, select Utilities, then select Clean Up Company Data.
  2. Select Compress database, then select OK.
  3. (Optional) In the Non-history documents window, select the list you want to remove from your file, then select Next.
  4. (Optional) In the History documents and other data window, select the data you want to remove and the date, then select Next.
  5. In the Proceed with Cleanup window, select Cleanup and wait until the cleanup completes.
  6. If the issue persists, run a second clean up.
    1. Go to File, select Utilities, then select Clean Up Company Data.
    2. Select Compress database, select OK, then select Next.
    3. Select Next again, then, on the calendar 📅▼ dropdown, select today’s date. Select Next.
      Note: Leave all the boxes unchecked.
    4. Select Cleanup.
    5. Let the cleanup finish, then select OK.
    6. Restart QuickBooks Point of Sale.
      Note: If you get an error message, select OK, then close and re-open QuickBooks.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Point of Sale BasicQuickBooks Point of Sale Multi-StoreQuickBooks Point of Sale Pro

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this