Quickbooks Import Data Not Responding

Quickbooks Import data not responding when there is an issue with the data file: accountant’s copy, backup, or spreadsheet. Some users report that the software stops responding, while others report that there are unexpected results because of the import. QuickBooks has several rules for importing data from an accountant’s copy, but spreadsheets are more flexible and only require the basic compatibility requirement. Further, upgrading a company file can also lead to software freezing when you try to import the changes into the company file.

Reasons for QuickBooks “Import Data” not responding: Unexpected changes in the data when importing the accountant’s copy, Restoring a backup causes QuickBooks to Freeze, The error occurs when importing from QuickBooks Desktop to QuickBooks online, Error while importing an IFF file (invoice) from third-party software, Not responding when trying to import from a spreadsheet. In this post, we’ll look at each of these issues and help you solve this error.

Causes of QuickBooks Import Data Not Responding Issue

The QuickBooks Import data not responding error can occur because of the following reasons:

• The QuickBooks company file was upgraded after the creation of the accountant’s copy.
• The accountant’s copy isn’t being imported into the right company file.
• Microsoft Excel installed on the user’s system isn’t compatible with the available version of QuickBooks Desktop.
• QuickBooks cannot connect to the company file from which it needs to import the data.
• The original company file or the accountant’s copy is damaged.

Top 3 Solutions for QuickBooks Import Data Not Responding

As per the reasons given for the error, you may have to try these different solutions one by one. However, if you have identified the cause, then you can skip to the particular solution to resolve this error. Let’s look at some possible solutions for this error.

Step 1: Change preferences for importing the accountant’s copy

• When users try to import the changes from the accountant’s copy into the company file, they sometimes encounter this error. One of the following happens during the import process:
• The Import Accountant’s changes from Web/File are disabled (grayed out).
• Error: “QuickBooks cannot import the Accountant’s Changes. Possible reasons are…”
• When it comes to the accountant’s copy, the QuickBooks import data not responding error occurs for the following reasons:
  • The changes are being imported to the wrong company file
  • The company file originally used to create the accountant’s copy was upgraded.
  • Restriction on the accountant’s copy was removed.

Here are some possible solutions based on the cause:

• Restore a previous backup of the company file if it was upgraded for compatibility with a later version.
• Open the correct company file if you haven’t upgraded it.
• Copy the accountant’s file to the local drive and then import the changes.
• Use a different service or method to send and receive the accountant’s copy if you’re having issues with the Accountant’s copy file transfer service.

Step 2: Scan the company file for damage

Importing data into a damaged company file can often lead QuickBooks to not respond. In such cases, it is essential for the user to quickly scan the company file, fix the damage, and if not, then get in touch with an accounting expert.

To test if something is wrong with your company file, you can:

• Create a sample company file.
• Create an accountant’s copy of the sample company file.
• Send the accountant’s copy via the same network.

If the accountant’s copy is created using the sample company file successfully transferred over the ACFT, then your company file isn’t working properly. This can be because of data damage or network issues.

Step 3: Update your worksheet

This info is specifically for users trying to import data from a spreadsheet. QuickBooks has a robust mechanism for importing and exporting data from and to spreadsheets. However, in some cases, the QuickBooks import data functionality doesn’t respond.

• Launch QuickBooks.
• Go to a Report available in QuickBooks. 
• Click on the Excel button.
• Choose the option Update Existing Worksheet.
• After selecting the Browse button, look for the spreadsheet or worksheet.
• Click on Export.

This should help you to export data easily. However, if you’re still getting the same error and QuickBooks simply freezes when you try to import from Excel files, then you need to update both the accounting software and the spreadsheet software.

Conclusion

Whenever you’re working with an accountant’s copy or spreadsheets in QuickBooks, you need to take care of compatibility between the two; otherwise, you’ll receive this error: Quickbooks Import Data Not Responding. You should take your time to go through each of the solutions according to the cause of the error in your system.

Frequently Asked Questions