Vendor Import Template Field Reference

External ID

No

Enter the unique identifier for the record from your original system.

Vendor

Yes

Enter a code of up to 8 alphanumeric digits to identify the vendor.

Vendor Name

Yes

Enter the name of the vendor.

One Time Vendor

Yes

Indicate whether or not the vendor is a one-time vendor.

• Yes/No

• Y/N

• True/False

• On/Off

Sort Name

Yes

Enter the text to use for sorting vendor names in lookup lists and reports.

Web Site

No

Enter the address of the Web site for the vendor.

E-mail Address

No

Enter the vendor's e-mail address.

Phone Number

No

Enter the phone number for the vendor.

Fax

No

Enter the fax number for the vendor.

Payment Terms

Yes

Enter the code for the default payment terms to be used when you create an invoice for the vendor.

Sales Tax Authority

Yes

Enter the code of the default sales tax authority to be used when you create an invoice or purchase order for this vendor.

Default Invoice Status

Yes

Indicate the default status to be used when entering invoices for this vendor.

• Open: An invoice with a status of Open can be selected for payment.

• Payment Hold: An invoice with a status of Payment Hold cannot be selected for payment. To save an invoice with this status, you must enter a default reason for the payment hold in the Default Hold Reason field.

• Pending Approval: An invoice with a status of Pending Approval cannot be selected for payment until the status is changed to Open, Pay, or Manual Payment. To save an invoice with this status, the invoice must conform to the settings on the Accounts Payable Settings screen.

• Pay: An invoice with a status of Pay will be paid the next time checks are generated.

• Manual Payment: An invoice with a status of Manual Payment cannot be selected for payment. You must pay the invoice manually, typically by cash or credit card.

Default Hold Reason

Conditional

If the default invoice status is Payment Hold, enter a default reason for holding the payment.

Default Transaction Type

No

Indicate the default transaction type for distribution lines on vendor invoices. All distribution lines on vendor invoices for this vendor will default to this transaction type. If needed, you can change the transaction type on individual lines in an invoice.

• General Ledger Only

• Project Cost

• Equipment Cost

Default Cost Type

No

Enter the code of the default cost type to be used on invoices for the vendor.

Default Cost Account

No

Enter the code of the default cost account to be used on invoices for the vendor.

Status

Yes

Enter the status of the vendor.

• Active: Vendor is available for use and appears in lookup lists.

• Inactive: Vendor is not available for use and does not appear in lookup lists on other screens.

Memo

No

Enter any comments or notes about the vendor.

Can Be Subcontractor

No

Indicate whether or not the vendor can be used as a subcontractor. Valid values:

• Yes/No

• Y/N

• True/False

• On/Off

If you want to use the vendor as a subcontractor, specify related settings on the Compliance Worksheet.

Use For Estimating

No

Indicate whether or not the vendor can be used in invitations to bid. Valid values:

• Yes/No

• Y/N

• True/False

• On/Off

1099 Type

Yes

Enter the default report type to be used on invoices for this vendor. Valid values:

• None

• Rents: 1099-MISC

• Non Employee Compensation: 1099-NEC

• Interest Income: 1099-INT

• Construction Subcontractor Payments – T5018

1099 ID Number

Conditional

If you entered anything other than None in the 1099 Type field, enter the taxpayer identification number to be used on the Form 1099 or T5018 slip for this vendor.

In the United States:

This is typically a federal identification number or a Social Security number.

In Canada:

This can be a business number, business account number, Social Insurance Number, individual tax number, or temporary tax number.

1099 Name 1

Conditional

If you entered anything other than None in the 1099 Type field, enter the text that will appear on the first line of the Form 1099 or T5018 slip for this vendor.

1099 Name 2

No

Enter the text that will appear on the second line of the Form 1099 or T5018 slip for this vendor.

Main Address Street 1

No

Enter the first line of the street portion of the vendor's main address.

Main Address Street 2

No

Enter the second line of the street portion of the vendor's main address.

Main Address City

No

Enter the city of the vendor's main address.

Main Address State

No

Main Address Zip

No

Main Address Country

No

Enter the country of the vendor's main address.

Purchase Order Entry Message

No

Enter text to be used as the default print message for purchase orders for this vendor. This text becomes the default value in the Print Message field on the Enter Purchase Order screen when you create a purchase order for this vendor.

One Check Per Invoice

Yes

Indicate whether or not you want to create one check for each invoice for this vendor.

• Yes/No

• Y/N

• True/False

• On/Off

Check Reference Indicator

Yes

Enter the check reference indicator to be used for this vendor. The check reference indicator appears on the stub for the vendor payment check.

• Project Name: Checks to this vendor include the project names from the distribution lines on the invoices. Distribution lines for a single project are rolled into a single line for each invoice.

• Project Name & Retention Held: Checks to this vendor include the project names from the distribution lines and the amount of open retainage on the invoices.

• Project: Checks to this vendor include the project codes from the distribution lines on the invoices. All distribution lines for a single project are rolled into a single line for each invoice.

• Invoice Description: Checks to this vendor include descriptions from the Invoice Description column on the General tab of the Enter Vendor Invoice screen.

• Invoice Distribution Description: Depending on the type of invoice, checks to this vendor include the description from the Description field the Purchase Order Line Item tab, Purchase Order Lump Sum tab, or the Distribution tab on the Enter Vendor Invoice screen.

• As Per Subcontract: Checks to this vendor will be for a single subcontract and will include the total subcontract amount, the billed-though date, the retention amount, the paid-through date, and the net amount of the check.

• Purchase Order: Checks to this vendor include the purchase order numbers for each invoice.

• Purchase Order Line: Checks to this vendor include the purchase order numbers and lines for each distribution.

• Purchase Order Item: Checks to this vendor include the item number for each distribution.

• Purchase Order Item Name: Checks to this vendor include the item name for each distribution.

• Purchase Order Vendor Item Number: Checks to this vendor include the vendor's item number for each distribution.

• Vendor Check Comment: Checks to this vendor include the Check Comment field on this tab.

• As Per Statement: Checks to this vendor include the words "As Per Statement".

Only Print Details on Supplement Stub

Yes

Indicate whether or not check details should be printed on a supplemental stub.

• Yes/No

• Y/N

• True/False

• On/Off

Check Stub Comment

No

Enter a comment that will print on all checks if the Check Reference Indicator value is set to Vendor Check Comment.

Vendor

Yes

Enter a code of up to 8 alphanumeric characters to identify the vendor.

Address Type

Yes

Enter the address type.

• Remit To

• Purchase Address

Street 1

No

Enter the first line of the street portion of the address.

Street 2

No

Enter the second line of the street portion of the address.

City

No

Enter the city for the address.

State

No

Enter the state () or province () of the address.

Zip

No

Enter the ZIP code () or postal code () of the address.

Vendor

Yes

Enter a code of up to 8 alphanumeric characters to identify the vendor.

Contact Type

Yes

Enter the code for the contact type for the contact.

Vendor

Yes

Enter a code of up to 8 alphanumeric characters to identify the vendor.

Tax Authority

Yes

Enter the code for a tax authority for the vendor.

Nexus

No

Indicate whether or not the tax authority is a nexus tax authority for the vendor (and therefore will charge sales tax).

• Yes/No

• Y/N

• True/False

• On/Off

Vendor

Yes

Enter a code of up to 8 alphanumeric characters to identify the vendor.

Company

Yes

Enter the code for the company.

Workers Comp Expiration Date

No

Enter the expiration date for the workers' compensation insurance policy when the vendor is a subcontractor.

General Liability Expiration Date

No

Enter the expiration date for the general liability insurance policy when the vendor is a subcontractor.

Vendor

Yes

Enter the code of the vendor.

Company

Yes

Enter the code of the company for the subcontract.

Project

No

Enter the code of the project for the subcontract.

Subcontract

Yes

Enter the code of the subcontract.