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.
Exporting from QBO to other versions of QuickBooks:
Requirements for the export:
Things to do before the export:
After the export file is requested and the Prepare data button is clicked, don't make any changes to the company file until you receive an email stating that the export is complete. This will prevent an error from occurring and the file not being created.
Important: To save time and avoid errors, please make sure you are familiar with the export limitations before beginning the export process. The limitations are listed in Export Limitations.
Note: Exporting your company file doesn't cancel your QBO subscription.
NOTE: At this point you shouldn't change any data in your company. Any new data entered won't be included in the export file. Preparing the file will take from a few hours up to a day. When it's done you'll receive a notification email with general instructions on how to convert the file.
From this point a new company file will build itself within QuickBooks with your QuickBooks Online data. When it's done, QuickBooks will be open within the new file.
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.
You should now be able to see the Digital Certificate and proceed with your conversion.
Important: If during the conversion process the progress freezes at a certain percentage, it doesn't always mean the export will not complete! Check the folder where you saved your company file. Look for a file with the extension .tlg and check the file size (usually listed in kilobytes or kbs). Take note of the number of kilobytes and close out the folder and check it after about one minute. If the number of kilobytes (kbs) on the right hand side are increasing the export is working successfully. If after about ten minutes the file size is not increasing, it's best to restart the Export conversion process.
After you've exported your data, run a Balance Sheet and a Profit and Loss report in your QuickBooks Online file and in your QuickBooks Desktop to ensure that the numbers match. The reports must be run on an Accrual basis and for All Dates in both programs.
If the report totals don't match, check to be sure you ran both reports on Accrual basis and for All Dates in the date range. Then make sure no data was entered into either application after the export. If the data still doesn't match, you'll need to contact Customer Care.