The following is an explanation of each of the fields you can provide when importing Vendors.
|Field Name||Required?||Maximum length||Description||Accepted Values||Additional Information|
|Active?||No||N/A||Denotes if this Vendor is active or inactive.||Active
|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.||Key field.
Requires an exact match with the desired Vendor's name (for updating).
|Vendor Id||No||20 characters||An alternative identifer for this Vendor defined by you and/or a third-party system.||If you are 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.|
|Account Number||No||100 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 software.|
|1099 Vendor||No||N/A||Denotes whether this Vendor is a 1099 Vendor.||Yes
|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||The zip code or postal code of this Vendor's payment address.|
|Country||No||255 characters||The country of this Vendor's payment address.|
|Primary Email||No||1023 characters||The primary email address for this Vendor.||Must be formatted as email address: e.g. email@example.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. firstname.lastname@example.org|
|Payment Contact Phone||No||40 characters||An alternative phone number for this Vendor to contact regarding payments.|
|Description||No||4000 characters||The description of this Vendor.|
Note: Vendor balances cannot be imported - balances are based off of bills in Bill.com.