ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How-to-Guide to QuickBooks Data Conversion

Updated on March 23, 2018

QuickBooks Data Conversion

QuickBooks Data Conversion is one of the most important as well as critical steps that you need to carefully follow while moving from QuickBooks Online to QuickBooks Desktop. While converting the existing company file for any of the versions of QuickBooks Desktop accounting software, there are chances that you can encounter incidents of data loss, data damage or data corruption.

And, to prevent any of such adversites, there are a defined set of guidelines that need to be followed to have smooth QuickBooks data conversion for QuickBooks Desktop. And, in case, if you are not technically acquainted with the technical aspects of QuickBooks Desktop and Online, then it’s always wise to take help from a reputed and reliable QuickBooks support services provider.


Key Considerations for QuickBooks Data Conversion

If you want to migrate from QuickBooks Online to QuickBooks Desktop then there are a few well-defined process that you need to follow while importing and exporting company file.

Requirements for Exporting Data from QuickBooks Online to Desktop

  • You need to have the US version of QuickBooks Online.
  • Before starting the data conversion process, make sure that you are the Company Administrator or Master Administrator.
  • You should have the supported version of QuickBooks Desktop accounting software installed either on your personal computer or cloud server on which you are importing QuickBooks data.
  • The Windows Operating System that you are using should be of 64 bit version
  • You need to have ActiveX for exporting data from QuickBooks Online

Preparation for QuickBooks Data Conversion

Before converting data of QuickBooks Online for the Desktop version, you need to follow the below-mentioned steps:

  1. Sign in to the company file of QuickBooks Online
  2. Select Gear icon and click on Export Data option of the menu
  3. Click on Get Started icon
  4. Before preparing export, install and activate ActiveX
  5. Now, click on Install ActiveX Control
  6. When there is a pop up of Installation Confirmation, click on Continue button
  7. Now, request you data section page, and review how QuickBooks data will be modified and changed after the completion of export process
  8. Then, click on continue
  9. At this stage, click on the contact information button and then click on Continue
  10. Now, click Close

Steps to Export Data from QuickBooks Online

  • From the Homepage of QuickBooks company file, select Gear icon and click on Export Data
  • Now, click on the Get Started menu, and click on Continue
  • Now, select the data that you want to export and then click on Continue
  • In the page named, Exporting from QuickBooks Online page, click on Continue to Download
  • Now, verify the version of QuickBooks Desktop on which you are exporting data and see that it is open with no sitting company file open. And in case, company file is open then you need to close it
  • Now, click on the Download option
  • At this point in time, you will see a pop up named Save Company File, where you need to select the location where you want to store export_company file
  • When the download of the export file is completed, you need to click on Convert Now
  • After the conversion process is finished, you need to click on the Finish button


Want to Upgrade from the earlier QuickBooks Desktop version to the All New QuickBooks Desktop 2018?

In order to supercharge the performance of your accounting team, you can get the all new and powerful QuickBooks Desktop 2018. And, to get enhanced version of QuickBooks 2018, you need to convert the existing company file. Here are a few things that you need to know before converting a company file for QuickBooks 2018:

  • QuickBooks data conversion can only be done by a authorized Administrator
  • Never upgrade QuickBooks company file over a network
  • The upgraded QuickBooks company file can be only opened in the new QuickBooks version
  • Data converted for the Enterprise version of QuickBooks will not work in Pro or Premier


This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

Show Details
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
ClickscoThis is a data management platform studying reader behavior (Privacy Policy)