How to export Quickbooks Online data to Quickbooks Desktop Enterprise

Where is your company located? US or another country?

We can use the migration tool as the most straightforward way to move your data from QuickBooks Online to QuickBooks Desktop., Mvlee928.

To do this, you'll need to download a migration tool and have your QuickBooks Desktop company file open during the process.

Follow these steps below:

1. Sign in to QuickBooks Online using a supported web browser.  
2. In the URL bar, replace anything after /app/ with exportqbodatatoqbdt (it should look like this: https://app.qbo.intuit.com/app/exportqbodatatoqbdt).
3. On the Export overview screen, click the Get Started button. 
   
4. Click the Download tool button to download the migration tool.
5. After downloading, launch the installer and run it. 
6. Follow the prompts to complete the installation process. 
    

Next, let's proceed to the second process:

1. On the Prepare to export page, choose the financial data you want to export and click Continue.
2. Next, on the "Request your data" page, enter your name and email address, then click Continue.
3. You'll get an email once the file is ready to download. This might take a while, depending on how much data you have.
4. Once you receive the confirmation, go back to the Export Overview page.
5. Click Continue to Download, then select Download QBXML file to save it to your computer.
6. Save the file to your desktop, then choose Continue.

After that, we can move to Step no. 3. To run the QuickBooks Desktop migration tool, please refer to this article as a guide: Move your QuickBooks Online data to QuickBooks Desktop.

Once you've exported your data, run a profit and loss report in both QuickBooks Online and QuickBooks Desktop to compare the results.

Please let us know if you need any further assistance with this matter.

USA

As usual for QB, the export does not work.  Only shows Retained Earnings with no detail.  

As usual, QB solution does not work. 

Tye only account imported to Desktop Enterprise was Retained Earnings with no detail.  

@mvlee928 

As I know the conversion tool has been unreliable for the last 3 months. You should consider purchasing a 3rd party conversion service. You can contact @Fiat Lux - ASIA directly via email for assistance.

Thanks but Intuit should fix the problem that they created.  

Any recommendations for another accounting software system?

Thanks but Intuit should fix the problem they created. 

Does anyone have a recommendation for another accounting software system similar in function and design as QB Desktop?

Developers prefer to offer cloud-based applications nowadays. Otherwise, you can explore ERP, but it will cost more. If you don't need to run any add-ons (e.g payroll), you should contact Fiat Lux as I mentioned earlier. They will share a few options to consider.

Thanks for getting back with the Community, mvlee928.

If your data didn't export successfully, you'll initially want to make sure in the second process mentioned in ChristineJoieR's post that you've selected the correct data you want exported from QuickBooks Online.

In the event you've already confirmed you chose the correct data, but it wasn't successfully moved to QuickBooks Desktop with your migration tool, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up the account in a secure environment, conduct further research with you, and create an investigation ticket if necessary.

They can be reached while you're signed in.

Here's how:
 

1. Use the Help option.
2. In QB Assistant, enter your question or topic. You can also access the Search tab and enter keywords.
3. After searching, in QB Assistant you can type in "Talk to an expert" to get options for expert help. If you're on your Search screen, select Contact us.

Be sure to review their support hours so you'll know when agents are available.

Please feel welcome to send a reply if there's any additional questions. Have a wonderful Friday!