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

Importing: Vendors

FAQ

Can’t find your answer?