Import multiple invoices at once in QuickBooks Online

Learn how to import multiple invoices to QuickBooks Online in one go.

You can import more than one invoice at a time in QuickBooks Online. 

Important: If you have set up sales tax in your account, you can’t import invoices this way.

If you'd like to make it easy for your customers to pay an invoice online, check out QuickBooks Payments rates and apply.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view .

Prerequisites

Before you begin, add any new products or services, customers, and vendors to QuickBooks Online and prepare a spreadsheet containing your invoices. 

Whether you use an existing spreadsheet or copy your invoices into a sample file provided by QuickBooks Online, it needs to meet these requirements:

• Each line item needs its own invoice number, customer, invoice date, due date, and item amount.
• Each imported spreadsheet can contain up to 1,000 rows.
• You can import a maximum of 100 invoices at a time.
• You can't add negative charges, such as discounts or credit memos.

Upload your spreadsheet

Upload your spreadsheet so you can start the import.

Note: If you have new imported customers without setting its proper currency, QuickBooks assumes the currency is USD. If you have multicurrency turned on, you can import invoices in foreign currencies.

1. Go to Settings ⚙ and select Import data.
2. Select Invoices.
3. Select Upload a file to import data.  
4. (Optional) Select the checkbox to add new customers that don't already exist in QuickBooks.
5. Select Browse and then find and select the spreadsheet for your invoices.
6. Select Next.
7. Map the column headers with QuickBooks Online’s invoice fields.
   • Fields with an asterisk (*) are required.
   • Select Not applicable for any fields not in your spreadsheet.
     Note: QuickBooks populates with a generic item called "sales" for missing products and services.
8. Select the date format you used, like DD/MM/YYYY.
9. Select Next.
10. After you've mapped the fields, review the summary of your import. If everything looks good, select Start import.
11. Once you’re done:
    • Select OK if all your invoices have been imported successfully.
12. If some invoices fail to import, note why, then select Done.

Related links

• Set up and use Multicurrency in QuickBooks Online