Import Matrix: Clients

Field Name

Key Field

Required

Valid Values

Table Validation

Table

Field Validation

Comments

Downloaded

Yes

No

1099 Form

None

MISC

INT

Form selected must correspond to the appropriate 1099 Form. Check with irs.gov to confirm the appropriate form to use

1099 Box

01

02

03

04

05

06

07

08

10

13

14

Only used if “Is a Vendor” is Yes

Number selected must correspond to the appropriate 1099 Form. Check with irs.gov to confirm the appropriate box to use

Account Manager

Yes

Employee

Full Name (First Name+” “+Last Name)

Account Team

Active

Yes

No

BC Commission Pct

Numeric

Only used if “Get Markup From” is “Client” or “Project”

CC Number

Card Holders Name

Client ID

Yes

Yes - See Comments

If “Is a Billable Client” is Yes than a Client ID is required

Comments

Company Address 1

Company Address 2

Company Address 3

Company City

Company Country

Company Name

Yes

Yes

Company Owner

Yes

Employee

Full Name (First Name+” “+Last Name)

Company Postal Code

Company Source

Yes

Source

Source

Company State

Company Type

Yes

Company Types

Company Type

DBA

Date Converted

Must be a valid date format

Default AP Account

Yes

GL Accounts

GL Account Number

Default Billing Method

Time and              Material,

Fixed Fee,

Retainer

Default Company GL

See Comments

See Comments

Yes

GL Companies

Company ID

If the “Show GL Companies” is selected in the GL Tracking Options then this field will be display and optional.  If the “Require GL Companies” is selected then this field is mandatory and a valid Company ID must entered for all records being imported

Default Expense Account

Yes

GL Accounts

GL Account Number

Default Item Rate Sheet

See Comments

Yes

Item Rate Sheet

Rate Sheet

If “Get Markup   From” is “Item Rate Sheet” then a valid values are blank or a valid Rate Sheet

Default Memo

Default Retainer

See Comments

Yes

Retainer

Title

This field is only used when the Billing Method is “Retainer”.

If this field is not blank, then a valid retainer for the company record must exist

Default Sales GL Account Number

Yes

GL Accounts

GL Account Number

Default Sales Tax ID 1 (Client)

See Comments

Yes

Sales Tax Rates

Sales Tax ID

If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table

Default Sales Tax ID 1 (Vendor)

See Comments

Yes

Sales Tax Rates

Sales Tax ID

If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table

Default Sales Tax ID 2 (Client)

See Comments

Yes

Sales Tax Rates

Sales Tax ID

If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table

Default Sales Tax ID 2 (Vendor)

See Comments

Yes

Sales Tax Rates

Sales Tax ID

If this field is not blank, then a valid Sales Tax ID must exist in the Sales Tax Rates table

Default Terms

See Comments

Yes

Payment Terms

Payment Term

If this field is not blank, then a valid Payment Term must exist in the Payment Terms table

EIN Number

Only used if “Is a Vendor” is Yes

Estimate Template

See Comments

Yes

Estimate Layouts

Name

If this field is not blank, then a valid Name must exist in the Estimate Layouts table

Exp Month

01 thru 12

Exp Year

00 thru 99

(2-digit Year)

Expenses Not Included

Yes

No

See Comments

This field is only used when the Billing Method is Fixed Fee

Fax

Folder

See Comments

Yes

Transaction Preferences

Use Company Folders

If “Use Company Folders” is Yes, then Valid Values for Folder is Blank or an existing Company Folder Name

Get Markup From

Client,

Project,

Item,

Item Rate Sheet,

Task

Get Rate Sheet From

Project,

Project/User,

Service,

Service Rate Sheet,

Task

Hourly Rate

Numeric

Only used if “Get Rate Sheet From” is “Project”

IO Commission Pct

Numeric

Only used if “Get Markup From” is “Client” or “Project”

Invoice Layout

See Comments

Yes

Invoice Layout

Name

If this field is not blank, then a valid Name must exist in the Invoice Layout table

Is a Billable Client

Yes

No

Is a Parent Company

Yes

No

Markup Pct

Numeric

Only used if “Get Markup From” is “Client” or “Project”

Next Project Number

Numeric

Yes

Transaction Preferences

Method

Only used if “Method” in Transaction Preferences is “Client ID + Next Number from Client” or “Prefix + Client ID + Next Number from Client”

On Hand

Numeric

One Invoice Per

Project,

Client,

Parent Client,

Division,

Product,

Campaign

One Line Item Per

Billing Item and Item,

Project then Billing Item and Item,

Project and Task

Overhead

Yes

No

This field is used for Clients that are to be considered “Overhead Clients”

Parent Company

See Comments

Yes

Company

Company Name

This field is only used when “Is a Parent” is Yes

Payment  Address

Default from Mailing Address or a valid Address Name for Company

Yes

Addresses

Address Name

Phone

Yes

Pre Bill Broadcast At

Gross,

Net,

Commission Only

Pre Bill Insertions At

Gross,

Net,

Commission Only

Primary Contact

See Comments

Yes

Contacts

“Full Name” (First Name +” “+Last Name

NOTE: This field should be imported via the Contact import, instead of via the Company import.

If this field is not blank then the “Full Name” of the Contact must exist for the Company

Rate Sheet

See Comments

Yes

Service Rate Sheets

Rate Sheet

If “Get Rate Sheet From” is “Service Rate Sheet” then the valid values are blank or a valid Rate Sheet

Sales Person

Yes

Employee

Full Name (First Name+” “+Last Name)

Terms Days

Numeric

Terms Net

Numeric

Terms Percent

Numeric

Vendor

Yes

No

Vendor Downloaded

Yes

No

Vendor ID

Yes

Required if “Vendor” is Yes

Verifications Code

WebSite