Importing Invoicing Information into Quickbooks

You can export invoiced information for QuickBooks. The format for the customer name in the file exported from X Dispatch will be <Customer Name> <Customer ID>. For example, "Test Customer 1001". 

The customer name in QuickBooks must match the customer name generated by the export, otherwise QuickBooks will try to create a duplicate customer.

How to Export Invoices for QuickBooks

Requires X Dispatch 19.2 or newer for Save to QuickBooks 2019+ File Format and Save to QuickBooks Online File Format.

Save to QuickBooks Online File Format requires the QuickBooks Online Plus or QuickBooks Online Advanced plan.

  1. Go to Actions > InvoicesInvoice Center.
  2. Expand Batches or Single Invoices to find the invoice information you would like to import into QuickBooks.
  3. Right-click on the batch or invoice.
  4. Select Export then the QuickBooks file format you would like. 

Quick Tip

If you need more help with importing into QuickBooks, see their help section https://quickbooks.intuit.com/learn-support/.

How to Import into QuickBooks 2018 or Older

  1. Use the Save to QuickBooks File Format export option.
  2. In QuickBooks navigate to File > Utilities > Import > IIF Files.
  3. Navigate to the IIF file you would like to import and select Open.
  4. Select OK.

For more information see QuickBooks support article here.

How to Import into QuickBooks 2019 or Newer

QuickBooks Pro 2020 and QuickBooks Online Plus were used to create the documentation and take screenshots. There may be differences between this documentation and what you see based on the version of QuickBooks you have.

  1. Use the Save to QuickBooks 2019+ File Format export option.
  2. In QuickBooks navigate to File > Utilities > Import > IIF Files

  3. Choose the import option you wish to use. 

    • "Import it for me. I’ll fix it later" link at the bottom - This is the recommended option. Click here to continue to the steps below. 

      Quick Tip

      This option is recommended because of the overall import success rates.

    • Import IIF button to import with a data review - This option is not recommended. Click here to continue to the steps below.

Import it for me. I’ll fix it later

This option will work in the same manner as importing for QuickBooks 2018 and below.

  1. Create a backup if desired, then select Import IIF

  2. Navigate to the IIF file you would like to import and select Open

  3. Select OK.

Import IIF

Using this option will include a data review that may cause the import to fail.

  1. Locate the file and select OK.
  2. Once the import is completed, select Done.

Troubleshooting Common Issues

  • If the billing phone number for the customer is too long, then the import will fail with an error. You can resolve this by making sure only a single telephone number is in the billing phone field on the customer record.
  • If a semi-colon (;) is included in any of the fields exported to the .iif, the import will fail. The most common place a semi-colon will be included on customer records is the billing email since a semi-colon is used to separate emails if there is more than one listed.

For more information see QuickBooks support article here.

How to Import into QuickBooks Online

The QuickBooks Online export will produce a customers.csv and an invoices.csv. You will only need to use the customers .csv if you have new customers on this invoice that have not been entered into QuickBooks before.

 Click here see how to import customers into QuickBooks Online...
  1. In QuickBook Online, go to Sales > Customers

  2. Open the dropdown next to New customer, then select Import customers

  3. Select Browse.
  4. Navigate to the customers .csv you would like to import and select Open.
  5. Select Next.
  6. Verify the spreadsheet field mapping if desired and select Next.
  7. Verify the customer information and select Import.
  1. Use the Save to QuickBooks Online File Format export option.
  2. In QuickBook Online, go to Sales > Invoices

  3. Open the dropdown next to New invoice and then select Import invoices

  4. Select Browse.
  5. Navigate to the invoices .csv you would like to import and select Open

    Quick Tip

    You can check Add new customers to QuickBooks if you would like to create new customers in QuickBooks for any customers on the invoice that do not already exist in QuickBooks. We recommend you use the standalone customer import instead as it will import more complete customer information.

  6. Select Next.
  7. Verify the spreadsheet field mapping if desired and select Next.
  8. Select Next for any additional screens that come up regarding verifying information. 

    Quick Tip

    The terms will be the number of days for billing set on the customer record in X dispatch. For example, a customer with 30 days for billing will have 30 as the term. You will need to create these terms in QuickBooks Online before the import if they have not already been created in QuickBooks Online.

  9. Select Start Import.
  10. Select OK.

For more information see QuickBooks support article here.