Hello, I am trying to upload an Excel file of Customer contacts to QB, but am getting the attached error message. I have no idea what it means, let alone how to fix the problem. If anyone knows what to do with this, any advice would be most appreciated.
I can help you sort out your concern about importing files into QuickBooks Desktop (QBDT) for Mac, @AKAKAK.
Regarding the error message you encounter when trying to import data, we can perform the steps below to fix it:
I also suggest you check out this article to learn more about importing contacts and how to fix any missed entries when importing transactions: Import data into QuickBooks for Mac.
If you want to know what the other lists you can import to QuickBooks Desktop are, you can check that out here: Import and export data in QuickBooks Desktop.
Feel free to add a comment if you need further assistance with importing data. I’m hoping your business will prosper. Have a great day!
Hi there, @AKAKAK.
Thanks for following up with us.
So I can investigate the error message further, would you mind sharing a screenshot of it? I want to ensure you get back to business as quickly as possible. By seeing the error, I can know more information about it and let you know what may be causing it.
I'll be sure to keep an eye out for your reply and look forward to chatting with you soon. Take care, and have a wonderful day ahead!
Good morning, @AKAKAK.
Thanks for coming back with that screenshot.
To clarify, which file type are you currently trying to import into your QuickBooks Desktop for Mac account?
In the meantime, you can check out this guide about importing your contacts: Import data into QuickBooks for Mac.
Please reach back out with those details, and then we'll determine the best solution for your business. I'll be right around the corner!
Thanks for following up with the Community, AKAKAK. I appreciate your detailed information.
Since you're receiving this message when trying to import contacts from spreadsheets, I'd recommend confirming that each customer's information is entered properly.
Once you choose Paste from a spreadsheet, you'll want to be sure to open the spreadsheet you're working with and copy each customer's First Name column, then paste your copied text into QuickBooks. Once you've finished entering their names, you'll need to make sure that each customer you want imported has their Import box ticked. Before completing your import, also confirm there's no blank name fields and that everything's labeled correctly.
If you continue receiving the error, I'd recommend using your Verify utility to see if anything needs to be rebuilt.
If you receive a "Your data has failed the integrity check" message, you'll need to rebuild your file:
In the event your Verify utility doesn't find any problems with the data, or you completed a rebuild and are continuing to receive the error when importing contacts, you'll want to get in touch with our Customer Care team. They'll be able to pull your account up in a secure environment, conduct further research, and create an investigation ticket if necessary.
I'll be here to help if there's any questions. Have a great day!
Thank you, @ZackE . Everything seems to be correct on the spreadsheet. I also tried directly entering information from one contact in the Import Contacts form, but it always brings up the same error message. Since I don't have any contacts now, Verify Data finds no issues.