Spreadsheet imports — AP transactions

Special information

Source Data screen

Select
File
,
Import
, then
Spreadsheet
.
In the
Source Data
screen, select the
Client name
.
Select
Accounts Payable Transactions
from the
Data type
dropdown.
In the Import File section, enter the path and file name of the spreadsheet or use
Browse
.
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.
note
The application will skip all data-mapping screens unless it needs you to make a decision.
Select
Next
.

Column Mapping screen

You can choose a
Template
if you saved mapping information from a prior import as a mapping template.
If the spreadsheet includes column headings or other rows of data that you don't want to import, mark the checkbox in the
Omit row
column for that row.
For each column, select the column heading then the mapping item from
Column <x>
.
Mapping item	Required
Transaction Type	Yes
Bank Account	Yes, for AP checks and AP payments.
Journal	No
Reference	Yes, for AP checks and AP payments.
Date	No
Due Date	No
Vendor ID	No
Vendor Name	Yes
Payment Term	No
PO Number	No
Total Amount	You'll need to map at least 1 type of amount (Total, Distribution, or Debit Distribution and Credit Distribution).
Accounts Payable General Ledger Account	Yes, for Payables and Credit memos.
Distribution General Ledger Account	No
Distribution Description	No
Debit Distribution Amount	You'll need to map at least 1 type of amount (Total, Distribution, or Debit Distribution and Credit Distribution).
Credit Distribution Amount	You'll need to map at least 1 type of amount (Total, Distribution, or Debit Distribution and Credit Distribution).
Distribution Amount	You'll need to map at least 1 type of amount (Total, Distribution, or Debit Distribution and Credit Distribution).
1099 Form/Box	No
Memo	No
Status	No
After you've mapped all the columns, select
Next
.
note
The application validates the spreadsheet data and highlights any invalid items.
Correct the data if needed, then select
Next
.

Map additional data types

Clear Mapping
Use this 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 not mapped and need attention.
Reset default to
If there's a blank cell in the spreadsheet mapped to a required field, the application enters
Add as is
in that field by default. To change the default information to
Do not import
or to a blank field for any of these fields that you have
not
changed, select the default value.

Data mapping screens

Bank Accounts
:
For each row, select the bank account in the application.
You can choose from accounts for the client in the
Bank Accounts
screen.
To import the AP transactions for this bank account as cleared (for reconciliation purposes), mark the checkbox in the
Cleared
column.
Chart of Accounts
:
For each row, choose the GL account number from the application.
The dropdown list includes accounts from the
Chart of Accounts screen
.
If an account isn't listed, select
Add as is
, then enter a valid account number and class code. Alternatively select
Do not import
to skip this account.
Vendors
:
For each row, select the vendor from the application.
The dropdown list includes vendors from the
Vendors
screen.
If the vendor isn't listed, you can add the vendor by selecting
Add as is
.
1099
:
For each row, select the 1099 item. The dropdown includes all supported 1099 forms.
Payment Terms
:
For each row, select the payment term from the application.
The dropdown list includes payment terms from the
Payment Terms
screen.
If a payment term isn't listed, select
Add as is
, then enter a payment term ID and due date type. Alternatively, select
Do not import
to skip the import of data for that payment term.

Review import diagnostics on the Data Analysis screen

Sample spreadsheet file