Vendor list (VEND)

Import and export files can contain all the information in your Vendor list. The keyword for the Vendor list is VEND.

Column headings

The following table shows the column headings for the Vendor list. Only the NAME column is required.

NAME

(Required) The name of the vendor.

TIMESTAMP

(Export files only) A unique number that identifies the company file from which you exported the Vendor list.

REFNUM

(Export files only) A unique number that identifies an entry in the list.

PRINTAS

The name you would like checks to be made out to. This field allows you to make checks out to a different name than the name that appears on your Vendor list.

ADDR1

The first line of the vendor's address.

ADDR2

The second line of the vendor's address.

ADDR3

The third line of the vendor's address.

ADDR4

The fourth line of the vendor's address.

ADDR5

The fifth line of the vendor's address.

VTYPE

Your classification for the vendor (QuickBooks calls this a "vendor type"). If you import a vendor type that is not on your Vendor Type list, QuickBooks adds the new vendor type to the list.

CONT1

The name of your primary contact with the vendor.

PHONE1

The vendor's phone number.

PHONE2

The vendor's alternate phone number.

FAXNUM

The vendor's FAX number.

NOTE

A short note or phrase you want to associate with the vendor. QuickBooks automatically puts your note in the Memo field of checks you send to the vendor.

TAXID

The vendor's tax identification number.

LIMIT

Your credit limit with the vendor. If you are creating an import file, enter the dollar amount.

TERMS

Your payment terms with the vendor.

NOTEPAD

Your notes about the vendor. If you are creating an import file, the notes appear in the Notepad window for the vendor.

SALUTATION

The vendor's salutation, or title (Mr., Ms., Doctor, etc.).

COMPANYNAME

The name of the vendor's company.

FIRSTNAME

The vendor's first name.

MIDINIT

The vendor's middle initial.

LASTNAME

The vendor's last name.

CUSTFLD1
CUSTFLD2
.
.

CUSTFLD7

The custom field entries for the vendor (you can have up to 7 custom field entries). Custom fields let you track special information about the vendor, such as the vendor's birthday or e-mail address. What you use custom fields for is entirely up to you.

1099

Indicates whether you file a 1099-MISC form for this vendor. If you are creating an import file, enter one of these keywords in the 1099 field:

 

Y

Yes. You file a 1099-MISC form for this vendor.

 

N

No. You do not file a 1099-MISC form for this vendor.

NOTE

The name or number of the account you want to associate with this vendor. QuickBooks requires an account number if you want to set up this vendor as an online payee. The payee uses this number to identify you.