There are two methods of importing data into ACH Universal:
1. Basic
The file should have one transaction on each row, with each row having information about the account you are transferring funds to/from.
Overview
There are two methods of importing data into ACH Universal:
1. Basic
The file should have one transaction on each row, with each row having
information about the account you are transferring funds to/from.
Your list can simply be: amount, account number and routing/ABA number. You can import this list at 'Import', 'ACH Transactions'.
OR
2. Customer, Employee and Vendor Accounts
Think of Customer, Employee and Vendor Accounts in a manner similar to
a an accounting system's accounts payable 'Vendor Profile'. A
vendor profile contains the address, and other information needed to create
and mail a paper check.
ACH Universal's Customer, Employee and Vendor Accounts perform the exact
same function, in that they hold the information needed to make payment,
although now, it is an electronic payment.
|
First make a list of your Customers,
Employees and Vendors. Import this list at 'Import', 'Customers, Employees
and Vendors'. At a minimum, import three fields: |
Then prepare your transactions. The system will use the Name field to lookup the account and routing numbers. Import this data at 'Import', 'ACH Transactions'. |
|
|
|
When importing Customers, Employees and Vendors Accounts:
--The names in the 'ACH_Name_Internal (Look-up)' should be unique (do not
repeat any names). Do
not re-import the same Customers, Employees and Vendor account more than
once.
--You can import new lists of Customers, Employees and Vendors whenever
you want.
--ACH Universal verifies the syntax in the 'ACH_Routing_ABA' field. Invalid
records will not be imported.
--The name in 'ACH_Name_Internal (Look-up)' field will also appear in their
bank statement description. To
avoid any third party bank issues, only use letters, numbers, hyphens
and spaces in this field.
When importing ACH Transactions:
--Do not map an ACH_Account or ACH_Routing_ABA field. This
information is already contained in the Customers, Employees and Vendors
Account. If
you map either field, the system will not perform a lookup.
--ACH Transactions which cannot be matched to a Customer, Employee and
Vendor Account will not be imported. Reason:
The transaction
will not have an account or routine/ABA number.
Manual Entry
You can manually add Customers, Employees and Vendors at 'Edit', 'Add/Edit
Customers, Employees and Vendors'.
You can also manually enter an ACH Transaction at 'Edit', 'Add Record(s).
