Importing from Excel to Cycle Count

Hi there, @Cardpeople.

I'll work with you so you'll be able to import files into your QuickBooks Desktop. Let's make sure that QuickBooks is granting access to the internet.

Although you can modify these settings in Internet Explorer, it is preferable to do so in QuickBooks Desktop. This ensures that the new QuickBooks settings are applied.

To do so, you must follow the next steps:

1. Open QuickBooks > select Help in the menu bar > click Internet Connection Setup
2. Check to have to use my computer’s Internet connection settings to establish a connection when this application accesses the Internet selected
3. Click Next > Done

Moreover, try importing data from excel and see if it works. See this article for your additional reference: Import and export data in QuickBooks Desktop.

Note: If your computer is on a network, you will need to verify the server has the correct date and time as well.

If you see the same problems in other areas of QuickBooks Desktop, downloading and installing the QuickBooks Tools Hub will assist in corrections of common errors. To use the tool hub, you must first close QuickBooks.

Here's how:

1. Close QuickBooks.
2. Download the most recent version (1.5.0.0) of the QuickBooks Tool Hub.
3. Open the downloaded file (QuickBooksToolHub.exe).
4. Install by following the on-screen instructions and agreeing to the terms and conditions.
5. When the installation is complete, double-click the tool hub icon on your Windows desktop to launch it.

I added this article for the complete guidelines: Verify and Troubleshoot QuickBooks Desktop and Internet Explorer settings.

Let me know how it goes. I want to ensure that you get this taken care of today. Have a wonderful day!

As a QuickBooks user and QB/IT support tech for 30 years I too experienced this issue where upon importing the cycle count Excel sheet I got a message “Cannot Import Cycle Count”. I am also a ProAdvisor. 

Turns out, for me, the issue was resolved by opening a new blank Excel spreadsheet on the same computer the file was exported to. Then I copied and pasted the data (with formatting) into the new spreadsheet; saved it then reimported and it worked!

Upon further investigation, I discovered that the user who was performing the cycle count moved the cycle count export spreadsheet to another computer with a different version of Excel. I suspect there are some subtle formatting and functionality elements in Excel that the QuickBooks cycle count export/import process requires to operate properly. By creating a new spreadsheet on the original Excel version used for the export, then copying in the data, with formatting, from the exported spreadsheet that had been saved in different version, I believe these required formatting and sheet functions were reinstated. This allowed the process to complete.

Of course, what is very frustrating is the alert messaging was completely erroneous and misleading. In my case, the issue had absolutely nothing to do with the server, internet access or the current login session. 

As a ProAdvisor agent recently advised we discussed the challenges for most users to migrate to QBO, "QuickBooks for desktop is being phased out". Issues like this, the enormous challenge to obtain higher level support on this issue and the responses from Intuit in this forum seem a clear indication that the agent’s advisement has merit.

Has anyone figured out how to import? I have tried all of the recommendations and still receive the same error as OP. This is extremely frustrating.

Any help is appreciated.