Importing CSV invoices - Format of

It's a pleasure to have you in the Community space, Charles. I'll provide details to ensure your invoices get imported successfully inside QuickBooks Online (QBO).
 

First, please know that the Products or service items should be arranged accurately according to how they'll be written or coded inside the CSV file. This way, QuickBooks can easily recognize the data you're trying to get into your company and finish the importation process. Moreover, if you use categories and subcategories, implement them in the file you wish to upload inside the system. I'll outline the steps to get you going:

1. Locate the CSV file in your system and then open it. 
2. Review the data inside the CSV file and ensure they follow this format [Name of category]:Name of sub-category]:[Name of the product/service item]. 
3. Once done, click File menu and then select Save.
4. Import the invoices inside QBO. 

See this page for more details about the process: Import Multiple Invoices at once in QuickBooks Online.

You can also consider utilizing a third-party application to streamline data transfer from one program to another. Visit our official QuickBooks App Store to help you find an app: https://quickbooks.intuit.com/app/apps/home/en-us/

In addition, you can check this article to know more about what data can be imported inside QBO: Common questions about importing data to QuickBooks Online.

I'll be on the lookout if you require further assistance importing data or managing invoices inside QuickBooks. You can count on me to help you out right away. Keep safe. 

Hi Kurt,

Thanks for replying but you have not addressed the issue.

We need to import invoices as CSV files. The CSV files are formatted per QB documentation.

The issue is that (please see screenshot I uploaded) that we need to call our Interpreting service (set-up in QBO) using the Flowers:Roses:Red Roses format.

We know that our "Red Roses" is "Interpreting." What we don't know is what category and possibly subcategory we need to add before. 

Your importer tells us what to enter but not where to find that info.

(Can't tell if the reply went through, it's not showing it after I posted it.)

Hi Kurt, 

Thanks for replying but you have not addressed the issue.

We need to import invoices as CSV files. The CSV files are formatted per QB documentation.

The issue is that (please see screenshot I uploaded) that we need to call our Interpreting service (set-up in QBO) using the Flowers:Roses:Red Roses format.

We know that our "Red Roses" is "Interpreting." What we don't know is what category and possibly subcategory we need to add before. 

Your importer tells us what to enter but not where to find that info.

Thanks for the prompt response, @CharlesQuestion. I'm here to guide you on how to format the file to ensure you can import your invoices into QuickBooks Online (QBO).

Based on your configuration of the product/service item, you must verify that it aligns with the CSV file. If you're not using categories and sub-categories, simply modify the service item by removing any associated categories.

If you're using categories and subcategories, please review if you're using the correct format in the CSV file, which is [Name of category]:[Name of sub-category]:[Name of product/service]. For instance, my service item is Interpreting and Flowers is the category and Roses are the sub-categories. Then, the format in the Item column would be Flowers:Roses:Interpreting.

Please see the screenshot below for your visual reference:

Once imported, it will appear like this: 

However, if it's formatted correctly in your CSV file and the issue persists, I suggest using an incognito window to access your QBO account to determine whether the problem is with your browser. Here are the shortcut keys:

• Google Chrome: press Ctrl + Shift + N
• Mozilla Firefox: press Ctrl + Shift + P
• Safari: press Command + Shift + N

Once you're in incognito mode, log into your QBO account and import your invoices again. If you're able to import them using a private window, return to your regular browser and clear its cache. Clearing the cache and cookies is the best way to get a clean slate for your browser. Otherwise, using other supported browsers can be also a good option.

Moreover, you'll want to visit this article that outlines how to document your invoice payments to keep correct financial records: Record invoice payments in QuickBooks Online.

I'm all ears and ready to provide further support regarding importing invoices in QBO. I'm just around to promptly assist you.

Thanks, Kevin. Super helpful answer. I wanted to confirm that I've seen it. I'm waiting to hear back from the person in charge of settings things up in QBO.

Thanks, Kevin. Super helpful answer. 

I wanted to confirm that I've seen it. I'm waiting to hear back from the person in charge of setting-up QBO.

I sort of understand that.  I’ll try to put in place.