Showing results for 
Search instead for 
Did you mean: 
27 helpful votes

Import invoices in batches

Learn how to import invoices in batches to QuickBooks Online.

Do you need to import a batch of invoices quickly into QuickBooks Online? If you're a QuickBooks Online Advanced user you can easily do this. We'll show you how.

Note: Don't have QuickBooks Online Advanced yet? See if it's right for you.

What can I import into QuickBooks?

  • Invoices can be imported with multiple line items or as a total value for each invoice.
  • Add new products and services to QuickBooks before importing.
  • Multicurrency is supported.
  • Product categories are supported.
  • Sales tax is not supported.
Note: We recommend you don’t import more than 100 invoices at a time. There is also a 1,000 row limit per spreadsheet or CSV file.

Before you get started

Prep your CSV file

Before you import your data, you need to prep your CSV (or Excel) file accurately. The following columns are required:
  • Invoice number
  • Customer
  • Invoice date
  • Due date
  • Item amount
  • Item tax code (if applicable)
You'll be able to map each of your column headings to QuickBooks invoice fields during the import flow. Take a look at . There is also an example data file available for you to download.

Import a batch of invoices

Once your spreadsheet is set you can import the data into QuickBooks Online.

Step 1: Open the Import Invoices tool

If you want to import your own invoice numbers, first turn on Custom transaction numbers in Account and Settings, which is found in Sales. ( Note: If you don't turn this on, invoice numbers in your spreadsheet will be overwritten by standard QuickBooks invoice numbers.) User-added image To begin your import:
  1. Go to Settings ⚙️, then select Import Data.
  2. Select Invoices.

Step 2: Upload your CSV file

  1. Once your CSV file is ready, select Browse, then select your CSV file.
  2. You have the option to add any new customers that are not in QuickBooks Online. If you would like QuickBooks to create customers, check the applicable box.
  3. Select Next.
Note: If your CSV file contains new products/services, you must import or add new products and services before uploading your CSV file.

Step 3: Map your import fields

Map your column headings

  • Map all mandatory fields that are marked with an asterisk (*).
  • Select Not applicable for any fields not in your CSV file. Note: If no product or service is present, QuickBooks will populate this field with a generic item called "sales".
  • Select the date format you have used, ex. DD/MM/YYYY.
  • Select Exclusive or Inclusive as your sales tax option. .
  • Select Next.
At this stage, any mapping issues will be highlighted so you can go back and resolve them.

Step 4: Import invoices

After you map the import fields, you will see a summary of your import. If everything looks good, select Start import. Once completed, an import summary will be displayed:
  • If your invoices were added successfully, select OK to finish.
  • If any invoices fail to import, note why, and then select Done.
Your invoices have been added to your accounts.

Other Helpful Tips

  • QuickBooks Online supports the import of a large volume of customers and vendors or products and services.
  • New product and service items and customers and vendors must be added before importing your invoices.
  • Discounts, credit memos, and negative amounts, in general, are not supported.
  • When new customers are imported, if no currency is specified QuickBooks assumes the customers’ currency is USD.
  • When invoices have multiple line items, ensure each line entry specifies the invoice number, customer, invoice date, etc., as seen in the example CSV file, specifically invoice 1001.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us