How move data from QB Online to QB Desktop 2020

There's no need for you to create a spreadsheet or an IIF file to transfer your data, gibsd.

You can directly migrate to the Desktop version right away from your QBO account. I'd be glad to guide you through the entire process. 

First, download and install the migration tool. Here's how: 

1. Sign in to the QuickBooks Online account you want to convert using a supported web browser.  
2. Select the URL and replace anything after /app/ with exportqbodatatoqbdt.  The URL should say https://app.qbo.intuit.com/app/exportqbodatatoqbdt. Then press Enter on your keyboard.  Other support task links won't work during this process.
3. You'll see an Export Overview window.  Then, select Get Started.
4. Select Download tool to download the QuickBooks Desktop migration tool.
5. Once you download the tool, launch the tool to install it and select Next.
6. Accept the terms in the license agreement and select Next.
7. Click Complete as the type of setup, then Next.
8. Select Install, then click Finish.

Second, prepare your file for export. Here's how:

1. Go back to QuickBooks Online. You should still be on Step 1: Prepare to export window. Select Continue.
2. Choose what data you want to export. You can export all data with transactions or just list and balances. then, select Continue.
3. Select Learn about the limitations of converting data for QuickBooks Desktop to learn about limitations that can impact your migration and click Continue.
4. Enter the name and email address you want the migration confirmation email to be sent to and select Continue.
5. Select Close on the email confirmation screen to go back to your QBO file. Wait for your email confirmation. The email may take some time.  It depends on the amount of data you migrate.
6. You'll need to get back to the export screen in QuickBooks Online. Repeat the previous steps in Step 2 to get back to the export page and select Get Started.
7. Click Continue.
8. On the Select your data page, select the same option you selected previously and select Continue.
9. You'll see a message that says you already have a file to download in the Exporting from QuickBooks Online page. Click Continue to Download.
10.  Select Download QBXML file. If QuickBooks prompts you to save the file, choose a location easy to find, like your desktop and select Continue.
11. In QuickBooks Desktop, make sure you're on the No Company Open screen. If you have a company open, go to File and select Close company.  View your reports to compare your data before and after the export.

Lastly, run the migration tool by following these steps: 

1. Make sure QuickBooks Desktop is open at the No Company Open screen.
2. Open the QuickBooks Desktop migration tool app you downloaded from step 2.
3. Enter (or Browse to) the path to the downloaded QBXML file and select Import.
4. Choose a location and name for your new QuickBooks Desktop file.
5. Look for the QuickBooks - Application Certificate.  It may be hidden behind other screens if QuickBooks Desktop is in the background. Select the read/modify rights and if you want to allow personal data access. Select Continue and Done on the confirmation screen.
6. Select Done once your data has been imported successfully.

Check out these articles for more details about moving from QBO to QBDT:

• Export and Convert Your QuickBooks Online data to QuickBooks Desktop
• QuickBooks Desktop Migration Tool FAQs

I'd also like to share one more article as an additional reference about switching platforms: Limitations When You Convert From QuickBooks Online to QuickBooks Desktop.

As always, you can reach out to us anytime you need anything else when working on the software. We're always here to help and offer our guidance again. 

@gibsd 

Do you need to migrate data from QBO US to QBD 2020 US? Try converting your data with the tool mentioned by JenoP. Otherwise consider purchasing a 3rd party service.