Spreadsheet import - vendor data

Special information

If you're importing direct deposit information, you'll need to first set up bank information in the application before you begin the import.
If you're importing vendor payment terms information, you may want to first set up payment terms in the application before you begin the import. Otherwise you can add them on the fly during the import.

Select the source file

Select
File
Import
Spreadsheet
.
In the
Source Data
screen, select the appropriate client from the
Client name
field.
Select
Vendors
from the dropdown in the
Data type
field.
In the Import File section, enter the path and file name of the spreadsheet file to import, or select
Browse
to find the file.
Select the worksheet within the spreadsheet file to import.
To have the spreadsheet import wizard skip all data-mapping screens for the additional data types, mark the
Skip data mapping screens
checkbox. The application will skip all data-mapping screens unless it requires input from you.
Select
Next
.

Map spreadsheet columns

If you saved mapping information from a prior import as a mapping template, that template will be included in the dropdown in the
Template
field. If applicable, select the appropriate template.
If the spreadsheet includes column headings or other rows of data that shouldn't be imported, mark the checkbox in the
Omit row
column for that row. The application won't validate or import data in that row.
For each column, select the column heading in the grid, then select the applicable mapping item from the dropdown in the
Column
field.
Mapping item	Additional info	Additional info 2	Required?
ID	None	None	Yes, if the same vendor name is used for more than 1 vendor.
Vendor Name	None	None	Yes
EIN/SSN	None	None	No
Verified	None	None	No
DBA Name	None	None	No
Account	None	None	No
Vendor Type	None	None	No
Address Line 1	None	None	No
Address Line 2	None	None	No
City	None	None	No
State	None	None	No
Zip	None	None	No
County	None	None	No
Country	None	None	No
Phone	Business Car Home Mobile Pager Other	None	No
Fax	None	None	No
Email	None	None	No
Website	None	None	No
Payment Preferences Method	None	None	No
Distribution Amount	None	None	No
Distribution Description	None	None	No
Distribution General Ledger Account	None	None	No
Distribution 1099 Form/Box	None	None	No
Transaction Memo	None	None	No
1099 Form/Box	None	None	No
Accounts Payable General Ledger Account	None	None	Yes, for AP clients
Accounts Payable Beginning Balance Amount	None	None	No
Accounts Payable Beginning Balance Reference	None	None	No
Accounts Payable Beginning Balance PO#	None	None	No
Accounts Payable Beginning Balance AP Account	None	None	Yes, if Accounts Payable Beginning Balance Amount is mapped.
Accounts Payable Beginning Balance Date	None	None	Yes, if Accounts Payable Beginning Balance Amount is mapped.
Accounts Payable Payment Term	None	None	No
Accounts Payable PO#	None	None	No
Accounts Payable Memo	None	None	No
Direct Deposit Allocation	Routing Number Account Number Account Type Amount Percent Status	None	Yes, if Direct Deposit Allocation is mapped Yes, if Direct Deposit Allocation is mapped Yes, if Direct Deposit Allocation is mapped If Direct Deposit Allocation is mapped, EITHER Amount OR Percent (but not both) must be mapped If Direct Deposit Allocation is mapped, EITHER Amount OR Percent (but not both) must be mapped No
note
To import vendor GL account distributions to the
Setup
Vendors
Distributions tab
, you'll need to map columns for at least the following items:
ID
Vendor Name
State
Distribution General Ledger Account
After you've mapped all applicable columns, select
Next
.
The application validates the spreadsheet data. If any issues are found, the invalid items are highlighted. If necessary, correct the data then select
Next
.

Map additional data types

Clear mapping
: Mark this checkbox to clear any changes made in the current
Data Mapping
screen.
Show all mappings
: Mark this checkbox to display all mapped and non-mapped items in the grid. If you clear this checkbox, the grid displays only those items that are un-mapped and need attention.
Reset default to
: If the application encounters a blank field in the spreadsheet, and that blank field is mapped to a required field, the application enters
Do not import
in that field by default. To change the default information to
Add as is
or to a blank field for any of these fields that you haven't changed, select the desired default value from this field.

Data-mapping screens

Bank Routing number
: For each row in the grid, select the corresponding bank and routing number. The dropdown includes banks that were set up in the
Banks
screen.
Chart of Accounts
: For each row in the grid, select the corresponding GL account number and description. The dropdown includes all accounts that were set up in the
Chart of Accounts
screen. If a corresponding account isn't listed, select
Add as is
then enter a valid account number and class code to add the account, or select
Do not import
to skip the import of data for that account.
Vendors
: For each row in the grid, select the corresponding vendor. The dropdown includes all vendors that were set up in the
Vendors
screen. If a corresponding vendor isn't listed, select
Add as is
to add the vendor record, or select
Do not import
to skip the import of data for that vendor.
1099 items
: For each row in the grid, select the corresponding 1099 item. The dropdown includes all supported 1099 forms.

Review import diagnostics

Sample spreadsheet file