How do we get auto invoice number generation to work with batch invoice import via CSV? It works when batch invoicing from the web interface, but not the CSV import.

Hello there, alippiatt@bioinf.

I can share the details on how you can match your transactions using the invoice number. 

Setting QuickBooks to automatically match the bank transactions using the invoice number is currently unavailable. You'll need to manually match them using the Find match option to apply the transaction to the correct invoice number.

I'm leaving you this recommended article. This will provide you with more information on how to manage your bank transactions in QuickBooks Online as well as on what are the options you can choose to allocate them: How to set and use banking rules for downloaded transactions.

If I can be of additional assistance, please let me know. I'll be more than willing to lend you a hand.

Thanks for the reply, LollyNino_C, but I don't think it is related. We're not trying to download and match bank transactions. Rather, we're creating invoices using the batch invoice feature via CSV import.

Thanks for following up with the Community, alippiatt@bioinf.

You can have QuickBooks automatically number invoices while importing from a CSV spreadsheet by having custom transaction numbers turned off.

Here's how to make sure it isn't active:

1. Use your Gear (⚙️) icon, then go to Account and settings.
2. Access your Sales tab and find the Sales form content section.
3. Hit its Pencil (✏️) icon.
4. Make sure Custom transaction numbers is turned off.
5. If any changes were made, select Save, then Done.

If you choose to continue entering invoice numbers manually in your spreadsheet, you'll need to make sure all of the required information is present. 

In regard to the error message you're receiving when trying to import your CSV file, since it's saying that there's an invoice number missing in one of its rows, I'd recommend reviewing your spreadsheet to identify where the missing number is. Once you've found it, you'll need to enter the missing data to have your import complete without displaying any errors.

If you review the file and identify that it's not missing any invoice numbers in any of its rows, I'd recommend getting in touch with our Customer Care team . They'll be able to pull up the account in a secure environment, conduct further research, and create an investigation ticket if necessary.

They can be reached while you're signed in.

Here's how:

1. Use the Help (?) icon.
   
2. Click Contact Us.
   
3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.
   
4. Select Start messaging or Get a call.
   

Be sure to review their support hours so you'll know when agents are available.

Please feel welcome to send a reply if there's any additional questions. Have a great day!