When an invoice has multiple rows, enter the same invoice number in every row that's part of that invoice.

Hello pattyk,

  I can say here that if you are using a .csv file it is not possible to import Invoice that has multiple rows without setting an Invoice number as it is used for grouping the rows.

  Can't say why it doesn't work with a single line though.

Thanks for posting in the Community, @pattyk. I'd be glad to lend a hand with importing invoices. 

First, I'd like to take a quick moment to welcome you to QuickBooks Online Advanced. It's also nice to see that you're taking advantage of the new features in the software.

@Aleh - CloudBusiness is correct in that you will need to have an invoice number when importing a CSV. This is a required column and is largely used to help ensure that transactions are properly grouped. I had a similar experience of needing to include an invoice number for a file that had a single line. 

The Custom transaction numbers setting means that the numbers in the Excel file will be pulled over if it's turned on. However, if it's not, then the imported invoices will have their number overwritten by the standard QuickBooks numbers. For example, if your spreadsheet has an invoice marked as 101 then it will not be retained and a default will be used. 

Should you not need custom numbers then you can put a default or generic number in there as it will be overwritten. However, please make sure that invoices with multiple items on it share the same number to ensure proper grouping. 

Please let me know if you should have any questions about this or anything else as I'm just a few clicks away. Have a good day. 

Dear Team,

I am facing the same error even I have put the invoice nos. Can you please let me know why the error is coming on invoice nos. when I have already put it.

Thanks for following on this thread, Ajain1.

I appreciate you sharing with us a screenshot of your concern. This gives me a better picture of what's happening to the invoices.  Let me help you point in the right direction so you can import the CSV file seamlessly.

When importing invoices, the CSV file should meet the required format. Aside from the Invoice Number, Customer, Invoice Date, Due Date, and Item Amount, make sure it has a Taxable column. Aside from that, the date format should be similar to the sample spreadsheet. There shouldn't be any negative numbers on the template, too.

Now, let's go back to the CSV template and review the mapping of the fields. Make sure the format is similar to the sample spreadsheet.

After reviewing, you can start importing it to QBO. Here's how:

1. Go to the Gear icon at the top to choose Import Data.
2. Tap the Invoices tile to open the Import invoices page.
   
3. From there, click the Browse button to find the CSV file and hit Open to upload it.
   
4. Choose Next to continue.
5. On the Map your column headings page, review the mapping of each field and press Next.
   
6. Follow the on-screen instructions to complete the import process.

For additional resources, check out this link. It provides important tips to follow to successfully import the  CSV file to QBO: Accelerated invoicing with QuickBooks Online Advanced, Part 2: Importing invoices. 

Let me share the Import multiple invoices at once article. It provides detailed information on the do’s and don’ts when importing the sales transactions. From there, you’ll see the complete steps on how to prepare the spreadsheet up to importing the invoices. Go to the Prep your Spreadsheet section and proceed to #3 to see the requirements to transfer entries and to access the downloadable sample template.

Stay in touch if you have any other concerns or questions. I’ll be right here to answer them for you. Have a good one. 

I am having uploading problem of my previous send csv due to the below error in Quick books.

Not sure, as in my CSV I have put the invoice nos. as per the format present in sample file. What is this error all about and how to resolve. Kindly assist.

**Some rows need invoice numbers

When an invoice has multiple rows, enter the same invoice number in every row that's part of that invoice.

I am facing a similar issue while importing invoices with the same error. Kindly note that this is not the first time I am importing. Have been importing for the past many months seamlessly. I have also checked my csv file many times in different ways and invoice numbers are correct. There is no line were an invoice number is missing (as reflected in the error).

Could you please help resolve

Thanks

Shri

I know it can be frustrating when you're not able to get your tasks done in Quickbooks due to receiving errors, Shri.

If you've met the required format when importing the CSV file yet, the issue persists, I'd recommend reaching out to our Customer Care Support Team. This way, one of our live support agents can do a screen-share with you and further investigate the root cause of this error.

Here's how to contact them:

1. Go to Help.
2. Select Contact Us.
3. Enter a brief description of your concern in the What can we help you with? field.
4. Click Let's talk.
5. Choose a way to connect with us.
   

Check out these import-related articles for additional guide and reference:

• Import custom form styles for invoices or estimates
• Import multiple invoices at once

Please keep me posted on how the call goes. I want to make sure this taken care of.

I've been having this issue all day. Tried several solutions, won't work with even a single line invoice = same multi line error.

I RESOLVED my issue by:

1. Create new blank .csv file.

2. Type in new headers (I specifically did not copy them from the original s/sheet).

3.Copy all data from the original file to the new file.

4. Imported all records for me after doing this.

I suspect it is something to do with the excel spreadsheet (possibly the headers??) and not your data. Really hope this helps someone because I was very frustrated with it.

THANK YOU SOOOOO MUCH!!!  i was pulling my hair out!!!

I resolved too just writing the amounts and dates and NOT using any formulas. 

Hey, everybody!
Maybe my way out of the situation will help someone.
When opening a csv. file in an external program, I noticed that there are unprintable characters in it. Some functions write them and you do not see them, but they still get into the csv. In my case it was the CHAR(10) function. It left invisible characters and I could not import the csv file into QB, it showed the message “Invoice No. missing in one of the rows.”.
It doesn't matter where these characters are, they can be anywhere and prevent you from working productively. 
Look screenshot.
Thank you.