I appreciate you sharing detailed information about your concern, cbrv-kirklands.
Knowing why there are duplicates when importing your customer list in QuickBooks Online (QBO) is crucial to help you fix it and avoid it from reoccurring. Let me share some information about this and route you to the best support to check this further.
Yes, you're correct. QuickBooks detects duplicate data from your Excel or CSV files and prevents it from being imported into the program. As this is an unexpected behavior, I recommend that you contact our Live Support team for further assistance. They have the tools to check your account securely and investigate this issue further. Here's how you can reach them:
- Go to the Help menu, then select the Search tab.
- Click Contact Us.
- Enter a brief description of your concern and select Continue.
- Select either Start a Chat or Get a Callback and start connecting with them.
On the other hand, to remove the duplicates on your customer lists, you can make the duplicate one inactive. This will prevent them from appearing in your list or menus and will not impact the importation process in the future.
- Go to Sales, then select Customers.
- Select the customer's name you want to remove, then click the dropdown ▼ next to Edit. If there are multiple duplicates, you can select all of these, then click the Batch action dropdown menu.
- Select Make Inactive, then Yes, Make Inactive, or Yes to confirm.
Alternatively, you can merge the duplicate profiles into one if you don't want to remove them.
Moreover, I'm adding this article for your future reference when creating statements for your customers: Create and send customer statements in QuickBooks Online.
Also, you can run different customer-related and other financial reports to have a bigger picture of your customer transactions and business or financial information.
Please know that the Community is always here to help if you have any concerns with QuickBooks. Just visit us here, and we'll ensure you're taken care of.