Skip to main content
B
BooksB4Breakfast
August 23, 2021
Solved

Invoice number does not import

  • August 23, 2021
  • 1 reply
  • 0 views

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.

Best answer by JoesemM

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. 

1 reply

JoesemM
JoesemMAnswer
August 24, 2021

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. 

S
Sietske
August 14, 2024

This does not work. QBO will not import the custom invoice numbers even when the settings has been updated?

What am I doing wrong, I can't get these invoices to import because I keep getting "unknown error" on the invoice number field. 

Terms & ConditionsAccessibility statement