cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

Visual Guide to Export

Here's a visual guide you can use when exporting your data from QuickBooks Online to QuickBooks Desktop.

Important:
  • QuickBooks Online is not compatible with the 64-bit version of Internet Explorer in Windows 7. Make sure that you have the 32-bit version of Internet Explorer instead.
  • You must be logged in as an Admin user on both QuickBooks Online and Desktop for this process to work.
  • If you're having trouble installing the ActiveX control or getting error messages, see Can't install ActiveX control in Internet Explorer when exporting QuickBooks Online data.

Export your data from QuickBooks Online

    1. Run Internet Explorer and Quickbooks Desktop as the Administrator even if you are logged in to your computer as the Admin.

      User-added image

    2. Turn off Protected Mode from Internet options (Alt+X), then add https://*.intuit.com, https://*.qbo.intuit.com and https://*.quickbooks.intuit.com to your browser's Trusted Sites Zone.
      Note: After doing this, you will have to close/re- open Internet Explorer for Protected Mode to be truly disabled. Repeat step 1 before opening Internet Explorer if you have to disable Protected Mode.

      User-added image

    3. In QuickBooks Online, select the Gear icon at the top. Under Tools, choose Export Data.

      User-added image

      Note: A pop- up window appears with a quick question about your reason for exporting. Choose your reason, then select Continue.

    1. Under Moving to QuickBooks Desktop?, select Learn more.

      User-added image

  1. Under Download company data, select Learn more.

    User-added image

  2. Review the export overview, then select Get Started.
  3. Select Install for the ActiveX control, then choose Install ActiveX Control Now to confirm the installation.

    Note: There will be another window that will prompt for the next step to install ActiveX.

    User-added image

  4. After successfully installing ActiveX, select Continue.

    User-added image

  5. Choose the data you want to export. At the bottom right, select Continue.

    User-added image

  6. Review the limitations of the data that will be exported, then select Continue.

    User-added image

  7. Enter your contact information. At the bottom right, select Continue.
    Note: You will receive an email with steps to complete the export conversion within a few minutes to 2hrs, depending on the amount of data that is being prepared. Receipt of this email means the data has been compiled and you are ready to move on to the next step.
  8. Repeat step 6, then follow the prompts until you reach the screen that shows the next step.
  9. Choose your preferred option. At the bottom right, select Continue.
  10. Follow the steps, then select Download.

    User-added image

  11. A pop- up window will appear and ask where you’d like to save the file (we suggest the Desktop folder), then select Convert Now.

    User-added image

  12. In the Application Certificate, choose Yes, prompt each time.
  13. Select Continue, then choose Done.

    User-added image

  14. At the bottom right, select Finished. Run some reports to confirm that your data is successfully converted.

    User-added image

We suggest you run 2 reports in both QuickBooks Online and in QuickBooks for Windows to ensure your data was transferred correctly.

  • Profit and Loss
  • Balance Sheet

In order to compare data accurately, 2 things are vital to verify your reports in both products:

  • Ensure that you are running the reports to include All Dates.
  • Your accounting method must be set to Accrual.

Important: If you lowered your security settings in following the steps, be sure to change them back so that you don't leave your computer open to viruses when navigating to other websites in Internet Explorer.