Move data from QuickBooks Online to QuickBooks Desktop

If you're interested in support any time, any day, consider upgrading to QuickBooks Online Advanced.

Learn how to move your data from QuickBooks Online to QuickBooks Desktop. With the help of our migration tool, you can relocate all your data and transactions.

The QuickBooks design has been updated! If this video doesn't match what you see in QuickBooks, use the in-app Search bar to navigate to the page you need.

Prerequisites

• If you haven't yet, download QuickBooks Desktop. You’ll need it open when you move your data.
• For information on how data moves to QuickBooks Desktop, check out Learn how data moves from QuickBooks Online to QuickBooks Desktop.

Step 1: Download the migration tool in QuickBooks Online

1. Sign in to QuickBooks Online.
2. Go to the Export Overview page.
3. Select Get Started.
4. Select Download tool.
   Note: Keep this page open on your browser.
5. Install the migration tool, then select Next.
6. Read and accept the terms of the license agreement, then select Next.
7. Select Install, then select Finish.

Step 2: Export your QuickBooks Online data

1. In the Step 1: Prepare to export page, select Continue.
2. Select the QuickBooks Online data you want to export, then select Continue.
   Note: You can either choose All financial data or All financial data without transactions. For products and services, inventory isn't exported.
3. In the Step 3: Request your data page, select Continue.
4. Fill in the Name and Email address fields, then select Continue.
5. Select Close.
   Note: Email confirmation may take time depending on the amount of data you want to migrate. Check your QuickBooks Online homepage for updates.
6. Go to the Export Overview page.
7. In the Step 1: Prepare to export page, follow the instructions for online migration. Then, select Continue.
8. In the Exporting from QuickBooks Online page, select Continue to Download, then select Download QBXML file.
9. Save the file to your desktop, then select Continue.

Step 3: Run the QuickBooks Desktop migration tool

1. In the QuickBooks Desktop Migration tool, select Browse, select your QBXML file, then select Open.
2. Open QuickBooks Desktop. In the No Company Open screen, select Create a new company.
3. In the What does creating a company file require? screen, select For myself, then select Start Setup.
4. In the sign in screen, go to the Sign in Later ▼dropdown, then select In 2 days.
5. Select OK.
6. In the migration tool, select Import, then choose the location of the file and name the file.
7. Select Save.
8. In the application certificate, select Yes, always allow access even if QuickBooks is not running.
9. Select Yes, then select Continue.
10. Select Done.
11. In the Update Business Info screen, fill out the fields then select Save.
12. Select Sign in now, then select Start Working.
13. In the Intuit Account menu, select Admin, then enter your email address.
14. Select Continue.
15. In the Sign In Later ▼ dropdown, select In 2 Days, then select OK.
16. Wait for the import to finish, then select Done.

Note: If you want more information about this tool, check out Desktop Migration Tool FAQs. 

Step 4: Check if the data exported matches

After you export your data, run a profit and loss report in QuickBooks Online and QuickBooks Desktop to compare your books.

Note: Run reports on accrual basis in QuickBooks Online and QuickBooks Desktop to match and compare them.

Next steps

• You can cancel your QuickBooks Online subscription if needed.
• Get started with QuickBooks Desktop.