|
|
Customer, Employee and Vendor Accounts (Profiles) |
|
|
|
|
Customer, Employee and Vendor Accounts (Profiles) |
|
|
|
|
|
Customer, Employee and Vendor Accounts (Profiles) |
|
|
|
|
Customer, Employee and Vendor Accounts (Profiles) |
|
|
|
|
|
||
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: --ACH_Name_Internal (Look-up) --ACH_Account --ACH_Routing_ABA
|
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).
Treasury Software Corp. 1999 - 2005. All rights reserved.
Can't find what you need? Contact us
