cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
pernasloren-gmai
Level 1

QB doesn't allow me to import suppliers, it says that they already exist, when my suppliers list is empty

 
2 Comments 2
Fiat Lux - ASIA
Level 15

QB doesn't allow me to import suppliers, it says that they already exist, when my suppliers list is empty

Which QBO Plan do you have? QBO Simple Start or else?

Rea_M
Moderator

QB doesn't allow me to import suppliers, it says that they already exist, when my suppliers list is empty

Hello there, @pernasloren-gmai.

 

When you import your list of suppliers to QuickBooks Online (QBO), you're able to save time and effort from manually adding them into your account. Before we start the process, I'd recommend clearing your cache and cookies. This will refresh the system and remove older files that cause viewing and performance issues.

 

One of the things you need to consider when importing to QBO is your file format. You need to make sure you're using the one that's accepted by the system (i.e. CSV). To know more about this, here are the things to examine before performing the import process:

  • The file size limit is 2MB or 1000 rows. 
  • Sub-accounts can't be imported. Change them into parent accounts, then change them back after the import.
  • The entries in the Name field must be unique. A supplier, customer, or employee can't have the same name as one another.
  • The import only supports one email address.
  • Column headers are in the first row.
  • Contacts are on Sheet1 of the spreadsheet.
  • The spreadsheet doesn't contain any formulas, charts, blank rows, and errors, such as #REF!, #NAME?, #N/A or #VALUE!.
  • Names don't contain colons (:) or quotation marks (").

 

Once everything looks good, let's now start the import process by performing the steps below:

  1. Go to the Gear icon.
  2. Choose Import data.
  3. Select Suppliers.
  4. Click Browse.
  5. Find and select the file, then click the Open button.
  6. Select Next to continue.
  7. Map your data and then select Next.
  8. Adjust your data if necessary then select Import.

 

After that, go to the Supplier page or pull up the Supplier Contact List report to view the complete list of imported suppliers. Just go to the Expenses and suppliers section from the Report menu's Standard tab.

 

I'm also adding this article to further guide you in managing your suppliers and expenses in QBO: Help Articles. It includes topics about entering and paying bills, deleting expenses, and viewing supplier transactions to name a few.

 

Please know that you're welcome to comment below if you have other concerns or follow-up inquiries about managing supplier lists and transactions in QBO. I'm just around to help. Take care always.