How to import your Vendor and Customer lists

For accounts on our price plan where accounting system sync isn't available, you can connect one time with QuickBooks Online or Xero to bring in your vendor and customer lists. If you use other accounting systems, you can use our import feature to import them in manually.

Using QuickBooks Online

If you use QuickBooks Online for your accounting system, we can connect to your QuickBooks Online account to automatically import your customer list.

  1. Select the Sync with your accounting software card
  2. Select Get started
    QBO one time sync
  3. Enter Master or Company Admin login credentials for your QuickBooks Online account
  4. Select Sign In
  5. Select Authorize

Using Xero

If using Xero for your accounting system, we can connect to your Xero account to automatically import your vendor/customer list.

  1. Select the Sync with your accounting software card
  2. Select Get started
    Xero one time sync
  3. Select Connect your Xero account
  4. Enter Xero login credentials
  5. Select Allow access

Import manually

If you use an accounting system other than QuickBooks Online or Xero, you can use our import feature to import your vendor and customer lists.

Export your vendor and/or your customer list from your accounting system in .csv format then follow the steps below:

  1. Select Settings
  2. Select Import/Export
  3. Select Import next to Vendors or Customers
  4. Select Choose file and locate your vendor or customer .csv file
  5. Select Upload
  6. Map the headers of your spreadsheet to the Bill.com℠ fields
  7. Enter a profile name next to save as for this header mapping
    • We will save this mapping so that you don't have to map it again
  8. Select Continue
  9. Select Import