Importing: Vendors

Fields accepted when importing Vendors.

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 automatically 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 Cell - 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 Cell - Key field if in use: Requires an exact match with the desired Vendor's name (for updating)
- If syncing with an accounting software, do not update this field
Name on Check No 250 characters The name used for payments you have us send, if different from the Vendor Name Cell Cell
Account Number No 100 characters The account number of this Vendor (typically provided by vendor) Cell Cell
Tax ID No 16 characters The tax ID of this Vendor for 1099 reporting in your accounting software Cell Cell
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 Cell Cell
address2 No 500 characters The second line of this Vendor's payment address Cell Cell
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 Cell Cell
State / Province No 255 characters The state or province of this Vendor's payment address Cell Cell
Zip / Postal Code No 20 characters Cell Cell Cell
Country No 255 characters The country of this Vendor's payment address Cell Cell
Primary Email No 1023 character The primary email address for this Vendor Cell Must be formatted as email address: e.g. name@domain.com
Fax No 40 characters The fax number of this Vendor Cell Cell
Phone No 40 characters The phone number of this Vendor Cell Cell
Payment Info Email No 1023 characters An alternative email address to use for emailing payment information to this Vendor Cell 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 Cell Cell
Description No 4000 characters The description of this Vendor Cell Cell
  • Vendor balances cannot be imported
    • Balances are based on bills in Bill.com