Skip to main content
February 26, 2024
Question

Imported customers as vendors on accident

  • February 26, 2024
  • 1 reply
  • 0 views

I didn't realize I had vendors selected when I was importing a large list of customers using quickbooks online. Now I cannot create invoices without manually recreating them. Is there a way to undo the import or mass change all the vendors to customers?

1 reply

MsNorthPND18
February 26, 2024

I know how to rectify your concern about importing a customer list into QuickBooks Online (QBO), @sdgsdfgsdfgsdgs.

 

 Since you mistakenly selected vendors instead of customers. What you can do is make the vendors inactive, and manually recreate or import them as customers on your QuickBooks Online. 

 

To make it inactive here's how:

 

  1. Sign in to QuickBooks.
  2. Select Expenses, then choose Vendors.
  3. Click Vendor Name to make it inactive.

 

To recreate customers here's how:

 

  1. Sign in to QuickBooks.
  2. Select Settings ⚙. Then select Import Data.
  3. Select Customers to Import.
  4. Select Browse to upload the file from your computer.
  5. Choose the file, and select Open.
  6. Or, to upload from Google Sheets, select Connect to sign into your Google account.
  7. Choose the file, and then Select.
  8. Select Next.
  9. In the Your Field column, select each small arrow ▼ icon.
  10. Then, match your field to the corresponding QuickBooks Online field.
  11. Select No Match if you have a field that doesn't have a matching column in your spreadsheet.
  12. Confirm your contacts.
  13. Uncheck any that you don't want to save.
  14. If everything looks good, select Import.

 

To learn more details about the process, please refer to this article: Create multiple bills or expenses in QuickBooks Online Advanced

 

If you have any further concerns regarding importing in QBO, please don't hesitate to comment below. I'll be more than happy to assist you. Stay safe!