Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Mar 29, 2022 5:17 PM UTC
Question

Our customer file is huge and needs to be cleaned up. We have 20 plus years of customers and job info. What are the solutions for deleting years of old customer data?

Are we able to delete our existing customer file and then reimport a cleaned up version?

5 replies

Fiat Lux - ASIA
Level 14
Mar 29, 2022 6:21 PM UTC

Just to clarify your question. Are you using QB Desktop or QB Online? If you are using QB Desktop, which year version do you have? Have you explored the Condense Data utility to remove older transactions?

Mar 29, 2022 8:38 PM UTC

sorry, yes to clarify this is for Quickbooks Online

QuickBooks Team
Mar 29, 2022 11:22 PM UTC

Thank you for the clarification, @officemngr_ML. 

 

My colleague above provided the article as your reference for transferring data to a new company file using QuickBooks Desktop.

 

Now that you have confirmed that you are using QuickBooks Online, I will provide you with some information about using multiple accounts and cleaning your old account.

 

You can have multiple QuickBooks Online accounts to run several businesses. Each company file requires a separate paid subscription, but you can access them using the same login information. It allows you to switch between organizations fast to handle things more effectively.

 

In QuickBooks Online, merging two companies isn't possible, but if you want to consolidate and compare your QuickBooks firms, check out Qvinci Consolidations, our authorized 3rd party tool.

 

Check this article to learn more about the process: Create or add another company file to QuickBooks Online.

 

Once done transferring all the files, you can try to run a report to check all your data. Refer to this article for the steps: Run reports in QuickBooks Online.

 

If you need further help creating another company file, click the Reply button below. I am always here to help.

Level 8
Mar 29, 2022 6:30 PM UTC

Good afternoon, @officemngr_ML. 

 

It's great to see you back in the Community. Let me share some insight into deleting years worth of customer data. 

 

The best route would be for you to start a new company file and import things like the list and open balances. However, you'll have to manually enter any opening transactions. Here's a guide for more details: Starting a new company file with data from your existing file.

 

If you have any trouble along the way, don't hesitate to ask. We're always here to have your back. Take care!