Showing results for 
Search instead for 
Did you mean: 
Get your Payroll questions answered by a QuickBooks Product Manager here -
Level 1

Importing Invoice in QBO


I am trying to import my CSV file for sales mapped in all respect but it shows the error as shown in screen shot, can anyone help to resolve the issue? The error shown is invoice number.


Invoice Import Error.jpg

QuickBooks Team

Importing Invoice in QBO

Hi there, @Zaini.


It could be that invoices were in an incorrect format. This is why you're getting the error message. Before you import your invoices, make sure everything looks good in your spreadsheet.


Let's ensure that the following required columns are filled in: 


  • Invoice number
  • Customer
  • Invoice date
  • Due date
  • Item amount
  • Item tax code


Additionally, here's what you can and can’t import in QuickBooks Online (QBO).


  • You can’t add discounts, credit notes, and negative amounts in general.
  • You can import a maximum of 100 invoices at a time and 1,000 row limit per spreadsheet.
  • You can import invoices with single or multiple line items.
  • You can also import a large volume of customers and suppliers or products and services.


If you already checked the steps above, let's perform some basic troubleshooting to address the issue. There might be a cache build-up in your current browser that's causing the error. 


First, open your account in a private window. Simply press the following shortcut keys:


  • Press Ctrl + Shift + N (Google Chrome).
  • Ctrl + Shift + P (Firefox).
  • Control + Option + P (Safari).


If you're able to import your invoices successfully, go back to your regular browser and clear its cache. You can also use another supported browser as an alternative option. This might be a temporary issue with QuickBooks and the current browser that you use.


Additionally, you can check out this article as an additional reference in importing your sales transactions: How to import multiple invoices at once in QBO.


Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Keep safe!