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.
Before you get started
Prep your CSV fileBefore you import your data, you need to prep your CSV (or Excel) file accurately. The following columns are required:
- Invoice number
- Invoice date
- Due date
- Item amount
- Item tax code (if applicable)
Import a batch of invoicesOnce your spreadsheet is set you can import the data into QuickBooks Online.
Step 1: Open the Import Invoices toolIf 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.) To begin your import:
- Go to Settings ⚙️, then select Import Data.
- Select Invoices.
Step 2: Upload your CSV file
- Once your CSV file is ready, select Browse, then select your CSV file.
- 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.
- Select Next.
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.
Step 4: Import invoicesAfter 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.
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.