Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
mck1
Level 2

Hey! I can't figure out how to import bills. What format is the vendor name supposed to be in? Everything else works but the vendor name gives me an error.

I am literally copying and pasting from the Supplier name to the spreadsheet so wondering if there's some other value related to the supplier I'm supposed to use. It gives me an error to say vendor not found, and I don't want to have it create a new vendor since I want it tied to my existing vendor. Help please!
2 Comments 2
Alex M
QuickBooks Team

Hey! I can't figure out how to import bills. What format is the vendor name supposed to be in? Everything else works but the vendor name gives me an error.

Hi there mck1,

 

Thanks for reaching out about entering bills. QuickBooks Online is a great tool able to import different information from CSV and Excel files to save you time with data entry. I can provide some information about importing bills.

 

The first step to try would be to make sure the name of the supplier in QuickBooks has no special characters and has no extra space after their name. This can be done by going to the Expenses tab, then Suppliers. Click on the name of the supplier in question, then Edit. Make sure that the Supplier display name has no extra spaces.

 

One extra step is to make sure that there are no commas in the line affected in the file being imported, as the comma is used in the CSV file to separate the cells of a line. If there is a comma in the name, this would technically separate the name in the file, as well as if there is a comma somewhere else in the line, there would be too many cells in the line.

 

If you have any other questions or need further assistance, feel free to reach out here.

4Gal
Level 11

Hey! I can't figure out how to import bills. What format is the vendor name supposed to be in? Everything else works but the vendor name gives me an error.

@mck1 

Did you try to import bills with a 3rd party tool?

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us