Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowWe are currently on Desktop Pro 2019. We have been using quickbooks since 2008 and have a very large file (1.7 million total targets). We are interested in separating our file into two files. We would like to have a smaller current working file and a larger one keeping all the historical data. Does anyone know how to go about doing this or know of a third-party consultant that can do that for us? Once our file size is reduced, we can then update to the new desktop or online version. Any help would be appreciated.
Glad to have you here in the Community, @Diane9035. Let me be your guide today with your concern regarding splitting a company file in QuickBooks Desktop (QBDT).
You can split the company file in two by copying the existing file and adding the same vendors, customer contact information, chart of accounts, and lists. Let me guide you through the steps.
First off, create a copy of an existing company file. Follow the steps below:
The restored backup creates a new company file with the same data. You will have to erase the transactions QuickBooks also copied across to start again. However, before we proceed with the steps, I highly suggest consulting your accountant or accounting professional for guidance on which account is for the debit and credit side of the transaction.
Once done, you can check your accounts by running the Transaction List by Date report.
I'm adding these articles for more details: Create new company files from existing ones in QuickBooks Desktop.
Feel free to get back to me if you have further questions about splitting a company file. I’ll make sure to get back to you as soon as I can. Have a great day!
Run the Condense Data utility as mentioned by LollyNino_C. Another option, consider purchasing a 3rd party condense service. The service will help to reduce the target count to under 350,000 and remove inactive customers, vendors, items to stay under the 14,500 limit for Pro/Premier. You may also consider to purchase a new one time license for QB Desktop 2021 to upgrade your version. Contact us in private for details.
Do you have any 3rd party condense companies that you can recommend?
Do you have any 3rd party condense companies you can recommend?
Click our username and you will find our website address to send a direct message.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here