Import Transactions - Profile

Related Topics

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:

Add a File Mapping

File Mapping Overview

ACH Overview

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.

  1. 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.

  2. 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.

  3. Click to display the Import dialog.

  4. 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.

  5. 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.

  6. 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.

  7. 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.