Skip to main content
R
russ23
July 15, 2021
Solved

Importing invoices issue

  • July 15, 2021
  • 1 reply
  • 0 views

I am trying to import invoices daily to QB but i dont want to allocate an invoice number. How do i import invoices and QB assign the next available invoice number to the invoice as at the minute when i tried to import a csv it says it cant as there is no invocie number on my csv 

 

Thanks 

Best answer by LollyNino_C

It's nice to see you again in the QuickBooks Community, @russ23. 

 

I can say here 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 them share the same number to ensure proper grouping. 

 

Also, I'm including this article to serve as your reference when importing your templates in QuickBooks: Import custom form styles for invoices or estimates. On the same link, you'll find invoice samples as well as steps to fix uploading issues.

 

If you need further assistance with the steps when importing transactions, I recommend contacting our QuickBooks Online Support Team. They have additional tools to pull up your account and do screen-sharing. 

 

Here's how to contact our customer support:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (question mark icon) at the top right.
  3. Select Contact us to connect with a live support agent.

For additional reference, you can check this article for the detailed steps on how to import bank transactions using Excel CSV files. 

 

Don't hesitate to leave a comment below if you have additional questions about importing transactions using the CSV files. I'd be around to help you out. Have a good one. 

1 reply

E
EmmaM
July 15, 2021

Hello Russ23, Welcome to the Community! Thanks for getting in touch about the invoice numbering issue. Can you check in the settings cog in the top right>account and settings>sales if you have custom transaction numbers turned on?

R
russ23Author
July 15, 2021

HI Emma 

 

Thanks for the quick response . At the minute i have it turned off . 

 

Thanks 

 

Russ

 

L
LollyNino_CAnswer
July 15, 2021

It's nice to see you again in the QuickBooks Community, @russ23. 

 

I can say here 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 them share the same number to ensure proper grouping. 

 

Also, I'm including this article to serve as your reference when importing your templates in QuickBooks: Import custom form styles for invoices or estimates. On the same link, you'll find invoice samples as well as steps to fix uploading issues.

 

If you need further assistance with the steps when importing transactions, I recommend contacting our QuickBooks Online Support Team. They have additional tools to pull up your account and do screen-sharing. 

 

Here's how to contact our customer support:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (question mark icon) at the top right.
  3. Select Contact us to connect with a live support agent.

For additional reference, you can check this article for the detailed steps on how to import bank transactions using Excel CSV files. 

 

Don't hesitate to leave a comment below if you have additional questions about importing transactions using the CSV files. I'd be around to help you out. Have a good one. 

Terms & ConditionsAccessibility statement