Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Can I export a Quickbooks file from Quickbooks Online?

Request is to export Quickbooks file from Quickbooks online to be reviewed in Quickbooks.
4 Comments
QuickBooks Team

Can I export a Quickbooks file from Quickbooks Online?

Glad to see you here in the Community, @rhix.

 

I can help you export data from QuickBooks Online (QBO) to QuickBooks Desktop (QBDT). 

 

First, we need to make sure your security settings in Internet Explorer and QBDT are set up properly. I'll guide you how:

 

How To Set Up Internet Explorer:

  1. Right-click the Internet Explorer icon and select Run as administrator.
  2. Click the Gear icon, and then select Internet options.
  3. Choose Security, then Trusted sites Sites.
  4. Add *.intuit.com to the zone field.
  5. Make sure Require server verification (https:) for all sites in this zone is unchecked.
  6. Close the Trusted Sites window.
  7. Uncheck Enable Protected Mode.
  8. Click Apply, then Okay. Leave Internet Explorer open.

How To Set Up QuickBooks Desktop:

  1. Right-click the QuickBooks Desktop icon and select Run as administrator
  2. Go to the File menu, and then select Close Company.
  3. Leave QuickBooks Desktop open while you complete the rest of the steps.

Now that you've got your security settings ready, you can now prepare to export your QuickBooks Online data. Here's how:

 

  1. Go to the Gear icon.
  2. Under Tools, select Export data.
  3. Click Learn more in the Moving to QuickBooks Desktop section
  4. In the Download company data section, click Learn more.
  5. Choose to Get started.
  6. Select Install ActiveX Control now and follow the steps to install ActiveX.
  7. Once done, click Continue.
  8. Select the data you want to export and click Continue.
  9. Review the limitations and click Continue.
  10. Enter your contact information and then Continue.

To finish exporting your data, you can check this link under step 4Export and convert your QuickBooks Online data to QuickBooks Desktop.

 

I've also added this article about what will happen when converting a company file: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

 

Don't hesitate to drop a comment below if you have other questions. I'm more than happy to help. Take care!

Level 1

Can I export a Quickbooks file from Quickbooks Online?

Hi "Learn More" takes me to Quickbooks community" under Export Data? Please kindly advise.

QuickBooks Team

Can I export a Quickbooks file from Quickbooks Online?

I can help you export your data from QuickBooks Online (QBO), @forestparklaundry.

 

Can you tell me more or send us a screenshot of the link that takes you to the QuickBooks Community? That'll help us provide you the best resolution to this concern. You can also follow the steps that I'll be providing below to export your data. 

 

Here's how:

  1. Log in to your account. 
  2. Highlight the URL and replace anything after /app/ with exportqbodatatoqbdt (http://qbo.intuit.com/app/exportqbodatatoqbdt). You’ll now be routed to the Export Overview Window.
  3. Choose what data you want to export. Either All financial data or All financial data without transactions. Then, click on Continue.
  4. Provide your name and email address where you’d like to receive an email when your file is ready to be downloaded from the QuickBooks Online Homepage. 
  5. Select Close.

Once you get your data, you can now download QuickBooks Desktop and select your data in QuickBooks Online for export. You can check this article for detailed guidance: Export and convert your QuickBooks Online data to QuickBooks Desktop.

 

Refer to the following article on how your data convert from QuickBooks Online to QuickBooks Desktop: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

 

Let me know if you still need further guidance with exporting your company file. I'm always here to help. Have a wonderful day!

Level 15

Can I export a Quickbooks file from Quickbooks Online?

Need to get in touch?

Contact us