Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Convert QuickBooks Online company file to QuickBooks desktop

To convert a QuickBooks Online Edition company file to a desktop version of QuickBooks Pro, QuickBooks Premier, or QuickBooks Enterprise Solutions, use the Export Interview and follow the instructions to export either Lists only or Lists and Transactions.

Important:

  • QuickBooks Online Edition (QBOE) will export entire company files only.
  • Data can be exported into a new desktop company file only.
  • Data that was not imported into QBOE has been removed from the file and cannot be exported. One example of this is memorized transactions. That data will need to be recreated in your desktop version after you convert.
Detailed instructions

For a visual guide to conversion that includes screen shots of the entire procedure, see Visual guide to export on the QuickBooks Online Support page

Note: You must log in as the QuickBooks Administrator to convert your company file and you must be using Internet Explorer to access QuickBooks Online.

 

  • BOTH QUICKBOOKS ONLINE EDITION AND QUICKBOOKS DESKTOP MUST BE OPEN AND REMAIN OPEN THROUGHOUT THE CONVERSION PROCESS OR YOU MUST START OVER FROM THE BEGINNING.

 

  1. Open the version of QuickBooks desktop into which you will convert your QuickBooks Online Edition company file. Do not open a company file; stop at the No Company Open window.
  2. Start the QuickBooks Online Edition export interview:
    1. Go to QuickBooks Online and log in to your company file.
    2. Select the Company tab, then under More, select Export Your Data.
    3. The QuickBooks Online Export window opens.
  3. Select an option to export Lists or Lists & Transactions, and then click Next.
    • Lists:
      1. Read the information in the Exporting Lists window. Click the print the entire list of details link, and read and retain the document.
      2. Click Next.
      3. Read the information on your screen about how to export lists, and then click the Export button.
      4. In the Create New QuickBooks File window, select a location and enter a file name for your new company file.
      5. Click Save. QuickBooks Online Edition begins converting your data and displays a progress bar on the screen.
      6. When the conversion is complete, read the information in the Final Steps window, and then click Finished.
    • Lists & Transactions:
      1. Use the drop-down arrow to select the version of QuickBooks into which you will import your online company file, and then click Next.
      2. Read the special conditions information, and then select each checkbox to indicate that you have read and understand the information.
      3. Click the print the entire list of details link, read and retain the document, and then click Next.
      4. Read the information in the Get ready to prepare your data window. Verify or update your name and email address information, and then click Prepare Data.
      5. Read the information about your data file being prepared, and then click OK.
      6. When you receive e-mail notification that your data is ready to download, click the Download the company file created on MM/DD/YYYY link in the Things To Do section of your company home page.
      7. In the Download Prepared Data window, select I'm moving my data to QuickBooks desktop edition, and I'm canceling my QuickBooks Online subscription, and then click Next.
        Note: This step will not cancel your QuickBooks Online Edition subscription.
      8. Read the information in the How long will this take? window, and then click Next.
      9. Click the Download button, select a location for your exported company file data, and then click Save.
      10. Read the information in the Convert the data to QuickBooks desktop edition window, verify that QuickBooks (desktop edition) is running but do not open a company, and then click Convert. Note: you may receive a prompt to accept a Digital Certificate. Click Allow to accept the Certificate.
        • NOTE:  If the Digital Certificate fails to prompt for acceptance, try minimizing everything to see if the certificate is below other screens. If the Certificate is not found, try the following: 
          1. In Internet Explorer, Click on Tools > Internet Options > Security Tab > Trusted Sites > Sites
          2. Add the QBOE web site to the trusted sites list (qbo.intuit.com).
          3. Sign in to QBOE. 
          4. Press F12  to open the Developer Options menu.  (This will open at the bottom of the browser window)
          5. On the right hand side of the Developer Menu you should see a button titled Browser Mode:
          6. Change the Browser Mode to IE8 Compatibility View.
          7. You should now be able to see the Digital Certificate and proceed with your conversion.
      11. In the Create New QuickBooks File window, select a location and enter a file name for your new company file, and then click Save. QuickBooks Online Edition begins converting your data and displays a progress bar on the screen.
      12. When the conversion is complete, read the information in the Final Steps window, and then click Finished.
  4. Switch to your QuickBooks desktop version, and open the file you saved:
    1. Select the File menu and select Open or Restore Company.
    2. Select Open a company file, and then click Next.
    3. Browse to the location where you created the company file, select it, and then click Open.

If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

Other articles to try

Can I synchronize QuickBooks Online with my Desktop version?

Converting from QuickBooks for Mac to QuickBooks Online

Converting Data to and from QuickBooks Online from other versions of QuickBooks

Exporting to QuickBooks Pro/Premier

What community members have to say

Community image  Converting Online to Non-Profit Premiere Edition Desktop 
Learn from other small businesses or post your own solution in the Intuit community.

KB ID# HOW12246
10/23/2014 11:32:34 AM
PPRDQSSWS407 9102 Pro 2013 e5847f