cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
BooksB4Breakfast
Level 1

Invoice number does not import

I am importing invoices using a .csv file and all fields work except the invoice number.  QBO assigns a new invoice number rather than pick up an invoice number from the file.  The original invoice number does not already exist in QBO. The example implied (to me) that the original invoice is a mandatory field for the import.

Solved
Best answer August 24, 2021

Accepted Solutions
JoesemM
Moderator

Invoice number does not import

Thanks for posting in the Community space, @BooksB4Breakfast.

 

You can go to the Account and settings and make sure to turn on the Custom transaction numbers option. This way, QuickBooks will not assign or automatically numbers your invoices when you process the import.

 

Here's how:

 

  1. Go to the Gear  and select Account and Settings.
  2. Click the Sales tab. Then select Edit ✎ in the Sales form content section.
  3. Tap Custom transaction numbers and turn on the option.
  4. Hit Save and then Done.

 

Once done, you can now upload your spreadsheets and map your import fields correctly. For detailed steps, see this article: Import multiple invoices at once.

 

You can also bookmark the articles below for future reference. It contains a video for visual reference and steps on how to enhance and add a brand to your sales forms.

 

 

Let me know by leaving a reply below if you need further assistance in importing your invoice in QuickBooks. I'm always here to help. Take care always. 

View solution in original post

1 REPLY 1
JoesemM
Moderator

Invoice number does not import

Thanks for posting in the Community space, @BooksB4Breakfast.

 

You can go to the Account and settings and make sure to turn on the Custom transaction numbers option. This way, QuickBooks will not assign or automatically numbers your invoices when you process the import.

 

Here's how:

 

  1. Go to the Gear  and select Account and Settings.
  2. Click the Sales tab. Then select Edit ✎ in the Sales form content section.
  3. Tap Custom transaction numbers and turn on the option.
  4. Hit Save and then Done.

 

Once done, you can now upload your spreadsheets and map your import fields correctly. For detailed steps, see this article: Import multiple invoices at once.

 

You can also bookmark the articles below for future reference. It contains a video for visual reference and steps on how to enhance and add a brand to your sales forms.

 

 

Let me know by leaving a reply below if you need further assistance in importing your invoice in QuickBooks. I'm always here to help. Take care always. 

Need to get in touch?

Contact us