Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Has anyone had any experience with exporting file and transactions from a company file into a new company file?
I would like to keep my old company file and then start a new one and only export the last 5 years of transactions into the new file. Is this possible and how can we insure there are no errors??
Solved! Go to Solution.
Hello @Misty Johnson. Glad to see you again in the Community. I'd be happy to share more details on how to export your company files and transactions in QuickBooks Desktop (QBDT).
Currently, exporting transactions from QuickBooks using .IFF file is unavailable. You can use this to export the company lists only. I'd recommend checking with our third-party applications to export the transactions.
Before proceeding with the export process, I'd suggest backing up your company file. Here's how:
I've also added some references that you can check to know more about the data management process in QBDT:
Moreover, I've added this article to help you fix any errors during the export process: Fix export to Excel issues in QuickBooks Desktop.
You’re always welcome to get back to me if you have other concerns with any QuickBooks processes. I’d be more than happy to help. Take care and have a good one.
I'd be glad to help with your question about exporting data from QuickBooks, Misty.
I'll also share the steps on how you can export your data using an .IIF file. This type of file can easily be opened on Excel or imported to a new company file
Here's how:
Please take note that this only export list elements (vendors, customers, chart of accounts, and other lists), and not the actual file or transactions. Please see these articles for more details:
Then, import the file into the new on. Check out this article for the complete set of instructions: Start a New Company File with Data from Your Existing File.
If you want to transfer the actual transactions, you'll want to use a third-party app that offers this type of service. You can look for approved and accredit apps here: https://desktop.apps.com/home.
Other users of the forum who have already tried the same process can also jump in and share their experiences.
Lastly, let me share these articles in case you want to use these features in the new company file:
Don't' hesitate to add more questions if you need anything else. We'd be more than happy to help you again.
I want to export my file and transactions. How would I do that and ensure there are no errors?
Hello @Misty Johnson. Glad to see you again in the Community. I'd be happy to share more details on how to export your company files and transactions in QuickBooks Desktop (QBDT).
Currently, exporting transactions from QuickBooks using .IFF file is unavailable. You can use this to export the company lists only. I'd recommend checking with our third-party applications to export the transactions.
Before proceeding with the export process, I'd suggest backing up your company file. Here's how:
I've also added some references that you can check to know more about the data management process in QBDT:
Moreover, I've added this article to help you fix any errors during the export process: Fix export to Excel issues in QuickBooks Desktop.
You’re always welcome to get back to me if you have other concerns with any QuickBooks processes. I’d be more than happy to help. Take care and have a good one.
Which QB Desktop year version do you have?
I have Enterprise 2022 Professional Services - Desktop
Utilize the Condense Data utility to split your file.
https:// quickbooks.intuit.com/learn-support/en-us/help-article/data-utilities/use-condense-data-utility/L7zprPIcj_US_en_US
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