Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveHello @nht11704,
Welcome to the Community. I can help you get in the right direction with deleting and importing data in QuickBooks Desktop.
Currently, the option to delete customer records in bulk is unavailable. You'll need to remove them one by one by opening each customer profile in the system.
As a workaround, I recommend making these customers inactive all at once. This method allows you to hide them, including the data from the company file.
Here's how:
To delete a customer completely, follow these steps:
Also, when importing customer data into the company file, there's a specific formatting you need to follow. You'll need to copy the data from the exported file to the formatted spreadsheet coming from QuickBooks.
Please follow these steps:
This method will help ensure you have the correct format when performing the process. After following the steps above, you should be able to upload the data successfully.
For additional reference, you can use the following article if you need edit multiple customers simultaneously in QuickBooks: Add and edit multiple customers, vendors, and items.
Drop me a comment below if you have any other questions about importing data or the required formatting. I'll be happy to help you some more.