Before attempting to import data, be sure that the appropriate import file mapping (comma separated or fixed-width) has been set up based on the format and record position of the data in the file being imported. If importing a file in NACHA format, an import mapping is not required. Refer to the following for details on setting up File Mappings:
TIP: Transactional data imported into a profile become a permanent part of that profile's setup. If you wish the changes to be valid for an individual submission of a payment, complete the import during the creation of a payment. Refer to Import Transaction - Payment Help topic for information regarding this option.
Select the ACH
Tab in the navigation bar, choose Maintenance
from the options presented. The ACH:
Profile Summary page is displayed, containing a list of currently
set up profiles.
If you wish to reduce or expand the data that displays in the summary
list, use the Quick Filter
fields located above the summary table.
If setting up a new profile for the purpose
of importing transaction data, click
. The Select Profile
Type page is displayed. Follow the instructions
for adding a profile outlined in the Add an ACH Profile Help Topic.
If importing transaction data into an existing profile, select the
profile into which you wish to import transactions by clicking on it.
Right click the record and select the Modify
option, or click
. The Modify Profile page is
displayed.
Select the Transaction tab.
The Transaction Summary is presented. The
summary contains a listing of all transactions currently in the selected
profile. If the profile does not currently contain
transactions, the list will be empty.
Click
to display the Import dialog.
In the Select File To Import field, enter the path (location) and file name of the file to be imported. You may use the Browse... button to locate the file path and name.
Click
at the right of the Select
Import File Mapping field to display the list of available file mappings.
Click on the appropriate mapping for this file/import.
The mapping setup must match the content/format
structure of the file being imported.
Click OK.
The system will access the designated file, reviewing/validating
the information contained therein. If errors are
discovered during the review/validation, a message will presented identifying
the error, and causing the process to terminate. If
no errors are encountered, the data will be queued for entry into the
profile during the next execution at the bank of the import event. During
this time the status of the profile will be Import.
When the event executes, the transactions will
be written to the profile. After the execution
of the event by your bank, you should return to this profile and by clicking
the transaction tab, review the imported data.
Click the Submit button to accept the imported data into the profile.
Once displayed, the profile is ready for the next
step in the operational process (approval, prenoting [if required], payment
creation, etc.
Click Save to complete the process. Profiles are placed in Pending Approval status. If profiles do not require second level approval (approval by an individual other than the profile creator/editor), you may highlight the appropriate record by right-clicking it and select Approve from the options listed. If profiles required secondary approval, the "edited" profile must be approved by an authorized user (other than the creator/editor), prior to its use in creating payments based on the profile. Refer to the Approve an ACH Profile Help Topic.