cancel
Showing results for 
Search instead for 
Did you mean: 
GailQAP
Level 1

import invoices but let QB number them

I want to import multiple invoices but still allow QB to number them - but, an invoice # is required to import

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

import invoices but let QB number them

Thanks for checking in with us, GailQAP.

 

If your invoices have multiple line items, let's make sure each line entry has an invoice number, customer, invoice date, and other required details, just like in the sample spreadsheet. Also, your spreadsheet should be in .csv format and have the following columns:

 

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

 

If you use numbers to track your invoices, we can turn on custom transaction numbers in QuickBooks Online (QBO). If you don't turn this on, the program will automatically number the invoices for you. Here's how:

 

  1. Go to the Gear icon on the top menu. 
  2. Select Account and settings.
  3. Click the Sales tab. Then hit Edit in the Sales form content section.
  4. Turn on Custom transaction numbers.
  5. Press Save and then Done.

 

Once done, upload your spreadsheet so you can start the import by following the steps below:

 

  1. Go to the Gear icon on the top menu. 
  2. Select Import data.
  3. Tap Invoices.
  4. Choose the checkbox to add new customers that don't already exist in QuickBooks.
  5. Hit Browse and then find and select the spreadsheet of your invoices. 
  6. Press Next.

 

Here's an article you can refer to for more details about importing multiple invoices at once in QuickBooks Online. Once everything is settled, see this guide to record your sales transactions so your invoices are masked as paid: Record invoice payments in QuickBooks Online.

 

You can also bookmark the Customize invoices, estimates, and sales receipts in QuickBooks Online for future reference that contains a video for visual reference and steps on how to enhance and add a brand to your sales forms.

 

The Community will always have your back if you need a hand with managing your invoices and customizing your custom form styles. If you have other questions, feel free to add them below. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us