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.

@mck1 

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