Moving your accounting records from QuickBooks Online to QuickBooks Desktop requires careful preparation. Intuit provides a migration tool that helps users export company data from QuickBooks Online and import it into the desktop version. By following the correct steps, you can transfer supported financial information and continue managing your business accounts in QuickBooks Desktop.

The process involves downloading the migration tool, preparing your online company data, exporting a QBXML file, and importing that file into QuickBooks Desktop. You should also review your financial reports after the migration to make sure your accounting records are consistent.

This guide explains how to use the QuickBooks Data migration tool, prepare your company file, transfer your data, and troubleshoot common migration problems.

What Is the QuickBooks Online to Desktop Migration Tool?

The QuickBooks migration tool helps users transfer supported company data from QuickBooks Online to QuickBooks Desktop. It provides a structured way to export financial information and import it into the desktop accounting application.

However, not every type of data transfers in the same way. Some information may have limitations during the conversion process, and certain features available in QuickBooks Online may not work identically in QuickBooks Desktop.

Before starting, review Intuit's guidance on how data moves between the two QuickBooks versions. This will help you understand which records transfer and which items may require additional attention.

Prerequisites for Migrating QuickBooks Online Data

Prepare your system and accounting records before downloading the migration tool. Taking these precautions can reduce the risk of interruptions and data inconsistencies.

1. Install QuickBooks Desktop

Download and install the appropriate version of QuickBooks Desktop on your computer. You must have the software installed and available during the migration process.

Keep QuickBooks Desktop closed until the instructions tell you to open it. When you run the migration tool, the desktop application should remain on the No Company Open screen.

2. Sign In to QuickBooks Online

Make sure you can access the correct QuickBooks Online company account. You may need the appropriate account permissions to export company information.

3. Back Up Important Accounting Records

Before moving your data, keep a copy of your important financial records. Retain the reports and documents you may need to verify the imported information.

4. Understand Data Conversion Limitations

Inventory information for products and services is not exported through the described migration process. Other records may also convert differently depending on the data type and the QuickBooks Desktop version.

Review the applicable migration documentation before proceeding.

Step 1: Download the QuickBooks Migration Tool

You must download the migration tool through the Export Overview page in QuickBooks Online. Keep your browser open while you complete the initial setup.

Follow these instructions:

  1. Sign in to your QuickBooks Online account.
  2. Navigate to the Export Overview page.
  3. Select Get Started.
  4. Choose Download tool.
  5. Open the downloaded installer.
  6. Follow the installation instructions and select Next.
  7. Read the license agreement and accept its terms.
  8. Select Next, then choose Install.
  9. Wait for the installation to finish and select Finish.

Keep the Export Overview page open because you will return to it when preparing and downloading your company data.

Step 2: Prepare Your QuickBooks Online Company Data

After installing the migration tool, return to QuickBooks Online and begin preparing your company information for export.

  1. Open the Prepare to export page.
  2. Select Continue.
  3. Choose the type of data you want to export.
  4. Select Continue to proceed.
  5. On the Request your data page, select Continue.
  6. Enter your name and email address in the requested fields.
  7. Select Continue, then choose Close when prompted.

QuickBooks Online may take some time to prepare your export. The processing time depends on the amount of information in your company file.

You can check your QuickBooks Online homepage for updates. Once the export is ready, return to the Export Overview page and follow the instructions for online migration.

Step 3: Export Data from QuickBooks Online

Once QuickBooks Online has prepared your information, download the export file needed by the desktop migration tool.

Follow these steps:

  1. Return to the Export Overview page.
  2. Open the Prepare to export section.
  3. Follow the displayed instructions for online migration.
  4. Select Continue.
  5. On the Exporting from QuickBooks Online page, select Continue to Download.
  6. Choose Download QBXML file.
  7. Save the downloaded QBXML file to your computer, such as your desktop.
  8. Select Continue to proceed.

Keep track of the file's location. You will need to select this exact QBXML file when importing your company data into QuickBooks Desktop.

Depending on the export options available, you may be able to select all financial data or all financial data without transactions. Choose the option that matches your migration requirements.

Remember that inventory is not exported for products and services through this process.

Step 4: Import the QBXML File into QuickBooks Desktop

After downloading the QBXML file, you can use the migration tool to import the prepared data into QuickBooks Desktop.

Open the Migration Tool

  1. Launch QuickBooks Desktop.
  2. Stay on the No Company Open screen.
  3. Open the QuickBooks Desktop migration tool.
  4. Select Browse.
  5. Navigate to the folder containing your downloaded QBXML file.
  6. Select the file and choose Open.

Import and Save Your Company Data

Once you select the correct file, choose Import. Enter the requested name and follow the prompts to save your company file. Select the appropriate save location, provide a file name, and choose Save.

Make sure you select a suitable location and use a clear file name so you can identify the migrated company file later.

Grant the Required Permissions

After a short wait, QuickBooks Desktop may display a certificate window asking you to authorize the migration tool.

To continue:

  1. Select Yes, Always.
  2. Check the box that allows the application to access personal data, if displayed.
  3. Select Continue.
  4. Select Confirm to begin importing your data.

A progress indicator will display the import status. Wait until the process finishes before closing the tool or shutting down your computer.

The time required depends on the size and complexity of your company data. Large migrations may take several hours.

When the import finishes, select Done.

What If the Certificate Window Does Not Appear?

If the migration tool cannot connect to QuickBooks Desktop, the authorization window may fail to appear.

You can try running the migration tool or QuickBooks Desktop with administrator privileges:

  1. Close the relevant application.
  2. Right-click its program icon.
  3. Select Run as administrator.
  4. Retry the migration process.

Use this option only when needed, and make sure you are working with the correct company data.

Step 5: Verify Your QuickBooks Desktop Financial Reports

Importing your data is only part of the migration process. You should compare your financial reports to check whether the imported records match your original accounting information.

Compare Profit and Loss Reports

Run a Profit and Loss report in both QuickBooks Online and QuickBooks Desktop.

For a meaningful comparison, use the same reporting period and the accrual accounting method in both applications. Compare the totals and review any significant differences.

Pay attention to income, expenses, and other figures that affect your business's financial results.

What If Your Reports Do Not Match?

Differences may occur because of export limitations, data conversion issues, or problems associated with unsupported versions of Internet Explorer used in certain legacy workflows.

If your reports do not match, try the following steps:

  1. Open QuickBooks Desktop.
  2. Select File.
  3. Choose Close Company.
  4. Repeat the migration steps to import your file again, following the applicable instructions.
  5. Run the Profit and Loss reports again using the same reporting period and accrual basis.

Before repeating an import, confirm that you are following the correct workflow and saving the results to an appropriate file. Avoid overwriting important company data without a verified backup.

If the reports still differ, investigate the transactions and balances responsible for the discrepancy. You may need to make manual adjustments in QuickBooks Online or QuickBooks Desktop after verifying the correct amounts and accounting treatment.

Do not enter adjustments simply to force the totals to match. Identify the underlying cause first so your accounting records remain accurate.

Common QuickBooks Migration Problems and Their Solutions

Some migration issues can interrupt the process or affect the accuracy of your imported data.

Migration tool cannot connect to QuickBooks Desktop: Confirm that QuickBooks Desktop is installed and that the application is on the No Company Open screen. If necessary, retry the process with administrator privileges.

QBXML file cannot be located: Check your Downloads folder or the location you selected when saving the file. Use the Browse option to select the correct file.

Migration takes too long: Large company files can require several hours to process. Allow the import to finish before interrupting it.

Financial reports show different totals: Compare reports for the same dates using the accrual basis. Investigate conversion limitations and individual transactions before making adjustments.

Some records are missing: Review the migration documentation to determine whether the affected data type is supported. Inventory for products and services is not exported through the process described in this guide.

For additional guidance, consult Intuit's official QuickBooks Desktop migration tool FAQs and data conversion documentation.

Final Thoughts

Migrating from QuickBooks Online to QuickBooks Desktop involves more than downloading a file. You must prepare your online company data, install the migration tool, export the QBXML file, and import the supported information into the desktop application.

Follow each step carefully and allow enough time for large company files to process. After the migration, compare Profit and Loss reports using the same reporting period and accrual basis. Review missing records and differences before making any manual adjustments.

With proper preparation and verification, you can move your supported accounting information into QuickBooks Desktop and continue managing your business records with greater confidence.

Add as a preferred source on Google