How to export data file from QuickBooks Online to QuickBooks Desktop?

    Add Comment
    1 Answer(s)

      You can use data export to export your QuickBooks Online data to QuickBooks desktop.

      I want to remind this thing that exporting your data from QuickBooks Online to QuickBooks desktop does not mean that your QuickBooks online paid subscription will be canceled.

      Prepare your data for export

      • Open your QuickBooks online company.
      • Click on the gear icon at the top, select export data under tools.
      • Quickbooks will ask a reason why you are exporting your data select a reason and continue.
      • Go to under moving to QuickBooks desktop and select learn more.
      • Go to under download company data and select learn more.
      • Select install active x control now.
      • Review the export overview and select get started.
      • Click install for the ActiveX control and select install ActiveX control, now to confirm the installation a pop-up window appears for the next steps to install active x.
      • After installing ActiveX successfully select continue.
      • Select the date you want to export from the bottom right and select continue.
      • Review the limitations of exporting the data and select continue.
      • Enter your contact information at the bottom right and select continue.

      Important: you will receive an email with some steps to complete the process within a few minutes to 2 hrs, the receiving time depends on the total amount of data you are exporting. Receipt of this email means the data has been compiled and now you can move forward to the next steps.

      Exporting data from Quickbooks online

      If you want to continue the download option within the export process, you will need to repeat some steps.

      • Click on the gear icon at the top, select export data under tools.
      • Go to under moving to QuickBooks desktop and select learn more.
      • Go to under download company data and select learn more.
      • Select install active x control now.
      • Review the export overview and select get started.
      • Go to the QuickBooks online page and select continue to download.
      • Verify the version of the QuickBooks desktop to which you are exporting the data.
      • Important: If a company file is currently open, you need to close that file before proceeding.
        • To close QuickBooks company file follow the steps:
          • Go to the File menu and select Close Company.
          • After this, you will be placed at the No Company Open screen.
      • Click on download.
      • Go to save your company file window and select the location to save the export company file(do not change the file name).
      • Once the file download is finished, select convert now.
      • Go to the new QuickBooks file popup window, enter the file name and save the file to a local directory.
      • Important: Do not save the file to a network directory or to an external directory otherwise the process failed. Save your file to a local directory. After saving the file to a local directory a pop-up dialogue window containing a status bar will be displayed, if the status bar does not appear to be processing, verify QuickBooks desktop for an application certificate.
        • Go to the Windows taskbar, select the active QuickBooks desktop session. Now the application certificate must be shown.
        • In the application certificate select yes, prompt each time and then select continue.
        • Go to the confirmation windows that follow select done. After this, a new company file will build itself within QuickBooks desktop with QuickBooks online data. After its done QuickBooks will open within a new file.
      • After the export process completes, select Finished.
      Answered 6 days ago.
      Add Comment

      Your Answer

      By posting your answer, you agree to the privacy policy and terms of service.