Import vendors

The following is a list and explanation of each of the fields you can include when importing vendors.

Important Note: If you sync with an accounting system, we don't recommend importing records via CSV into Bill.com unless they don’t exist in your accounting system at all to avoid duplicates and sync errors.

Field Name Required? Maximum Length Description Accepted Values Additional Information
Active? No NA Denotes if this Vendor is active or inactive - Active
- Inactive
- Requires an exact match with one of the accepted values
- All records are set to Active when created; they cannot be created and set to inactive in the same import
Vendor Name* Yes 100 characters The name of this vendor - Key field
- Requires an exact match with the desired Vendor's name (for updating)
Vendor ID No 20 characters An alternative identifier for this Vendor defined by you and/or a third-party system - Key field if in use
- Requires an exact match with the desired Vendor's name (for updating)
- If syncing with an accounting system, don't update this field
Name on Check No 250 characters The name used for payments you have us send, if different from the Vendor Name
Account Number No 70 characters The account number of this Vendor (typically provided by vendor)
Tax ID No 16 characters The tax ID of this Vendor for 1099 reporting in your accounting system
1099 Vendor No NA Denotes whether this Vendor is a 1099 Vendor - Yes
- No
Requires an exact match with one of the accepted values
Payment Address No 500 characters The first line of this Vendor's payment address
address2 No 500 characters The second line of this Vendor's payment address
address3 No 500 characters The third line of this Vendor's payment address
address4 No 500 characters The fourth line of this Vendor's payment address
City No 255 characters The city of this Vendor's payment address
State / Province No 255 characters The state or province of this Vendor's payment address
Zip / Postal Code No 20 characters
Country No 255 characters The country of this Vendor's payment address
Primary Email No 1023 character The primary email address for this Vendor Must be formatted as email address: e.g. name@domain.com
Fax No 40 characters The fax number of this Vendor
Phone No 40 characters The phone number of this Vendor
Payment Info Email No 1023 characters An alternative email address to use for emailing payment information to this Vendor Must be formatted as email address: e.g. name@domain.com
Payment Contact No 40 characters An alternative phone number for this Vendor to contact regarding payments
Description No 4000 characters The description of this Vendor
Payment Terms Name No 100 characters The terms provided by your vendor that determine how many days you have to pay a bill
  • Vendor balances can't be imported
    • Balances are based on bills in Bill.com

The following fields won't import; leave them blank on the template to avoid errors:

  • Tax ID Type
  • Type
  • Send Notifications
  • Bill Payments in Last 12 Months From accounting system
  • Billed In
  • Bill Sync Preference
  • Preferred Payment Method
  • Purpose of Payment
  • Vendor Bank Country
  • Send Invite For Private Vendor
  • Vendor Virtual Card Remittance
  • Remit Email From Payer